public void EditInventorySalesItem(INV_SalesItem salesitem) { string sql = " Update INV_SalesItem set" + " DepartmentId=@DepartmentId, ItemId=@ItemId, SalesQuantity=@SalesQuantity, Rate=@Rate, Total=@Total," + " LastUpdatedBy=@LastUpdatedBy, LastUpdatedDate=@LastUpdatedDate, IsDeleted=@IsDeleted, DeletedBy=@DeletedBy, DeletedDate=@DeletedDate" + " where SalesItemId=@SalesItemId"; using (var db = DbHelper.GetDBConnection()) { db.Query(sql, salesitem); db.Close(); } }
public int AddInventorySalesItem(INV_SalesItem salesitem) { string sql = " insert into INV_SalesItem(" + "DepartmentId, SalesBillId, ItemId, SalesQuantity, Rate, Total," + " IsVerified, VerifiedBy," + " VerifiedDate, EnteredBy, EnteredDate, LastUpdatedBy, LastUpdatedDate, IsDeleted," + " DeletedDate, DeletedBy" + ")" + " values(" + "@DepartmentId, @SalesBillId, @ItemId, @SalesQuantity, @Rate, @Total," + " @IsVerified, @VerifiedBy," + " @VerifiedDate, @EnteredBy, @EnteredDate, 0, null, 0," + " null, 0 " + ") SELECT CAST(SCOPE_IDENTITY() as int)"; using (var db = DbHelper.GetDBConnection()) { int a = db.Query <int>(sql, salesitem).SingleOrDefault(); db.Close(); 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 salesid = 0; int totalcount = Convert.ToInt32(frm["hddrowindex"]); try { //For bill Section INV_SalesBill pbill = new INV_SalesBill(); 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; } salesid = db.AddInventorySales(pbill); //Purchase Item Add if (hddrowindex != null) { for (int i = 1; i <= totalcount; i++) { if (i == Convert.ToInt32(frm["" + i])) { INV_SalesItem pitem = new INV_SalesItem(); pitem.DepartmentId = depid; pitem.SalesBillId = salesid; pitem.ItemId = Convert.ToInt32(frm["ItemId-" + i]); pitem.SalesQuantity = Convert.ToDecimal(frm["Quantity-" + i]); pitem.Rate = Convert.ToDecimal(frm["Rate-" + 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.AddInventorySalesItem(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.ItemId = new SelectList(ddl.getItemList(depid), "Id", "Name"); return(View()); } }