public bool Update([FromBody] Dispatch _oDispatch) { try { int output; using (var context = new DB001Core()) { var input = context.Dispatchs .Include(d => d.DispatchDetails) .Where(s => s.DispatchID == _oDispatch.DispatchID) .FirstOrDefault(); input.ClientID = _oDispatch.ClientID; input.ProductID = _oDispatch.ProductID; input.StateID = _oDispatch.StateID; input.DistrictID = _oDispatch.DistrictID; input.CityID = _oDispatch.CityID; input.ShippingAddress = _oDispatch.ShippingAddress; input.DispatchDate = _oDispatch.DispatchDate; input.DispatchDetails = _oDispatch.DispatchDetails; input.IsDispatched = _oDispatch.IsDispatched; input.ModifiedOn = DateTime.Now; if (_oDispatch.IsDispatched == true) { if (input.DispatchDate == null) { input.DispatchDate = DateTime.Now; } } output = context.SaveChanges(); } if (_oDispatch.IsDispatched == true) { var invoice = context.Invoices .Where(w => w.OrderID == _oDispatch.OrderID && w.PaymentStatus.Status == "Pending") .FirstOrDefault(); if (invoice != null) { invoice.PaymentStatusID = 2; //Unpaid context.SaveChanges(); } CommonLogic commonLogic = new CommonLogic(); commonLogic.ChangeOrderStatus(_oDispatch.OrderID, "Delivered"); } return(Convert.ToBoolean(output)); } catch (Exception ex) { throw; } finally { context = null; } }
public bool Add([FromBody] Dispatch _oDispatch) { try { int output; using (var context = new DB001Core()) { CommonLogic clsCommonLogic = new CommonLogic(); _oDispatch.DispatchNumber = clsCommonLogic.GenerateDispatchCode(); _oDispatch.CreatedOn = DateTime.Now; _oDispatch.ModifiedOn = DateTime.Now; _oDispatch.IsDeleted = false; context.Dispatchs.Add(_oDispatch); output = context.SaveChanges(); } CommonLogic commonLogic = new CommonLogic(); commonLogic.ChangeOrderStatus(_oDispatch.OrderID, "Device Ready"); return(Convert.ToBoolean(output)); } catch (Exception ex) { throw; } finally { context = null; } }
public bool Update([FromBody] Invoice _oInvoice) { try { int output = 0; if (_oInvoice.IsDraft) { using (var context = new DB001Core()) { var input = context.Invoices .Include(i => i.InvoiceDetails) .Where(w => w.InvoiceID == _oInvoice.InvoiceID) .FirstOrDefault(); input.ClientID = _oInvoice.ClientID; input.ProductID = _oInvoice.ProductID; input.OrderID = _oInvoice.OrderID; input.PaymentModeID = _oInvoice.PaymentModeID; input.PaymentStatusID = _oInvoice.PaymentStatusID; input.TotalAmount = _oInvoice.TotalAmount; input.PaymentDate = _oInvoice.PaymentDate; input.InvoiceDetails = _oInvoice.InvoiceDetails; input.IsDraft = _oInvoice.IsDraft; output = context.SaveChanges(); } } else { using (var context = new DB001Core()) { var input = context.Invoices .Include(i => i.InvoiceDetails) .Where(w => w.InvoiceID == _oInvoice.InvoiceID) .FirstOrDefault(); if (_oInvoice.PaymentStatusID == 1 && input.PaymentDate == null) { input.PaymentDate = DateTime.Now; AddDistributorBill(_oInvoice); } input.PaymentModeID = _oInvoice.PaymentModeID; input.PaymentStatusID = _oInvoice.PaymentStatusID; input.IsDraft = _oInvoice.IsDraft; input.InvoiceDetails = _oInvoice.InvoiceDetails; output = context.SaveChanges(); if (_oInvoice.PaymentStatusID == 1 && input.PaymentDate == null) { var invoice = context.Invoices .Where(w => w.OrderID == _oInvoice.OrderID) .FirstOrDefault(); AddDistributorBill(invoice); } } if (_oInvoice.PaymentStatusID != 1) { CommonLogic commonLogic = new CommonLogic(); commonLogic.ChangeOrderStatus(_oInvoice.OrderID, "Billing"); } else if (_oInvoice.PaymentStatusID == 1) { CommonLogic commonLogic = new CommonLogic(); commonLogic.ChangeOrderStatus(_oInvoice.OrderID, "Payment"); } } return(Convert.ToBoolean(output)); } catch (Exception ex) { throw; } finally { context = null; } }