// GET: Home/LeadInfo/5 public ActionResult LeadInfo(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } var formData = _db.Leads.Where(t => t.Id == id).FirstOrDefault(); var currentLanguageId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]); ViewBag.message= TempData["message"]; ViewBag.SMSmessage = TempData["SMSmessage"]; var leadVm = new LeadViewModel() { Name = formData.Name, Email = formData.Email, Address = formData.Address, Status = (LeadStatusEnum)formData.Status, Phone_Number = formData.Phone_Number, Notes = formData.Notes, Created_Date = formData.Created_Date, AssigneeId=formData.AssigneeId, AssigneeName = LanguageFallbackHelper.GetUserProfile((formData.UserProfile?.Id??0), currentLanguageId)?.FullName, CampaignId = formData.CampaignId, CampaignName = LanguageFallbackHelper.GetCampaigns(formData.Campaign.Id, currentLanguageId).Name }; ViewBag.Lead_ID = id; return View(leadVm); }
public ActionResult ExportAdvanceSearchAllFieldsToExcel() { var lead = _db.Leads.AsQueryable(); var langId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]); //cases = AdvanceSearchCasesData(filters, cases); var list = lead.ToList().Select(x => new LeadViewModel() { Id = x.Id, Name = x.Name, Address = x.Address, Email=x.Email, Phone_Number=x.Phone_Number, Notes=x.Notes, Created_Date=x.Created_Date, CampaignId=x.CampaignId, AssigneeId=x.AssigneeId, AssigneeName= LanguageFallbackHelper.GetUserProfile((x.UserProfile?.Id ?? 0), langId)?.FullName, CampaignName = LanguageFallbackHelper.GetCampaigns(x.Campaign.Id, langId).Name }); var result = ReportHelper.WriteCsvToMemory(list); var memoryStream = new MemoryStream(result); return new FileStreamResult(memoryStream, "text/csv") { FileDownloadName = $"FullLeadReport-{DateTime.Now}.csv" }; }
public ActionResult EditSystemSetting(int id, int languageId) { try { SystemSetting systemSetting = _db.SystemSettings.Find(id); if (systemSetting != null && systemSetting.Status != (int)GeneralEnums.StatusEnum.Deleted) { var system = LanguageFallbackHelper.GetSystemSetting(id, languageId); return(Json(system, JsonRequestBehavior.AllowGet)); } return(Json(null, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogHelper.LogException(User.Identity.Name, ex, "Error While Editing System Settings (Get)"); return(null); } }
public ActionResult EditMasterLookup(int id, int languageId) { try { MasterLookup masterLookup = _db.MasterLookups.Find(id); if (masterLookup != null && masterLookup.Status != (int)GeneralEnums.StatusEnum.Deleted) { var master = LanguageFallbackHelper.GetMasterLookup(id, languageId); return(Json(master, JsonRequestBehavior.AllowGet)); } return(Json(null, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogHelper.LogException(User.Identity.Name, ex, "Error While Editing Master Lookup (Get)"); return(null); } }
public JsonResult EditSMSTemplate(int id, int languageId) { try { var men = _db.SMSTemplates.Find(id); if (men != null && men.Status != (int)GeneralEnums.StatusEnum.Deleted) { var smsTemplate = LanguageFallbackHelper.GetSMSTemplate(id, languageId); return(Json(smsTemplate, JsonRequestBehavior.AllowGet)); } return(Json(null, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogHelper.LogException(User.Identity.Name, ex, "Error While editing SMS (Get)"); return(null); } }
// api/lookups/[email protected] public IHttpActionResult GetDepartments(string username) { AuthenticationHelper.ApiAuthorizationCheck(Request); try { var lang = Request?.Headers?.AcceptLanguage?.FirstOrDefault()?.Value ?? "ar"; var languageId = lang == "ar" ? (int)GeneralEnums.LanguageEnum.Arabic : (int)GeneralEnums.LanguageEnum.English; var departments = _db.Departments.Where(r => r.DepartmentTranslations.Any(x => x.LanguageId == languageId) && r.Status == (int)GeneralEnums.StatusEnum.Active) .SelectMany(r => r.DepartmentTranslations.Where(x => x.LanguageId == languageId)).Select(x => new DepartmentViewModel() { Id = x.DepartmentId, Name = x.Name, Description = x.Description, LanguageId = x.LanguageId, CreatedBy = x.Department.CreatedBy, CreatedOn = x.Department.CreatedOn }).ToList(); if (!departments.Any()) { departments = LanguageFallbackHelper.GetDefaultDepartments(); } return(Ok(departments)); } catch (Exception ex) { LogHelper.LogException(Constants.Users.Mobile, ex, Constants.Errors.Apis.ErrorGetDepatments); return(Content(HttpStatusCode.InternalServerError, new BaseApiResponse() { StatusCode = HttpStatusCode.InternalServerError, Message = Constants.Errors.Apis.ErrorGetDepatments })); } }
// api/lookups/getlookupsbymasterid? username = salam - [email protected]&lookupId=2 public IHttpActionResult GetLookupsByMasterId(string username, int lookupId) { AuthenticationHelper.ApiAuthorizationCheck(Request); try { var httpRequest = HttpContext.Current.Request; var lang = Request?.Headers?.AcceptLanguage?.FirstOrDefault()?.Value ?? "ar"; var languageId = lang == "ar" ? (int)GeneralEnums.LanguageEnum.Arabic : (int)GeneralEnums.LanguageEnum.English; var lookups = _db.DetailsLookups.Where(r => r.DetailsLookupTranslations.Any(x => x.LanguageId == languageId) && r.MasterId == lookupId && r.Status == (int)GeneralEnums.StatusEnum.Active) .SelectMany(r => r.DetailsLookupTranslations.Where(x => x.LanguageId == languageId)).Select( x => new DetailsLookupViewModel() { Id = x.DetailsLookupId, Name = x.Value }).ToList(); if (!lookups.Any()) { lookups = LanguageFallbackHelper.GetDefaultLookupDetailsByMasterId(lookupId); } return(Ok(lookups)); } catch (Exception ex) { LogHelper.LogException(Constants.Users.Mobile, ex, Constants.Errors.Apis.ErrorGetLookups); return(Content(HttpStatusCode.InternalServerError, new BaseApiResponse() { StatusCode = HttpStatusCode.InternalServerError, Message = Constants.Errors.Apis.ErrorGetLookups })); } }
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 Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var langId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]); var profile = LanguageFallbackHelper.GetUserProfile((int)id, langId); if (profile == null || profile.Status == (int)GeneralEnums.StatusEnum.Deleted) { return(HttpNotFound()); } var systemCases = _db.SystemCases.Where(x => x.CreatedBy == profile.Username).ToList().Where(x => x.CreatedBy == profile.Username).ToList().Select(x => new CaseViewModel { Id = x.Id, Status = x.Status, Description = x.Description, CreatedOn = x.CreatedOn, DeletedOn = x.DeletedOn, CreatedBy = x.CreatedBy, Tags = x.Tags, Title = x.Title, Address = x.Address, Location = x.Location, TypeId = x.TypeId, AssigneeId = x.AssigneeId, AssigneeName = x.AssigneeId != null ? LanguageFallbackHelper.GetUserProfile((int)x.AssigneeId, langId)?.FullName ?? string.Empty : string.Empty, CategoryId = x.CategoryId, CategoryName = x.CategoryId != null ? LookupHelper.GetLookupDetailsById((int)x.CategoryId, Request.Cookies["_culture"])?.Name ?? string.Empty : string.Empty, PriorityId = x.PriorityId, PriorityName = x.PriorityId != null ? LookupHelper.GetLookupDetailsById((int)x.PriorityId, Request.Cookies["_culture"])?.Name ?? string.Empty : string.Empty, SeverityId = x.SeverityId, SeverityName = x.SeverityId != null ? LookupHelper.GetLookupDetailsById((int)x.SeverityId, Request.Cookies["_culture"])?.Name ?? string.Empty : string.Empty, UniqueId = x.UniqueId }).ToList(); var result = new CitizenProfileViewModel() { Status = profile.Status, Address = profile.Address, Id = profile.Id, ManagerId = profile.ManagerId, Department = profile.Department, PrefferdLanguage = profile.PrefferdLanguage, Username = profile.Username, FullName = profile.FullName, Email = profile.Email, WeekDaysOff = profile.WeekDaysOff, LanguageId = profile.LanguageId, LastLogin = profile.LastLogin, CityId = profile.CityId, ManagerName = profile.ManagerName, UserHolidays = profile.UserHolidays, Password = profile.Password, DepartmentName = profile.DepartmentName, IdNumber = profile.IdNumber, BirthDay = profile.BirthDay, CityCode = profile.CityCode, CityName = profile.CityName, ConfirmPassword = profile.ConfirmPassword, CustomerId = profile.CustomerId, Fax = profile.Fax, GenderCode = profile.GenderCode, GenderLookupId = profile.GenderLookupId, GenderLookupName = profile.GenderLookupName, MartialStatusCode = profile.MartialStatusCode, MartialStatusLookupId = profile.MartialStatusLookupId, MartialStatusLookupName = profile.MartialStatusLookupName, Mobile = profile.Mobile, PhoneNumber = profile.PhoneNumber, PrefferdLanguageName = profile.PrefferdLanguageName, ProfilePath = profile.ProfilePath, ProvinceCode = profile.ProvinceCode, ProvinceId = profile.ProvinceId, ProvinceName = profile.ProvinceName, RegionId = profile.RegionId, RegionName = profile.RegionName, Roles = profile.Roles, Cases = systemCases }; var prefferdLanguage = LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.PrefferdLanguage, Request.Cookies["_culture"]); ViewBag.PrefferdLanguage = new SelectList(prefferdLanguage, "Id", "Name", profile.PrefferdLanguage); ViewBag.GenderLookupId = new SelectList( LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.Gender, Request.Cookies["_culture"]), "Id", "Name"); ViewBag.MartialStatusLookupId = new SelectList(LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.MartialStatus, Request.Cookies["_culture"]), "Id", "Name", profile.MartialStatusLookupId); ViewBag.ProvinceId = new SelectList(LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.Province, Request.Cookies["_culture"]), "Id", "Name", profile.ProvinceId); ViewBag.RegionId = new SelectList(LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.Region, Request.Cookies["_culture"]), "Id", "Name", profile.RegionId); ViewBag.CityId = new SelectList(LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.City, Request.Cookies["_culture"]), "Id", "Name", profile.CityId); return(View(result)); }
public ActionResult Index(int? campaignNo) { var companyId = SessionHelper.GetCompanyId(); var CampaignList = _db.Campaigns.Where(r => r.CompanyId == companyId).Select(r=>r.Id).ToList(); int NewLeads; int QualifiedLeads; int WonLeads; int LostLeads; var currentLanguageId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]); var LeadList = _db.Leads.Where(r=> CampaignList.Contains(r.CampaignId.Value)).ToList(); if (campaignNo != null) { LeadList = _db.Leads.Where(x => x.CampaignId == campaignNo).ToList(); } var LeadList_result = LeadList.Select(r => new LeadViewModel { Id = r.Id, Status = (LeadStatusEnum)r.Status, Email = r.Email, Name = r.Name, Address=r.Address, Phone_Number = r.Phone_Number, Notes=r.Notes, Created_Date=r.Created_Date, AssigneeId = r.AssigneeId, AssigneeName = LanguageFallbackHelper.GetUserProfile((r.UserProfile?.Id ?? 0), currentLanguageId)?.FullName, CampaignId = r.CampaignId, CampaignName=LanguageFallbackHelper.GetCampaigns(r.Campaign.Id,currentLanguageId).Name } ).ToList(); if (campaignNo != null) { NewLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.New && r.CampaignId == campaignNo); QualifiedLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Qualified && r.CampaignId == campaignNo); WonLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Won && r.CampaignId == campaignNo); LostLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Lost && r.CampaignId == campaignNo); } else { NewLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.New); QualifiedLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Qualified); WonLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Won); LostLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Lost); } ViewData["NewLeads"] = NewLeads; ViewData["QualifiedLeads"] = QualifiedLeads; ViewData["WonLeads"] = WonLeads; ViewData["LostLeads"] = LostLeads; var list = new List<SelectListItem> { new SelectListItem{ Text=App_GlobalResources.General.Home.Name, Value = "Name", Selected = true}, new SelectListItem{ Text=App_GlobalResources.General.Home.Email, Value = "Email" }, new SelectListItem{ Text=App_GlobalResources.General.Home.Mobile, Value = "Mobile"} }; ViewData["SearchFieldsList"] = list; var pageSize = int.Parse(SettingHelper.GetOrCreate(Constants.SystemSettings.ControlPanelPageSize, "20").Value); return View(LeadList_result); // return View(LeadList_result.OrderByDescending(r => r.Id).ToList().ToPagedList(1,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))); }