// 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);
}
