/// <summary> /// method for checking duplicate emailid /// </summary> /// <param name="userName"></param> /// <returns></returns> public bool CheckDuplicateEmail(string emailID) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortalDbEntities portalEntities = new PortalDbEntities()) { bool result = false; var userData = portalEntities.UserAccounts.Where(x => x.email.ToLower() == emailID.ToLower()).FirstOrDefault(); if (userData != null) { result = true; } return(result); } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// For inserting user Groups in database. /// </summary> /// <param name="objLocationEmailContact"></param> /// <returns></returns> public bool AddUserGroup(GroupList objUsergroup) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool IsSuccessfull = false; using (PortalDbEntities portalEntities = new PortalDbEntities()) { GroupMember usergroup = new GroupMember(); usergroup.userID = objUsergroup.UserID; usergroup.groupID = objUsergroup.GroupID;; usergroup.dateCreated = objUsergroup.DateCreated; usergroup.whoUpdated = objUsergroup.WhoCreated; portalEntities.GroupMembers.Add(usergroup); /// Insert the Record in Respected Table. portalEntities.SaveChanges(); /// Check the Chenges in Table After Record Insertion. IsSuccessfull = true; } return(IsSuccessfull); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// For inserting user modules in database. /// </summary> /// <param name="objLocationEmailContact"></param> /// <returns></returns> public bool AddUserModule(ModuleList objModuleUser) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool IsSuccessfull = false; using (PortalDbEntities portalEntities = new PortalDbEntities()) { ModuleUser usermodule = new ModuleUser(); usermodule.userId = objModuleUser.UserID; usermodule.moduleId = objModuleUser.ModuleID; portalEntities.ModuleUsers.Add(usermodule); /// Insert the Record in Respected Table. portalEntities.SaveChanges(); /// Check the Chenges in Table After Record Insertion. IsSuccessfull = true; } return(IsSuccessfull); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// For inserting New User in database. /// </summary> /// <param name="objLocationEmailContact"></param> /// <returns></returns> public bool AddUser(WebPortalUserList objUser) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool IsSuccessfull = false; using (PortalDbEntities portalEntities = new PortalDbEntities()) { UserAccount user = new UserAccount(); user.username = objUser.username; user.password = objUser.password; user.email = objUser.email; user.Phone = objUser.phone; user.firstname = objUser.firstname; user.lastname = objUser.lastname; user.lastLogin = objUser.lastLogin; user.isActive = objUser.isActive; portalEntities.UserAccounts.Add(user); /// Insert the Record in Respected Table. portalEntities.SaveChanges(); /// Check the Chenges in Table After Record Insertion. IsSuccessfull = true; } return(IsSuccessfull); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// To get list of all customer with their selection status coressponding to UserID /// </summary> /// <param name="userID"></param> /// <returns></returns> public List <UserCustomerList> GetCustomers(int userID) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortalDbEntities objAppWorksEntitiesPortal = new PortalDbEntities()) { using (PortStorageEntities portalEntities = new PortStorageEntities()) { var LstCUstomers = objAppWorksEntitiesPortal.spGetSelectedUserCustomerList(userID).Select(x => new UserCustomerList { CustomerID = x.CustomerID, CustomerName = x.CustomerName, IsSelected = x.IsSelected == 0 ? false : true }); List <UserCustomerList> lstUserCustomers = new List <UserCustomerList>(); lstUserCustomers = LstCUstomers.ToList(); return(lstUserCustomers); } } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// To get the user list for customer web portal. /// </summary> /// <returns></returns> public List <WebPortalUserList> GetUsers(WebPortalUserList objUserList) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortalDbEntities portalEntities = new PortalDbEntities()) { var lstUsers = (from users in portalEntities.UserAccounts orderby users.username select new WebPortalUserList { userID = users.userID, username = users.username, firstname = users.firstname, lastname = users.lastname, password = users.password, email = users.email, phone = users.Phone, isActive = users.isActive, lastLogin = users.lastLogin } ); var pageCount = lstUsers.ToList().Count; if (objUserList.CurrentPageIndex == 0) { var queryResult = lstUsers.ToList().Skip(objUserList.CurrentPageIndex * objUserList.PageSize).Take(objUserList.PageSize).ToList(); //var queryResult = query.ToList().Skip(objFindUserProp.CurrentPageIndex * objFindUserProp.PageSize).Take(objFindUserProp.PageSize).ToList(); if (queryResult != null && queryResult.Count > 0) { queryResult.FirstOrDefault().TotalPageCount = pageCount; } return(queryResult); } else { var queryResult = lstUsers.ToList().Skip((objUserList.CurrentPageIndex * objUserList.PageSize) + (objUserList.DefaultPageSize - objUserList.PageSize)).Take(objUserList.PageSize).ToList(); //var queryResult = query.ToList().Skip(objFindUserProp.CurrentPageIndex * objFindUserProp.PageSize).Take(objFindUserProp.PageSize).ToList(); if (queryResult != null && queryResult.Count > 0) { queryResult.FirstOrDefault().TotalPageCount = pageCount; } return(queryResult); } } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// To get list of all modules with their selection status coressponding to UserID /// </summary> /// <param name="userID"></param> /// <returns></returns> public List <ModuleList> GetModules(int userID) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortalDbEntities portalEntities = new PortalDbEntities()) { var lstSelectedModules = (from usermodule in portalEntities.ModuleUsers join module in portalEntities.Modules on usermodule.moduleId equals module.moduleId where usermodule.userId == userID select new ModuleList { ModuleID = module.moduleId, ModuleCode = module.code, ModuleName = module.name, IsSelected = true } ).Distinct(); var lstModules = (from modules in portalEntities.Modules select new ModuleList { ModuleID = modules.moduleId, ModuleCode = modules.code, ModuleName = modules.name, IsSelected = true, } ).Distinct(); var lstexclude = lstModules.Select(x => new ModuleList { ModuleID = x.ModuleID, ModuleCode = x.ModuleCode, ModuleName = x.ModuleName, IsSelected = false }) .Except(lstSelectedModules.Select(x => new ModuleList { ModuleID = x.ModuleID, ModuleCode = x.ModuleCode, ModuleName = x.ModuleName, IsSelected = false })); var lstMerge = lstexclude.Union(lstSelectedModules); return(lstMerge.OrderBy(x => x.ModuleCode).ToList()); } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// To get list of all groups with their selection status coressponding to UserID /// </summary> /// <param name="userID"></param> /// <returns></returns> public List <GroupList> GetGroups(int userID) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortalDbEntities portalEntities = new PortalDbEntities()) { var lstSelectedGroups = (from groupmember in portalEntities.GroupMembers join usergroup in portalEntities.UserGroups on groupmember.groupID equals usergroup.groupID where groupmember.userID == userID select new GroupList { GroupID = usergroup.groupID, GroupName = usergroup.groupname, Description = usergroup.description, IsSelected = true } ).Distinct(); var lstGroups = (from usergroup in portalEntities.UserGroups select new GroupList { GroupID = usergroup.groupID, GroupName = usergroup.groupname, Description = usergroup.description, IsSelected = true } ).Distinct(); var lstexclude = lstGroups.Select(x => new GroupList { GroupID = x.GroupID, GroupName = x.GroupName, Description = x.Description, IsSelected = false }) .Except(lstSelectedGroups.Select(x => new GroupList { GroupID = x.GroupID, GroupName = x.GroupName, Description = x.Description, IsSelected = false })); var lstMerge = lstexclude.Union(lstSelectedGroups); return(lstMerge.OrderBy(x => x.GroupName).ToList()); } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// To get list of all roles with their selection status coressponding to UserID /// </summary> /// <param name="userID"></param> /// <returns></returns> public List <RoleList> GetRoles(int userID) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortalDbEntities portalEntities = new PortalDbEntities()) { var lstSelectedRoles = (from rolemember in portalEntities.RoleMembers join role in portalEntities.Roles on rolemember.roleId equals role.id where rolemember.userId == userID select new RoleList { RoleID = role.id, RoleName = role.roleName, Description = role.description, IsSelected = true } ).Distinct(); var lstRoles = (from role in portalEntities.Roles select new RoleList { RoleID = role.id, RoleName = role.roleName, Description = role.description, IsSelected = true, } ).Distinct(); var lstexclude = lstRoles.Select(x => new RoleList { RoleID = x.RoleID, RoleName = x.RoleName, Description = x.Description, IsSelected = false }) .Except(lstSelectedRoles.Select(x => new RoleList { RoleID = x.RoleID, RoleName = x.RoleName, Description = x.Description, IsSelected = false })); var lstMerge = lstexclude.Union(lstSelectedRoles); return(lstMerge.OrderBy(x => x.RoleName).ToList()); } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// Method for inserting a new user with customers,modules,roles and groups /// </summary> /// <param name="objUser"></param> /// <param name="lstUserCustomer"></param> /// <param name="lstUserModules"></param> /// <param name="lstUserRoles"></param> /// <param name="lstUserGroups"></param> /// <returns></returns> public bool InsertUpdateUser(WebPortalUserList objUser, List <UserCustomerList> lstUserCustomer, List <ModuleList> lstUserModules, List <RoleList> lstUserRoles, List <GroupList> lstUserGroups) { using (var transaction = new TransactionScope()) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortalDbEntities portalEntities = new PortalDbEntities()) { bool result = false; int userID = 0; var userrData = portalEntities.UserAccounts.Where(x => x.userID == objUser.userID).FirstOrDefault(); if (userrData == null) // Insert { UserAccount userlist = new UserAccount(); userlist.username = objUser.username; userlist.password = objUser.password; userlist.firstname = objUser.firstname; userlist.lastname = objUser.lastname; userlist.password = objUser.password; userlist.email = objUser.email; userlist.Phone = objUser.phone; userlist.isActive = objUser.isActive; userlist.isSuperUser = objUser.isSuperUser; //userlist.lastLogin = objUser.lastLogin; userlist.dateCreated = objUser.dateCreated; userlist.whoCreated = objUser.whoCreated; userlist.dateModified = objUser.dateModified; userlist.whoModified = objUser.whoModified; portalEntities.UserAccounts.Add(userlist); portalEntities.SaveChanges(); userID = userlist.userID; } else// Update { userrData.username = objUser.username; userrData.password = objUser.password; userrData.firstname = objUser.firstname; userrData.lastname = objUser.lastname; userrData.password = objUser.password; userrData.email = objUser.email; userrData.Phone = objUser.phone; userrData.isActive = objUser.isActive; userrData.isSuperUser = objUser.isSuperUser; // userrData.lastLogin = objUser.lastLogin; userrData.dateCreated = objUser.dateCreated; userrData.whoCreated = objUser.whoCreated; userrData.dateModified = objUser.dateModified; userrData.whoModified = objUser.whoModified; portalEntities.SaveChanges(); userID = objUser.userID; } if (userID > 0) { var userCustomerData = portalEntities.UserCustomerRoles.Where(x => x.userId == userID).ToList(); if (userCustomerData != null) { foreach (var customer in userCustomerData) { portalEntities.UserCustomerRoles.Remove(customer); portalEntities.SaveChanges(); } } foreach (var item in lstUserCustomer) { item.UserID = userID; if (item.IsSelected == true) { AddUserCustomer(item); } } var userModuleData = portalEntities.ModuleUsers.Where(x => x.userId == userID).ToList(); if (userModuleData != null) { foreach (var module in userModuleData) { portalEntities.ModuleUsers.Remove(module); portalEntities.SaveChanges(); } } foreach (var item in lstUserModules) { item.UserID = userID; if (item.IsSelected == true) { AddUserModule(item); } } var userRoleData = portalEntities.RoleMembers.Where(x => x.userId == userID).ToList(); if (userRoleData != null) { foreach (var role in userRoleData) { portalEntities.RoleMembers.Remove(role); portalEntities.SaveChanges(); } } foreach (var item in lstUserRoles) { item.UserID = userID; if (item.IsSelected == true) { AddUserRole(item); } } var userGroupData = portalEntities.GroupMembers.Where(x => x.userID == userID).ToList(); if (userGroupData != null) { foreach (var group in userGroupData) { portalEntities.GroupMembers.Remove(group); portalEntities.SaveChanges(); } } foreach (var item in lstUserGroups) { item.UserID = userID; if (item.IsSelected == true) { AddUserGroup(item); } } //portalEntities.SaveChanges(); result = true; } if (result) { transaction.Complete(); } return(result); } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } } }
/// <summary> /// This Method is to delete a particular user. /// </summary> /// <param name="locationID"></param> /// <returns></returns> public bool DeleteUser(int userID) { using (var transaction = new TransactionScope()) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool result = false; using (PortalDbEntities portalEntities = new PortalDbEntities()) { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); var userCustomerData = portalEntities.UserCustomerRoles.Where(x => x.userId == userID).ToList(); if (userCustomerData != null) { foreach (var customer in userCustomerData) { portalEntities.UserCustomerRoles.Remove(customer); portalEntities.SaveChanges(); } } var userModuleData = portalEntities.ModuleUsers.Where(x => x.userId == userID).ToList(); if (userModuleData != null) { foreach (var module in userModuleData) { portalEntities.ModuleUsers.Remove(module); portalEntities.SaveChanges(); } } var userRoleData = portalEntities.RoleMembers.Where(x => x.userId == userID).ToList(); if (userRoleData != null) { foreach (var role in userRoleData) { portalEntities.RoleMembers.Remove(role); portalEntities.SaveChanges(); } } var userGroupData = portalEntities.GroupMembers.Where(x => x.userID == userID).ToList(); if (userGroupData != null) { foreach (var group in userGroupData) { portalEntities.GroupMembers.Remove(group); portalEntities.SaveChanges(); } } var userInfoData = portalEntities.UserAccounts.Where(x => x.userID == userID).FirstOrDefault(); if (userInfoData != null) { userInfoData.isActive = 0; portalEntities.SaveChanges(); } result = true; transaction.Complete(); } return(result); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } } }