public Zbor FindOneByDestinatieAndDateTime(String destinatie, String DataTimp)
{
IDbConnection con = DBUtils.getConnection(props);
using (var comm = con.CreateCommand())
{
comm.CommandText = "select * from Zboruri where Destinatia=@destinatia and Plecare=@plecare";
IDbDataParameter paramDestinatie = comm.CreateParameter();
paramDestinatie.ParameterName = "@destinatia";
paramDestinatie.Value = destinatie;
comm.Parameters.Add(paramDestinatie);
IDbDataParameter paramPlecare = comm.CreateParameter();
paramPlecare.ParameterName = "@plecare";
paramPlecare.Value = DataTimp;
comm.Parameters.Add(paramPlecare);
using (var dataR = comm.ExecuteReader())
{
if (dataR.Read())
{
int IdZ = dataR.GetInt32(0);
String Destinatie = dataR.GetString(1);
String PlecareS = dataR.GetString(2);
DateTime Plecare = DateTime.Parse(PlecareS);
String Aeroport = dataR.GetString(3);
int Locuri = dataR.GetInt32(4);
Zbor z = new Zbor(IdZ, Destinatie, Plecare, Aeroport, Locuri);
log.InfoFormat("Exiting findOne with value {0}", z);
return(z);
}
}
}
log.InfoFormat("Exiting findOne with value {0}", null);
return(null);
}