//public ActionResult PurchaseDetailSaveChanges(TBPURCHASEDETAIL obj) //{ // if (obj.PurDetailID > 0) // { // TBPURCHASEDETAIL objbrand = dbContext.TBPURCHASEDETAILS.Where(x => x.PurDetailID == obj.PurDetailID).FirstOrDefault(); // objbrand.ItemID = obj.ItemID; // objbrand.SizeID = obj.SizeID; // objbrand.Quantity = obj.Quantity; // objbrand.BaseRate = obj.BaseRate; // objbrand.PurchaseRate = obj.PurchaseRate; // objbrand.SaleRate = obj.SaleRate; // objbrand.MRP = obj.MRP; // objbrand.GAmount = obj.GAmount; // objbrand.Cd = obj.Cd; // objbrand.Td = obj.Td; // // objbrand.CdVal = obj.CdVal; // decimal gAmount = Convert.ToDecimal(obj.GAmount); // decimal cd = Convert.ToDecimal(obj.Cd); // decimal cdval = gAmount - (cd * gAmount / 100); // decimal netamount = gAmount - cdval; // objbrand.CdVal = cdval; // objbrand.TdVal = obj.TdVal; // objbrand.Tax1_ = obj.Tax1_; // objbrand.Tax2_ = obj.Tax2_; // decimal tax2 = Convert.ToDecimal(obj.Tax2_); // decimal tax2val = (netamount * tax2) / (100 + tax2); // netamount = netamount - tax2val; // objbrand.Tax3_ = obj.Tax3_; // decimal tax3 = Convert.ToDecimal(obj.Tax3_); // decimal tax3val = (netamount * tax3) / (100 + tax3); // netamount = netamount - tax3val; // objbrand.Tax1Val =tax2; // objbrand.Tax2Val = tax2val; // objbrand.Tax3Val = tax3val; // objbrand.NetAmount = netamount; // objbrand.PurchaseAC = obj.PurchaseAC; // objbrand.PurchaseTaxAc = obj.PurchaseTaxAc; // objbrand.SurChargeAC = obj.SurChargeAC; // objbrand.Tax1AC = obj.Tax1AC; // objbrand.Tax2AC = obj.Tax2AC; // } // else // { // dbContext.TBPURCHASEDETAILS.Add(obj); // } // dbContext.SaveChanges(); // return RedirectToAction("PurchaseDetail"); //} public ActionResult EditPurchaseDetail(int id = 0) { TBPURCHASEDETAIL obj = dbContext.TBPURCHASEDETAILS.Where(x => x.PurDetailID == id).FirstOrDefault(); if (obj == null) { return(HttpNotFound()); } ViewBag.PurchaseIdList = GetPurchaseId(); ViewBag.ItemIdList = GetItemId(); ViewBag.SizeIdList = GetSizeId(); ViewBag.PurchaseDetailList = dbContext.TBPURCHASEDETAILS.ToList(); return(View("PurchaseDetail", obj)); }
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")); }