private void button3_Click(object sender, EventArgs e)
{
#region Проверка ошибок
if (LoginTextBox.Text == "")
{
return;
}
List <string> existUser = SQLClass.Select(
"SELECT * FROM users WHERE login = '******'");
if (existUser.Count > 0)
{
MessageBox.Show("Пользователь с таким логином существует");
return;
}
#endregion
SQLClass.Update("UPDATE users SET" +
" name = '" + textBox2.Text + "'," +
" city = '" + CityComboBox.Text + "'," +
" age = '" + textBox1.Text + "'," +
" login = '******'," +
" password = '******'" +
" WHERE login = '******'");
SQLClass.Update("UPDATE booking SET" +
" user = '******'" +
" WHERE user = '******'");
SQLClass.Update("UPDATE rating SET" +
" user = '******'" +
" WHERE user = '******'");
MainForm.Login = LoginTextBox.Text;
}
private void button1_Click(object sender, EventArgs e)
{
#region Провера ошибок
if (MainForm.Login == "")
{
MessageBox.Show("Вы не авторизованы");
return;
}
DateTime dt = dateTimePicker1.Value;
while (dt <= dateTimePicker2.Value.AddDays(0.5))
{
List <string> existBooking = SQLClass.Select("SELECT COUNT(*) FROM booking " +
"WHERE dateFrom <= '" + dt.ToString("yyyy-MM-dd") + "'" +
"AND dateTo >= '" + dt.ToString("yyyy-MM-dd") + "'");
if (Convert.ToInt32(existBooking[0]) >= qty)
{
MessageBox.Show("Все забронировано. Выберите другие даты!");
return;
}
dt = dt.AddDays(1);
}
#endregion
SQLClass.Update("INSERT INTO booking(user, datefrom, dateto, room_id) VALUES(" +
"'" + MainForm.Login + "', " +
"'" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "'," +
"'" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "'," +
id + ")");
MessageBox.Show("Успешно");
}
private void button1_Click(object sender, EventArgs e)
{
SQLClass.Update(
"UPDATE " + SQLClass.HOTELS +
" SET name = '" + textBox2.Text + "', " +
" description = '" + textBox3.Text + "'" +
" WHERE id = '" + id + "'");
}
private void button1_Click(object sender, EventArgs e)
{
SQLClass.Update(
"INSERT INTO " + SQLClass.HOTELS + " (Name, City, Rating, Image)" +
" VALUES('" + textBox1.Text + "', '" + textBox2.Text + "', '" +
textBox3.Text + "', '" + address + "')");
MessageBox.Show("Сохранено");
}
private void OpinionCLick(object sender, EventArgs e)
{
SQLClass.Update("INSERT INTO rating(user, hotel_id, rate, comment) VALUES(" +
"'" + MainForm.Login + "', " +
"'" + id + "', " +
"'" + numericUpDown1.Value.ToString() + "', " +
"'" + textBox1.Text + "')");
MessageBox.Show("Спасибо");
}
private void button1_Click(object sender, EventArgs e)
{
string[] parts = comboBox1.Text.Split(new char[] { '(', ')' }, StringSplitOptions.RemoveEmptyEntries);
SQLClass.Update(
"INSERT INTO room(Name, hotel, hotel_id, price, Image)" +
" VALUES('" + textBox1.Text + "', '" + parts[0] + "', '" + parts[1] + "', '" +
textBox3.Text + "', '" + address + "')");
MessageBox.Show("Сохранено");
AdminRoomsForm_Load(sender, e);
}
private void textBox4_KeyDown(object sender, KeyEventArgs e)
{
TextBox tb = (TextBox)sender;
if (e.KeyCode == Keys.Enter)
{
SQLClass.Update(
"UPDATE room" +
" SET quantity = '" + tb.Text.Replace("штук", "") + "'" +
" WHERE id = '" + tb.Tag.ToString() + "'");
}
}
private void DeleteRoom(object sender, EventArgs e)
{
Button btn = (Button)sender;
int y = btn.Location.Y;
foreach (Control control in panel2.Controls)
{
if (control.Location == new Point(0, y))
{
SQLClass.Update(
"DELETE FROM room WHERE id = '" + control.Tag.ToString() + "'");
AdminRoomsForm_Load(sender, e);
return;
}
}
}
private void DeleteHotel(object sender, EventArgs e)
{
Button btn = (Button)sender;
int y = btn.Location.Y;
foreach (Control control in panel2.Controls)
{
if (control.Location == new Point(0, y))
{
SQLClass.Update(
"DELETE FROM " + SQLClass.HOTELS + " WHERE Name = '" + control.Text + "'");
AdminHotelsForm_Load(sender, e);
return;
}
}
}
private void button3_Click(object sender, EventArgs e)
{
List <string> exist = SQLClass.Select("SELECT Login FROM users WHERE login = '******'");
if (exist.Count > 0)
{
MessageBox.Show("Вы уже зарегистрированы");
}
else
{
SQLClass.Update("INSERT INTO users(login, password, name, age, city) VALUES(" +
"'" + LoginTextBox.Text + "'," +
"'" + PasswordTextBox.Text + "'," +
"'" + textBox1.Text + "'," +
"'" + textBox2.Text + "'," +
"'" + CityComboBox.Text + "')");
}
}
