aleedca / ProyectoSoftware

https://aleedca.github.io/ProyectoSoftware/

0 stars 0 forks source link

CRUD cursos #16

Open luisfmplus opened 1 month ago

luisfmplus commented 1 month ago

also a list form

luisfmplus commented 3 weeks ago

InloTEC_SP_Courses_Details_List

Procedure to list all of the Course_Details

Parameters:

Returns

returns a list of all the Course details

Id (int), Location (string), Teacher (string), Course (string), Group (string) [it is a csv of the groups name's], IdSchedule (int), Schedule (string), Modality (string), StartDate (date), EndDate (date), Notes (string)

Pendiente

Filtros

luisfmplus commented 3 weeks ago

InloTEC_SP_Courses_Details_Add

Procedure to add a Course_Details

Parameters:

@IN_IdLocation BIGINT,
@IN_IdTeachers BIGINT,
@IN_IdCourses BIGINT,
@IN_IdSchedule BIGINT,
@IN_IdModality BIGINT,
@IN_IdGroup BIGINT,
@IN_startDate DATE,
@IN_endDate DATE,
@IN_notes NVARCHAR(512) = NULL

Returns

error mesage
1 if successfull

luisfmplus commented 3 weeks ago

InloTEC_SP_Courses_Details_Get

Procedure to get a Course_Details

Parameters:

@IN_IdCourses_Details BIGINT

Returns

error message
Id (int), Location (string), Teacher (string), Course (string), Group (string) [it is a csv of the groups name's], IdSchedule (int), Schedule (string), Modality (string), StartDate (date), EndDate (date), Notes (string)

luisfmplus commented 3 weeks ago

InloTEC_SP_Courses_Details_Delete

Procedure to delete a Course_Details

Parameters:

@IN_IdCourses_Details BIGINT

Returns

error mesage
1 if successfull

luisfmplus commented 3 weeks ago

InloTEC_SP_Courses_List

Procedure to list all of the Course

Parameters:

Returns

returns a list of all the Course name's

Id (int), Name (string)

luisfmplus commented 3 weeks ago

InloTEC_SP_Courses_Get

Procedure to get a Course name

Parameters:

@IN_IdCourses BIGINT

Returns

error message
Id (int), Name (string)