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