public JsonResult SaveUserPermission(int userTypeId, string pages) { var cStatus = "error"; var cMsg = Resources.NotifyMsg.ErrorMsg; var lstPagesIds = pages.TrimEnd(',').Split(','); using (var context = new kindergartenNetworkEntities()) { // delete existing records context.Database.ExecuteSqlCommand("DELETE FROM UserTypePages WHERE UserTypeId = @UserTypeId", new SqlParameter("@UserTypeId", userTypeId)); var x = context.Database.SqlQuery <kindergartenNetworkEntities>("SP_UserTypePagesAdd", new SqlParameter("@UserTypeId", userTypeId), new SqlParameter("@PageId", pages)); } //var lstUserPages = new List<UserTypePage>(); //foreach (var t in lstPagesIds) //{ // var utp = new UserTypePage {PageId = Convert.ToInt32(t), UserTypeId = userTypeId}; // db.UserTypePages.Add(utp); //} cStatus = "success"; cMsg = Resources.NotifyMsg.SuccessMsg; return(Json(new { cStatus, cMsg }, JsonRequestBehavior.AllowGet)); }