/// <summary>
/// GET /Contributors/Delete/Id
/// </summary>
/// <param name="id">Id of record to delete</param>
/// <param name="referer">The go-back url</param>
/// <param name="sortOrder">Page Sort Order</param>
/// <param name="searchString">Search String to limit results</param>
/// <param name="page">Page number of results, starting at 0</param>
/// <param name="pageSize">Page size to display</param>
/// <param name="currentFilter">Last search string while paging</param>
/// <returns>Task Action Result</returns>
public async Task <IActionResult> Delete(
long?id,
string state,
string sortOrder,
string searchString,
int?page,
int?pageSize,
string currentFilter = "")
{
// Manage call stack
var stack = new ServiceStack(state);
var referer = stack.GetReturnUrl();
var callstack = stack.AddReturnUrl(Request.Headers["referer"]);
// pass page configuration to Views
ViewData["referer"] = referer;
ViewData["callstack"] = callstack;
ViewData["CurrentSort"] = sortOrder;
ViewData["sortOrder"] = sortOrder;
ViewData["searchString"] = searchString;
ViewData["page"] = page;
ViewData["pageSize"] = pageSize;
ViewData["currentFilter"] = currentFilter;
if (id == null)
{
return(NotFound());
}
var result = await _context.Contributors.SingleOrDefaultAsync(m => m.Id == id);
if (result == null)
{
return(NotFound());
}
return(View(result));
}
/// <summary>
/// GET /Contributors/Create
/// </summary>
/// <param name="referer">The go-back url</param>
/// <param name="sortOrder">Page Sort Order</param>
/// <param name="searchString">Search String to limit results</param>
/// <param name="page">Page number of results, starting at 0</param>
/// <param name="pageSize">Page size to display</param>
/// <param name="currentFilter">Last search string while paging</param>
/// <returns>Task Action Result</returns>
public IActionResult Create(
string state,
string sortOrder,
string searchString,
int?page,
int?pageSize,
string currentFilter = "")
{
// Manage call stack
var stack = new ServiceStack(state);
var referer = stack.GetReturnUrl();
var callstack = stack.AddReturnUrl(Request.Headers["referer"]);
// pass page configuration to Views
ViewData["referer"] = referer;
ViewData["callstack"] = callstack;
ViewData["CurrentSort"] = sortOrder;
ViewData["sortOrder"] = sortOrder;
ViewData["searchString"] = searchString;
ViewData["page"] = page;
ViewData["pageSize"] = pageSize;
ViewData["currentFilter"] = currentFilter;
var newItem = new Contributor();
return(View(newItem));
}
/// <summary>
/// GET /Contributors/Index
/// </summary>
/// <param name="sortOrder">Page Sort Order</param>
/// <param name="searchString">Search String to limit results</param>
/// <param name="state">Serive State</param>
/// <param name="page">Page number of results, starting at 0</param>
/// <param name="pageSize">Page size to display</param>
/// <param name="currentFilter">Last search string while paging</param>
/// <returns>Task Action Result</returns>
public async Task <IActionResult> Index(
string sortOrder,
string searchString,
string state,
int?page,
int?pageSize,
string currentFilter = "")
{
// Manage call stack
var stack = new ServiceStack(state);
var referer = stack.GetReturnUrl();
var callstack = stack.AddReturnUrl(Request.Headers["referer"]);
// pass page configuration to Views
ViewData["referer"] = referer;
ViewData["callstack"] = callstack;
ViewData["CurrentSort"] = sortOrder;
// Set up column sorting
ViewData["IdSortParm"] = sortOrder == "Id" ? "Id_desc" : "Id";
ViewData["NameSortParm"] = sortOrder == "Name" ? "Name_desc" : "Name";
ViewData["DescriptionSortParm"] = sortOrder == "Description" ? "Description_desc" : "Description";
ViewData["DegreeSortParm"] = sortOrder == "Degree" ? "Degree_desc" : "Degree";
ViewData["AlmaMaterSortParm"] = sortOrder == "AlmaMater" ? "AlmaMater_desc" : "AlmaMater";
ViewData["EmailSortParm"] = sortOrder == "Email" ? "Email_desc" : "Email";
ViewData["EvaluationsSortParm"] = sortOrder == "Evaluations" ? "Evaluations_desc" : "Evaluations";
ViewData["PasswordSortParm"] = sortOrder == "Password" ? "Password_desc" : "Password";
ViewData["CommentsSortParm"] = sortOrder == "Comments" ? "Comments_desc" : "Comments";
ViewData["AuditEnteredSortParm"] = sortOrder == "AuditEntered" ? "AuditEntered_desc" : "AuditEntered";
ViewData["AuditEnteredBySortParm"] = sortOrder == "AuditEnteredBy" ? "AuditEnteredBy_desc" : "AuditEnteredBy";
ViewData["AuditUpdatedSortParm"] = sortOrder == "AuditUpdated" ? "AuditUpdated_desc" : "AuditUpdated";
ViewData["AuditUpdatedBySortParm"] = sortOrder == "AuditUpdatedBy" ? "AuditUpdatedBy_desc" : "AuditUpdatedBy";
// Reset page if there is a new search order
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
if (searchString == null)
{
searchString = "";
}
// Pass paging settings
ViewData["CurrentFilter"] = searchString;
ViewData["page"] = page;
ViewData["pageSize"] = pageSize;
int testId = -1;
int.TryParse(searchString, out testId);
// Get data from context
var results = _context.Contributors.Where(b => b.Id > -1 &&
(b.Id == testId ||
b.Id.ToString().Contains(searchString) ||
b.Name.Contains(searchString) ||
b.Description.Contains(searchString) ||
b.Degree.Contains(searchString) ||
b.AlmaMater.Contains(searchString) ||
b.Email.Contains(searchString) ||
b.Evaluations.ToString().Contains(searchString) ||
b.Password.Contains(searchString) ||
b.Comments.Contains(searchString) ||
b.AuditEnteredBy.ToString().Contains(searchString) ||
b.AuditUpdatedBy.ToString().Contains(searchString)
)).Take(1000);
//Set up column sorting
switch (sortOrder)
{
case "Id": results = results.OrderBy(a => a.Id); break;
case "Id_desc": results = results.OrderByDescending(a => a.Id); break;
case "Name": results = results.OrderBy(a => a.Name); break;
case "Name_desc": results = results.OrderByDescending(a => a.Name); break;
case "Description": results = results.OrderBy(a => a.Description); break;
case "Description_desc": results = results.OrderByDescending(a => a.Description); break;
case "Degree": results = results.OrderBy(a => a.Degree); break;
case "Degree_desc": results = results.OrderByDescending(a => a.Degree); break;
case "AlmaMater": results = results.OrderBy(a => a.AlmaMater); break;
case "AlmaMater_desc": results = results.OrderByDescending(a => a.AlmaMater); break;
case "Email": results = results.OrderBy(a => a.Email); break;
case "Email_desc": results = results.OrderByDescending(a => a.Email); break;
case "Evaluations": results = results.OrderBy(a => a.Evaluations); break;
case "Evaluations_desc": results = results.OrderByDescending(a => a.Evaluations); break;
case "Password": results = results.OrderBy(a => a.Password); break;
case "Password_desc": results = results.OrderByDescending(a => a.Password); break;
case "Comments": results = results.OrderBy(a => a.Comments); break;
case "Comments_desc": results = results.OrderByDescending(a => a.Comments); break;
case "AuditEntered": results = results.OrderBy(a => a.AuditEntered); break;
case "AuditEntered_desc": results = results.OrderByDescending(a => a.AuditEntered); break;
case "AuditEnteredBy": results = results.OrderBy(a => a.AuditEnteredBy); break;
case "AuditEnteredBy_desc": results = results.OrderByDescending(a => a.AuditEnteredBy); break;
case "AuditUpdated": results = results.OrderBy(a => a.AuditUpdated); break;
case "AuditUpdated_desc": results = results.OrderByDescending(a => a.AuditUpdated); break;
case "AuditUpdatedBy": results = results.OrderBy(a => a.AuditUpdatedBy); break;
case "AuditUpdatedBy_desc": results = results.OrderByDescending(a => a.AuditUpdatedBy); break;
default: results = results.OrderBy(s => s.Id); break;
}
return(View(await PaginatedList <Contributor> .CreateAsync(results.AsNoTracking(), page ?? 1, pageSize ?? 10)));
}