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); }