public CityAreaDTO Update(CityAreaDTO updatedRecord)
{
try
{
string query = @"
UPDATE CityAreas
SET CityAreaCode = @CityAreaCode
,CityAreaName = @CityAreaName
,CityID = @CityID
WHERE CityAreaID = @CityAreaID";
var queryParameters = new DynamicParameters();
queryParameters.Add("@CityID", updatedRecord.CityID);
queryParameters.Add("@CityAreaID", updatedRecord.CityAreaID);
queryParameters.Add("@CityAreaCode", updatedRecord.CityAreaCode);
queryParameters.Add("@CityAreaName", updatedRecord.CityAreaName);
int rowsUpdated = Connection.Execute(query, queryParameters, CurrentTrans);
return((rowsUpdated > 0) ? GetByID(updatedRecord.CityAreaID) : throw noRecordEX);
}
catch (Exception ex)
{
throw SqlExceptionHandler.HandleSqlException(ex) ?? ex;
}
}
public CityAreaDTO Update(CityAreaDTO newModel)
{
try
{
CityAreaDTO returnModel = UOW.CityAreaRepo.Update(newModel);
UOW.SaveChanges();
return(returnModel);
}
catch (Exception ex)
{
UOW.RollbackChanges();
throw ex;
}
}
public ActionResult <CityAreaDTO> Update([FromBody] CityAreaDTO newModel)
{
try { return(_cityAreaManager.Update(newModel)); }
catch (BaseCustomException ex) { return(BadRequest(ex.Message)); }
}
public CityAreaDTO Update(CityAreaDTO newModel)
{
return(_cityAreaService.Update(newModel));
}
