public async Task <IActionResult> PostCollege([FromBody] CollegeDTO collegeDto)
{
var college = new College()
{
Name = collegeDto.Name
};
_context.Colleges.Add(college);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (CollegeExists(college.ID))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(Ok());
}
public async Task <IActionResult> PutCollege([FromRoute] int id, [FromBody] CollegeDTO collegeDto)
{
if (id != collegeDto.ID)
{
return(BadRequest());
}
var college = await _context.Colleges.FirstOrDefaultAsync(c => c.ID == collegeDto.ID);
college.Name = collegeDto.Name;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CollegeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok());
}
public static List <CollegeDTO> GetListColloge()
{
string query = string.Format("EXEC dbo.USP_GetListCollege");
DataTable dataTable = DataProvider.ExcuteQuery(query);
List <CollegeDTO> listCollege = new List <CollegeDTO>();
foreach (DataRow item in dataTable.Rows)
{
CollegeDTO temp = new CollegeDTO(item);
listCollege.Add(temp);
}
return(listCollege);
}
public IActionResult GetCollegeByCode([FromBody] CollegeDTO collegeDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var watch = System.Diagnostics.Stopwatch.StartNew();
var rs = this._collegeService.findScoreByCollegeCode(collegeDTO.collegeCode, collegeDTO.years);
watch.Stop();
var took = watch.ElapsedMilliseconds;
if (rs == null)
{
return(NotFound(new JsonResponse(took, MessagesResponse.MESSAGE_NOT_FOUND, null)));
}
return(Ok(new JsonResponse(took, null, rs)));
}
