public ActionResult EditChequeReceipt(int id = 0) { TBCHEQUERECEIPT obj = dbContext.TBCHEQUERECEIPTs.Where(x => x.SerialNo == id).FirstOrDefault(); if (obj == null) { return(HttpNotFound()); } ViewBag.AccountHeadCodeList = GetAccountHeadCode(); ViewBag.CustomerHeadList = GetCustomerId(); ViewBag.ChequeReceiptList = dbContext.TBCHEQUERECEIPTs.ToList(); return(View("ChequeReceipt", obj)); }
public ActionResult ChequeReceiptSaveChanges(TBCHEQUERECEIPT obj) { if (obj.SerialNo > 0) { TBCHEQUERECEIPT objbrand = dbContext.TBCHEQUERECEIPTs.Where(x => x.SerialNo == obj.SerialNo).FirstOrDefault(); objbrand.SerialNo = obj.SerialNo; objbrand.OpeningBal = obj.OpeningBal; objbrand.Date = obj.Date; objbrand.CustomerHead = obj.CustomerHead; objbrand.Voucher = obj.Voucher; objbrand.Amount = obj.Amount; objbrand.Discount = obj.Discount; objbrand.Narration = obj.Narration; } else { TBCHEQUERECEIPT objChequeReceipt = JsonConvert.DeserializeObject <TBCHEQUERECEIPT>(JsonConvert.SerializeObject(obj)); dbContext.TBCHEQUERECEIPTs.Add(objChequeReceipt); dbContext.SaveChanges(); var id = dbContext.TBCHEQUERECEIPTs.OrderByDescending(x => x.SerialNo).FirstOrDefault(); TBDEBIT objDebit = new TBDEBIT(); objDebit.FNEntryCode = Convert.ToInt32(id.SerialNo); objDebit.STType = "CHQRE"; objDebit.HeadCode = Convert.ToInt32(id.AccountHeadCode); objDebit.FNAmount = obj.Amount; objDebit.FNDate = Convert.ToDateTime("1-4-2016"); objDebit.Description = "CHEQUE RECEIPT AGAINST " + obj.Voucher + " " + obj.Narration; dbContext.TBDEBITs.Add(objDebit); dbContext.SaveChanges(); TBCREDIT objCredit = new TBCREDIT(); objCredit.FNEntryCode = Convert.ToInt32(id.SerialNo); objCredit.STType = "CHQRE"; objCredit.HeadCode = Convert.ToInt32(id.CustomerHead); objCredit.FDAmount = obj.Amount; objCredit.FDDate = Convert.ToDateTime("1-4-2016"); objCredit.Description = "CHEQUE RECEIPT AGAINST " + obj.Voucher + " " + obj.Narration; dbContext.TBCREDITs.Add(objCredit); dbContext.SaveChanges(); ViewBag.savemsg = "Saved Successfully!"; } return(RedirectToAction("ChequeReceipt")); }