public ActionResult Create(Project pro) { try { db.Projects.Add(pro); db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
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); }