public AdminUserModel GetUserById(int userId) { var db = new HospitalTransparencyEntities(); IList <AdminUserModel> details = new List <AdminUserModel>(); var data = (from m in db.AdminPanelUserMasters where m.UserId == userId select new { m.Email, m.UserId, m.IsActive, m.Name, m.Password, m.Username, m.CreatedOn, m.RoleId, m.ImagePath }).FirstOrDefault(); var userData = new AdminUserModel(); { userData.UserId = data.UserId; userData.Email = data.Email; userData.IsActive = data.IsActive; userData.Name = data.Name; userData.Password = data.Password; userData.Username = data.Username; userData.RoleId = data.RoleId; userData.Image = data.ImagePath; } return(userData); }
public bool DeleteAllRole(string roleIds) { var db = new HospitalTransparencyEntities(); foreach (var item in roleIds.Split(',')) { var roleId = Convert.ToInt64(item); var roleData = db.RoleMasters.Find(roleId); if (roleData != null) { roleData.ModifiedOn = DateTime.Now; roleData.IsDeleted = true; roleData.ModifiedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"]); db.Entry(roleData).CurrentValues.SetValues(roleData); } var rightsData = db.RightsMasters.Where(m => m.RoleId == roleId).ToList(); if (rightsData.Any()) { foreach (var rightsItem in rightsData) { var rightsDetail = db.RightsMasters.Find(rightsItem.RightsId); if (rightsDetail != null) { db.Entry(rightsDetail).State = EntityState.Deleted; } } } } db.SaveChanges(); return(true); }
public static void Email(string emailId, string subject, string body) { using (var db = new HospitalTransparencyEntities()) { var mailSettings = db.MailSettings.FirstOrDefault(m => m.Id == "1"); if (mailSettings != null) { var mail = new MailMessage { IsBodyHtml = true, Body = body, From = new MailAddress(mailSettings.UserName, mailSettings.FromName) }; mail.To.Add(emailId); mail.Subject = "Forgot Password"; var cred = new NetworkCredential(mailSettings.UserName, mailSettings.Password); var smtp = new SmtpClient(mailSettings.ServerHost, Convert.ToInt16(mailSettings.ServerPort)) { EnableSsl = mailSettings.SSL, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = cred }; smtp.SendMailAsync(mail); } } }
public bool UpdateRights(RightsMaster rights) { using (var db = new HospitalTransparencyEntities()) { db.RightsMasters.Add(rights); db.Entry(rights).State = EntityState.Modified; db.SaveChanges(); } return(true); }
public ActionResult GetParentMenuByChild_MenuMaster(int parentId) { string parentid = string.Empty; using (var db1 = new HospitalTransparencyEntities()) { var menu = db1.MenuMasters.Where(m => m.ParentId == parentId && m.IsActive == true).ToList(); return(Json(new { parentid = parentid, menu = menu }, JsonRequestBehavior.AllowGet)); } }
public string IconList(string icon) { using (var db = new HospitalTransparencyEntities()) { var iconList = (from rm in db.MenuIcons orderby rm.DisplayHTML select new { IconClass = rm.IconClass.Replace("glyphicon glyphicon-", ""), rm.Id }).ToList(); ViewBag.IconList = !string.IsNullOrEmpty(icon) ? new SelectList(iconList, "Id", "IconClass", icon) : new SelectList(iconList, "Id", "IconClass"); } return("Yes"); }
public string ParentList(string parent) { using (var db = new HospitalTransparencyEntities()) { var parentList = (from rm in db.MenuMasters where /* rm.ParentId == null &&*/ rm.IsDeleted == false && rm.IsActive == true select new { rm.MenuId, rm.MenuName }).OrderBy(m => m.MenuName).ToList(); ViewBag.ParentMenuList = !string.IsNullOrEmpty(parent) ? new SelectList(parentList, "MenuId", "MenuName", parent) : new SelectList(parentList, "MenuId", "MenuName"); } return("Yes"); }
private void Dispose(bool disposing) { if (!_disposed) { if (disposing) { using (var db = new HospitalTransparencyEntities()) { db.Dispose(); } } } _disposed = true; }
public JsonResult ManageRootMenu(int RoleId, int MenuId) { using (var db = new HospitalTransparencyEntities()) { var getComData = (from c in db.MenuMasters where c.MenuId == MenuId && c.ParentId != null select c).ToList(); if (getComData.Any()) { int?parentId = 0; foreach (var item in getComData) { parentId = item.ParentId; } getComData = (from c in db.MenuMasters where c.IsActive == true && c.IsDeleted == false && c.ParentId == parentId select c).ToList(); } return(Json(getComData, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetParentMenuByChild(int childMenuId, int roleId) { int?parentid = 0; using (var db1 = new HospitalTransparencyEntities()) { var Data = db1.MenuMasters.Where(m => m.MenuId == childMenuId).ToList(); if (Data.Count > 0) { parentid = Data.First().ParentId; var menu = db1.Sp_GetParentMenuByChildId(parentid, roleId).ToList(); return(Json(new { parentid = parentid, menu = menu }, JsonRequestBehavior.AllowGet)); } return(Json(new { parentid = parentid, }, JsonRequestBehavior.AllowGet)); } }
public string RoleList(int?roleId) { using (var db = new HospitalTransparencyEntities()) { var sessioRoleId = Convert.ToInt32(Session["RoleId"]); var roleList = (from rm in db.RoleMasters where rm.IsDeleted == false && rm.IsActive == true select new { rm.RoleId, rm.RoleName }).ToList(); if (sessioRoleId != 1) { roleList = roleList.Where(m => m.RoleId != 1).ToList(); } ViewBag.RoleData = roleId != 0 ? new SelectList(roleList, "RoleId", "RoleName", roleId) : new SelectList(roleList, "RoleId", "RoleName"); } return("Yes"); }
public ActionResult MenuIconList() { var model = new MenuModel(); using (var db = new HospitalTransparencyEntities()) { var iconList = (from rm in db.MenuIcons orderby rm.DisplayHTML select new { IconClass = rm.IconClass, rm.Id }).ToList(); model.MenuList = (from i in iconList select new SelectListItem() { Text = i.IconClass, Value = Convert.ToString(i.Id) }).ToList(); } return(PartialView("MenuIcons", model)); }
public bool DeleteUser(int userId) { var db = new HospitalTransparencyEntities(); var userData = db.AdminPanelUserMasters.Find(userId); if (userData != null) { userData.ModifiedDate = DateTime.Now; userData.IsDeleted = true; userData.IsActive = false; userData.DeletedDate = DateTime.Now; userData.ModifiedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"]); db.Entry(userData).CurrentValues.SetValues(userData); db.SaveChanges(); } return(true); }
public bool DeleteAllMenu(string menuIds) { var db = new HospitalTransparencyEntities(); foreach (var item in menuIds.Split(',')) { var menuId = Convert.ToInt64(item); var menuData = db.MenuMasters.Find(menuId); if (menuData != null) { menuData.ModifiedOn = DateTime.Now; menuData.IsDeleted = true; menuData.ModifiedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"]); db.Entry(menuData).CurrentValues.SetValues(menuData); } } db.SaveChanges(); return(true); }
public IEnumerable <RightsListModel> GetRightsList() { List <RightsListModel> pageDetails = new List <RightsListModel>(); using (var db = new HospitalTransparencyEntities()) { DataTable dt = new DataTable(); int roleId = Convert.ToInt32(HttpContext.Current.Session["RoleId"].ToString()); List <MenuList> myQuery = CustomCacheManagement.MenuList.Where(m => m.RoleId == roleId).OrderBy(m => m.ParentId).ThenBy(m => m.OrderBy).ToList(); dt = ToDataTable <MenuList>(myQuery); pageDetails = GetTopLevelRows(dt) .Select(row => CreateItem(dt, row)) .ToList(); var controller = Convert.ToString(HttpContext.Current.Request.RequestContext.RouteData.Values["controller"]).ToLower(); //if (controller.ToLower() != "widgetrights") //{ // controller = controller.Replace("Home", "Dashboard").Replace("AdminUser", "AdminPanelUser").Replace("Rights", "RightsMaster").ToLower(); //} var actionName = myQuery.Where(m => m.ControllerName == controller).ToList().FirstOrDefault(); var action = ""; if (actionName != null) { action = actionName.ActionName.ToLower(); } var roleQuery = myQuery.Where(m => m.ActionName == action && m.ControllerName == controller).FirstOrDefault(); if (roleQuery != null) { HttpContext.Current.Session["RightAdd"] = roleQuery.Add; HttpContext.Current.Session["RightEdit"] = roleQuery.Edit; HttpContext.Current.Session["RightDelete"] = roleQuery.Delete; HttpContext.Current.Session["RightDisplay"] = roleQuery.Display; HttpContext.Current.Session["MenuId"] = roleQuery.MenuId; HttpContext.Current.Session["ParentMenuId"] = roleQuery.ParentIdList; } return(pageDetails); } }
public ActionResult AddRights(int roleId, string[] menuData) { using (var db = new HospitalTransparencyEntities()) { #region Remove rights first from table db.Database.ExecuteSqlCommand("Delete from RightsMaster where RoleId = '" + roleId + "'"); #endregion #region If rights are not for Super Admin then Update Rights for all users for that particular role foreach (var item in menuData) { var menus = item.Split(','); var menuId = menus[0]; bool?add = Convert.ToBoolean(menus[1]); bool?edit = Convert.ToBoolean(menus[2]); bool?delete = Convert.ToBoolean(menus[3]); bool?display = Convert.ToBoolean(menus[4]); var right = new RightsModel(); right.MenuId = int.Parse(menuId); right.RoleId = roleId; right.Add = add; right.Edit = edit; right.Display = display; right.Delete = delete; right.ClientId = null; right.UserId = null; right.CreatedBy = Convert.ToInt32(System.Web.HttpContext.Current.Session["UserId"]); right.CreatedDate = DateTime.Now; using (var context = new RightsRepository()) { context.AddRights(right); } } CustomCacheManagement.MenuList = new RightsListRepository().GetMenuList(); #endregion return(Json(true, JsonRequestBehavior.AllowGet)); } }
public IEnumerable <RightsModel> GetRightsDetails(string userId) { IList <RightsModel> rightsDetails = new List <RightsModel>(); using (var db = new HospitalTransparencyEntities()) { var rightsData = db.Sp_MenuRightsList().ToList(); foreach (var item in rightsData) { var pageModel = new RightsModel(); { //pageModel.MenuId = item.MenuId; //pageModel.MenuName = item.MenuName; //pageModel.MenuType = item.MenuType; //rightsDetails.Add(pageModel); } } } return(rightsDetails); }
public IEnumerable <RightsModel> GetRightsByRoleId(int roleId) { using (var db = new HospitalTransparencyEntities()) { IList <RightsModel> details = new List <RightsModel>(); var data = (from mm in db.MenuMasters join rm in db.RightsMasters on mm.MenuId equals rm.MenuId into rights from right in rights.DefaultIfEmpty() where right.RoleId == roleId && mm.IsDeleted == false && mm.IsActive == true select new { right.Display, right.MenuId, right.Add, right.Delete, right.Edit, right.RightsId, right.RoleId, mm.MenuName }).ToList(); if (data.Count() > 0) { foreach (var item in data) { var rights = new RightsModel(); { rights.MenuId = item.MenuId; rights.MenuName = item.MenuName; rights.Add = item.Add; rights.Edit = item.Edit; rights.Delete = item.Delete; rights.Display = item.Display; rights.RoleId = item.RoleId; details.Add(rights); } } } return(details); } }
public bool DeleteAllUser(string userIds) { var db = new HospitalTransparencyEntities(); foreach (var item in userIds.Split(',')) { var userId = Convert.ToInt64(item); var userData = db.AdminPanelUserMasters.Find(userId); if (userData != null) { userData.ModifiedDate = DateTime.Now; userData.IsDeleted = true; userData.IsActive = false; userData.DeletedDate = DateTime.Now; userData.ModifiedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"]); db.Entry(userData).CurrentValues.SetValues(userData); } } db.SaveChanges(); return(true); }
public bool AddRights(RightsModel rights) { using (var db = new HospitalTransparencyEntities()) { var pageData = new RightsMaster(); { pageData.RoleId = rights.RoleId; pageData.MenuId = rights.MenuId; pageData.Add = Convert.ToBoolean(rights.Add); pageData.Edit = Convert.ToBoolean(rights.Edit); pageData.Delete = Convert.ToBoolean(rights.Delete); pageData.Display = Convert.ToBoolean(rights.Display); pageData.CreatedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"].ToString()); pageData.CreatedDate = DateTime.Now; pageData.ModifiedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"].ToString()); pageData.ModifiedDate = DateTime.Now; db.RightsMasters.Add(pageData); db.SaveChanges(); } } return(true); }
public string RoleList(string role) { int roleid = Convert.ToInt32(Session["RoleId"].ToString()); using (var db = new HospitalTransparencyEntities()) { if (roleid == 1) { var roleList = (from rm in db.RoleMasters where rm.IsDeleted == false && rm.IsActive == true select new { rm.RoleId, rm.RoleName, rm.DisplayOrder }).Distinct().OrderBy(r => r.RoleName).ToList(); ViewBag.roleList = !string.IsNullOrEmpty(role) ? new SelectList(roleList, "RoleId", "RoleName", role) : new SelectList(roleList, "RoleId", "RoleName"); } else { var roleList = (from rm in db.RoleMasters where rm.IsDeleted == false && rm.IsActive == true && rm.RoleId == roleid select new { rm.RoleId, rm.RoleName, rm.DisplayOrder }).Distinct().OrderBy(r => r.RoleName).ToList(); ViewBag.roleList = !string.IsNullOrEmpty(role) ? new SelectList(roleList, "RoleId", "RoleName", roleid) : new SelectList(roleList, "RoleId", "RoleName"); } } return("Yes"); }
public IEnumerable <RightsModel> MenuList() { using (var db = new HospitalTransparencyEntities()) { var controller = HttpContext.Current.Request.RequestContext.RouteData.Values["controller"].ToString(); var getRoleId = Convert.ToInt32(HttpContext.Current.Session["RoleId"]); var actionName = new MenuMaster(); actionName = db.MenuMasters.Where(m => m.ControllerName == controller && m.IsActive == true).ToList().FirstOrDefault(); #region Active Menu if (actionName != null) { var menuId = actionName.MenuId; var parentId = actionName.ParentId; HttpContext.Current.Session["ActivemenuId"] = menuId; HttpContext.Current.Session["ActiveparentId"] = parentId; } #endregion var roleQuery = (from r in db.RightsMasters join m in db.MenuMasters on r.MenuId equals m.MenuId where m.ActionName == actionName.ActionName && m.ControllerName == controller && r.RoleId == getRoleId select new { r.Add, r.Edit, r.Display, r.Delete, r.MenuId, m.ParentId }).FirstOrDefault(); if (roleQuery != null) { HttpContext.Current.Session["RightAdd"] = roleQuery.Add; HttpContext.Current.Session["RightEdit"] = roleQuery.Edit; HttpContext.Current.Session["RightDelete"] = roleQuery.Delete; HttpContext.Current.Session["RightDisplay"] = roleQuery.Display; HttpContext.Current.Session["MenuId"] = roleQuery.MenuId; HttpContext.Current.Session["ParentMenuId"] = roleQuery.ParentId; } IList <RightsModel> rightsData = new List <RightsModel>(); var nquery = (from rm in db.RightsMasters join mm in db.MenuMasters on rm.MenuId equals mm.MenuId join mi in db.MenuIcons on mm.MenuIcon equals mi.Id where rm.RoleId == getRoleId && mm.IsActive == true && (rm.Add == true || rm.Edit == true || rm.Delete == true || rm.Display == true) orderby mm.OrderBy select new { rm.Add, rm.RoleId, rm.Delete, rm.Edit, rm.Display, mm.ControllerName, mm.MenuId, mm.ActionName, mm.MenuName, mm.ParentId, mi.IconClass }).ToList(); foreach (var courseData in nquery) { rightsData.Add(new RightsModel { Add = courseData.Add, Edit = courseData.Edit, Delete = courseData.Delete, Display = courseData.Display, ControllerName = courseData.ControllerName, ActionName = courseData.ActionName, MenuName = courseData.MenuName, ParentId = courseData.ParentId, MenuId = courseData.MenuId, MenuIcon = courseData.IconClass }); } return(rightsData); } }