public JsonResult updateFeeRepository([FromBody] Business.FeeDataModel request) { var respuesta = new { idEntity = request.FeeID, idEntityRequest = request.FeeID, message = "OK", error = "", DataReceived = request, OldData = "" }; Fees oldData = null; using (QuotingToolRepository db = new QuotingToolRepository()) { try { var FeeData = request.FeeID > 0 ? db.Fees.Where(i => i.FeeID == request.FeeID).Single() : new Fees(); oldData = FeeData; if (request.FeeID > 0) { FeeData.DateUpdated = System.DateTime.Now; FeeData.UpdatedBy = "SYSTEM"; // Replace with the right identity, } else { FeeData.DateAdded = System.DateTime.Now; FeeData.AddedBy = "SYSTEM"; // Replace with the right identity, } FeeData.FeeID = request.FeeID; FeeData.ParentFeeID = request.ParentFeeID; FeeData.FeeTypeID = request.FeeTypeID; FeeData.ByUomID = request.ByUomID; FeeData.CityID = request.CityID; FeeData.StateID = request.StateID; FeeData.Discount = request.Discount; FeeData.IslandID = request.IslandID; FeeData.ActionID = request.ActionID; FeeData.Value = request.Value; FeeData.ZipCodes = request.ZipCodes; FeeData.FeeMin = request.FeeMin; FeeData.FeeMax = request.FeeMax; FeeData.RangeFrom = request.RangeFrom; FeeData.RangeTo = request.RangeTo; FeeData.ValidFrom = request.ValidFrom; FeeData.ValidUntil = request.ValidUntil; if (request.FeeID < 0 && Helpers.NewEntityCreationHelper.CheckMandatoryFields(FeeData, typeof(Fees))) { db.Fees.AddObject(FeeData); } if (db.SaveChanges() > 0) { respuesta = new { idEntity = FeeData.FeeID, idEntityRequest = request.FeeID, message = "OK", error = "", DataReceived = request, OldData = JsonConvert.SerializeObject(oldData) } } ; } catch (Exception ex) { Response.StatusCode = 500; respuesta = new { idEntity = request.FeeID, idEntityRequest = request.FeeID, message = "ERROR", error = ex.Message, DataReceived = request, OldData = JsonConvert.SerializeObject(oldData) }; } } return(Json(respuesta, JsonRequestBehavior.AllowGet)); }
public JsonResult updateSingleFieldFeeData([FromBody] Business.AGCellValueDataChangedModel request) { var respuesta = new { idEntity = request.idEntity, message = "OK", error = "", DataReceived = request, OldData = "" }; Fees oldData = null; using (QuotingToolRepository db = new QuotingToolRepository()) { try { var FeeData = request.idEntity > -1 ? db.Fees.Where(i => i.FeeID == request.idEntity).Single() : new Fees(); oldData = FeeData; if (request.idEntity > -1) { FeeData.DateUpdated = System.DateTime.Now; FeeData.UpdatedBy = "System"; // Replace with the right identity, } else { FeeData.DateAdded = System.DateTime.Now; FeeData.AddedBy = "System"; // Replace with the right identity, } var properties = typeof(Fees).GetProperties(BindingFlags.Public | BindingFlags.Instance); foreach (var property in properties) { if (request.field == property.Name) { property.SetValue(FeeData, Helpers.TypesHelper.ChangeType(request.newValue, property.PropertyType), null); break; } } if (request.idEntity == -1) { db.Fees.AddObject(FeeData); } if (db.SaveChanges() > 0) { respuesta = new { idEntity = request.idEntity, message = "OK", error = "", DataReceived = request, OldData = JsonConvert.SerializeObject(oldData) } } ; } catch (Exception ex) { Response.StatusCode = 500; respuesta = new { idEntity = request.idEntity, message = "ERROR", error = ex.Message + System.Environment.NewLine + ex.InnerException?.Message, DataReceived = request, OldData = JsonConvert.SerializeObject(oldData) }; } } return(Json(respuesta, JsonRequestBehavior.AllowGet)); }
public JsonResult removeFeeData([FromBody] int[] ids) { var respuesta = new { message = "OK", error = "", DataReceived = JsonConvert.SerializeObject(ids), OldData = "" }; try { using (QuotingToolRepository db = new QuotingToolRepository()) { foreach (int id in ids) { db.Fees.DeleteObject(db.Fees.Where(i => i.FeeID == id).Single()); } db.SaveChanges(); } } catch (Exception ex) { Response.StatusCode = 500; respuesta = new { message = "ERROR", error = ex.Message, DataReceived = JsonConvert.SerializeObject(ids), OldData = "" }; } return(Json(respuesta, JsonRequestBehavior.AllowGet)); }