public List <ProgrammingListDto> getCurrentCoursesByTeacherID(Int32 schoolID, Int32 teacherID, Boolean active, Boolean isCurrentPeriod)
{
SqlConnection conn = null;
SqlDataReader reader;
String sql;
SqlCommand command;
SqlParameter prmschoolID = null;
SqlParameter prmisCurrentPeriod = null;
SqlParameter prmteacherID = null;
SqlParameter prmactive = null;
try
{
ProgrammingListDto programming;
List <ProgrammingListDto> lstProgrammings;
conn = new SqlConnection(Functions.GetConnectionString());
sql = "GetCurrentCourses";
command = new SqlCommand(sql, conn);
command.CommandType = CommandType.StoredProcedure;
prmschoolID = new SqlParameter();
prmschoolID.ParameterName = "@schoolID";
prmschoolID.SqlDbType = SqlDbType.Int;
prmschoolID.Value = schoolID;
command.Parameters.Add(prmschoolID);
prmisCurrentPeriod = new SqlParameter();
prmisCurrentPeriod.ParameterName = "@isCurrentPeriod";
prmisCurrentPeriod.SqlDbType = SqlDbType.Bit;
prmisCurrentPeriod.Value = isCurrentPeriod;
command.Parameters.Add(prmisCurrentPeriod);
prmteacherID = new SqlParameter();
prmteacherID.ParameterName = "@teacherID";
prmteacherID.SqlDbType = SqlDbType.Int;
prmteacherID.Value = teacherID;
command.Parameters.Add(prmteacherID);
prmactive = new SqlParameter();
prmactive.ParameterName = "@active";
prmactive.SqlDbType = SqlDbType.Bit;
prmactive.Value = active;
command.Parameters.Add(prmactive);
command.Connection.Open();
reader = command.ExecuteReader();
lstProgrammings = new List <ProgrammingListDto>();
while (reader.Read())
{
programming = new ProgrammingListDto();
programming.programmingID = reader.GetInt32(reader.GetOrdinal("programmingID"));
programming.evaluationFormulaID = reader.GetInt32(reader.GetOrdinal("evaluationFormulaID"));
programming.career_name = reader.GetString(reader.GetOrdinal("career_name"));
programming.schoolID = schoolID;
programming.classroom_name = reader.GetString(reader.GetOrdinal("classroom_name"));
programming.course_name = reader.GetString(reader.GetOrdinal("course_name"));
programming.course_credits = reader.GetInt32(reader.GetOrdinal("course_credits"));
programming.grade = reader.GetInt32(reader.GetOrdinal("grade"));
programming.evaluationPeriod_name = reader.GetString(reader.GetOrdinal("evaluationPeriod_name"));
programming.section_name = reader.GetInt32(reader.GetOrdinal("grade")) + "" + reader.GetString(reader.GetOrdinal("section_name"));
programming.turn_name = reader.GetString(reader.GetOrdinal("turn_name"));
programming.courseID = reader.GetInt32(reader.GetOrdinal("courseID"));
programming.schoolYearID = reader.GetInt32(reader.GetOrdinal("schoolYearID"));
programming.schoolID = reader.GetInt32(reader.GetOrdinal("schoolID"));
programming.careerID = reader.GetInt32(reader.GetOrdinal("careerID"));
programming.sectionID = reader.GetInt32(reader.GetOrdinal("sectionID"));
programming.turnID = reader.GetInt32(reader.GetOrdinal("turnID"));
programming.periodTypeID = reader.GetInt32(reader.GetOrdinal("periodTypeID"));
programming.evaluationPeriodID = reader.GetInt32(reader.GetOrdinal("evaluationPeriodID"));
programming.headquartersID = reader.GetInt32(reader.GetOrdinal("headquartersID"));
programming.grade = reader.GetInt32(reader.GetOrdinal("grade"));
programming.teacherID = teacherID;
lstProgrammings.Add(programming);
}
command.Connection.Close();
conn.Dispose();
return(lstProgrammings);
}
catch (Exception ex)
{
conn.Dispose();
throw ex;
}
}
public Object insertNotes([FromBody] ProgrammingListDto requestProgramming)
{
return(this.teacherApplicationService.insertNotes(requestProgramming));
}
