private void btnNext_Click(object sender, EventArgs e)
{
var db = new dbprovider();
var room_id = db.SqlExec($"SELECT uid FROM rooms WHERE room_number = {guests_to_add[0].roomN}")[0][0];
for (int i = 0; i < guests_to_add.Count(); i++)
{
db.SqlExec($"INSERT INTO guests(name, surname, patronymic, used_room_id, date_of_arrival, date_of_leaving) VALUES('{guests_to_add[i].name}', '{guests_to_add[i].surname}', '{guests_to_add[i].patronymic}', {room_id}, GETDATE(), GETDATE())");
}
var res = MessageBox.Show("Заддные успешно занесены", "Успешно", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (res == DialogResult.OK)
{
this.Close();
}
}
private void tryAuth()
{
if (!string.IsNullOrEmpty(tblogin.Text))
{
if (!string.IsNullOrEmpty(tbpassword.Text))
{
var sqlresult = db.SqlExec($"SELECT uid FROM emp_accounts WHERE username = '******'");
if (sqlresult.Count() == 1)
{
sqlresult = db.SqlExec($"SELECT info_id FROM emp_accounts WHERE username = '******' AND password = '******'");
if (sqlresult.Count() == 1)
{
sqlresult = db.SqlExec($"SELECT i.surname, i.name, i.patronymic, r.rank_name, rank_access_level FROM emp_info i JOIN emp_accounts a ON i.uid = {sqlresult[0][0]} JOIN ranks r ON r.uid = a.rank_id");
labelAuthName.Text = $"{sqlresult[0][0]} {sqlresult[0][1]} {sqlresult[0][2]} [{sqlresult[0][3]}]";
user = new User(sqlresult[0][0], sqlresult[0][1], int.Parse(sqlresult[0][4]));
if (user.getLvl() == 4)
{
btnAdmin.Visible = true;
}
togglePanels(panelAuth, panelMain, false);
}
else
{
showError("Введен неверный пароль.");
}
}
else
{
showError("Не найден такой пользователь.");
}
}
else
{
showError("Введите пароль");
}
}
else
{
showError("Введите логин");
}
}
