private void dtMenuList_CellClick(object sender, DataGridViewCellEventArgs e) { if (dtMenuList.RowCount > 0) { var idMenu = Convert.ToInt16(dtMenuList.SelectedRows[0].Tag); if (idMenu != 0) { dtMenuList.Visible = false; Thread thread = new Thread(ThreadLoading); thread.Start(); Thread.Sleep(1000); ContextDataContext linq = new ContextDataContext(Connection.connection); var menu = linq.Menu.FirstOrDefault(el => el.ID == idMenu); if (menu != null) { tbMenuName.Text = menu.Name; tbMenuDetails.Text = menu.Details; ID = menu.ID; } thread.Abort(); dtMenuList.Visible = true; } } }
private void GetListOrder() { ContextDataContext linq = new ContextDataContext(Connection.connection); List <Order> orderList = linq.Order.ToList(); DrawListOrdersInDT(orderList); }
private void btnDeleteMenu_Click(object sender, EventArgs e) { if (dtMenuList.RowCount > 0) { var idMenu = Convert.ToInt16(dtMenuList.SelectedRows[0].Tag); if (idMenu != 0) { dtMenuList.Visible = false; Thread thread = new Thread(ThreadLoading); thread.Start(); Thread.Sleep(1000); ContextDataContext linq = new ContextDataContext(Connection.connection); var menu = linq.Menu.FirstOrDefault(el => el.ID == idMenu); if (menu != null) { linq.Menu.DeleteOnSubmit(menu); linq.SubmitChanges(); DrawListmenuInDT(); ResetControls(); MessageBox.Show("Меню успешно удалено"); } thread.Abort(); dtMenuList.Visible = true; } } }
private void AddNewOrder(ContextDataContext linq) { Thread thread = new Thread(ThreadLoading); thread.Start(); Thread.Sleep(1000); try { var orderDetails = new OrderDetails { MenuID = Convert.ToInt16(cbMenu.SelectedValue), Details = tbOrderDetails_Details.Text }; linq.OrderDetails.InsertOnSubmit(orderDetails); linq.SubmitChanges(); var newOrder = new Order { PersonalID = Convert.ToInt16(cbPersonal.SelectedValue), OrderDetailID = orderDetails.ID, OrderDate = DateTime.Now, Details = tbOrder_Details.Text }; linq.Order.InsertOnSubmit(newOrder); linq.SubmitChanges(); MessageBox.Show("Новый заказ был создан успешно"); thread.Abort(); } catch { thread.Abort(); } }
private void dtPersonalList_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dtPersonalList.RowCount > 0) { var idPersona = Convert.ToInt16(dtPersonalList.SelectedRows[0].Tag); if (idPersona != 0) { dtPersonalList.Visible = false; Thread thread = new Thread(ThreadLoading); thread.Start(); ContextDataContext linq = new ContextDataContext(Connection.connection); var persona = linq.Personal.FirstOrDefault(el => el.ID == idPersona); if (persona != null) { tbFirstName.Text = persona.FirstName; tbLastName.Text = persona.LastName; tbPhoneNumber.Text = persona.Phone; tbEmail.Text = persona.Email; tbAddress.Text = persona.Address; ID = idPersona; } thread.Abort(); dtPersonalList.Visible = true; } } }
private void button4_Click(object sender, EventArgs e) { var linq = new ContextDataContext(connection); var pretMaxim = linq.Vanzari.OrderBy(el => el.Data).ToArray(); decimal? suma = 0; decimal? sumaMax = 0; DateTime?datamax = new DateTime(); for (int i = 1; i < pretMaxim.Length; i++) { if (pretMaxim[i].Data == pretMaxim[i - 1].Data) { suma += pretMaxim[i].Cantitate * pretMaxim[i].Pret; datamax = pretMaxim[i].Data; } else { sumaMax = suma; suma = 0; datamax = pretMaxim[i].Data; } } lbVenitMaxim.Text = $"Data cu venit maxim : {datamax}"; }
private void button6_Click(object sender, EventArgs e) { //lbPretMaxim.Text = "Pret maxim: "; var linq = new ContextDataContext(connection); var pretMaxim = linq.Vanzari.Where(el => el.Denumire == tbMarfa.Text).OrderByDescending(el => el.Pret).ToList(); lbPretMaxim.Text += $"{pretMaxim[0].Pret} pentru {pretMaxim[0].Denumire}"; }
private void DrawListmenuInDT() { dtMenuList.Rows.Clear(); ContextDataContext linq = new ContextDataContext(Connection.connection); var listMenu = linq.Menu.ToList(); foreach (var menu in listMenu) { dtMenuList.Rows.Add(); dtMenuList[0, dtMenuList.RowCount - 1].Value = menu.Name; dtMenuList[1, dtMenuList.RowCount - 1].Value = menu.Details; dtMenuList.Rows[dtMenuList.RowCount - 1].Tag = menu.ID; } }
private void EditPersona(string _FirstName, string _LastName, string _Phone, string _Email, string _Address) { ContextDataContext linq = new ContextDataContext(Connection.connection); var persona = linq.Personal.FirstOrDefault(el => el.ID == ID); if (persona != null) { persona.FirstName = _FirstName; persona.LastName = _LastName; persona.Phone = _Phone; persona.Email = _Email; persona.Address = _Address; linq.SubmitChanges(); } }
public static void AddNewPersona(string _FirstName, string _LastName, string _Phone, string _Email, string _Address) { ContextDataContext linq = new ContextDataContext(Connection.connection); var persona = new Personal { FirstName = _FirstName, LastName = _LastName, Phone = _Phone, Email = _Email, Address = _Address }; linq.Personal.InsertOnSubmit(persona); linq.SubmitChanges(); }
private void button3_Click(object sender, EventArgs e) { var linq = new ContextDataContext(connection); Vanzari newmarfa = new Vanzari { Denumire = tbMarfa.Text, Data = dtData.Value, Pret = Decimal.Parse(tbPret.Text), Cantitate = Decimal.Parse(tbCantitate.Text) }; linq.Vanzari.InsertOnSubmit(newmarfa); linq.SubmitChanges(); MessageBox.Show("Datele au fost salvate cu success"); button7_Click(null, null); }
private void btnSaveOrder_Click(object sender, EventArgs e) { ContextDataContext linq = new ContextDataContext(Connection.connection); if (!IsEdit) { AddNewOrder(linq); MessageBox.Show("Заказ был успешно создан"); } else { EditOrder(linq); MessageBox.Show("Заказ был успешно изменен"); } this.Close(); }
private void button2_Click(object sender, EventArgs e) { dataGridView1.Rows.Clear(); var linq = new ContextDataContext(connection); var marfaOrdonata = linq.Vanzari.OrderBy(el => el.Denumire).ThenBy(el => el.Data).ToList(); foreach (var marfa in marfaOrdonata) { dataGridView1.Rows.Add(); dataGridView1.Rows[dataGridView1.RowCount - 1].Tag = marfa.Id; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[0].Value = marfa.Id; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[1].Value = marfa.Denumire; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[2].Value = marfa.Data; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[3].Value = marfa.Pret; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[4].Value = marfa.Cantitate; dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[5].Value = (marfa.Cantitate * marfa.Pret); } }
private void EditOrder(ContextDataContext linq) { var order = linq.Order.FirstOrDefault(el => el.ID == OrderID); if (order != null) { var orderDetails = linq.OrderDetails.FirstOrDefault(el => el.ID == order.OrderDetailID); if (orderDetails != null) { orderDetails.MenuID = Convert.ToInt16(cbMenu.SelectedValue); orderDetails.Details = tbOrderDetails_Details.Text; linq.SubmitChanges(); } order.PersonalID = Convert.ToInt16(cbPersonal.SelectedValue); order.Details = tbOrder_Details.Text; linq.SubmitChanges(); } }
private void LoadControls() { Thread thread = new Thread(ThreadLoading); thread.Start(); Thread.Sleep(1000); ContextDataContext linq = new ContextDataContext(Connection.connection); var personalList = linq.Personal.ToList(); cbPersonal.ValueMember = "ID"; cbPersonal.DisplayMember = "LastName"; cbPersonal.DataSource = personalList; var menuList = linq.Menu.ToList(); cbMenu.ValueMember = "ID"; cbMenu.DisplayMember = "Name"; cbMenu.DataSource = menuList; if (IsEdit) { var order = linq.Order.FirstOrDefault(el => el.ID == OrderID); if (order != null) { cbPersonal.SelectedValue = order.PersonalID; cbMenu.SelectedValue = order.OrderDetails.MenuID; tbOrderDetails_Details.Text = order.OrderDetails.Details; tbOrder_Details.Text = order.Details; } else { MessageBox.Show("Заказ не был найден"); } } thread.Abort(); }
private void DrawPersonalInDT() { try { dtPersonalList.Rows.Clear(); ContextDataContext linq = new ContextDataContext(Connection.connection); var personal = linq.Personal.ToList(); foreach (var persona in personal) { dtPersonalList.Rows.Add(); dtPersonalList[0, dtPersonalList.RowCount - 1].Value = persona.FirstName; dtPersonalList[1, dtPersonalList.RowCount - 1].Value = persona.LastName; dtPersonalList[2, dtPersonalList.RowCount - 1].Value = persona.Phone; dtPersonalList[3, dtPersonalList.RowCount - 1].Value = persona.Email; dtPersonalList[4, dtPersonalList.RowCount - 1].Value = persona.Address; dtPersonalList.Rows[dtPersonalList.RowCount - 1].Tag = persona.ID; } } catch { } }
private void btnSaveMenu_Click(object sender, EventArgs e) { dtMenuList.Visible = false; Thread thread = new Thread(ThreadLoading); thread.Start(); Thread.Sleep(1000); ContextDataContext linq = new ContextDataContext(Connection.connection); if (ID == 0) { var menu = new Menu { Name = tbMenuName.Text, Details = tbMenuDetails.Text }; linq.Menu.InsertOnSubmit(menu); linq.SubmitChanges(); MessageBox.Show("Меню успешно добавлено"); } else { var menu = linq.Menu.FirstOrDefault(el => el.ID == ID); if (menu != null) { menu.Name = tbMenuName.Text; menu.Details = tbMenuDetails.Text; linq.SubmitChanges(); MessageBox.Show("Меню успешно изменено"); } } thread.Abort(); dtMenuList.Visible = true; ResetControls(); DrawListmenuInDT(); }
private void btnDeletePersonal_Click(object sender, EventArgs e) { if (dtPersonalList.RowCount > 0) { var IdPersonal = Convert.ToInt16(dtPersonalList.SelectedRows[0].Tag); if (IdPersonal != 0) { dtPersonalList.Visible = false; Thread thread = new Thread(ThreadLoading); thread.Start(); ContextDataContext linq = new ContextDataContext(Connection.connection); var persona = linq.Personal.FirstOrDefault(el => el.ID == IdPersonal); if (persona != null) { linq.Personal.DeleteOnSubmit(persona); linq.SubmitChanges(); MessageBox.Show("Сотрудник был удален"); } thread.Abort(); dtPersonalList.Visible = true; } } }
public Form1() { InitializeComponent(); // cream instanta a clasei OleDbConnection linq = new ContextDataContext(connection); }