public ActionResult DormantCustomersPaging(int? page, int? pageSize, string keyword = "",
ReportSort sortBy = ReportSort.LastLogonDate, bool isDesc = false,
int startDay = 0, int startMonth = 0, int startYear = 0,
int endDay = 0, int endMonth = 0, int endYear = 0)
{
DateTime startDate;
DateTime endDate;
if (startYear == 0 || endYear == 0)
{
startDate = DateTime.Now.AddDays(-7);
endDate = DateTime.Now;
}
else
{
startDate = new DateTime(startYear, startMonth, startDay);
endDate = new DateTime(endYear, endMonth, endDay);
}
int _currentPageIndex = page.HasValue ? page.Value - 1 : 0;
int _pageSize = pageSize.HasValue ? pageSize.Value : 10;
var list = AdminServices.Report.GetDormantCustomers(keyword, _currentPageIndex, _pageSize, sortBy, isDesc);
var model = new DormantCustomersViewModel(keyword, sortBy, isDesc, _pageSize) { DormantCustomers = list };
return PartialView("~/Areas/Admin/Views/Dashboard/_ajaxDormantCustomers.cshtml", model);
}
public ActionResult CompliancesVerification(int? page, int? pageSize,
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false,
bool isVerified = true,
bool isUnverified = true,
bool isExpired = true,
bool isUnlicense = true)
{
int _currentPageIndex = page.HasValue ? page.Value - 1 : 0;
int _pageSize = pageSize.HasValue ? pageSize.Value : _itemPerPage;
var list = AdminServices.ManagementService.GetCompliancesVerification(
_currentPageIndex, _pageSize, isVerified, isUnverified, isExpired, isUnlicense, sortBy, isDesc);
CompliancesVerificationModel model = new CompliancesVerificationModel(
isVerified, isUnverified, isExpired, isUnlicense, sortBy, isDesc, _pageSize)
{
CompliancesVerifications = list
};
if (!Request.IsAjaxRequest())
{
return View(model);
}
return PartialView(_ajaxCompliancesVerification, model);
}
protected void grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (e.RowIndex < Page.Settings.SortedColumns.Count)
{
Page.Settings.SortedColumns.RemoveAt(e.RowIndex);
}
int reportColumnsSchemaId = Convert.ToInt32((grid.Rows[e.RowIndex].Cells[0].Controls[1] as DropDownList).SelectedValue);
bool asc = Convert.ToBoolean((grid.Rows[e.RowIndex].Cells[1].Controls[1] as DropDownList).SelectedValue);
// Verifies if yet inserted
ReportSort sortItem = Page.Settings.SortedColumns.Find(p => p.ReportColumnsSchemaId == reportColumnsSchemaId);
if (sortItem == null)
{
sortItem = new ReportSort();
sortItem.ReportTablesSchemaId = Page.Settings.Report.ReportTablesSchemaId.Value;
sortItem.ReportColumnsSchemaId = reportColumnsSchemaId;
sortItem.Ascending = asc;
sortItem.Name = (grid.Rows[e.RowIndex].Cells[0].Controls[1] as DropDownList).SelectedItem.Text;
Page.Settings.SortedColumns.Insert(e.RowIndex, sortItem);
}
else
{
sortItem.Ascending = asc;
}
BindGrid(-1);
}
public ExpiringVerificationViewModel(string keyWord, ReportSort sortBy, bool isDesc, int pageSize)
{
Pager = new PagerViewModel()
{
KeyWord = keyWord,
SortBy = sortBy,
IsDesc = isDesc,
PageSize = pageSize,
};
}
public PaymentDefaultViewModel(string keyWord, ReportSort sortBy, bool isDesc, int pageSize)
{
Pager = new PagerViewModel()
{
KeyWord = keyWord,
SortBy = sortBy,
IsDesc = isDesc,
PageSize = pageSize,
};
}
public DormantCustomersViewModel(string keyWord, ReportSort sortBy, bool isDesc, int pageSize)
{
Pager = new PagerViewModel()
{
KeyWord = keyWord,
SortBy = sortBy,
IsDesc = isDesc,
PageSize = pageSize,
};
}
public MvcPaging.IPagedList<DormantCustomersDto> GetDormantCustomers(string keyword, int currentPage,
int pageSize, ReportSort sortBy = ReportSort.LastLogonDate, bool isDesc = false)
{
keyword = keyword.ToLower();
DateTime lastLogonBefore3Month = DateTime.Now.AddMonths(-3);
var listUsers = Repository.Query<TeleConsult.Domain.User>().Where(a => a.ModifiedDate <= lastLogonBefore3Month && a.Role == Role.Customer);
if (listUsers != null && listUsers.Any())
{
var _totalItem = listUsers.Count();
switch (sortBy)
{
case ReportSort.FirstName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.FirstName)
: listUsers.OrderBy(e => e.FirstName);
break;
case ReportSort.LastName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.LastName)
: listUsers.OrderBy(e => e.LastName);
break;
case ReportSort.EmailAddress:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.Email)
: listUsers.OrderBy(e => e.Email);
break;
case ReportSort.UserName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.UserName)
: listUsers.OrderBy(e => e.UserName);
break;
case ReportSort.LastLogonDate:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.ModifiedDate)
: listUsers.OrderBy(e => e.ModifiedDate);
break;
default:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.ModifiedDate)
: listUsers.OrderBy(e => e.ModifiedDate);
break;
}
return listUsers.Skip(currentPage * pageSize).Take(pageSize).Select(p => new DormantCustomersDto()
{
FirstName = p.FirstName,
LastName = p.LastName,
EmailAddress = p.Email,
UserName = p.UserName,
LastLogonDate = p.ModifiedDate
}).ToPagedList(currentPage, pageSize, _totalItem);
}
return null;
}
protected void btnAddSortColumn_Click(object sender, ImageClickEventArgs e)
{
ReportSort sortItem = new ReportSort();
sortItem.ReportTablesSchemaId = Page.Settings.Report.ReportTablesSchemaId.Value;
sortItem.ReportColumnsSchemaId = Convert.ToInt32(cboColumn.SelectedValue);
sortItem.Ascending = Convert.ToBoolean(cboOrder.SelectedValue);
sortItem.Name = cboColumn.SelectedItem.Text;
Page.Settings.SortedColumns.Add(sortItem);
BindGrid(-1);
}
public CompliancesVerificationModel(bool isVerified, bool isUnverified, bool isExpired,
bool isUnlicense, ReportSort sortBy, bool isDesc, int pageSize)
{
Pager = new PagerViewModel()
{
IsVerified = isVerified,
IsUnverified = isUnverified,
IsExpired = isExpired,
IsUnlicense = isUnlicense,
SortBy = sortBy,
IsDesc = isDesc,
PageSize = pageSize,
};
}
public ActionResult DormantCustomers(int? page, int? pageSize, string keyword = "",
ReportSort sortBy = ReportSort.LastLogonDate, bool isDesc = false)
{
int _currentPageIndex = page.HasValue ? page.Value - 1 : 0;
int _pageSize = pageSize.HasValue ? pageSize.Value : 10;
var list = AdminServices.Report.GetDormantCustomers(keyword, _currentPageIndex, _pageSize, sortBy, isDesc);
var model = new DormantCustomersViewModel(keyword, sortBy, isDesc, _pageSize) { DormantCustomers = list };
if (!Request.IsAjaxRequest())
{
return View(model);
}
return PartialView("_ajaxDormantCustomers", model);
}
public ActionResult RegistrationRequiringVerificationPagging(int? page, int? pageSize, string keyword = "",
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false)
{
int _currentPageIndex = page.HasValue ? page.Value - 1 : 0;
int _pageSize = pageSize.HasValue ? pageSize.Value : 10;
var list = AdminServices.Report.GetRegistrationVerification(keyword, _currentPageIndex, _pageSize, sortBy, isDesc);
var model = new RegistrationVerificationViewModel(keyword, sortBy, isDesc, _pageSize) { PaymentDefault = list };
return PartialView("~/Areas/Admin/Views/Dashboard/_ajaxRegistrationRequiringVerification.cshtml", model);
}
public IPagedList<CompliancesVerificationDto> GetCompliancesVerification(int currentPage, int pageSize,
bool isVerified,
bool isUnverified,
bool isExpired,
bool isUnlicense,
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false)
{
var listUsers =
(from user in Repository.Query<User>()
where
user.Role == Role.Specialist
&& user.CompletedStep == Step.Step4
&& user.IsEmailConfirmed == true
&& user.IsPhoneConfirmed == true
select new
{
UserId = user.Id,
FirstName = user.FirstName,
LastName = user.LastName,
Email = user.Email,
Status = user.Profiles.FirstOrDefault().Specializations.FirstOrDefault().LicenceToOperate
? user.Profiles.FirstOrDefault().Specializations.FirstOrDefault().ExpiredDate.HasValue
? user.Profiles.FirstOrDefault().Specializations.FirstOrDefault().ExpiredDate.Value < DbFunctions.TruncateTime(DateTime.Now)
? VerifiedType.Expired
: VerifiedType.Verified
: VerifiedType.Unverified
: VerifiedType.Unlicense,
ExpiredDate = user.Profiles.FirstOrDefault().Specializations.FirstOrDefault().ExpiredDate,
});
if (!isVerified)
{
listUsers = listUsers.Where(u => u.Status != VerifiedType.Verified);
}
if (!isUnverified)
{
listUsers = listUsers.Where(u => u.Status != VerifiedType.Unverified);
}
if (!isExpired)
{
listUsers = listUsers.Where(u => u.Status != VerifiedType.Expired);
}
if (!isUnlicense)
{
listUsers = listUsers.Where(u => u.Status != VerifiedType.Unlicense);
}
if (listUsers != null && listUsers.Any())
{
var _totalItem = listUsers.Count();
switch (sortBy)
{
case ReportSort.FirstName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.FirstName)
: listUsers.OrderBy(e => e.FirstName);
break;
case ReportSort.LastName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.LastName)
: listUsers.OrderBy(e => e.LastName);
break;
case ReportSort.EmailAddress:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.Email)
: listUsers.OrderBy(e => e.Email);
break;
case ReportSort.Status:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.Status)
: listUsers.OrderBy(e => e.Status);
break;
default:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.ExpiredDate)
: listUsers.OrderBy(e => e.ExpiredDate);
break;
}
return listUsers.Skip(currentPage * pageSize).Take(pageSize).Select(p => new CompliancesVerificationDto()
{
UserId = p.UserId.ToString(),
FirstName = p.FirstName,
LastName = p.LastName,
EmailAddress = p.Email,
Status = p.Status.ToString(),
ExpiredDate = p.ExpiredDate
}).ToPagedList(currentPage, pageSize, _totalItem);
}
return null;
}
public ActionResult PaymentDefault(int? page, int? pageSize, string keyword = "",
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false,
PaymentDefaultType paymentDafaultType = PaymentDefaultType.All)
{
int _currentPageIndex = page.HasValue ? page.Value - 1 : 0;
int _pageSize = pageSize.HasValue ? pageSize.Value : 10;
var list = AdminServices.Report.GetPaymentDefault(keyword, paymentDafaultType, _currentPageIndex, _pageSize, sortBy, isDesc);
var model = new PaymentDefaultViewModel(keyword, sortBy, isDesc, _pageSize) { PaymentDefault = list };
model.ListAllPaymentDefault = AdminServices.Report.GetAllPaymentDefault(paymentDafaultType);
if (!Request.IsAjaxRequest())
{
return View(model);
}
return PartialView("_ajaxPaymentDefault", model);
}
public MvcPaging.IPagedList<RegistrationVerificationDto> GetRegistrationVerification(string keyword,int currentPage, int pageSize,
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false)
{
keyword = keyword.ToLower();
var listUsers = (from user in Repository.Query<User>()
where
user.Role == Role.Specialist
&& user.Profiles.FirstOrDefault().Specializations.Any(s => s.POCs.Any(x => x.ExpiredDate == null))
select user);
if (listUsers != null && listUsers.Any())
{
var _totalItem = listUsers.Count();
switch (sortBy)
{
case ReportSort.FirstName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.FirstName)
: listUsers.OrderBy(e => e.FirstName);
break;
case ReportSort.LastName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.LastName)
: listUsers.OrderBy(e => e.LastName);
break;
case ReportSort.EmailAddress:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.Email)
: listUsers.OrderBy(e => e.Email);
break;
case ReportSort.UserName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.UserName)
: listUsers.OrderBy(e => e.UserName);
break;
default:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.UserName)
: listUsers.OrderBy(e => e.UserName);
break;
}
return listUsers.Skip(currentPage * pageSize).Take(pageSize).Select(p => new RegistrationVerificationDto()
{
UserId = p.Id.ToString(),
FirstName = p.FirstName,
LastName = p.LastName,
EmailAddress = p.Email,
UserName = p.UserName,
}).ToPagedList(currentPage, pageSize, _totalItem);
}
return null;
}
public MvcPaging.IPagedList<PaymentDefaultDto> GetPaymentDefault(string keyword, PaymentDefaultType paymentDafaultType, int currentPage, int pageSize,
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false)
{
keyword = keyword.ToLower();
var listUsers = paymentDafaultType == PaymentDefaultType.All ?
Repository.Query<TeleConsult.Domain.User>().Where(a => a.Role == Role.Customer) :
Repository.Query<TeleConsult.Domain.User>().Where(a => a.Role == Role.Customer &&
(int)a.PaymentMethod == (int)paymentDafaultType);
if (listUsers != null && listUsers.Any())
{
var _totalItem = listUsers.Count();
switch (sortBy)
{
case ReportSort.FirstName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.FirstName)
: listUsers.OrderBy(e => e.FirstName);
break;
case ReportSort.LastName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.LastName)
: listUsers.OrderBy(e => e.LastName);
break;
case ReportSort.EmailAddress:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.Email)
: listUsers.OrderBy(e => e.Email);
break;
case ReportSort.UserName:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.UserName)
: listUsers.OrderBy(e => e.UserName);
break;
case ReportSort.PaymentDefault:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.PaymentMethod)
: listUsers.OrderBy(e => e.PaymentMethod);
break;
default:
listUsers = isDesc ? listUsers.OrderByDescending(e => e.PaymentMethod)
: listUsers.OrderBy(e => e.PaymentMethod);
break;
}
return listUsers.Skip(currentPage * pageSize).Take(pageSize).Select(p => new PaymentDefaultDto()
{
FirstName = p.FirstName,
LastName = p.LastName,
EmailAddress = p.Email,
UserName = p.UserName,
PaymentDefault = p.PaymentMethod,
}).ToPagedList(currentPage, pageSize, _totalItem);
}
return null;
}
public MvcPaging.IPagedList<ExpiringVerificationDto> GetExpiringVerification(string keyword, int currentPage, int pageSize,
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false)
{
keyword = keyword.ToLower();
var listUsers = Repository.Query<TeleConsult.Domain.User>().Where(a => a.Role == Role.Specialist).ToList();
List<ExpiringVerificationDto> listVerification = new List<ExpiringVerificationDto>();
bool flagAddUser;
foreach (var item in listUsers)
{
ExpiringVerificationDto verification = new ExpiringVerificationDto();
verification.EmailAddress = item.Email;
verification.FirstName = item.FirstName;
verification.LastName = item.LastName;
verification.UserName = item.UserName;
verification.LastVerifiedDate = new DateTime();
verification.ExpiredDate = new DateTime();
flagAddUser = false;
var profiles = item.Profiles;
foreach (var itemProfile in profiles)
{
var specialization = itemProfile.Specializations;
foreach (var itemSpecialization in specialization)
{
// File unverified or expired
if (itemSpecialization.ExpiredDate != null || itemSpecialization.ExpiredDate < DateTime.Now)
{
// If the specialist has more than 1 compliances, it will show the closest date of expiring
if (itemSpecialization.ExpiredDate > verification.ExpiredDate)
{
verification.LastVerifiedDate = itemSpecialization.LastVerifiedDate;
verification.ExpiredDate = itemSpecialization.ExpiredDate;
flagAddUser = true;
}
}
}
}
if (flagAddUser)
listVerification.Add(verification);
}
if (listVerification != null && listVerification.Any())
{
var _totalItem = listVerification.Count();
switch (sortBy)
{
case ReportSort.FirstName:
listVerification = isDesc ? listVerification.OrderByDescending(e => e.FirstName).ToList()
: listVerification.OrderBy(e => e.FirstName).ToList();
break;
case ReportSort.LastName:
listVerification = isDesc ? listVerification.OrderByDescending(e => e.LastName).ToList()
: listVerification.OrderBy(e => e.LastName).ToList();
break;
case ReportSort.EmailAddress:
listVerification = isDesc ? listVerification.OrderByDescending(e => e.EmailAddress).ToList()
: listVerification.OrderBy(e => e.EmailAddress).ToList();
break;
case ReportSort.UserName:
listVerification = isDesc ? listVerification.OrderByDescending(e => e.UserName).ToList()
: listVerification.OrderBy(e => e.UserName).ToList();
break;
case ReportSort.ExpiredDate:
listVerification = isDesc ? listVerification.OrderByDescending(e => e.ExpiredDate).ToList()
: listVerification.OrderBy(e => e.ExpiredDate).ToList();
break;
case ReportSort.LastVerifiedDate:
listVerification = isDesc ? listVerification.OrderByDescending(e => e.LastVerifiedDate).ToList()
: listVerification.OrderBy(e => e.LastVerifiedDate).ToList();
break;
default:
listVerification = isDesc ? listVerification.OrderByDescending(e => e.UserName).ToList()
: listVerification.OrderBy(e => e.UserName).ToList();
break;
}
return listVerification.Skip(currentPage * pageSize).Take(pageSize).Select(p => new ExpiringVerificationDto()
{
FirstName = p.FirstName,
LastName = p.LastName,
EmailAddress = p.EmailAddress,
UserName = p.UserName,
ExpiredDate = p.ExpiredDate,
LastVerifiedDate = p.LastVerifiedDate,
}).ToPagedList(currentPage, pageSize, _totalItem);
}
return null;
}
public ActionResult PaymentDefaultPaging(int? page, int? pageSize, string keyword = "",
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false,
PaymentDefaultType paymentDafaultType = PaymentDefaultType.All)
{
int _currentPageIndex = page.HasValue ? page.Value - 1 : 0;
int _pageSize = pageSize.HasValue ? pageSize.Value : 10;
var list = AdminServices.Report.GetPaymentDefault(keyword, paymentDafaultType, _currentPageIndex, _pageSize, sortBy, isDesc);
var model = new PaymentDefaultViewModel(keyword, sortBy, isDesc, _pageSize) { PaymentDefault = list };
model.ListAllPaymentDefault = AdminServices.Report.GetAllPaymentDefault(paymentDafaultType);
return PartialView("~/Areas/Admin/Views/Dashboard/_ajaxPaymentDefault.cshtml", model);
}
public ActionResult RegistrationRequiringVerification(int? page, int? pageSize, string keyword = "",
ReportSort sortBy = ReportSort.FirstName, bool isDesc = false)
{
int _currentPageIndex = page.HasValue ? page.Value - 1 : 0;
int _pageSize = pageSize.HasValue ? pageSize.Value : 10;
var list = AdminServices.Report.GetRegistrationVerification(keyword, _currentPageIndex, _pageSize, sortBy, isDesc);
var model = new RegistrationVerificationViewModel(keyword, sortBy, isDesc, _pageSize) { PaymentDefault = list };
if (!Request.IsAjaxRequest())
{
return View(model);
}
return PartialView("_ajaxRegistrationRequiringVerification", model);
}
