CREATE PROCEDURE [dbo].[DELETESTUDENT] (
     @studentid        varchar(6)

)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from

SET NOCOUNT ON;
		DELETE
		FROM STUDENT
		WHERE upper(STUDENT_ID) = UPPER( @studentid)
		

    
END
go




CREATE PROCEDURE [dbo].[GetByStudentIDS] (
     @studentid       varchar(6)
)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
	--updated by CAS 2/13/2023 1:52PM
    SET NOCOUNT ON;
    
    SELECT *
    FROM STUDENT
    WHERE upper(STUDENT_ID) = upper(@studentid)
    
END
go


CREATE PROCEDURE [dbo].[UPDATESTUDENTBYID]
(
 @student_id varchar(6),
 @fname varchar (25),
 @lname varchar(25),
 @balance decimal(7,2),
 @gender char(6),
 @credits decimal(5,2),
 @state	char(2),
 @DOB	date
)

as
begin

    update STUDENT 
   set FNAME = @fname, 
   LNAME = @lname, 
   ACCT_BAL = @balance, 
   DOB  = @DOB, 
   GENDER = @gender,
   TOTALCREDITS = @credits,
   STU_STATE = @state
   where STUDENT_ID = @student_id
   end
go

CREATE PROCEDURE SEARCHSTUDENTS (
     @fname            varchar(6),
	 @lname			   varchar(25)	

)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from

SET NOCOUNT ON;
       --return same # of fields used in datagrid
		SELECT  student_id, fname, lname,HOME_PHONE  
		FROM STUDENT
		WHERE upper(FNAME) like '%' + upper( @fname   ) + '%' or (FNAME = '')
		or upper(lname) like '%' + upper( @lname   ) + '%' or (lname = '')
	

    
END
go