private void UserAdd(string query)
{
try
{
con.Open();
SqlCommand register = new SqlCommand(query, con);
register.ExecuteNonQuery();
var UsersForm = new aUsers
{
Location = Location
};
UsersForm.Show();
MessageBox.Show("Пользователь: " + metroTextBox3.Text + " добавлен в базу Информационной Системы WSR.", "WSR: Информация",
MessageBoxButtons.OK, MessageBoxIcon.Information);
Hide();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
private void DeleteUser_Click(object sender, EventArgs e)
{
try
{
con.Open();
var command = new SqlCommand("dbo.sp_DeleteUser", con)
{
CommandType = System.Data.CommandType.StoredProcedure
};
var userMail = new SqlParameter
{
ParameterName = "@email",
Value = Сonnection.EditMail
};
command.Parameters.Add(userMail);
command.ExecuteNonQuery();
MessageBox.Show("Пользователь успешно удалён!", "WSR: Удаление",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
var UsersForm = new aUsers();
Location = Location;
UsersForm.Show();
Hide();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
}
private void MetroTile1_Click(object sender, EventArgs e)
{
var UsersForm = new aUsers
{
Location = Location
};
UsersForm.Show();
Hide();
}
private void UpdateUser()
{
string query = null;
query = "UPDATE Users " +
"SET FirstName = '" + userInfo1.Text + "'," +
" LastName = '" + userInfo2.Text + "'," +
" RoleId = '" + userInfo3.Text + "' ";
if ((metroTextBox4.Text != "" && metroTextBox5.Text != "") && (metroTextBox4.Text == metroTextBox5.Text))
{
query += ",Password = '******' ";
}
query += "WHERE Email ='" + metroLabel11.Text + "'; ";
if (metroPanel1.Enabled)
{
query += "UPDATE Runner " +
"SET DateOfBirth = '" + runnerDateTime1.Value.ToString("yyyy-MM-dd") + "'," +
" Gender = '" + runnerCombo1.Text + "'," +
" CountryCode = '" + runnerCombo2.Text + "' " +
"WHERE Email ='" + metroLabel11.Text + "'; ";
}
else
{
if (Role == 'R') // Sponsorship -> RegistrationEvent -> Registration -> Runner
{
query += "DELETE FROM Sponsorship WHERE RegistrationId =" +
" (SELECT RegistrationId FROM Registration WHERE RunnerId = " +
"(SELECT RunnerId FROM Runner WHERE Email = '" + metroLabel11.Text + "')); ";
// При обновлении Бегуна на другую роль этот код удаляет его из 4 таблиц (удаление дубликата с R-ролью)
query += "DELETE FROM RegistrationEvent WHERE RegistrationId =" +
" (SELECT RegistrationId FROM Registration WHERE RunnerId = " +
"(SELECT RunnerId FROM Runner WHERE Email = '" + metroLabel11.Text + "')); ";
// Порядок удаления нельзя менять, конфликты FK
query += "DELETE FROM Registration WHERE RunnerId = '" + wsrDataSetUsers1.Tables[1].Rows[0][3].ToString() + "';" +
" DELETE FROM Runner WHERE Email = '" + metroLabel11.Text + "'; ";
}
}
try
{
con.Open();
var updateQuery = new SqlCommand(query, con);
updateQuery.ExecuteNonQuery();
MessageBox.Show("Информация пользователя " + userInfo1.Text + " успешно обновлена.", "WSR: Обновление", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
var UsersForm = new aUsers
{
Location = Location
};
UsersForm.Show();
Hide();
Role = '\0';
}
}
