public List <Pizza> SelectAllPizzasShortInfo()
{
List <Pizza> pizzas = new List <Pizza>();
using (var connection = new SqlConnection(_connectionString))
using (var command = connection.CreateCommand())
{
connection.Open();
command.CommandText = "select distinct Name, Filling from Pizzas";
var reader = command.ExecuteReader();
while (reader.Read())
{
string[] fillingInString = reader["FillingList"].ToString().Split(' ');
Ingridients[] filling = new Ingridients[fillingInString.Count()];
for (int i = 0; i < fillingInString.Count(); i++)
{
Enum.TryParse(fillingInString[i], out filling[i]);
}
pizzas.Add(new Pizza
{
Name = reader["Name"].ToString(),
Filling = filling,
Cost = 0,
Size = 0
});
}
}
return(pizzas);
}
protected void IngredientsGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Insert")
{
DataTable dt = new DataTable();
DataTable newIngredient = new DataTable();
dt = (DataTable)ViewState["Ingredients"];
if (dt.Rows.Count < 15)
{
Ingridients ing = new Ingridients();
ing.RecipeId = Convert.ToInt32(recipeGrid.DataKey.Value.ToString());
ing.name = ((TextBox)IngredientsGrid.FooterRow.FindControl("txtName")).Text;
ing.Quantity = Convert.ToInt32(((TextBox)IngredientsGrid.FooterRow.FindControl("txtQuantity")).Text);
ing.measureUnit = ((TextBox)IngredientsGrid.FooterRow.FindControl("txtMeasureUnits")).Text;
DataRow newIng = dt.NewRow();
newIng[1] = ing.name;
newIng[2] = ing.Quantity;
newIng[3] = ing.measureUnit;
newIng[4] = ing.RecipeId;
dt.Rows.Add(newIng);
ViewState["Ingredients"] = dt;
ViewState["NewIngredient"] = ing;
IngredientsGrid.DataSource = dt;
IngredientsGrid.DataBind();
}
else
{
update.Text = "Can't add more than 15 Ingredients ";
}
}
}
public Italian()
{
Ingridients.Add("cheese");
Ingridients.Add("tomatos");
Ingridients.Add("olives");
Ingridients.Add("meat");
}
public int insertIngredients(Ingridients ingredient)
{
int error = 0;
conn = new OracleConnection(conString);
try
{
OracleCommand cmd1 = new OracleCommand();
cmd1.Connection = conn;
cmd1.CommandText = "PROC_INSERTINGREDIENTS";
cmd1.CommandType = System.Data.CommandType.StoredProcedure;
cmd1.Parameters.Add("RID", OracleDbType.Int32, System.Data.ParameterDirection.Input).Value = ingredient.RecipeId;
cmd1.Parameters.Add("iNAME", OracleDbType.Varchar2, System.Data.ParameterDirection.Input).Value = ingredient.name.TrimStart().TrimEnd();
cmd1.Parameters.Add("iQUANTITY", OracleDbType.Double, System.Data.ParameterDirection.Input).Value = ingredient.Quantity;
cmd1.Parameters.Add("iMEASUREUNITS", OracleDbType.Varchar2, System.Data.ParameterDirection.Input).Value = ingredient.measureUnit.TrimStart().TrimEnd();
conn.Open();
cmd1.ExecuteNonQuery();
}
catch (Exception e)
{
error = 1;
}
finally
{
conn.Close();
}
return(error);
}
public ActionResult DeleteConfirmed(int id)
{
Ingridients ingridients = db.Ingridients.Find(id);
db.Ingridients.Remove(ingridients);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void UpdateRecipe(Recipe recipe)
{
recipe.Name = Name;
recipe.TimeToCook = new TimeSpan(TimeToCookHrs, TimeToCookMins, 0);
recipe.Method = Method;
recipe.IsVegetarian = IsVegetarian;
recipe.IsVegan = IsVegan;
recipe.Ingridients = Ingridients?.Select(x => x.ToIngridient()).ToList();
}
public ActionResult Edit([Bind(Include = "Ingridient_Id,IngridientName,Receipt_Id")] Ingridients ingridients)
{
if (ModelState.IsValid)
{
db.Entry(ingridients).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Receipt_Id = new SelectList(db.Receipts, "Receipt_Id", "ReceiptName", ingridients.Receipt_Id);
return(View(ingridients));
}
public ActionResult Create([Bind(Include = "Ingridient_Id,IngridientName,Receipt_Id,Quantity")] Ingridients ingridients)
{
if (ModelState.IsValid)
{
db.Ingridients.Add(ingridients);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Receipt_Id = new SelectList(db.Receipts, "Receipt_Id", "ReceiptName", ingridients.Receipt_Id);
return(View(ingridients));
}
// GET: Ingridients/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ingridients ingridients = db.Ingridients.Find(id);
if (ingridients == null)
{
return(HttpNotFound());
}
return(View(ingridients));
}
// GET: Ingridients/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ingridients ingridients = db.Ingridients.Find(id);
if (ingridients == null)
{
return(HttpNotFound());
}
ViewBag.Receipt_Id = new SelectList(db.Receipts, "Receipt_Id", "ReceiptName", ingridients.Receipt_Id);
return(View(ingridients));
}
public IEnumerable<Dishes> GetAllDishes()
{
List<Ingridients> skladniki = new List<Ingridients>();
var salata = new Ingridients();
var cebula = new Ingridients();
skladniki.Add(salata);
skladniki.Add(cebula);
var dania = new List<Dishes>
{
new Dishes{Id=0,Name="salatka",Calories=100,Ingridients=skladniki},
new Dishes{Id=1,Name="salatka2",Calories=1200,Ingridients=skladniki},
new Dishes{Id=2,Name="salatka3",Calories=1100,Ingridients=skladniki}
};
return dania;
}
protected void btnSaveChanges_Click(object sender, EventArgs e)
{
DataTable recipe = (DataTable)ViewState["Recipe"];
DataTable ingredients = (DataTable)ViewState["Ingredients"];
Ingridients objIn = (Ingridients)ViewState["NewIngredient"];
int error1 = _objrepositry.updateRecipe(recipe, ingredients);
//int error2 = _objrepositry.insertIngredients(objIn);
if (error1 == 0)
{
update.Text = "Recipe Updated Successfully";
}
else
{
update.Text = "Error Occurred";
}
}
public PizzaDecorator(Pizza pizza, params IIngridient[] addedIngrids)
{
_pizza = pizza;
Ingridients = _pizza.Ingridients.GetRange(0, _pizza.Ingridients.Count);
foreach (var ingrid in addedIngrids)
{
_ingridient = ingrid;
if (_ingridient.GetType() == typeof(CakeLayer))
{
throw new ArgumentException("Нельзя добавить второй корж");
}
Ingridients.Add(_ingridient.GetType());
if (Ingridients.Count % 7 == 0)
{
discount *= 0.9;
}
_addedCost += _ingridient.GetCost();
_addedDescription += $" {_ingridient.GetDescription()} + ";
}
}
public Carbonara()
{
Ingridients.Add("cheese");
Ingridients.Add("tomatos");
}
public Pepperoni()
{
Ingridients.Add("cheese");
Ingridients.Add("tomatos");
Ingridients.Add("meat");
}
public Ester()
{
Ingridients.AddRange(EsterIngridients);
}
public FourCheese()
{
Ingridients.AddRange(FourCheeseIngridients);
}
public int GetTotalCalories()
{
return(Ingridients.Sum(n => n.Calories));
}
public Neapolitana()
{
Ingridients.AddRange(NeapolitanaIngridients);
}
public Margarita()
{
Ingridients.Add("cheese");
Ingridients.Add("tomatos");
Ingridients.Add("olives");
}
public List <Ingridient> getIngridients()
{
return(Ingridients.Select(n => n).ToList <Ingridient>());
}
public static async void Ingr_Start_Parsing(ToolStripStatusLabel toolStripStatusLabel1)
{
#region переменные
List <string> gg = new List <string>();
Baza db = new Baza();
AngleSharp.Parser.Html.HtmlParser sss = new AngleSharp.Parser.Html.HtmlParser();
IConfiguration config = Configuration.Default.WithDefaultLoader();
IBrowsingContext context = BrowsingContext.New(config);
int k = 0;
List <Ingridients> ingridients_List = new List <Ingridients>();
#endregion
for (int i = Start_blydo_number; i > End_blydo_number; i--)
{
try
{
var document = sss.Parse(DownloadPage("https://e-dostavka.by/recipe/" + i + ".html"));
var file = document.QuerySelectorAll("li.not_in_cart a");
for (int iss = 0; iss < file.Length; iss++)
{
gg.Add(file[iss].GetAttribute("href"));
}
toolStripStatusLabel1.Text = "Обновление:" + "загрузка страниц " + (i - 1);
}
catch (Exception) { continue; }
}
toolStripStatusLabel1.Text = "Обновление:" + "удаление старых записей";
Ingridients[] ing = new Ingridients[gg.Count];
foreach (var item in db.Ingridients)
{
db.Ingridients.Attach(item);
db.Ingridients.Remove(item);
}
IEnumerable <string> sorted_links = gg.GroupBy(f => f).Select(d => d.First());
foreach (var cgus in sorted_links)
{
try
{
var document = sss.Parse(DownloadPage(cgus));
ingridients_List.Add(new Ingridients());
ingridients_List[k].Ing_Name = document.QuerySelector("img.retina_redy").GetAttribute("alt");
ingridients_List[k].ING_Price = double.Parse(Convert_Price(document.QuerySelector("div.price").TextContent));
ingridients_List[k].Ing_Weight = document.QuerySelector("small.kg").TextContent;
ingridients_List[k].Ing_Id = k;
k++;
}
catch (Exception) { continue; }
}
IEnumerable <Ingridients> sortedList = ingridients_List.GroupBy(f => f.Ing_Name).Select(d => d.First());
k = 0;
toolStripStatusLabel1.Text = "Обновление:" + "формирование новых данных ";
foreach (var sorted in sortedList)
{
try
{
if (sorted.Ing_Name != null)
{
ing[k] = new Ingridients();
ing[k].Ing_Name = sorted.Ing_Name;
ing[k].ING_Price = sorted.ING_Price;
ing[k].Ing_Weight = sorted.Ing_Weight;
ing[k].Ing_Id = k;
db.Ingridients.Add(ing[k]);
k++;
}
}
catch (Exception) { continue; }
}
toolStripStatusLabel1.Text = "Обновление:" + "сохранение базы";
db.SaveChanges();
}
public void Add(Vegetable vegetable)
{
Ingridients.Add(vegetable);
}
public void InsertIngridients(Ingridients input)
{
_context.Ingridients.Add(input);
_context.SaveChanges();
}
