public ViewResult Index(PriceLookup price)
{
var connectionString = @"Data Source=" + Server.MapPath("App_Data/prices.s3db");
var priceDb = new PriceDb(connectionString);
if (ModelState.IsValid)
{
if (!string.IsNullOrEmpty(price.Upc))
{
priceDb.GetPriceByUpc(price);
if (price.Price == null)
{
ModelState.AddModelError("NotFound", "UPC not found");
}
}
else if (!string.IsNullOrEmpty(price.Isbn))
{
priceDb.GetPriceByIsbn(price);
if (price.Price == null)
{
ModelState.AddModelError("NotFound", "ISBN not found");
}
}
else
{
ModelState.AddModelError("Required", "You must enter a UPC or an ISBN");
}
}
return(View(price));
}
public decimal?GetPrice(PriceLookup price)
{
if (!string.IsNullOrEmpty(price.Upc))
{
var priceValue = _priceDb.GetPriceByUpc(price.Upc);
if (priceValue == null)
{
_modelState.AddModelError("NotFound", "UPC not found");
}
return(priceValue);
}
else if (!string.IsNullOrEmpty(price.Isbn))
{
var priceValue = _priceDb.GetPriceByIsbn(price.Isbn);
if (price.Price == null)
{
_modelState.AddModelError("NotFound", "ISBN not found");
}
return(priceValue);
}
else
{
_modelState.AddModelError("Required", "You must enter a UPC or an ISBN");
}
return(null);
}
public ViewResult Index(PriceLookup priceLookup)
{
if (ModelState.IsValid)
{
priceLookup.Price = _priceService.GetPrice(priceLookup);
}
return(View(priceLookup));
}
public ViewResult Index(PriceLookup price)
{
var connectionString = @"Data Source=" + Server.MapPath("App_Data/prices.s3db");
if (ModelState.IsValid)
{
if (!string.IsNullOrEmpty(price.Upc))
{
var sql = "SELECT Price FROM Prices WHERE Upc = @upc";
using (var conn = new SQLiteConnection(connectionString))
{
conn.Open();
var sqlCommand = new SQLiteCommand(sql, conn);
sqlCommand.Parameters.AddWithValue("upc", price.Upc);
var result = sqlCommand.ExecuteScalar();
if (result == null)
{
ModelState.AddModelError("NotFound", "UPC not found");
}
else
{
price.Price = (decimal)sqlCommand.ExecuteScalar();
}
conn.Close();
}
}
else if (!string.IsNullOrEmpty(price.Isbn))
{
var sql = "SELECT Price FROM Prices WHERE Isbn = @isbn";
using (var conn = new SQLiteConnection(connectionString))
{
conn.Open();
var sqlCommand = new SQLiteCommand(sql, conn);
sqlCommand.Parameters.AddWithValue("isbn", price.Isbn);
var result = sqlCommand.ExecuteScalar();
if (result == null)
{
ModelState.AddModelError("NotFound", "ISBN not found");
}
else
{
price.Price = (decimal)sqlCommand.ExecuteScalar();
}
conn.Close();
}
}
else
{
ModelState.AddModelError("Required", "You must enter a UPC or an ISBN");
}
}
return(View(price));
}
public ViewResult Index(PriceLookup price)
{
var connectionString = @"Data Source=" + Server.MapPath("App_Data/prices.s3db");
var priceDb = new PriceDb(connectionString);
var priceSvc = new PriceService(ModelState, priceDb);
if (ModelState.IsValid)
{
price.Price = priceSvc.GetPrice(price);
}
return(View(price));
}
public void GetPriceByIsbn(PriceLookup price)
{
var sql = "SELECT Price FROM Prices WHERE Isbn = @isbn";
using (var conn = new SQLiteConnection(_connectionString))
{
conn.Open();
var sqlCommand = new SQLiteCommand(sql, conn);
sqlCommand.Parameters.AddWithValue("isbn", price.Isbn);
var result = sqlCommand.ExecuteScalar();
if (result != null)
{
price.Price = (decimal)result;
}
conn.Close();
}
}
public decimal?GetPrice(PriceLookup priceLookup)
{
if (!string.IsNullOrEmpty(priceLookup.Upc))
{
if (_priceDb.DoesUpcExist(priceLookup.Upc))
{
return(_priceDb.GetPriceByUpc(priceLookup.Upc));
}
_modelState.AddModelError("NotFound", "UPC not found");
}
else if (!string.IsNullOrEmpty(priceLookup.Isbn))
{
if (_priceDb.DoesIsbnExist(priceLookup.Isbn))
{
return(_priceDb.GetPriceByIsbn(priceLookup.Isbn));
}
_modelState.AddModelError("NotFound", "ISBN not found");
}
else
{
_modelState.AddModelError("Required", "You must enter a UPC or an ISBN");
}
return(null);
}
