private void btnDelOrder_Click(object sender, EventArgs e)
{
var id = int.Parse(dgvOrder.Rows[dgvOrder.SelectedCells[0].RowIndex].Cells[0].Value.ToString());
using (var Context = new DomowyFastFoodContext())
{
var removeOrder = Context
.Zamowienies
.FirstOrDefault(x => x.ID_Zamowienia == id);
var removeCommand = Context
.Entry(removeOrder);
removeCommand.State = EntityState.Deleted;
Context.SaveChanges();
}
this.OnLoad(e);
}
private void btnOrder_Click(object sender, EventArgs e)
{
using (DomowyFastFoodContext Context = new DomowyFastFoodContext())
{
var client = Context.Klients.SingleOrDefault(x => x.Nick == Identity);
var id = client.ID_Klienta;
var idRes = int.Parse(dgvRestaurant.Rows[dgvRestaurant.SelectedCells[0].RowIndex].Cells[0].Value.ToString());
var Dinner = Context.Restauracjas.SingleOrDefault(x => x.ID_Restauracji == idRes);
Context.Zamowienies.Add(new Zamowienie
{
ID_Zamowienia = Context.Zamowienies.Max(x => x.ID_Zamowienia) + 1,
ID_Klienta = id,
ID_Restauracji = idRes,
DanieDnia = Dinner.DanieDnia,
DataZamowienia = DateTime.Now.Date
});
Context.SaveChanges();
MessageBox.Show("Pomyslnie dodano zamowienie", "Zamow!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
try
{
using (DomowyFastFoodContext Context = new DomowyFastFoodContext())
{
Context.Klients.Add(new Klient
{
ID_Klienta = Context.Klients.Max(x => x.ID_Klienta) + 1,
Nick = txtboxNick.Text,
Password = txtboxPassword.Text,
Adres = txtboxAdress.Text,
Telefon = txtboxPhone.Text
});
Context.SaveChanges();
Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
private void btnSync_Click(object sender, EventArgs e)
{
using (DomowyFastFoodContext Context = new DomowyFastFoodContext())
{
var currentDate = $"{DateTime.Now.ToShortDateString()} \t {DateTime.Now.ToShortTimeString()}";
lblSyncInfo.Text = currentDate;
File.WriteAllText(path, $"");
File.AppendAllText(path, currentDate);
string urlPoSwiecie = "http://www.poswieciekuchni.pl/menu-dnia/";
HtmlWeb web = new HtmlWeb();
HtmlAgilityPack.HtmlDocument documentPoSwiecie = web.Load(urlPoSwiecie);
var nodePoSwiecie = documentPoSwiecie.DocumentNode
.SelectNodes("//div[@class='wpb_wrapper']/p[position() > 5]").ToArray();
string DinnerPoSwiecie = string.Empty;
if (nodePoSwiecie != null)
{
foreach (var item in nodePoSwiecie)
{
DinnerPoSwiecie += item.InnerText;
}
}
var resultPoSwiecie = Context.Restauracjas.SingleOrDefault(x => x.ID_Restauracji == 1);
if (resultPoSwiecie != null)
{
resultPoSwiecie.DanieDnia = DinnerPoSwiecie;
Context.SaveChanges();
}
string urlMaximus = "http://maximus.bielsko.pl/";
HtmlAgilityPack.HtmlDocument documentMaximus = web.Load(urlMaximus);
//switch (DateTime.Now.DayOfWeek )
//{
// case DayOfWeek.Monday:
// var nodeMaximus = documentMaximus.DocumentNode
// .SelectNodes("//div[@class='wpb_wrapper']/p[position() > 5]").ToArray();
// break;
// default:
//}
var nodeMaximus = documentMaximus.DocumentNode
.SelectNodes("//div[@class='views-row views-row-1 views-row-odd views-row-first views-row-last']/div/p[3]").ToArray();
//*[@id="block-views-dish-of-the-day-block"]/div/div/div/div/div/p[3]
string DinnerMaximus = string.Empty;
if (nodeMaximus != null)
{
foreach (var item in nodeMaximus)
{
DinnerMaximus += item.InnerText;
}
}
var resultMaximus = Context.Restauracjas.SingleOrDefault(x => x.ID_Restauracji == 2);
if (resultMaximus != null)
{
resultMaximus.DanieDnia = DinnerMaximus;
Context.SaveChanges();
}
this.OnLoad(e);
// frmUserControlPanel form = new frmUserControlPanel(Identity);
// form.Show();
//this.Close();
// var node = document.DocumentNode.Descendants("P")
//.Select(y => y.Descendants()
//.Where(x => x.Attributes["class"].Value == "wpb_wrapper"))
//.ToArray();
//HtmlWeb web = new HtmlWeb();
//var document = web.Load("");
//HtmlNode[] nodes = document.DocumentNode.SelectNodes("//*[@id=block - views - dish - of - the - day - block]").ToArray();
//MessageBox.Show(nodes[0].InnerText);
//var Result = Context.Restauracjas.SingleOrDefault(x => x.NazwaRestauracji == "Maximus");
//if (Result != null)
//{
// Result.DanieDnia = nodes[0].InnerText;
// Context.SaveChanges();
//}
}
}