CRUD de Profesores

[luisfmplus]

InloTEC_SP_Teachers_Add

• Procedure to add a teacher with duplicated email validation.

Parameters:

• @IN_name NVARCHAR(128),
• @IN_email NVARCHAR(128)

Returns

• Error message
• 1 if succesfull

[luisfmplus]

InloTEC_SP_Teachers_Delete

• Procedure to delete a teacher

Parameters:

• @IN_email NVARCHAR(128)

Returns

• Error message
• 1 if succesfull

[luisfmplus]

InloTEC_SP_Teachers_Edit

• Procedure to edit a teacher

Parameters:

• @IN_oldEmail NVARCHAR(128),
• @IN_newName NVARCHAR(128),
• @IN_newEmail NVARCHAR(128)

Returns

• Error message
• 1 if succesfull

[luisfmplus]

InloTEC_SP_Teachers_List

• Procedure to list all teacher

Parameters:

Returns

returns a list of all the teachers

• Id(int), Name (string) , Email (string)

[luisfmplus]

InloTEC_SP_Teachers_Get

• Procedure to get a teacher

Parameters:

• @IN_IdTeachers BIGINT

Returns

• error message
• Id(int), Name (string) , Email (string)