// GET: Akcje public ActionResult DodajDania() { ChickDbContext db = new ChickDbContext(); List <Skladnik> skladniki = db.Skladniki.ToList(); foreach (Skladnik s in skladniki) { Danie danie = new Danie { Nazwa = s.NazwaSkladnika, WagaPorcji = 100 }; db.Dania.Add(danie); db.SaveChanges(); Receptura receptura = new Receptura { Skladnik = s.ID, Danie = danie.ID, Waga = 100 }; db.Receptury.Add(receptura); db.SaveChanges(); } return(null); }
public AddProductPage() { this.Title = "Stwórz produkt"; var db = new SQLiteConnection(_dbPath); _recipePicker = new Picker() { ItemsSource = db.Table <Receptura>().OrderBy(x => x.Name).ToList(), Title = "Wybierz pierwszą recepturę", TitleColor = Color.Gold }; _countEntry = new Entry() { Keyboard = Keyboard.Text, Placeholder = "Ilość pierwszego produktu" }; stackLayout.Children.Add(_recipePicker); stackLayout.Children.Add(_countEntry); Receptura receptura = (Receptura)_recipePicker.SelectedItem; _saveButton = new Button(); _saveButton.Text = "Dodaj produkt"; _saveButton.Clicked += _saveButton_Clicked; stackLayout.Children.Add(_saveButton); Content = stackLayout; }
public ActionResult DeleteConfirmed(int id) { Receptura receptura = db.Receptury.Find(id); db.Receptury.Remove(receptura); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(RecepturaViewModel recepturaView) { Receptura receptura = CompleteRecepturaInfo(recepturaView); db.Entry(receptura).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); return(View(receptura)); }
public ActionResult Create(RecepturaViewModel recepturaView) { Receptura receptura = CompleteRecepturaInfo(recepturaView); db.Receptury.Add(receptura); db.SaveChanges(); return(RedirectToAction("Index")); return(View(recepturaView)); }
// GET: Receptura/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Receptura receptura = db.Receptury.Find(id); if (receptura == null) { return(HttpNotFound()); } return(View(receptura)); }
private Receptura CompleteRecepturaInfo(RecepturaViewModel recepturaView) { Receptura receptura = recepturaView.Receptura; var user = userManager.FindById(User.Identity.GetUserId()); Styl styl = db.Style.FirstOrDefault(s => s.StylID == recepturaView.Styl.StylID); receptura.Styl = styl; Drozdze drozdze = db.Drozdze.FirstOrDefault(d => d.DrozdzeID == recepturaView.Drozdze.DrozdzeID); receptura.Drozdze = drozdze; Slod slod = db.Slody.FirstOrDefault(s => s.SlodID == recepturaView.Slod.SlodID); SkladnikSlodu skladnikSlodu = new SkladnikSlodu() { Slod = slod, Ilosc = recepturaView.IloscSlodu }; List <SkladnikSlodu> skladnikiSlodu = new List <SkladnikSlodu>(); skladnikiSlodu.Add(skladnikSlodu); receptura.SkladnikiSlodu = skladnikiSlodu; Chmiel chmiel = db.Chmiele.FirstOrDefault(c => c.ChmielID == recepturaView.Chmiel.ChmielID); //SkladnikChmielu chmielReceptury = receptura.SkladnikiChmielu.FirstOrDefault(c => c.ChmielID == chmiel.ChmielID); //if(chmielReceptury==null) //{ SkladnikChmielu skladnikChmielu = new SkladnikChmielu() { Chmiel = chmiel, Ilosc = recepturaView.IloscChmielu }; List <SkladnikChmielu> skladnikiChmielu = new List <SkladnikChmielu>(); skladnikiChmielu.Add(skladnikChmielu); receptura.SkladnikiChmielu = skladnikiChmielu; //} Przerwa przerwa = db.Przerwy.FirstOrDefault(p => p.PrzerwaID == recepturaView.Przerwa.PrzerwaID); List <Przerwa> przerwy = new List <Przerwa>(); przerwy.Add(przerwa); receptura.Przerwy = przerwy; receptura.Uzytkownik = user; return(receptura); }
// GET: Receptura/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RecepturaViewModel recepturaView = PopulateSelectList(); Receptura receptura = db.Receptury.Find(id); recepturaView.Receptura = receptura; if (receptura == null) { return(HttpNotFound()); } return(View(recepturaView)); }
public static void Delete(Receptura receptura) { KalkulatorDietyDatabase DataSet = new KalkulatorDietyDatabase(); String XML_Location = @"DataBase.xml"; DataSet.ReadXml(XML_Location); if (DataSet.Receptury.Rows.Count > 0) { for (int i = 0; i < DataSet.Receptury.Rows.Count; i++) { if (DataSet.Receptury.Rows[i]["Nazwa receptury"].ToString() == receptura.nazwa && DataSet.Receptury.Rows[i]["Skład receptury"].ToString() == receptura.sklad) { DataSet.Receptury.Rows[i].Delete(); } } } DataSet.WriteXml(XML_Location); }
private void _listView_ItemSelected(object sender, SelectedItemChangedEventArgs e) { _receptura = (Receptura)e.SelectedItem; _nameEntry.Text = _receptura.Name; _countEntry.Text = Convert.ToString(_receptura.Surowce); }
private void _listView_ItemSelected(object sender, SelectedItemChangedEventArgs e) { _receptura = (Receptura)e.SelectedItem; }
private async void _saveButton_Clicked(object sender, EventArgs e) { try { Receptura receptura = (Receptura)_recipePicker.SelectedItem; string surowiec1 = receptura.Surowce.Replace(")", ""); string surowiec2 = surowiec1.Replace("(", ""); string[] surowce = surowiec2.Split(' '); var db = new SQLiteConnection(_dbPath); db.CreateTable <Produkt>(); var maxPK = db.Table <Produkt>().OrderByDescending(c => c.Id).FirstOrDefault(); Produkt produkt = new Produkt() { Id = (maxPK == null ? 1 : maxPK.Id + 1), Name = receptura.Name, Count = Convert.ToDouble(_countEntry.Text) }; string resource1String = surowce[0]; var Resource1 = db.Table <Surowiec>().Where(c => c.Name == resource1String).FirstOrDefault(); var resource1Previous = Resource1.Count; if (IsEnoughResource(Resource1, produkt, Convert.ToDouble(surowce[1]))) { Resource1.Count -= (produkt.Count * Convert.ToDouble(surowce[1])); db.Update(Resource1); db.Insert(produkt); } else { double iloscBrakuje = -(Resource1.Count - (produkt.Count * Convert.ToDouble(surowce[1]))); string brakujeSurowca = "Brakuje " + Resource1.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); } string resource2String = surowce[2]; var Resource2 = db.Table <Surowiec>().Where(c => c.Name == resource2String).FirstOrDefault(); var resource2Previous = Resource2.Count; if (IsEnoughResource(Resource2, produkt, Convert.ToDouble(surowce[3]))) { Resource2.Count -= (produkt.Count * Convert.ToDouble(surowce[3])); db.Update(Resource2); } else { double iloscBrakuje = -(Resource2.Count - (produkt.Count * Convert.ToDouble(surowce[3]))); string brakujeSurowca = "Brakuje " + Resource2.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); db.Delete(produkt); } string resource3String = surowce[4]; var Resource3 = db.Table <Surowiec>().Where(c => c.Name == resource3String).FirstOrDefault(); var resource3Previous = Resource3.Count; if (IsEnoughResource(Resource3, produkt, Convert.ToDouble(surowce[5]))) { Resource3.Count -= (produkt.Count * Convert.ToDouble(surowce[5])); db.Update(Resource3); } else { double iloscBrakuje = -(Resource3.Count - (produkt.Count * Convert.ToDouble(surowce[5]))); string brakujeSurowca = "Brakuje " + Resource3.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); db.Delete(produkt); } string resource4String = surowce[6]; var Resource4 = db.Table <Surowiec>().Where(c => c.Name == resource4String).FirstOrDefault(); var resource4Previous = Resource4.Count; if (IsEnoughResource(Resource4, produkt, Convert.ToDouble(surowce[7]))) { Resource4.Count -= (produkt.Count * Convert.ToDouble(surowce[7])); db.Update(Resource4); } else { double iloscBrakuje = -(Resource4.Count - (produkt.Count * Convert.ToDouble(surowce[7]))); string brakujeSurowca = "Brakuje " + Resource4.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); db.Delete(produkt); } string resource5String = surowce[8]; var Resource5 = db.Table <Surowiec>().Where(c => c.Name == resource5String).FirstOrDefault(); var resource5Previous = Resource5.Count; if (IsEnoughResource(Resource5, produkt, Convert.ToDouble(surowce[9]))) { Resource5.Count -= (produkt.Count * Convert.ToDouble(surowce[9])); db.Update(Resource5); } else { double iloscBrakuje = -(Resource5.Count - (produkt.Count * Convert.ToDouble(surowce[9]))); string brakujeSurowca = "Brakuje " + Resource5.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); db.Delete(produkt); } string resource6String = surowce[10]; var Resource6 = db.Table <Surowiec>().Where(c => c.Name == resource6String).FirstOrDefault(); var resource6Previous = Resource6.Count; if (IsEnoughResource(Resource6, produkt, Convert.ToDouble(surowce[11]))) { Resource6.Count -= (produkt.Count * Convert.ToDouble(surowce[11])); db.Update(Resource6); } else { double iloscBrakuje = -(Resource6.Count - (produkt.Count * Convert.ToDouble(surowce[11]))); string brakujeSurowca = "Brakuje " + Resource6.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); db.Delete(produkt); } string resource7String = surowce[12]; var Resource7 = db.Table <Surowiec>().Where(c => c.Name == resource7String).FirstOrDefault(); var resource7Previous = Resource7.Count; if (IsEnoughResource(Resource7, produkt, Convert.ToDouble(surowce[13]))) { Resource7.Count -= (produkt.Count * Convert.ToDouble(surowce[13])); db.Update(Resource7); } else { double iloscBrakuje = -(Resource7.Count - (produkt.Count * Convert.ToDouble(surowce[13]))); string brakujeSurowca = "Brakuje " + Resource7.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); db.Delete(produkt); } string resource8String = surowce[14]; var Resource8 = db.Table <Surowiec>().Where(c => c.Name == resource8String).FirstOrDefault(); var resource8Previous = Resource8.Count; if (IsEnoughResource(Resource8, produkt, Convert.ToDouble(surowce[15]))) { Resource8.Count -= (produkt.Count * Convert.ToDouble(surowce[15])); db.Update(Resource8); } else { double iloscBrakuje = -(Resource8.Count - (produkt.Count * Convert.ToDouble(surowce[15]))); string brakujeSurowca = "Brakuje " + Resource8.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); db.Delete(produkt); } string resource9String = surowce[16]; var Resource9 = db.Table <Surowiec>().Where(c => c.Name == resource9String).FirstOrDefault(); var resource9Previous = Resource9.Count; if (IsEnoughResource(Resource9, produkt, Convert.ToDouble(surowce[17]))) { Resource9.Count -= (produkt.Count * Convert.ToDouble(surowce[17])); db.Update(Resource9); } else { double iloscBrakuje = -(Resource9.Count - (produkt.Count * Convert.ToDouble(surowce[17]))); string brakujeSurowca = "Brakuje " + Resource9.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); db.Delete(produkt); } string resource10String = surowce[18]; var Resource10 = db.Table <Surowiec>().Where(c => c.Name == resource10String).FirstOrDefault(); var resource10Previous = Resource10.Count; if (IsEnoughResource(Resource10, produkt, Convert.ToDouble(surowce[19]))) { Resource10.Count -= (produkt.Count * Convert.ToDouble(surowce[19])); db.Update(Resource10); } else { double iloscBrakuje = -(Resource10.Count - (produkt.Count * Convert.ToDouble(surowce[19]))); string brakujeSurowca = "Brakuje " + Resource10.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); db.Delete(produkt); } string resource11String = surowce[20]; var Resource11 = db.Table <Surowiec>().Where(c => c.Name == resource11String).FirstOrDefault(); var resource11Previous = Resource11.Count; if (IsEnoughResource(Resource11, produkt, Convert.ToDouble(surowce[21]))) { Resource11.Count -= (produkt.Count * Convert.ToDouble(surowce[21])); db.Update(Resource11); } else { double iloscBrakuje = -(Resource11.Count - (produkt.Count * Convert.ToDouble(surowce[21]))); string brakujeSurowca = "Brakuje " + Resource11.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); db.Delete(produkt); } string resource12String = surowce[22]; var Resource12 = db.Table <Surowiec>().Where(c => c.Name == resource12String).FirstOrDefault(); var resource12Previous = Resource12.Count; if (IsEnoughResource(Resource12, produkt, Convert.ToDouble(surowce[23]))) { Resource12.Count -= (produkt.Count * Convert.ToDouble(surowce[23])); db.Update(Resource12); } else { double iloscBrakuje = -(Resource12.Count - (produkt.Count * Convert.ToDouble(surowce[23]))); string brakujeSurowca = "Brakuje " + Resource12.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); db.Delete(produkt); } string resource13String = surowce[24]; var Resource13 = db.Table <Surowiec>().Where(c => c.Name == resource13String).FirstOrDefault(); var resource13Previous = Resource13.Count; if (IsEnoughResource(Resource13, produkt, Convert.ToDouble(surowce[25]))) { Resource13.Count -= (produkt.Count * Convert.ToDouble(surowce[25])); db.Update(Resource13); } else { double iloscBrakuje = -(Resource13.Count - (produkt.Count * Convert.ToDouble(surowce[25]))); string brakujeSurowca = "Brakuje " + Resource13.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); Resource12.Count = resource12Previous; db.Update(Resource12); db.Delete(produkt); } string resource14String = surowce[26]; var Resource14 = db.Table <Surowiec>().Where(c => c.Name == resource14String).FirstOrDefault(); var resource14Previous = Resource14.Count; if (IsEnoughResource(Resource14, produkt, Convert.ToDouble(surowce[27]))) { Resource14.Count -= (produkt.Count * Convert.ToDouble(surowce[27])); db.Update(Resource14); } else { double iloscBrakuje = -(Resource14.Count - (produkt.Count * Convert.ToDouble(surowce[27]))); string brakujeSurowca = "Brakuje " + Resource14.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); Resource12.Count = resource12Previous; db.Update(Resource12); Resource13.Count = resource13Previous; db.Update(Resource13); db.Delete(produkt); } string resource15String = surowce[28]; var Resource15 = db.Table <Surowiec>().Where(c => c.Name == resource15String).FirstOrDefault(); var resource15Previous = Resource15.Count; if (IsEnoughResource(Resource15, produkt, Convert.ToDouble(surowce[29]))) { Resource15.Count -= (produkt.Count * Convert.ToDouble(surowce[29])); db.Update(Resource15); } else { double iloscBrakuje = -(Resource15.Count - (produkt.Count * Convert.ToDouble(surowce[29]))); string brakujeSurowca = "Brakuje " + Resource15.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); Resource12.Count = resource12Previous; db.Update(Resource12); Resource13.Count = resource13Previous; db.Update(Resource13); Resource14.Count = resource14Previous; db.Update(Resource14); db.Delete(produkt); } string resource16String = surowce[30]; var Resource16 = db.Table <Surowiec>().Where(c => c.Name == resource16String).FirstOrDefault(); var resource16Previous = Resource16.Count; if (IsEnoughResource(Resource16, produkt, Convert.ToDouble(surowce[31]))) { Resource16.Count -= (produkt.Count * Convert.ToDouble(surowce[31])); db.Update(Resource16); } else { double iloscBrakuje = -(Resource16.Count - (produkt.Count * Convert.ToDouble(surowce[31]))); string brakujeSurowca = "Brakuje " + Resource16.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); Resource12.Count = resource12Previous; db.Update(Resource12); Resource13.Count = resource13Previous; db.Update(Resource13); Resource14.Count = resource14Previous; db.Update(Resource14); Resource15.Count = resource15Previous; db.Update(Resource15); db.Delete(produkt); } string resource17String = surowce[32]; var Resource17 = db.Table <Surowiec>().Where(c => c.Name == resource17String).FirstOrDefault(); var resource17Previous = Resource17.Count; if (IsEnoughResource(Resource17, produkt, Convert.ToDouble(surowce[33]))) { Resource17.Count -= (produkt.Count * Convert.ToDouble(surowce[33])); db.Update(Resource17); } else { double iloscBrakuje = -(Resource17.Count - (produkt.Count * Convert.ToDouble(surowce[33]))); string brakujeSurowca = "Brakuje " + Resource17.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); Resource12.Count = resource12Previous; db.Update(Resource12); Resource13.Count = resource13Previous; db.Update(Resource13); Resource14.Count = resource14Previous; db.Update(Resource14); Resource15.Count = resource15Previous; db.Update(Resource15); Resource16.Count = resource16Previous; db.Update(Resource16); db.Delete(produkt); } string resource18String = surowce[34]; var Resource18 = db.Table <Surowiec>().Where(c => c.Name == resource18String).FirstOrDefault(); var resource18Previous = Resource18.Count; if (IsEnoughResource(Resource18, produkt, Convert.ToDouble(surowce[35]))) { Resource18.Count -= (produkt.Count * Convert.ToDouble(surowce[35])); db.Update(Resource18); } else { double iloscBrakuje = -(Resource18.Count - (produkt.Count * Convert.ToDouble(surowce[35]))); string brakujeSurowca = "Brakuje " + Resource18.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); Resource12.Count = resource12Previous; db.Update(Resource12); Resource13.Count = resource13Previous; db.Update(Resource13); Resource14.Count = resource14Previous; db.Update(Resource14); Resource15.Count = resource15Previous; db.Update(Resource15); Resource16.Count = resource16Previous; db.Update(Resource16); Resource17.Count = resource17Previous; db.Update(Resource17); db.Delete(produkt); } string resource19String = surowce[36]; var Resource19 = db.Table <Surowiec>().Where(c => c.Name == resource19String).FirstOrDefault(); var resource19Previous = Resource19.Count; if (IsEnoughResource(Resource19, produkt, Convert.ToDouble(surowce[37]))) { Resource19.Count -= (produkt.Count * Convert.ToDouble(surowce[37])); db.Update(Resource19); } else { double iloscBrakuje = -(Resource19.Count - (produkt.Count * Convert.ToDouble(surowce[37]))); string brakujeSurowca = "Brakuje " + Resource19.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); Resource12.Count = resource12Previous; db.Update(Resource12); Resource13.Count = resource13Previous; db.Update(Resource13); Resource14.Count = resource14Previous; db.Update(Resource14); Resource15.Count = resource15Previous; db.Update(Resource15); Resource16.Count = resource16Previous; db.Update(Resource16); Resource17.Count = resource17Previous; db.Update(Resource17); Resource18.Count = resource18Previous; db.Update(Resource18); db.Delete(produkt); } string resource20String = surowce[38]; var Resource20 = db.Table <Surowiec>().Where(c => c.Name == resource20String).FirstOrDefault(); var resource20Previous = Resource20.Count; if (IsEnoughResource(Resource20, produkt, Convert.ToDouble(surowce[39]))) { Resource20.Count -= (produkt.Count * Convert.ToDouble(surowce[39])); db.Update(Resource20); } else { double iloscBrakuje = -(Resource20.Count - (produkt.Count * Convert.ToDouble(surowce[39]))); string brakujeSurowca = "Brakuje " + Resource20.Name + " W ilosci: " + iloscBrakuje; await DisplayAlert(null, brakujeSurowca, "OK"); Resource1.Count = resource1Previous; db.Update(Resource1); Resource2.Count = resource2Previous; db.Update(Resource2); Resource3.Count = resource3Previous; db.Update(Resource3); Resource4.Count = resource4Previous; db.Update(Resource4); Resource5.Count = resource5Previous; db.Update(Resource5); Resource6.Count = resource6Previous; db.Update(Resource6); Resource7.Count = resource7Previous; db.Update(Resource7); Resource8.Count = resource8Previous; db.Update(Resource8); Resource9.Count = resource9Previous; db.Update(Resource9); Resource10.Count = resource10Previous; db.Update(Resource10); Resource11.Count = resource11Previous; db.Update(Resource11); Resource12.Count = resource12Previous; db.Update(Resource12); Resource13.Count = resource13Previous; db.Update(Resource13); Resource14.Count = resource14Previous; db.Update(Resource14); Resource15.Count = resource15Previous; db.Update(Resource15); Resource16.Count = resource16Previous; db.Update(Resource16); Resource17.Count = resource17Previous; db.Update(Resource17); Resource18.Count = resource18Previous; db.Update(Resource18); Resource19.Count = resource19Previous; db.Update(Resource19); db.Delete(produkt); } //await DisplayAlert(null, "Dodano produkt i zaktualizowano surowce", "OK"); await Navigation.PopAsync(); } catch { //await DisplayAlert(null, "Dodano produkt i zaktualizowano surowce", "OK"); await Navigation.PopAsync(); } }
private async void _saveButton_Clicked(object sender, EventArgs e) { var db = new SQLiteConnection(_dbPath); db.CreateTable <Receptura>(); var maxPk = db.Table <Receptura>().OrderByDescending(c => c.Id).FirstOrDefault(); Receptura receptura = new Receptura() { Id = (maxPk == null ? 1 : maxPk.Id + 1), Name = _nameEntry.Text, Surowce = "" }; try { Surowiec surowiec1 = (Surowiec)_reagentPicker1.SelectedItem; surowiec1.Count = Convert.ToDouble(_countEntry1.Text); receptura.Surowce = receptura.Surowce + surowiec1.Name + " (" + surowiec1.Count + ") "; Surowiec surowiec2 = (Surowiec)_reagentPicker2.SelectedItem; surowiec2.Count = Convert.ToDouble(_countEntry2.Text); receptura.Surowce = receptura.Surowce + surowiec2.Name + " (" + surowiec2.Count + ") "; Surowiec surowiec3 = (Surowiec)_reagentPicker3.SelectedItem; surowiec3.Count = Convert.ToDouble(_countEntry3.Text); receptura.Surowce = receptura.Surowce + surowiec3.Name + " (" + surowiec3.Count + ") "; Surowiec surowiec4 = (Surowiec)_reagentPicker4.SelectedItem; surowiec4.Count = Convert.ToDouble(_countEntry4.Text); receptura.Surowce = receptura.Surowce + surowiec4.Name + " (" + surowiec4.Count + ") "; Surowiec surowiec5 = (Surowiec)_reagentPicker5.SelectedItem; surowiec5.Count = Convert.ToDouble(_countEntry5.Text); receptura.Surowce = receptura.Surowce + surowiec5.Name + " (" + surowiec5.Count + ") "; Surowiec surowiec6 = (Surowiec)_reagentPicker6.SelectedItem; surowiec6.Count = Convert.ToDouble(_countEntry6.Text); receptura.Surowce = receptura.Surowce + surowiec6.Name + " (" + surowiec6.Count + ") "; Surowiec surowiec7 = (Surowiec)_reagentPicker7.SelectedItem; surowiec7.Count = Convert.ToDouble(_countEntry7.Text); receptura.Surowce = receptura.Surowce + surowiec7.Name + " (" + surowiec7.Count + ") "; Surowiec surowiec8 = (Surowiec)_reagentPicker8.SelectedItem; surowiec8.Count = Convert.ToDouble(_countEntry8.Text); receptura.Surowce = receptura.Surowce + surowiec8.Name + " (" + surowiec8.Count + ") "; Surowiec surowiec9 = (Surowiec)_reagentPicker9.SelectedItem; surowiec9.Count = Convert.ToDouble(_countEntry9.Text); receptura.Surowce = receptura.Surowce + surowiec9.Name + " (" + surowiec9.Count + ") "; Surowiec surowiec10 = (Surowiec)_reagentPicker10.SelectedItem; surowiec10.Count = Convert.ToDouble(_countEntry10.Text); receptura.Surowce = receptura.Surowce + surowiec10.Name + " (" + surowiec10.Count + ") "; Surowiec surowiec11 = (Surowiec)_reagentPicker11.SelectedItem; surowiec11.Count = Convert.ToDouble(_countEntry11.Text); receptura.Surowce = receptura.Surowce + surowiec11.Name + " (" + surowiec11.Count + ") "; Surowiec surowiec12 = (Surowiec)_reagentPicker12.SelectedItem; surowiec12.Count = Convert.ToDouble(_countEntry12.Text); receptura.Surowce = receptura.Surowce + surowiec12.Name + " (" + surowiec12.Count + ") "; Surowiec surowiec13 = (Surowiec)_reagentPicker13.SelectedItem; surowiec13.Count = Convert.ToDouble(_countEntry13.Text); receptura.Surowce = receptura.Surowce + surowiec13.Name + " (" + surowiec13.Count + ") "; Surowiec surowiec14 = (Surowiec)_reagentPicker14.SelectedItem; surowiec14.Count = Convert.ToDouble(_countEntry14.Text); receptura.Surowce = receptura.Surowce + surowiec14.Name + " (" + surowiec14.Count + ") "; Surowiec surowiec15 = (Surowiec)_reagentPicker15.SelectedItem; surowiec15.Count = Convert.ToDouble(_countEntry15.Text); receptura.Surowce = receptura.Surowce + surowiec15.Name + " (" + surowiec15.Count + ") "; Surowiec surowiec16 = (Surowiec)_reagentPicker16.SelectedItem; surowiec16.Count = Convert.ToDouble(_countEntry16.Text); receptura.Surowce = receptura.Surowce + surowiec16.Name + " (" + surowiec16.Count + ") "; Surowiec surowiec17 = (Surowiec)_reagentPicker17.SelectedItem; surowiec17.Count = Convert.ToDouble(_countEntry17.Text); receptura.Surowce = receptura.Surowce + surowiec17.Name + " (" + surowiec17.Count + ") "; Surowiec surowiec18 = (Surowiec)_reagentPicker18.SelectedItem; surowiec18.Count = Convert.ToDouble(_countEntry18.Text); receptura.Surowce = receptura.Surowce + surowiec18.Name + " (" + surowiec18.Count + ") "; Surowiec surowiec19 = (Surowiec)_reagentPicker19.SelectedItem; surowiec19.Count = Convert.ToDouble(_countEntry19.Text); receptura.Surowce = receptura.Surowce + surowiec19.Name + " (" + surowiec19.Count + ") "; Surowiec surowiec20 = (Surowiec)_reagentPicker20.SelectedItem; surowiec20.Count = Convert.ToDouble(_countEntry20.Text); receptura.Surowce = receptura.Surowce + surowiec20.Name + " (" + surowiec20.Count + ") "; db.Insert(receptura); await DisplayAlert(null, receptura.Name + " zapisano", "OK"); await Navigation.PopAsync(); } catch { db.Insert(receptura); await Navigation.PopAsync(); } }
//protected override void Seed(BeerContext context) //{ // SeedBeer(context); // base.Seed(context); //} public static void SeedBeer(BeerContext context) { var chmiel = new Chmiel { AlfaKwasy = 4.0M, NazwaChmielu = "INITIAL_DB" }; context.Chmiele.Add(chmiel); var UserManager = new UserManager <Uzytkownik>(new UserStore <Uzytkownik>(context)); var RoleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context)); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - STWORZENIE ROLI 'ADMIN' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - string roleNameAdmin = "Admin"; if (!RoleManager.RoleExists(roleNameAdmin)) { var roleresult = RoleManager.Create(new IdentityRole(roleNameAdmin)); } // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - STWORZENIE ROLI 'MOD' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - string roleNameMod = "Mod"; if (!RoleManager.RoleExists(roleNameMod)) { var roleresult = RoleManager.Create(new IdentityRole(roleNameMod)); } // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - STWORZENIE ROLI 'USER' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - string roleNameUser = "******"; if (!RoleManager.RoleExists(roleNameUser)) { var roleresult = RoleManager.Create(new IdentityRole(roleNameUser)); } // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - STWORZENIE UŻYTKOWNIKÓW 'ADMIN' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - var user = new Uzytkownik() { UserName = "******", Email = "*****@*****.**", DataRejestracji = DateTime.Now, OstatniaAktywnosc = DateTime.Now }; if (UserManager.Create(user, "P@ssw0rd").Succeeded) { UserManager.AddToRole(user.Id, roleNameAdmin); } // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - STWORZENIE UŻYTKOWNIKÓW 'MOD' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - user = new Uzytkownik() { UserName = "******", Email = "*****@*****.**", DataRejestracji = DateTime.Now, OstatniaAktywnosc = DateTime.Now }; if (UserManager.Create(user, "P@ssw0rd").Succeeded) { UserManager.AddToRole(user.Id, roleNameMod); } // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - STWORZENIE UŻYTKOWNIKÓW 'USER' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - List <Uzytkownik> listaUserow = new List <Uzytkownik>() { new Uzytkownik() { UserName = "******", Email = "*****@*****.**", Imie = "Sebastian", Nazwisko = "Szczepanski", DataRejestracji = DateTime.Now, OstatniaAktywnosc = DateTime.Now }, new Uzytkownik() { UserName = "******", Email = "*****@*****.**", Imie = "Tomek", Nazwisko = "Miss", DataRejestracji = DateTime.Now, OstatniaAktywnosc = DateTime.Now }, new Uzytkownik() { UserName = "******", Email = "*****@*****.**", Imie = "Lukasz", Nazwisko = "Gej", DataRejestracji = DateTime.Now, OstatniaAktywnosc = DateTime.Now }, new Uzytkownik() { UserName = "******", Email = "*****@*****.**", Imie = "James", Nazwisko = "Blunt", DataRejestracji = DateTime.Now, OstatniaAktywnosc = DateTime.Now } }; foreach (var us in listaUserow) { if (UserManager.Create(us, "P@ssw0rd").Succeeded) { UserManager.AddToRole(us.Id, roleNameUser); } } // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - STWORZENIE UŻYTKOWNIKÓW 'RECEPTURA' - - - - - - - - - - - - - - - - - - - - - - - Slod slod1 = new Slod { NazwaSlodu = "PaleAle", Barwa = 12, Ekstraktywnosc = 80 }; Slod slod2 = new Slod { NazwaSlodu = "Pilznenski", Barwa = 4, Ekstraktywnosc = 60 }; Chmiel chmiel1 = new Chmiel { NazwaChmielu = "IUNGA", AlfaKwasy = 12.0M }; Chmiel chmiel2 = new Chmiel { NazwaChmielu = "Lubelski", AlfaKwasy = 3.0M }; Styl styl = new Styl { NazwaStylu = "APA", Kod = "APE123", OGmin = 12.0M, OGmax = 20.0M }; Przerwa przerwa1 = new Przerwa { Etap = "Maltozowa", Temperatura = 66, CzasTrwania = 60 }; Przerwa przerwa2 = new Przerwa { Etap = "Wygrzew", Temperatura = 75, CzasTrwania = 5 }; Receptura receptura = new Receptura { NazwaReceptury = "RReceptura pyzianowska", Opis = "Receptura piwa warzonego pyzianowskiego", Drozdze = new Drozdze { NazwaDrozdzy = "asdf", Fermentacja = EFermentacja.dolna, Flokulacja = EFlokulacja.niska }, Objetosc = 23.0M, Gotowanie = 30.0M, Wysladzanie = 10.0M, TemperaturaFermentacji = 18, SkladnikiSlodu = new List <SkladnikSlodu> { new SkladnikSlodu { Ilosc = 2, Slod = slod1 }, new SkladnikSlodu { Ilosc = 3, Slod = slod2 } }, IloscSlodu = 5.0M, SkladnikiChmielu = new List <SkladnikChmielu> { new SkladnikChmielu { Ilosc = 1, Chmiel = chmiel1 }, new SkladnikChmielu { Ilosc = 1, Chmiel = chmiel2 }, }, Uzytkownik = context.Users.SingleOrDefault(u => u.UserName == "*****@*****.**"), Styl = styl, Przerwy = new List <Przerwa> { przerwa1, przerwa2 }, OG = 12.0M, FG = 2.0M, ABV = 5.0M, EBC = 20.0M, IBU = 30.0M }; //Chmiel cmielStary = context.Chmiele.FirstOrDefault(c => c.NazwaChmielu == "submit"); ID 1, recID 00 //Chmiel chmielNowy = new Chmiel //{ // NazwaChmielu = cmielStary.NazwaChmielu, // SkladnikiChmielu = cmielStary.SkladnikiChmielu, // AlfaKwasy = cmielStary.AlfaKwasy //}; context.Receptury.Add(receptura); context.SaveChanges(); }
public static void Update(Receptura receptura, string nazwa, string sklad) { Delete(receptura); Insert(nazwa, sklad); }