private async void _AddButton_Clicked(object sender, EventArgs e)
{
try
{
var db = new SQLiteConnection(_dbPath);
Surowiec surowiec = new Surowiec();
surowiec = (Surowiec)_picker.SelectedItem;
surowiec.Count += Convert.ToDouble(_countEntry.Text);
db.Update(surowiec);
Surowiec surowiec2 = new Surowiec();
surowiec2 = (Surowiec)_picker2.SelectedItem;
surowiec2.Count += Convert.ToDouble(_countEntry2.Text);
db.Update(surowiec2);
Surowiec surowiec3 = new Surowiec();
surowiec3 = (Surowiec)_picker3.SelectedItem;
surowiec3.Count += Convert.ToDouble(_countEntry3.Text);
db.Update(surowiec3);
Surowiec surowiec4 = new Surowiec();
surowiec4 = (Surowiec)_picker4.SelectedItem;
surowiec4.Count += Convert.ToDouble(_countEntry4.Text);
db.Update(surowiec4);
Surowiec surowiec5 = new Surowiec();
surowiec5 = (Surowiec)_picker5.SelectedItem;
surowiec5.Count += Convert.ToDouble(_countEntry5.Text);
db.Update(surowiec5);
await Navigation.PopAsync();
}
catch
{
await Navigation.PopAsync();
}
}
private void _listView_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
_surowiec = (Surowiec)e.SelectedItem;
_idEntry.Text = _surowiec.Id.ToString();
_nameEntry.Text = _surowiec.Name;
_countEntry.Text = Convert.ToString(_surowiec.Count);
}
public ActionResult DeleteConfirmed(int id)
{
Surowiec surowiec = db.Surowiecs.Find(id);
db.Surowiecs.Remove(surowiec);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Nazwa,Opis,WspolczynnikID")] Surowiec surowiec)
{
if (ModelState.IsValid)
{
db.Entry(surowiec).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.WspolczynnikID = new SelectList(db.Wspolczynniks, "Id", "Id", surowiec.WspolczynnikID);
return(View(surowiec));
}
private bool IsEnoughResource(Surowiec surowiec, Produkt produkt, double surowiecAmount)
{
if (surowiec.Count < produkt.Count * surowiecAmount)
{
return(false);
}
else
{
return(true);
}
}
public ActionResult Create([Bind(Include = "Id,Nazwa,Opis,WspolczynnikID")] Surowiec surowiec)
{
if (ModelState.IsValid)
{
db.Surowiecs.Add(surowiec);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.WspolczynnikID = new SelectList(db.Wspolczynniks, "Id", "Id", surowiec.WspolczynnikID);
return(View(surowiec));
}
// GET: Surowiecs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Surowiec surowiec = db.Surowiecs.Find(id);
if (surowiec == null)
{
return(HttpNotFound());
}
return(View(surowiec));
}
// GET: Surowiecs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Surowiec surowiec = db.Surowiecs.Find(id);
if (surowiec == null)
{
return(HttpNotFound());
}
ViewBag.WspolczynnikID = new SelectList(db.Wspolczynniks, "Id", "Id", surowiec.WspolczynnikID);
return(View(surowiec));
}
private async void _EditButton_Clicked(object sender, EventArgs e)
{
try
{
var db = new SQLiteConnection(_dbPath);
Surowiec surowiec = new Surowiec()
{
Id = Convert.ToInt16(_idEntry.Text),
Name = _nameEntry.Text.Replace(" ", "_"),
Count = Convert.ToDouble(_countEntry.Text)
};
db.Update(surowiec);
await Navigation.PopAsync();
}
catch
{
await Navigation.PopAsync();
}
}
private async void _saveButton_Clicked(object sender, EventArgs e)
{
var db = new SQLiteConnection(_dbPath);
db.CreateTable <Surowiec>();
var maxPk = db.Table <Surowiec>().OrderByDescending(c => c.Id).FirstOrDefault();
Surowiec surowiec = new Surowiec()
{
Id = (maxPk == null ? 1 : maxPk.Id + 1),
Name = _nameEntry.Text.Replace(" ", "_"),
Count = Convert.ToDouble(_countEntry.Text)
};
db.Insert(surowiec);
await DisplayAlert(null, surowiec.Name + " zapisano", "OK");
await Navigation.PopAsync();
}
private void _listView_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
_surowiec = (Surowiec)e.SelectedItem;
}
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();
}
}
