public bool EditSector(tblCommonElement sector)
        {
            var orgSec = context.tblCommonElements.Where(ss => ss.ID == sector.ID).FirstOrDefault();

            orgSec.elementName = sector.elementName;
            return(context.SaveChanges() > 0);
        }
        public bool DeleteSector(tblCommonElement sector)
        {
            var orgSec = context.tblCommonElements.Where(ss => ss.ID == sector.ID).FirstOrDefault();

            context.tblCommonElements.Remove(orgSec);
            return(context.SaveChanges() > 0);
        }
        public bool SaveSector(tblCommonElement sector)
        {
            int maxId = context.tblCommonElements.Select(cc => cc.ID).DefaultIfEmpty(0).Max();

            sector.ID = ++maxId;
            //sector.elementCode = 3;
            context.tblCommonElements.Add(sector);
            return(context.SaveChanges() > 0);
        }
Esempio n. 4
0
 public JsonResult DeleteSector([System.Web.Http.FromBody] tblCommonElement sector)
 {
     if (Session["role"] == null)
     {
         Session["userId"] = null;
         Session["role"]   = null;
         return(Json(false, JsonRequestBehavior.AllowGet));
     }
     else if (Session["role"].ToString() == "Super Admin")
     {
         return(Json(sectorRepository.DeleteSector(sector), JsonRequestBehavior.AllowGet));
     }
     else
     {
         Session["userId"] = null;
         Session["role"]   = null;
         return(Json(false, JsonRequestBehavior.AllowGet));
     }
 }
Esempio n. 5
0
 public JsonResult SaveSector(tblCommonElement sector)
 {
     if (Session["role"] == null)
     {
         Session["userId"] = null;
         Session["role"]   = null;
         return(Json(false, JsonRequestBehavior.AllowGet));
     }
     else if (Session["role"].ToString() == "Admin" || Session["role"].ToString() == "Super Admin" || Session["role"].ToString() == "User")
     {
         return(Json(sectorRepository.SaveSector(sector), JsonRequestBehavior.AllowGet));
     }
     else
     {
         Session["userId"] = null;
         Session["role"]   = null;
         return(Json(false, JsonRequestBehavior.AllowGet));
     }
 }