public void ButtonClick()
{
if (String.IsNullOrEmpty(window.AddMalfunctionTitle.Text))
{
MessageBox.Show("Поля не заполнены"); return;
}
int idtype = 1;
MySqlDataReader reader = window.ex.returnResult("select idmalfunctions from malfunctions where title='" + window.AddMalfunctionTitle.Text + "'");
if (reader == null)
{
return;
}
if (reader.HasRows)
{
MessageBox.Show("Такое устройство уже добавлено"); window.ex.closeCon(); return;
}
window.ex.closeCon();
reader = window.ex.returnResult("select idtypes from typeofdevices where title='" + window.AddMalfunctionTypeOfDevice.SelectedItem.ToString() + "'");
if (reader.HasRows)
{
while (reader.Read())
{
idtype = reader.GetInt32(0);
}
}
window.ex.closeCon();
window.ex.ExecuteWithoutRedaer("INSERT INTO malfunctions(title,idtypes)VALUES('" + window.AddMalfunctionTitle.Text + "'," + idtype + ")");
window.hd.HideAll();
window.MalfunctionsGrid.Visibility = Visibility.Visible;
DataGridUpdater.MalfunctionsDataGridUpdate(window);
}
public void ButtonClick()
{
DataTable table = new DataTable();
table.Columns.Add("idtypes", System.Type.GetType("System.Int32"));
table.Columns.Add("title", System.Type.GetType("System.String"));
ArrayList list = new ArrayList();
for (int i = 0; i < window.TypesOfDevicesDataGrid.Items.Count - 1; i++)
{
DataRowView DRV = window.TypesOfDevicesDataGrid.Items[i] as DataRowView;
DataRow row = DRV.Row;
object[] rMas = row.ItemArray;
if (rMas[1].ToString() == "")
{
MessageBox.Show("В " + (i + 1) + " строке не указан тип устройства"); return;
}
if (list.IndexOf(rMas[1]) != -1)
{
MessageBox.Show("Повторяется тип устройства " + rMas[1]); return;
}
list.Add(rMas[1]);
table.ImportRow(row);
}
window.ex.AddChangeToSimpleTable("select * from typeofdevices", table);
DataGridUpdater.TypesOfDevicesDataGridUpdate(window);
}
public void ButtonClick()
{
DataRowView DRV = window.UserDataGrid.SelectedItem as DataRowView;
if (DRV == null)
{
MessageBox.Show("Удаление прервано, Вы не выбрали запись для удаления."); return;
}
DataRow DR = DRV.Row;
object[] arr = DR.ItemArray;
MySqlDataReader reader = window.ex.returnResult("select id from orders where id=" + arr[0]);
if (reader == null)
{
return;
}
if (reader.HasRows)
{
window.ex.closeCon(); MessageBox.Show("Невозможно удалить запись"); return;
}
window.ex.closeCon();
window.ex.ExecuteWithoutRedaer("delete from users where id=" + arr[0]);
DataGridUpdater.UserDataGridUpdate(window);
}
public void ButtonClick()
{
window.ex.ExecuteWithoutRedaer("update repairorders set datestart='" + Convert.ToDateTime(window.ChangeDateStartOfRepairOrder.SelectedDate).Year + "-" + Convert.ToDateTime(window.ChangeDateStartOfRepairOrder.SelectedDate).Month + "-" + Convert.ToDateTime(window.ChangeDateStartOfRepairOrder.SelectedDate).Day + "' ,dateend='" + Convert.ToDateTime(window.ChangeDateEndOfRepairOrder.SelectedDate).Year + "-" + Convert.ToDateTime(window.ChangeDateEndOfRepairOrder.SelectedDate).Month + "-" + Convert.ToDateTime(window.ChangeDateEndOfRepairOrder.SelectedDate).Day + "', state='" + window.ChangeStatOfRepairOrder.SelectedItem.ToString().Split(' ')[1] + "', repairorders.desc='" + window.ChangeDescOfRepairOrder.Text + "',costofdetails=" + window.ChangeCostOfDetailsOfRepairOrder.Text.Replace(',', '.').Replace("₴", "") + " where idrepairorders=" + window.repairOrderForChange);
window.hd.HideAll();
window.RepairOrdersGrid.Visibility = Visibility.Visible;
DataGridUpdater.RepairOrdersDataGridUpdate(window);
}
public void MenuClick()
{
DataGridUpdater.UserDataGridUpdate(window);
HideAllGrids hd = new HideAllGrids(window);
hd.HideAll();
window.UsersGrid.Visibility = Visibility.Visible;
}
public void ButtonClick()
{
if (String.IsNullOrEmpty(window.AddOrderPrice.Text) || String.IsNullOrEmpty(window.AddOrderQuantity.Text))
{
MessageBox.Show("Поля не заполненны"); return;
}
int detid = -1;
int userid = -1;
MySqlDataReader reader = window.ex.returnResult("select id from users where login='******'");
if (reader == null)
{
return;
}
if (reader.HasRows)
{
while (reader.Read())
{
userid = reader.GetInt32(0);
}
}
window.ex.closeCon();
reader = window.ex.returnResult("select iddetails from details where title='" + window.AddOrderDetailTitle.SelectedItem.ToString() + "'");
if (reader == null)
{
return;
}
if (reader.HasRows)
{
while (reader.Read())
{
detid = reader.GetInt32(0);
}
}
window.ex.closeCon();
window.ex.ExecuteWithoutRedaer("INSERT INTO orders(`iddetails`,`id`,`orderdate`,`quantity`,`orderprice`,`iscompleet`)VALUES(" + detid + "," + userid + ",'" + Convert.ToDateTime(window.AddOrderDate.SelectedDate).Year + "-" + Convert.ToDateTime(window.AddOrderDate.SelectedDate).Month + "-" + Convert.ToDateTime(window.AddOrderDate.SelectedDate).Day + "'," + window.AddOrderQuantity.Text + "," + window.AddOrderPrice.Text.Replace(',', '.').Replace("₴", "") + ",0)");
window.ex.ExecuteWithoutRedaer("update details set ordered=ordered+" + window.AddOrderQuantity.Text + " where iddetails=" + detid);
window.hd.HideAll();
window.OrdersGrid.Visibility = Visibility.Visible;
if (window.currentUserLogin == "root")
{
window.OrdersOperationForAdminGrid.Visibility = Visibility.Visible;
}
else
{
window.OrdersOperationForManagerGrid.Visibility = Visibility.Visible;
}
DataGridUpdater.OrdersDataGridUpdate(window);
}
public void MenuClick()
{
window.hd.HideAll();
window.OrdersGrid.Visibility = Visibility.Visible;
if (window.currentUserLogin == "root")
{
window.OrdersOperationForAdminGrid.Visibility = Visibility.Visible;
}
else
{
window.OrdersOperationForManagerGrid.Visibility = Visibility.Visible;
}
DataGridUpdater.OrdersDataGridUpdate(window);
}
public void ButtonClick()
{
DataRowView DRV = window.RepairOrdersDataGrid.SelectedItem as DataRowView;
if (DRV == null)
{
MessageBox.Show("Удаление прервано, Вы не выбрали запись для удаления."); return;
}
DataRow DR = DRV.Row;
object[] arr = DR.ItemArray;
window.ex.ExecuteWithoutRedaer("delete from repairorders where idrepairorders=" + arr[0]);
window.ex.ExecuteWithoutRedaer("delete from repairorders_malfunctions where idrepairorders=" + arr[0]);
DataGridUpdater.RepairOrdersDataGridUpdate(window);
}
public void ButtonClick()
{
if (window.AddClientOfRepairOrder.SelectedItem == null)
{
MessageBox.Show("Клиент не выбран"); return;
}
if (window.AddDeviceOfRepairOrder.SelectedItem == null)
{
MessageBox.Show("Устройство не выбрано"); return;
}
window.ex.ExecuteWithoutRedaer("INSERT INTO `repairorders`(`idclients`,`iddevices`,`datestart`,`dateend`,`state`,`desc`)VALUES((select idclients from clients where name='" + window.AddClientOfRepairOrder.SelectedItem.ToString() + "'),(select iddevices from devices where title='" + window.AddDeviceOfRepairOrder.SelectedItem.ToString() + "'),'" + Convert.ToDateTime(window.AddDateStartOfRepairOrder.SelectedDate).Year + "-" + Convert.ToDateTime(window.AddDateStartOfRepairOrder.SelectedDate).Month + "-" + Convert.ToDateTime(window.AddDateStartOfRepairOrder.SelectedDate).Day + "','" + Convert.ToDateTime(window.AddDateEndOfRepairOrder.SelectedDate).Year + "-" + Convert.ToDateTime(window.AddDateEndOfRepairOrder.SelectedDate).Month + "-" + Convert.ToDateTime(window.AddDateEndOfRepairOrder.SelectedDate).Day + "','Принят','" + window.AddDescOfRepairOrder.Text + "')");
window.hd.HideAll();
window.RepairOrdersGrid.Visibility = Visibility.Visible;
DataGridUpdater.RepairOrdersDataGridUpdate(window);
}
public void MenuClick()
{
window.hd.HideAll();
window.DetailsGrid.Visibility = Visibility.Visible;
if (window.currentUserLogin == "root")
{
window.DetailsOperationForAdminGrid.Visibility = Visibility.Visible;
}
else
{
window.DetailsOperationForManagerGrid.Visibility = Visibility.Visible;
}
window.filter.sql = "select * from details";
window.filter.CreateDetailsFiltr(window.FilterDetailsGridAdmin);
DataGridUpdater.DetailsDataGridUpdate(window, window.filter.sql);
}
public void ButtonClick()
{
DataRowView DRV = window.OrdersDataGrid.SelectedItem as DataRowView;
if (DRV == null)
{
MessageBox.Show("Подтверждение прервано, Вы не выбрали запись для подтверждения"); return;
}
DataRow DR = DRV.Row;
object[] arr = DR.ItemArray;
if (arr[6].ToString() == "Получен")
{
MessageBox.Show("Заказ уже получен"); return;
}
window.ex.ExecuteWithoutRedaer("update details set ordered=ordered-" + arr[5] + ", storage=storage+" + arr[5] + " where title = '" + arr[1] + "'");
window.ex.ExecuteWithoutRedaer("update orders set iscompleet=1 where idorders=" + arr[0]);
DataGridUpdater.OrdersDataGridUpdate(window);
}
public void ButtonClick()
{
DataRowView DRV = window.OrdersDataGrid.SelectedItem as DataRowView;
if (DRV == null)
{
MessageBox.Show("Удаление прервано, Вы не выбрали запись для удаления."); return;
}
DataRow DR = DRV.Row;
object[] arr = DR.ItemArray;
if (arr[6].ToString() != "Получен")
{
window.ex.ExecuteWithoutRedaer("update details set ordered=ordered-" + arr[5] + " where title='" + arr[1] + "'");
}
window.ex.ExecuteWithoutRedaer("delete from orders where idorders=" + arr[0]);
DataGridUpdater.OrdersDataGridUpdate(window);
}
public void ButtonClick()
{
DataRowView DRV = window.DetailsDataGrid.SelectedItem as DataRowView;
if (DRV == null)
{
MessageBox.Show("Изменение прервано, Вы не выбрали запись для Изменения"); return;
}
DataRow DR = DRV.Row;
object[] arr = DR.ItemArray;
if (arr[6].ToString() == "Важная")
{
window.ex.ExecuteWithoutRedaer("UPDATE details SET isimportant = 0 WHERE iddetails =" + arr[0]);
}
else
{
window.ex.ExecuteWithoutRedaer("UPDATE details SET isimportant = 1 WHERE iddetails =" + arr[0]);
}
DataGridUpdater.DetailsDataGridUpdate(window, window.filter.sql);
}
public void ButtonClick()
{
DataRowView DRV = window.UserDataGrid.SelectedItem as DataRowView;
if (DRV == null)
{
MessageBox.Show("Подтверждение прервано, Вы не выбрали запись для подтверждения"); return;
}
DataRow DR = DRV.Row;
object[] arr = DR.ItemArray;
if (arr[3].ToString() == "Одобрен")
{
window.ex.ExecuteWithoutRedaer("UPDATE users SET isconfirmed = 0 WHERE id =" + arr[0]);
}
else
{
window.ex.ExecuteWithoutRedaer("UPDATE users SET isconfirmed = 1 WHERE id =" + arr[0]);
}
DataGridUpdater.UserDataGridUpdate(window);
}
public void ButtonClick()
{
if (String.IsNullOrEmpty(window.ChangeLogin.Text) || String.IsNullOrEmpty(window.ChangePass.Text))
{
MessageBox.Show("Поля не заполненны"); return;
}
MySqlDataReader reader = window.ex.returnResult("select id from users where login='******'");
if (reader == null)
{
return;
}
if (reader.HasRows && window.unChangeLogin != window.ChangeLogin.Text)
{
MessageBox.Show("Пользователь с таким логином уже сущесвтует"); window.ex.closeCon(); return;
}
window.ex.closeCon();
window.ex.ExecuteWithoutRedaer("update users set login='******', password='******' where id=" + window.userIdForChange);
window.hd.HideAll();
window.UsersGrid.Visibility = Visibility.Visible;
DataGridUpdater.UserDataGridUpdate(window);
}
public void ButtonClick()
{
DataTable table = new DataTable();
table.Columns.Add("idclients", System.Type.GetType("System.Int32"));
table.Columns.Add("name", System.Type.GetType("System.String"));
table.Columns.Add("phone", System.Type.GetType("System.String"));
ArrayList list = new ArrayList();
for (int i = 0; i < window.ClientsDataGrid.Items.Count - 1; i++)
{
DataRowView DRV = window.ClientsDataGrid.Items[i] as DataRowView;
DataRow row = DRV.Row;
object[] rMas = row.ItemArray;
if (rMas[1].ToString() == "")
{
MessageBox.Show("В " + (i + 1) + " строке не указано имя клиента"); return;
}
if (rMas[2].ToString() == "")
{
MessageBox.Show("В " + (i + 1) + " строке не указан телефон клиента"); return;
}
if (rMas[2].ToString().Length > 12)
{
MessageBox.Show("В " + (i + 1) + " строке не верный телефон клиента"); return;
}
if (list.IndexOf(rMas[2]) != -1)
{
MessageBox.Show("Повторяется телефон клиента " + rMas[2]); return;
}
list.Add(rMas[2]);
table.ImportRow(row);
}
window.ex.AddChangeToSimpleTable("select * from clients", table);
DataGridUpdater.ClientsDataGridUpdate(window);
}
public void ButtonClick()
{
if (String.IsNullOrEmpty(window.ChangeOrderPrice.Text) || String.IsNullOrEmpty(window.ChangeOrderQuantity.Text))
{
MessageBox.Show("Поля не заполненны"); return;
}
int detid = -1;
MySqlDataReader reader = window.ex.returnResult("select iddetails from details where title='" + window.ChangeOrderDetailTitle.Content + "'");
if (reader == null)
{
return;
}
if (reader.HasRows)
{
while (reader.Read())
{
detid = reader.GetInt32(0);
}
}
window.ex.closeCon();
window.ex.ExecuteWithoutRedaer("update orders set orderdate='" + Convert.ToDateTime(window.ChangeOrderDate.SelectedDate).Year + "-" + Convert.ToDateTime(window.ChangeOrderDate.SelectedDate).Month + "-" + Convert.ToDateTime(window.ChangeOrderDate.SelectedDate).Day + "',quantity=" + window.ChangeOrderQuantity.Text + ",orderprice=" + window.ChangeOrderPrice.Text.Replace(',', '.').Replace("₴", "") + " where idorders=" + window.orderIdForChange);
window.ex.ExecuteWithoutRedaer("update details set ordered=ordered-" + window.orderQuantity + "+" + window.ChangeOrderQuantity.Text + " where iddetails=" + detid);
window.hd.HideAll();
window.OrdersGrid.Visibility = Visibility.Visible;
if (window.currentUserLogin == "root")
{
window.OrdersOperationForAdminGrid.Visibility = Visibility.Visible;
}
else
{
window.OrdersOperationForManagerGrid.Visibility = Visibility.Visible;
}
DataGridUpdater.OrdersDataGridUpdate(window);
}
public void ButtonClick()
{
if (String.IsNullOrEmpty(window.ChangeDeviceTitle.Text))
{
MessageBox.Show("Поля не заполнены"); return;
}
int idtype = 1;
MySqlDataReader reader = window.ex.returnResult("select iddevices from devices where title='" + window.ChangeDeviceTitle.Text + "'");
if (reader == null)
{
return;
}
if (reader.HasRows && window.ChangeDeviceTitle.Text != window.unChangeDeviceTitle)
{
MessageBox.Show("Такое устройство уже добавлено"); window.ex.closeCon(); return;
}
window.ex.closeCon();
reader = window.ex.returnResult("select idtypes from typeofdevices where title='" + window.ChangeDeviceTypeOfDevice.SelectedItem.ToString() + "'");
if (reader == null)
{
return;
}
if (reader.HasRows)
{
while (reader.Read())
{
idtype = reader.GetInt32(0);
}
}
window.ex.closeCon();
window.ex.ExecuteWithoutRedaer("update devices set title='" + window.ChangeDeviceTitle.Text + "',idtypes=" + idtype + " where iddevices=" + window.deviceIdForChange);
window.hd.HideAll();
window.DevicesGrid.Visibility = Visibility.Visible;
DataGridUpdater.DevicesDataGridUpdate(window);
}
public void ButtonClick()
{
if (String.IsNullOrEmpty(window.ChangeDetTitle.Text) || String.IsNullOrEmpty(window.ChangeDetPrice.Text) || String.IsNullOrEmpty(window.ChangeDetStorage.Text) || String.IsNullOrEmpty(window.ChangeDetSaled.Text))
{
MessageBox.Show("Поля не заполнены"); return;
}
MySqlDataReader reader = window.ex.returnResult("select iddetails from details where title='" + window.ChangeDetTitle.Text + "'");
if (reader == null)
{
return;
}
if (reader.HasRows && window.unChangeDetailTitle != window.ChangeDetTitle.Text)
{
MessageBox.Show("Такая деталь уже добавленна"); window.ex.closeCon(); return;
}
window.ex.closeCon();
int i = 0;
if (window.ChangeDetIsImportant.IsChecked == true)
{
i = 1;
}
window.ex.ExecuteWithoutRedaer("UPDATE details SET `title` ='" + window.ChangeDetTitle.Text + "',`storage` = " + window.ChangeDetStorage.Text + ",`ordered` = 0,`saled` = " + window.ChangeDetSaled.Text + ",`price` = " + window.ChangeDetPrice.Text.Replace(',', '.').Replace("₴", "") + ",`isimportant` = " + i + " WHERE `iddetails` = " + window.detailIdForChange);
window.hd.HideAll();
window.DetailsGrid.Visibility = Visibility.Visible;
if (window.currentUserLogin == "root")
{
window.DetailsOperationForAdminGrid.Visibility = Visibility.Visible;
}
else
{
window.DetailsOperationForManagerGrid.Visibility = Visibility.Visible;
}
DataGridUpdater.DetailsDataGridUpdate(window, window.filter.sql);
}
public void MenuClick()
{
window.hd.HideAll();
window.MalfunctionsGrid.Visibility = Visibility.Visible;
DataGridUpdater.MalfunctionsDataGridUpdate(window);
}
public void MenuClick()
{
window.hd.HideAll();
window.DevicesGrid.Visibility = Visibility.Visible;
DataGridUpdater.DevicesDataGridUpdate(window);
}
public void MenuClick()
{
window.hd.HideAll();
window.RepairOrdersGrid.Visibility = Visibility.Visible;
DataGridUpdater.RepairOrdersDataGridUpdate(window);
}
public void ButtonClick()
{
window.filter.ApplyDetailsFiltr();
DataGridUpdater.DetailsDataGridUpdate(window, window.filter.sql);
}
