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("Введите логин"); } }