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