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())); }