public ConnectionWizard() { InitializeComponent(); DatabaseControlService.ReadINI(); UserName.Text = DatabaseControlService.UserName; DataSource.Text = DatabaseControlService.DataSource; if (DatabaseControlService.SavePassword) { ConnectBySQL.Checked = true; string Pass = ""; DatabaseControlService.PasswordLoad(ref Pass); Password.Text = Pass; UpdateMask(); PasswordCheck.Checked = true; } else { UpdateParameters(); PasswordCheck.Enabled = false; } if (DatabaseControlService.ConnectString != "") { ConnectionString.Text = DatabaseControlService.ConnectString; } UpdateConnectString(); }
public void FormStart() { AutoCombo.Items.Clear(); ClientCombo.Items.Clear(); DatabaseControlService.LoadComboData("SELECT Auto_ID,ManafacturerName,Model FROM dbo.AutomobilesData INNER JOIN dbo.Manafacturers ON dbo.AutomobilesData.Manafacturer_ID = dbo.Manafacturers.Manafacturer_ID", AutoCombo, IndexMassiveAuto); DatabaseControlService.LoadComboData("SELECT Client_ID, Family, Name, Surname FROM Clients", ClientCombo, IndexMassiveClients); }
private void AutoCombo_SelectedIndexChanged(object sender, EventArgs e) { if (AutoCombo.SelectedIndex != -1) { string No_PTC = ""; string Query = "SELECT No_PTC FROM Sells WHERE Sell_ID = " + IndexMassiveAuto[AutoCombo.SelectedIndex]; DatabaseControlService.SQL.SqlProcduceCommand(Query); if (DatabaseControlService.SQL.DataTableHasValues()) { No_PTC = DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][0].ToString(); } Query = "SELECT Sell_ID,No_body, No_engine, No_PTC, Warranty, Cost, Office_Name FROM dbo.Sells INNER JOIN dbo.AutomobilesData ON dbo.Sells.Auto_ID = dbo.AutomobilesData.Auto_ID INNER JOIN dbo.Offices ON dbo.Sells.Office_ID = dbo.Offices.Office_ID WHERE No_PTC = '" + No_PTC + "'"; DatabaseControlService.SQL.SqlProcduceCommand(Query); if (DatabaseControlService.SQL.DataTableHasValues()) { AutoIndex = Convert.ToInt32(DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][0].ToString()); NoBody.Text = DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][1].ToString(); NoEngine.Text = DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][2].ToString(); NoPTC.Text = DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][3].ToString(); Warranty.Text = DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][4].ToString(); AutoCost.Text = DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][5].ToString(); Office.Text = DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][6].ToString(); WorkerCombo.Items.Clear(); DatabaseControlService.LoadComboData("SELECT Worker_ID, Family, Name, Surname FROM Workers WHERE Office_ID = " + DatabaseControlService.DBECS.GetOfficeIDByOfficeName(Office.Text), WorkerCombo, IndexMassiveWorkers); } } else { Discount.Text = ""; SellCost.Text = ""; } }
private void buttonUpdate_Click(object sender, EventArgs e) { switch (PageID) { case 1: { DBAutomobileEditor.CallEdit(dataGridView1); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBAutomobilesData.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); break; } case 2: { DBClientEditor.CallEdit(dataGridView1); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBClients.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); break; } case 3: { DBOfficeEditor.CallEdit(dataGridView1); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBOffices.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); break; } case 4: { DBOrderEditor.CallEdit(dataGridView1); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBOrders.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); break; } case 5: { DBPresenceCarEditor.CallEdit(dataGridView1); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBPresenceCars.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); break; } case 8: { DBWorkerEditor.CallEdit(dataGridView1); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBWorkers.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); break; } default: { MessageBox.Show("О неееееееет!!!!!!!", "Гипер-пупер ошибка века!", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } }
public void LoadData() { DatabaseControlService.StandartSelectQuery(TableName, TableValueName, TableIDName, MainID); if (DatabaseControlService.SQL.DataTableHasValues()) { MainValue = DatabaseControlService.SQL.SQLDS.Tables["Table"].Rows[0][0].ToString(); } }
private void Exit() { if (ConnectStatus != 1) { DatabaseControlService.DataSource = DataSource.Text; DatabaseControlService.WriteINI(); Application.Exit(); } }
private void button3_Click(object sender, EventArgs e) { SmallSelector DBSmallSelector = new SmallSelector(); DBSmallSelector.Call(6); DBSmallSelector.Dispose(); LanguageCombo.Items.Clear(); DatabaseControlService.LoadComboData("SELECT LanguageName FROM Languages", LanguageCombo); }
public void FormStart() { AutoCombo.Items.Clear(); ColorCombo.Items.Clear(); OfficeCombo.Items.Clear(); DatabaseControlService.LoadComboData("SELECT Auto_ID,ManafacturerName,Model FROM dbo.AutomobilesData INNER JOIN dbo.Manafacturers ON dbo.AutomobilesData.Manafacturer_ID = dbo.Manafacturers.Manafacturer_ID", AutoCombo, IndexesMassiveAuto); DatabaseControlService.LoadComboData("SELECT ColorName FROM Colors", ColorCombo); DatabaseControlService.LoadComboData("SELECT Office_Name FROM Offices", OfficeCombo); }
public bool CheckAll() { DatabaseControlService.StandartSelectQuery(TableName, TableValueName, TableValueName, MainValue); if (DatabaseControlService.SQL.DataTableHasValues()) { return(true); } return(false); }
public void FormStart() { ManafacturerCombo.Items.Clear(); ClassCombo.Items.Clear(); CountryCombo.Items.Clear(); BodyCombo.Items.Clear(); GearCombo.Items.Clear(); DatabaseControlService.LoadComboData("SELECT ManafacturerName FROM Manafacturers", ManafacturerCombo); DatabaseControlService.LoadComboData("SELECT ClassName FROM Classes", ClassCombo); DatabaseControlService.LoadComboData("SELECT CountryName FROM Countries", CountryCombo); DatabaseControlService.LoadComboData("SELECT BodyName FROM BodyTypes", BodyCombo); DatabaseControlService.LoadComboData("SELECT GearName FROM GearTypes", GearCombo); }
public void LoadData(DataSet DS, int RowNumber) { if (DatabaseControlService.SQL.DataTableHasValues(DS, "Table", RowNumber)) { Auto_ID = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][0]); Release_Date = Convert.ToDateTime(DS.Tables["Table"].Rows[RowNumber][1]); Manafacturer_ID = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][2]); Model = DS.Tables["Table"].Rows[RowNumber][3].ToString(); Class_ID = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][4]); Country_ID = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][5]); Warranty = Convert.ToDecimal(DatabaseControlService.ConvertDecimal(DS.Tables["Table"].Rows[RowNumber][6].ToString())); Body_ID = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][7]); DoorsNumber = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][8]); PlacesNumber = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][9]); MaxSpeed = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][10]); MotorVolume = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][11]); HP = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][12]); RPM = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][13]); Torque = DS.Tables["Table"].Rows[RowNumber][14].ToString(); CylindersAligment = DS.Tables["Table"].Rows[RowNumber][15].ToString(); CylindersNumber = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][16]); CylinderValves = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][17]); Acceleration = Convert.ToDecimal(DatabaseControlService.ConvertDecimal(DS.Tables["Table"].Rows[RowNumber][18].ToString())); Braking = Convert.ToDecimal(DatabaseControlService.ConvertDecimal(DS.Tables["Table"].Rows[RowNumber][19].ToString())); TransmissionNumberM = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][20]); TransmissionNumberA = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][21]); EnginePosition = DS.Tables["Table"].Rows[RowNumber][22].ToString(); Gear_ID = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][23]); GDM = DS.Tables["Table"].Rows[RowNumber][24].ToString(); FuelTank = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][25]); FuelMethod = DS.Tables["Table"].Rows[RowNumber][26].ToString(); FuelType = DS.Tables["Table"].Rows[RowNumber][27].ToString(); StMass = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][28]); GVW = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][29]); Size = DS.Tables["Table"].Rows[RowNumber][30].ToString(); WheelsBase = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][31]); GroundClearance = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][32]); MaxAmountTrunk = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][33]); MinAmountTrunk = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][34]); FrontBrakes = DS.Tables["Table"].Rows[RowNumber][35].ToString(); RearBrakes = DS.Tables["Table"].Rows[RowNumber][36].ToString(); FuelCity = Convert.ToDecimal(DatabaseControlService.ConvertDecimal(DS.Tables["Table"].Rows[RowNumber][37].ToString())); FuelHighway = Convert.ToDecimal(DatabaseControlService.ConvertDecimal(DS.Tables["Table"].Rows[RowNumber][38].ToString())); FuelCombined = Convert.ToDecimal(DatabaseControlService.ConvertDecimal(DS.Tables["Table"].Rows[RowNumber][39].ToString())); Turbo = Convert.ToBoolean(DS.Tables["Table"].Rows[RowNumber][40]); ABS = Convert.ToBoolean(DS.Tables["Table"].Rows[RowNumber][41]); SteeringPowerer = Convert.ToBoolean(DS.Tables["Table"].Rows[RowNumber][42]); Spoiler = Convert.ToBoolean(DS.Tables["Table"].Rows[RowNumber][43]); Cost = Convert.ToDecimal(DatabaseControlService.ConvertDecimal(DS.Tables["Table"].Rows[RowNumber][44].ToString())); } }
private void buttonUpdate_Click(object sender, EventArgs e) { if (PageID != 4) { DBSmallEditor.CallEdit(PageID, dataGridView1); } else { DBCountryEditor.CallEdit(dataGridView1); } Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); }
public void LoadData(DataSet DS, int RowNumber) { if (DatabaseControlService.SQL.DataTableHasValues(DS, "Table", RowNumber)) { Client_ID = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][0]); Family = DS.Tables["Table"].Rows[RowNumber][1].ToString(); Name = DS.Tables["Table"].Rows[RowNumber][2].ToString(); Surname = DS.Tables["Table"].Rows[RowNumber][3].ToString(); Discount = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][4]); Purchases = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][5]); Orders_Count = Convert.ToInt32(DS.Tables["Table"].Rows[RowNumber][6]); Telephone = DS.Tables["Table"].Rows[RowNumber][7].ToString(); Address = DS.Tables["Table"].Rows[RowNumber][8].ToString(); Total_Spended = Convert.ToDecimal(DatabaseControlService.ConvertDecimal(DS.Tables["Table"].Rows[RowNumber][9].ToString())); } }
private void Execute(string TableName, int ID, string Names) { if (EditorMode == 1) { if (CheckData()) { DatabaseControlService.ExecuteUpdate(TableName, ID, Names); EditorMode = 0; this.Close(); } } else { if (CheckData()) { DatabaseControlService.ExecuteInsert(TableName, Names); this.Close(); } } }
private void button1_Click(object sender, EventArgs e) { if (ConnectionString.Text != "") { if (DatabaseControlService.SQL.CheckConnection(ConnectString)) { DatabaseControlService.SQL.ConnectString = ConnectString; MessageBox.Show("Подключение успешно! Приятной работы", "Подключение установлено!", MessageBoxButtons.OK, MessageBoxIcon.Information); ConnectStatus = 1; if (PasswordCheck.Checked) { DatabaseControlService.PasswordSave(Password.Text); } DatabaseControlService.DataSource = DataSource.Text; DatabaseControlService.SavePassword = PasswordCheck.Checked; DatabaseControlService.UserName = UserName.Text; UpdateMask(); if (PasswordCheck.Checked) { DatabaseControlService.ConnectString = ConnectionString.Text; } else if (PasswordMask != "") { DatabaseControlService.ConnectString = ConnectionString.Text.Replace(PasswordMask, " "); } this.Close(); } else { MessageBox.Show("Не удалось подключиться!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Запоните строку подключения!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void MainForm_FormClosed(object sender, FormClosedEventArgs e) { DatabaseControlService.LastPage = PageID; DatabaseControlService.WriteINI(); }
private void buttonDelete_Click(object sender, EventArgs e) { switch (PageID) { case 1: { DBAutomobilesData.LoadData(dataGridView1); if (!DBAutomobilesData.CheckUse()) { DatabaseControlService.SQL.SqlProcduceTransactionCommand(DBAutomobilesData.Delete()); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBAutomobilesData.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } else { MessageBox.Show("Элемент используется! Удаление невозможно!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; } case 2: { DBClients.LoadData(dataGridView1); if (!DBClients.CheckUse()) { DatabaseControlService.SQL.SqlProcduceTransactionCommand(DBClients.Delete()); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBClients.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } else { MessageBox.Show("Элемент используется! Удаление невозможно!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; } case 3: { DBOffices.LoadData(dataGridView1); if (!DBOffices.CheckUse()) { DatabaseControlService.SQL.SqlProcduceTransactionCommand(DBOffices.Delete()); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBOffices.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } else { MessageBox.Show("Элемент используется! Удаление невозможно!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; } case 4: { DBOrders.LoadData(dataGridView1); if (!DBOrders.CheckUse()) { DatabaseControlService.SQL.SqlProcduceTransactionCommand(DBOrders.Delete()); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBOrders.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } else { MessageBox.Show("Элемент используется! Удаление невозможно!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; } case 5: { DBPresenceCars.LoadData(dataGridView1); if (!DBPresenceCars.CheckUse()) { DatabaseControlService.SQL.SqlProcduceTransactionCommand(DBPresenceCars.Delete()); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBPresenceCars.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } else { MessageBox.Show("Элемент используется! Удаление невозможно!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; } case 7: { DBSells.LoadData(dataGridView1); if (!DBSells.CheckUse()) { DatabaseControlService.SQL.SqlProcduceTransactionCommand(DBSells.Delete()); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBSells.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } else { MessageBox.Show("Элемент используется! Удаление невозможно!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; } case 8: { DBWorkers.LoadData(dataGridView1); if (!DBWorkers.CheckUse()) { DatabaseControlService.SQL.SqlProcduceTransactionCommand(DBWorkers.Delete()); DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBWorkers.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } else { MessageBox.Show("Элемент используется! Удаление невозможно!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; } default: { MessageBox.Show("О неееееееет!!!!!!!", "Гипер-пупер ошибка века!", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } }
public void UpdateData(int TableID) { switch (TableID) { case 1: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBAutomobilesData.ViewAll()); PageID = 1; TableName = "Автомобили"; DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); InfoString.Text = "База автомобилей загружена!"; break; } case 2: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBClients.ViewAll()); PageID = 2; TableName = "Клиенты"; DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); InfoString.Text = "База клиентов загружена!"; break; } case 3: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBOffices.ViewAll()); PageID = 3; TableName = "Офисы продаж"; DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); InfoString.Text = "База офисов продаж загружена!"; break; } case 4: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBOrders.ViewAll()); PageID = 4; TableName = "Заказы"; DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); InfoString.Text = "База заказов загружена!"; break; } case 5: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBPresenceCars.ViewAll()); PageID = 5; TableName = "Автомобили в наличие"; DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); InfoString.Text = "База автомобилей в наличии загружена!"; break; } case 6: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBSelledCars.ViewAll()); PageID = 6; TableName = "Проданные автомобили"; DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); InfoString.Text = "База проданных автомобилей загружена!"; break; } case 7: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBSells.ViewAll()); PageID = 7; TableName = "Продажи"; DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); InfoString.Text = "База продаж загружена!"; break; } case 8: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBWorkers.ViewAll()); PageID = 8; TableName = "Работники"; DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); InfoString.Text = "База работников загружена!"; break; } default: { break; } } }
public static void LoadFromXML() { DatabaseControlService.XMLLoad("Manafacturers"); }
public void GetID() { string Query = "SELECT Auto_ID FROM AutomobilesData WHERE Release_Date = " + Release_Date + " AND Manafacturer_ID = " + Manafacturer_ID + " AND Model = '" + Model + "' AND Class_ID = '" + Class_ID + "' AND Country_ID = " + Country_ID + " AND Warranty = " + Warranty + " AND Body_ID = " + Body_ID + " AND DoorsNumber = " + DoorsNumber + " AND PlacesNumber = " + PlacesNumber + " AND MaxSpeed = " + MaxSpeed + " AND MotorVolume = " + MotorVolume + " AND HP = " + HP + " AND RPM = " + RPM + " AND Torque = '" + Torque + "' AND CylindersAligment = '" + CylindersAligment + "' AND CylindersNumber = " + CylindersNumber + " AND CylinderValves = " + CylinderValves + " AND Acceleration = " + Acceleration + " AND Braking =" + Braking + " AND TransmissionNumberM = " + TransmissionNumberM + " AND TransmissionNumberA = " + TransmissionNumberA + " AND EnginePosition = '" + EnginePosition + "' AND Gear_ID = " + Gear_ID + " AND GDM = '" + GDM + "' AND FuelTank = " + FuelTank + " AND FuelMethod = '" + FuelMethod + "' AND FuelType = '" + FuelType + "' AND StMass = " + StMass + " AND GVW = " + GVW + " AND Size = '" + Size + "' AND WheelsBase = " + WheelsBase + " AND GroundClearance = " + GroundClearance + " AND MaxAmountTrunk = " + MaxAmountTrunk + " AND MinAmountTrunk = " + MinAmountTrunk + " AND FrontBrakes = '" + FrontBrakes + "' AND RearBrakes = '" + RearBrakes + "' AND FuelCity = " + FuelCity + " AND FuelHighway = " + FuelHighway + " AND FuelCombined = " + FuelCombined + " AND Turbo = " + Turbo + " AND ABS = " + ABS + " AND SteeringPowerer = " + SteeringPowerer + " AND Spoiler = " + Spoiler + " AND Cost = " + Cost; Auto_ID = DatabaseControlService.GetElementID(Query, 0); }
public void Update(int TableID) { switch (TableID) { case 1: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBBodyTypes.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); this.Text = "Список типов кузова..."; break; } case 2: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBClasses.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); this.Text = "Список классов автомобилей..."; break; } case 3: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBColors.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); this.Text = "Список цветов..."; break; } case 4: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBCountries.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); this.Text = "Список стран..."; break; } case 5: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBGearTypes.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); this.Text = "Список типов привода..."; break; } case 6: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBLanguages.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); this.Text = "Список языков..."; break; } case 7: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBManafacturers.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); this.Text = "Список производителей..."; break; } case 8: { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBWorkplaces.ViewAll()); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); this.Text = "Список должностей..."; break; } default: { MessageBox.Show("О неееееееет!!!!!!!", "Гипер-пупер ошибка века!", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } PageID = TableID; }
public static void SaveToXML() { DatabaseControlService.XMLSave("Workplaces"); }
public static void LoadFromXML() { DatabaseControlService.XMLLoad("Workplaces"); }
public static void SaveToXML() { DatabaseControlService.XMLSave("Colors"); }
public static void SaveToXML() { DatabaseControlService.XMLSave("Languages"); }
public void GetID() { string Query = "SELECT Country_ID FROM Countries WHERE CountryName = ('" + CountryName + "') AND Language_ID = " + Language_ID; Country_ID = DatabaseControlService.GetElementID(Query, 0); }
public static void LoadFromXML() { DatabaseControlService.XMLLoad("Languages"); }
private void buttonDelete_Click(object sender, EventArgs e) { switch (PageID) { case 1: { DBBodyTypes.LoadData(dataGridView1); if (!DBBodyTypes.CheckUse()) { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBBodyTypes.Delete()); Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } break; } case 2: { DBClasses.LoadData(dataGridView1); if (!DBClasses.CheckUse()) { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBClasses.Delete()); Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } break; } case 3: { DBColors.LoadData(dataGridView1); if (!DBColors.CheckUse()) { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBColors.Delete()); Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } break; } case 4: { DBCountries.LoadData(dataGridView1); if (!DBCountries.CheckUse()) { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBCountries.Delete()); Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } break; } case 5: { DBGearTypes.LoadData(dataGridView1); if (!DBGearTypes.CheckUse()) { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBGearTypes.Delete()); Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } break; } case 6: { DBLanguages.LoadData(dataGridView1); if (!DBLanguages.CheckUse()) { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBLanguages.Delete()); Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } UpdateButtons(); break; } case 7: { DBManafacturers.LoadData(dataGridView1); if (!DBManafacturers.CheckUse()) { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBManafacturers.Delete()); Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } break; } case 8: { DBWorkplaces.LoadData(dataGridView1); if (!DBWorkplaces.CheckUse()) { DatabaseControlService.SQL.SqlProcduceCommand(dataGridView1, DBWorkplaces.Delete()); Update(PageID); DatabaseControlService.DataGridSelectLast(dataGridView1); UpdateButtons(); } break; } default: { MessageBox.Show("О неееееееет!!!!!!!", "Гипер-пупер ошибка века!", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } }
public static void LoadFromXML() { DatabaseControlService.XMLLoad("Colors"); }
public static void SaveToXML() { DatabaseControlService.XMLSave("Manafacturers"); }