private void btnLog_Click(object sender, EventArgs e) { using (DomowyFastFoodContext Context = new DomowyFastFoodContext()) { if (Context.Klients.AsParallel().Where(x => x.Nick == txtBoxLogin.Text).Count() > 0 && Context.Klients.AsParallel().Where(x => x.Password == txtBoxPassword.Text).Count() > 0) { Identity = txtBoxLogin.Text; frmUserControlPanel f = new frmUserControlPanel(Identity); f.ShowDialog(); } else if (Context.Pracowniks.AsParallel().Where(x => x.Nick == txtBoxLogin.Text).Count() > 0 && Context.Pracowniks.AsParallel().Where(x => x.Password == txtBoxPassword.Text).Count() > 0) { Authorization = Context.Pracowniks.AsParallel().Where(x => x.Nick == txtBoxLogin.Text).FirstOrDefault().Autoryzacja; Identity = txtBoxLogin.Text; frmAdminControlPanel f = new frmAdminControlPanel(Authorization, Identity); f.ShowDialog(); } else { MessageBox.Show("Błąd Logowania", "Niepoprawny login lub hasło", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
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 frmAdminControlPanel_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("ID_Zamowienia"); dt.Columns.Add("Pracownik"); dt.Columns.Add("Telefon Pracownika"); dt.Columns.Add("Nazwa Restauracji"); dt.Columns.Add("Danie Dnia"); dt.Columns.Add("Telefon Restauracji"); dt.Columns.Add("Data Zamowienia"); dt.AcceptChanges(); using (var Context = new DomowyFastFoodContext()) { var clientDatav2 = Context.Zamowienies // your starting point - table in the "from" statement .Join(Context.Klients, // the source table of the inner join zam => zam.ID_Klienta, // Select the primary key (the first part of the "on" clause in an sql "join" statement) client => client.ID_Klienta, // Select the foreign key (the second part of the "on" clause) (zam, client) => new { Zam = zam, Client = client }) // selection .Where(x => x.Zam.ID_Klienta == x.Client.ID_Klienta) .Join(Context.Restauracjas, // the source table of the inner join zam => zam.Zam.ID_Restauracji, // Select the primary key (the first part of the "on" clause in an sql "join" statement) restaurant => restaurant.ID_Restauracji, // Select the foreign key (the second part of the "on" clause) (zam, restaurant) => new { Zam2 = zam, Restaurant = restaurant }) // selection .Where(x => x.Zam2.Zam.ID_Restauracji == x.Restaurant.ID_Restauracji); var filteredClientDatav2 = clientDatav2.AsParallel().Select(x => new { x.Zam2.Zam.ID_Zamowienia, x.Zam2.Client.Nick, x.Zam2.Client.Telefon, x.Restaurant.NazwaRestauracji, x.Zam2.Zam.DanieDnia, x.Zam2.Zam.DataZamowienia }).ToList(); var filteredRestaurantdata = clientDatav2.AsParallel().Select(x => x.Restaurant.Telefon).ToList(); var orderDate = Context.Zamowienies.Select(x => x.DataZamowienia).ToList(); foreach (var item in filteredClientDatav2.Zip(filteredRestaurantdata, Tuple.Create)) { dt.Rows.Add(item.Item1.ID_Zamowienia, item.Item1.Nick, item.Item1.Telefon, item.Item1.NazwaRestauracji, item.Item1.DanieDnia, item.Item2, item.Item1.DataZamowienia); } dt.AcceptChanges(); dgvOrder.DataSource = dt; // // var clientData = Context.Klients.AsParallel().Select(x => new { x.Nick, x.Telefon}).ToList(); // var clientData = Context.Zamowienies // your starting point - table in the "from" statement // .Join(Context.Klients, // the source table of the inner join // zam => zam.ID_Klienta, // Select the primary key (the first part of the "on" clause in an sql "join" statement) // client => client.ID_Klienta, // Select the foreign key (the second part of the "on" clause) // (zam,client) => new { Zam = zam,Client = client }) // selection // .Where(x => x.Zam.ID_Klienta == x.Client.ID_Klienta); // var filteredClientData = clientData.AsParallel().Select(x => new { x.Client.Nick, x.Client.Telefon }).ToList(); // //var restaurantData = Context.Restauracjas.AsParallel().Select(x => new { x.NazwaRestauracji, x.DanieDnia, x.Telefon }).ToList(); // var restaurantData = Context.Zamowienies // your starting point - table in the "from" statement //.Join(Context.Restauracjas, // the source table of the inner join // zam => zam.ID_Restauracji, // Select the primary key (the first part of the "on" clause in an sql "join" statement) // restaurant => restaurant.ID_Restauracji, // Select the foreign key (the second part of the "on" clause) // (zam, restaurant) => new { Zam = zam, Restaurant = restaurant }) // selection //.Where(x => x.Zam.ID_Restauracji == x.Restaurant.ID_Restauracji); // var filteredRestaurantData = restaurantData.AsParallel().Select(x => new { x.Restaurant.NazwaRestauracji,x.Restaurant.DanieDnia ,x.Restaurant.Telefon }).ToList(); } }
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(); //} } }