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