// GET: Items/EditItem/1 public ActionResult EditItem(int id) { if (!WebSecurity.IsAuthenticated) { ViewBag.CloseWindow = true; ViewBag.LogoutUser = true; return(RedirectToAction("Logout", "Account")); } if (id < 1) { ViewBag.Message = "Item not found!"; ViewBag.CloseWindow = true; return(View()); } gp_InventoryItems dbitem = db.gp_InventoryItems.Find(id); if (id < 1 || dbitem == null) { ViewBag.Message = "Item not found!"; ViewBag.CloseWindow = true; return(View()); } gp_InventoryItems current_item = db.gp_InventoryItems.AsNoTracking().Where(d => d.ItemId == id).First(); mdl_Item item = new mdl_Item(); item.ItemId = dbitem.ItemId; item.VendorItemNumber = dbitem.VNDITNUM; item.VendorItemDescription = dbitem.VNDITDSC; return(PartialView(item)); }
public JsonNetResult AddItem(string collection) { //server response obj_ServerResponse response = new obj_ServerResponse(); int affectedRows = 0; JavaScriptSerializer jsonSerializer = new JavaScriptSerializer(); mdl_Item item = jsonSerializer.Deserialize <mdl_Item>(collection); var context = new ValidationContext(item); var results = new List <ValidationResult>(); if (Validator.TryValidateObject(item, context, results, true)) { //validate existing vendor item number IQueryable <gp_InventoryItems> existingItems = db.gp_InventoryItems.Where(d => d.VNDITNUM == item.VendorItemNumber); if (existingItems.Count() > 0) { response.MessageType = "warning"; response.Message = "An item already has that vendor code, try again!"; response.ShowDialog = true; return(new JsonNetResult(response)); } gp_InventoryItems dbItem = new gp_InventoryItems(); dbItem.VNDITNUM = item.VendorItemNumber; dbItem.VNDITDSC = item.VendorItemDescription; dbItem.CustomItem = true; dbItem.DateCreated = DateTime.Now; db.gp_InventoryItems.Add(dbItem); affectedRows = db.SaveChanges(); if (affectedRows > 0) { response.MessageType = "success"; response.Message = "Item added successfully!"; response.ShowDialog = true; } else { response.MessageType = "danger"; response.Message = "There was a problem saving this item!"; response.ShowDialog = true; } } else { response.Errors = results.Select(d => new KeyValuePair <string, string>(d.MemberNames.First().ToString(), d.ErrorMessage)); } return(new JsonNetResult(response)); }
public JsonNetResult GetConsumerReport(int id, int month) { gp_InventoryItems gpItem = db.gp_InventoryItems.Find(id); List <mdl_ConsumerReport> consumers = db.AAA2018_CONSUMER_REPORT_DATA(gpItem.VNDITNUM, 2012, month) .Select(d => new mdl_ConsumerReport() { Average = d.Average, CustomerName = d.CustomerName, CustomerNumber = d.CustomerNumber, MonthUsage = d.MonthlyUsage, Quantity = d.OverallUsage, Rank = d.Rank }) .ToList <mdl_ConsumerReport>(); return(new JsonNetResult(consumers)); }
public ActionResult DeleteItem(int id) { //server response obj_ServerResponse response = new obj_ServerResponse(); int affectedRows = 0; gp_InventoryItems dbItem = db.gp_InventoryItems.Find(id); if (id < 1 || dbItem == null) { //item not found response.MessageType = "warning"; response.Message = "Item not found!"; response.ShowDialog = true; } //only delete custom, unsynced items if (dbItem.CustomItem != true || dbItem.Synced == true) { //item not found response.MessageType = "warning"; response.Message = "Can't delete this item!"; response.ShowDialog = true; return(new JsonNetResult(response)); } db.gp_InventoryItems.Remove(dbItem); affectedRows = db.SaveChanges(); if (affectedRows > 0) { response.MessageType = "success"; response.Message = "Item deleted successfully!"; response.ShowDialog = true; } else { response.MessageType = "warning"; response.Message = "There was a problem deleting this item!"; response.ShowDialog = true; } return(new JsonNetResult(response)); }
public JsonNetResult EditItem(string collection) { //server response obj_ServerResponse response = new obj_ServerResponse(); int affectedRows = 0; JavaScriptSerializer jsonSerializer = new JavaScriptSerializer(); mdl_Item item = jsonSerializer.Deserialize <mdl_Item>(collection); var context = new ValidationContext(item); var results = new List <ValidationResult>(); if (Validator.TryValidateObject(item, context, results, true)) { gp_InventoryItems dbItem = db.gp_InventoryItems.Find(item.ItemId); if (dbItem == null) { //item not found response.MessageType = "warning"; response.Message = "Item not found!"; response.ShowDialog = true; } //validate existing vendor item number IQueryable <gp_InventoryItems> existingItems = db.gp_InventoryItems.Where(d => d.VNDITNUM == item.VendorItemNumber && d.ItemId != item.ItemId); if (existingItems.Count() > 0) { response.MessageType = "warning"; response.Message = "An item already has that vendor code, try again!"; response.ShowDialog = true; return(new JsonNetResult(response)); } //only edit custom, unsynced items if (dbItem.CustomItem != true || dbItem.Synced == true) { //item not found response.MessageType = "warning"; response.Message = "Can't edit this item!"; response.ShowDialog = true; return(new JsonNetResult(response)); } gp_InventoryItems currentItem = db.gp_InventoryItems.AsNoTracking().Where(d => d.ItemId == item.ItemId).First(); dbItem.VNDITNUM = item.VendorItemNumber; dbItem.VNDITDSC = item.VendorItemDescription; db.Entry(dbItem).State = EntityState.Modified; affectedRows = db.SaveChanges(); if (affectedRows > 0) { response.MessageType = "success"; response.Message = "Item updated successfully!"; response.ShowDialog = true; } else { response.MessageType = "warning"; response.Message = "There was a problem updating this item!"; response.ShowDialog = true; } } else { response.Errors = results.Select(d => new KeyValuePair <string, string>(d.MemberNames.First().ToString(), d.ErrorMessage)); } return(new JsonNetResult(response)); }