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