/// <summary>
/// Method to Get Sites by sort
/// </summary>
/// <param name="id"></param>
/// <param name="search"></param>
/// <param name="sortby"></param>
/// <returns></returns>
public ActionResult GetSitesBySort(int?id, string search, string sortby)
{
try
{
int pageno = 1;
List <SiteListViewModel> Sites = null;
ViewData["ActiveId"] = id.HasValue ? id.Value : 0;
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["SiteSearchCriteria"];
objSearch.Active = id;
objSearch.CurrentSort = sortby;
objSearch.SearchText = search;
TempData["SiteSearchCriteria"] = objSearch;
Sites = GetSites(objSearch);
pageno = objSearch.Page.HasValue ? objSearch.Page.Value : 1;
return(PartialView("_SiteList", Sites.ToPagedList(pageno, SPFSConstants.SitePageSize)));
}
catch (Exception)
{
Utilities util = new Utilities();
string msg = "error occured while loading sites information";
throw new Exception(util.GetDivElements(msg, "alert alert-danger", "Error ! "));
}
}
/// <summary>
/// Used to Export Items to Excel.
/// </summary>
/// <param name="fileName"></param>
public void ExportData(string fileName)
{
List <SiteListViewModel> SiteViewModel = null;
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["SiteSearchCriteria"];
TempData.Keep("SiteSearchCriteria");
if (objSearch != null)
{
SiteViewModel = GetSites(objSearch);
SiteViewModel = SortByInput(objSearch.CurrentSort, SiteViewModel);
}
var result = (from site in SiteViewModel
select new
{
Gdis_org_entity_ID = site.Gdis_org_entity_ID,
Gdis_org_Parent_ID = site.Gdis_org_Parent_ID,
Name = site.Name,
Address_1 = site.Address_1,
Address_2 = site.Address_2,
City = site.City,
State = site.State,
Country = site.Country,
Postal_Code = site.Postal_Code,
SPFS_Active = site.SPFS_Active,
}).ToList();
base.ExportToCSV(result.GetCSV(), fileName + DateTime.Now.ToShortDateString());
}
/// <summary>
/// Used to Export Items to Excel.
/// </summary>
/// <param name="fileName"></param>
public void ExportData(string fileName)
{
List <SupplierListViewModel> SupplierViewModel = null;
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["SupplierSearchCriteria"];
TempData.Keep("SupplierSearchCriteria");
if (objSearch != null)
{
SupplierViewModel = GetSuppliers(objSearch);
SupplierViewModel = SortByInput(objSearch.CurrentSort, SupplierViewModel);
}
var result = (from sup in SupplierViewModel
select new
{
CID = sup.CID,
Duns = sup.Duns,
Name = sup.Name,
Address1 = sup.Address_1,
Address2 = sup.Address_2,
City = sup.City,
State = sup.State,
Country = sup.Country,
PostalCode = sup.Postal_Code,
Active = sup.SPFS_Active ? true : false,
}).ToList();
base.ExportToCSV(result.GetCSV(), fileName + DateTime.Now.ToShortDateString());
}
/// <summary>
/// Method to retrieve Sites by input
/// </summary>
/// <param name="id"></param>
/// <param name="search"></param>
/// <param name="page"></param>
/// <param name="sortby"></param>
/// <returns></returns>
public ActionResult GetSiteBySearch(int?id, string search)
{
int pageno = 1;
List <SiteListViewModel> Sites = null;
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["SiteSearchCriteria"];
objSearch.Active = id;
objSearch.SearchText = search;
Sites = GetSites(objSearch);
//pageno = objSearch.Page.Value;
TempData["SiteSearchCriteria"] = objSearch;
return(PartialView("_SiteList", Sites.ToPagedList(pageno, SPFSConstants.SitePageSize)));
}
/// <summary>
/// Method to retrieve suppliers by input
/// </summary>
/// <param name="id"></param>
/// <param name="search"></param>
/// <param name="page"></param>
/// <param name="sortby"></param>
/// <returns></returns>
public ActionResult GetSupplierByActiveOrInActive(int?id, string search)
{
int pageno = 1;
List <SupplierListViewModel> suppliers = null;
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["SupplierSearchCriteria"];
objSearch.Active = id;
objSearch.SearchText = search;
suppliers = GetSuppliers(objSearch);
pageno = objSearch.Page.Value;
TempData["SupplierSearchCriteria"] = objSearch;
return(PartialView("_SupplierList", suppliers.ToPagedList(pageno, SPFSConstants.SupplierPageSize)));
}
/// <summary>
/// Method to retrieve Sites by page
/// </summary>
/// <param name="search"></param>
/// <param name="page"></param>
/// <param name="sortby"></param>
/// <param name="activeId"></param>
/// <returns></returns>
public ActionResult SearchByPage(int?page)
{
CreateViewBags();
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["SiteSearchCriteria"];
objSearch.Page = page.HasValue ? page : objSearch.Page;
TempData["SiteSearchCriteria"] = objSearch;
List <SiteListViewModel> Sites = null;
Sites = GetSites(objSearch);
Sites = SortByInput(objSearch.CurrentSort, Sites);
int pageno = objSearch.Page.HasValue ? objSearch.Page.Value : 1;
return(View("Index", Sites.ToPagedList(pageno, SPFSConstants.SitePageSize)));
}
/// <summary>
/// Method to retrieve users by page
/// </summary>
/// <param name="search"></param>
/// <param name="page"></param>
/// <param name="sortby"></param>
/// <param name="activeId"></param>
/// <returns></returns>
public ActionResult SearchByPage(int?page)
{
CreateViewBags();
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["UserSearchCriteria"];
objSearch.Page = page.HasValue ? page : objSearch.Page;
TempData["UserSearchCriteria"] = objSearch;
List <UserListViewModel> userViewModel = null;
userViewModel = GetUsers(objSearch);
userViewModel = SortByInput(objSearch.CurrentSort, userViewModel);
int pageno = objSearch.Page.HasValue ? objSearch.Page.Value : 1;
return(View("Index", userViewModel.ToPagedList(pageno, SPFSConstants.UserPageSize)));
}
// GET: User
public ActionResult Index()
{
CreateViewBags();
List <UserListViewModel> users = new List <UserListViewModel>();
if (TempData["UserSearchCriteria"] == null)
{
IntializeSearchCriteria();
}
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["UserSearchCriteria"];
users = GetUsers(objSearch);
users = SortByInput(objSearch.CurrentSort, users);
int pageNumber = objSearch.Page.HasValue ? objSearch.Page.Value : 1;
return(View(users.ToPagedList(pageNumber, SPFSConstants.UserPageSize)));
}
/// <summary>
/// Method to Get Users by Search
/// </summary>
/// <param name="id"></param>
/// <param name="search"></param>
/// <param name="userViewModel"></param>
/// <returns></returns>
//private List<UserListViewModel> GetUserBySearch(int? pageno)
//{
// GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["UserSearchCriteria"];
// objSearch.Page = pageno;
// TempData["UserSearchCriteria"] = objSearch;
// return GetUsers(objSearch);
//}
private List <UserListViewModel> GetUsers(GeneralSearchCriteria ObjSearch)
{
List <UserListViewModel> users;
using (Repository rep = new Repository())
{
var user = (from usr in rep.Context.SPFS_USERS
join tmprole in rep.Context.SPFS_ROLES on usr.RoleID equals tmprole.RoleID into tpRole
from role in tpRole.DefaultIfEmpty()
select new UserListViewModel()
{
UserID = usr.UserID,
UserName = usr.UserName,
Email = usr.Email,
FirstName = usr.First_Name,
MiddleName = usr.MiddleName,
LastName = usr.Last_Name,
RoleName = role != null ? role.RoleName : string.Empty,
SPFS_Active = usr.SPFS_Active ? true : false,
UserSites = (from usrsite in rep.Context.SPFS_USERSITES
join site in rep.Context.SPFS_SITES on usrsite.SiteID equals site.SiteID
where usrsite.UserID == usr.UserID
select site.Name).ToList()
});
if (ObjSearch.Active.HasValue)
{
if (ObjSearch.Active.Value == 1)
{
user = user.Where(item => item.SPFS_Active);
}
else if (ObjSearch.Active.Value == 0)
{
user = user.Where(item => !item.SPFS_Active);
}
}
if (!string.IsNullOrEmpty(ObjSearch.SearchText))
{
user = user.Where(item => item.UserName.Contains(ObjSearch.SearchText) ||
item.FirstName.Contains(ObjSearch.SearchText));
}
users = SortByInput(ObjSearch.CurrentSort, user.ToList());
}
return(users);
}
//public ActionResult FillUserInfoFromAD(string userName)
//{
// CreateViewBags();
// UserViewModel user = null;
// if (TempData["AdUsers"] != null)
// {
// List<UserViewModel> adResult = (List<UserViewModel>)TempData["AdUsers"];
// if (adResult.Count > 0)
// {
// TempData["AdUsers"] = adResult;
// user = adResult.Where(item => item.UserName.Equals(userName)).FirstOrDefault();
// }
// }
// UserViewModel userViewModel = new UserViewModel();
// userViewModel = new UserViewModel() { UserName = user.UserName, FirstName = user.FirstName, LastName = user.LastName, Email = user.Email, SPFS_Active = true };
// return View("Create", userViewModel);
//}
/// <summary>
/// Used to Export Items to Excel.
/// </summary>
/// <param name="fileName"></param>
public void ExportData(string fileName)
{
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["UserSearchCriteria"];
TempData.Keep("UserSearchCriteria");
using (Repository ExpRep = new Repository())
{
var result = (from usrsite in ExpRep.Context.SPFS_USERSITES
join site in ExpRep.Context.SPFS_SITES on usrsite.SiteID equals site.SiteID
join user in ExpRep.Context.SPFS_USERS on usrsite.UserID equals user.UserID
join tmprole in ExpRep.Context.SPFS_ROLES on user.RoleID equals tmprole.RoleID
select new UserExportViewModel
{
UserID = usrsite.UserID,
UserName = user.UserName,
FirstName = user.First_Name,
LastName = user.Last_Name,
MiddleName = user.MiddleName,
RoleName = tmprole.RoleName.Trim(),
Email = user.Email,
SPFS_Active = user.SPFS_Active,
UserSiteName = site.Name
});
if (objSearch.Active.HasValue)
{
if (objSearch.Active.Value == 1)
{
result = result.Where(item => item.SPFS_Active);
}
else if (objSearch.Active.Value == 0)
{
result = result.Where(item => !item.SPFS_Active);
}
}
if (!string.IsNullOrEmpty(objSearch.SearchText))
{
result = result.Where(item => item.UserName.Contains(objSearch.SearchText) ||
item.FirstName.Contains(objSearch.SearchText));
}
base.ExportToCSV(result.ToList().GetCSV(), fileName + DateTime.Now.ToShortDateString());
}
}
public ActionResult Index(int?page)
{
CreateViewBags();
List <SiteListViewModel> Sites = new List <SiteListViewModel>();
if (TempData["SiteSearchCriteria"] == null)
{
InitializeSearchCriteria();
}
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["SiteSearchCriteria"];
Sites = GetSites(objSearch);
Sites = SortByInput(objSearch.CurrentSort, Sites);
int pageNumber = objSearch.Page.HasValue ? objSearch.Page.Value : 1;
return(View(Sites.ToPagedList(pageNumber, SPFSConstants.SitePageSize)));
}
/// <summary>
/// Method to Get Users by sort
/// </summary>
/// <param name="id"></param>
/// <param name="search"></param>
/// <param name="sortby"></param>
/// <returns></returns>
public ActionResult GetUsersBySort(int?id, string search, string sortby)
{
int pageno = 1;
List <UserListViewModel> userViewModel = null;
ViewData["ActiveId"] = id.HasValue ? id.Value : 0;
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["UserSearchCriteria"];
objSearch.Active = id;
objSearch.CurrentSort = sortby;
objSearch.SearchText = search;
TempData["UserSearchCriteria"] = objSearch;
userViewModel = GetUsers(objSearch);
pageno = objSearch.Page.HasValue ? objSearch.Page.Value : 1;
return(PartialView("_UserList", userViewModel.ToPagedList(pageno, SPFSConstants.UserPageSize)));
}
private List <SiteListViewModel> GetSites(GeneralSearchCriteria ObjSearch)
{
List <SiteListViewModel> Sites;
using (Repository rep = new Repository())
{
var Site = (from site in rep.Context.SPFS_SITES
select new SiteListViewModel()
{
SiteID = site.SiteID,
Gdis_org_entity_ID = site.Gdis_org_entity_ID,
Gdis_org_Parent_ID = site.Gdis_org_Parent_ID,
Name = site.Name,
Address_1 = site.Address_1,
Address_2 = site.Address_2,
City = site.City,
State = site.State,
Country = site.Country,
Postal_Code = site.Postal_Code,
SPFS_Active = site.SPFS_Active,
});
if (ObjSearch.Active.HasValue)
{
if (ObjSearch.Active.Value == 1)
{
Site = Site.Where(item => item.SPFS_Active);
}
if (ObjSearch.Active.Value == 0)
{
Site = Site.Where(item => !item.SPFS_Active);
}
}
if (!string.IsNullOrEmpty(ObjSearch.SearchText))
{
Site = Site.Where(item => item.Name.Contains(ObjSearch.SearchText) || item.Gdis_org_entity_ID.ToString().Contains(ObjSearch.SearchText) || item.Gdis_org_Parent_ID.ToString().Contains(ObjSearch.SearchText));
}
Sites = SortByInput(ObjSearch.CurrentSort, Site.ToList());
}
return(Sites);
}
private List <SupplierListViewModel> GetSuppliers(GeneralSearchCriteria ObjSearch)
{
List <SupplierListViewModel> suppliers;
using (Repository rep = new Repository())
{
var supplier = (from supp in rep.Context.SPFS_SUPPLIERS
select new SupplierListViewModel()
{
CID = supp.CID,
Duns = supp.Duns,
Name = supp.Name,
Address_1 = supp.Address_1,
Address_2 = supp.Address_2,
City = supp.City,
State = supp.State,
Country = supp.Country,
Postal_Code = supp.Postal_Code,
SPFS_Active = supp.SPFS_Active
});
if (ObjSearch.Active.HasValue)
{
if (ObjSearch.Active.Value == 1)
{
supplier = supplier.Where(item => item.SPFS_Active);
}
if (ObjSearch.Active.Value == 0)
{
supplier = supplier.Where(item => !item.SPFS_Active);
}
}
if (!string.IsNullOrEmpty(ObjSearch.SearchText))
{
supplier = supplier.Where(item => item.Name.Contains(ObjSearch.SearchText) || item.Duns.Contains(ObjSearch.SearchText) || item.CID.ToString().Contains(ObjSearch.SearchText));
}
suppliers = SortByInput(ObjSearch.CurrentSort, supplier.ToList());
}
return(suppliers);
}
/// <summary>
/// Method to retrieve Users by input
/// </summary>
/// <param name="id"></param>
/// <param name="search"></param>
/// <param name="page"></param>
/// <param name="sortby"></param>
/// <returns></returns>
public ActionResult GetUserBySearch(int?id, string search)
{
try
{
int pageno = 1;
List <UserListViewModel> userViewModel = null;
GeneralSearchCriteria objSearch = (GeneralSearchCriteria)TempData["UserSearchCriteria"];
objSearch.Active = id;
objSearch.SearchText = search;
userViewModel = GetUsers(objSearch);
//pageno = objSearch.Page.Value;
TempData["UserSearchCriteria"] = objSearch;
return(PartialView("_UserList", userViewModel.ToPagedList(pageno, SPFSConstants.UserPageSize)));
}
catch (Exception)
{
Utilities util = new Utilities();
string msg = "error occured while loading users information";
throw new Exception(util.GetDivElements(msg, "alert alert-danger", "Error ! "));
}
}
private void InitializeSearchCriteria()
{
TempData["SiteSearchCriteria"] = new GeneralSearchCriteria {
Active = 2, Page = 1, SearchText = string.Empty, CurrentSort = " "
};
}
