public ActionResult EditItemPrice(mItemPrice itemdata) { try { mItemPrice item = new mItemPrice(); item = (from u in db.mItemPrices.ToList() where u.ItemCode == itemdata.ItemCode select u).FirstOrDefault(); item.Currency = itemdata.Currency; item.UnitPrice = itemdata.UnitPrice; item.Update_User = "******"; item.Update_Date = DateTime.Now; db.Entry(item).State = EntityState.Modified; db.SaveChanges(); } catch (Exception err) { } return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateItem(mItem item) { item.SiteCode = System.Web.HttpContext.Current.Session["user"].ToString(); string gencode = string.Empty; string lastgencode = (from u in db.mItems.ToList() orderby u.ItemCode descending select u.ItemCode).FirstOrDefault(); if (lastgencode == null) { gencode = "ITM0001"; } else { gencode = lastgencode.Substring(3); int upId = Convert.ToInt32(gencode.TrimStart(new char[] { '0' })) + 1; gencode = string.Format("ITM{0}", upId.ToString().PadLeft(4, '0')); } item.ItemCode = gencode; item.Is_Deleted = false; item.Create_Date = DateTime.Now; item.Create_User = user.UserID; item.Update_Date = DateTime.Now; item.Update_User = user.UserID; mItem checker = (from c in db.mItems where c.ItemName == item.ItemName && c.Description == item.Description && c.CusSupCode == item.CusSupCode && c.CargoClass == item.CargoClass && c.BaseMeasurement == item.BaseMeasurement && c.SiteCode == item.SiteCode && c.Is_Deleted == false select c).FirstOrDefault(); if (checker == null) { try { db.mItems.Add(item); db.SaveChanges(); mItemPrice itemprice = new mItemPrice(); itemprice.ItemCode = gencode; itemprice.Is_Deleted = false; itemprice.Create_Date = DateTime.Now; itemprice.Create_User = user.UserID; itemprice.Update_Date = DateTime.Now; itemprice.Update_User = user.UserID; db.mItemPrices.Add(itemprice); db.SaveChanges(); } catch (Exception err) { } } else { return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet)); } return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet)); }