bool IntfDalVille.deleteVille(crlVille Ville)
{
#region declaration
bool isDelete = false;
int nombreDelete = 0;
#endregion
#region implementation
if (Ville != null)
{
if (Ville.NumVille != "")
{
this.strCommande = "DELETE FROM `ville` WHERE (`numVille` = '" + Ville.NumVille + "')";
this.serviceConnectBase.openConnection();
nombreDelete = this.serviceConnectBase.requete(this.strCommande);
if (nombreDelete == 1)
{
isDelete = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isDelete);
}
DataTable IntfDalFicheBord.getDataTableFicheBordSansAD(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalVille serviceVille = new ImplDalVille();
crlVille villeD = new crlVille();
crlVille villeF = new crlVille();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numFb", typeof(string));
dataTable.Columns.Add("dateHeurPrevue", typeof(DateTime));
dataTable.Columns.Add("voiture", typeof(string));
dataTable.Columns.Add("chauffeur", typeof(string));
dataTable.Columns.Add("itineraire", typeof(string));
dataTable.Columns.Add("nbPlaceLibre", typeof(string));
DataRow dr;
#endregion
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(strRqst);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
dr = dataTable.NewRow();
dr["numFb"] = reader["numFb"].ToString();
dr["dateHeurPrevue"] = Convert.ToDateTime(reader["dateHeurPrevue"].ToString());
dr["voiture"] = reader["matriculeVehicule"].ToString() + " " + reader["marqueVehicule"].ToString();
dr["chauffeur"] = reader["nomChauffeur"].ToString() + " " + reader["prenomChauffeur"].ToString();
villeD = serviceVille.selectVille(reader["numVilleItineraireDebut"].ToString());
villeF = serviceVille.selectVille(reader["numVilleItineraireFin"].ToString());
if (villeD != null && villeF != null)
{
dr["itineraire"] = villeD.NomVille + "-" + villeF.NomVille;
}
else
{
dr["itineraire"] = reader["numVilleItineraireDebut"].ToString() + "-" + reader["numVilleItineraireFin"].ToString();
}
dr["nbPlaceLibre"] = (int.Parse(reader["nbPlace"].ToString()) - int.Parse(reader["nbOccuper"].ToString())).ToString();
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
bool IntfDalVille.updateVille(crlVille Ville)
{
#region declaration
bool isUpdate = false;
int nombreUpdate = 0;
#endregion
#region implementation
if (Ville != null)
{
if (Ville.NumVille != "")
{
this.strCommande = "UPDATE `ville` SET `nomVille`='" + Ville.NomVille + "',";
this.strCommande += " `nomRegion`='" + Ville.NomRegion + "',`nomProvince`='" + Ville.NomProvince + "'";
this.strCommande += " WHERE (`numVille`='" + Ville.NumVille + "')";
this.serviceConnectBase.openConnection();
nombreUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nombreUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isUpdate);
}
string IntfDalVille.insertVille(crlVille Ville, string sigleAgence)
{
#region declaration
IntfDalVille serviceVille = new ImplDalVille();
int nombreInsertion = 0;
string numVille = "";
#endregion
#region implementation
if (Ville != null)
{
Ville.NumVille = serviceVille.getNumVille(sigleAgence);
this.strCommande = "INSERT INTO `ville` (`numVille`,`nomVille`,`nomRegion`,`nomProvince`)";
this.strCommande += " VALUES ('" + Ville.NumVille + "','" + Ville.NomVille + "',";
this.strCommande += "'" + Ville.NomRegion + "', '" + Ville.NomProvince + "')";
this.serviceConnectBase.openConnection();
nombreInsertion = this.serviceConnectBase.requete(this.strCommande);
if (nombreInsertion == 1)
{
numVille = Ville.NumVille;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numVille);
}
DataTable IntfDalBillet.getDataTableBilletInsertToFB(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalVille serviceVille = new ImplDalVille();
crlVille villeD = new crlVille();
crlVille villeF = new crlVille();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numBillet", typeof(string));
dataTable.Columns.Add("dateValidite", typeof(DateTime));
dataTable.Columns.Add("client", typeof(string));
dataTable.Columns.Add("trajet", typeof(string));
DataRow dr;
#endregion
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(strRqst);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
dr = dataTable.NewRow();
dr["numBillet"] = reader["numBillet"].ToString();
dr["dateValidite"] = Convert.ToDateTime(reader["dateDeValidite"].ToString());
dr["client"] = reader["nomIndividu"].ToString() + " " + reader["prenomIndividu"].ToString();
villeD = serviceVille.selectVille(reader["numVilleD"].ToString());
villeF = serviceVille.selectVille(reader["numVilleF"].ToString());
if (villeD != null && villeF != null)
{
dr["trajet"] = villeD.NomVille + "-" + villeF.NomVille;
}
else
{
dr["trajet"] = reader["numVilleD"].ToString() + "-" + reader["numVilleF"].ToString();
}
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
private void insertToObjetVille(crlVille ville)
{
#region implementation
if (ville != null)
{
ville.NomProvince = ddlProvince.SelectedValue;
ville.NomRegion = ddlRegion.SelectedValue;
ville.NomVille = TextNomVille.Text;
}
#endregion
}
public crlAgence()
{
this.NumAgence = "";
this.NumVille = "";
this.TypeAgence = "";
this.SigleAgence = "";
this.NomAgence = "";
this.LocalisationAgence = "";
this.typeAgence = null;
this.ville = null;
this.sessionAgence = null;
}
List <crlVille> IntfDalVille.selectVillesForRN(string routeNationale)
{
#region declaration
List <crlVille> Villes = null;
crlVille tempVille = null;
#endregion
#region implementation
if (routeNationale != "")
{
this.strCommande = "SELECT ville.numVille, ville.nomVille, ville.nomRegion,";
this.strCommande += " ville.nomProvince FROM ville";
this.strCommande += " Inner Join assovilleroutenationale ON assovilleroutenationale.numVille = ville.numVille";
this.strCommande += " WHERE assovilleroutenationale.routeNationale = '" + routeNationale + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
Villes = new List <crlVille>();
while (this.reader.Read())
{
tempVille = new crlVille();
tempVille.NumVille = reader["numVille"].ToString();
tempVille.NomVille = reader["nomVille"].ToString();
tempVille.NomRegion = reader["nomRegion"].ToString();
tempVille.NomProvince = reader["nomProvince"].ToString();
tempVille.region = new crlRegion();
tempVille.region.NomRegion = tempVille.NomRegion;
tempVille.province = new crlProvince();
tempVille.province.nomProvince = tempVille.NomProvince;
Villes.Add(tempVille);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(Villes);
}
private void afficheVille(string numVille)
{
#region declaration
crlVille ville = null;
string strConfirm = "";
#endregion
#region implementation
if (numVille != "")
{
ville = serviceVille.selectVille(numVille);
if (ville != null)
{
try
{
ddlProvince.SelectedValue = ville.NomProvince;
}
catch (Exception)
{
}
try
{
ddlRegion.SelectedValue = ville.NomRegion;
}
catch (Exception)
{
}
TextNomVille.Text = ville.NomVille;
hfNumVille.Value = ville.NumVille;
strConfirm = "Voulez vous vraiment modifier le ville " + ville.NomVille + "?";
btnModifier_ConfirmButtonExtender.ConfirmText = strConfirm;
btnModifier.Enabled = true;
btnValider.Enabled = false;
}
}
#endregion
}
crlVille IntfDalVille.selectVilleNom(string nomVille)
{
#region declaration
crlVille Ville = null;
#endregion
#region implementation
if (nomVille != "")
{
this.strCommande = "SELECT * FROM `ville` WHERE (`nomVille`='" + nomVille + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
Ville = new crlVille();
Ville.NumVille = reader["numVille"].ToString();
Ville.NomVille = reader["nomVille"].ToString();
Ville.NomRegion = reader["nomRegion"].ToString();
Ville.NomProvince = reader["nomProvince"].ToString();
Ville.region = new crlRegion();
Ville.region.NomRegion = Ville.NomRegion;
Ville.province = new crlProvince();
Ville.province.nomProvince = Ville.NomProvince;
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(Ville);
}
string IntfDalVille.isVille(crlVille Ville)
{
#region declaration
string isVille = "";
#endregion
#region implementation
if (Ville != null)
{
this.strCommande = "SELECT * FROM `ville` WHERE (`numVille`<>'" + Ville.NumVille + "' AND";
this.strCommande += " `nomVille`='" + Ville.NomVille + "' AND `nomRegion`='" + Ville.NomRegion + "' AND";
this.strCommande += " `nomProvince`='" + Ville.NomProvince + "')";
this.serviceConnectBase.openConnection();
reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
if (Ville.NomVille.Trim().ToLower().Equals(reader["nomVille"].ToString().Trim().ToLower()) &&
Ville.NomRegion.Trim().ToLower().Equals(reader["nomRegion"].ToString().Trim().ToLower()) &&
Ville.NomProvince.Trim().ToLower().Equals(reader["nomProvince"].ToString().Trim().ToLower()))
{
isVille = reader["numVille"].ToString();
break;
}
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isVille);
}
protected void btnModifier_Click(object sender, EventArgs e)
{
#region declaration
crlVille ville = null;
string strIndication = "";
string numVille = "";
#endregion
#region implementation
if (hfNumVille.Value != "")
{
ville = serviceVille.selectVille(hfNumVille.Value);
if (ville != null)
{
this.insertToObjetVille(ville);
numVille = serviceVille.isVille(ville);
if (numVille.Equals(""))
{
if (serviceVille.updateVille(ville))
{
this.initialiseGridVille();
}
else
{
}
}
else
{
//
}
}
}
#endregion
}
protected void btnValider_Click(object sender, EventArgs e)
{
#region declaration
crlVille ville = null;
string strIndication = "";
#endregion
#region implementation
ville = new crlVille();
this.insertToObjetVille(ville);
ville.NumVille = serviceVille.isVille(ville);
if (ville.NumVille.Equals(""))
{
ville.NumVille = serviceVille.insertVille(ville, agent.agence.SigleAgence);
if (ville.NumVille != "")
{
this.initialiseFormulaire();
strIndication = "Ville " + ville.NomVille + " bien enregistrer!";
this.divIndicationText(strIndication, "Black");
this.initialiseGridVille();
}
else
{
strIndication = "Une erreur ce produit durant l'enregistrement!";
this.divIndicationText(strIndication, "Red");
}
}
else
{
this.afficheVille(ville.NumVille);
}
#endregion
}
bool IntfDalTrajet.insertAssociationVilleTrajet(crlTrajet Trajet, crlVille Ville)
{
#region declaration
bool isInsert = false;
int nombreInsertion = 0;
#endregion
#region implementation
if (Trajet != null && Ville != null)
{
this.strCommande = "INSERT INTO `associationvilletrajet` (`numTrajet`,`numVille`)";
this.strCommande += " VALUES ('" + Trajet.NumTrajet + "','" + Ville.NumVille + "')";
this.serviceConnectBase.openConnection();
nombreInsertion = this.serviceConnectBase.requete(this.strCommande);
if (nombreInsertion == 1)
{
isInsert = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isInsert);
}
DataTable IntfDalAutorisationDepart.getDataTableAutorisationDepart(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalVille serviceVille = new ImplDalVille();
IntfDalFicheBord serviceFicheBord = new ImplDalFicheBord();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
crlVille villeD = new crlVille();
crlVille villeF = new crlVille();
double montant = 0.00;
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numAutorisationDepart", typeof(string));
dataTable.Columns.Add("dateDepart", typeof(DateTime));
dataTable.Columns.Add("itineraire", typeof(string));
dataTable.Columns.Add("chauffeur", typeof(string));
dataTable.Columns.Add("voiture", typeof(string));
dataTable.Columns.Add("montant", typeof(string));
dataTable.Columns.Add("montantRecu", typeof(string));
DataRow dr;
#endregion
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(strRqst);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
dr = dataTable.NewRow();
dr["numAutorisationDepart"] = reader["numAutorisationDepart"].ToString();
dr["dateDepart"] = Convert.ToDateTime(reader["dateHeurDepart"].ToString());
villeD = serviceVille.selectVille(reader["numVilleItineraireDebut"].ToString());
villeF = serviceVille.selectVille(reader["numVilleItineraireFin"].ToString());
if (villeD != null && villeF != null)
{
dr["itineraire"] = villeD.NomVille + "-" + villeF.NomVille;
}
else
{
dr["itineraire"] = reader["numVilleItineraireDebut"].ToString() + "-" + reader["numVilleItineraireFin"].ToString();
}
dr["chauffeur"] = reader["nomChauffeur"].ToString() + " " + reader["prenomChauffeur"].ToString();
dr["voiture"] = reader["matriculeVehicule"].ToString() + " " + reader["marqueVehicule"].ToString() + " " + reader["couleurVehicule"].ToString();
montant = serviceFicheBord.getPrixTotalBagage(reader["numerosFB"].ToString()) + serviceFicheBord.getPrixTotalBillet(reader["numerosFB"].ToString()) + serviceFicheBord.getPrixTotalCommission(reader["numerosFB"].ToString());
dr["montant"] = serviceGeneral.separateurDesMilles(montant.ToString("0")) + "Ar";
dr["montantRecu"] = serviceGeneral.separateurDesMilles(reader["sommeRecu"].ToString()) + "Ar";
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalBillet.getDataTableBilletAbonnement(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
IntfDalVille serviceVille = new ImplDalVille();
crlVille VilleD = null;
crlVille VilleF = null;
string strTrajet = "";
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numBillet", typeof(string));
dataTable.Columns.Add("dateValidite", typeof(DateTime));
dataTable.Columns.Add("modePaiement", typeof(string));
dataTable.Columns.Add("prixBillet", typeof(string));
dataTable.Columns.Add("trajet", typeof(string));
DataRow dr;
#endregion
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(strRqst);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
dr = dataTable.NewRow();
dr["numBillet"] = reader["numBillet"].ToString();
dr["dateValidite"] = Convert.ToDateTime(reader["dateDeValidite"].ToString());
dr["modePaiement"] = reader["modePaiement"].ToString();
dr["prixBillet"] = serviceGeneral.separateurDesMilles(reader["prixBillet"].ToString()) + "Ar";
VilleD = serviceVille.selectVille(reader["numVilleD"].ToString());
VilleF = serviceVille.selectVille(reader["numVilleF"].ToString());
if (VilleD != null)
{
strTrajet = VilleD.NomVille + "-";
}
else
{
strTrajet = reader["numVilleD"].ToString() + "-";
}
if (VilleF != null)
{
strTrajet += VilleF.NomVille;
}
else
{
strTrajet += reader["numVilleF"].ToString();
}
dr["trajet"] = strTrajet;
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalAgence.getDataTableAgenceListe(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
crlAgence agence = null;
IntfDalVille serviceVille = new ImplDalVille();
IntfDalAgence serviceAgence = new ImplDalAgence();
crlVille ville = null;
#endregion
#region implemntation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numAgence", typeof(string));
dataTable.Columns.Add("villeAgence", typeof(string));
dataTable.Columns.Add("nomAgence", typeof(string));
dataTable.Columns.Add("localisation", typeof(string));
dataTable.Columns.Add("typeAgence", typeof(string));
dataTable.Columns.Add("sigleAgence", typeof(string));
dataTable.Columns.Add("statut", typeof(string));
DataRow dr;
#endregion
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(strRqst);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
dr = dataTable.NewRow();
agence = serviceAgence.selectAgence(this.reader["numAgence"].ToString());
dr["numAgence"] = this.reader["numAgence"].ToString();
ville = serviceVille.selectVille(this.reader["numVille"].ToString());
if (ville != null)
{
dr["villeAgence"] = ville.NomVille;
}
else
{
dr["villeAgence"] = this.reader["numVille"].ToString();
}
dr["nomAgence"] = this.reader["nomAgence"].ToString();
dr["sigleAgence"] = this.reader["sigleAgence"].ToString();
dr["localisation"] = this.reader["localisationAgence"].ToString();
dr["typeAgence"] = this.reader["typeAgence"].ToString();
if (agence.sessionAgence != null)
{
dr["statut"] = "vert16.png";
}
else
{
dr["statut"] = "rouge16.png";
}
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalVerification.getDataTableVerificationNonValider(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalVille serviceVille = new ImplDalVille();
crlVille villeD = null;
crlVille villeF = null;
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("idVerification", typeof(string));
dataTable.Columns.Add("dateVerification", typeof(DateTime));
dataTable.Columns.Add("vehicule", typeof(string));
dataTable.Columns.Add("chauffeur", typeof(string));
dataTable.Columns.Add("itineraire", typeof(string));
DataRow dr;
#endregion
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(strRqst);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
dr = dataTable.NewRow();
dr["idVerification"] = reader["idVerification"].ToString();
dr["dateVerification"] = Convert.ToDateTime(reader["dateVerification"].ToString());
dr["vehicule"] = reader["matriculeVehicule"].ToString() + " " + reader["marqueVehicule"].ToString() + " " + reader["couleurVehicule"].ToString();
dr["chauffeur"] = reader["prenomChauffeur"].ToString() + " " + reader["nomChauffeur"].ToString();
villeD = serviceVille.selectVille(reader["numVilleItineraireDebut"].ToString());
villeF = serviceVille.selectVille(reader["numVilleItineraireFin"].ToString());
if (villeD != null && villeF != null)
{
dr["itineraire"] = villeD.NomVille + "-" + villeF.NomVille;
}
else
{
dr["itineraire"] = reader["numVilleItineraireDebut"].ToString() + "-" + reader["numVilleItineraireFin"].ToString();
}
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalTrajet.getDataTableTrajetNotItineraire(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalVille serviceVille = new ImplDalVille();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
crlVille villeD = null;
crlVille villeF = null;
string strTrajet = "";
#endregion
#region initialise table
dataTable.Columns.Add("numTrajet", typeof(string));
dataTable.Columns.Add("distanceTrajet", typeof(string));
dataTable.Columns.Add("dureeTrajet", typeof(string));
dataTable.Columns.Add("trajet", typeof(string));
DataRow dr = null;
#endregion
#region implementation
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(strRqst);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
dr = dataTable.NewRow();
dr["numTrajet"] = this.reader["numTrajet"].ToString();
dr["distanceTrajet"] = this.reader["distanceTrajet"].ToString() + "Km";
dr["dureeTrajet"] = serviceGeneral.getTextTimeSpan(this.reader["dureeTrajet"].ToString());
villeD = serviceVille.selectVille(this.reader["numVilleD"].ToString());
villeF = serviceVille.selectVille(this.reader["numVilleF"].ToString());
if (villeD != null)
{
strTrajet += villeD.NomVille;
}
else
{
strTrajet += this.reader["numVilleD"].ToString();
}
if (villeF != null)
{
strTrajet += "-" + villeF.NomVille;
}
else
{
strTrajet += "-" + this.reader["numVilleF"].ToString();
}
dr["trajet"] = strTrajet;
strTrajet = "";
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalProprietaire.getDataTableVoyageVoitureProprietaire(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalVille serviceVille = new ImplDalVille();
IntfDalFicheBord serviceFicheBord = new ImplDalFicheBord();
IntfDalAutorisationDepart serviceAutorisationDepart = new ImplDalAutorisationDepart();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
crlVille villeD = new crlVille();
crlVille villeF = new crlVille();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("vehicule", typeof(string));
dataTable.Columns.Add("chauffeur", typeof(string));
dataTable.Columns.Add("dateVoyage", typeof(DateTime));
dataTable.Columns.Add("Itineraire", typeof(string));
dataTable.Columns.Add("recette", typeof(string));
dataTable.Columns.Add("reste", typeof(string));
DataRow dr;
#endregion
this.serviceConnection.openConnection();
this.reader = this.serviceConnection.select(strRqst);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
dr = dataTable.NewRow();
dr["vehicule"] = reader["matriculeVehicule"].ToString() + " " + reader["marqueVehicule"];
dr["chauffeur"] = reader["nomChauffeur"].ToString() + " " + reader["prenomChauffeur"].ToString();
dr["dateVoyage"] = Convert.ToDateTime(reader["dateHeurDepart"].ToString());
villeD = serviceVille.selectVille(reader["numVilleItineraireDebut"].ToString());
villeF = serviceVille.selectVille(reader["numVilleItineraireFin"].ToString());
if (villeD != null && villeF != null)
{
dr["Itineraire"] = villeD.NomVille + "-" + villeF.NomVille;
}
else
{
dr["Itineraire"] = reader["numVilleItineraireDebut"].ToString() + "-" + reader["numVilleItineraireFin"].ToString();
}
dr["recette"] = serviceGeneral.separateurDesMilles(reader["recetteTotale"].ToString()) + "Ar";
dr["reste"] = serviceGeneral.separateurDesMilles(reader["resteRegle"].ToString()) + "Ar";
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnection.closeConnection();
#endregion
return(dataTable);
}
