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