public JsonResult EditDepartment(int id, int languageId) { try { var men = _db.Departments.Find(id); if (men != null && men.Status != (int)GeneralEnums.StatusEnum.Deleted) { var department = LanguageFallbackHelper.GetDepartment(id, languageId); return(Json(department, JsonRequestBehavior.AllowGet)); } return(Json(null, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogHelper.LogException(User.Identity.Name, ex, "Error While editing Department (Get)"); return(null); } }
public ActionResult Index(int?page, int?typeId, string searchText, int resetTo = 0) { if (resetTo == 1) { page = 1; } ViewBag.SearchText = searchText; ViewBag.TypeId = typeId; var citizens = _db.AspNetUserRoles.Where(r => r.AspNetRole.Name == Constants.Roles.Citizen) .Select(r => r.AspNetUser.UserName).ToList(); var currentLanguageId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]); var userProfilesForcurrentLan = _db.UserProfileTranslations .Where(r => (r.LanguageId == currentLanguageId) && r.UserProfile.Status != (int)GeneralEnums.StatusEnum.Deleted).Select(c => c.UserProfileId); var userProfiles = _db.UserProfileTranslations .Where(r => (r.IsDefault) && r.UserProfile.Status != (int)GeneralEnums.StatusEnum.Deleted && !userProfilesForcurrentLan.Contains(r.UserProfileId)) .Union( _db.UserProfileTranslations .Where(r => r.LanguageId == currentLanguageId && r.UserProfile.Status != (int)GeneralEnums.StatusEnum.Deleted && userProfilesForcurrentLan.Contains(r.UserProfileId))); userProfiles = userProfiles.Where(r => citizens.Contains(r.UserProfile.Username)); if (typeId != null) { switch (typeId) { case (int)GeneralEnums.PersonInformationTypeEnum.Name: userProfiles = userProfiles.Where(r => r.FullName.Contains(searchText)); break; case (int)GeneralEnums.PersonInformationTypeEnum.Email: userProfiles = userProfiles.Where(r => r.UserProfile.Email.Contains(searchText)); break; case (int)GeneralEnums.PersonInformationTypeEnum.Mobile: userProfiles = userProfiles.Where(r => r.UserProfile.Mobile.Contains(searchText) || r.UserProfile.PhoneNumber.Contains(searchText) || r.UserProfile.Fax.Contains(searchText)); break; case (int)GeneralEnums.PersonInformationTypeEnum.Identity: userProfiles = userProfiles.Where(r => r.UserProfile.IdNumber.Contains(searchText)); break; } } var result = userProfiles.ToList().Select(x => new ProfileViewModel() { Id = x.UserProfileId, LanguageId = x.LanguageId, IdNumber = x.UserProfile.IdNumber, PhoneNumber = x.UserProfile.PhoneNumber, GenderLookupId = x.UserProfile.GenderLookupId, MartialStatusLookupId = x.UserProfile.MartialStatusLookupId, FullName = x.FullName, Address = x.Address, Mobile = x.UserProfile.Mobile, Username = x.UserProfile.Username, Email = x.UserProfile.Email, Fax = x.UserProfile.Fax, BirthDay = x.UserProfile.Birthday, Status = x.UserProfile.Status, CityId = x.UserProfile.CityId, ProvinceId = x.UserProfile.ProvinceId, RegionId = x.UserProfile.RegionId, LastLogin = x.UserProfile.LastLogin, ManagerId = x.UserProfile.ManagerId, ManagerName = x.UserProfile?.ManagerId != null ? LanguageFallbackHelper.GetUserProfile((int)x.UserProfile.ManagerId, currentLanguageId)?.FullName : string.Empty, Department = x.UserProfile.DepartmentId, DepartmentName = x.UserProfile?.DepartmentId != null ? LanguageFallbackHelper.GetDepartment((int)x.UserProfile.DepartmentId, currentLanguageId)?.Name : string.Empty, PrefferdLanguage = x.UserProfile.PreferedLanguageId }); var pageSize = int.Parse(SettingHelper.GetOrCreate(Constants.SystemSettings.ControlPanelPageSize, "10").Value); var pageNumber = page ?? 1; return(View(result.OrderByDescending(r => r.Id).ToList().ToPagedList(pageNumber, pageSize))); }
public ActionResult Index(int?page, string searchText, int resetTo = 0) { if (!SessionHelper.CheckSessionCompanyId()) { //logout } var companyId = SessionHelper.GetCompanyId(); if (resetTo == 1) { page = 1; } var genders = LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.Gender, Request.Cookies["_culture"]); var prefferdLanguage = LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.PrefferdLanguage, Request.Cookies["_culture"]); var roles = _db.AspNetRoles.ToList(); var departments = LookupHelper.GetDepartments(Request.Cookies["_culture"]); var managers = LookupHelper.GetEmployees(Request.Cookies["_culture"]); var martialStatuses = LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.MartialStatus, Request.Cookies["_culture"]); var statuses = LookupHelper.GetStatuses(Request.Cookies["_culture"]); ViewBag.Status = new SelectList(statuses, "Id", "Name"); ViewBag.RoleList = new SelectList(roles, "Id", "Name"); ViewBag.DepartmentsList = new SelectList(departments, "Id", "Name"); ViewBag.DepartmentsListEdit = new SelectList(departments, "Id", "Name"); ViewBag.StatusEdit = new SelectList(statuses, "Id", "Name"); ViewBag.GenderLookupId = new SelectList(genders, "Id", "Name"); ViewBag.GenderLookupIdEdit = new SelectList(genders, "Id", "Name"); ViewBag.PrefferdLanguage = new SelectList(prefferdLanguage, "Id", "Name"); ViewBag.PrefferdLanguageEdit = new SelectList(prefferdLanguage, "Id", "Name"); ViewBag.ManagerId = new SelectList(managers, "Id", "FullName"); ViewBag.ManagerIdEdit = new SelectList(managers, "Id", "FullName"); ViewBag.MartialStatusLookupId = new SelectList(martialStatuses, "Id", "Name"); ViewBag.MartialStatusLookupIdEdit = new SelectList(martialStatuses, "Id", "Name"); var currentLanguageId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]); var userProfilesForcurrentLan = _db.UserProfileTranslations .Where(r => (r.LanguageId == currentLanguageId) && r.UserProfile.CompanyId == companyId && r.UserProfile.Status != (int)GeneralEnums.StatusEnum.Deleted).Select(c => c.UserProfileId); var userProfiles = _db.UserProfileTranslations .Where(r => (r.IsDefault) && r.UserProfile.Status != (int)GeneralEnums.StatusEnum.Deleted && !userProfilesForcurrentLan.Contains(r.UserProfileId) && r.UserProfile.CompanyId == companyId) .Union( _db.UserProfileTranslations .Where(r => r.LanguageId == currentLanguageId && r.UserProfile.CompanyId == companyId && r.UserProfile.Status != (int)GeneralEnums.StatusEnum.Deleted && userProfilesForcurrentLan.Contains(r.UserProfileId))) .ToList(); if (!searchText.IsNullOrWhiteSpace()) { userProfiles = userProfiles .Where(r => (r.FullName.Contains(searchText) || r.FullName.Contains(searchText) || r.UserProfile.Mobile.Contains(searchText) || r.UserProfile.PhoneNumber.Contains(searchText))).ToList(); ViewBag.searchText = searchText; } var result = userProfiles.ToList().Select(x => new ProfileViewModel() { Id = x.UserProfileId, LanguageId = x.LanguageId, IdNumber = x.UserProfile.IdNumber, PhoneNumber = x.UserProfile.PhoneNumber, GenderLookupId = x.UserProfile.GenderLookupId, MartialStatusLookupId = x.UserProfile.MartialStatusLookupId, FullName = x.FullName, Address = x.Address, Mobile = x.UserProfile.Mobile, Username = x.UserProfile.Username, Email = x.UserProfile.Email, Fax = x.UserProfile.Fax, BirthDay = x.UserProfile.Birthday, Status = x.UserProfile.Status, CityId = x.UserProfile.CityId, ProvinceId = x.UserProfile.ProvinceId, RegionId = x.UserProfile.RegionId, LastLogin = x.UserProfile.LastLogin, ManagerId = x.UserProfile.ManagerId, ManagerName = x.UserProfile?.ManagerId != null ? LanguageFallbackHelper.GetUserProfile((int)x.UserProfile.ManagerId, currentLanguageId)?.FullName : string.Empty, Department = x.UserProfile.DepartmentId, DepartmentName = x.UserProfile?.DepartmentId != null ? LanguageFallbackHelper.GetDepartment((int)x.UserProfile.DepartmentId, currentLanguageId)?.Name : string.Empty, PrefferdLanguage = x.UserProfile.PreferedLanguageId, CompanyId = x.UserProfile.CompanyId, }); int pageSize = int.Parse(SettingHelper.GetOrCreate(Core.Constants.SystemSettings.ControlPanelPageSize, "10").Value); var pageNumber = (page ?? 1); return(View(result.OrderByDescending(r => r.Id).ToList().ToPagedList(pageNumber, pageSize))); }