public ActionResult Edit(int?id) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; if (id == null || id == 0) { return(HttpNotFound()); } var detail = db.GetPurchaseDetail(orgid, (int)id); if (detail.InventoryPurchase == null) { return(HttpNotFound()); } INV_PurchaseBill sn = (db.GetBillSerialNo(orgid, (int)id)); int BSN = Convert.ToInt32(sn.BillSerialNo); ViewBag.BSN = BSN; ViewBag.CategoryList = ddl.GetCategoryList(orgid); ViewBag.ItemList = ddl.GetItemList(orgid, 0); ViewBag.UnitList = ddl.GetUnitByItemList(orgid); ViewBag.ItemUnitList = ddl.GetUnitByPurchase((int)id); ViewBag.OrganizationId = orgid; ViewBag.VendorId = new SelectList(ddl.GetInvVenodrList(orgid), "Id", "Name", detail.InventoryPurchase.VendorId); return(View(detail)); }
public void EditInventoryPurchase(INV_PurchaseBill apurchase) { string sql = " update INV_PurchaseBill set " + " DepartmentId=@DepartmentId,VendorId=@VendorId, BillNo=@BillNo, BillDate=@BillDate, BillDateBS=@BillDateBS," + " TotalAmount=@TotalAmount, " + " VatApplicable=@VatApplicable,VatAmount=@VatAmount,VATPercent=@VATPercent," + " DiscountAmount=@DiscountAmount,DiscountPercent=@DiscountPercent,TaxableAmount=@TaxableAmount,TotalWithVat=@TotalWithVat," + " LastUpdatedBy=@LastUpdatedBy, LastUpdatedDate=@LastUpdatedDate,Remarks=@Remarks" + " where PurchaseBillId=@PurchaseBillId"; using (var db = DbHelper.GetDBConnection()) { db.Query(sql, apurchase); db.Close(); } }
public void EditInvetoryPurchase(INV_PurchaseBill purchasebill) { string sql = " update INV_PurchaseBill set " + " VendorId=@VendorId,BillNo=@BillNo,BillDate=@BillDate,BillDateBS=@BillDateBS,TotalAmount=@TotalAmount,IsPreviousStock=@IsPreviousStock," + " VatApplicable=@VatApplicable,VatAmount=@VatAmount,VATPercent=@VATPercent," + " ShippingCharge=@ShippingCharge,DiscountAmount=@DiscountAmount,TotalWithVat=@TotalWithVat," + " OrganizationId=@OrganizationId," + " LastUpdatedBy=@LastUpdatedBy,LastUpdatedDate=@LastUpdatedDate" + " where PurchaseId=@PurchaseId"; using (var db = DbHelper.GetDBConnection()) { //using (var trsn = db.BeginTransaction()) //{ db.Query(sql, purchasebill); // trsn.Commit(); //} } }
public ActionResult Details(int?id) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; INV_PurchaseBill sn = (db.GetBillSerialNo(orgid, (int)id)); int BSN = Convert.ToInt32(sn.BillSerialNo); ViewBag.BSN = BSN; if (id == null || id == 0) { return(HttpNotFound()); } var details = db.GetPurchaseDetail(orgid, (int)id); if (details.InventoryPurchase == null) { return(HttpNotFound()); } return(View(details)); }
public int AddInventoryPurchase(INV_PurchaseBill apurchase) { string sql = " insert into INV_PurchaseBill (" + " DepartmentId,VendorId, BillNo, BillDate, BillDateBS, TotalAmount,VatApplicable,VatPercent,VatAmount, IsVerified,Remarks," + " DiscountAmount,DiscountPercent,TaxableAmount,TotalWithVat,VerifiedBy, VerifiedDate, EnteredBy, EnteredDate, LastUpdatedBy, LastUpdatedDate, IsDeleted, DeletedBy," + " DeletedDate, BillSerialNo" + ")" + " values " + " (" + "@DepartmentId,@VendorId, @BillNo, @BillDate, @BillDateBS, @TotalAmount, @VatApplicable,@VatPercent,@VatAmount, @IsVerified,@Remarks," + " @DiscountAmount,@DiscountPercent,@TaxableAmount,@TotalWithVat,@VerifiedBy, @VerifiedDate, @EnteredBy, @EnteredDate, 0, null, 0, 0," + " null, @BillSerialNo" + ") SELECT CAST(SCOPE_IDENTITY() as int)"; using (var db = DbHelper.GetDBConnection()) { int a = db.Query <int>(sql, apurchase).SingleOrDefault(); db.Close(); return(a); } }
public ActionResult Create() { INV_PurchaseBill sn = (db.GetBillSerialNo()); if (sn == null) { ViewBag.BSN = 1; } else { int sn1 = Convert.ToInt32(sn.BillSerialNo) + 1; ViewBag.BSN = sn1; } int depid = Convert.ToInt32(Session["DepartmentId"]); ViewBag.VendorId = new SelectList(ddl.getInventoryVendorList(depid), "Id", "Name"); ViewBag.CategoryList = new SelectList(ddl.getCategoryList(depid), "Id", "Name"); ViewBag.CategoryId = new SelectList(ddl.getCategoryList(depid), "Id", "Name"); ViewBag.ItemList = new SelectList(ddl.getItemList(depid), "Id", "Name"); ViewBag.UnitList = new SelectList(ddl.getUnitList(depid), "Id", "Name"); ViewBag.ItemId = new SelectList(ddl.getItemList(depid), "Id", "Name"); return(View()); }
public ActionResult Create() { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; //int orgid= orgid; INV_PurchaseBill sn = (db.GetBillSerialNo(orgid)); if (sn == null) { ViewBag.BSN = 1; } else { int sn1 = Convert.ToInt32(sn.BillSerialNo) + 1; ViewBag.BSN = sn1; } ViewBag.CategoryList = ddl.GetCategoryList(orgid); ViewBag.ItemList = ddl.GetItemList(orgid, 0); ViewBag.UnitList = ddl.GetUnitByItemList(orgid); ViewBag.VendorId = new SelectList(ddl.GetInvVenodrList(orgid), "Id", "Name"); ViewBag.OrganizationId = orgid; return(View()); }
public int AddInvetoryPurchase(INV_PurchaseBill purchasebill) { string sql = " insert into INV_PurchaseBill (" + "VendorId,BillNo,BillDate,BillDateBS,TotalAmount,VatApplicable,VATPercent,VatAmount,IsPreviousStock," + "ShippingCharge,DiscountAmount,TotalWithVat,OrganizationId,EnteredBy,EnteredDate," + "IsVerified,VerifiedBy,VerifiedDate,IsDeleted ,DeletedBy,DeletedDate,LastUpdatedBy,LastUpdatedDate," + "BillSerialNo, Remarks)" + " values " + " (" + "@VendorId,@BillNo,@BillDate,@BillDateBS,@TotalAmount,@VatApplicable,@VATPercent,@VatAmount,@IsPreviousStock," + "@ShippingCharge,@DiscountAmount,@TotalWithVat,@OrganizationId,@EnteredBy,@EnteredDate," + " 1,@EnteredBy,@EnteredDate,@IsDeleted ,0,null,0,null,@BillSerialNo, @Remarks" + ") SELECT CAST(SCOPE_IDENTITY() as int)"; using (var db = DbHelper.GetDBConnection()) { //using (var trsn = db.BeginTransaction()) //{ int a = db.Query <int>(sql, purchasebill).SingleOrDefault(); // trsn.Commit(); //} return(a); } }
//[ValidateAntiForgeryToken] public ActionResult Create(FormCollection frm, string[] hddrowindex) { int depid = Convert.ToInt32(Session["DepartmentId"]); int uid = Convert.ToInt32(Session["UserId"]); var cdate = DateTime.Now; int purchaseid = 0; int totalcount = Convert.ToInt32(frm["hddrowindex"]); try { //For bill Section INV_PurchaseBill pbill = new INV_PurchaseBill(); pbill.BillDate = frm["BillDate"]; pbill.BillDateBS = frm["BillDateBS"]; pbill.BillNo = frm["BillNo"]; pbill.BillSerialNo = Convert.ToInt32(frm["BillSerialNo"]); pbill.VendorId = Convert.ToInt32(frm["VendorId"]); pbill.Remarks = frm["Remarks"]; pbill.DepartmentId = depid; pbill.EnteredBy = uid; pbill.EnteredDate = cdate; pbill.IsVerified = 1; pbill.VerifiedBy = uid; pbill.VerifiedDate = cdate; pbill.IsDeleted = false; pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]); pbill.DiscountPercent = Convert.ToInt32(frm["DiscountPercent"]); pbill.DiscountAmount = Convert.ToDecimal(frm["DiscountAmount"]); pbill.TaxableAmount = Convert.ToDecimal(frm["TaxableAmount"]); if (frm["VatApplicable"] == "Yes") { pbill.VatApplicable = 1; pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]); pbill.VatPercent = Convert.ToInt32(frm["VatPercent"]); } else { pbill.VatApplicable = 0; pbill.VatAmount = 0; pbill.VatPercent = 0; } purchaseid = db.AddInventoryPurchase(pbill); //Purchase Item Add if (hddrowindex != null) { for (int i = 1; i <= totalcount; i++) { if (i == Convert.ToInt32(frm["" + i])) { INV_PurchaseItem pitem = new INV_PurchaseItem(); pitem.DepartmentId = depid; pitem.PurchaseBillId = purchaseid; pitem.ItemId = Convert.ToInt32(frm["ItemId-" + i]); pitem.PurchaseQuantity = Convert.ToDecimal(frm["Quantity-" + i]); pitem.Rate = Convert.ToDecimal(frm["Rate-" + i]); pitem.UnitId = Convert.ToInt32(frm["UnitId-" + i]); pitem.Total = Convert.ToDecimal(frm["Total-" + i]); pitem.IsVerified = true; pitem.VerifiedBy = uid; pitem.VerifiedDate = cdate; pitem.IsDeleted = false; pitem.EnteredBy = uid; pitem.EnteredDate = cdate; db.AddInventoryPurchaseItem(pitem); } } } return(RedirectToAction("Index")); } catch (Exception ex) { //int depid = Convert.ToInt32(Session["DepartmentId"]); ViewBag.VendorId = new SelectList(ddl.getVendorList(depid), "Id", "Name"); ViewBag.CategoryList = new SelectList(ddl.getAssetCategoryList(depid), "Id", "Name"); ViewBag.CategoryId = new SelectList(ddl.getAssetCategoryList(depid), "Id", "Name"); ViewBag.ItemList = new SelectList(ddl.getItemList(depid), "Id", "Name"); ViewBag.UnitList = new SelectList(ddl.getUnitList(depid), "Id", "Name"); ViewBag.ItemId = new SelectList(ddl.getItemList(depid), "Id", "Name"); return(View()); } }
public ActionResult Create(FormCollection frm, string[] hddrowindex) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; int uid = (User as CustomPrincipal).UserId; INV_PurchaseBill pbill = new INV_PurchaseBill(); INV_PurchaseItem pitem; //= new INV_SoldItem(); int purchaseid = 0; var cdate = DateTime.Now; try { //var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"])); if (frm["PurchaseId"] == "0") { db.EditInvetoryPurchase(pbill); pbill.VendorId = Convert.ToInt32(frm["VendorId"]); pbill.BillNo = frm["BillNo"]; pbill.BillSerialNo = Convert.ToInt32(frm["BillSerialNo"]); pbill.Remarks = frm["Remarks"]; pbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); pbill.BillDateBS = frm["BillDateBS"]; pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]); pbill.IsPreviousStock = frm["IsPreviousStock"] == "Yes" ? true : false; if (frm["VatApplicable"] == "Yes") { pbill.VatApplicable = true; pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]); pbill.VATPercent = Convert.ToInt32(frm["VATPercent"]); } else { pbill.VatApplicable = false; pbill.VatAmount = 0; pbill.VATPercent = 0; } pbill.ShippingCharge = 0; // frm[""]; pbill.DiscountAmount = 0; // Convert.ToDecimal(frm["DiscountAmount"]); //pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]); pbill.OrganizationId = orgid; pbill.EnteredBy = uid; pbill.EnteredDate = cdate; pbill.IsVerified = true; pbill.VerifiedBy = uid; pbill.VerifiedDate = cdate; pbill.IsDeleted = false; purchaseid = db.AddInvetoryPurchase(pbill); } else { purchaseid = Convert.ToInt32(frm["PurchaseId"]); pbill = db.GetPurchaseBillById(orgid, purchaseid); pbill.VendorId = Convert.ToInt32(frm["VendorId"]); pbill.BillNo = frm["BillNo"]; pbill.Remarks = frm["Remarks"]; pbill.BillSerialNo = Convert.ToInt32(frm["BillSerialNo"]); ViewBag.BSN2 = Convert.ToInt32(frm["BillSerialNo"]) + 1; pbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); pbill.BillDateBS = frm["BillDateBS"]; pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]); pbill.IsPreviousStock = frm["IsPreviousStock"] == "Yes" ? true : false; if (frm["VatApplicable"] == "Yes") { pbill.VatApplicable = true; pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]); pbill.VATPercent = Convert.ToInt32(frm["VATPercent"]); } else { pbill.VatApplicable = false; pbill.VatAmount = 0; pbill.VATPercent = 0; } pbill.ShippingCharge = 0; // frm[""]; pbill.DiscountAmount = 0; // Convert.ToDecimal(frm["DiscountAmount"]); //pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]); pbill.OrganizationId = orgid; pbill.EnteredBy = uid; pbill.EnteredDate = cdate; pbill.IsVerified = true; pbill.VerifiedBy = uid; pbill.VerifiedDate = cdate; pbill.IsDeleted = false; db.EditInvetoryPurchase(pbill); } if (hddrowindex != null) { //INV_SoldItem item; foreach (var indx in hddrowindex) { if (frm["PurchaseItemId-" + indx] == "0") { pitem = new INV_PurchaseItem(); pitem.PurchaseId = purchaseid; pitem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); pitem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); pitem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); pitem.Total = Convert.ToDecimal(frm["Total-" + indx]); pitem.IsReturned = false; //pitem.ReturnedUnitId = frm[""]; //pitem.ReturnedQuantity = frm[""]; //pitem.ReturnedVerified = frm[""]; //pitem.ReturnedDate = frm[""]; //pitem.ReturnedBy = frm[""]; //pitem.ReturnRemarks = frm[""]; pitem.IsVerified = true; pitem.VerifiedBy = uid; pitem.VerifiedDate = cdate; pitem.IsDeleted = false; pitem.EnteredBy = uid; pitem.EnteredDate = cdate; pitem.OrganizationId = orgid; db.AddInvetoryPurchaseItem(pitem); } else { pitem = db.GetPurchaseItemById(orgid, Convert.ToInt32(frm["PurchaseItemId-" + indx])); pitem.PurchaseId = purchaseid; pitem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); pitem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); pitem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); pitem.Total = Convert.ToDecimal(frm["Total-" + indx]); pitem.IsReturned = false; //pitem.ReturnedUnitId = frm[""]; //pitem.ReturnedQuantity = frm[""]; //pitem.ReturnedVerified = frm[""]; //pitem.ReturnedDate = frm[""]; //pitem.ReturnedBy = frm[""]; //pitem.ReturnRemarks = frm[""]; pitem.IsVerified = true; pitem.VerifiedBy = uid; pitem.VerifiedDate = cdate; pitem.IsDeleted = false; pitem.EnteredBy = uid; pitem.EnteredDate = cdate; pitem.OrganizationId = orgid; db.EditInvetoryPurchaseItem(pitem); } } } return(RedirectToAction("Index")); } catch (Exception ex) { ViewBag.CategoryList = ddl.GetCategoryList(orgid); ViewBag.ItemList = ddl.GetItemList(orgid, 0); ViewBag.UnitList = ddl.GetUnitList(orgid); ViewBag.VendorId = new SelectList(ddl.GetInvVenodrList(orgid), "Id", "Name"); ViewBag.OrganizationId = orgid; //ex.Message; return(View()); } }
public ActionResult Edit(FormCollection frm, string[] hddrowindex) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; int uid = (User as CustomPrincipal).UserId; int pid = Convert.ToInt32(frm["PurchaseId"]); DateTime cdate = DateTime.Now; INV_PurchaseBill pbill = db.GetPurchaseBillById(orgid, pid); INV_PurchaseItem pitem;//= new INV_SoldItem(); //var student = stdb.GetAcademicStudentById(Convert.ToInt32(frm["StudentId"])); try { pbill.IsPreviousStock = frm["IsPreviousStock"] == "Yes" ? true : false; pbill.VendorId = Convert.ToInt32(frm["VendorId"]); pbill.BillNo = frm["BillNo"]; pbill.BillDate = DateTime.ParseExact(frm["BillDate"], "yyyy-MM-dd", null); pbill.BillDateBS = frm["BillDateBS"]; pbill.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); if (frm["VatApplicable"] == "Yes") { pbill.VatApplicable = true; pbill.VatAmount = Convert.ToDecimal(frm["VatAmount"]); pbill.VATPercent = Convert.ToInt32(frm["VATPercent"]); } else { pbill.VatApplicable = false; pbill.VatAmount = 0; pbill.VATPercent = 0; } pbill.ShippingCharge = 0;// frm[""]; pbill.DiscountAmount = Convert.ToDecimal(frm["DiscountAmount"]); pbill.TotalWithVat = Convert.ToDecimal(frm["TotalWithVat"]); pbill.OrganizationId = orgid; pbill.LastUpdatedBy = uid; pbill.LastUpdatedDate = cdate; pbill.IsVerified = true; pbill.VerifiedBy = uid; pbill.VerifiedDate = cdate; pbill.IsDeleted = false; db.DeleteAllInvetoryItem(pid, uid, DateTime.Now); db.EditInvetoryPurchase(pbill); if (hddrowindex != null) { //INV_SoldItem item; foreach (var indx in hddrowindex) { if (frm["PurchaseItemId-" + indx] == "0") { pitem = new INV_PurchaseItem(); pitem.PurchaseId = pid; pitem.OrganizationId = orgid; pitem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); pitem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); pitem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); pitem.Total = Convert.ToDecimal(frm["Total-" + indx]); pitem.EnteredBy = (User as CustomPrincipal).UserId; pitem.IsDeleted = false; pitem.EnteredDate = DateTime.Now; db.AddInvetoryPurchaseItem(pitem); } else { pitem = db.GetPurchaseItemById(orgid, Convert.ToInt32(frm["PurchaseItemId-" + indx])); pitem.PurchaseId = pid; pitem.OrganizationId = orgid; pitem.ItemId = Convert.ToInt32(frm["ItemId-" + indx]); pitem.UnitId = Convert.ToInt32(frm["UnitId-" + indx]); pitem.Quantity = Convert.ToInt32(frm["Quantity-" + indx]); pitem.Rate = Convert.ToDecimal(frm["Rate-" + indx]); pitem.Total = Convert.ToDecimal(frm["Total-" + indx]); pitem.LastUpdatedBy = uid; pitem.IsDeleted = false; pitem.LastUpdatedDate = DateTime.Now; db.EditInvetoryPurchaseItem(pitem); } } } } catch (Exception ex) { return(RedirectToAction("Edit", new { id = pid })); } return(RedirectToAction("Index")); }
public ActionResult SavePurchaseBill(string PurchaseId = "", string VendorId = "", string BillNo = "", string BillDate = "", string BillDateBS = "", string TotalAmount = "", string VatApplicable = "", string VatAmount = "0", string VATPercent = "0", string DiscountAmount = "0", string TotalWithVat = "0", string IsPreviousStock = "", string BillSerialNo = "", string Remarks = "") { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; int uid = (User as CustomPrincipal).UserId; INV_PurchaseBill pbill;// = new INV_SoldBill(); //INV_SoldItem solditem;//= new INV_SoldItem(); //var student = stdb.GetAcademicStudentById(Convert.ToInt32(StudentId)); if (string.IsNullOrEmpty(PurchaseId) || PurchaseId == "0") { pbill = new INV_PurchaseBill { BillSerialNo = Convert.ToInt32(BillSerialNo), Remarks = Remarks, BillDate = DateTime.ParseExact(BillDate, "yyyy-MM-dd", null), OrganizationId = orgid,// OrganizationId;// orgid; BillDateBS = BillDateBS, BillNo = BillNo, IsPreviousStock = IsPreviousStock == "Yes" ? true : false, //pbill.GroupNo = GroupNo; TotalAmount = Convert.ToDecimal(TotalAmount) }; if (VatApplicable == "Yes") { pbill.VatApplicable = true; pbill.VatAmount = string.IsNullOrEmpty(VatAmount)?0:Convert.ToDecimal(VatAmount); pbill.VATPercent = string.IsNullOrEmpty(VATPercent) ? 0 : Convert.ToInt32(VATPercent); } else { pbill.VatApplicable = false; pbill.VatAmount = 0; pbill.VATPercent = 0; } //if (VatApplicable == "No") //{ // pbill.VatAmount = 0; // pbill.VatApplicable = false; //} //else if (VatApplicable == "Yes") //{ // pbill.VatAmount = Convert.ToInt32(VatAmount); // pbill.VatApplicable = true; //} pbill.ShippingCharge = 0; // frm[""]; pbill.DiscountAmount = Convert.ToDecimal(DiscountAmount); // Convert.ToDecimal(frm["DiscountAmount"]); pbill.TotalWithVat = Convert.ToDecimal(pbill.TotalWithVat); // + pbill.TotalAmount;// Convert.ToDecimal(TotalWithVat); pbill.IsDeleted = false; pbill.EnteredBy = uid; // (User as CustomPrincipal).UserId; pbill.EnteredDate = DateTime.Now; int soldid = db.AddInvetoryPurchase(pbill); return(Json(new { result = soldid })); } else { pbill = db.GetPurchaseBillById(orgid, Convert.ToInt32(PurchaseId)); pbill.BillSerialNo = Convert.ToInt32(BillSerialNo); pbill.Remarks = Remarks; pbill.BillDate = DateTime.ParseExact(BillDate, "yyyy-MM-dd", null); pbill.OrganizationId = orgid;// orgid; pbill.BillDateBS = BillDateBS; pbill.BillNo = BillNo; //pbill.GroupNo = GroupNo; pbill.TotalAmount = Convert.ToDecimal(TotalAmount); if (VatApplicable == "No") { pbill.VatAmount = 0; pbill.VatApplicable = false; } else if (VatApplicable == "Yes") { pbill.VatAmount = Convert.ToInt32(VatAmount); pbill.VatApplicable = true; } pbill.ShippingCharge = 0; // frm[""]; pbill.DiscountAmount = Convert.ToDecimal(DiscountAmount); // Convert.ToDecimal(frm["DiscountAmount"]); pbill.TotalWithVat = Convert.ToDecimal(TotalWithVat); pbill.IsDeleted = false; pbill.LastUpdatedBy = uid;// (User as CustomPrincipal).UserId; pbill.LastUpdatedDate = DateTime.Now; int soldid = db.AddInvetoryPurchase(pbill); return(Json(new { result = soldid })); } }