public ActionResult CreateItemUnit(mItemUnit itemunit, int stockqty, mItemUnit InnerCase, mItemUnit PerUnit)
{
mItemUnit checker = (from c in db.mItemUnits where c.ItemCode == itemunit.ItemCode select c).FirstOrDefault();
if (checker != null)
{
List <mItemUnit> del = (from d in db.mItemUnits where d.ItemCode == itemunit.ItemCode select d).ToList();
foreach (mItemUnit t in del)
{
db.mItemUnits.Remove(t);
db.SaveChanges();
}
List <mItemCategory> dels = (from d in db.mItemCategories where d.ItemCode == itemunit.ItemCode select d).ToList();
foreach (mItemCategory t in dels)
{
db.mItemCategories.Remove(t);
db.SaveChanges();
}
}
itemunit.Is_Deleted = false;
itemunit.Create_Date = DateTime.Now;
itemunit.Create_User = user.UserID;
itemunit.Update_Date = DateTime.Now;
itemunit.Update_User = user.UserID;
itemunit.MaintainingQty = stockqty;
InnerCase.Is_Deleted = false;
InnerCase.Create_Date = DateTime.Now;
InnerCase.Create_User = user.UserID;
InnerCase.Update_Date = DateTime.Now;
InnerCase.Update_User = user.UserID;
InnerCase.MaintainingQty = stockqty;
PerUnit.Is_Deleted = false;
PerUnit.Create_Date = DateTime.Now;
PerUnit.Create_User = user.UserID;
PerUnit.Update_Date = DateTime.Now;
PerUnit.Update_User = user.UserID;
PerUnit.MaintainingQty = stockqty;
try
{
db.mItemUnits.Add(itemunit);
db.SaveChanges();
db.mItemUnits.Add(InnerCase);
db.SaveChanges();
db.mItemUnits.Add(PerUnit);
db.SaveChanges();
}
catch (Exception err) { }
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDetails(string ItemCode, string Type)
{
mItemUnit unit = new mItemUnit();
List <mItemUnit> list = new List <mItemUnit>();
if (Type != "")
{
unit = (from c in db.mItemUnits where c.ItemCode == ItemCode && c.Type == Type select c).FirstOrDefault();
}
else
{
list = (from c in db.mItemUnits where c.ItemCode == ItemCode select c).ToList();
}
return(Json(new { result = "success", unit = unit, list = list }, JsonRequestBehavior.AllowGet));
}
