public ActionResult EditService(M_ServiceCategory data)
{
try
{
M_ServiceCategory dataval = new M_ServiceCategory();
dataval = (from u in db.M_ServiceCategory.ToList()
where u.ID2 == data.ID2
select u).FirstOrDefault();
dataval.CategoryNameSer = data.CategoryNameSer;
dataval.UpdateID = user.UserName;
dataval.UpdateDate = DateTime.Now;
M_ServiceCategory checker = (from c in db.M_ServiceCategory
where c.CategoryNameSer == data.CategoryNameSer
&& 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 CreateService(M_ServiceCategory data)
{
try
{
data.CreateID = "Admin";
data.CreateDate = DateTime.Now;
data.UpdateID = "Admin";
data.UpdateDate = DateTime.Now;
data.IsDeleted = false;
M_ServiceCategory checker = (from c in db.M_ServiceCategory
where c.CategoryNameSer == data.CategoryNameSer &&
c.IsDeleted == false
select c).FirstOrDefault();
if (checker == null)
{
db.M_ServiceCategory.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 DeleteService(int ID)
{
try
{
M_ServiceCategory dataval = new M_ServiceCategory();
dataval = (from u in db.M_ServiceCategory.ToList()
where u.ID2 == 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));
}
}
