public ActionResult CashPayment() { CashPayement model = new CashPayement(); bool Exists = db.Voucher_Entry_Credit.Any(c => c.voucher_type.Equals("CashPayment")); if (Exists == true && db.Voucher_Entry_Credit.Select(p => p.record_no).Count() > 0) { var id = (from n in db.Voucher_Entry_Credit.Where(x => x.voucher_type == "CashPayment") select n.record_no).Max(); int recno = Convert.ToInt32(id) + 1; model.RecordNo = recno.ToString(); } else { model.RecordNo = "1"; } return(View(model)); }
public ActionResult CashPaymentBill(CashPayement model) { try { int CurrentYear = DateTime.Today.Year; int PreviousYear = DateTime.Today.Year - 1; int NextYear = DateTime.Today.Year + 1; string PreYear = PreviousYear.ToString(); string NexYear = NextYear.ToString(); string CurYear = CurrentYear.ToString(); string FinYear = null; if (DateTime.Today.Month > 3) { FinYear = CurYear + "-" + NexYear; } else { FinYear = PreYear + "-" + CurYear; } for (int i = 0; i < model.ByAccount.Length; i++) { Voucher_Entry_Debit tb1 = new Voucher_Entry_Debit(); tb1.voucher_no = model.VoucherNo; tb1.voucher_date = model.Date; tb1.record_no = model.RecordNo.ToString(); tb1.record_date = model.Date; tb1.voucher_sno = i + 1; tb1.voucher_tb = "By"; tb1.voucher_type = "CashPayment"; tb1.voucher_year = FinYear; tb1.from_form_name = "CashPayment"; tb1.userid = WebSecurity.CurrentUserId; tb1.account_type = "CashPayment"; tb1.from_form_id = 0; string accountname = model.ByAccount[i]; var idl = (from n in db.tblLedgerMasters.Where(x => x.LedgerName == accountname) select n.LedgerMasterId).SingleOrDefault(); tb1.voucher_ledger_accout_id = Convert.ToInt32(idl); tb1.voucher_dbt_amount = model.DrAmount[i]; tb1.voucher_narration = model.DrNarration[i]; tb1.purchase_id = model.PurchaseId[i]; tb1.create_date = DateTime.Now; db.Voucher_Entry_Debit.Add(tb1); db.SaveChanges(); } for (int j = 0; j < model.LedgerAccId.Length; j++) { Voucher_Entry_Credit tb = new Voucher_Entry_Credit(); tb.voucher_no = model.VoucherNo; tb.Voucher_date = model.Date; tb.record_no = model.RecordNo.ToString(); tb.record_date = model.Date; tb.voucher_sno = j + 1; tb.voucher_tb = "To"; tb.voucher_type = "CashPayment"; tb.voucher_year = FinYear; tb.from_form_name = "CashPayment"; tb.userid = WebSecurity.CurrentUserId; tb.account_type = "CashPayment"; tb.from_form_id = 0; string name = model.LedgerAccId[j]; var id = (from n in db.tblLedgerMasters.Where(x => x.LedgerName == name) select n.LedgerMasterId).SingleOrDefault(); tb.voucher_ledger_accout_id = Convert.ToInt32(id); tb.voucher_cr_amount = model.CreditAmount[j]; tb.voucher_narration = model.CrNarration[j]; //tb.purchase_id = model.PurchaseId[j]; tb.create_date = DateTime.Now; db.Voucher_Entry_Credit.Add(tb); db.SaveChanges(); } TempData["Perror"] = "Inserted Successfully !"; return(View("CashPayment")); } catch (Exception ex) { //return View(ex); TempData["Perror"] = "Please Enter the Details Correctlly !"; return(RedirectToAction("CashPayment")); } }