public List <CarClassDTO> GetAll()
{
try
{
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sql = "SELECT * FROM CarClass ORDER BY Name";
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
List <CarClassDTO> carClasses = new List <CarClassDTO>();
while (reader.Read())
{
CarClassDTO carClass = new CarClassDTO
{
Id = reader.GetInt32(0),
Name = reader.GetString(1)
};
carClasses.Add(carClass);
}
connection.Close();
return(carClasses);
}
}
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(null);
}
}
public bool Update(CarClassDTO carClass)
{
try
{
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sql = "UPDATE CarClass SET Name = (@Name) WHERE Id = (@Id)";
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
command.Parameters.AddWithValue("@Name", carClass.Name);
command.Parameters.AddWithValue("@Id", carClass.Id);
command.ExecuteNonQuery();
connection.Close();
}
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(false);
}
return(true);
}
public CarClassDTO Get(int carClassId)
{
CarClassDTO carClass = new CarClassDTO();
try
{
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sql = "SELECT * FROM CarClass WHERE Id = (@Id)";
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
command.Parameters.AddWithValue("@Id", carClassId);
using (SqlDataReader reader = command.ExecuteReader())
{
reader.Read();
carClass.Id = reader.GetInt32(0);
carClass.Name = reader.GetString(1);
}
connection.Close();
}
}
}
catch (SqlException e)
{
Console.WriteLine(e);
}
return(carClass);
}
public bool Create(CarClassDTO carClass)
{
try
{
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sql = "INSERT INTO CarClass (Name) VALUES (@Name)";
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
command.Parameters.AddWithValue("@Name", carClass.Name);
if (command.ExecuteNonQuery() < 1)
{
connection.Close();
return(false);
}
connection.Close();
}
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(false);
}
return(true);
}
public bool Update()
{
CarClassDTO carClassDTO = new CarClassDTO
{
Id = this.Id,
Name = this.Name
};
return(CarClassFactoryDAL.GetDAL().Update(carClassDTO));
}
public bool Create(CarClass carclass)
{
CarClassDTO carclassDTO = new CarClassDTO()
{
Id = 0,
Name = carclass.Name,
};
return(CarClassFactoryDAL.GetCollectionDAL().Create(carclassDTO));
}
public CarClassDTO GetCarClass(int id)
{
CarClassDTO classDTO = _mapper.Map <CarClassDTO>(Database.CarClassesRepository.GetClassByID(id));
if (classDTO == null)
{
throw new ValidationException("Класса с таким ключом не существует", "");
}
return(classDTO);
}
