public void AddAward(Award award)
{
using (var connection = new SqlConnection(DataBaseConfig.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand())
{
command.CommandText = "AddAward";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@Title", award.Title);
command.Parameters.AddWithValue("@Description", award.Description);
command.ExecuteNonQuery();
}
connection.Close();
}
}
public void DeleteUser(User user)
{
using (var connection = new SqlConnection(DataBaseConfig.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand())
{
command.CommandText = "DeleteUser";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@Firstname", user.FirstName);
command.Parameters.AddWithValue("@lastname", user.LastName);
command.Parameters.AddWithValue("@BirthDay", user.DateOfBirthDay);
command.ExecuteNonQuery();
}
connection.Close();
}
}
public IEnumerable <User> GetUsersList()
{
List <User> users = new List <User>();
using (var connection = new SqlConnection(DataBaseConfig.GetConnectionString()))
{
connection.Open();
using (SqlCommand command = new SqlCommand("GetAwards", connection))
{
command.CommandType = CommandType.StoredProcedure;
var reader = command.ExecuteReader();
while (reader.Read())
{
var user = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetDateTime(3));
users.Add(user);
}
reader.Close();
}
connection.Close();
}
return(users);
}
public IEnumerable <Award> GetAwardsList()
{
List <Award> awards = new List <Award>();
using (var connection = new SqlConnection(DataBaseConfig.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand("GetAwards", connection))
{
command.CommandType = CommandType.StoredProcedure;
var reader = command.ExecuteReader();
while (reader.Read())
{
var award = new Award(reader.GetInt32(0), reader.GetString(1), reader[2]?.ToString());
awards.Add(award);
}
reader.Close();
}
connection.Close();
}
return(awards);
}