// GET: RecipiesOfTheDay
public ActionResult _Index()
{
BrewDayDBEntities db = new BrewDayDBEntities();
//recupera dal model parametri che mi servono per la spUpdateQuantityIngredients
var userID = User.Identity.GetUserId();
var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
if (User.Identity.GetUserName().Equals(ConfigurationManager.AppSettings["SuperUser"]))
{
//lancia la spRecuperaRecipiesOfTheDayAll
var command = new SqlCommand("spRecuperaRecipiesOfTheDayAll", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
else
{
//lancia la spUpdateQuantityIngredients con parametro userID
var command = new SqlCommand("spRecuperaRecipiesOfTheDay", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@userId", userID);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
var query = "select ID,[Description], [batchSize],Rate from RecipiesofTheDay where batchSize>1";
IEnumerable <RecipiesOfTheDay> data = db.Database.SqlQuery <RecipiesOfTheDay>(query);
return(PartialView(data.ToList()));
}
// GET: IngredientToSubstract
public ActionResult _Index(int?recipiesID, int batchSize)
{
BrewDayDBEntities db = new BrewDayDBEntities();
string query = "select r.ID as IdRecipie, i.ID as IdIngredient, i.[Description], i.UnitMeasure, i.Quantity, ir.AbsolutQuantity, " + batchSize + " as [Batchsize], (ir.AbsolutQuantity * " + batchSize + ") as QuantityToSubstract, (i.Quantity - (ir.AbsolutQuantity * " + batchSize + ")) as QuantityAfterBrew, i.Threshold" +
" from Ingredients as i inner join" +
" IngredientRecipe ir on i.ID = ir.IdIngredients inner join" +
" Recipies as r on ir.IdRecipes = r.ID " +
" where r.ID =" + recipiesID +
" group by r.ID, i.ID, i.[Description], i.UnitMeasure, i.Quantity, ir.AbsolutQuantity, i.Threshold";
IEnumerable <IngredientToSubstract> data = db.Database.SqlQuery <IngredientToSubstract>(query);
return(PartialView(data.ToList()));
}
