public ActionResult EditDebit(int id = 0)
{
TBDEBIT obj = dbContext.TBDEBITs.Where(x => x.DebitID == id).FirstOrDefault();
if (obj == null)
{
return(HttpNotFound());
}
ViewBag.HeadCodeList = GetPurchaseHeaderDebit();
ViewBag.debitList = dbContext.TBDEBITs.ToList();
return(View("Debit", 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 DebitSaveChanges(TBDEBIT obj)
{
if (obj.DebitID > 0)
{
TBDEBIT objbrand = dbContext.TBDEBITs.Where(x => x.DebitID == obj.DebitID).FirstOrDefault();
objbrand.FNEntryCode = obj.FNEntryCode;
objbrand.STType = obj.STType;
objbrand.HeadCode = obj.HeadCode;
objbrand.FNAmount = obj.FNAmount;
objbrand.FNDate = obj.FNDate;
objbrand.Description = obj.Description;
}
else
{
dbContext.TBDEBITs.Add(obj);
}
dbContext.SaveChanges();
return(RedirectToAction("Debit"));
}
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"));
}
