crlLicence IntfDalLicence.selectLicence(string numLicence)
{
#region declaration
IntfDalLicence serviceLicence = new ImplDalLicence();
List <crlItineraire> Itineraires = null;
crlLicence Licence = null;
IntfDalCooperative serviceCooperative = new ImplDalCooperative();
IntfDalZone serviceZone = new ImplDalZone();
IntfDalVehicule serviceVehicule = new ImplDalVehicule();
#endregion
#region implementation
if (numLicence != "")
{
Itineraires = serviceLicence.selectItineraire(numLicence);
this.strCommande = "SELECT * FROM licence WHERE (licence.numLicence = '" + numLicence + "')";
this.serviceConnectBase.openConnection();
reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
if (reader.Read())
{
Licence = new crlLicence();
Licence.NumLicence = reader["numLicence"].ToString();
Licence.NumerosLicence = reader["numerosLicence"].ToString();
Licence.Zone = reader["zone"].ToString();
Licence.NumCooperative = reader["numCooperative"].ToString();
Licence.NumVehicule = reader["numVehicule"].ToString();
try
{
Licence.DatePremiereMiseCiculation = Convert.ToDateTime(reader["datePremiereMiseCiculation"].ToString());
}
catch (Exception) { }
try
{
Licence.DatePremiereExploitation = Convert.ToDateTime(reader["datePremiereExploitation"].ToString());
}
catch (Exception) { }
try
{
Licence.ValideAu = Convert.ToDateTime(reader["valideAu"].ToString());
}
catch (Exception)
{
}
try
{
Licence.ValideDu = Convert.ToDateTime(reader["valideDu"].ToString());
}
catch (Exception)
{
}
try
{
Licence.NombrePlacePayante = int.Parse(reader["nombrePlacePayante"].ToString());
}
catch (Exception)
{
}
try
{
Licence.IsProvisoire = int.Parse(reader["isProvisoire"].ToString());
}
catch (Exception)
{
}
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (Licence != null)
{
if (Licence.Zone != "")
{
Licence.zoneObj = serviceZone.selectZone(Licence.Zone);
}
if (Licence.NumCooperative != "")
{
Licence.cooperative = serviceCooperative.selectCooperative(Licence.NumCooperative);
}
if (Licence.NumVehicule != "")
{
Licence.vehicule = serviceVehicule.selectVehicule(Licence.NumVehicule);
}
Licence.itineraires = serviceLicence.selectItineraire(Licence.NumLicence);
}
}
#endregion
return(Licence);
}
