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 OnGetAsync()
{
if (Request.Cookies["pagesize"] != null)
{
PageSize = int.Parse(Request.Cookies["pagesize"]);
}
string[] filterOptions =
{
"Prawda",
"Fałsz",
};
completeFilter = new SelectList(filterOptions);
declaredFilter = new SelectList(filterOptions);
var query = _db.VTMagazyn.AsNoTracking().Include(c => c.Technical).AsNoTracking().AsQueryable();
char separator = ',';
if (Filter_LiteraRodziny != null)
{
var options = Filter_LiteraRodziny.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.Technical.LiterRodziny));
}
if (Filter_KodWiazki != null)
{
var options = Filter_KodWiazki.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.Technical.KodWiazki));
}
if (Filter_NumerKompletu != null)
{
var options = Filter_NumerKompletu.Split(separator).Select(c => int.Parse(c.Trim()));
query = query.Where(c => options.Contains(c.NumerKompletu));
}
if (Filter_SztukiZeskanowane != null)
{
var options = Filter_SztukiZeskanowane.Split(separator).Select(c => int.Parse(c.Trim()));
query = query.Where(c => options.Contains(c.SztukiZeskanowane));
}
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_KodCiety != null)
{
var options = Filter_KodCiety.Split(separator).Select(c => c.Trim());
foreach (var option in options)
{
query = query.Where(c => c.KodCiety.Contains(option));
}
}
if (Filter_Pracownik != null)
{
var options = Filter_Pracownik.Split(separator).Select(c => c.Trim());
foreach (var option in options)
{
query = query.Where(c => c.Pracownik.Contains(option));
}
}
if (Filter_DokDostawy != null)
{
var options = Filter_DokDostawy.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.DokDostawy));
}
if (Filter_DokDostawyDopis != null)
{
var options = Filter_DokDostawy.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.DostawaDopis));
}
if (Filter_DataUtworzeniaFrom != DateTime.MinValue && Filter_DataUtworzeniaTo != DateTime.MinValue)
{
query = query.Where(c => c.DataUtworzenia.Date >= Filter_DataUtworzeniaFrom.Date && c.DataUtworzenia.Date <= Filter_DataUtworzeniaTo.Date);
}
else if (Filter_DataUtworzeniaFrom != DateTime.MinValue)
{
query = query.Where(c => c.DataUtworzenia.Date == Filter_DataUtworzeniaFrom);
}
if (Filter_DataDostawyFrom != DateTime.MinValue && Filter_DataDostawyTo != DateTime.MinValue)
{
query = query.Where(c => c.DataDostawy.Date >= Filter_DataDostawyFrom.Date && c.DataDostawy.Date <= Filter_DataDostawyTo.Date);
}
else if (Filter_DataDostawyFrom != DateTime.MinValue)
{
query = query.Where(c => c.DataDostawy.Date == Filter_DataDostawyFrom);
}
if (Filter_DataDopisuFrom != DateTime.MinValue && Filter_DataDopisuTo != DateTime.MinValue)
{
query = query.Where(c => c.DataDopisu != null && ((DateTime)c.DataDopisu).Date >= Filter_DataDopisuFrom && ((DateTime)c.DataDopisu).Date <= Filter_DataDopisuTo);
}
else if (Filter_DataDopisuFrom != DateTime.MinValue)
{
query = query.Where(c => c.DataDopisu != null && ((DateTime)c.DataDopisu).Date == Filter_DataDopisuFrom);
}
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_Komplet != null)
{
if (Filter_Komplet == "Prawda")
{
query = query.Where(c => c.Komplet == true);
}
else if (Filter_Komplet == "Fałsz")
{
query = query.Where(c => c.Komplet == false);
}
}
if (Filter_Deklaracja != null)
{
if (Filter_Deklaracja == "Prawda")
{
query = query.Where(c => c.Deklarowany == true);
}
else if (Filter_Deklaracja == "Fałsz")
{
query = query.Where(c => c.Deklarowany == false);
}
}
string[] sortings =
{
"Sztuki Zeskanowane",
"Pracownik",
"Dok. Dostawy",
"Data Utworzenia",
"Data Dostawy",
"Data Dopisu",
"Deklarowany",
"Uwagi"
};
availableSortings = new SelectList(sortings);
if (SortColumn != null)
{
switch (SortColumn)
{
case "Sztuki Zeskanowane":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.SztukiZeskanowane);
}
else
{
query = query.OrderBy(c => c.SztukiZeskanowane);
}
break;
case "Pracownik":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.Pracownik);
}
else
{
query = query.OrderBy(c => c.Pracownik);
}
break;
case "Dok. Dostawy":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.DokDostawy);
}
else
{
query = query.OrderBy(c => c.DokDostawy);
}
break;
case "Data Utworzenia":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.DataUtworzenia);
}
else
{
query = query.OrderBy(c => c.DataUtworzenia);
}
break;
case "Data Dostawy":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.DataDostawy);
}
else
{
query = query.OrderBy(c => c.DataDostawy);
}
break;
case "Data Dopisu":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.DataDopisu);
}
else
{
query = query.OrderBy(c => c.DataDopisu);
}
break;
case "Deklarowany":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.Deklarowany);
}
else
{
query = query.OrderBy(c => c.Deklarowany);
}
break;
case "Uwagi":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.Uwagi);
}
else
{
query = query.OrderBy(c => c.Uwagi);
}
break;
}
}
int count = query.Count();
Data = await PaginatedList <Data.Tables.VTMagazyn> .CreateAsync(query, CurrentPage, PageSize);
return;
}
public async Task OnGetAsync()
{
if (Request.Cookies["pagesize"] != null)
{
PageSize = int.Parse(Request.Cookies["pagesize"]);
}
var query = _db.Dostawa.IgnoreQueryFilters().Include(c => c.Technical).AsNoTracking().AsQueryable();
char separator = ',';
if (Filter_Kod != null)
{
var options = Filter_Kod.Split(separator).Select(c => c.Replace("PLC", "").Trim());
query = query.Where(c => options.Contains(c.Kod.Replace("PLC", "")));
}
if (Filter_Wiazka != null)
{
var options = Filter_Wiazka.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.Technical.Wiazka));
}
if (Filter_LiteraRodziny != null)
{
var options = Filter_LiteraRodziny.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.Technical.LiterRodziny));
}
if (Filter_KodWiazki != null)
{
var options = Filter_KodWiazki.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.Technical.KodWiazki));
}
if (Filter_Ilosc != null)
{
query = query.Where(c => c.Ilosc == Filter_Ilosc);
}
if (Filter_DataFrom != DateTime.MinValue && Filter_DataTo != DateTime.MinValue)
{
query = query.Where(c => c.Data.Date >= Filter_DataFrom.Date && c.Data.Date <= Filter_DataTo.Date);
}
else if (Filter_DataFrom != DateTime.MinValue)
{
query = query.Where(c => c.Data.Date == Filter_DataFrom.Date);
}
if (Filter_DateCreated != DateTime.MinValue)
{
query = query.Where(c => c.DataUtworzenia.Date == Filter_DateCreated.Date);
}
if (Filter_Uwagi != null)
{
var options = Filter_Uwagi.Split(separator).Select(c => c.Trim());
query = query.Where(c => options.Contains(c.Uwagi));
}
string[] sortings =
{
"Kod",
"Ilość",
"Data",
"Data utworzenia"
};
availableSortings = new SelectList(sortings);
if (SortColumn != null)
{
switch (SortColumn)
{
case "Kod":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.Kod);
}
else
{
query = query.OrderBy(c => c.Kod);
}
break;
case "Ilość":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.Ilosc);
}
else
{
query = query.OrderBy(c => c.Ilosc);
}
break;
case "Data":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.Data);
}
else
{
query = query.OrderBy(c => c.Data);
}
break;
case "Data utworzenia":
if (OrderDescent)
{
query = query.OrderByDescending(c => c.DataUtworzenia);
}
else
{
query = query.OrderBy(c => c.DataUtworzenia);
}
break;
}
}
Data = await PaginatedList <Data.Tables.Dostawa> .CreateAsync(query, CurrentPage, PageSize);
return;
}