public ActionResult Order(int code, OrderFromWareHouseModel model)
{
model.StoreId = int.Parse(Request.Params["store-id"]);
if (!ModelState.IsValid)
{
return(View("Order", model));
}
using (var connection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString))
{
connection.Open();
using (var command = new NpgsqlCommand($"SELECT narachka({model.StoreId}, {model.Code}, {model.Quantity})", connection))
{
try
{
NpgsqlDataReader reader = command.ExecuteReader();
}
catch (Exception)
{
ModelState.AddModelError(String.Empty, $"Unexpected error has occured");
return(View("Order", model));
}
}
return(View("OrderPlaced"));
}
}
public ActionResult Order(int code)
{
using (var connection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString))
{
connection.Open();
using (var command = new NpgsqlCommand($@"SELECT store.*, stock.cnt as stock FROM store, stock
WHERE store.id = stock.store_id
AND stock.product_code = {code}
ORDER BY store.name ASC", connection))
{
NpgsqlDataReader reader = command.ExecuteReader();
List <StoreStockDbo> stores = ReflectionHelper.MapDataToBusinessEntityCollection <StoreStockDbo>(reader);
OrderFromWareHouseModel model = new OrderFromWareHouseModel
{
Code = code,
Stores = stores,
Quantity = 1
};
return(View(model));
}
}
}
