public ActionResult ConfigurationList(ConfigureUrlSearchFilter searchFilter)
{
Logger.Info(_logMsg.Clear().SetPrefixMsg("Search Configuration").Add("SystemName", searchFilter.SystemName)
.Add("Url", searchFilter.Url).Add("Status", searchFilter.Status));
try
{
if (ModelState.IsValid)
{
_commonFacade = new CommonFacade();
_configFacade = new ConfigurationFacade();
ConfigurationViewModel configVM = new ConfigurationViewModel();
configVM.SearchFilter = searchFilter;
configVM.ConfigureUrlList = _configFacade.GetConfigureURL(searchFilter);
ViewBag.PageSize = configVM.SearchFilter.PageSize;
ViewBag.PageSizeList = _commonFacade.GetPageSizeList();
return(PartialView("~/Views/Configuration/_ConfigurationList.cshtml", configVM));
}
return(Json(new
{
Valid = false,
Error = string.Empty,
Errors = GetModelValidationErrors()
}));
}
catch (Exception ex)
{
Logger.Error("Exception occur:\n", ex);
Logger.Info(_logMsg.Clear().SetPrefixMsg("Search Configuration").Add("Error Message", ex.Message).ToFailLogString());
return(Error(new HandleErrorInfo(ex, this.ControllerContext.RouteData.Values["controller"].ToString(),
this.ControllerContext.RouteData.Values["action"].ToString())));
}
}
public IEnumerable <ConfigureUrlEntity> GetConfigureUrl(ConfigureUrlSearchFilter searchFilter)
{
var urlList = (from cf in _context.TB_M_CONFIG_URL.AsNoTracking()
join mu in _context.TB_C_MENU on cf.MENU_ID equals mu.MENU_ID
where (string.IsNullOrEmpty(searchFilter.SystemName) || cf.CONFIG_NAME.ToUpper().Contains(searchFilter.SystemName.ToUpper())) &&
(string.IsNullOrEmpty(searchFilter.Url) || cf.CONFIG_URL.ToUpper().Contains(searchFilter.Url.ToUpper())) &&
(searchFilter.Status == null || searchFilter.Status == Constants.ApplicationStatus.All || cf.STATUS == searchFilter.Status)
select new ConfigureUrlEntity
{
ConfigureUrlId = cf.CONFIG_URL_ID,
SystemName = cf.CONFIG_NAME,
Url = cf.CONFIG_URL,
ImageFile = cf.IMAGE,
Status = cf.STATUS,
Menu = mu != null ? new MenuEntity
{
MenuId = mu.MENU_ID,
MenuName = mu.MENU_NAME
} : null,
Roles = (from r in _context.TB_M_CONFIG_ROLE
where r.CONFIG_URL_ID == cf.CONFIG_URL_ID
select new RoleEntity
{
RoleName = r.TB_C_ROLE.ROLE_NAME,
RoleId = r.TB_C_ROLE.ROLE_ID
}).ToList()
});
int startPageIndex = (searchFilter.PageNo - 1) * searchFilter.PageSize;
searchFilter.TotalRecords = urlList.Count();
if (startPageIndex >= searchFilter.TotalRecords)
{
startPageIndex = 0;
searchFilter.PageNo = 1;
}
urlList = SetConfigureUrlSort(urlList, searchFilter);
return(urlList.Skip(startPageIndex).Take(searchFilter.PageSize).ToList <ConfigureUrlEntity>());
}
public IEnumerable <ConfigureUrlEntity> GetConfigureURL(ConfigureUrlSearchFilter searchFilter)
{
_commonDataAccess = new CommonDataAccess(_context);
return(_commonDataAccess.GetConfigureUrl(searchFilter));
}
private static IQueryable <ConfigureUrlEntity> SetConfigureUrlSort(IQueryable <ConfigureUrlEntity> urlList, ConfigureUrlSearchFilter searchFilter)
{
if (searchFilter.SortOrder.ToUpper(CultureInfo.InvariantCulture).Equals("ASC"))
{
switch (searchFilter.SortField.ToUpper(CultureInfo.InvariantCulture))
{
case "SYSTEMNAME":
return(urlList.OrderBy(ord => ord.SystemName));
case "URL":
return(urlList.OrderBy(ord => ord.Url));
case "STATUS":
return(urlList.OrderBy(ord => (ord.Status == 1) ? "A" : "I"));
default:
return(urlList.OrderBy(ord => ord.ConfigureUrlId));
}
}
else
{
switch (searchFilter.SortField.ToUpper(CultureInfo.InvariantCulture))
{
case "SYSTEMNAME":
return(urlList.OrderByDescending(ord => ord.SystemName));
case "URL":
return(urlList.OrderByDescending(ord => ord.Url));
case "STATUS":
return(urlList.OrderByDescending(ord => (ord.Status == 1) ? "A" : "I"));
default:
return(urlList.OrderByDescending(ord => ord.ConfigureUrlId));
}
}
}
