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));
}
