public async Task <ActionResult <DocumentariesResponseModel> > GetAllDocumentaries()
{
DocumentariesResponseModel documentariesResponseModel = new DocumentariesResponseModel();
documentariesResponseModel = await Task.Run(() => _lessonPlannerRepository.GetAllDocumentaries());
return(Ok(documentariesResponseModel));
}
public DocumentariesResponseModel GetAllDocumentaries()
{
DocumentariesResponseModel documentariesResponseModel = new DocumentariesResponseModel();
documentariesResponseModel.Data = new List <DocumentariesDto>();
DataTable dataTable = new DataTable();
SqlConnection conn = new SqlConnection(DbHelper.DbConnectionString);
try
{
SqlCommand command = new SqlCommand(@"dbo.uspGetAllDocumentaries", conn);
command.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
dataAdapter.Fill(dataTable);
documentariesResponseModel.Message = "Success";
documentariesResponseModel.StatusCode = 200;
foreach (DataRow row in dataTable.Rows)
{
DocumentariesDto documentaries = new DocumentariesDto();
documentaries.DocumentaryID = row["DocumentaryID"] != DBNull.Value ? Convert.ToInt64(row["DocumentaryID"].ToString()) : 0;
documentaries.MainTopicID = row["MainTopicID"] != DBNull.Value ? Convert.ToInt64(row["MainTopicID"].ToString()) : 0;
documentaries.MainTopicNumber = row["MainTopicNumber"] != DBNull.Value ? Convert.ToString(row["MainTopicNumber"]) : string.Empty;
documentaries.DocumentaryDescription = row["DocumentaryDescription"] != DBNull.Value ? Convert.ToString(row["DocumentaryDescription"].ToString()) : string.Empty;
documentariesResponseModel.Data.Add(documentaries);
}
}
catch (Exception ex)
{
documentariesResponseModel.StatusCode = 500;
documentariesResponseModel.Message = ex.Message;
documentariesResponseModel.Data = null;
}
finally
{
dataTable.Clear();
dataTable = null;
conn.Close();
}
return(documentariesResponseModel);
}
