public ActionResult EditCredit(int id = 0) { TBCREDIT obj = dbContext.TBCREDITs.Where(x => x.CreditID == id).FirstOrDefault(); if (obj == null) { return(HttpNotFound()); } ViewBag.AccountMasterList = GetAccountMaster(); ViewBag.HeadCodeList = GetPurchaseHeaderDebit(); ViewBag.creditList = dbContext.TBCREDITs.ToList(); return(View("Credit", obj)); }
public ActionResult CHQPaymentSaveChanges(TBCHQPAYMENT obj) { if (obj.SerialNo > 0) { TBCHQPAYMENT objbrand = dbContext.TBCHQPAYMENTs.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 { TBCHQPAYMENT objCHQPayment = JsonConvert.DeserializeObject <TBCHQPAYMENT>(JsonConvert.SerializeObject(obj)); dbContext.TBCHQPAYMENTs.Add(objCHQPayment); dbContext.SaveChanges(); var id = dbContext.TBCHQPAYMENTs.OrderByDescending(x => x.SerialNo).FirstOrDefault(); TBDEBIT objDebit = new TBDEBIT(); objDebit.FNEntryCode = Convert.ToInt32(id.SerialNo); objDebit.STType = "CHQPA"; objDebit.HeadCode = Convert.ToInt32(id.CustomerHead); objDebit.FNAmount = obj.Amount; objDebit.FNDate = Convert.ToDateTime("1-4-2016"); objDebit.Description = "CHEQUE PAYMENT AGAINST " + obj.Voucher + " " + obj.Narration; dbContext.TBDEBITs.Add(objDebit); dbContext.SaveChanges(); TBCREDIT objCredit = new TBCREDIT(); objCredit.FNEntryCode = Convert.ToInt32(id.SerialNo); objCredit.STType = "CHQPA"; objCredit.HeadCode = Convert.ToInt32(id.AccountHeadCode); objCredit.FDAmount = obj.Amount; objCredit.FDDate = Convert.ToDateTime("1-4-2016"); objCredit.Description = "CHEQUE PAYMENT AGAINST " + obj.Voucher + " " + obj.Narration; dbContext.TBCREDITs.Add(objCredit); dbContext.SaveChanges(); ViewBag.savemsg = "Saved Successfully!"; ViewBag.AccountHeadCodeList = GetAccountHeadCode(); ViewBag.CustomerHeadList = GetCustomerHead(); ViewBag.CHQPaymentList = dbContext.TBCHQPAYMENTs.ToList(); } return(View("CHQPayment")); }
public ActionResult CreditSaveChanges(TBCREDIT obj) { if (obj.CreditID > 0) { TBCREDIT objbrand = dbContext.TBCREDITs.Where(x => x.CreditID == obj.CreditID).FirstOrDefault(); objbrand.FNEntryCode = obj.FNEntryCode; objbrand.STType = obj.STType; objbrand.HeadCode = obj.HeadCode; objbrand.FDAmount = obj.FDAmount; objbrand.FDDate = obj.FDDate; objbrand.Description = obj.Description; } else { dbContext.TBCREDITs.Add(obj); } dbContext.SaveChanges(); return(RedirectToAction("Credit")); }
public ActionResult AccountMasterSaveChanges(AcountMasterVM obj) { if (obj.ACCOUNTNAME != null) { if (obj.ACCOUNTID > 0) { TBACCOUNTMASTER objbrand = dbContext.TBACCOUNTMASTERs.Where(x => x.ACCOUNTID == obj.ACCOUNTID).FirstOrDefault(); objbrand.ACCOUNTTYPEID = obj.ACCOUNTTYPEID; objbrand.ACCOUNTNAME = obj.ACCOUNTNAME; objbrand.ADDRESS1 = obj.ADDRESS1; objbrand.ADDRESS2 = obj.ADDRESS2; objbrand.ADDRESS3 = obj.ADDRESS3; objbrand.BSIDPOSITIVE = obj.BSIDPOSITIVE; objbrand.BSIDNEGATIVE = obj.BSIDNEGATIVE; objbrand.EMAIL = obj.EMAIL; objbrand.MOBILENO = obj.MOBILENO; objbrand.OPENING_BALANCE = obj.OPENING_BALANCE; objbrand.OPENINGTYPE = obj.OPENINGTYPE; objbrand.TINNO = obj.TINNO; } else { TBACCOUNTMASTER objTBACCOUNTMASTER = JsonConvert.DeserializeObject <TBACCOUNTMASTER>(JsonConvert.SerializeObject(obj)); dbContext.TBACCOUNTMASTERs.Add(objTBACCOUNTMASTER); dbContext.SaveChanges(); var id = dbContext.TBACCOUNTMASTERs.OrderByDescending(x => x.ACCOUNTID).FirstOrDefault(); if (obj.OPENINGTYPE == "0") { TBDEBIT objDebit = new TBDEBIT(); objDebit.FNEntryCode = Convert.ToInt32(id.ACCOUNTID); objDebit.STType = "OPENI"; objDebit.HeadCode = Convert.ToInt32(id.ACCOUNTID); objDebit.FNAmount = obj.OPENING_BALANCE; objDebit.FNDate = Convert.ToDateTime("1-4-2016"); objDebit.Description = "OPENING BALANCE AGAINST " + obj.ACCOUNTNAME; dbContext.TBDEBITs.Add(objDebit); dbContext.SaveChanges(); } else { TBCREDIT objCredit = new TBCREDIT(); objCredit.FNEntryCode = Convert.ToInt32(id.ACCOUNTID); objCredit.STType = "OPENI"; objCredit.HeadCode = Convert.ToInt32(id.ACCOUNTID); objCredit.FDAmount = obj.OPENING_BALANCE; objCredit.FDDate = Convert.ToDateTime("1-4-2016"); objCredit.Description = "OPENING BALANCE AGAINST " + obj.ACCOUNTNAME; dbContext.TBCREDITs.Add(objCredit); dbContext.SaveChanges(); } } } else { ViewBag.accountTypeList = GetAccountType(); ViewBag.BSPositiveList = GetBSGroupPositive(); ViewBag.BSNegativeList = GetBSGroupNegative(); ViewBag.AccountList = dbContext.TBACCOUNTMASTERs.ToList(); return(View("AccountMaster", obj)); } return(RedirectToAction("AccountMaster")); }
public ActionResult PurchaseHeaderSaveChanges(PurachaseDeatil obj) { TBPURCHASEHEADER objTBPURCHASEHEADER = new TBPURCHASEHEADER(); TBPURCHASEDETAIL objTBPURCHASEDETAIL = new TBPURCHASEDETAIL(); if (obj.PurchaseId > 0) { TBPURCHASEHEADER objbrand = dbContext.TBPURCHASEHEADERs.Where(x => x.PurchaseId == obj.PurchaseId).FirstOrDefault(); objbrand.PurDate = obj.PurDate; objbrand.BillDate = obj.BillDate; objbrand.BillNo = obj.BillNo; objbrand.PaymentMode = obj.PaymentMode; objbrand.ACCOUNTID = obj.ACCOUNTID; objbrand.CustomerId = obj.CustomerId; dbContext.SaveChanges(); } else { objTBPURCHASEHEADER.PurDate = obj.PurDate; objTBPURCHASEHEADER.BillDate = obj.BillDate; objTBPURCHASEHEADER.BillNo = obj.BillNo; objTBPURCHASEHEADER.PaymentMode = obj.PaymentMode; objTBPURCHASEHEADER.ACCOUNTID = obj.ACCOUNTID; objTBPURCHASEHEADER.CustomerId = obj.CustomerId; dbContext.TBPURCHASEHEADERs.Add(objTBPURCHASEHEADER); dbContext.SaveChanges(); decimal grandtotal = 0; var ids = dbContext.TBPURCHASEHEADERs.OrderByDescending(p => p.PurchaseId).FirstOrDefault(); if (ids.PurchaseId > 0) { foreach (var item in obj.purachasedetail) { TBITEMMASTERHEADER objTBITEMMASTERHEADER = dbContext.TBITEMMASTERHEADERs.Where(x => x.ITEMID == item.ItemID).FirstOrDefault(); TBTAXCONFIG objtbtaxconfig = dbContext.TBTAXCONFIGs.Where(x => x.TAXID == objTBITEMMASTERHEADER.PURTAXID).FirstOrDefault(); item.Tax2 = objtbtaxconfig.TAX2_; item.Tax3 = objtbtaxconfig.TAX3_; item.SurCharge = objtbtaxconfig.SURONTAX3; objTBPURCHASEDETAIL.ItemID = item.ItemID; objTBPURCHASEDETAIL.SizeID = item.SizeID; objTBPURCHASEDETAIL.PurchaseId = ids.PurchaseId; objTBPURCHASEDETAIL.Quantity = item.Quantity; objTBPURCHASEDETAIL.BaseRate = item.BaseRate; objTBPURCHASEDETAIL.PurchaseRate = item.PurchaseRate; objTBPURCHASEDETAIL.SaleRate = item.SaleRate; objTBPURCHASEDETAIL.MRP = item.MRP; objTBPURCHASEDETAIL.GAmount = item.GAmount; objTBPURCHASEDETAIL.Cd = item.Cd; objTBPURCHASEDETAIL.Td = item.Td == null?0:item.Td; objTBPURCHASEDETAIL.TdVal = item.TdVal == null ? 0 : item.TdVal; objTBPURCHASEDETAIL.Tax1 = item.Tax1 == null ? 0 : item.Tax1; objTBPURCHASEDETAIL.Tax1Val = item.Tax1Val == null ? 0 : item.Tax1Val; // objbrand.CdVal = obj.CdVal; decimal gAmount = Convert.ToDecimal(item.GAmount); decimal cd = Convert.ToDecimal(item.Cd); decimal cdval = (cd * gAmount / 100); decimal netamount = gAmount - cdval; decimal grosscd = netamount; objTBPURCHASEDETAIL.CdVal = cdval; objTBPURCHASEDETAIL.TdVal = item.TdVal; objTBPURCHASEDETAIL.Tax1 = item.Tax1; objTBPURCHASEDETAIL.Tax2 = item.Tax2; decimal tax2 = Convert.ToDecimal(item.Tax2); decimal tax2val = (netamount * tax2) / (100 + tax2); netamount = netamount - tax2val; objTBPURCHASEDETAIL.Tax3 = item.Tax3; decimal tax3 = Convert.ToDecimal(item.Tax3); decimal tax3val = (netamount * tax3) / 100; netamount = netamount + tax3val; decimal SurCharge = Convert.ToDecimal(item.SurCharge); decimal surcharegeval = (tax3val * SurCharge) / 100; netamount = netamount + surcharegeval; //objTBPURCHASEDETAIL.Tax1Val = tax2; objTBPURCHASEDETAIL.Tax2Val = tax2val; objTBPURCHASEDETAIL.Tax3Val = tax3val; objTBPURCHASEDETAIL.NetAmount = netamount; objTBPURCHASEDETAIL.PurchaseAC = objtbtaxconfig.SALE_PURACCOUNT; objTBPURCHASEDETAIL.PurchaseTaxAc = objtbtaxconfig.SALES_PURTAXACCOUNT; objTBPURCHASEDETAIL.SurChargeAC = objtbtaxconfig.SURCHARGEACCOUNT; objTBPURCHASEDETAIL.Tax1AC = objtbtaxconfig.TAX1ACCOUNT; objTBPURCHASEDETAIL.Tax2AC = objtbtaxconfig.TAX2ACCOUNT; objTBPURCHASEDETAIL.SurCharge = SurCharge; objTBPURCHASEDETAIL.SurChargeVal = surcharegeval; grandtotal += netamount; dbContext.TBPURCHASEDETAILS.Add(objTBPURCHASEDETAIL); dbContext.SaveChanges(); TBSTOCK objstock = new TBSTOCK(); objstock.ItemId = item.ItemID; objstock.SizeId = item.SizeID; objstock.STType = "PUR"; objstock.EntryCode = ids.PurchaseId; objstock.FDDate = obj.PurDate; objstock.Quantity = item.Quantity; dbContext.TBSTOCKs.Add(objstock); dbContext.SaveChanges(); //Tax2 account if (tax2val != 0) { TBDEBIT objDebit = new TBDEBIT(); objDebit.FNEntryCode = Convert.ToInt32(ids.PurchaseId); objDebit.STType = "PUR"; objDebit.HeadCode = Convert.ToInt32(objtbtaxconfig.TAX2ACCOUNT); objDebit.FNAmount = tax2val; objDebit.FNDate = obj.PurDate; objDebit.Description = "PURCHASE TAX2 AGAINST " + obj.BillNo; dbContext.TBDEBITs.Add(objDebit); dbContext.SaveChanges(); } //Tax3 account if (tax3val != 0) { TBDEBIT objDebit2 = new TBDEBIT(); objDebit2.FNEntryCode = Convert.ToInt32(ids.PurchaseId); objDebit2.STType = "PUR"; objDebit2.HeadCode = Convert.ToInt32(objtbtaxconfig.SALES_PURTAXACCOUNT); //NEDD TO DISCUSS objDebit2.FNAmount = tax3val; objDebit2.FNDate = obj.PurDate; objDebit2.Description = "PURCHASE TAX3 AGAINST " + obj.BillNo; dbContext.TBDEBITs.Add(objDebit2); dbContext.SaveChanges(); } //Surcharge account if (surcharegeval != 0) { TBDEBIT objDebit3 = new TBDEBIT(); objDebit3.FNEntryCode = Convert.ToInt32(ids.PurchaseId); objDebit3.STType = "PUR"; objDebit3.HeadCode = Convert.ToInt32(objtbtaxconfig.SURCHARGEACCOUNT); objDebit3.FNAmount = surcharegeval; objDebit3.FNDate = obj.PurDate; objDebit3.Description = "PURCHASE SURCHARGE AGAINST " + obj.BillNo; dbContext.TBDEBITs.Add(objDebit3); dbContext.SaveChanges(); } //PURCHASE account if (grosscd != 0) { TBDEBIT objDebit4 = new TBDEBIT(); objDebit4.FNEntryCode = Convert.ToInt32(ids.PurchaseId); objDebit4.STType = "PUR"; objDebit4.HeadCode = Convert.ToInt32(objtbtaxconfig.SALE_PURACCOUNT); objDebit4.FNAmount = grosscd; objDebit4.FNDate = obj.PurDate; objDebit4.Description = "PURCHASE AGAINST " + obj.BillNo; dbContext.TBDEBITs.Add(objDebit4); dbContext.SaveChanges(); } } TBCREDIT objCredit = new TBCREDIT(); objCredit.FNEntryCode = Convert.ToInt32(ids.PurchaseId); objCredit.STType = "PUR"; objCredit.HeadCode = Convert.ToInt32(obj.ACCOUNTID); objCredit.FDAmount = grandtotal; objCredit.FDDate = obj.PurDate; objCredit.Description = "PURCHASE AGAINST " + obj.BillNo; dbContext.TBCREDITs.Add(objCredit); dbContext.SaveChanges(); TBPURCHASEHEADER objTBPURCHASEHEADERs = new TBPURCHASEHEADER(); objTBPURCHASEHEADERs = dbContext.TBPURCHASEHEADERs.Where(x => x.PurchaseId == ids.PurchaseId).FirstOrDefault(); objTBPURCHASEHEADERs.BillAmount = grandtotal; dbContext.SaveChanges(); } } return(RedirectToAction("PurchaseHeader")); }