public OrderDTO Update(UpdatedOrderDTO updatedRecord)
{
try
{
string query = @"
UPDATE OrderHeaders
SET CustomerID = @CustomerID,
AddressID = @AddressID,
OrderDate = @OrderDate,
DeliveryDate = @DeliveryDate
WHERE OrderHeaderID = @OrderID";
var queryParameters = new DynamicParameters();
queryParameters.Add("@CustomerID", updatedRecord.CustomerID);
queryParameters.Add("@AddressID", updatedRecord.AddressID);
queryParameters.Add("@OrderDate", updatedRecord.OrderDate);
queryParameters.Add("@DeliveryDate", updatedRecord.DeliveryDate);
queryParameters.Add("@OrderID", updatedRecord.OrderID);
int rowsUpdated = Connection.Execute(query, queryParameters, CurrentTrans);
return((rowsUpdated > 0) ? GetByID(updatedRecord.OrderID) : throw noRecordEX);
}
catch (Exception ex)
{
throw SqlExceptionHandler.HandleSqlException(ex) ?? ex;
}
}
public OrderDetailedDTO Update(UpdatedOrderDTO updatedRecord)
{
try
{
var updateResult = UOW.OrderRepo.Update(updatedRecord);
UOW.SaveChanges();
return(GetByID(updateResult.OrderID));
}
catch (Exception ex)
{
UOW.RollbackChanges();
throw ex;
}
}
public ActionResult <OrderDetailedDTO> Update(UpdatedOrderDTO updatedRecord)
{
try { return(_orderManager.Update(updatedRecord)); }
catch (BaseCustomException ex) { return(BadRequest(ex.Message)); }
}
public OrderDetailedDTO Update(UpdatedOrderDTO updatedRecord)
{
return(_orderService.Update(updatedRecord));
}
