public async Task <ActionResult <LessonPlannerResponseModel> > GetAllLessonPlannersByGradeIDandSubjectID(long gradeID, long subjectID)
{
LessonPlannerResponseModel lessonPlannerResponseModel = new LessonPlannerResponseModel();
//lessonPlannerResponseModel = await Task.Run(() => _lessonPlannerRepository.GetAllLessonPlanners());
lessonPlannerResponseModel = await Task.Run(() => _lessonPlannerRepository.GetAllLessonPlannersByGradeIDandSubjectID(gradeID, subjectID));
return(Ok(lessonPlannerResponseModel));
}
public async Task <ActionResult <LessonPlannerResponseModel> > GetAllLessonPlanners()
{
LessonPlannerResponseModel lessonPlannerResponseModel = new LessonPlannerResponseModel();
//lessonPlannerResponseModel = await Task.Run(() => _lessonPlannerRepository.GetAllLessonPlanners());
lessonPlannerResponseModel = await Task.Run(() => _lessonPlannerRepository.GetAllLessonPlanners());
return(Ok(lessonPlannerResponseModel));
}
public LessonPlannerResponseModel GetAllLessonPlannersByGradeIDandSubjectID(long gradeID, long subjectID)
{
LessonPlannerResponseModel lessonPlannerResponseModel = new LessonPlannerResponseModel();
lessonPlannerResponseModel.Data = new List <LessonPlannerDto>();
DataTable dataTable = new DataTable();
SqlConnection conn = new SqlConnection(DbHelper.DbConnectionString);
try
{
SqlCommand command = new SqlCommand(@"dbo.uspGetAllLessonPlannersByGradeIDandSubjectID", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@GradeID", gradeID);
command.Parameters.AddWithValue("@SubjectID", subjectID);
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
dataAdapter.Fill(dataTable);
lessonPlannerResponseModel.Message = "Success";
lessonPlannerResponseModel.StatusCode = 200;
foreach (DataRow row in dataTable.Rows)
{
LessonPlannerDto LessonPlannerDto = new LessonPlannerDto();
LessonPlannerDto.LessonPlannerID = row["LessonPlannerID"] != DBNull.Value ? Convert.ToInt64(row["LessonPlannerID"].ToString()) : 0;
LessonPlannerDto.GradeID = row["GradeID"] != DBNull.Value ? Convert.ToInt64(row["GradeID"].ToString()) : 0;
LessonPlannerDto.GradeName = row["GradeName"] != DBNull.Value ? Convert.ToString(row["GradeName"]) : string.Empty;
LessonPlannerDto.SubjectID = row["SubjectID"] != DBNull.Value ? Convert.ToInt64(row["SubjectID"].ToString()) : 0;
LessonPlannerDto.SubjectName = row["SubjectName"] != DBNull.Value ? Convert.ToString(row["SubjectName"]) : string.Empty;
LessonPlannerDto.MainTopicID = row["MainTopicID"] != DBNull.Value ? Convert.ToInt64(row["MainTopicID"].ToString()) : 0;
LessonPlannerDto.MainTopicNumber = row["MainTopicNumber"] != DBNull.Value ? Convert.ToString(row["MainTopicNumber"]) : string.Empty;
LessonPlannerDto.TitleMainTopic = row["MainTopicTitle"] != DBNull.Value ? Convert.ToString(row["MainTopicTitle"]) : string.Empty;
LessonPlannerDto.Introduction = row["Introduction"] != DBNull.Value ? Convert.ToString(row["Introduction"]) : string.Empty;
LessonPlannerDto.Objectives = row["Objectives"] != DBNull.Value ? Convert.ToString(row["Objectives"]) : string.Empty;
LessonPlannerDto.Material = row["Material"] != DBNull.Value ? Convert.ToString(row["Material"]) : string.Empty;
lessonPlannerResponseModel.Data.Add(LessonPlannerDto);
}
}
catch (Exception ex)
{
lessonPlannerResponseModel.StatusCode = 500;
lessonPlannerResponseModel.Message = ex.Message;
lessonPlannerResponseModel.Data = null;
}
finally
{
dataTable.Clear();
dataTable = null;
conn.Close();
}
return(lessonPlannerResponseModel);
}
