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