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;
_dbReadService.IncludeEntityNavigation <Supplier>();
var users = await _dbReadService.GetAllRecordsAsync <User>();
return(View(users.OrderBy(s => s.LastName)));
}
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> 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> CreateProduct(int id, [Bind("Id,ProductName,ProductDescription,Upccode,ProductLocation,ProductCost,ProductPrice,SuggestedPrice,PackageSize,PackageType,ContainerSizeTypeId,ContainerTypeId,OrderWeek,CategoryId,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy,UnitsPerCase,SupplierData")] Product product)
{
var requestId = id;
product.Id = 0;
if (ModelState.IsValid)
{
if (User != null)
{
var userFullName = User.Claims.FirstOrDefault(x => x.Type == $"emails").Value;
product.CreatedBy = userFullName;
}
product.CreatedOn = DateTime.Now;
_dbWriteService.Add(product);
await _dbWriteService.SaveChangesAsync();
_dbReadService.IncludeEntityNavigation <Request>();
var request = await _dbReadService.GetSingleRecordAsync <Request>(s => s.Id.Equals(requestId));
request.ProductId = product.Id;
_dbWriteService.Update(request);
await _dbWriteService.SaveChangesAsync();
if (request.StoreId != null)
{
RequestEmail requestEmail = new RequestEmail(_configuration, _dbReadService);
requestEmail.SendRequestToStoreManager(request);
}
RequestLogHelper logHelper = new RequestLogHelper();
logHelper.LogRequestChange(request, _context, RequestLogConstants.RequestAddByVendor);
}
ViewData["CategoryId"] = new SelectList(_context.Category, "Id", "CategoryName", product.CategoryId);
ViewData["OrderWeeks"] = new SelectList(new Dictionary <int, int>()
{
{ 1, 1 }, { 2, 2 }, { 3, 3 }, { 4, 4 }, { 5, 5 }, { 6, 6 }, { 7, 7 }, { 8, 8 }, { 9, 9 }
}, "Key", "Value", product.OrderWeek);
return(RedirectToAction("Details", "Requests", new { id = requestId }));
}
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
_dbRead.IncludeEntityNavigation <Family>();
var userProfile = await _dbRead.GetSingleRecordAsync <UserProfile>(u => u.Id.Equals(id));
if (userProfile == null)
{
return(NotFound());
}
return(View(userProfile));
}
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 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()
{
_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(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(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()));
}
