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