public ActionResult mergeAndSendToAcoount(int OrgId) { BalanceStatement BSObj = new BalanceStatement(); Commission CommissionLastrecord = Commission.GetAllCommissions().Where(w => w.OrgId == OrgId).Last(); Sale SaleLastrecord = Sale.GetAllSales().Where(w => w.OrgId == OrgId).Last(); BSObj.Narration = "Online Payment received Entry No." + SaleLastrecord.EntryNo; BSObj.CRAmount = SaleLastrecord.SaleAmount; BalanceStatement TotalBalance = BalanceStatement.GetAllForBalanceCalculation(OrgId).Last(); BSObj.Balance = TotalBalance.Balance - BSObj.CRAmount; BSObj.Date = DateTime.Now; BSObj.OrgId = OrgId; BSObj.EntryNo = SaleLastrecord.EntryNo; BSObj.SaveOpeningValue(); BalanceStatement Obj = new BalanceStatement(); Obj.Narration = "Commission Invoice No." + CommissionLastrecord.EntryNo; Obj.Amount = CommissionLastrecord.CommissionAmount; BalanceStatement TotalBalances = BalanceStatement.GetAllForBalanceCalculation(OrgId).Last(); Obj.Balance = TotalBalances.Balance + Obj.Amount; Obj.Date = DateTime.Now; Obj.OrgId = OrgId; Obj.EntryNo = CommissionLastrecord.EntryNo; Obj.SaveOpeningValue(); return(Json(new { data = BSObj }, JsonRequestBehavior.AllowGet)); }
public ActionResult EntryToAccount(int OrgId) { Accounts Obj = new Accounts(); Accounts AObj = new Accounts(); Accounts AObj1 = new Accounts(); Accounts ADObj = new Accounts(); List <Accounts> ADObjList = new List <Accounts>(); Commission AllCommissions = Commission.GetAllCommissions().Where(w => w.OrgId == OrgId).Last(); BalanceStatement LastRecords = BalanceStatement.GetAllForBalanceCalculation(OrgId).Last(); BalanceStatement FirstRecords = BalanceStatement.GetAllForBalanceCalculation(OrgId).Where(w => w.Narration == "Opening Balance").Last(); Sale AllSales = Sale.GetAllSales().Where(w => w.OrgId == OrgId).Last(); Accounts FirstAccountRecords = Accounts.GetAll().Where(w => w.Narration == "Opening Balance").FirstOrDefault(); if (FirstAccountRecords == null) { Obj.Date = FirstRecords.Date; Obj.Narration = "Opening Balance"; Obj.AOrgId = OrgId; if (AllSales == null) { Obj.DRAmount = 0.00; } else { Obj.DRAmount = LastRecords.Balance; } Obj.SaveGeneral(); } AObj.DRAmount = AllSales.SaleAmount; AObj.Narration = "Online Payment received Entry No." + AllSales.EntryNo; AObj.Balance = AllSales.SaleAmount; AObj.Date = DateTime.Now; AObj.AOrgId = OrgId; AObj.SaveGeneral(); //=============================================== HG_OrganizationDetails Objitem = new HG_OrganizationDetails(); HG_OrganizationDetails State = Objitem.GetAll(OrgId).FirstOrDefault(); Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.DebtorType == 1 && x.OrgId == OrgId).FirstOrDefault(); AObj1.CRAmount = AllCommissions.CommissionAmount; AObj1.Narration = "Commission Invoice No." + AllCommissions.EntryNo; AObj1.Balance = AllSales.SaleAmount - AllCommissions.CommissionAmount; AObj1.Date = DateTime.Now; AObj1.AOrgId = OrgId; // entry to Account Details if (State.State == "17") { for (int i = 1; i <= 2; i++) { ADObj = new Accounts(); if (i == 1) { ADObj.ADDate = DateTime.Now; ADObj.ADAmount = AllCommissions.CommissionAmount * (LedgerDetails.TaxOnAboveMargin / 2) / 100; ADObj.CRLedgerId = 13; ADObj.ADGroupId = 3; ADObj.AOrgId = OrgId; ADObjList.Add(ADObj); } else if (i == 2) { ADObj.ADDate = DateTime.Now; ADObj.ADAmount = AllCommissions.CommissionAmount * (LedgerDetails.TaxOnAboveMargin / 2) / 100; ADObj.CRLedgerId = 17; ADObj.ADGroupId = 3; ADObj.AOrgId = OrgId; ADObjList.Add(ADObj); } } } else { ADObj.ADDate = DateTime.Now; ADObj.ADAmount = (AllCommissions.CommissionAmount * LedgerDetails.TaxOnAboveMargin) / 100; ADObj.CRLedgerId = 21; ADObj.ADGroupId = 3; ADObj.AOrgId = OrgId; ADObjList.Add(ADObj); } //============================= AObj1.Save(ADObjList); return(Json(new { data = AllCommissions }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetAllCommission(int OrgId) { // Sale table objects// Sale SObj = new Sale(); Sale S1Obj = new Sale(); //======================// // Commission table objects// Commission CObj = new Commission(); Commission CMObj = new Commission(); //================================== int LastEntry = 0; int LastSaleEntry = 0; double totalAmount = 0.00; double TotalSale = 0.00; double TotalTaxOnCommission = 0.00; List <BalanceStatement> GetRecords = new List <BalanceStatement>(); BalanceStatement FindLastEntryNo = new BalanceStatement(); try { FindLastEntryNo = BalanceStatement.GetAllForBalanceCalculation(OrgId) .Where(w => w.EntryNo > 0 && w.Narration.Contains("Commission Invoice No.")).Last(); } catch (Exception ex) { ex.ToString(); } if (FindLastEntryNo.EntryNo == 0) { GetRecords = BalanceStatement.GetAllForBalanceCalculation(OrgId); } else { GetRecords = BalanceStatement.GetAllForBalanceCalculation(OrgId).Where(w => w.BID > FindLastEntryNo.BID).ToList(); } if (GetRecords != null) { BalanceStatement LastRecords = BalanceStatement.GetAllForBalanceCalculation(OrgId).Last(); Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.DebtorType == 1 && x.OrgId == OrgId).FirstOrDefault(); foreach (var data in GetRecords) { if (data.Narration != "Opening Balance") { CObj.CommissionAmount = data.CRAmount; SObj.SaleAmount = data.Amount; if (data.TaxOnCash > 0) { CObj.TaxOnCommission = (data.CRAmount * data.TaxOnCash) / 100; } if (data.TaxOnOnline > 0) { CObj.TaxOnCommission = (data.CRAmount * data.TaxOnOnline) / 100; } // CObj.BalanceStatementId = data.BID; CObj.OrgId = data.OrgId; SObj.OrgId = data.OrgId; //Save to commision table CObj.Save(); //======================// // Save to Sale Table SObj.Save(); //====================// } } //if (GetRecords.Count != 1) // used for eliminating Opening Balance entry when there is no data for next entry // { int GetLastCalculationRecord = Commission.GetAllCommissions().Where(w => w.OrgId == OrgId).Select(s => s.BalanceStatementId).Max(); int CommissionId = Commission.GetAllCommissions() .Where(w => w.BalanceStatementId == GetLastCalculationRecord && w.OrgId == OrgId).Select(s => s.CommisionId).FirstOrDefault(); if (GetLastCalculationRecord == 0) { TotalTaxOnCommission = Commission.GetAllCommissions() .Where(w => w.CommisionId >= CommissionId && w.OrgId == OrgId).Select(s => s.TaxOnCommission).Sum(); totalAmount = Commission.GetAllCommissions() .Where(w => w.CommisionId >= CommissionId && w.OrgId == OrgId).Select(s => s.CommissionAmount).Sum(); } else { TotalTaxOnCommission = Commission.GetAllCommissions() .Where(w => w.CommisionId > CommissionId && w.OrgId == OrgId).Select(s => s.TaxOnCommission).Sum(); totalAmount = Commission.GetAllCommissions() .Where(w => w.CommisionId > CommissionId && w.OrgId == OrgId).Select(s => s.CommissionAmount).Sum(); } int GetMaxBID = Sale.GetAllSales().Where(w => w.OrgId == OrgId).Select(s => s.BalanceStatementId).Max(); int SaleId = Sale.GetAllSales() .Where(w => w.BalanceStatementId == GetMaxBID && w.OrgId == OrgId).Select(s => s.SaleId).FirstOrDefault(); if (GetMaxBID == 0) { TotalSale = Sale.GetAllSales().Where(w => w.SaleId >= SaleId && w.OrgId == OrgId).Select(s => s.SaleAmount).Sum(); } else { TotalSale = Sale.GetAllSales().Where(w => w.SaleId > SaleId && w.OrgId == OrgId).Select(s => s.SaleAmount).Sum(); } try { LastEntry = Commission.GetAllCommissions() .Where(w => w.EntryNo > 0 && w.OrgId == OrgId).Select(s => s.EntryNo).Max(); LastSaleEntry = Sale.GetAllSales() .Where(w => w.EntryNo > 0 && w.OrgId == OrgId).Select(s => s.EntryNo).Max(); } catch (Exception ex) { ex.ToString(); } CMObj.EntryNo = LastEntry + 1; CMObj.CommissionAmount = totalAmount; CMObj.TaxOnCommission = TotalTaxOnCommission; CMObj.BalanceStatementId = LastRecords.BID; CMObj.OrgId = LastRecords.OrgId; CMObj.Save(); S1Obj.EntryNo = LastSaleEntry + 1; S1Obj.SaleAmount = TotalSale; S1Obj.BalanceStatementId = LastRecords.BID; S1Obj.OrgId = LastRecords.OrgId; S1Obj.Save(); mergeAndSendToAcoount(LastRecords.OrgId); EntryToAccount(LastRecords.OrgId); // } } return(Json(new { data = CObj }, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int ID) { List <Ledger> LedgerList = Ledger.GetAll(); LedgerList = LedgerList.FindAll(x => x.OrgId == ID); List <BalanceStatement> BList = BalanceStatement.GetByOrgId(ID); BList = BList.FindAll(x => x.OrgId == ID); List <Commission> CommissionList = Commission.GetAllCommissions(); CommissionList = CommissionList.FindAll(x => x.OrgId == ID); List <Sale> SList = Sale.GetAllSales(); SList = SList.FindAll(x => x.OrgId == ID); List <Accounts> AccountList = Accounts.GetAll(); AccountList = AccountList.FindAll(x => x.AOrgId == ID); List <Accounts> AccountDetailsList = Accounts.GetAllDetails(); AccountList = AccountList.FindAll(x => x.ADOrgId == ID); // List<Receipt> ReceiptList = Receipt.GetAllList(ID,0); if (LedgerList != null) { int i = Ledger.Dell(ID); } if (BList != null) { int i = BalanceStatement.Dell(ID); } if (CommissionList != null) { int i = Commission.Dell(ID); } if (SList != null) { int i = Sale.Dell(ID); } if (AccountList != null) { int i = Accounts.Dell(ID); } if (AccountDetailsList != null) { int i = Accounts.DellAccountDetails(ID); } //if(ReceiptList!=null) //{ // int i = Receipt.Dell(ID); //} return(Json(new { data = "1" }, JsonRequestBehavior.AllowGet)); }