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