public List <Result> GetSearchResults(string searchId) { using (ProDBContext db = new ProDBContext()) { var results = db.Results.Where(r => r.SearchId == searchId).ToList(); return(results); } }
public IActionResult Searches() { using (ProDBContext db = new ProDBContext()) { ViewBag.searches = db.Searches.OrderBy(s => s.Date).ToList(); return(View()); } }
private List <SearchRequest> GetFailedReqests(string searchId) { using (ProDBContext db = new ProDBContext()) { return(db.Results.Where(r => r.SearchId == searchId && (r.IsSuccessful == false)) .Select(r => new SearchRequest { Id = r.PartId, Brand = r.Brand, OriginalPrice = r.OriginalPrice }).ToList()); }; }
public AccountController(ProDBContext context) { _context = context; hasher = new PasswordHasher(); }
private bool SaveSearchResults(SearchResult searchResult, string searchId, bool updateExistingResults) { bool isSucessful; using (ProDBContext db = new ProDBContext()) { try { if (updateExistingResults) { var searchToUpdate = db.Searches.Where(s => s.SearchId == searchId).SingleOrDefault(); searchToUpdate.Date = DateTime.Now; var resultToUpdate = db.Results .Where(r => r.SearchId == searchId && r.PartId == searchResult.Id && r.Brand == searchResult.Brand) .SingleOrDefault(); resultToUpdate.FirstPrice = searchResult.FirstPrice; resultToUpdate.SecondPrice = searchResult.SecondPrice; resultToUpdate.IsSuccessful = searchResult.IsSuccessful; db.SaveChanges(); isSucessful = true; } else { var result = new Result(); if (!db.Searches.Any(s => s.SearchId == searchId)) { Search search = new Search { SearchId = searchId, Date = DateTime.Now }; db.Searches.AddAsync(search); result = new Result { PartId = searchResult.Id, Brand = searchResult.Brand, OriginalPrice = searchResult.OriginalPrice, FirstPrice = searchResult.FirstPrice, SecondPrice = searchResult.SecondPrice, SearchId = search.SearchId, IsSuccessful = searchResult.IsSuccessful }; } else { result = new Result { PartId = searchResult.Id, Brand = searchResult.Brand, OriginalPrice = searchResult.OriginalPrice, FirstPrice = searchResult.FirstPrice, SecondPrice = searchResult.SecondPrice, SearchId = searchId, IsSuccessful = searchResult.IsSuccessful }; } db.Results.AddAsync(result); db.SaveChanges(); isSucessful = true; } } catch (Exception e) { isSucessful = false; } } return(isSucessful); }