internal static Client GetClientById(int id)
{
using (SqlConnection connection = new SqlConnection(ActualConnectionString.Get()))
{
SqlCommand command = new SqlCommand("GetClientByID");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Client client = new Client();
client.Id = id;
client.Passport = reader["Паспорт"].ToString();
client.FullName = reader["ФИО"].ToString();
client.Phone = reader["Телефон"].ToString();
client.AddDrivingCategory(DrivingCategoryDAO.GetClientsDrivingCategories(client));
return(client);
}
}
}
return(null);
}
public static IEnumerable <Client> GetClients()
{
List <Client> сlients = new List <Client>();
using (SqlConnection connection = new SqlConnection(ActualConnectionString.Get()))
{
SqlCommand command = new SqlCommand("GetClients");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Client client = new Client();
client.Id = int.Parse(reader["ID_Клиент"].ToString());
client.Passport = reader["Паспорт"].ToString();
client.FullName = reader["ФИО"].ToString();
client.Phone = reader["Телефон"].ToString();
client.AddDrivingCategory(DrivingCategoryDAO.GetClientsDrivingCategories(client));
сlients.Add(client);
}
}
return(сlients);
}