public async Task <PaginatedList <BannedWord> > GetAllPaged(int pageIndex, int pageSize)
{
var query = _context.BannedWord.OrderBy(x => x.Word);
return(await PaginatedList <BannedWord> .CreateAsync(query.AsNoTracking(), pageIndex, pageSize));
}
public static Task <PaginatedList <TDestination> > PaginatedListAsync <TDestination>(this IQueryable <TDestination> queryable, int pageNumber, int pageSize) => PaginatedList <TDestination> .CreateAsync(queryable, pageNumber, pageSize);
public void CreatePage()
{
if (Request.Cookies["pagesize"] != null)
{
PageSize = int.Parse(Request.Cookies["pagesize"]);
}
IQueryable <Data.Tables.Technical> query;
if (!ShowDeleted)
{
query = _db.Technical.AsNoTracking().AsQueryable();
}
else
{
query = _db.Technical.AsNoTracking().IgnoreQueryFilters().AsQueryable();
}
char separator = ',';
string[] filterOptions =
{
"Prawda",
"Fałsz",
};
kanbanFilter = new SelectList(filterOptions);
if (Filter_Rodzina != null)
{
var options = Filter_Rodzina.Split(separator).Select(c => c.Trim());
foreach (var option in options)
{
query = query.Where(c => c.Rodzina.Contains(option));
}
}
if (Filter_Wiazka != null)
{
var options = Filter_Wiazka.Split(separator).Select(c => c.Trim());
foreach (var option in options)
{
query = query.Where(c => c.Wiazka.Contains(option));
}
}
if (Filter_KodWiazki != null)
{
var options = Filter_KodWiazki.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.KodWiazki));
}
if (Filter_PrzewodCiety != null)
{
var options = Filter_PrzewodCiety.Split(separator).Select(c => c.Replace("PLC", "").Trim());
foreach (var option in options)
{
query = query.Where(c => c.PrzewodCiety.Contains(option));
}
}
if (Filter_BIN != null)
{
var options = Filter_BIN.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.BIN));
}
if (Filter_LiteraRodziny != null)
{
var options = Filter_LiteraRodziny.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.LiterRodziny));
}
if (Filter_Uwagi != null)
{
var options = Filter_Uwagi.Split(separator).Select(c => c.Trim());
foreach (var option in options)
{
query = query.Where(c => c.Uwagi.Contains(option));
}
}
if (Filter_IlePrzedowow != null)
{
var options = Filter_IlePrzedowow.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.IlePrzewodow));
}
if (Filter_Kanban != null)
{
if (Filter_Kanban == "Prawda")
{
query = query.Where(c => c.KanBan == true);
}
else if (Filter_Kanban == "Fałsz")
{
query = query.Where(c => c.KanBan == false);
}
}
string[] sortings =
{
"Rodzina",
"Wiązka",
"Litera rodziny",
"Kod wiązki",
"Przew. Cięty",
"BIN"
};
availableSortings = new SelectList(sortings);
if (SortColumn != null)
{
switch (SortColumn)
{
case "Rodzina":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.Rodzina);
}
else
{
query = query.OrderBy(c => c.Rodzina);
}
break;
case "Wiązka":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.Wiazka);
}
else
{
query = query.OrderBy(c => c.Wiazka);
}
break;
case "Litera rodziny":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.LiterRodziny);
}
else
{
query = query.OrderBy(c => c.LiterRodziny);
}
break;
case "Kod wiązki":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.KodWiazki);
}
else
{
query = query.OrderBy(c => c.KodWiazki);
}
break;
case "Przew. Cięty":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.PrzewodCiety);
}
else
{
query = query.OrderBy(c => c.PrzewodCiety);
}
break;
case "BIN":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.BIN);
}
else
{
query = query.OrderBy(c => c.BIN);
}
break;
}
}
Data = PaginatedList <Data.Tables.Technical> .CreateAsync(query, CurrentPage, PageSize).Result;
}
public async Task <IActionResult> About(int?pageNumber)
{
int pageSize = 5;
return(View(await PaginatedList <QAMessage> .CreateAsync(_context.QAMessages.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
// GET
public async Task <IActionResult> Index(int?pageNumber)
{
var posts = from p in _db.Posts orderby p.Title where p.IsApproved && p.Type.Equals(PostType.Guide.ToString()) select p;
return(View(await PaginatedList <Post> .CreateAsync(posts.AsNoTracking(), pageNumber ?? 1, 3)));
}
// GET: DirectoryClients
public async Task <IActionResult> Index(
string sortOrder,
string currentFilter,
string searchString,
int?pageNumber)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["FirstName"] = String.IsNullOrEmpty(sortOrder) ? "fname_desc" : "";
ViewData["SecondName"] = sortOrder == "Sname" ? "sname_desc" : "Sname";
ViewData["Patronymic"] = sortOrder == "Patronymic" ? "patronymic_desc" : "Patronymic";
ViewData["ClientDate"] = sortOrder == "Date" ? "date_desc" : "Date";
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var clients = from s in _context.Clients
select s;
if (!String.IsNullOrEmpty(searchString))
{
clients = clients.Where(s => s.FirstName.Contains(searchString) ||
s.SecondName.Contains(searchString));
}
switch (sortOrder)
{
case "fname_desc":
clients = clients.OrderByDescending(s => s.FirstName);
break;
case "sname_desc":
clients = clients.OrderByDescending(s => s.SecondName);
break;
case "patronymic_desc":
clients = clients.OrderByDescending(s => s.Patronymic);
break;
case "Sname":
clients = clients.OrderBy(s => s.SecondName);
break;
case "Patronymic":
clients = clients.OrderBy(s => s.Patronymic);
break;
case "Date":
clients = clients.OrderBy(s => s.ClientDate);
break;
case "date_desc":
clients = clients.OrderByDescending(s => s.ClientDate);
break;
default:
clients = clients.OrderBy(s => s.FirstName);
break;
}
int pageSize = 3;
return(View(await PaginatedList <DirectoryClients> .CreateAsync(clients.AsNoTracking(), pageNumber ?? 1, pageSize)));
//return View(await clients.AsNoTracking().ToListAsync());
//return View(await _context.Clients.ToListAsync());
}
// GET: Students
public async Task <IActionResult> Index(
string sortOrder,
string currentFilter,
string searchString,
int?page)
{
ViewData["CurrentSort"] = sortOrder;
// If sort name is null then set at lastname_desc else empty the string
ViewData["NameSortParm"] =
String.IsNullOrEmpty(sortOrder) ? "LastName_desc" : "";
// If sortorder is equal to enrollment
ViewData["DateSortParm"] =
sortOrder == "EnrollmentDate" ? "EnrollmentDate_desc" : "EnrollmentDate";
// no search string is given -- return page 1 as default
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
// Set up queryable variable to use in searches
var students = from s in _context.Students select s;
if (!String.IsNullOrEmpty(searchString))
{
// if last name or first/middle name contains search string then return the query list
students = students.Where(s => s.LastName.Contains(searchString) || s.FirstMidName.Contains(searchString));
}
// Sorted by last name if no sort order given
if (string.IsNullOrEmpty(sortOrder))
{
sortOrder = "LastName";
}
bool descending = false;
if (sortOrder.EndsWith("_desc"))
{
sortOrder = sortOrder.Substring(0, sortOrder.Length - 5);
descending = true;
}
if (descending)
{
students = students.OrderByDescending(e => EF.Property <object>(e, sortOrder));
}
else
{
students = students.OrderBy(e => EF.Property <object>(e, sortOrder));
}
// Split the student list into 3 equivalent sizes if possible
int pageSize = 3;
return(View(await PaginatedList <Student> .CreateAsync(students.AsNoTracking(),
page ?? 1, pageSize)));
}
// GET: Stores
public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?page)
{
// get current user
ApplicationUser user = await GetCurrentUserAsync();
// Get the roles for the user
var roles = await _userManager.GetRolesAsync(user);
// create a list of stores
// by default, only retrieve matching stores where current user is the Sales Rep attached to the store
var stores = _context.Store.Include("SalesRep").Include("State").Include("Status").Where(s => s.SalesRep == user);
// check if the user is an Administrator
if (roles.Contains("Administrator"))
{
// retrieve all stores to display (for site administrator)
stores = _context.Store.Include("SalesRep").Include("State").Include("Status");
}
if (!String.IsNullOrEmpty(searchString))
{
stores = stores.Where(s => s.Name.ToLower().Contains(searchString.ToLower()) || s.Status.Name.ToLower().Contains(searchString.ToLower()));
}
ViewData["CurrentSort"] = sortOrder;
ViewData["OrderDateSortParm"] = String.IsNullOrEmpty(sortOrder) ? "Date" : "";
ViewData["NameSortParm"] = sortOrder == "name" ? "name_desc" : "Name";
ViewData["StatusSortParm"] = sortOrder == "Status" ? "status_desc" : "Status";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
switch (sortOrder)
{
case "Name":
stores = stores.OrderBy(s => s.Name);
break;
case "name_desc":
stores = stores.OrderByDescending(s => s.Name);
break;
case "Date":
stores = stores.OrderBy(s => s.LastOrderDate);
break;
case "date_desc":
stores = stores.OrderByDescending(s => s.LastOrderDate);
break;
case "Status":
stores = stores.OrderBy(s => s.StatusId);
break;
case "status_desc":
stores = stores.OrderByDescending(s => s.StatusId);
break;
default:
stores = stores.OrderByDescending(s => s.LastOrderDate);
break;
}
// set amount of stores to display per page
int pageSize = 25;
return(View(await PaginatedList <Store> .CreateAsync(stores, page ?? 1, pageSize)));
}
public async Task <ViewResult> Index(
string sortOrder,
string searchString,
string currentFilter,
int?pageNumber)
{
ViewBag.CurrentSort = sortOrder;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.StatusSortParm = sortOrder == "Status" ? "status_desc" : "Status";
ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
var tickets = from t in _context.Ticket select t;
if (!String.IsNullOrEmpty(searchString))
{
tickets = tickets.Where(t => t.TicketName.Contains(searchString) ||
t.TicketProjectName.Contains(searchString) ||
t.TicketDescription.Contains(searchString));
}
switch (sortOrder)
{
case "name_desc":
tickets = tickets.OrderByDescending(t => t.TicketProjectName);
break;
case "Status":
tickets = tickets.OrderBy(t => t.TicketStatus);
break;
case "status_desc":
tickets = tickets.OrderByDescending(t => t.TicketStatus);
break;
case "Date":
tickets = tickets.OrderBy(t => t.StartDate);
break;
case "date_desc":
tickets = tickets.OrderByDescending(t => t.StartDate);
break;
default:
tickets = tickets.OrderBy(t => t.TicketProjectName);
break;
}
int pageSize = 5;
return(View(await PaginatedList <TicketModel> .CreateAsync(tickets.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
public async Task <IActionResult> Index(string sortOrder, string searchString, string currentFilter, int?page)
{
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
//Sorting
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = sortOrder == "Name" ? "Name_desc" : "Name";
ViewData["StatusSortParm"] = sortOrder == "Status" ? "Status_desc" : "Status";
ViewData["PreparerSortParm"] = sortOrder == "Preparer" ? "Preparer_desc" : "Preparer";
var persons = from p in _contextDB.Person
select p;
if (!String.IsNullOrEmpty(searchString))
{
persons = persons.Where(p => p.Name.Contains(searchString));
}
switch (sortOrder)
{
case "Name":
persons = persons.OrderBy(p => p.Name);
break;
case "Name_desc":
persons = persons.OrderByDescending(p => p.Name);
break;
case "Status":
persons = persons.OrderBy(p => p.Status);
break;
case "Status_desc":
persons = persons.OrderByDescending(p => p.Status);
break;
case "Preparer":
persons = persons.OrderBy(p => p.Preparer);
break;
case "Preparer_desc":
persons = persons.OrderByDescending(p => p.Preparer);
break;
default:
persons = persons.OrderBy(p => p.Number);
break;
}
//Number of items on on page
int pageSize = 15;
int pageNumber = (page ?? 1);
return(View(await PaginatedList <Person> .CreateAsync(persons.AsNoTracking(), page ?? 1, pageSize)));
}
// GET: Kendaraan
public async Task <IActionResult> Index(string ktsd, string searchString, string searchFil, string sortOrder, string currentFilter, int?pageNumber)
//buat list menyimpan ktersediaan
{
var ktsdList = new List <String>();
var ktsdQuery = from d in _context.Kendaraan orderby d.Ketersediaan select d.Ketersediaan;
ktsdList.AddRange(ktsdQuery.Distinct());
//menampilkan kedalam dropdown ListView di view
ViewBag.ktsd = new SelectList(ktsdList);
var menu = from m in _context.Kendaraan.Include(k => k.IdJenisKendaraanNavigation) select m;
if (!string.IsNullOrEmpty(ktsd))
{
menu = menu.Where(x => x.Ketersediaan == ktsd);
}
if (!string.IsNullOrEmpty(searchString))
{
menu = menu.Where(s => s.NoPolisi.Contains(searchString));
}
//var rental_kendaraanContext = _context.Kendaraan.Include(k => k.IdJenisKendaraanNavigation);
//return View(await rental_kendaraanContext.ToListAsync());
ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date";
switch (sortOrder)
{
case "name_desc":
menu = menu.OrderByDescending(s => s.NamaKendaraan);
break;
case "Date":
menu = menu.OrderBy(s => s.NoPolisi);
break;
default: //name ascending
menu = menu.OrderBy(s => s.NamaKendaraan);
break;
}
ViewData["CurrentSort"] = sortOrder;
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
// return View(await menu.ToListAsync());
int pageSize = 5;
return(View(await PaginatedList <Kendaraan> .CreateAsync(menu.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
// GET: ProductKey
public async Task <IActionResult> Index(string sortBy, string search, string currentFilter, int?pageNumber, int?pageRow)
{
int pageSize = pageRow ?? 10;
ViewData["totalRow"] = pageRow;
ViewData["CurrentSort"] = sortBy;
ViewData["KeyName"] = string.IsNullOrEmpty(sortBy) ? "KeyNameDESC" : "";
ViewData["KeyCode"] = sortBy == "KeyCode" ? "KeyCodeDESC" : "KeyCode";
ViewData["KeyStatus"] = sortBy == "KeyStatus" ? "KeyStatusDESC" : "KeyStatus";
ViewData["Onwer"] = sortBy == "Onwer" ? "OnwerDESC" : "Onwer";
if (search != null)
{
pageNumber = 1;
}
else
{
search = currentFilter;
}
ViewData["CurrentFilter"] = search;
var productKeys = _context.ProductKey.Include(p => p.ProductName).AsQueryable();
// Search product by the input
if (!string.IsNullOrEmpty(search))
{
productKeys = productKeys.Where(p => p.ProductName.Name.ToLower().Contains(search.ToLower()));
}
// Sort the product by name
switch (sortBy)
{
case "KeyNameDESC":
productKeys = productKeys.OrderByDescending(p => p.ProductName.Name);
break;
case "KeyCodeDESC":
productKeys = productKeys.OrderByDescending(p => p.Key);
break;
case "KeyCode":
productKeys = productKeys.OrderBy(p => p.Key);
break;
case "KeyStatusDESC":
productKeys = productKeys.OrderByDescending(p => p.Status);
break;
case "KeyStatus":
productKeys = productKeys.OrderBy(p => p.Status);
break;
case "OnwerDESC":
productKeys = productKeys.OrderByDescending(p => p.OwnerId);
break;
case "Onwer":
productKeys = productKeys.OrderBy(p => p.OwnerId);
break;
default:
productKeys = productKeys.OrderBy(p => p.ProductName.Name);
break;
}
if (pageRow == -1)
{
pageSize = productKeys.Count();
ViewData["totalRow"] = pageSize;
}
var model = await PaginatedList <ProductKey> .CreateAsync(productKeys.AsNoTracking(), pageNumber ?? 1, pageSize);
return(View(model));
}
public async Task <IActionResult> Index(string sortBy, string search, string currentFilter, int?pageNumber, int?pageRow)
{
int pageSize = pageRow ?? 10;
ViewData["totalRow"] = pageRow;
ViewData["CurrentSort"] = sortBy;
ViewData["Product"] = string.IsNullOrEmpty(sortBy) ? "NameDESC" : "";
ViewData["TotalKeys"] = sortBy == "TotalKey" ? "TotalKeyDESC" : "TotalKey";
ViewData["Limit"] = sortBy == "QuantityLimit" ? "QuantityLimitDESC" : "QuantityLimit";
ViewData["Status"] = sortBy == "ActiveStatus" ? "ActiveStatusDESC" : "ActiveStatus";
ViewData["Link"] = sortBy == "DownloadLink" ? "DownloadLinkDESC" : "DownloadLink";
if (search != null)
{
pageNumber = 1;
}
else
{
search = currentFilter;
}
ViewData["CurrentFilter"] = search;
var products = _context.Product.AsQueryable();
var productkeys = _context.ProductKey.AsQueryable();
//// Count the key number for each product and store the number into database
//foreach (Product product in products) {
// int keyCount = productkeys.Where(k => k.NameId == product.Id).Count();
// int usedKeyCount = productkeys.Where(k => k.NameId == product.Id && k.Status == "Used").Count();
// // Save the calculated key count number into database
// product.KeyCount = keyCount;
// _context.Entry(product).Property("KeyCount").IsModified = true;
// product.UsedKeyCount = usedKeyCount;
// _context.Entry(product).Property("UsedKeyCount").IsModified = true;
//}
//_context.SaveChanges();
// Search product by the input
if (!string.IsNullOrEmpty(search))
{
products = products.Where(p => p.Name.ToLower().Contains(search.ToLower()));
}
// Sort the product by name
switch (sortBy)
{
case "NameDESC":
products = products.OrderByDescending(p => p.Name);
break;
case "TotalKeyDESC":
products = products.OrderByDescending(p => p.KeyCount);
break;
case "TotalKey":
products = products.OrderBy(p => p.KeyCount);
break;
case "QuantityLimitDESC":
products = products.OrderByDescending(p => p.QuantityLimit);
break;
case "QuantityLimit":
products = products.OrderBy(p => p.QuantityLimit);
break;
case "ActiveStatusDESC":
products = products.OrderByDescending(p => p.ActiveStatus);
break;
case "ActiveStatus":
products = products.OrderBy(p => p.ActiveStatus);
break;
case "DownloadLinkDESC":
products = products.OrderByDescending(p => p.DownloadLink);
break;
case "DownloadLink":
products = products.OrderBy(p => p.DownloadLink);
break;
default:
products = products.OrderBy(p => p.Name);
break;
}
if (pageRow == -1)
{
pageSize = products.Count();
ViewData["totalRow"] = pageSize;
}
var model = await PaginatedList <Product> .CreateAsync(products.AsNoTracking(), pageNumber ?? 1, pageSize);
return(View(model));
}
public async Task <PaginatedList <Log> > GetPaginatedListAsync(IQueryable <Log> result, int page, int perPage)
{
return(await PaginatedList <Log> .CreateAsync(result, page, perPage));
}
// GET: Events
public async Task <IActionResult> Index(string sortOrder, string searchString, string currentFilter, int?pageNumber)
{
// Sort Parameters
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSort"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["DateSort"] = sortOrder == "Date" ? "date_desc" : "Date";
ViewData["TypeSort"] = sortOrder == "Type" ? "type_desc" : "Type";
// Search box filter
ViewData["CurrentFilter"] = searchString;
// Page number is 1 unless there's a search string
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
// Include related entities
var events = from e in _context.Events
.Include(a => a.EventType)
.Include(a => a.Manager)
select e;
// Search function
if (!string.IsNullOrEmpty(searchString))
{
events = events.Where(s => s.Name.Contains(searchString));
}
// Switch case for sorting results
switch (sortOrder)
{
case "name_desc":
events = events.OrderByDescending(s => s.Name);
break;
case "Date":
events = events.OrderBy(s => s.StartTime);
break;
case "date_desc":
events = events.OrderByDescending(s => s.StartTime);
break;
case "Type":
events = events.OrderBy(s => s.EventType.Type);
break;
case "type_desc":
events = events.OrderByDescending(s => s.EventType.Type);
break;
default:
events = events.OrderBy(s => s.EventID);
break;
}
// Number of records per page before paginating
int pageSize = 10;
// Return view with parameters
return(View(await PaginatedList <Event> .CreateAsync(events.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
public async Task <IActionResult> List(
string sortOrder,
string currentFilter,
string searchString,
int?page,
int?status)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = sortOrder == "name" ? "name_desc" : "name";
ViewData["DateSortParm"] = String.IsNullOrEmpty(sortOrder) ? "" : "date";
ViewData["Status"] = status;
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var countItem = (from s in _context.DaftarKajianVideo
where s.Status == published
select s).Count();
var countTrash = (from s in _context.DaftarKajianVideo
where s.Status == trash
select s).Count();
var kajianVideo = from s in _context.DaftarKajianVideo
.Include(ee => ee.Path)
.Include(ee => ee.Kategori)
select s;
if (!String.IsNullOrEmpty(searchString))
{
kajianVideo = kajianVideo.Where(s => s.Judul.Contains(searchString));
}
if (status == null)
{
kajianVideo = kajianVideo.Where(s => s.Status == published);
}
else if (status == trash)
{
kajianVideo = kajianVideo.Where(s => s.Status == trash);
}
switch (sortOrder)
{
case "name_desc":
kajianVideo = kajianVideo.OrderByDescending(s => s.Judul);
break;
case "name":
kajianVideo = kajianVideo.OrderBy(s => s.Judul);
break;
case "date":
kajianVideo = kajianVideo.OrderBy(s => s.Tanggal);
break;
default:
kajianVideo = kajianVideo.OrderByDescending(s => s.Tanggal);
break;
}
int pageSize = 20;
return(View(await PaginatedList <KajianVideo> .CreateAsync(kajianVideo.AsNoTracking(), page ?? 1, pageSize, countItem, countTrash)));
}
public async Task <IActionResult> Index(
string sortOrder,
string currentFilter,
string filter,
int pageNumber = 1,
int pageSize = 50)
{
#region 分页|筛选|排序
/*
* 名为 currentFilter 的 ViewData 元素为视图提供当前筛选器字符串。
* 此值必须包含在分页链接中，以便在分页过程中保持筛选器设置，并且在页面重新显示时必须将其还原到文本框中。
*
* 如果在分页过程中搜索字符串发生变化，则页面必须重置为 1，因为新的筛选器会导致显示不同的数据。
* 在文本框中输入值并按下“提交”按钮时，搜索字符串将被更改。 在这种情况下，filter参数不为 NULL。
*/
if (!string.IsNullOrWhiteSpace(filter))
{
pageNumber = 1;
}
else
{
filter = currentFilter;
}
ViewData["CurrentFilter"] = filter;
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date";
var datas = from m in _context.PveData
select m;
if (!string.IsNullOrEmpty(filter))
{
datas = datas.Where(s => s.VIN.Contains(filter));
}
switch (sortOrder)
{
case "name_desc":
datas = datas.OrderByDescending(s => s.SerialNum);
break;
case "Date":
datas = datas.OrderBy(s => s.ReleaseDate);
break;
case "date_desc":
datas = datas.OrderByDescending(s => s.ReleaseDate);
break;
default:
datas = datas.OrderBy(s => s.SerialNum);
break;
}
#endregion
return(View(await PaginatedList <PveData> .CreateAsync(datas, pageNumber, pageSize)));
}
public async Task <IActionResult> Keskin(DateTime Emre)
{
var student = _context.Students.Where(s => s.EnrollmentDate.Month == Emre.Month).AsNoTracking();
return(View("Index", await PaginatedList <Student> .CreateAsync(student, 1, 5)));
}
public async Task <IActionResult> Index(string sortString, string searchString, string currentFilter, int?page)
{
ViewData["SortByName"] = string.IsNullOrEmpty(sortString) ? "descendName" : "";
ViewData["SortBySchool"] = sortString == "school" ? "descendSchool" : "school";
ViewData["currentFilter"] = searchString;
ViewData["CurrentSort"] = sortString;
ViewData["CountAll"] = _guestsGuestRepository.GetAllGuests().Count();
ViewData["CountVisitors"] = _guestsGuestRepository
.GetAllGuests()
.Count(guest => guest.Member == "visitor");
ViewData["CountWorkers"] = _guestsGuestRepository
.GetAllGuests()
.Count(guest => guest.Member == "worker");
ViewData["CountMembers"] = _guestsGuestRepository
.GetAllGuests()
.Count(guest => guest.Member == "member");
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
IQueryable <Guest> guests = _guestsGuestRepository.GetAllGuests();
if (!string.IsNullOrEmpty(searchString))
{
guests = _guestsGuestRepository.GeneralSearch(searchString);
}
switch (sortString)
{
case "descendName":
guests = guests.OrderBy(guest => guest.FirstName);
break;
case "school":
guests = guests.OrderByDescending(guest => guest.School);
break;
default:
guests = guests.OrderBy(guest => guest.LastName);
break;
}
#region Guest ViewModel
//var guestVM = guests
// .Select(guest => new Guest()
// {
// Id = guest.Id,
// FirstName = guest.FirstName,
// LastName = guest.LastName,
// AgeGroup = guest.AgeGroup,
// Gender = guest.Gender,
// MaritalStatus = guest.MaritalStatus,
// Phone = guest.Phone,
// Email = guest.Email,
// School = guest.School,
// YearOfStudy = guest.YearOfStudy,
// Member = guest.Member,
// PrayerRequest = guest.PrayerRequest,
// });
#endregion
const int pageSize = 10;
return(View(await PaginatedList <Guest> .CreateAsync(guests.AsNoTracking(), page ?? 1, pageSize)));
}
public async Task OnGetAsync(
string currentType,
string searchType,
string sortOrder,
string currentFilter,
string searchString,
int?PageIndex)
{
CurrentSort = sortOrder;
DateSort = String.IsNullOrEmpty(sortOrder) ? "Date" : "";
IncoinSort = sortOrder == "Incoin" ? "incoin_desc" : "Incoin";
ViewSort = sortOrder == "View" ? "view_desc" : "View";
if (searchType != null || searchString != null)
{
PageIndex = 1;
}
else
{
searchString = currentFilter;
searchType = currentType;
}
CurrentFilter = searchString;
CurrentType = searchType;
IQueryable <Novel> NovelsIQ = from n in Context.Novels.Include("Profile")
select n;
if (!String.IsNullOrEmpty(searchString))
{
NovelsIQ = NovelsIQ.Where(n => n.Profile.UserName.Contains(searchString) ||
n.Title.Contains(searchString));
}
if (!String.IsNullOrEmpty(searchType))
{
switch (searchType)
{
case "Fantasy":
NovelsIQ = NovelsIQ.Where(n => n.Type == Models.NovelModel.Type.Fantasy);
break;
case "History":
NovelsIQ = NovelsIQ.Where(n => n.Type == Models.NovelModel.Type.History);
break;
case "Love":
NovelsIQ = NovelsIQ.Where(n => n.Type == Models.NovelModel.Type.Love);
break;
case "Real":
NovelsIQ = NovelsIQ.Where(n => n.Type == Models.NovelModel.Type.Real);
break;
case "Modern":
NovelsIQ = NovelsIQ.Where(n => n.Type == Models.NovelModel.Type.Modern);
break;
case "Science":
NovelsIQ = NovelsIQ.Where(n => n.Type == Models.NovelModel.Type.Science);
break;
case "Horror":
NovelsIQ = NovelsIQ.Where(n => n.Type == Models.NovelModel.Type.Horror);
break;
case "Detective":
NovelsIQ = NovelsIQ.Where(n => n.Type == Models.NovelModel.Type.Detective);
break;
default:
break;
}
}
switch (sortOrder)
{
case "Date":
NovelsIQ = NovelsIQ.OrderBy(s => s.UpdateTime);
break;
case "incoin_desc":
NovelsIQ = NovelsIQ.OrderByDescending(s => s.MonthlyCoins);
break;
case "Incoin":
NovelsIQ = NovelsIQ.OrderBy(s => s.MonthlyCoins);
break;
case "view_desc":
NovelsIQ = NovelsIQ.OrderByDescending(s => s.Views);
break;
case "View":
NovelsIQ = NovelsIQ.OrderBy(s => s.Views);
break;
default:
NovelsIQ = NovelsIQ.OrderByDescending(s => s.UpdateTime);
break;
}
var isAuthorized = User.IsInRole(Authorization.Novel.Novels.NovelManagersRole) ||
User.IsInRole(Authorization.Novel.Novels.NovelAdministratorsRole);
var currentUserId = UserManager.GetUserId(User);
// Only approved contacts are shown UNLESS you're authorized to see them
// or you are the owner.
if (!isAuthorized)
{
NovelsIQ = NovelsIQ.Where(a => a.Block == false ||
a.ProfileID == currentUserId);
}
int PageSize = 5;
Novels = await PaginatedList <Novel> .CreateAsync(
NovelsIQ.AsNoTracking(), PageIndex ?? 1, PageSize);
}
public async Task <PaginatedList <MembershipUser> > GetAll(int pageIndex, int pageSize)
{
var query = _context.MembershipUser.OrderBy(x => x.UserName);
return(await PaginatedList <MembershipUser> .CreateAsync(query.AsNoTracking(), pageIndex, pageSize));
}
// GET: Studs
/* public async Task<IActionResult> Index()
* {
* var fakultetContext = _context.Stud.Include(s => s.PbrRodNavigation).Include(s => s.PbrStanNavigation);
* return View(await fakultetContext.ToListAsync());
* } */
public async Task <IActionResult> Index(string sortOrder, string searchString, string currentFilter, int?pageNumber)
{
//var fakultetContext = _context.Stud.Include(s => s.PbrRodNavigation).Include(s => s.PbrStanNavigation);
//return View(await fakultetContext.ToListAsync());
ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["LastNameSortParm"] = sortOrder == "lastname_asc" ? "lastname_desc" : "lastname_asc";
ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date";
//ViewData["CurrentFilter"] = searchString;
ViewData["CurrentSort"] = sortOrder;
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var students = from s in _context.Stud
select s;
ViewData["Total"] = students.Count();
if (!String.IsNullOrEmpty(searchString))
{
students = students.Where(s => s.PrezStud.Contains(searchString) ||
s.ImeStud.Contains(searchString));
}
ViewData["Count"] = students.Count();
switch (sortOrder)
{
case "name_desc":
students = students.OrderByDescending(s => s.ImeStud).Include(s => s.PbrRodNavigation).Include(s => s.PbrStanNavigation);
break;
case "lastname_asc":
students = students.OrderBy(s => s.PrezStud).Include(s => s.PbrRodNavigation).Include(s => s.PbrStanNavigation);
break;
case "Date":
students = students.OrderBy(s => s.DatRodStud).Include(s => s.PbrRodNavigation).Include(s => s.PbrStanNavigation);
break;
case "date_desc":
students = students.OrderByDescending(s => s.DatRodStud).Include(s => s.PbrRodNavigation).Include(s => s.PbrStanNavigation);
break;
case "lastname_desc":
students = students.OrderByDescending(s => s.PrezStud).Include(s => s.PbrRodNavigation).Include(s => s.PbrStanNavigation);
break;
default:
students = students.OrderBy(s => s.ImeStud).Include(s => s.PbrRodNavigation).Include(s => s.PbrStanNavigation);
break;
}
//return View(await students.AsNoTracking().ToListAsync());
int pageSize = 20;
ViewData["CurrentPageNo"] = pageNumber;
ViewData["TotalPages"] = Math.Ceiling(students.Count() / (double)20);
return(View(await PaginatedList <Stud> .CreateAsync(students.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
// GET: Activities
public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?pageNumber)
{
//Get the current user
var user = await GetCurrentUserAsync();
ViewData["CurrentSort"] = sortOrder;
//Start date, County, City, Title, Finish date for the table sorts
ViewData["StartSortParm"] = String.IsNullOrEmpty(sortOrder) ? "start_desc" : "";
ViewData["CountySortParm"] = sortOrder == "county_desc" ? "county_asc" : "county_desc";
ViewData["CitySortParm"] = sortOrder == "city_desc" ? "city_asc" : "city_desc";
ViewData["TitleSortParm"] = sortOrder == "title_desc" ? "title_asc" : "title_desc";
ViewData["FinishSortParm"] = sortOrder == "finish_desc" ? "finish_asc" : "finish_desc";
//Search
ViewData["CurrentFilter"] = searchString;
//Get the activies for the logged-in user
var applicationDbContext = _context.Activity.Include(a => a.Location).Include(a => a.User)
.Where(a => a.UserId == user.Id);
//Paging
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
if (!String.IsNullOrEmpty(searchString))
{
applicationDbContext = applicationDbContext.Where(a => a.Location.County.Contains(searchString));
}
//Table sorts
switch (sortOrder)
{
case "county_asc":
applicationDbContext = applicationDbContext.OrderBy(g => g.Location.County);
break;
case "county_desc":
applicationDbContext = applicationDbContext.OrderByDescending(g => g.Location.County);
break;
case "city_asc":
applicationDbContext = applicationDbContext.OrderBy(g => g.City);
break;
case "city_desc":
applicationDbContext = applicationDbContext.OrderByDescending(g => g.City);
break;
case "title_asc":
applicationDbContext = applicationDbContext.OrderBy(g => g.Title);
break;
case "title_desc":
applicationDbContext = applicationDbContext.OrderByDescending(g => g.Title);
break;
case "start_desc":
applicationDbContext = applicationDbContext.OrderByDescending(g => g.StartTime);
break;
case "finish_asc":
applicationDbContext = applicationDbContext.OrderBy(g => g.EndTime);
break;
case "finish_desc":
applicationDbContext = applicationDbContext.OrderByDescending(g => g.EndTime);
break;
default:
applicationDbContext = applicationDbContext = applicationDbContext.OrderBy(g => g.StartTime);
break;
}
//Prints 5 activites per page
int pageSize = 5;
return(View(await PaginatedList <Activity> .CreateAsync(applicationDbContext.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
public async Task <IActionResult> ListadeCausas(
string sortOrder,
string currentFilter,
string searchString,
int?pageNumber)
{
#region -ListaUsuarios-
var user = await userManager.FindByNameAsync(User.Identity.Name);
var roles = await userManager.GetRolesAsync(user);
List <string> rolUsuario = new List <string>();
for (int i = 0; i < roles.Count; i++)
{
rolUsuario.Add(roles[i]);
}
ViewBag.RolesUsuario = rolUsuario;
#endregion
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date";
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var causa = from p in _context.Causapenal
select p;
if (!String.IsNullOrEmpty(searchString))
{
causa = causa.Where(p => p.CausaPenal.Contains(searchString) ||
p.Juez.Contains(searchString) ||
p.Cambio.Contains(searchString) ||
p.Distrito.Contains(searchString) ||
p.Cnpp.Contains(searchString));
}
switch (sortOrder)
{
case "name_desc":
causa = causa.OrderByDescending(p => p.CausaPenal);
break;
case "Date":
causa = causa.OrderBy(p => p.CausaPenal);
break;
case "date_desc":
causa = causa.OrderByDescending(p => p.CausaPenal);
break;
default:
causa = causa.OrderBy(p => p.CausaPenal);
break;
}
int pageSize = 10;
return(View(await PaginatedList <Causapenal> .CreateAsync(causa.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
public async Task <ActionResult <IEnumerable <User> > > Get(int?page = 1, int?pageSize = 10)
{
var paginatedList = await PaginatedList <User> .CreateAsync(_db.Users, page.Value, pageSize.Value);
return(paginatedList);
}
public async Task <IActionResult> ListLeaveType(string sortOrder,
string currentFilter,
string searchString,
int?pageNumber)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["LeaveTypeSortParm"] = String.IsNullOrEmpty(sortOrder) ? "LeaveType_desc" : "";
ViewData["noofdaySortParm"] = String.IsNullOrEmpty(sortOrder) ? "noofday_desc" : "";
ViewData["allcatoToAllSortParm"] = String.IsNullOrEmpty(sortOrder) ? "allcatoToAll_desc" : "";
ViewData["itispersonalSortParm"] = String.IsNullOrEmpty(sortOrder) ? "itispersonal_desc" : "";
ViewData["CurrentFilter"] = searchString;
if (searchString != null)
{
pageNumber = 1;
}
else
{
//searchString = "Enter some value";
searchString = currentFilter;
}
var allusers = from s in _context.leaveType select s;
if (!String.IsNullOrEmpty(searchString))
{
allusers = allusers.Where(s => s.LeaveType.Contains(searchString) ||
s.noofday.ToString().Contains(searchString)
);
}
switch (sortOrder)
{
case "LeaveType_desc":
allusers = allusers.OrderByDescending(s => s.LeaveType);
break;
case "noofday_desc":
allusers = allusers.OrderByDescending(s => s.noofday);
break;
case "allcatoToAll_desc":
allusers = allusers.OrderByDescending(s => s.allcatoToAll);
break;
case "itispersonal_desc":
allusers = allusers.OrderByDescending(s => s.itispersonal);
break;
default:
allusers = allusers.OrderBy(s => s.LeaveType);
break;
}
//return View(await allusers.AsNoTracking().ToListAsync());
int pageSize = 5;
return(View(await PaginatedList <leaveType> .CreateAsync(allusers.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
// GET: KondisiKendaraans
public async Task <IActionResult> Index(string ktsd, string searchString, string sortOrder, string currentFilter, int?pageNumber)
{
//buat list menyimpan ketersediaan
var ktsdList = new List <string>();
//Query mengambil data
var ktsdQuery = from d in _context.KondisiKendaraan orderby d.NamaKondisi select d.NamaKondisi;
ktsdList.AddRange(ktsdQuery.Distinct());
//untuk menampilkan di view
ViewBag.ktsd = new SelectList(ktsdList);
//panggil db context
var menu = from m in _context.KondisiKendaraan select m;
//untuk memilih dropdownlist ketersediaan
if (!string.IsNullOrEmpty(ktsd))
{
menu = menu.Where(x => x.NamaKondisi == ktsd);
}
//untuk search data
if (!string.IsNullOrEmpty(searchString))
{
menu = menu.Where(s => s.NamaKondisi.Contains(searchString));
}
//untuk sorting
ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
switch (sortOrder)
{
case "name_desc":
menu = menu.OrderByDescending(s => s.NamaKondisi);
break;
default:
menu = menu.OrderBy(s => s.NamaKondisi);
break;
}
//membuat pagedList
ViewData["CurrentSort"] = sortOrder;
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
//definisi jumlah data pada halaman
int pageSize = 5;
return(View(await PaginatedList <KondisiKendaraan> .CreateAsync(menu.AsNoTracking(), pageNumber ?? 1, pageSize)));
//return View(await menu.ToListAsync());
}
// ~/Invoice
public async Task <IActionResult> Index(string sortOrder, string searchString, string currentFilter, int?pageNumber)
{
// default sort in ascending order by Invoice CreatedDate
ViewData["CurrentSort"] = sortOrder;
ViewData["DateSortParam"] = string.IsNullOrEmpty(sortOrder) ? "date_desc" : "";
ViewData["IDParam"] = sortOrder == "InvoiceID" ? "ID_desc" : "InvoiceID";
ViewData["NameParam"] = sortOrder == "InvoiceName" ? "name_desc" : "InvoiceName";
ViewData["UserParam"] = sortOrder == "UserName" ? "user_desc" : "UserName";
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
var invoices = _context.Invoices
.Include(i => i.InvoiceLineitems)
.ThenInclude(i => i.Lineitem)
.AsNoTracking();
if (!string.IsNullOrEmpty(searchString)) // search by invoicename
{
invoices = invoices.Where(i => i.InvoiceName.Contains(searchString));
}
switch (sortOrder)
{
case "date_desc":
invoices = invoices.OrderByDescending(i => i.CreatedDate);
break;
case "InvoiceID":
invoices = invoices.OrderBy(i => i.InvoiceID);
break;
case "ID_desc":
invoices = invoices.OrderByDescending(i => i.InvoiceID);
break;
case "InvoiceName":
invoices = invoices.OrderBy(i => i.InvoiceName);
break;
case "name_desc":
invoices = invoices.OrderByDescending(i => i.InvoiceName);
break;
case "UserName":
invoices = invoices.OrderBy(i => i.UserName);
break;
case "user_desc":
invoices = invoices.OrderByDescending(i => i.UserName);
break;
default:
invoices = invoices.OrderBy(i => i.CreatedDate);
break;
}
return(View("Index", await PaginatedList <Invoice> .CreateAsync(invoices, pageNumber ?? 1, InvoiceListPageSize)));
}
public async Task <PaginatedList <User> > GetUsersAsync(int loggedUser, int pag, int perPag, string sortOrder, int statusFilter, string search)
{
var user = await _uow.UserRepository.GetAsync(loggedUser);
if (user.Role == RoleEnum.NORMAL)
{
throw new NotAllowedException("User");
}
var result = _uow.UserRepository.GetAll()
.Where(u => u.Role == RoleEnum.NORMAL)
.AsQueryable();
if (!string.IsNullOrWhiteSpace(search))
{
result = result.Where(
i => i.FullName.ToLower().Contains(search.ToLower()) ||
i.Email.ToLower().Contains(search.ToLower()) ||
i.Phone.ToLower().Contains(search.ToLower()));
}
// define status filter
if (statusFilter > -1)
{
result = result.Where(i => (StatusEnum)statusFilter == i.Status);
}
// define sort order
if (!string.IsNullOrWhiteSpace(sortOrder))
{
// sort order section
switch (sortOrder)
{
case "fullName_desc":
result = result.OrderByDescending(i => i.FullName);
break;
case "fullName_asc":
result = result.OrderBy(i => i.FullName);
break;
case "email_desc":
result = result.OrderByDescending(i => i.Email);
break;
case "email_asc":
result = result.OrderBy(i => i.Email);
break;
case "phone_desc":
result = result.OrderByDescending(i => i.Phone);
break;
case "phone_asc":
result = result.OrderBy(i => i.Phone);
break;
case "status_desc":
result = result.OrderByDescending(i => i.Status);
break;
case "status_asc":
result = result.OrderBy(i => i.Status);
break;
default:
break;
}
}
return(await PaginatedList <User> .CreateAsync(result, pag, perPag));
}
// GET: Genders
public async Task <IActionResult> Index(string ktsd, string sortOrder, string searchString, string currentFilter, int?pageNumber)
{
//buat list menyimpan ketersediaaan
var ktsdList = new List <string>();
//query mengambil data
var ktsdQuery = from d in _context.Gender orderby d.NamaGender select d.NamaGender;
ktsdList.AddRange(ktsdQuery.Distinct());
//untuk menampilkan di view
ViewBag.ktsd = new SelectList(ktsdList);
//panggil db context
var menu = from m in _context.Gender.Include(k => k.IdGender) select m;
//untuk memilih dropdownlist ketersediaan
if (!string.IsNullOrEmpty(ktsd))
{
menu = menu.Where(x => x.IdGender.ToString() == ktsd);
}
//untuk search data
if (!string.IsNullOrEmpty(searchString))
{
menu = menu.Where(s => s.NamaGender.Contains(searchString));
}
ViewData["CurrentSort"] = sortOrder;
if (searchString != null)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
ViewData["CurrentFilter"] = searchString;
int pageSize = 5;
//untuk sorting
ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date";
switch (sortOrder)
{
case "name_desc":
menu = menu.OrderByDescending(s => s.NamaGender);
break;
case "Date":
menu = menu.OrderBy(s => s.IdGender.ToString());
break;
case "date_desc":
menu = menu.OrderByDescending(s => s.IdGender.ToString());
break;
default: //nama ascending
menu = menu.OrderBy(s => s.NamaGender);
break;
}
return(View(await PaginatedList <Gender> .CreateAsync(menu.AsNoTracking(), pageNumber ?? 1, pageSize)));
}