private static IEnumerable <Reciept> GetReciepts(SqlParameter parameter)
{
List <Reciept> reciepts = new List <Reciept>();
using (SqlConnection connection = new SqlConnection(ActualConnectionString.Get()))
{
SqlCommand command = new SqlCommand("GetReciepts");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
if (parameter != null)
{
command.Parameters.Add(parameter);
}
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Reciept reciept = new Reciept();
reciept.Id = int.Parse(reader["ID_КвОВыдаче"].ToString());
int idTariff = int.Parse(reader["Тариф"].ToString());
int idTransport = int.Parse(reader["Транспорт"].ToString());
int idParking = int.Parse(reader["Парковка"].ToString());
int idEmployee = int.Parse(reader["Работник"].ToString());
int idClient = int.Parse(reader["Клиент"].ToString());
reciept.CreationDate = DateTime.Parse(reader["ДатаОформления"].ToString());
reciept.NecessaryReturnDate = DateTime.Parse(reader["НеобходимаяДатаВозврата"].ToString());
reciept.Price = double.Parse(reader["Стоимость"].ToString());
int.TryParse(reader["ID_КвОВозврате"].ToString(), out int idRecieptForReturn);
int.TryParse(reader["ID_КвВодитель"].ToString(), out int idDriverReciept);
reciept.Tariff = TariffsDAO.GetTariffById(idTariff);
reciept.Transport = TransportDAO.GetTransportById(idTransport);
reciept.Parking = ParkingDAO.GetParkingById(idParking);
reciept.Employee = EmployeeDAO.GetEmployeeById(idEmployee);
reciept.Client = ClientDAO.GetClientById(idClient);
reciept.RecieptForReturn = RecieptForReturnDAO.GetRecieptForReturnById(idRecieptForReturn);
reciept.DriverReciept = DriverRecieptDAO.GetDriverRecieptById(idDriverReciept);
reciepts.Add(reciept);
}
}
return(reciepts);
}
public static RecieptForReturn GetRecieptForReturnById(int id)
{
if (id == 0)
{
return(null);
}
using (SqlConnection connection = new SqlConnection(ActualConnectionString.Get()))
{
SqlCommand command = new SqlCommand("GetRecieptForReturnById");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
RecieptForReturn recieptForReturn = new RecieptForReturn();
recieptForReturn.Id = int.Parse(reader["ID_КвОВозврате"].ToString());
int idParking = int.Parse(reader["Парковка"].ToString());
recieptForReturn.CreationDate = DateTime.Parse(reader["ДатаОформления"].ToString());
if (!string.IsNullOrEmpty(reader["ID_КвШтраф"].ToString()))
{
recieptForReturn.FineReciept = new FineReciept(int.Parse(reader["ID_КвШтраф"].ToString()),
double.Parse(reader["Штраф"].ToString()));
}
recieptForReturn.Parking = ParkingDAO.GetParkingById(idParking);
return(recieptForReturn);
}
}
}
return(null);
}
