public ActionResult CreateCategory(M_ItemCategory data)
{
try
{
data.CreateID = "Admin";
data.CreateDate = DateTime.Now;
data.UpdateID = "Admin";
data.UpdateDate = DateTime.Now;
data.IsDeleted = false;
M_ItemCategory checker = (from c in db.M_ItemCategory
where c.CategoryName == data.CategoryName &&
c.IsDeleted == false
select c).FirstOrDefault();
if (checker == null)
{
db.M_ItemCategory.Add(data);
db.SaveChanges();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception err)
{
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditCategory(M_ItemCategory data)
{
try
{
M_ItemCategory dataval = new M_ItemCategory();
dataval = (from u in db.M_ItemCategory.ToList()
where u.ID == data.ID
select u).FirstOrDefault();
dataval.CategoryName = data.CategoryName;
dataval.UpdateID = user.UserName;
dataval.UpdateDate = DateTime.Now;
M_ItemCategory checker = (from c in db.M_ItemCategory
where c.CategoryName == data.CategoryName
&& c.IsDeleted == false
select c).FirstOrDefault();
if (checker == null)
{
db.Entry(dataval).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception err)
{
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteCategory(int ID)
{
try
{
M_ItemCategory dataval = new M_ItemCategory();
dataval = (from u in db.M_ItemCategory.ToList()
where u.ID == ID
select u).FirstOrDefault();
dataval.IsDeleted = true;
db.Entry(dataval).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
