public int Save(Models.MOrdersLine model) { Common.Logger l = new Common.Logger(); string ClassName = "COrderLine"; try { DB.OrderLine bs = new DB.OrderLine(); bs.OrderId = Convert.ToInt32(model.OrderId); bs.ProductId = Convert.ToInt32(model.ProductId); bs.SalePrice = model.SalePrice; bs.units = model.unit; bs.totalProductCost = model.totalProductCost; bs.eDate = Convert.ToDateTime(model.eDate); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] OrderId[" + model.OrderId + "] ProductId[" + model.ProductId + "] SalePrice[" + model.SalePrice + "] units [" + model.unit + " ] totalProductCost [ " + model.totalProductCost + " ] eDate[ " + model.eDate + "]"); obj.OrderLines.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public List <Models.MOrdersLine> GetAll() { List <Models.MOrdersLine> Get = new List <Models.MOrdersLine>(); var query = from o in obj.OrderLines select o; foreach (var item in query) { Models.MOrdersLine mol = new Models.MOrdersLine(); mol.id = item.id.ToString(); mol.eDate = item.eDate.ToString(); mol.OrderId = item.OrderId.ToString(); mol.ProductId = item.ProductId.ToString(); mol.SalePrice = item.SalePrice; mol.totalProductCost = item.totalProductCost; mol.unit = item.units; Get.Add(mol); } return(Get); }
private int SaveOrders() { try { Classes.CDefaultCashAccount cda = new Classes.CDefaultCashAccount(); Classes.CDefaultAccount cba = new Classes.CDefaultAccount(); int OrderId = 0; string OrderNo = txtOrderNo.Text; string OrderName = txtOrderName.Text; string OrderDescription = txtOrderDescription.Text; string OrderDate = txtOrderDate.Text; string OrderDeliveryDate = txtDeliveryOfOrderDate.Text; string TotalCost = ReturnTotalOrderCost().ToString(); string OrderType = ddlOrderType.SelectedValue; string VendorId = ddlVendor.SelectedValue; string ClientId = ddlCustomer.SelectedValue; string WareHouseId = Session["WareHouse"].ToString(); string ModeOfPayment = ddlModeOfPayment.SelectedItem.Text; string Installments = txtInstallments.Text; string InstallmentDueDate = txtIntallmentDueDate.Text; if (OrderType == "1") { OrderType = "Order To Client"; } else if (OrderType == "2") { OrderType = "Order To Vendor"; } else { return(-2); } if (ModeOfPayment == "Please Select") { return(-8); } Models.MOrders mr = new Models.MOrders(); mr.OrdersNo = OrderNo; mr.OrderName = OrderName; mr.OrderDescription = OrderDescription; mr.Orderdate = OrderDate; mr.deliverydate = OrderDeliveryDate; mr.TotalCost = TotalCost; mr.OrderType = OrderType; mr.eDate = DateTime.Now.ToShortDateString(); mr.FiscalYearld = Session["FiscalYear"].ToString(); mr.WareHouseId = WareHouseId; mr.ModeOfPayment = ModeOfPayment; mr.Installments = Installments; mr.InstallmentDueDate = InstallmentDueDate; if (OrderType.EndsWith("Vendor")) { mr.venorld = VendorId; mr.ClientId = "-1"; if (Convert.ToInt32(VendorId) < 0) { return(-5); } } else { if (cbGrantor.Checked) { string GrantorName = txtGrantorInfo.Text; mr.GrantorName = GrantorName; } mr.ClientId = ClientId; mr.venorld = "-1"; if (Convert.ToInt32(ClientId) < 0) { return(-6); } } Classes.COrders co = new Classes.COrders(); if (Convert.ToInt32(WareHouseId) < 0) { return(-7); } //Saving Order if (co.Save(mr) < 0) { return(-1); } OrderId = co.GetLastOrderID(); if (OrderId < 0) { return(-3); } //Saving Order Products #region objects Models.MOrdersLine mor = new Models.MOrdersLine(); Models.MSaleTransactions ms = new Models.MSaleTransactions(); Classes.CSaleTransations ct = new Classes.CSaleTransations(); Classes.COrderOnline cor = new Classes.COrderOnline(); Models.MInventory mi = new Models.MInventory(); Classes.CInventory ci = new Classes.CInventory(); float OrderTotalCost = 0; #endregion for (int i = 0; i < grdProducts.Rows.Count; i++) { #region objects initializing mor = new Models.MOrdersLine(); ms = new Models.MSaleTransactions(); ct = new Classes.CSaleTransations(); cor = new Classes.COrderOnline(); mi = new Models.MInventory(); ci = new Classes.CInventory(); DropDownList ddlProduct = (DropDownList)grdProducts.Rows[i].FindControl("ddlProducts"); TextBox txtCp = (TextBox)grdProducts.Rows[i].FindControl("txtCp"); TextBox txtSp = (TextBox)grdProducts.Rows[i].FindControl("txtSp"); TextBox txtUnits = (TextBox)grdProducts.Rows[i].FindControl("txtUnits"); TextBox txtTotal = (TextBox)grdProducts.Rows[i].FindControl("txtTotal"); string ProductId = ddlProduct.SelectedValue; string CostPrice = txtCp.Text; string SalePrice = txtSp.Text; string TotalUnits = txtUnits.Text; string totalCost = (Convert.ToInt32(TotalUnits) * Convert.ToInt32(SalePrice)).ToString(); OrderTotalCost += Convert.ToSingle(totalCost); #endregion //OrderLine #region OrderLine mor.OrderId = OrderId.ToString(); mor.ProductId = ProductId; if (OrderType.EndsWith("Vendor")) { mor.SalePrice = CostPrice; } else { mor.SalePrice = SalePrice; } mor.unit = TotalUnits; mor.totalProductCost = totalCost; mor.eDate = DateTime.Now.ToShortDateString(); if (cor.Save(mor) < 0) { return(-3); } #endregion //Sale transaction #region Sale Transaction ms.ProductID = ProductId; ms.clientID = ClientId; ms.CostPrice = CostPrice; ms.SalePrice = SalePrice; ms.units = TotalUnits; ms.clientID = ClientId; ms.VendorID = VendorId; ms.date = Convert.ToDateTime(txtOrderDate.Text); ms.WareHouseId = WareHouseId; ms.OrderId = OrderId.ToString(); if (OrderType.EndsWith("Vendor")) { ms.transactionType = Common.Constants.SaleTransactions.Addition.ToString(); } else { ms.transactionType = Common.Constants.SaleTransactions.Deduction.ToString(); } //sale transaction if (ct.Save(ms) < 0) { return(-1); } #endregion //Inventory #region Inventory mi.ProductId = ProductId; mi.WareHouseld = WareHouseId; mi.Quantity = TotalUnits; mi.FiscalYearld = Session["FiscalYear"].ToString(); mi.Date = Convert.ToDateTime(OrderDate); mi.Cost = CostPrice; if (OrderType.EndsWith("Vendor")) { // mi.Cost = CostPrice; if (ci.Save(mi, Common.Constants.SaleTransactions.Addition) < 0) { return(-4); } } else { // mi.Cost = SalePrice; if (ci.Save(mi, Common.Constants.SaleTransactions.Deduction) < 0) { return(-4); } } #endregion //Accounts #region Accounts if (OrderType.Contains("Vendor")) { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString(); mj.amount = totalCost; mj.des = "Order Of Inventory for Vendor of Product Id [" + ProductId + "] units [" + TotalUnits + "] "; mj.e_date = (OrderDate); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.AccountsPayable).ToString(); mj.amount = totalCost; mj.des = "Order Of Inventory for Vendor of Product Id [" + ProductId + "] units [" + TotalUnits + "] "; mj.e_date = (OrderDate); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); } else if (OrderType.Contains("Client")) { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.AccountsRecievalbes).ToString(); mj.amount = totalCost; mj.des = "Order Of Inventory for Client of Product Id [" + ProductId + "] units [" + TotalUnits + "] "; mj.e_date = (OrderDate); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); cj = new Classes.CJournal(); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Sales).ToString(); mj.amount = totalCost; mj.des = "Order Of Inventory for Client of Product Id [" + ProductId + "] units [" + TotalUnits + "] "; mj.e_date = (OrderDate); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); cj = new Classes.CJournal(); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.CostOfGoodsSold).ToString(); mj.amount = totalCost; mj.des = "Order Of Inventory for Client of Product Id [" + ProductId + "] units [" + TotalUnits + "] "; mj.e_date = (OrderDate); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); cj = new Classes.CJournal(); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString(); mj.amount = totalCost; mj.des = "Order Of Inventory for Client of Product Id [" + ProductId + "] units [" + TotalUnits + "] "; mj.e_date = (OrderDate); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); } #endregion } //Payments #region Payments Classes.CPayment cap = new Classes.CPayment(); Models.MPayments map = new Models.MPayments(); string TransactionId = ct.GetLastTransactionId().ToString(); if (ddlOrderType.SelectedItem.Text.Contains("Vendor")) { map.ClientId = -1; map.VendorId = Convert.ToInt32(VendorId); } else if (ddlOrderType.SelectedItem.Text.Contains("Client")) { map.ClientId = Convert.ToInt32(ClientId); map.VendorId = -1; } map.TransactionId = Convert.ToInt32(TransactionId); map.Paid = "0"; map.TotalCost = OrderTotalCost.ToString(); map.OrderId = OrderId; map.PaymentType = Common.Constants.PaymentTypes.Partial.ToString(); map.Paymentstate = Common.Constants.PaymentState.NotPaid.ToString(); if (cap.Save(map) < 0) { return(-4); } #endregion return(1); } catch { return(-1); } }