// GET: INV_ItemConfiguration/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } INV_ItemConfiguration iNV_ItemConfiguration = db.INV_ItemConfiguration.Find(id); if (iNV_ItemConfiguration == null) { return(HttpNotFound()); } return(View(iNV_ItemConfiguration)); }
// GET: INV_ItemConfiguration/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } INV_ItemConfigurationViewModal iNV_ItemConfigurationViewModal = new INV_ItemConfigurationViewModal(); INV_ItemConfiguration iNV_ItemConfiguration = db.INV_ItemConfiguration.Find(id); if (iNV_ItemConfiguration != null) { iNV_ItemConfiguration.Remarks = ""; iNV_ItemConfigurationViewModal = new INV_ItemConfigurationViewModal() { ItemConfigurationID = iNV_ItemConfiguration.ItemConfigurationID, MainItemID = iNV_ItemConfiguration.MainItemID, SubItemID = iNV_ItemConfiguration.SubItemID, Qunatity = iNV_ItemConfiguration.Qunatity, UserID = iNV_ItemConfiguration.UserID, Created = iNV_ItemConfiguration.Created, Modified = iNV_ItemConfiguration.Modified, Remarks = iNV_ItemConfiguration.Remarks }; iNV_ItemConfigurationViewModal.SubItems = db.INV_ItemConfiguration.Where(ic => ic.MainItemID == iNV_ItemConfiguration.MainItemID).ToList(); } if (iNV_ItemConfigurationViewModal == null) { return(HttpNotFound()); } var items = db.INV_Item .Where(i => i.IsLock == true && i.IsConfigurable == true) .Select(s => new { ItemID = s.ItemID, ItemName = s.ItemName + " - " + s.ItemCode }) .ToList(); ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName", iNV_ItemConfiguration.MainItemID); ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName"); ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_ItemConfiguration.UserID); return(View(iNV_ItemConfigurationViewModal)); }
public ActionResult DeleteConfirmed(int id) { INV_ItemConfiguration iNV_ItemConfiguration = db.INV_ItemConfiguration.Find(id); try { var LisIiNV_ItemConfiguration = db.INV_ItemConfiguration.Where(ic => ic.MainItemID == iNV_ItemConfiguration.MainItemID).ToList(); db.INV_ItemConfiguration.RemoveRange(LisIiNV_ItemConfiguration); db.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("", "You can not Delete this Employee."); return(View(iNV_ItemConfiguration)); } return(RedirectToAction("Index")); }
public JsonResult Retrieve_INV_ItemConfiguration_List(INV_ItemConfiguration iNV_ItemConfiguration) { try { if (iNV_ItemConfiguration == null) { //erroor } if (iNV_ItemConfiguration != null) { if (iNV_ItemConfiguration.RetrieveType == true) { var itemConfigurationList = db.INV_ItemConfiguration.Where(e => e.MainItemID == iNV_ItemConfiguration.MainItemID).OrderByDescending(e => e.ItemConfigurationID).Select(e => new { SubItemID = e.SubItemID, ItemName = db.INV_Item.Where(i => i.ItemID == e.MainItemID).FirstOrDefault().ItemName, Qunatity = e.Qunatity }).FirstOrDefault(); return(Json(itemConfigurationList, JsonRequestBehavior.AllowGet)); } else if (iNV_ItemConfiguration.RetrieveType == false) { var itemConfigurationList = db.INV_ItemConfiguration.Where(e => e.MainItemID == iNV_ItemConfiguration.MainItemID).OrderByDescending(e => e.ItemConfigurationID).Select(e => new { SubItemID = e.SubItemID, ItemName = db.INV_Item.Where(i => i.ItemID == e.SubItemID).FirstOrDefault().ItemName, Qunatity = e.Qunatity, MainItemID = e.MainItemID }).ToList(); return(Json(itemConfigurationList, JsonRequestBehavior.AllowGet)); } } } catch (Exception exception) { //exception handiling } return(Json("failure", JsonRequestBehavior.AllowGet)); }
public JsonResult SaveMainItem(INV_ItemConfiguration iNV_ItemConfiguration) { try { if (iNV_ItemConfiguration != null) { //erroor handle } if (iNV_ItemConfiguration != null) { if (Session["UserID"] != null) { iNV_ItemConfiguration.UserID = Convert.ToInt16(Session["UserID"].ToString()); } var inv_Item = db.INV_Item.Where(e => e.ItemID == iNV_ItemConfiguration.MainItemID).FirstOrDefault(); string getIssueLastNumber; if (inv_Item != null) { var getIssueLast = db.INV_StockHistory.Where(e => e.Remarks == "Return").OrderByDescending(e => e.StockHistoryID).FirstOrDefault(); if (getIssueLast == null) { getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "01"; #region Check No INV_StockHistory _INV_StockHistoryNo = db.INV_StockHistory.Where(w => w.IssueNumber == getIssueLastNumber).FirstOrDefault(); if (_INV_StockHistoryNo != null) { getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "02"; } #endregion Check No } else { var a = getIssueLast.IssueNumber; if (a == null) { getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "01"; #region Check No INV_StockHistory _INV_StockHistoryNo = db.INV_StockHistory.Where(w => w.IssueNumber == getIssueLastNumber).FirstOrDefault(); if (_INV_StockHistoryNo != null) { getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "02"; } #endregion Check No } else { //a = "278201801"; a = a.ToString(); string delimiters = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString(); //bool aaa = a.Contains(delimiters); string[] newstring = a.Split(new[] { delimiters }, StringSplitOptions.None); getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + (Convert.ToInt32(newstring[1]) + 1); #region Check No INV_StockHistory _INV_StockHistoryNo = db.INV_StockHistory.Where(w => w.IssueNumber == getIssueLastNumber).FirstOrDefault(); if (_INV_StockHistoryNo != null) { getIssueLastNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + (Convert.ToInt32(newstring[1]) + 2); } #endregion Check No } } INV_StockHistory new_INV_StockHistory = new INV_StockHistory(); new_INV_StockHistory.ItemID = inv_Item.ItemID; new_INV_StockHistory.OperationTypeID = 7; new_INV_StockHistory.ReferenceID = getIssueLastNumber; new_INV_StockHistory.Quantity = inv_Item.Quantity; new_INV_StockHistory.UserID = iNV_ItemConfiguration.UserID; new_INV_StockHistory.Created = DateTime.Now; new_INV_StockHistory.Modified = DateTime.Now; new_INV_StockHistory.Remarks = "Return"; new_INV_StockHistory.FinYearID = CommonConfig.GetFinYearID(); new_INV_StockHistory.ReturnNumber = getIssueLastNumber; db.INV_StockHistory.Add(new_INV_StockHistory); db.SaveChanges(); inv_Item.Quantity = inv_Item.Quantity + iNV_ItemConfiguration.Qunatity; db.SaveChanges(); } } } catch (Exception exception) { //exception handiling } return(Json("failure", JsonRequestBehavior.AllowGet)); }
public ActionResult Create(INV_ItemConfiguration iNV_ItemConfiguration) { //if (db.INV_ItemConfiguration.Where(I => I.MainItemID == iNV_ItemConfiguration.MainItemID).Count() > 0) //{ // ModelState.AddModelError("ItemNameDuplicate", "Selected item is already configured."); //} if (iNV_ItemConfiguration.ItemConfigurationID > 0) { if (iNV_ItemConfiguration.Remarks == null || iNV_ItemConfiguration.Remarks == "") { var items = db.INV_Item .Where(i => i.IsLock == true && i.IsConfigurable == true) .Select(s => new { ItemID = s.ItemID, ItemName = s.ItemName + " - " + s.ItemCode }) .ToList(); iNV_ItemConfiguration.INV_Items = db.INV_ItemConfiguration.Where(ic => ic.MainItemID == iNV_ItemConfiguration.MainItemID).ToList(); ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName", iNV_ItemConfiguration.MainItemID); ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName"); ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_ItemConfiguration.UserID); ModelState.AddModelError("", "Enter Remarks"); return(View(iNV_ItemConfiguration)); } } if (iNV_ItemConfiguration.INV_Items != null) { if (ModelState.IsValid) { iNV_ItemConfiguration.Modified = DateTime.Now; if (Session["UserID"] != null) { iNV_ItemConfiguration.UserID = Convert.ToInt16(Session["UserID"].ToString()); } var ToRemovedbINV_ItemConfiguration = db.INV_ItemConfiguration.Where(i => i.MainItemID == iNV_ItemConfiguration.MainItemID).ToList(); db.INV_ItemConfiguration.RemoveRange(ToRemovedbINV_ItemConfiguration); db.SaveChanges(); String Err = ""; List <INV_ItemConfiguration> newINV_ItemConfiguration = new List <INV_ItemConfiguration>(); foreach (var item in iNV_ItemConfiguration.INV_Items) { if (item.Qunatity <= 0) { INV_Item _Subitem = db.INV_Item.Find(item.SubItemID); if (_Subitem != null) { if (Err == "") { Err = "Enter Valid Quantity for " + _Subitem.ItemName; } else { Err += ", Enter Valid Quantity for " + _Subitem.ItemName; } } } INV_ItemConfiguration new_INV_InvoiceItem = new INV_ItemConfiguration(); new_INV_InvoiceItem.MainItemID = iNV_ItemConfiguration.MainItemID; new_INV_InvoiceItem.SubItemID = item.SubItemID; new_INV_InvoiceItem.Qunatity = item.Qunatity; new_INV_InvoiceItem.Created = DateTime.Now; new_INV_InvoiceItem.Modified = DateTime.Now; new_INV_InvoiceItem.UserID = iNV_ItemConfiguration.UserID; new_INV_InvoiceItem.Remarks = iNV_ItemConfiguration.Remarks; newINV_ItemConfiguration.Add(new_INV_InvoiceItem); } if (Err != "") { var items = db.INV_Item .Where(i => i.IsLock == true && i.IsConfigurable == true) .Select(s => new { ItemID = s.ItemID, ItemName = s.ItemName + " - " + s.ItemCode }) .ToList(); ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName"); ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName"); ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName"); TempData["errorConfig"] = Err; return(View(iNV_ItemConfiguration)); } db.INV_ItemConfiguration.AddRange(newINV_ItemConfiguration); db.SaveChanges(); } } var itemsa = db.INV_Item .Where(i => i.IsLock == true && i.IsConfigurable == true) .Select(s => new { ItemID = s.ItemID, ItemName = s.ItemName + " - " + s.ItemCode }) .ToList(); ViewBag.MainItemID = new SelectList(itemsa, "ItemID", "ItemName"); ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName"); ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName"); INV_ItemConfigurationViewModal iNV_ItemConfigurationViewModal = new INV_ItemConfigurationViewModal(); ViewData["errorConfig"] = TempData["errorConfig"]; return(View("Edit", iNV_ItemConfigurationViewModal)); }
public ActionResult Edit(INV_ItemConfigurationViewModal iNV_ItemConfigurationViewModal) { if (iNV_ItemConfigurationViewModal.ItemConfigurationID > 0) { if (iNV_ItemConfigurationViewModal.Remarks == null || iNV_ItemConfigurationViewModal.Remarks == "") { var items = db.INV_Item .Where(i => i.IsLock == true && i.IsConfigurable == true) .Select(s => new { ItemID = s.ItemID, ItemName = s.ItemName + " - " + s.ItemCode }) .ToList(); iNV_ItemConfigurationViewModal.SubItems = db.INV_ItemConfiguration.Where(ic => ic.MainItemID == iNV_ItemConfigurationViewModal.MainItemID).ToList(); ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName", iNV_ItemConfigurationViewModal.MainItemID); ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName"); ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_ItemConfigurationViewModal.UserID); ModelState.AddModelError("", "Enter Remarks"); return(View(iNV_ItemConfigurationViewModal)); } } if (iNV_ItemConfigurationViewModal.SubItems.Count > 0) { if (ModelState.IsValid) { INV_ItemConfiguration iNV_ItemConfiguration = db.INV_ItemConfiguration.Find(iNV_ItemConfigurationViewModal.ItemConfigurationID); db.Entry(iNV_ItemConfiguration).State = EntityState.Modified; iNV_ItemConfiguration.Modified = DateTime.Now; if (Session["UserID"] != null) { iNV_ItemConfiguration.UserID = Convert.ToInt16(Session["UserID"].ToString()); } String Err = ""; TempData["errorIssue"] = ""; List <INV_ItemConfiguration> newINV_ItemConfiguration = new List <INV_ItemConfiguration>(); foreach (var item in iNV_ItemConfiguration.INV_Items) { if (item.Qunatity <= 0) { INV_Item _Subitem = db.INV_Item.Find(item.SubItemID); if (_Subitem != null) { if (Err == "") { Err = "Enter Valid Quantity for " + _Subitem.ItemName; } else { Err += ", Enter Valid Quantity for " + _Subitem.ItemName; } } } INV_ItemConfiguration new_INV_InvoiceItem = new INV_ItemConfiguration(); new_INV_InvoiceItem.MainItemID = iNV_ItemConfiguration.MainItemID; new_INV_InvoiceItem.SubItemID = item.SubItemID; new_INV_InvoiceItem.Qunatity = item.Qunatity; new_INV_InvoiceItem.Created = DateTime.Now; new_INV_InvoiceItem.Modified = DateTime.Now; INV_ItemConfiguration dbINV_ItemConfiguration = db.INV_ItemConfiguration.Where(i => i.MainItemID == item.MainItemID & i.SubItemID == item.SubItemID).FirstOrDefault(); if (dbINV_ItemConfiguration == null) { newINV_ItemConfiguration.Add(new_INV_InvoiceItem); } } if (Err != "") { var items = db.INV_Item .Where(i => i.IsLock == true && i.IsConfigurable == true) .Select(s => new { ItemID = s.ItemID, ItemName = s.ItemName + " - " + s.ItemCode }) .ToList(); ViewBag.MainItemID = new SelectList(items, "ItemID", "ItemName"); ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName"); ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName"); TempData["errorConfig"] = Err; return(View(iNV_ItemConfiguration)); } db.INV_ItemConfiguration.AddRange(newINV_ItemConfiguration); db.SaveChanges(); return(RedirectToAction("Index")); } } ViewBag.MainItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true && i.IsConfigurable == true), "ItemID", "ItemName"); ViewBag.SubItemID = new SelectList(db.INV_Item.Where(i => i.IsLock == true), "ItemID", "ItemName"); ViewBag.UserID = new SelectList(db.SEC_User, "UserID", "UserName", iNV_ItemConfigurationViewModal.UserID); return(RedirectToAction("Index")); }