private void SendRequestCompletedToSupplier(Request request)
{
if (request.SupplierId.HasValue == false)
{
return;
}
var vendorUrl = _configuration.GetValue <string>("VendorWebsite:BaseUrl");
var requestEditPath = string.Format(_configuration.GetValue <string>("VendorWebsite:RequestEdit"), request.Id);
var subject = $"Vandivier Product Request Complete: {request.RequestDescription}";
var users = _dbReadService.GetAllRecordsAsync <Entity.Models.User>(x => x.SupplierId == request.SupplierId.Value).Result;
foreach (var user in users)
{
var body = $"Request {request.RequestDescription} has been completed! <br /><br />" +
$"View the request <a href='{vendorUrl}{requestEditPath}'>here</a> <br /><br />" +
$"Thanks, <br /> Vandivier Management";
if (user.EmailAddress != null)
{
Helper.Send(_configuration, subject, body, new List <string>()
{
user.EmailAddress
});
}
}
}
public async Task <IActionResult> Index()
{
_dbReadService.IncludeEntityNavigation <Category>();
_dbReadService.IncludeEntityNavigation <Product, ContainerSizeType>();
_dbReadService.IncludeEntityNavigation <Product, ContainerType>();
var products = await _dbReadService.GetAllRecordsAsync <Product>();
products.Reverse();
return(View(products));
}
public async Task <IActionResult> Index(int?id)
{
ViewData["ProductId"] = id;
_dbReadService.IncludeEntityNavigation <Supplier>();
_dbReadService.IncludeEntityNavigation <Product>();
var product = await _dbReadService.GetSingleRecordAsync <Product>(s => s.Id.Equals(id));
ViewData["ProductName"] = product.ProductName;
var packages = await _dbReadService.GetAllRecordsAsync <ProductPackageType>(s => s.ProductId.Equals(id));
packages.Reverse();
return(View(packages));
}
public async Task <IActionResult> Index(string search)
{
if (search != null)
{
Regex rgx = new Regex("[^a-zA-Z0-9 -]");
search = rgx.Replace(search, "").ToUpper();
}
ViewData["FilterParam"] = search;
UserDto.UserId = User.Identity.Name;
_dbReadService.IncludeEntityNavigation <Product>();
_dbReadService.IncludeEntityNavigation <Store>();
_dbReadService.IncludeEntityNavigation <RequestType>();
_dbReadService.IncludeEntityNavigation <StatusType>();
_dbReadService.IncludeEntityNavigation <Supplier>();
var requests = await _dbReadService.GetAllRecordsAsync <Request>();
requests.Reverse();
var requestsEnumerable = requests.AsEnumerable();
if (!String.IsNullOrEmpty(search))
{
requestsEnumerable = requests.Where(s => s.RequestDescription != null && s.RequestDescription.ToUpper().Contains(search)
|| s.StatusType.StatusTypeName != null && s.StatusType.StatusTypeName.ToUpper().Contains(search)
|| s.RequestType.RequestTypeName != null && s.RequestType.RequestTypeName.ToUpper().Contains(search)
|| s.Store.StoreName != null && s.Store.StoreName.ToUpper().Contains(search)
|| s.ProductId != null && s.Product.ProductName.ToUpper().Contains(search)
|| s.Id.ToString().StartsWith(search)
|| s.Id.ToString().Contains(search)
|| s.CreatedBy != null && s.CreatedBy.ToUpper().Contains(search));
}
RequestDto.RequestId = null;
RequestDto.RequestDescription = null;
return(View(requestsEnumerable.ToList()));
}
public async Task <IActionResult> Index()
{
RequestDto.RequestDescription = string.Empty;
var suppliers = await _dbReadService.GetAllRecordsAsync <Supplier>();
return(View(suppliers.OrderBy(s => s.SupplierName)));
}
public async Task <IActionResult> Index(int?id)
{
ViewData["PackageTypeId"] = id;
var package = await _dbReadService.GetSingleRecordAsync <ProductPackageType>(s => s.Id.Equals(id));
ViewData["PackageName"] = package.AlternateProductName;
ViewData["AltUpcCode"] = package.AlternateProductUpccode;
if (package.AlternateProductPrice != null)
{
ViewData["PackagePrice"] = Math.Round((decimal)package.AlternateProductPrice, 2);
}
var product = await _dbReadService.GetSingleRecordAsync <Product>(p => p.Id.Equals(package.ProductId));
ViewData["ProductName"] = product.ProductName;
if (product.ProductPrice != null)
{
ViewData["ProductPrice"] = Math.Round((decimal)product.ProductPrice, 2);
}
_dbReadService.IncludeEntityNavigation <ProductStoreSpecific, Store>();
var productStoreSpecific = await _dbReadService.GetAllRecordsAsync <ProductStoreSpecific>(s => s.PackageTypeId.Equals(id));
productStoreSpecific.Reverse();
return(View(productStoreSpecific));
}
public async Task <IActionResult> Index()
{
RequestDto.RequestDescription = string.Empty;
var containerSizeTypes = await _dbReadService.GetAllRecordsAsync <ContainerSizeType>();
return(View(containerSizeTypes.OrderBy(s => s.ContainerSizeTypeName)));
}
public async Task <IActionResult> Index(int?id)
{
_dbReadService.IncludeEntityNavigation <Request>();
List <Note> notes = null;
if (id > 0 || id != null)
{
notes = await _dbReadService.GetAllRecordsAsync <Note>(s => s.RequestId.Equals(id));
}
else
{
notes = await _dbReadService.GetAllRecordsAsync <Note>();
}
notes.Reverse();
return(View(notes));
}
public async Task <IActionResult> Index()
{
RequestDto.RequestDescription = string.Empty;
_dbReadService.IncludeEntityNavigation <Supplier>();
var users = await _dbReadService.GetAllRecordsAsync <User>();
return(View(users.OrderBy(s => s.LastName)));
}
public async Task <IActionResult> Index(string search, bool showFamilyNotes)
{
if (!_signInManager.IsSignedIn(User))
{
return(RedirectToPage("/Account/Login", new { Area = "Identity" }));
}
if (search != null)
{
Regex rgx = new Regex("[^a-zA-Z0-9 -]");
search = rgx.Replace(search, "").ToUpper();
}
ViewData["FilterParam"] = search;
List <Note> notes = new List <Note>();
if (showFamilyNotes)
{
notes = await _dbRead.GetAllRecordsAsync <Note>(n => !n.ShareToFam.Equals(null) && n.ShareToFam.Equals(true) && n.UserProfile.FamilyId == UserData.FamilyId);
}
else
{
notes = await _dbRead.GetAllRecordsAsync <Note>(n => n.UserProfileId == UserData.UserProfileId);
}
var notesEnumerable = notes.AsEnumerable();
if (!String.IsNullOrEmpty(search))
{
notesEnumerable = notes.Where(s => s.Text != null && s.Text.ToUpper().Contains(search)
|| s.Title != null && s.Title.ToUpper().Contains(search));
}
return(View(notesEnumerable.ToList().OrderByDescending(n => n.Id)));
}
public async Task <IActionResult> Index(int?Id)
{
if (Id != null)
{
noteId = (int)Id;
}
_dbRead.IncludeEntityNavigation <Note>();
var noteList = await _dbRead.GetAllRecordsAsync <NoteListItem>(n => n.NoteId.Equals(Id));
var originalNote = await _dbRead.GetSingleRecordAsync <Note>(n => n.Id.Equals(Id));
ViewData["NoteTitle"] = !string.IsNullOrEmpty(originalNote.Title);
ViewData["NoteText"] = !string.IsNullOrEmpty(originalNote.Text);
ViewData["NoteId"] = originalNote.Id;
return(View(noteList));
}
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var family = await _dbRead.GetSingleRecordAsync <Family>(f => f.Id.Equals(id));
if (family == null)
{
return(NotFound());
}
UserData.FamilyMembers = await _dbRead.GetAllRecordsAsync <UserProfile>(m => !m.FamilyId.Equals(null) && m.FamilyId.Equals(UserData.FamilyId));
UserData.FamName = family.FamilyLastName;
return(View(family));
}
public async Task <IActionResult> Index(string sort, string search)
{
if (search != null)
{
Regex rgx = new Regex("[^a-zA-Z0-9 -]");
search = rgx.Replace(search, "").ToUpper();
}
// Intercept sort data
ViewData["RequestIdParam"] = sort == "RequestId" ? "requestId_desc" : "RequestId";
ViewData["RequestDescriptionParam"] = sort == "RequestDescription" ? "requestDescription_desc" : "RequestDescription";
ViewData["StoreNameParam"] = sort == "StoreName" ? "store_desc" : "StoreName";
ViewData["StatusTypeParam"] = sort == "StatusTypeName" ? "statusTypeName_desc" : "StatusTypeName";
ViewData["RequestTypeParam"] = sort == "RequestTypeParam" ? "requestType_desc" : "RequestTypeParam";
ViewData["ProductNameParam"] = sort == "ProductNameParam" ? "productName_desc" : "ProductNameParam";
ViewData["SupplierNameParam"] = sort == "SupplierNameParam" ? "supplierName_desc" : "SupplierNameParam";
ViewData["RequestDateParam"] = sort == "RequestDateParam" ? "requestDate_desc" : "RequestDateParam";
ViewData["RequesterNameParam"] = sort == "RequesterNameParam" ? "requesterName_desc" : "RequesterNameParam";
ViewData["CreatedOnParam"] = sort == "CreatedOnParam" ? "createdOn_desc" : "CreatedOnParam";
ViewData["CreatedByParam"] = sort == "CreatedByParam" ? "createdBy_desc" : "CreatedByParam";
// Intercept search term
ViewData["FilterParam"] = search;
_dbReadService.IncludeEntityNavigation <Product>();
_dbReadService.IncludeEntityNavigation <Store>();
_dbReadService.IncludeEntityNavigation <RequestType>();
_dbReadService.IncludeEntityNavigation <StatusType>();
_dbReadService.IncludeEntityNavigation <Supplier>();
var requests = await _dbReadService.GetAllRecordsAsync <Request>();
requests.Reverse();
var requestEnumerable = requests.AsEnumerable();
// Execute the search term filter
if (!String.IsNullOrEmpty(search))
{
requestEnumerable = requests.Where(s =>
s.RequestDescription != null && s.RequestDescription.ToUpper().Contains(search)
|| s.StatusType.StatusTypeName != null && s.StatusType.StatusTypeName.ToUpper().Contains(search)
|| s.RequestType.RequestTypeName != null && s.RequestType.RequestTypeName.ToUpper().Contains(search)
|| s.Store.StoreName != null && s.Store.StoreName.ToUpper().Contains(search)
|| s.Product.ProductName != null && s.Product.ProductName.ToUpper().Contains(search)
|| s.Supplier.SupplierName != null && s.Supplier.SupplierName.ToUpper().Contains(search)
|| s.Id.ToString().StartsWith(search)
|| s.UserId != null && s.UserId.ToUpper().Contains(search));
}
switch (sort)
{
case "requestId_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.OrderByDescending(s => s.Id.ToString()));
}
break;
case "RequestId":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.OrderBy(s => s.Id.ToString()));
}
break;
case "requestDescription_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.RequestDescription != null).OrderByDescending(s => s.RequestDescription.ToString()));
}
break;
case "RequestDescription":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.RequestDescription != null).OrderBy(s => s.RequestDescription.ToString()));
}
break;
case "store_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.Store.StoreName != null).OrderByDescending(s => s.Store.StoreName.ToString()));
}
break;
case "StoreName":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.Store.StoreName != null).OrderBy(s => s.Store.StoreName.ToString()));
}
break;
case "statusTypeName_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.StatusType.StatusTypeName != null).OrderByDescending(s => s.StatusType.StatusTypeName.ToString()));
}
break;
case "StatusTypeName":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.StatusType.StatusTypeName != null).OrderBy(s => s.StatusType.StatusTypeName.ToString()));
}
break;
case "requestType_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.RequestType.RequestTypeName != null).OrderByDescending(s => s.RequestType.RequestTypeName.ToString()));
}
break;
case "RequestTypeParam":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.RequestType.RequestTypeName != null).OrderBy(s => s.RequestType.RequestTypeName.ToString()));
}
break;
case "productName_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.Product.ProductName != null).OrderByDescending(s => s.Product.ProductName.ToString()));
}
break;
case "ProductNameParam":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.Product.ProductName != null).OrderBy(s => s.Product.ProductName.ToString()));
}
break;
case "supplierName_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.Supplier.SupplierName != null).OrderByDescending(s => s.Supplier.ToString()));
}
break;
case "SupplierNameParam":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.Supplier != null).OrderBy(s => s.Supplier.ToString()));
}
break;
case "requestDate_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.CreatedOn != null).OrderByDescending(s => s.CreatedOn.ToString()));
}
break;
case "RequestDateParam":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.CreatedOn != null).OrderBy(s => s.CreatedOn.ToString()));
}
break;
case "requesterName_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.CreatedBy != null).OrderByDescending(s => s.CreatedBy.ToString()));
}
break;
case "RequesterNameParam":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.CreatedBy != null).OrderBy(s => s.CreatedBy.ToString()));
}
break;
case "createdOn_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.CreatedOn != null).OrderByDescending(s => s.CreatedOn.ToString()));
}
break;
case "CreatedOnParam":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.CreatedOn != null).OrderBy(s => s.CreatedOn.ToString()));
}
break;
case "createdBy_desc":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.CreatedBy != null).OrderByDescending(s => s.CreatedBy.ToString()));
}
break;
case "CreatedByParam":
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.Where(s => s.CreatedBy != null).OrderBy(s => s.CreatedBy.ToString()));
}
break;
default:
if (requestEnumerable != null)
{
requestEnumerable =
new List <Request>(requestEnumerable.OrderByDescending(s => s.CreatedOn));
}
break;
}
return(View(requestEnumerable));
}
public async Task <IActionResult> Index(string sort, string search)
{
RequestDto.RequestDescription = string.Empty;
if (search != null)
{
Regex rgx = new Regex("[^a-zA-Z0-9 -]");
search = rgx.Replace(search, "").ToUpper();
}
// Intercept sort data
ViewData["RequestIdParam"] = sort == "RequestId" ? "requestId_desc" : "RequestId";
ViewData["RequestDescriptionParam"] = sort == "RequestDescription" ? "requestDescription_desc" : "RequestDescription";
ViewData["ChangeNoteParam"] = sort == "ChangeNote" ? "changeNote_desc" : "ChangeNote";
ViewData["StoreNameParam"] = sort == "StoreName" ? "store_desc" : "StoreName";
ViewData["StatusTypeParam"] = sort == "StatusTypeName" ? "statusTypeName_desc" : "StatusTypeName";
ViewData["RequestTypeParam"] = sort == "RequestTypeParam" ? "requestType_desc" : "RequestTypeParam";
ViewData["ProductNameParam"] = sort == "ProductNameParam" ? "productName_desc" : "ProductNameParam";
ViewData["SupplierNameParam"] = sort == "SupplierNameParam" ? "supplierName_desc" : "SupplierNameParam";
ViewData["RequestDateParam"] = sort == "RequestDateParam" ? "requestDate_desc" : "RequestDateParam";
ViewData["RequesterNameParam"] = sort == "RequesterNameParam" ? "requesterName_desc" : "RequesterNameParam";
ViewData["CreatedOnParam"] = sort == "CreatedOnParam" ? "createdOn_desc" : "CreatedOnParam";
ViewData["CreatedByParam"] = sort == "CreatedByParam" ? "createdBy_desc" : "CreatedByParam";
ViewData["RequestLogIdParam"] = sort == "RequestLogIdParam" ? "requestLogId_Desc" : "RequestLogIdParam";
// Intercept search term
ViewData["FilterParam"] = search;
// Map log data to view model with readable names
IEnumerable <RequestLog> logs = await _dbReadService.GetAllRecordsAsync <RequestLog>();
List <RequestLogFull> requestLogFullList = new List <RequestLogFull>();
foreach (var item in logs)
{
RequestLogFull requestLogFull = null;
requestLogFull = new RequestLogFull();
requestLogFull.RequestId = item.RequestId;
requestLogFull.ProductId = item.ProductId;
requestLogFull.ChangeNote = item.ChangeNote;
requestLogFull.RequestDescription = item.RequestDescription;
requestLogFull.RequestTypeId = item.RequestTypeId;
requestLogFull.StatusTypeId = item.StatusTypeId;
requestLogFull.StoreId = item.StoreId;
requestLogFull.SupplierId = item.SupplierId;
requestLogFull.UserId = item.UserId;
requestLogFull.OriginalCreatedOnDate = item.OriginalCreatedOnDate;
requestLogFull.OriginalCreatedByUser = item.OriginalCreatedByUser;
requestLogFull.CreatedOn = item.CreatedOn;
requestLogFull.CreatedBy = item.CreatedBy;
requestLogFull.Id = item.Id;
var tempProduct = await _dbReadService.GetSingleRecordAsync <Product>(p => item.ProductId != null && p.Id.Equals(item.ProductId));
if (tempProduct?.ProductName != null)
{
requestLogFull.ProductName = tempProduct.ProductName;
}
var tempSupplier = await _dbReadService.GetSingleRecordAsync <Supplier>(p => item.SupplierId != null && p.Id.Equals(item.SupplierId));
if (tempSupplier?.SupplierName != null)
{
requestLogFull.SupplierName = tempSupplier.SupplierName;
}
var tempStore = await _dbReadService.GetSingleRecordAsync <Store>(p => item.StoreId != null && p.Id.Equals(item.StoreId));
if (tempStore?.StoreName != null)
{
requestLogFull.StoreName = tempStore.StoreName;
}
var tempStatus = await _dbReadService.GetSingleRecordAsync <StatusType>(p => item.StatusTypeId != null && p.Id.Equals(item.StatusTypeId));
if (tempStatus?.StatusTypeName != null)
{
requestLogFull.StatusTypeName = tempStatus.StatusTypeName;
}
var tempRequestType = await _dbReadService.GetSingleRecordAsync <RequestType>(p => p.Id.Equals(item.RequestTypeId));
if (tempRequestType?.RequestTypeName != null)
{
requestLogFull.RequestTypeName = tempRequestType.RequestTypeName;
}
requestLogFullList.Add(requestLogFull);
}
var requestFullEnumerable = requestLogFullList.AsEnumerable();
// Execute the search term filter
if (!String.IsNullOrEmpty(search))
{
requestFullEnumerable = requestLogFullList.Where(s => s.RequestDescription != null && s.RequestDescription.ToUpper().Contains(search) ||
s.ChangeNote != null && s.ChangeNote.ToUpper().Contains(search)
|| s.StatusTypeName != null && s.StatusTypeName.ToUpper().Contains(search)
|| s.RequestTypeName != null && s.RequestTypeName.ToUpper().Contains(search)
|| s.SupplierName != null && s.SupplierName.ToUpper().Contains(search)
|| s.StoreName != null && s.StoreName.ToUpper().Contains(search)
|| s.ProductName != null && s.ProductName.ToUpper().Contains(search)
|| s.UserId != null && s.UserId.ToUpper().Contains(search)
|| s.RequestId != null && s.RequestId.ToString().Contains(search)
|| s.CreatedBy != null && s.CreatedBy.ToUpper().Contains(search)
|| s.OriginalCreatedByUser != null && s.OriginalCreatedByUser.ToUpper().Contains(search).Equals(null)
|| s.StatusTypeName != null && s.StatusTypeName.ToUpper().Contains(search));
}
// Execute sorting columns
switch (sort)
{
case "requestId_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.RequestId != null).OrderByDescending(s => s.RequestId.ToString()));
}
break;
case "RequestId":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.RequestId != null).OrderBy(s => s.RequestId.ToString()));
}
break;
case "requestDescription_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.RequestDescription != null).OrderByDescending(s => s.RequestDescription.ToString()));
}
break;
case "RequestDescription":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.RequestDescription != null).OrderBy(s => s.RequestDescription.ToString()));
}
break;
case "changeNote_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.ChangeNote != null).OrderByDescending(s => s.ChangeNote.ToString()));
}
break;
case "ChangeNote":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.ChangeNote != null).OrderBy(s => s.ChangeNote.ToString()));
}
break;
case "store_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.StoreName != null).OrderByDescending(s => s.StoreName.ToString()));
}
break;
case "StoreName":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.StoreName != null).OrderBy(s => s.StoreName.ToString()));
}
break;
case "statusTypeName_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.StatusTypeName != null).OrderByDescending(s => s.StatusTypeName.ToString()));
}
break;
case "StatusTypeName":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.StatusTypeName != null).OrderBy(s => s.StatusTypeName.ToString()));
}
break;
case "requestType_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.RequestTypeName != null).OrderByDescending(s => s.RequestTypeName.ToString()));
}
break;
case "RequestTypeParam":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.RequestTypeName != null).OrderBy(s => s.RequestTypeName.ToString()));
}
break;
case "productName_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.ProductName != null).OrderByDescending(s => s.ProductName.ToString()));
}
break;
case "ProductNameParam":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.ProductName != null).OrderBy(s => s.ProductName.ToString()));
}
break;
case "supplierName_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.SupplierName != null).OrderByDescending(s => s.SupplierName.ToString()));
}
break;
case "SupplierNameParam":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.SupplierName != null).OrderBy(s => s.SupplierName.ToString()));
}
break;
case "requestDate_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.OriginalCreatedOnDate != null).OrderByDescending(s => s.OriginalCreatedOnDate.ToString()));
}
break;
case "RequestDateParam":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.OriginalCreatedOnDate != null).OrderBy(s => s.OriginalCreatedOnDate.ToString()));
}
break;
case "requesterName_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.OriginalCreatedByUser != null).OrderByDescending(s => s.OriginalCreatedByUser.ToString()));
}
break;
case "RequesterNameParam":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.OriginalCreatedByUser != null).OrderBy(s => s.OriginalCreatedByUser.ToString()));
}
break;
case "createdOn_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.CreatedOn != null).OrderByDescending(s => s.CreatedOn.ToString()));
}
break;
case "CreatedOnParam":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.CreatedOn != null).OrderBy(s => s.CreatedOn.ToString()));
}
break;
case "createdBy_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.CreatedBy != null).OrderByDescending(s => s.CreatedBy.ToString()));
}
break;
case "CreatedByParam":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.CreatedBy != null).OrderBy(s => s.CreatedBy.ToString()));
}
break;
case "requestLogId_desc":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.RequestId != null).OrderByDescending(s => s.Id.ToString()));
}
break;
case "RequestLogIdParam":
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.RequestId != null).OrderBy(s => int.Parse(s.Id.ToString())));
}
break;
default:
if (requestFullEnumerable != null)
{
requestFullEnumerable =
new List <RequestLogFull>(requestFullEnumerable.Where(s => s.CreatedOn != null).OrderByDescending(s => s.CreatedOn.ToString()));
}
break;
}
return(View(requestFullEnumerable.ToList()));
}
public async Task <IActionResult> Index(string search)
{
_dbReadService.IncludeEntityNavigation <Product>();
_dbReadService.IncludeEntityNavigation <Store>();
_dbReadService.IncludeEntityNavigation <RequestType>();
_dbReadService.IncludeEntityNavigation <StatusType>();
_dbReadService.IncludeEntityNavigation <Supplier>();
if (search != null)
{
Regex rgx = new Regex("[^a-zA-Z0-9 -]");
search = rgx.Replace(search, "").ToUpper();
}
ViewData["FilterParam"] = search;
// Restrict by SupplierId
var b2CUserAuthId = User.FindFirst(ClaimTypes.NameIdentifier).Value;
var userToEnsure = await _dbReadService.GetSingleRecordAsync <User>(s => s.AuthId.Equals(b2CUserAuthId));
UserDto.UserId = userToEnsure.EmailAddress;
List <Request> requests = new List <Request>();
if (userToEnsure != null)
{
RequestDto.SupplierId = userToEnsure.SupplierId;
}
if (RequestDto.SupplierId != 0)
{
ViewData["SupplierData"] = RequestDto.SupplierId;
requests = await _dbReadService.GetAllRecordsAsync <Request>(s => s.SupplierId.Equals(RequestDto.SupplierId));
requests.Reverse();
}
else
{
TempData["notifyUser"] = "******";
ViewData["SupplierData"] = null;
}
RequestDto.RequestId = null;
RequestDto.RequestDescription = null;
var requestsEnumerable = requests.AsEnumerable();
if (!String.IsNullOrEmpty(search))
{
requestsEnumerable = requests.Where(s => s.RequestDescription != null && s.RequestDescription.ToUpper().Contains(search)
|| s.StatusType.StatusTypeName != null && s.StatusType.StatusTypeName.ToUpper().Contains(search)
|| s.RequestType.RequestTypeName != null && s.RequestType.RequestTypeName.ToUpper().Contains(search)
|| s.Store.StoreName != null && s.Store.StoreName.ToUpper().Contains(search)
|| s.ProductId != null && s.Product.ProductName.ToUpper().Contains(search)
|| s.Id.ToString().StartsWith(search)
|| s.Id.ToString().Contains(search)
|| s.CreatedBy != null && s.CreatedBy.ToUpper().Contains(search));
}
return(View(requestsEnumerable.ToList()));
}
