public ActionResult CreateService(M_Service data)
{
try
{
data.CreateID = user.CreateID;
data.CreateDate = DateTime.Now;
data.UpdateID = user.CreateID;
data.UpdateDate = DateTime.Now;
data.IsDeleted = false;
M_Service checker = (from c in db.M_Service
where c.ServiceName == data.ServiceName &&
c.ServiceCategory == data.ServiceCategory &&
c.Price == data.Price &&
c.IsDeleted == false
select c).FirstOrDefault();
if (checker == null)
{
db.M_Service.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_Service dataval = new M_Service();
dataval = (from u in db.M_Service.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));
}
}
public ActionResult EditService(M_Service data)
{
try
{
M_Service dataval = new M_Service();
dataval = (from u in db.M_Service.ToList()
where u.ID == data.ID
select u).FirstOrDefault();
dataval.ServiceCategory = data.ServiceCategory;
dataval.ServiceName = data.ServiceName;
dataval.Price = data.Price;
dataval.Photo = data.Photo;
dataval.UpdateID = user.UserName;
dataval.UpdateDate = DateTime.Now;
M_Service checker = (from c in db.M_Service
where c.ServiceName == data.ServiceName &&
c.ServiceCategory == data.ServiceCategory &&
c.Price == data.Price &&
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));
}
}