public async Task <ActionResult <GradeResponseModel> > GetAllGrades()
{
GradeResponseModel gradeResponseModel = new GradeResponseModel();
gradeResponseModel = await Task.Run(() => _gradeRepository.GetAllGrades());
return(Ok(gradeResponseModel));
}
public GradeResponseModel GetAllGrades()
{
GradeResponseModel gradeResponseModel = new GradeResponseModel();
gradeResponseModel.Data = new List <GradeDto>();
DataTable dataTable = new DataTable();
SqlConnection conn = new SqlConnection(DbHelper.DbConnectionString);
try
{
SqlCommand command = new SqlCommand(@"dbo.uspGetAllGrades", conn);
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
dataAdapter.Fill(dataTable);
gradeResponseModel.Message = "Success";
gradeResponseModel.StatusCode = 200;
foreach (DataRow row in dataTable.Rows)
{
GradeDto gradeDto = new GradeDto();
gradeDto.GradeID = row["GradeID"] != DBNull.Value ? Convert.ToInt32(row["GradeID"].ToString()) : 0;
gradeDto.GradeName = row["GradeName"] != DBNull.Value ? Convert.ToString(row["GradeName"]) : string.Empty;
gradeResponseModel.Data.Add(gradeDto);
}
}
catch (Exception ex)
{
gradeResponseModel.StatusCode = 500;
gradeResponseModel.Message = ex.Message;
gradeResponseModel.Data = null;
}
finally
{
dataTable.Clear();
dataTable = null;
conn.Close();
}
return(gradeResponseModel);
}
