public int Update(Models.MAccountTransaction model) { Common.Logger l = new Common.Logger(); string ClassName = "CAccounttransaction"; try { var query = from o in obj.AccountTransactions where Convert.ToString(o.id) == model.id select o; foreach (var item in query) { item.AccountId = Convert.ToInt32(model.AccountId); item.Total = model.Total; item.CurrentTransaction = model.CurrentTransaction; item.TransactionType = model.Transactiontype; item.FiscalYearId = Convert.ToInt32(model.FiscalYearId); item.eDate = model.eDate; } l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] AccountId[" + model.AccountId + "] Total[" + model.Total + "] CurrentTransaction[" + model.CurrentTransaction + "] TransactionType [ " + model.Transactiontype + " ] FiscalYearId [ " + model.FiscalYearId + " ] eDate [" + model.eDate + " ]"); 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 int Save(Models.MAccountTransaction model) { Common.Logger l = new Common.Logger(); string ClassName = "CAccounttransaction"; try { DB.AccountTransaction bs = new DB.AccountTransaction(); // bs.id = int.Parse(model.id); bs.AccountId = int.Parse(model.AccountId); bs.Total = model.Total; bs.Debit = model.Debit; bs.Credit = model.Credit; bs.Description = model.Description; bs.CurrentTransaction = model.CurrentTransaction; bs.TransactionType = model.Transactiontype; bs.FiscalYearId = int.Parse(model.FiscalYearId); bs.eDate = model.eDate; l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] AccountId[" + model.AccountId + "] Total[" + model.Total + "] CurrentTransaction[" + model.CurrentTransaction + "] TransactionType [ " + model.Transactiontype + " ] FiscalYearId [ " + model.FiscalYearId + " ] eDate [" + model.eDate + " ]"); obj.AccountTransactions.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); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { if (Convert.ToInt32(ddlBankId.SelectedValue) > 0) { string AccountBankId = ddlBankId.SelectedValue; string AccountNumber = txtAccountNumber.Text; string AccountTitle = txtAccountTitle.Text; string AccountHolderId = txtAccountHolderId.Text; string OpeningDate = txtBeginDate.Text; string OpeningBalance = txtOpeningBalance.Text; Models.MBankAccount mv = new Models.MBankAccount(); mv.BankId = AccountBankId; mv.accountNumber = AccountNumber; mv.Accounttitle = AccountTitle; mv.AccountHolderId = AccountHolderId; mv.BeginDate = OpeningDate; mv.OpeningBalance = OpeningBalance; mv.Balance = OpeningBalance; mv.WareHouseId = Session["WareHouse"].ToString(); Classes.CBankOfAccount ccv = new Classes.CBankOfAccount(); if (ccv.Save(mv) < 0) { ShowFailMessage(); } else { Classes.CAccountTransaction cat = new Classes.CAccountTransaction(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); mat.AccountId = ccv.ReturnLastAccountId().ToString(); mat.CurrentTransaction = "0"; mat.Credit = mv.OpeningBalance; mat.Debit = "0"; mat.eDate = DateTime.Now; mat.Total = OpeningBalance; mat.Description = "Opened Account [" + AccountTitle + "] Opening Balance [" + OpeningBalance + "]"; mat.Transactiontype = "Credit"; mat.FiscalYearId = Session["FiscalYear"].ToString(); if (cat.Save(mat) < 0) { ShowFailMessage(); } else { ShowSuccessMessage(); ClearTextBoxes(Page); } } } else { ShowErrorModal("Please Select Bank"); } } }
public List <Models.MAccountTransaction> GetAll() { List <Models.MAccountTransaction> model = new List <Models.MAccountTransaction>(); var query = from o in obj.AccountTransactions select o; foreach (var item in query) { Models.MAccountTransaction m = new Models.MAccountTransaction(); m.id = Convert.ToString(item.id); m.AccountId = Convert.ToString(item.AccountId); m.Total = item.Total; m.Debit = item.Debit; m.Credit = item.Credit; m.Description = item.Description; m.CurrentTransaction = item.CurrentTransaction; m.Transactiontype = item.TransactionType; m.FiscalYearId = Convert.ToString(item.FiscalYearId); m.eDate = Convert.ToDateTime(Convert.ToString(item.eDate)); 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 { } }
private int ProcessPayments(string PaymentId, string OrderId, string totalCost, string CurrentAmountPaid, string AccountId, float AmountRemaining, string RemainingAmount, string DatePaid, string Type) { if (Page.IsValid) { Classes.CBankOfAccount cba = new Classes.CBankOfAccount(); Classes.CAccountTransaction cat = new Classes.CAccountTransaction(); Classes.CPayment cp = new Classes.CPayment(); Classes.CPaymentLine cpl = new Classes.CPaymentLine(); Classes.CSaleTransations cs = new Classes.CSaleTransations(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); Models.MPayments mp = new Models.MPayments(); Models.PaymentLine mpl = new Models.PaymentLine(); #region Payments mp.Paid = (Convert.ToSingle(totalCost) - AmountRemaining).ToString(); if (cp.UpdateAmountPaid(Convert.ToInt32(PaymentId), mp.Paid) < 0) { return(-1); } #endregion #region PaymentLine mpl.PaymentId = Convert.ToInt32(PaymentId); mpl.BankId = Convert.ToInt32(AccountId); mpl.Date = DatePaid; mpl.PaidAmount = CurrentAmountPaid; mpl.RemainingAmount = RemainingAmount; mpl.CumulativeAmount = (Convert.ToSingle(cpl.LastPaidAmount(mpl.PaymentId)) + Convert.ToSingle(CurrentAmountPaid)).ToString(); if (cpl.Save(mpl) < 0) { return(-2); } #endregion #region Account Transactions float AccountTotal = cba.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)); mat.AccountId = AccountId; if (Type.Contains("Vendor")) { mat.Description = "Payment Of Order Id[" + OrderId + "] Paid, Amount [" + CurrentAmountPaid + "]"; mat.Debit = CurrentAmountPaid; mat.Credit = "0"; mat.Total = (AccountTotal - Convert.ToSingle(CurrentAmountPaid)).ToString(); mat.CurrentTransaction = cs.GetIdByOrderId(Convert.ToInt32(OrderId)).ToString(); mat.Transactiontype = "Debit"; mat.FiscalYearId = Session["FiscalYear"].ToString(); mat.eDate = Convert.ToDateTime(DatePaid); } else if (Type.Contains("Client")) { mat.Description = "Payment Of Order Id[" + OrderId + "] Recieved, Amount [" + CurrentAmountPaid + "]"; mat.Debit = "0"; mat.Credit = CurrentAmountPaid; mat.CurrentTransaction = cs.GetIdByOrderId(Convert.ToInt32(OrderId)).ToString(); mat.Total = (AccountTotal + Convert.ToSingle(CurrentAmountPaid)).ToString(); mat.Transactiontype = "Credit"; mat.FiscalYearId = Session["FiscalYear"].ToString(); mat.eDate = Convert.ToDateTime(DatePaid); } else { return(-3); } if (cat.Save(mat) < 0) { return(-4); } if (cba.SetNewAccountTotal(Convert.ToInt32(AccountId), Convert.ToSingle(mat.Total)) < 0) { return(-5); } #endregion #region Accounts if (Convert.ToSingle(mp.Paid) > 0) { if (Type == "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 = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); 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 = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); } else if (Type == "Client") { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.CostOfGoodsSold).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); 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.AccountsRecievalbes).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Sales).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); } } #endregion } return(1); }
private int Save() { Classes.CBankOfAccount cb = new Classes.CBankOfAccount(); Classes.CAccountTransaction cat = new Classes.CAccountTransaction(); Classes.CDefaultAccount cd = new Classes.CDefaultAccount(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); int AccountId = 0; string Amount = string.Empty; string Description = string.Empty; string Debit = string.Empty; string Credit = string.Empty; string Total = string.Empty; string CurrentTransaction = string.Empty; string FiscalYearId = string.Empty; DateTime eDate; if (cbDefault.Checked) { AccountId = cd.ReturnPurchaseDefaultAccount(Convert.ToInt32(Session["WareHouse"])); } else { AccountId = Convert.ToInt32(ddlSaleAccount.SelectedValue); } Amount = txtamount.Text; Description = "Msc Expense: " + txtDescription.Text; Debit = txtamount.Text; Credit = "0"; Total = txtamount.Text; CurrentTransaction = "-21"; FiscalYearId = Convert.ToInt32(Session["FiscalYear"]).ToString(); eDate = Convert.ToDateTime(txtdate.Text); mat.AccountId = Convert.ToInt32(AccountId).ToString(); mat.Credit = Credit; mat.Debit = Debit; mat.Description = Description; mat.FiscalYearId = FiscalYearId; mat.Total = Total; mat.Transactiontype = "Expense"; if (cb.SetNewAccountTotal(Convert.ToInt32(AccountId), Convert.ToSingle(Total)) > 0) { if (cat.Save(mat) > 0) { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.GeneralExpense).ToString(); mj.amount = Total; mj.des = "Msc Expense "; mj.e_date = (eDate).ToShortDateString(); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash).ToString(); mj.amount = Total; mj.des = "Msc Expense "; mj.e_date = (eDate).ToShortDateString(); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); return(1); } else { return(-1); } } else { return(-1); } }
public int RevertSingleTransaction(int TransactionId, int Units, int ProductId) { try { var TransactionType = (from o in obj.Transaction1s where o.id == TransactionId select o.TransactionType).FirstOrDefault(); var PaymentId = (from o in obj.Payments where o.TransactionId == TransactionId select o.id).FirstOrDefault(); var DataPaymentLine = from o in obj.PaymentLines where o.PaymentId == Convert.ToInt32(PaymentId) select o; var AccountType = (from o in obj.Payments join paymentLine in obj.PaymentLines on o.id equals paymentLine.PaymentId select paymentLine.ModeOfPayment); string AccountId = string.Empty; Classes.CPayment cp = new CPayment(); Models.MPayments mp = new Models.MPayments(); Classes.CInventory ci = new CInventory(); List <Models.MInventory> Inventory = new List <Models.MInventory>(); Classes.CProducts cpr = new CProducts(); Inventory = ci.GetAll(); string CostPrice = (from o in obj.Transaction1s where o.ProductID == ProductId && o.id == TransactionId select o.CostPrice).FirstOrDefault(); string SalePrice = (from o in obj.Transaction1s where o.ProductID == ProductId && o.id == TransactionId select o.SalePrice).FirstOrDefault(); switch (TransactionType) { case "Addition": { //Reverting Inventory float oldUnits = (from o in Inventory where o.ProductId == (ProductId).ToString() select Convert.ToSingle(o.Quantity)).FirstOrDefault(); float newUnits = oldUnits - Convert.ToSingle(Units); var query = from o in obj.Inventories where o.ProductId == Convert.ToInt32(ProductId) select o; foreach (var item in query) { item.Quantity = newUnits.ToString(); } obj.SubmitChanges(); obj.SubmitChanges(); //checking for cash of bank account if (Convert.ToString(AccountType) == Common.Constants.ModeOfPayment.Cash.ToString()) { string Amount = (Convert.ToSingle(CostPrice) * Convert.ToSingle(Units)).ToString(); Classes.CBankOfAccount cba = new CBankOfAccount(); Classes.CAccountTransaction cat = new CAccountTransaction(); //Reverting Account float OldTotal = cba.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)); float NewTotal = OldTotal + Convert.ToSingle(Amount); cba.SetNewAccountTotal(Convert.ToInt32(AccountId), NewTotal); //Add Revert Account Transaction Models.MAccountTransaction mat = new Models.MAccountTransaction(); mat.AccountId = AccountId.ToString(); mat.Credit = "0"; mat.Debit = Amount.ToString(); mat.Description = "Reverted Sale Transaction Product Id[" + ProductId + "] Units [" + Units + "]"; mat.eDate = DateTime.Now; mat.FiscalYearId = (from o in obj.AccountTransactions where o.CurrentTransaction == TransactionId.ToString() select o.FiscalYearId.ToString()).FirstOrDefault(); mat.Total = cba.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)).ToString(); mat.Transactiontype = "Credit"; cat.Save(mat); } else if (Convert.ToString(AccountType) == Common.Constants.ModeOfPayment.Cheque.ToString()) { Classes.CCashAccount cca = new CCashAccount(); Classes.CCashTransaction cct = new CCashTransaction(); Models.MCashTransactions mct = new Models.MCashTransactions(); Models.MCashAccount mca = new Models.MCashAccount(); string Amount = (Convert.ToSingle(CostPrice) * Convert.ToSingle(Units)).ToString(); //Reverting Account float OldTotal = cca.ReturnTotalOfCashAccount(Convert.ToInt32(AccountId)); float NewTotal = OldTotal + Convert.ToSingle(Amount); //setting new total cca.SetNewAccountTotal(Convert.ToInt32(AccountId), NewTotal); mct.CashAccountId = Convert.ToInt32(AccountId); mct.Credit = Amount; mct.Debit = "0"; mct.Description = "Reverted Sale Transaction Product Id[" + ProductId + "] Units [" + Units + "]"; mct.eDate = DateTime.Now.ToShortDateString(); mct.FiscalYearId = Convert.ToInt32((from o in obj.CashTransactions where o.TransactionId == TransactionId select o.FiscalYearId).FirstOrDefault()); mct.OrderId = -1; mct.TransactionId = -1; mct.TransactionType = Common.Constants.TransactionStatus.Reverse.ToString(); mct.UserId = Convert.ToString((from o in obj.CashTransactions where o.TransactionId == TransactionId select o.UserId).FirstOrDefault()); mct.WareHouseId = Convert.ToInt32((from o in obj.CashTransactions where o.TransactionId == TransactionId select o.WareHouseId).FirstOrDefault()); cct.Save(mct); } break; } case "Deduction": { //Reverting Inventory float oldUnits = (from o in Inventory where o.ProductId == (ProductId).ToString() select Convert.ToSingle(o.Quantity)).FirstOrDefault(); float newUnits = oldUnits + Convert.ToSingle(Units); var query = from o in obj.Inventories where o.ProductId == Convert.ToInt32(ProductId) select o; foreach (var item in query) { item.Quantity = newUnits.ToString(); } obj.SubmitChanges(); //checking for cash of bank account if (Convert.ToString(AccountType) == Common.Constants.ModeOfPayment.Cash.ToString()) { string Amount = (Convert.ToSingle(CostPrice) * Convert.ToSingle(Units)).ToString(); Classes.CBankOfAccount cba = new CBankOfAccount(); Classes.CAccountTransaction cat = new CAccountTransaction(); //Reverting Account float OldTotal = cba.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)); float NewTotal = OldTotal - Convert.ToSingle(Amount); cba.SetNewAccountTotal(Convert.ToInt32(AccountId), NewTotal); //Add Revert Account Transaction Models.MAccountTransaction mat = new Models.MAccountTransaction(); mat.AccountId = AccountId.ToString(); mat.Credit = "0"; mat.Debit = Amount.ToString(); mat.Description = "Reverted Sale Transaction Product Id[" + ProductId + "] Units [" + Units + "]"; mat.eDate = DateTime.Now; mat.FiscalYearId = (from o in obj.AccountTransactions where o.CurrentTransaction == TransactionId.ToString() select o.FiscalYearId.ToString()).FirstOrDefault(); mat.Total = cba.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)).ToString(); mat.Transactiontype = "Credit"; cat.Save(mat); } else if (Convert.ToString(AccountType) == Common.Constants.ModeOfPayment.Cheque.ToString()) { Classes.CCashAccount cca = new CCashAccount(); Classes.CCashTransaction cct = new CCashTransaction(); Models.MCashTransactions mct = new Models.MCashTransactions(); Models.MCashAccount mca = new Models.MCashAccount(); string Amount = (Convert.ToSingle(CostPrice) * Convert.ToSingle(Units)).ToString(); //Reverting Account float OldTotal = cca.ReturnTotalOfCashAccount(Convert.ToInt32(AccountId)); float NewTotal = OldTotal - Convert.ToSingle(Amount); //setting new total cca.SetNewAccountTotal(Convert.ToInt32(AccountId), NewTotal); //cash account transation mct.CashAccountId = Convert.ToInt32(AccountId); mct.Credit = "0"; mct.Debit = Amount; mct.Description = "Reverted Sale Transaction Product Id[" + ProductId + "] Units [" + Units + "]"; mct.eDate = DateTime.Now.ToShortDateString(); mct.FiscalYearId = Convert.ToInt32((from o in obj.CashTransactions where o.TransactionId == TransactionId select o.FiscalYearId).FirstOrDefault()); mct.OrderId = -1; mct.TransactionId = -1; mct.TransactionType = Common.Constants.TransactionStatus.Reverse.ToString(); mct.UserId = Convert.ToString((from o in obj.CashTransactions where o.TransactionId == TransactionId select o.UserId).FirstOrDefault()); mct.WareHouseId = Convert.ToInt32((from o in obj.CashTransactions where o.TransactionId == TransactionId select o.WareHouseId).FirstOrDefault()); cct.Save(mct); } break; } default: break; } //deletin Transaction var transactions = from o in obj.Transaction1s where o.id == TransactionId select o; foreach (var item in transactions) { obj.Transaction1s.DeleteOnSubmit(item); } //deleting Payment lines foreach (var item in DataPaymentLine) { obj.PaymentLines.DeleteOnSubmit(item); } obj.SubmitChanges(); //deleting payments mp.id = Convert.ToInt32(PaymentId); cp.Delete(mp); return(1); } catch { return(-1); } }
public int RevertSingleTransaction(int TransactionId) { try { var TransactionType = (from o in obj.Transaction1s where o.id == TransactionId select o.TransactionType).FirstOrDefault(); var AmountPaid = (from o in obj.Payments where o.TransactionId == TransactionId select o.Paid).FirstOrDefault(); var ProductId = (from o in obj.Transaction1s where o.id == TransactionId select o.ProductID).FirstOrDefault(); var Units = (from o in obj.Transaction1s where o.id == TransactionId select o.units).FirstOrDefault(); var PaymentId = (from o in obj.Payments where o.TransactionId == TransactionId select o.id).FirstOrDefault(); var AccountId = (from o in obj.PaymentLines where o.PaymentId == Convert.ToInt32(PaymentId) select o.BankId).FirstOrDefault(); var DataPaymentLine = from o in obj.PaymentLines where o.PaymentId == Convert.ToInt32(PaymentId) select o; //deleting Payment lines foreach (var item in DataPaymentLine) { obj.PaymentLines.DeleteOnSubmit(item); } obj.SubmitChanges(); //deleting Payments Classes.CPayment cp = new CPayment(); Models.MPayments mp = new Models.MPayments(); mp.id = Convert.ToInt32(PaymentId); cp.Delete(mp); Classes.CInventory ci = new CInventory(); List <Models.MInventory> Inventory = new List <Models.MInventory>(); Inventory = ci.GetAll(); switch (TransactionType.ToString()) { case "Addition": { Classes.CBankOfAccount cb = new CBankOfAccount(); if (AccountId != null) { //Reverting Account float OldTotal = cb.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)); float NewTotal = OldTotal + Convert.ToSingle(AmountPaid); cb.SetNewAccountTotal(Convert.ToInt32(AccountId), NewTotal); //Add Revert Account Transaction Classes.CAccountTransaction cat = new CAccountTransaction(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); mat.AccountId = AccountId.ToString(); mat.Credit = AmountPaid.ToString(); mat.Debit = "0"; mat.Description = "Reverted Purchase Transaction"; mat.eDate = DateTime.Now; mat.FiscalYearId = (from o in obj.AccountTransactions where o.CurrentTransaction == TransactionId.ToString() select o.FiscalYearId.ToString()).FirstOrDefault(); mat.Total = cb.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)).ToString(); mat.Transactiontype = "Credit"; cat.Save(mat); } //Reverting Inventory float oldUnits = (from o in Inventory where o.ProductId == (ProductId).ToString() select Convert.ToSingle(o.Quantity)).FirstOrDefault(); float newUnits = oldUnits - Convert.ToSingle(Units); var query = from o in obj.Inventories where o.ProductId == Convert.ToInt32(ProductId) select o; foreach (var item in query) { item.Quantity = newUnits.ToString(); } obj.SubmitChanges(); //deletin Transaction var transactions = from o in obj.Transaction1s where o.id == TransactionId select o; foreach (var item in transactions) { obj.Transaction1s.DeleteOnSubmit(item); } obj.SubmitChanges(); break; } case "Deduction": { Classes.CBankOfAccount cb = new CBankOfAccount(); if (AccountId != null) { //Reverting Account float OldTotal = cb.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)); float NewTotal = OldTotal - Convert.ToSingle(AmountPaid); cb.SetNewAccountTotal(Convert.ToInt32(AccountId), NewTotal); //Add Revert Account Transaction Classes.CAccountTransaction cat = new CAccountTransaction(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); mat.AccountId = AccountId.ToString(); mat.Credit = "0"; mat.Debit = AmountPaid.ToString(); mat.Description = "Reverted Sale Transaction"; mat.eDate = DateTime.Now; mat.FiscalYearId = (from o in obj.AccountTransactions where o.CurrentTransaction == TransactionId.ToString() select o.FiscalYearId.ToString()).FirstOrDefault(); mat.Total = cb.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)).ToString(); mat.Transactiontype = "Credit"; cat.Save(mat); } //Reverting Inventory float oldUnits = (from o in Inventory where o.ProductId == (ProductId).ToString() select Convert.ToSingle(o.Quantity)).FirstOrDefault(); float newUnits = oldUnits + Convert.ToSingle(Units); var query = from o in obj.Inventories where o.ProductId == Convert.ToInt32(ProductId) select o; foreach (var item in query) { item.Quantity = newUnits.ToString(); } obj.SubmitChanges(); //deletin Transaction var transactions = from o in obj.Transaction1s where o.id == TransactionId select o; foreach (var item in transactions) { obj.Transaction1s.DeleteOnSubmit(item); } obj.SubmitChanges(); break; } default: break; } return(1); } catch { return(-1); } }
private int ProcessPayments(string PaymentId, string OrderId, string totalCost, string CurrentAmountPaid, string AccountId, float AmountRemaining, string RemainingAmount, string DatePaid, string Type, string Cheque) { if (Page.IsValid) { Classes.CBankOfAccount cba = new Classes.CBankOfAccount(); Classes.CAccountTransaction cat = new Classes.CAccountTransaction(); Classes.CCashAccount cha = new Classes.CCashAccount(); Classes.CCashTransaction cht = new Classes.CCashTransaction(); Classes.CPayment cp = new Classes.CPayment(); Classes.CPaymentLine cpl = new Classes.CPaymentLine(); Classes.CSaleTransations cs = new Classes.CSaleTransations(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); Models.MPayments mp = new Models.MPayments(); Models.PaymentLine mpl = new Models.PaymentLine(); Models.MCashTransactions mht = new Models.MCashTransactions(); Models.MCashAccount mha = new Models.MCashAccount(); #region Payments mp.Paid = (Convert.ToSingle(totalCost) - AmountRemaining).ToString(); if (cp.UpdateAmountPaid(Convert.ToInt32(PaymentId), mp.Paid) < 0) { return(-1); } #endregion #region PaymentLine mpl.PaymentId = Convert.ToInt32(PaymentId); mpl.BankId = Convert.ToInt32(AccountId); mpl.Date = DatePaid; mpl.PaidAmount = CurrentAmountPaid; mpl.RemainingAmount = RemainingAmount; mpl.CumulativeAmount = (Convert.ToSingle(cpl.LastPaidAmount(mpl.PaymentId)) + Convert.ToSingle(CurrentAmountPaid)).ToString(); int OptionValue = Convert.ToInt32(ddlOption.SelectedValue); mpl.Cheque = Cheque; switch (OptionValue) { case -1: { return(-1); } case 1: { #region Account Transactions mpl.ModeOfPayment = Common.Constants.ModeOfPayment.Cheque.ToString(); float AccountTotal = cba.ReturnTotalOfAccountById(Convert.ToInt32(AccountId)); mat.AccountId = AccountId; if (Type.Contains("Vendor")) { mat.Description = "Payment Of Order Id[" + OrderId + "] Paid, Amount [" + CurrentAmountPaid + "]"; mat.Debit = CurrentAmountPaid; mat.Credit = "0"; mat.Total = (AccountTotal - Convert.ToSingle(CurrentAmountPaid)).ToString(); mat.CurrentTransaction = cs.GetIdByOrderId(Convert.ToInt32(OrderId)).ToString(); mat.Transactiontype = "Debit"; mat.FiscalYearId = Session["FiscalYear"].ToString(); mat.eDate = Convert.ToDateTime(DatePaid); } else if (Type.Contains("Client")) { mat.Description = "Payment Of Order Id[" + OrderId + "] Recieved, Amount [" + CurrentAmountPaid + "]"; mat.Debit = "0"; mat.Credit = CurrentAmountPaid; mat.CurrentTransaction = cs.GetIdByOrderId(Convert.ToInt32(OrderId)).ToString(); mat.Total = (AccountTotal + Convert.ToSingle(CurrentAmountPaid)).ToString(); mat.Transactiontype = "Credit"; mat.FiscalYearId = Session["FiscalYear"].ToString(); mat.eDate = Convert.ToDateTime(DatePaid); } else { return(-3); } if (cat.Save(mat) < 0) { return(-4); } if (cba.SetNewAccountTotal(Convert.ToInt32(AccountId), Convert.ToSingle(mat.Total)) < 0) { return(-5); } #endregion break; } case 2: { #region Cash Transaction mpl.ModeOfPayment = Common.Constants.ModeOfPayment.Cash.ToString(); mpl.Cheque = "-"; float AccountTotal = cha.ReturnTotalOfCashAccount(Convert.ToInt32(AccountId)); mht.CashAccountId = Convert.ToInt32(AccountId); if (Type.Contains("Vendor")) { mht.Credit = "0"; mht.Debit = CurrentAmountPaid; mht.Description = "Payment Of Order Id[" + OrderId + "] Paid, Amount [" + CurrentAmountPaid + "]"; mht.eDate = (DatePaid); mht.FiscalYearId = Convert.ToInt32(Session["FiscalYear"].ToString()); mht.OrderId = Convert.ToInt32(OrderId); mht.Total = totalCost; mht.TransactionId = -1; mht.TransactionType = "Debit"; mht.UserId = Session["User"].ToString(); mht.WareHouseId = Convert.ToInt32(Session["WareHouse"].ToString()); } else if (Type.Contains("Client")) { mht.Credit = CurrentAmountPaid; mht.Debit = "0"; mht.Description = "Payment Of Order Id[" + OrderId + "] Recieved, Amount [" + CurrentAmountPaid + "]"; mht.eDate = (DatePaid); mht.FiscalYearId = Convert.ToInt32(Session["FiscalYear"].ToString()); mht.OrderId = Convert.ToInt32(OrderId); mht.Total = totalCost; mht.TransactionId = -1; mht.TransactionType = "Debit"; mht.UserId = Session["User"].ToString(); mht.WareHouseId = Convert.ToInt32(Session["WareHouse"].ToString()); } else { return(-3); } if (cht.Save(mht) < 0) { return(-4); } if (cha.SetNewAccountTotal(Convert.ToInt32(AccountId), Convert.ToSingle(mat.Total)) < 0) { return(-5); } #endregion break; } default: return(-1); } if (cpl.Save(mpl) < 0) { return(-2); } #endregion #region Accounts if (Convert.ToSingle(mp.Paid) > 0) { if (Type == "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 = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); 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 = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); } else if (Type == "Client") { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.CostOfGoodsSold).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); 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.AccountsRecievalbes).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Sales).ToString(); mj.amount = mp.Paid; mj.des = "Payment Recieved of Order id [" + OrderId + "]"; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); } } #endregion } lblSalesAmountRemaining.Text = AmountRemaining.ToString(); lblSalesAmountPaid.Text = (Convert.ToSingle(totalCost) - AmountRemaining).ToString(); return(1); }
private int SavePaymentOfEmployee() { int AccountId = Convert.ToInt32(ddlAccount.SelectedValue); int CashAccountId = Convert.ToInt32(ddlCashAccount.SelectedValue); string EmployeeId = ddlEmployee.SelectedValue; string MonthPaid = txtMonth.Text; string SalaryId = Session["WareHouse"].ToString(); string Paid = txtPaidAmount.Text; string DatePaid = txtDateOfPayment.Text; Classes.CPaidSalary cp = new Classes.CPaidSalary(); Models.MPaidSalary mp = new Models.MPaidSalary(); mp.EmployeeId = EmployeeId; mp.MonthPaid = MonthPaid; mp.Paid = Paid; mp.SalaryId = SalaryId; mp.DatePaid = DatePaid; int option = Convert.ToInt32(ddlOption.SelectedValue); if (option < 1) { return(-4); } if (cp.Save(mp) > 0) { switch (option) { case 1: { Classes.CBankOfAccount cab = new Classes.CBankOfAccount(); Classes.CAccountTransaction cat = new Classes.CAccountTransaction(); Models.MAccountTransaction mat = new Models.MAccountTransaction(); float AccountTotal = cab.ReturnTotalOfAccountById(AccountId); AccountTotal = AccountTotal - Convert.ToSingle(Paid); if (cab.SetNewAccountTotal(AccountId, AccountTotal) > 0) { // float PreviousAccountTotal = cab.ReturnTotalOfAccountById(AccountId); mat.AccountId = AccountId.ToString(); mat.Credit = "0"; mat.CurrentTransaction = "-1"; mat.Debit = Paid; mat.Description = "Paid Salary for the month of [" + MonthPaid + "] to " + "Employee[" + ddlEmployee.SelectedItem.Text + "] Amount [" + Paid + "]"; mat.eDate = Convert.ToDateTime(DatePaid); mat.FiscalYearId = Convert.ToInt32(Session["FiscalYear"]).ToString(); // PreviousAccountTotal = PreviousAccountTotal - Convert.ToSingle(Paid); mat.Total = AccountTotal.ToString(); if (cat.Save(mat) > 0) { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.SalaryExpense).ToString(); mj.amount = mp.Paid; mj.des = "Payment of Employee [" + ddlEmployee.SelectedItem.Text + "] "; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash).ToString(); mj.amount = mp.Paid; mj.des = "Payment of Employee [" + ddlEmployee.SelectedItem.Text + "] "; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); return(1); } else { return(-3); } } else { return(-2); } } case 2: { Classes.CCashAccount cab = new Classes.CCashAccount(); Classes.CCashTransaction cat = new Classes.CCashTransaction(); Models.MCashTransactions mat = new Models.MCashTransactions(); float AccountTotal = cab.ReturnTotalOfCashAccount(CashAccountId); AccountTotal = AccountTotal - Convert.ToSingle(Paid); if (cab.SetNewAccountTotal(CashAccountId, AccountTotal) > 0) { // float PreviousAccountTotal = cab.ReturnTotalOfAccountById(AccountId); mat.CashAccountId = CashAccountId; mat.Credit = "0"; mat.Debit = Paid; mat.Description = "Paid Salary for the month of [" + MonthPaid + "] to " + "Employee[" + ddlEmployee.SelectedItem.Text + "] Amount [" + Paid + "]"; if (cat.Save(mat) > 0) { Classes.CJournal cj = new Classes.CJournal(); Models.MJournal mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.SalaryExpense).ToString(); mj.amount = mp.Paid; mj.des = "Payment of Employee [" + ddlEmployee.SelectedItem.Text + "] "; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Debit.ToString(); cj.Save(mj); mj = new Models.MJournal(); mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash).ToString(); mj.amount = mp.Paid; mj.des = "Payment of Employee [" + ddlEmployee.SelectedItem.Text + "] "; mj.e_date = (DatePaid); mj.type = Common.Constants.Accounts.Type.Credit.ToString(); cj.Save(mj); return(1); } else { return(-3); } } else { return(-2); } } default: return(-5); } } else { 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 { } }