public CityAreaDTO Create(CityAreaCreateDTO modelToCreate)
{
try
{
int newID = UOW.CityAreaRepo.Create(modelToCreate);
var createResult = UOW.CityAreaRepo.GetByID(newID);
UOW.SaveChanges();
return(createResult);
}
catch (Exception ex)
{
UOW.RollbackChanges();
throw ex;
}
}
public int Create(CityAreaCreateDTO entityToCreate)
{
try
{
string query = @"
INSERT INTO CityAreas(CityAreaCode, CityAreaName, CityID)
VALUES (@CityAreaCode, @CityAreaName, @CityID)
SELECT SCOPE_IDENTITY()";
var queryParameters = new DynamicParameters();
queryParameters.Add("@CityAreaCode", entityToCreate.CityAreaCode);
queryParameters.Add("@CityAreaName", entityToCreate.CityAreaName);
queryParameters.Add("@CityID", entityToCreate.CityID);
return(Connection.QueryFirst <int>(query, queryParameters, CurrentTrans));
}
catch (Exception ex)
{
throw SqlExceptionHandler.HandleSqlException(ex) ?? ex;
}
}
public ActionResult <CityAreaDTO> Create([FromBody] CityAreaCreateDTO userInput)
{
try { return(_cityAreaManager.Create(userInput)); }
catch (BaseCustomException ex) { return(BadRequest(ex.Message)); }
}
public CityAreaDTO Create(CityAreaCreateDTO createModel)
{
return(_cityAreaService.Create(createModel));
}
