private void Yes_Click(object sender, EventArgs e)
{
if (comboBox4.Text != "" && comboBox9.Text != "" && comboBox5.Text != "" && comboBox8.Text != "")
{
string login = "";
c.Open();
string sql1 = $"SELECT Login FROM Agency WHERE Agency.Name = '{comboBox8.Text}' ";
MySqlCommand command1 = new MySqlCommand(sql1, c);
MySqlDataReader reader1 = command1.ExecuteReader();
reader1.Read();
login = reader1[0].ToString();
c.Close();
c.Open();
string sql = "";
if (Yes.Text == "Добавить")
{
sql = $"INSERT INTO Voucher (ID, idTypeRoom, NumNights, DateHotel, login, CodeAirport, Status) " +
$"VALUES ('{textBox2.Text}','{CurIDRomms[comboBox4.SelectedIndex]}','{textBox1.Text}' , " +
$"STR_TO_DATE('{dateTimePicker1.Value.ToShortDateString().Replace('.', '-')}','%d-%m-%Y'),'{login}'," +
$"'{comboBox9.Text.Split(' ')[0]}','{comboBox5.Text}')";
}
else
{
sql = $"UPDATE Voucher SET idTypeRoom = (SELECT Room.id FROM Room, Hotel WHERE Room.TypeRoom='{comboBox4.Text}' AND Hotel.Name = '{comboBox1.Text}' AND Room.IdHotel= Hotel.ID), NumNights = '{textBox1.Text}', " +
$"DateHotel = STR_TO_DATE('{dateTimePicker1.Value.ToShortDateString().Replace('.', '-')}','%d-%m-%Y'), " +
$"login = '******', CodeAirport ='{comboBox9.Text.Split(' ')[0]}' , Status ='{comboBox5.Text}' " +
$"WHERE ID = '{textBox2.Text}'";
}
MySqlCommand command = new MySqlCommand(sql, c);
command.ExecuteNonQuery();
c.Close();
Close();
Point p = ((Vouchers)Form.State).Location;
Form.Controls.Remove(Form.State);
Vouchers a = new Vouchers(Form);
Form.State = a;
Form.Controls.Add(a);
a.Location = p;
a.Visible = true;
a.Show();
Form.panel12.Visible = true;
}
else
{
MyMessageBox mmb = new MyMessageBox(Form, "Ошибка", "Введите значение", "ОК", "", "ОК", "");
mmb.Show();
}
}
private void ButtonHome1_Click(object sender, EventArgs e)
{
string name = "";
try
{
Panel p = (Panel)sender;
name = f.GetNameOfButton(p);
}
catch { }
try
{
Label l = (Label)sender;
name = l.Text;
}
catch { }
try
{
PictureBox pb = (PictureBox)sender;
name = f.GetNameOfButton(panel1, pb);
}
catch { }
if (name != "")
{
if (name != "Выход")
{
for (int i = 0; i < panel1.Controls.Count; i++)
{
if (panel1.Controls[i].GetType() == typeof(Panel))
{
for (int j = 0; j < panel1.Controls[i].Controls.Count; j++)
{
if (panel1.Controls[i].Controls[j].GetType() == typeof(Panel))
{
panel1.Controls[i].Controls[j].Visible = false;
}
}
}
}
}
if (name == "Турагентства")
{
Controls.Remove(State);
Agencies ag = new Agencies(this);
State = ag;
this.Controls.Add(ag);
ag.Location = new Point(panel3.Location.X + panel3.Size.Width, panel3.Location.Y + panel3.Size.Height + PanelForm.Size.Height);
ag.Visible = true;
ag.Show();
panel4.Visible = true;
}
if (name == "Турагентство")
{
Controls.Remove(State);
OneAgency ag = new OneAgency(this, new Touragency(User.Login));
State = ag;
this.Controls.Add(ag);
ag.Location = new Point(panel3.Location.X + panel3.Size.Width, panel3.Location.Y + panel3.Size.Height + PanelForm.Size.Height);
ag.Visible = true;
ag.Show();
panel4.Visible = true;
}
if (name == "SQL запросы")
{
Controls.Remove(State);
SQLQuery sq = new SQLQuery(this);
State = sq;
this.Controls.Add(sq);
sq.Location = new Point(panel3.Location.X + panel3.Size.Width, panel3.Location.Y + panel3.Size.Height + PanelForm.Size.Height);
sq.Visible = true;
sq.Show();
panel17.Visible = true;
}
if (name == "Отели")
{
Controls.Remove(State);
Hotels a = new Hotels(this);
State = a;
this.Controls.Add(a);
a.Location = new Point(panel3.Location.X + panel3.Size.Width, panel3.Location.Y + panel3.Size.Height + PanelForm.Size.Height);
a.Visible = true;
a.Show();
panel14.Visible = true;
}
if (name == "Авиарейсы")
{
Controls.Remove(State);
Routes a = new Routes(this);
State = a;
this.Controls.Add(a);
a.Location = new Point(panel3.Location.X + panel3.Size.Width, panel3.Location.Y + panel3.Size.Height + PanelForm.Size.Height);
a.Visible = true;
a.Show();
panel15.Visible = true;
}
if (name == "Аккаунты")
{
Controls.Remove(State);
Accounts a = new Accounts(this);
State = a;
this.Controls.Add(a);
a.Location = new Point(panel3.Location.X + panel3.Size.Width, panel3.Location.Y + panel3.Size.Height + PanelForm.Size.Height);
a.Visible = true;
a.Show();
panel16.Visible = true;
}
if (name == "Путевки")
{
Controls.Remove(State);
Vouchers a = new Vouchers(this);
State = a;
this.Controls.Add(a);
a.Location = new Point(panel3.Location.X + panel3.Size.Width, panel3.Location.Y + panel3.Size.Height + PanelForm.Size.Height);
a.Visible = true;
a.Show();
panel12.Visible = true;
}
if (name == "Поиск")
{
Controls.Remove(State);
SearchVouchers a = new SearchVouchers(this);
State = a;
this.Controls.Add(a);
a.BringToFront();
a.Location = new Point(panel3.Location.X + panel3.Size.Width, panel3.Location.Y + panel3.Size.Height + PanelForm.Size.Height - 84);
a.Visible = true;
a.Show();
panel13.Visible = true;
}
if (name == "Выход")
{
MyMessageBox message = new MyMessageBox(this, "Предупреждение", "Выйти из аккаунта?", "Да", "Нет", "Выход_Да", "Выход_Нет");
message.Show();
}
}
}
