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