public ActionResult Create1(FormCollection frm, string[] hddrowindex) { A_AssetRepo aar = new A_AssetRepo(); int depid = Convert.ToInt32(Session["DepartmentId"]); int uid = Convert.ToInt32(Session["UserId"]); var cdate = DateTime.Now; int num = 0; int totalcount = Convert.ToInt32(frm["hddrowindex"]); try { //Purchase Item Add if (hddrowindex != null) { for (int i = 1; i <= totalcount; i++) { if (i == Convert.ToInt32(frm["" + i])) { INV_DistributionItem pitem = new INV_DistributionItem(); pitem.DepartmentId = Convert.ToInt32(frm["DepartmentId"]); //pitem.DistributionBillId = purchaseid; int tokenId = Convert.ToInt32(frm["TokenId"]); pitem.ItemId = Convert.ToInt32(frm["ItemId"]); pitem.SalesQuantity = Convert.ToDecimal(frm["SalesQuantity"]); //pitem.Rate = Convert.ToDecimal(frm["Rate-" + i]); pitem.UnitId = Convert.ToInt32(frm["UnitId"]); //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; num = db.AddInventoryDistributionItem(pitem); if (num > 0) { aar.ApprovedRequestTokenStore(tokenId, uid, cdate); } } } } return(RedirectToAction("Index")); } catch (Exception ex) { //int depid = Convert.ToInt32(Session["DepartmentId"]); ViewBag.DepartmentId = new SelectList(ddl.getDepartmentList(), "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 void EditInventoryDistributionItem(INV_DistributionItem distributionitem) { string sql = " Update INV_DistributionItem set" + " DepartmentId=@DepartmentId, ItemId=@ItemId, SalesQuantity=@SalesQuantity, Rate=@Rate, Total=@Total," + " LastUpdatedBy=@LastUpdatedBy, LastUpdatedDate=@LastUpdatedDate, IsDeleted=@IsDeleted, DeletedBy=@DeletedBy, DeletedDate=@DeletedDate" + " where DistributionItemId=@DistributionItemId"; using (var db = DbHelper.GetDBConnection()) { db.Query(sql, distributionitem); db.Close(); } }
public int AddInventoryDistributionItem(INV_DistributionItem distributionitem) { string sql = " insert into INV_DistributionItem(DepartmentId, ItemId, SalesQuantity, UnitId, IsVerified," + "VerifiedBy,VerifiedDate,IsDeleted,EnteredBy,EnteredDate) " + "Values(@DepartmentId, @ItemId, @SalesQuantity, @UnitId, @IsVerified, " + "@VerifiedBy, @VerifiedDate,@IsDeleted,@EnteredBy,@EnteredDate)SELECT CAST(SCOPE_IDENTITY() as int)"; using (var db = DbHelper.GetDBConnection()) { int a = db.Query <int>(sql, distributionitem).SingleOrDefault(); db.Close(); return(a); } }
//[ValidateAntiForgeryToken] public ActionResult Edit(FormCollection frm, string[] hddrowindex) { int depid = Convert.ToInt32(Session["DepartmentId"]); int uid = Convert.ToInt32(Session["UserId"]); var cdate = DateTime.Now; int distributionid = Convert.ToInt32(frm["DistributionBillId"]); int totalcount = Convert.ToInt32(frm["hddrowindex"]); try { //For bill Section INV_DistributionBill pbill = new INV_DistributionBill(); pbill.DepartmentId = depid; pbill.LastUpdatedBy = uid; pbill.LastUpdatedDate = cdate; pbill.IsVerified = 1; pbill.VerifiedBy = uid; pbill.VerifiedDate = cdate; pbill.IsDeleted = false; db.EditInventoryDistributionItemDelete(cdate, uid, distributionid); //db.EditInventoryDistribution(pbill); //Purchase Item Add if (hddrowindex != null) { INV_DistributionItem pitem = new INV_DistributionItem(); for (int i = 1; i <= totalcount; i++) { if (frm["DistributionItemId-" + i] == "0") { if (i == Convert.ToInt32(frm["" + i])) { pitem.DepartmentId = depid; pitem.DistributionBillId = distributionid; 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.AddInventoryDistributionItem(pitem); } } else { if (i == Convert.ToInt32(frm["" + i])) { pitem.DepartmentId = depid; //pitem.PurchaseBillId = purchaseid; pitem.DistributionItemId = Convert.ToInt32(frm["PurchaseItemId-" + i]); 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.DeletedBy = 0; pitem.DeletedDate = null; pitem.LastUpdatedBy = uid; pitem.LastUpdatedDate = cdate; db.EditInventoryDistributionItem(pitem); } } } } return(RedirectToAction("Index")); } catch (Exception ex) { //int depid = Convert.ToInt32(Session["DepartmentId"]); 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.ItemId = new SelectList(ddl.getItemList(depid), "Id", "Name"); return(View()); } }