public ActionResult InputItem(tblItem model, int?id) { if (ModelState.IsValid) { if (id > 0) { var cm = db.tblItem.Where(x => x.Id == id).FirstOrDefault(); cm.Id = Convert.ToInt32(id); cm.ItemName = model.ItemName; cm.ItemDesc = model.ItemDesc; cm.UOM = model.UOM; db.Entry(cm).State = EntityState.Modified; db.SaveChanges(); ModelState.Clear(); TempData["msg"] = "Update Succussfully"; return(RedirectToAction("ItemDetails")); } else { model.ItemName = model.ItemName; model.ItemDesc = model.ItemDesc; model.UOM = model.UOM; model.Status = true; db.tblItem.Add(model); db.SaveChanges(); ModelState.Clear(); TempData["msg"] = " Created Successfully"; return(RedirectToAction("ItemDetails")); } } return(View()); }
//-> uploadimages public async Task <ItemViewDTO> UploadImages(ItemUploadImageDTO itemUploadImage) { tblItem item = db.tblItems.FirstOrDefault(r => r.item_Deleted == null && r.id == itemUploadImage.id); if (item == null) { throw new HttpException((int)HttpStatusCode.NotFound, "This record does not exsists or has been deleted"); } using (var transaction = db.Database.BeginTransaction()) { try { List <sm_doc> documents = await DocumentHelper.SaveUploadImage(db, ConstantHelper.document_ItemTableID, itemUploadImage.id, itemUploadImage.base64s); transaction.Commit(); return(await SelectByID(item.id)); } catch (Exception ex) { transaction.Rollback(); throw new Exception(ex.Message); } } }
public ActionResult DeleteConfirmed(int id) { tblItem tblItem = db.tblItems.Find(id); db.tblItems.Remove(tblItem); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { using (OnlineFoodDBEntities db = new OnlineFoodDBEntities()) { ViewBag.SubMenus = db.tblSubMenus.ToList(); ViewBag.Action = "Create New Item"; return(View(new ItemViewModel())); } } else { using (OnlineFoodDBEntities db = new OnlineFoodDBEntities()) { ViewBag.Action = "Edit Item"; ViewBag.Menus = db.tblSubMenus.ToList(); tblItem item = db.tblItems.Where(i => i.ItemId == id).FirstOrDefault(); ItemViewModel itemvm = new ItemViewModel(); itemvm.ItemId = item.ItemId; itemvm.SubMenuId = Convert.ToInt32(item.SubMenuId); itemvm.Title = item.Title; itemvm.Price = item.Price; itemvm.Description = item.Description; itemvm.SmallImage = item.SmallImage; itemvm.LargeImage = item.LargeImage; //HttpPostedFileBase fup = Request.Files["SmallImage"]; //if(fup!=null) //{ // if(fup.FileName!="") // { // fup.SaveAs(Server.MapPath("~/img/dogaccessories" + fup.FileName)); // } //} //HttpPostedFileBase fup1 = Request.Files["LargeImage"]; //if (fup1 != null) //{ // if (fup1.FileName != "") // { // fup1.SaveAs(Server.MapPath("~/img/dogaccessories" + fup1.FileName)); // itemvm.LargeImage = item.LargeImage; // } //} itemvm.IsAvailable = "Available"; ViewBag.SubMenus = db.tblSubMenus.ToList(); return(View(itemvm)); } } }
public ActionResult Delete(int id) { using (OnlineFoodDBEntities db = new OnlineFoodDBEntities()) { tblItem sm = db.tblItems.Where(x => x.ItemId == id).FirstOrDefault(); db.tblItems.Remove(sm); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit([Bind(Include = "ItemId,ItemDescription,IsPicked,SectorId,InventoryId")] tblItem tblItem) { if (ModelState.IsValid) { db.Entry(tblItem).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("IndexItem", new { sectorId = tblItem.SectorId, inventoryId = tblItem.InventoryId })); } ViewBag.InventoryId = new SelectList(db.tblInventories, "InventoryId", "InventoryName", tblItem.InventoryId); ViewBag.SectorId = new SelectList(db.tblSectors, "SectorId", "SectorName", tblItem.SectorId); return(View(tblItem)); }
public ActionResult AddProduct(string code, string name, string fabric, string priceO, string discount, string priceNet, int cat, string mcat, int lotId, string articleId, string desc, string[] picsArr) { try { int assignedID = 0; using (linqDBContext db = new linqDBContext()) { int getCatId = (from a in db.tblMainCategories where a.name == mcat select a.id).FirstOrDefault(); tblItem it = new tblItem(); it.itemCode = code; it.itemName = name; it.fabric = fabric; it.originalPrice = Convert.ToDecimal(priceO); it.discount = Convert.ToDecimal(discount); it.netPrice = Convert.ToDecimal(priceNet); it.subCategory = cat; it.mainCategory = getCatId; it.description = desc; it.tag = ""; it.articleId = articleId; it.lotId = lotId; it.date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.tblItems.Add(it); db.SaveChanges(); assignedID = it.id; if (picsArr != null) { foreach (var item in picsArr) { //var physicalPath = Path.Combine(Server.MapPath(subPath), item); tblItemPicture p = new tblItemPicture(); p.itemID = assignedID; p.picLocation = item; db.tblItemPictures.Add(p); db.SaveChanges(); } } } return(Json(new JsonResult() { Data = assignedID }, JsonRequestBehavior.AllowGet)); } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
//-> Edit public async Task <ItemViewDTO> Edit(ItemEditDTO editDTO) { editDTO = StringHelper.TrimStringProperties(editDTO); tblItem item = db.tblItems.FirstOrDefault(r => r.item_Deleted == null && r.id == editDTO.id); if (item == null) { throw new HttpException((int)HttpStatusCode.NotFound, "This record has been deleted"); } var checkItemGroup = await db.tblItemGroups.FirstOrDefaultAsync(x => x.itmg_Deleted == null && x.id == editDTO.itemGroup.id); // check whether itemgroup name exist or not if (checkItemGroup == null) { throw new HttpException((int)HttpStatusCode.BadRequest, "Item group not exists"); } var checkItemCode = await db.tblItems.FirstOrDefaultAsync(r => r.item_Deleted == null && r.code == editDTO.code && r.id != editDTO.id); if (checkItemCode != null) { throw new HttpException((int)HttpStatusCode.BadRequest, "This item code already exsits"); } using (var transaction = db.Database.BeginTransaction()) { try { if (string.IsNullOrEmpty(editDTO.description)) { editDTO.description = editDTO.name; } item = (tblItem)Helper.Helper.MapDTOToDBClass <ItemEditDTO, tblItem>(editDTO, item); item.item_UpdatedDate = DateTime.Now; db.Entry(item).State = EntityState.Modified; await db.SaveChangesAsync(); //TODO : need to handle delete images or delete documents List <sm_doc> documents = await Helper.Helper.SaveUploadImage(db, item.name, Helper.Helper.document_ItemTableID, item.id, editDTO.images);// tmp not useful , just reserve data for using in the furture transaction.Commit(); return(await SelectByID(item.id)); } catch (Exception ex) { transaction.Rollback(); throw new Exception(ex.Message); } } }
public ActionResult Create([Bind(Include = "ItemId,ItemDescription,IsPicked,SectorId,InventoryId")] tblItem tblItem) { if (ModelState.IsValid) { db.tblItems.Add(tblItem); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.InventoryId = new SelectList(db.tblInventories, "InventoryId", "InventoryName", tblItem.InventoryId); ViewBag.SectorId = new SelectList(db.tblSectors, "SectorId", "SectorName", tblItem.SectorId); return(View(tblItem)); }
// GET: Items/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblItem tblItem = db.tblItems.Find(id); if (tblItem == null) { return(HttpNotFound()); } return(View(tblItem)); }
public ActionResult Create(tblItem data) { //try //{ data.dtCreationDate = DateTime.Now; ItemRepository.Add(data); ItemRepository.SaveChanges(); return(Ok()); //} //catch (Exception ex) //{ // return new HttpStatusCodeResult(HttpStatusCode.NotFound); //} }
private async Task SaveItemToWarehouses(tblItem item) { var wareHouses = await db.tblWarehouses.Where(r => r.ware_Deleted == null).ToListAsync(); foreach (var wareHouse in wareHouses) { var itemWareHouse = new tblItemWarehouse(); itemWareHouse.itemID = item.id; itemWareHouse.wareHouseID = wareHouse.id; itemWareHouse.quantity = 0; itemWareHouse.itwh_CreatedDate = DateTime.Now; db.tblItemWarehouses.Add(itemWareHouse); db.SaveChanges(); } }
public ActionResult Deleteitem(int id) { try { tblItem tb = (from p in db.tblItems where p.ItemId == id select p).SingleOrDefault(); tb.Active = false; db.SaveChanges(); TempData["Message"] = "Delete Successfully !!"; } catch { ModelState.AddModelError("", "Error Occured !"); } return(RedirectToAction("ItemDetails")); }
//-> create public async Task <ItemViewDTO> Create(ItemNewDTO newDTO) { newDTO = StringHelper.TrimStringProperties(newDTO); var checkItemGroup = await db.tblItemGroups.FirstOrDefaultAsync(x => x.itmg_Deleted == null && x.id == newDTO.itemGroup.id); // check whether itemgroup name exist or not if (checkItemGroup == null) { throw new HttpException((int)HttpStatusCode.BadRequest, "Item group not exist"); } var checkItemCode = await db.tblItems.FirstOrDefaultAsync(r => r.item_Deleted == null && r.code == newDTO.code); // check whether itemgroup name exist or not if (checkItemCode != null) { throw new HttpException((int)HttpStatusCode.BadRequest, "This item code already exsits"); } using (var transaction = db.Database.BeginTransaction()) { try { if (string.IsNullOrEmpty(newDTO.description)) { newDTO.description = newDTO.name; } tblItem item = (tblItem)Helper.Helper.MapDTOToDBClass <ItemNewDTO, tblItem>(newDTO, new tblItem()); item.item_CreatedDate = DateTime.Now; item.cost = 0; item.quantity = 0; item.lastCost = 0; db.tblItems.Add(item); await db.SaveChangesAsync(); List <sm_doc> documents = await Helper.Helper.SaveUploadImage(db, item.name, Helper.Helper.document_ItemTableID, item.id, newDTO.images);// tmp not useful , just reserve data for using in the furture await SaveItemToWarehouses(item); transaction.Commit(); return(await SelectByID(item.id)); } catch (Exception ex) { transaction.Rollback(); throw new Exception(ex.Message); } } }
public void updateDepartment(string ItemId, string DeptId) { int itemid = Convert.ToInt32(ItemId); int deptid = Convert.ToInt32(DeptId); tblItem tb = db.tblItems.Where(a => a.ItemId == itemid).SingleOrDefault(); tb.DepartmentId = deptid; //tb.CategoryId = tb.CategoryId; //tb.Description = tb.Description; //tb.ItemCode = tb.ItemCode; //tb.ItemImage = tb.ItemImage; //tb.Name = model.Name; //tb.Active = model.Active; db.SaveChanges(); TempData["item"] = "Record Updated Successfully..."; }
public tblItem Additem(int Typeid, string itemname, string SL, int isconsumable, int reorderpoint, decimal price) { var add = new tblItem() { ItemName = itemname, TypeId = Typeid, StorageLocation = SL, ReorderPoint = reorderpoint, IsConsumable = isconsumable, ItemPrice = price, Availablestock = 0, Qualityinspectionstock = 0, }; return(add); }
public ActionResult AddItem(AddItemModel model) { tblItem tb = new tblItem(); var itemcheck = (from p in db.tblItems where p.Name == model.Name && p.Active == true && p.CategoryId == model.ItemCategoryId select p).SingleOrDefault(); if (itemcheck == null) { try { if (model.ItemId > 0) { tb = (from p in db.tblItems where p.ItemId == model.ItemId select p).SingleOrDefault(); } tb.CategoryId = model.ItemCategoryId; tb.Description = model.Description; tb.ItemCode = model.ItemCode; tb.ItemImage = Image(); tb.Name = model.Name; tb.Active = model.Active; tb.DepartmentId = model.DepartmentId; if (model.ItemId > 0) { db.SaveChanges(); TempData["item"] = "Edit Successfully..!"; return(RedirectToAction("ItemDetails")); } else { db.tblItems.Add(tb); db.SaveChanges(); TempData["item"] = "Record Insert Successfully..!"; return(RedirectToAction("ItemDetails")); } } catch (Exception ex) { TempData["item"] = ex.Message; return(RedirectToAction("ItemDetails")); } } else { TempData["itemCreate"] = "This Item is already exist in this Category.."; return(RedirectToAction("AddItem")); } }
public ActionResult InputItem(int?id, string E) { if (id > 0 && E == "D") { tblItem model = db.tblItem.Find(id); db.Entry(model).State = EntityState.Deleted; db.SaveChanges(); TempData["msg"] = "Deleted Sucessfully!"; return(RedirectToAction("ItemDetails")); } else if (id > 0) { tblItem model = db.tblItem.Find(id); return(View(model)); } return(View()); }
protected void btnSubmit_Click(object sender, EventArgs e) { tblItem items = new tblItem(); if (db.tblItems.Any(d => d.Title == txtTitle.Text)) { Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + txtTitle.Text + " " + "already exists!" + "');", true); } else { items.Title = txtTitle.Text; items.SubSystemId = Int32.Parse(ddlSubSystem.SelectedValue); db.tblItems.Add(items); db.SaveChanges(); Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Added successfully');", true); txtTitle.Text = ""; } }
/// <summary> /// Adds the item if the itemID exists /// </summary> /// <param name="userID">the item that is being added for the user</param> /// <param name="item">the item that is being added</param> /// <returns>a new shopping cart element</returns> public tblShoppingCart AddItem(tblItem item, int userID) { int cartId = CartExists(item.ItemID, userID); try { using (OrderDBEntities context = new OrderDBEntities()) { if (cartId == 0) { tblShoppingCart newShoppingCart = new tblShoppingCart { Amount = item.Amount, UserID = userID, ItemID = item.ItemID }; context.tblShoppingCarts.Add(newShoppingCart); context.SaveChanges(); return(newShoppingCart); } else { tblShoppingCart shoppingCartToEdit = (from ss in context.tblShoppingCarts where ss.ShoppingCartID == cartId select ss).First(); shoppingCartToEdit.Amount = item.Amount; shoppingCartToEdit.UserID = shoppingCartToEdit.UserID; shoppingCartToEdit.ItemID = shoppingCartToEdit.ItemID; shoppingCartToEdit.ShoppingCartID = cartId; context.SaveChanges(); return(shoppingCartToEdit); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
// GET: Items/Edit/5 public ActionResult Edit(int?id, int sectorId, int inventoryId) { ViewBag.SectorId = sectorId; ViewBag.InventoryId = inventoryId; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblItem tblItem = db.tblItems.Find(id); if (tblItem == null) { return(HttpNotFound()); } ViewBag.InventoryId = new SelectList(db.tblInventories, "InventoryId", "InventoryName", tblItem.InventoryId); ViewBag.SectorId = new SelectList(db.tblSectors, "SectorId", "SectorName", tblItem.SectorId); return(View(tblItem)); }
/// <summary> /// Deletes item from shopping chart /// </summary> /// <param name="item">the item that is being deleted</param> /// <param name="userID">the user that has the item</param> public void RemoveItem(tblItem item, int userID) { int cartId = CartExists(item.ItemID, userID); try { using (OrderDBEntities context = new OrderDBEntities()) { tblShoppingCart shoppingCartToRemove = (from r in context.tblShoppingCarts where r.ShoppingCartID == cartId select r).First(); context.tblShoppingCarts.Remove(shoppingCartToRemove); context.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public ActionResult Create(ItemViewModel itm) { tblItem tb = new tblItem(); tb.ItemTitle = itm.ItemTitle; tb.ItemPrice = itm.ItemPrice; tb.ItemStatus = itm.ItemStatus; tb.Description = itm.Description; HttpPostedFileBase fup = Request.Files["ItemPhoto"]; if (fup != null) { tb.ItemPhoto = fup.FileName; fup.SaveAs(Server.MapPath("~/images/Vehicle/" + fup.FileName)); } _db.tblItems.Add(tb); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult EditItem(AddItemModel model) { try { tblItem tb = db.tblItems.Where(a => a.ItemId == model.ItemId).SingleOrDefault(); tb.CategoryId = model.ItemCategoryId; tb.DepartmentId = model.DepartmentId; tb.Description = model.Description; tb.ItemCode = model.ItemCode; tb.ItemImage = Image(); tb.Name = model.Name; tb.Active = model.Active; db.SaveChanges(); TempData["item"] = "Record Updated Successfully..."; return(RedirectToAction("ItemDetails")); } catch { TempData["item"] = "Record Not Updated !"; return(RedirectToAction("AddItem", new { id = model.ItemId })); } }
public void Additems(tblItem obj) { context.tblItems.Add(obj); }
/// <summary> /// /// </summary> /// <param name="item"></param> /// <returns></returns> public bool AddEditItem(Items item) { tblItem tblItem = new tblItem(); if (item != null && item.ItemGuid != Guid.Empty) { tblItem = bringlyEntities.tblItems .Where(x => x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid && x.ItemName == item.ItemName && x.ItemGuid != item.ItemGuid) .FirstOrDefault(); if (tblItem != null) { return(false); } else { tblItem.ItemGuid = item.ItemGuid; tblItem.ItemName = item.ItemName; tblItem.FK_CategoryGuid = item.CategoryGuid; tblItem.FK_BusinessGuid = item.BusinessGuid; tblItem.DeliveryCharge = item.DeliveryCharge; tblItem.ItemImage = item.ItemImage; tblItem.ItemName = item.ItemName; tblItem.ItemWeight = item.ItemWeight; tblItem.ItemSize = item.ItemSize; tblItem.ItemPrice = item.ItemPrice; tblItem.Discount = item.Discount; tblItem.ModifiedDate = DateTime.Now; tblItem.Modifiedby = UserVariables.LoggedInUserGuid; } } else { tblItem = bringlyEntities.tblItems .Where(x => x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid && x.ItemName == item.ItemName) .FirstOrDefault(); if (tblItem != null) { return(false); } else { tblItem = new tblItem(); tblItem.ItemGuid = Guid.NewGuid(); tblItem.FK_CreatedByGuid = UserVariables.LoggedInUserGuid; tblItem.ItemName = item.ItemName; tblItem.FK_CategoryGuid = item.CategoryGuid; tblItem.FK_BusinessGuid = item.BusinessGuid; tblItem.DeliveryCharge = item.DeliveryCharge; tblItem.ItemImage = string.IsNullOrEmpty(item.ItemImage) ? DefaultImage : item.ItemImage; tblItem.ItemWeight = item.ItemWeight; tblItem.ItemSize = item.ItemSize; tblItem.ItemPrice = item.ItemPrice; tblItem.Discount = item.Discount; tblItem.DateCreated = DateTime.Now; tblItem.IsActive = item.IsActive; tblItem.IsDeleted = false; bringlyEntities.tblItems.Add(tblItem); } } bringlyEntities.SaveChanges(); return(true); }
public ActionResult AddOrEdit(ItemViewModel ivm) { using (OnlineFoodDBEntities db = new OnlineFoodDBEntities()) { if (ivm.ItemId == 0) { tblItem itm = new tblItem(); itm.SubMenuId = Convert.ToInt32(ivm.SubMenuId); itm.Title = ivm.Title; itm.Price = ivm.Price; itm.Description = ivm.Description; HttpPostedFileBase fup = Request.Files["SmallImage"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/images/ItemImages/" + fup.FileName)); itm.SmallImage = fup.FileName; } } HttpPostedFileBase fup1 = Request.Files["LargeImage"]; if (fup1 != null) { if (fup1.FileName != "") { fup1.SaveAs(Server.MapPath("~/images/ItemImages/" + fup1.FileName)); itm.LargeImage = fup1.FileName; } } itm.IsAvailable = "Available"; db.tblItems.Add(itm); db.SaveChanges(); ViewBag.Message = "Updated Successfully"; } else { tblItem itm = db.tblItems.Where(i => i.ItemId == ivm.ItemId).FirstOrDefault(); itm.SubMenuId = Convert.ToInt32(ivm.SubMenuId); itm.Title = ivm.Title; itm.Price = ivm.Price; itm.Description = ivm.Description; HttpPostedFileBase fup = Request.Files["SmallImage"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/images/ItemImages/" + fup.FileName)); itm.SmallImage = fup.FileName; } } HttpPostedFileBase fup1 = Request.Files["LargeImage"]; if (fup1 != null) { if (fup1.FileName != "") { fup1.SaveAs(Server.MapPath("~/images/ItemImages/" + fup1.FileName)); itm.LargeImage = fup1.FileName; } } db.SaveChanges(); ViewBag.Message = "Updated Successfully"; } ViewBag.SubMenus = db.tblSubMenus.ToList(); return(View(new ItemViewModel())); } }
public ActionResult ItemDetails() { var itemsKOT = (from p in dbKOT.VM_PAOItemsFood select p).ToList(); var itemsCount = (from p in db.tblItems select p).ToList().Count; if (itemsKOT.Count > itemsCount) { foreach (var item in itemsKOT) { var itemCategoryId = (from p in db.tblCategories where p.Name == item.ItemSubGroup select p.CategoryId).FirstOrDefault(); var itemcheck = (from p in db.tblItems where p.Name == item.ItemName && p.CategoryId == itemCategoryId select p).SingleOrDefault(); if (itemcheck == null) { tblItem tb = new tblItem(); tb.CategoryId = itemCategoryId; tb.DepartmentId = 2; tb.Description = item.AdditionalDetails; tb.ItemCode = item.ItemCode; tb.ItemImage = ""; tb.Name = item.ItemName; tb.Active = true; db.tblItems.Add(tb); db.SaveChanges(); } } } List <SelectListItem> CategoryList = (from m in db.tblCategories where m.Active == true select m).AsEnumerable().Select(m => new SelectListItem() { Text = m.Name, Value = m.CategoryId.ToString() }).ToList(); CategoryList.Add(new SelectListItem() { Text = "--Select Category-- ", Value = "0" }); CategoryList = CategoryList.OrderBy(o => o.Value).ToList(); //CategoryList.Sort(); ViewBag.categoryLIsts = new SelectList(CategoryList, "Value", "Text", "CategoryId"); List <SelectListItem> DepartmentList = (from m in db.tbl_Department where m.Active == true select m).AsEnumerable().Select(m => new SelectListItem() { Text = m.Department, Value = m.DepartmentID.ToString() }).ToList(); DepartmentList.Add(new SelectListItem() { Text = "--Select Department-- ", Value = "0" }); DepartmentList = DepartmentList.OrderBy(o => o.Value).ToList(); ViewBag.departmentLists = new SelectList(DepartmentList, "Value", "Text", "DepartmentId"); var data = (from p in db.tblItems where p.Active == true select p).ToList(); //var rotiya = (from p in db.tblItems where p.Active == true && p.CategoryId==73 select p).ToList(); List <AddItemModel> List = new List <AddItemModel>(); foreach (var item in data) { AddItemModel model = new AddItemModel(); model.ItemCategoryId = item.CategoryId; model.Name = item.Name; model.Description = item.Description; model.ItemCode = item.ItemCode; model.ItemId = item.ItemId; model.ItemImage = item.ItemImage; model.DepartmentId = item.DepartmentId; //model.MinimumQuantity = item.MinimumQuantity; model.Name = item.Name; //model.Unit = item.Unit; List.Add(model); } return(View(List)); }
public EditPOModel() { Order = new PM_Order(); stock = new tblStock(); Items = new tblItem(); }
public ActionResult UpdateReceipt(ReceiptViewModel oReceiptViewModel) { try { int userId = ((tblUser)Session["Admin"]).UserId; // updates receipt details tblReceipt receipt = db.tblReceipts.Where(m => m.ReceiptId == oReceiptViewModel.ReceiptId).FirstOrDefault(); receipt.SupplierName = oReceiptViewModel.SupplierName; receipt.BillingDate = oReceiptViewModel.BillingDate; receipt.LocationName = oReceiptViewModel.LocationName; receipt.Note = oReceiptViewModel.Note; receipt.TotalBillAmount = oReceiptViewModel.TotalBillAmount; db.Entry(receipt).State = EntityState.Modified; db.SaveChanges(); // updates receipt items if (oReceiptViewModel.ListOfReceiptItem != null) { foreach (var item in oReceiptViewModel.ListOfReceiptItem) { tblItem otblItem = db.tblItems.Where(m => m.ItemId == item.ItemId && m.ReceiptId == oReceiptViewModel.ReceiptId).FirstOrDefault(); otblItem.ItemName = item.ItemName; otblItem.Quantity = item.Quantity; otblItem.Price = item.Price; db.Entry(otblItem).State = EntityState.Modified; db.SaveChanges(); } } List <tblUserReceiptTag> userTags = (from d in db.tblUserReceiptTags where d.ReceiptId == oReceiptViewModel.ReceiptId select d).ToList(); // if user tags does not have any tags then add all items if (userTags.Count == 0) { if (oReceiptViewModel.TagIds != null) { foreach (int tid in oReceiptViewModel.TagIds) { tblUserReceiptTag receiptTag = new tblUserReceiptTag(); receiptTag.TagsId = tid; receiptTag.ReceiptId = oReceiptViewModel.ReceiptId; receiptTag.UserId = userId; db.tblUserReceiptTags.Add(receiptTag); db.SaveChanges(); } } } else { // if tagids dont have any tag then delete all tags if (oReceiptViewModel.TagIds == null) { foreach (tblUserReceiptTag usertag in userTags) { db.tblUserReceiptTags.Remove(usertag); db.SaveChanges(); } } else { foreach (tblUserReceiptTag usertag in userTags) { bool isAvailable = oReceiptViewModel.TagIds.Contains(usertag.TagsId.Value); if (isAvailable == false) { tblUserReceiptTag receiptTag = (from y in db.tblUserReceiptTags where y.TagsId == usertag.TagsId select y).FirstOrDefault(); db.tblUserReceiptTags.Remove(receiptTag); db.SaveChanges(); } } foreach (int tagId in oReceiptViewModel.TagIds) { var checkIsAvailable = userTags.Where(m => m.TagsId == tagId).FirstOrDefault(); // if not availble if (checkIsAvailable == null) { tblUserReceiptTag receiptTag = new tblUserReceiptTag(); receiptTag.TagsId = tagId; receiptTag.ReceiptId = oReceiptViewModel.ReceiptId; receiptTag.UserId = userId; db.tblUserReceiptTags.Add(receiptTag); db.SaveChanges(); } } } } TempData["Success"] = "Receipt updated successfully."; return(RedirectToAction("ReceiptsList", "Receipts", new { page = Convert.ToInt32(Session["page"]), search = Session["Search"], area = "Admin" })); } catch (Exception ex) { GlobalVariable.objWriteLog.PrintMessage(Server.MapPath("~/ErrorLog/"), ex.Message); throw ex; } }