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