public virtual ActionResult Edit(int?dispatchID)
{
try
{
TempData["sDispatch"] = from x in PaymentsMethodsExtensions.typedispatchDisplay()
orderby x.Key
select new SelectListItem()
{
Text = x.Value,
Value = x.Key
};
DispatchTable dispatch = new DispatchTable();
dispatch = Dispatch.DispatchById(Convert.ToInt32(dispatchID));
dispatch.ProductsQuery = DispatchItems.DispatchItemsByDispatchID(Convert.ToInt32(dispatchID));
DispatchModel model = new DispatchModel(dispatch);
return(View(model));
}
catch (Exception ex)
{
var exception = EntityExceptionHelper.GetAndLogNetStepsException(ex, NetSteps.Data.Entities.Constants.NetStepsExceptionType.NetStepsApplicationException);
throw exception;
}
}
public virtual ActionResult Save(DispatchTable dispatch)
{
int resultado = 0;
try
{
if (dispatch.DispatchID > 0)
{
using (TransactionScope tran = new TransactionScope(TransactionScopeOption.Required))
{
resultado = Dispatch.UpdateDispatch(dispatch);
if (resultado < 1)
{
tran.Dispose();
return(Json(new { result = false, message = "No se grabó correctamente en la tabla Dispatch" }));
}
int retora = DispatchItems.DeleteDispatchItemsbyID(dispatch.DispatchID);
foreach (var product in dispatch.Products.Where(x => x.ProductID != 0))
{
product.DispatchID = dispatch.DispatchID;
if (DispatchItems.InsertDispatchItems(product) < 1)
{
tran.Dispose();
return(Json(new { result = false, message = "No se grabó correctamente en la tabla Dispatch" }));
}
}
resultado = 1;
tran.Complete();
}
}
else
{
using (TransactionScope tran = new TransactionScope(TransactionScopeOption.Required))
{
int dispatchID = 0;
dispatchID = Dispatch.InsertDispatch(dispatch);
if (dispatchID < 1)
{
tran.Dispose();
return(Json(new { result = false, message = "No se grabó correctamente en la tabla Dispatch" }));
}
foreach (var product in dispatch.Products.Where(x => x.ProductID != 0))
{
product.DispatchID = dispatchID;
if (DispatchItems.InsertDispatchItems(product) < 1)
{
tran.Dispose();
return(Json(new { result = false, message = "No se grabó correctamente en la tabla Dispatch" }));
}
}
resultado = 1;
tran.Complete();
}
}
}
catch (Exception ex)
{
var exception = EntityExceptionHelper.GetAndLogNetStepsException(ex, NetSteps.Data.Entities.Constants.NetStepsExceptionType.NetStepsApplicationException);
//tran.Dispose();
//throw exception;
return(Json(new { result = false, message = ex.Message }));
}
return(Json(new { result = (resultado == 0 ? false : true), message = "" }));
}
