public int Update(Models.MSaleTransactions model) { Common.Logger l = new Common.Logger(); string ClassName = "CSaleTransaction"; try { var query = from o in obj.Transaction1s where o.id == model.id select o; foreach (var item in query) { item.ProductID = Convert.ToInt32(model.ProductID); item.CostPrice = model.CostPrice; item.SalePrice = model.SalePrice; item.units = model.units; item.TransactionType = model.transactionType; item.ClientID = model.clientID; item.VendorID = model.VendorID; item.date = model.date; } l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] ProductID[" + model.ProductID + "] CostPrice[" + model.CostPrice + "] SalePrice[" + model.SalePrice + "] units [ " + model.units + "] TransactionType [ " + model.transactionType + " ] ClientID [ " + model.clientID + " ] VendorID [ " + model.VendorID + " ] date [ " + model.date + " ]"); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Updated Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public List <Models.MSaleTransactions> GetAllbyid(int id) { List <Models.MSaleTransactions> model = new List <Models.MSaleTransactions>(); var query = from o in obj.Transaction1s where Convert.ToString(o.id) == id.ToString() select o; foreach (var item in query) { Models.MSaleTransactions m = new Models.MSaleTransactions(); m.id = item.id; m.ProductID = Convert.ToString(item.ProductID); m.CostPrice = item.CostPrice; m.SalePrice = item.SalePrice; m.units = item.units; m.transactionType = item.TransactionType; m.clientID = item.VendorID; m.date = Convert.ToDateTime(item.date); model.Add(m); } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { //Saving Journal try { #region Objects Classes.CBankOfAccount cab = new Classes.CBankOfAccount(); Classes.CAccountTransaction cat = new Classes.CAccountTransaction(); Classes.CSaleTransations ct = new Classes.CSaleTransations(); Classes.CDefaultAccount df = new Classes.CDefaultAccount(); Classes.CInventory ci = new Classes.CInventory(); Classes.CPayment cpay = new Classes.CPayment(); Classes.CPaymentLine cpl = new Classes.CPaymentLine(); Classes.CPaymentContainer cpc = new Classes.CPaymentContainer(); Models.MInventory mi = new Models.MInventory(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); Models.MSaleTransactions ms = new Models.MSaleTransactions(); Models.MPayments mpay = new Models.MPayments(); Models.PaymentContainer mpc = new Models.PaymentContainer(); Models.PaymentLine mpl = new Models.PaymentLine(); #endregion string WareHouseId = ddlWareHouse.SelectedValue; string ClientId = ddlClient.SelectedValue; float Discount = Convert.ToSingle(txtDiscount.Text); Discount = Discount / grdSales.Rows.Count; bool[] Result = new bool[grdSales.Rows.Count]; if (Convert.ToInt32(WareHouseId) > 0) { if (Convert.ToInt32(ClientId) > 0) { #region Start Saving for (int i = 0; i < grdSales.Rows.Count; i++) { DropDownList ddlProduct = (DropDownList)grdSales.Rows[i].FindControl("ddlProducts"); Label txtCp = (Label)grdSales.Rows[i].FindControl("txtCp"); TextBox txtSp = (TextBox)grdSales.Rows[i].FindControl("txtSp"); TextBox txtUnits = (TextBox)grdSales.Rows[i].FindControl("txtUnits"); TextBox txtTotal = (TextBox)grdSales.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(); totalCost = Convert.ToSingle(Convert.ToSingle(totalCost) - Discount).ToString(); ms.ProductID = ProductId; ms.CostPrice = CostPrice; ms.SalePrice = SalePrice.ToString(); ms.units = TotalUnits; ms.clientID = ClientId; ms.VendorID = "-1"; ms.date = Convert.ToDateTime(txtDate.Text); ms.transactionType = Common.Constants.SaleTransactions.Deduction.ToString(); ms.date = Convert.ToDateTime(txtDate.Text); ms.OrderId = "-1"; ms.WareHouseId = WareHouseId; ms.Discount = Discount.ToString(); //sale transaction if (ct.Save(ms) > 0) { mi.WareHouseld = WareHouseId; mi.Cost = CostPrice; mi.Quantity = TotalUnits; mi.ProductId = ProductId; mi.FiscalYearld = Session["FiscalYear"].ToString();; mi.Date = Convert.ToDateTime(txtDate.Text); //inventory int retVal = ci.Save(mi, Common.Constants.SaleTransactions.Deduction); if (retVal > 0) { #region Accounts Transactions //Payments int TransactionId = 0; TransactionId = ct.GetLastTransactionId(); if (TransactionId != 0) { string AccountId = string.Empty; AccountId = df.ReturnSaleDefaultAccount(Convert.ToInt32(Session["WareHouse"])).ToString(); mat.AccountId = AccountId; mat.Debit = "0"; mat.Credit = totalCost; mat.Description = "Purchased Product[" + ddlProduct.SelectedItem.Text + "] Units [" + TotalUnits + " At Cost/Unit[" + CostPrice + "]] "; float AccountTotal = cab.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)); AccountTotal = AccountTotal + Convert.ToSingle(totalCost); mat.Total = AccountTotal.ToString(); mat.CurrentTransaction = TransactionId.ToString(); mat.Transactiontype = "Credit"; mat.FiscalYearId = Session["FiscalYear"].ToString(); mat.eDate = Convert.ToDateTime(txtDate.Text); //Account Transation if (cat.Save(mat) > 0) { //Updating Account total if (cab.SetNewAccountTotal(Convert.ToInt32(AccountId), AccountTotal) > 0) { //Updating Payments mpay.ClientId = Convert.ToInt32(ClientId); mpay.VendorId = 0; mpay.OrderId = 0; mpay.TransactionId = TransactionId; mpay.Paid = totalCost; mpay.TotalCost = totalCost; mpay.PaymentType = Common.Constants.PaymentTypes.Full.ToString(); mpay.Paymentstate = Common.Constants.PaymentState.Paid.ToString(); if (cpay.Save(mpay) > 0) { int PaymentId = cpay.ReturnLastPaymentId(); mpc.BankId = Convert.ToInt32(AccountId); mpc.PaymentId = PaymentId; mpc.AmountRemaning = "0"; if (cpc.Save(mpc) > 0) { mpl.PaymentId = PaymentId; mpl.PaidAmount = totalCost; mpl.RemainingAmount = "0"; mpl.Date = txtDate.Text; mpl.BankId = Convert.ToInt32(AccountId); mpl.CumulativeAmount = totalCost; if (cpl.Save(mpl) > 0) { ShowErrorModal("Successfully Saved Journal"); } } } } } } #endregion } else if (retVal == 0) { ShowErrorModal("Not enough units in Warehouse:" + ddlWareHouse.SelectedItem.Text + "Of Product: " + ddlProduct.SelectedItem.Text); break; } else { ShowErrorModal("There was Error Saving the Journal"); break; } } else { ShowErrorModal("There was Error Saving the Journal"); break; } } #endregion } else { ShowErrorModal("Please select a Client"); } } else { ShowErrorModal("Please select WareHouse"); } bool FinalResuls = false; for (int i = 0; i < Result.Length; i++) { if (Result[i]) { FinalResuls = true; } else { FinalResuls = true; ShowErrorModal("Some Transactions might have been incompleted"); break; } } if (FinalResuls) { ShowErrorModal("Journal Successfully Saved"); DeleteAllRowsFromGrid(); ClearTextBoxes(Page); HidePreviewModal(); // Response.Redirect("~/Pages/Main.aspx"); } } catch { } }
public List <Models.MViewModels.MItemProfatibilityReport> GetAll(DateTime fromDate, DateTime toDate) { #region Class Objects Classes.CSaleTransations ct = new CSaleTransations(); Classes.CWareHouse cw = new CWareHouse(); Classes.CProducts cp = new CProducts(); #endregion #region Models Models.MSaleTransactions mt = new Models.MSaleTransactions(); Models.MViewModels.MItemProfatibilityReport mii = new Models.MViewModels.MItemProfatibilityReport(); #endregion #region Lists List <Models.MViewModels.MItemProfatibilityReport> ItemProfatiblity = new List <Models.MViewModels.MItemProfatibilityReport>(); List <Models.MSaleTransactions> Transactions = new List <Models.MSaleTransactions>(); List <string> Products = new List <string>(); #endregion #region Logic float totalUnits = 0; Transactions = ct.GetAll(); //filtering for only deductions Transactions = (from o in Transactions where o.transactionType == Common.Constants.SaleTransactions.Deduction.ToString() && Convert.ToDateTime(o.date) >= fromDate && Convert.ToDateTime(o.date) <= toDate select o).ToList(); totalUnits = (from o in Transactions select Convert.ToSingle(o.units)).Sum(); Products = (from o in Transactions select o.ProductID).Distinct().ToList(); for (int i = 0; i < Products.Count; i++) { mii = new Models.MViewModels.MItemProfatibilityReport(); List <Models.MSaleTransactions> ProductWise = new List <Models.MSaleTransactions>(); ProductWise = (from o in Transactions where o.ProductID == Products[i] select o).ToList(); string ProductName = cp.GetProductNameWithTagsById(Convert.ToInt32(Products[i])); float CostPrice = (from a in ProductWise where a.ProductID == Products[i] select Convert.ToSingle(a.CostPrice)).Sum(); float Revenue = (from a in ProductWise where a.ProductID == Products[i] select Convert.ToSingle(a.SalePrice)).Sum(); float units = (from a in ProductWise where a.ProductID == Products[i] select Convert.ToSingle(a.units)).Sum(); CostPrice = CostPrice * units; Revenue = Revenue * units; float Difference = Revenue - CostPrice; float totalCost = Transactions.Select(o => Convert.ToSingle(o.units)).Sum(); float Percentage = (units / totalUnits) * 100; mii.Inventory = ProductName; mii.WareHouse = "Remaining"; mii.ActualCost = CostPrice.ToString(); mii.ActualRevenue = Revenue.ToString(); mii.Diff = Difference.ToString(); mii.UnitsSold = units.ToString(); mii.Percent = Percentage.ToString() + "%"; ItemProfatiblity.Add(mii); } #endregion return(ItemProfatiblity); }
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); } }
public int Save(Models.MSaleTransactions model) { Common.Logger l = new Common.Logger(); string ClassName = "CSaleTransaction"; try { DB.Transaction1 bs = new DB.Transaction1(); bs.id = Convert.ToInt32(model.id); bs.ProductID = Convert.ToInt32(model.ProductID); bs.CostPrice = model.CostPrice; bs.SalePrice = model.SalePrice; bs.units = model.units; bs.TransactionType = model.transactionType; bs.VendorID = model.VendorID; bs.ClientID = model.clientID; bs.OrderId = Convert.ToInt32(model.OrderId); bs.WareHouseId = Convert.ToInt32(model.WareHouseId); bs.date = model.date; l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] ProductID[" + model.ProductID + "] CostPrice[" + model.CostPrice + "] SalePrice[" + model.SalePrice + "] units [ " + model.units + "] TransactionType [ " + model.transactionType + " ] ClientID [ " + model.clientID + " ] VendorID [ " + model.VendorID + " ] date [ " + model.date + " ]"); obj.Transaction1s.InsertOnSubmit(bs); obj.SubmitChanges(); if (model.transactionType == Common.Constants.SaleTransactions.Addition.ToString()) { Classes.CJournal cj = new CJournal(); DB.Journal j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)) - Convert.ToSingle(model.Discount); j.des = "Purchased Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); if (Convert.ToSingle(model.Discount) > 0) { j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.PurchaseDiscount); j.amount = Convert.ToSingle(model.Discount); j.des = "Purchased Inventory Discount [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); } j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)); j.des = "Purchased Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Credit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); } else if (model.transactionType == Common.Constants.SaleTransactions.Deduction.ToString()) { Classes.CJournal cj = new CJournal(); DB.Journal j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)) - Convert.ToSingle(model.Discount); j.des = "Sold Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); if (Convert.ToSingle(model.Discount) > 0) { j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.SalesDiscount); j.amount = Convert.ToSingle(model.Discount); j.des = "Sold Inventory Discount [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); } j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Sales); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)); j.des = "Sold Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Credit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); cj = new CJournal(); j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.CostOfGoodsSold); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)); j.des = "Sold Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)); j.des = "Sold Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Credit.ToString(); obj.Journals.InsertOnSubmit(j); 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); } }
protected void btnSave_Click(object sender, EventArgs e) { //Saving Journal try { #region Objects Classes.CBankOfAccount cab = new Classes.CBankOfAccount(); Classes.CAccountTransaction cat = new Classes.CAccountTransaction(); Classes.CSaleTransations ct = new Classes.CSaleTransations(); Classes.CDefaultAccount df = new Classes.CDefaultAccount(); Classes.CInventory ci = new Classes.CInventory(); Classes.CPayment cpay = new Classes.CPayment(); Classes.CPaymentLine cpl = new Classes.CPaymentLine(); Classes.CPaymentContainer cpc = new Classes.CPaymentContainer(); Models.MInventory mi = new Models.MInventory(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); Models.MSaleTransactions ms = new Models.MSaleTransactions(); Models.MPayments mpay = new Models.MPayments(); Models.PaymentContainer mpc = new Models.PaymentContainer(); Models.PaymentLine mpl = new Models.PaymentLine(); #endregion string WareHouseId = ddlWareHouse.SelectedValue; // float Discount = Convert.ToSingle(txtDiscount.Text); // Discount = Discount / grdSales.Rows.Count; if (Convert.ToInt32(WareHouseId) > 0) { #region Start Saving for (int i = 0; i < grdSales.Rows.Count; i++) { DropDownList ddlProduct = (DropDownList)grdSales.Rows[i].FindControl("ddlProducts"); TextBox txtCp = (TextBox)grdSales.Rows[i].FindControl("txtCp"); Label txtVendor = (Label)grdSales.Rows[i].FindControl("txtVendor"); TextBox txtUnits = (TextBox)grdSales.Rows[i].FindControl("txtUnits"); TextBox txtTotal = (TextBox)grdSales.Rows[i].FindControl("txtTotal"); string ProductId = ddlProduct.SelectedValue; string CostPrice = txtCp.Text; string[] VendorDetails = txtVendor.Text.Split('-'); string VendorId = VendorDetails[0]; string TotalUnits = txtUnits.Text; string totalCost = (Convert.ToInt32(TotalUnits) * Convert.ToInt32(CostPrice)).ToString(); totalCost = Convert.ToSingle(Convert.ToSingle(totalCost)).ToString(); ms.ProductID = ProductId; ms.CostPrice = CostPrice; ms.units = TotalUnits; ms.date = Convert.ToDateTime(txtDate.Text); ms.transactionType = Common.Constants.SaleTransactions.Addition.ToString(); ms.date = Convert.ToDateTime(txtDate.Text); ms.VendorID = VendorId; ms.OrderId = "-1"; ms.WareHouseId = WareHouseId; ms.clientID = "-1"; ms.Discount = "0"; //sale transaction if (ct.Save(ms) > 0) { mi.WareHouseld = WareHouseId; mi.Cost = CostPrice; mi.Quantity = TotalUnits; mi.ProductId = ProductId; mi.FiscalYearld = "1"; mi.Date = Convert.ToDateTime(txtDate.Text); //inventory int retVal = ci.Save(mi, Common.Constants.SaleTransactions.Addition); if (retVal > 0) { //dance } else if (retVal == 0) { ShowErrorModal("Not enough units"); } else { ShowErrorModal("There was Error Saving the Journal"); break; } } else { ShowErrorModal("There was Error Saving the Journal"); break; } } ShowErrorModal("Successfully Saved Journal"); DeleteAllRowsFromGrid(); ClearTextBoxes(Page); HidePreviewModal(); #endregion } else { ShowErrorModal("Please Select Warehouse"); } } catch { } }