string IntfDalUSPlageNombreBillet.insertUSPlageNombreBillet(crlUSPlageNombreBillet plageNombreBillet, string sigleAgence)
{
#region declaration
string numPlageNombreBillet = "";
IntfDalUSPlageNombreBillet serviceUSPlageNombreBillet = new ImplDalUSPlageNombreBillet();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
int nbInsert = 0;
#endregion
#region implementation
if (plageNombreBillet != null)
{
plageNombreBillet.NumPlageNombreBillet = serviceUSPlageNombreBillet.getNumUSPlageNombreBillet(sigleAgence);
this.strCommande = "INSERT INTO `usplagenombrebillet` (`numPlageNombreBillet`,`nombreD`,`nombreF`,`numReductionBillet`,`dureeDeValidite`)";
this.strCommande += " VALUES ('" + plageNombreBillet.NumPlageNombreBillet + "','" + plageNombreBillet.NombreD + "',";
this.strCommande += " '" + plageNombreBillet.NombreF + "','" + plageNombreBillet.NumReductionBillet + "',";
this.strCommande += " '" + serviceGeneral.getStringTimeSpan(plageNombreBillet.DureeDeValidite) + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numPlageNombreBillet = plageNombreBillet.NumPlageNombreBillet;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numPlageNombreBillet);
}
bool IntfDalUSPlageNombreBillet.updateUSPlageNombreBillet(crlUSPlageNombreBillet plageNombreBillet)
{
#region declaration
bool isUpdate = false;
int nbUpdate = 0;
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
if (plageNombreBillet != null)
{
this.strCommande = "UPDATE `usplagenombrebillet` SET `nombreD`='" + plageNombreBillet.NombreD + "',";
this.strCommande += " `nombreF`='" + plageNombreBillet.NombreF + "',`numReductionBillet`='" + plageNombreBillet.NumReductionBillet + "',";
this.strCommande += " `dureeDeValidite`='" + serviceGeneral.getStringTimeSpan(plageNombreBillet.DureeDeValidite) + "'";
this.strCommande += " WHERE `numPlageNombreBillet`='" + plageNombreBillet.NumPlageNombreBillet + "'";
this.serviceConnectBase.openConnection();
nbUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nbUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isUpdate);
}
DataTable IntfDalFacture.getDataTableFactureNotRecu(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
//IntfDalVille serviceVille = new ImplDalVille();
//IntfDalFicheBord serviceFicheBord = new ImplDalFicheBord();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numFacture", typeof(string));
dataTable.Columns.Add("montant", typeof(string));
dataTable.Columns.Add("dateFacturation", typeof(DateTime));
dataTable.Columns.Add("Individu", typeof(string));
dataTable.Columns.Add("societe", typeof(string));
dataTable.Columns.Add("organisme", 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["numFacture"] = reader["numFacture"].ToString();
dr["montant"] = serviceGeneral.separateurDesMilles(reader["montant"].ToString()) + "Ar";
try
{
dr["dateFacturation"] = Convert.ToDateTime(reader["dateFacturation"].ToString());
}
catch (Exception)
{
}
dr["Individu"] = reader["prenomIndividu"].ToString() + " " + reader["nomIndividu"].ToString() + " / " + reader["cinIndividu"] + " / " + reader["adresse"].ToString();
dr["societe"] = reader["nomSociete"] + " / " + reader["adresseSociete"].ToString();
dr["organisme"] = reader["nomOrganisme"].ToString() + " / " + reader["adresseOrganisme"].ToString();
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
bool IntfDalUSAbonnementNVDevis.deleteUSAbonnementNVDevis(string numAbonnementNVDevis)
{
#region declaration
bool isUpdate = false;
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
if (numAbonnementNVDevis != "")
{
this.strCommande = "UPDATE `uscarte` SET `numAbonnementNVDevis`=NULL";
this.strCommande += " WHERE `numAbonnementNVDevis`='" + numAbonnementNVDevis + "'";
this.serviceConnectBase.openConnection();
this.serviceConnectBase.requete(this.strCommande);
this.serviceConnectBase.closeConnection();
if (serviceGeneral.delete("usabonnementnvdevis", "numAbonnementNVDevis", numAbonnementNVDevis) == 1)
{
isUpdate = true;
}
}
#endregion
return(isUpdate);
}
DataTable IntfDalDesignationCommission.getDataTableDesignationCommission(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numDesignation", typeof(string));
dataTable.Columns.Add("designation", typeof(string));
dataTable.Columns.Add("typeCommission", typeof(string));
dataTable.Columns.Add("paiement", 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["numDesignation"] = reader["numDesignation"].ToString();
dr["designation"] = reader["designation"].ToString();
dr["typeCommission"] = reader["typeCommission"].ToString();
if (reader["paiement"].ToString().Equals("0"))
{
dr["paiement"] = "Interne";
}
else if (reader["paiement"].ToString().Equals("1"))
{
dr["paiement"] = "Par Kg";
}
else if (reader["paiement"].ToString().Equals("2"))
{
dr["paiement"] = "Par pièce";
}
else
{
dr["paiement"] = "";
}
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
crlUSPlageNombreBillet IntfDalUSPlageNombreBillet.getPlageNombreBillet(int nombreBillet)
{
#region declaration
crlUSPlageNombreBillet plageNombreBillet = null;
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
if (nombreBillet > 0)
{
this.strCommande = "SELECT usplagenombrebillet.numPlageNombreBillet, usplagenombrebillet.nombreD,";
this.strCommande += " usplagenombrebillet.nombreF, usplagenombrebillet.numReductionBillet,";
this.strCommande += " usplagenombrebillet.dureeDeValidite FROM usplagenombrebillet";
this.strCommande += " WHERE usplagenombrebillet.nombreD <= '" + nombreBillet.ToString("0") + "' AND";
this.strCommande += " usplagenombrebillet.nombreF >= '" + nombreBillet.ToString("0") + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
plageNombreBillet = new crlUSPlageNombreBillet();
try
{
plageNombreBillet.DureeDeValidite = serviceGeneral.getTimeSpan(this.reader["dureeDeValidite"].ToString());
}
catch (Exception)
{
}
try
{
plageNombreBillet.NombreD = int.Parse(this.reader["nombreD"].ToString());
}
catch (Exception)
{
}
try
{
plageNombreBillet.NombreF = int.Parse(this.reader["nombreF"].ToString());
}
catch (Exception)
{
}
plageNombreBillet.NumPlageNombreBillet = this.reader["numPlageNombreBillet"].ToString();
plageNombreBillet.NumReductionBillet = this.reader["numReductionBillet"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(plageNombreBillet);
}
DataTable IntfDalCommissionDevis.getDataTableCommissionDevis(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
IntfDalTrajet serviceTrajet = new ImplDalTrajet();
crlTrajet trajet = null;
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("idCommissionDevis", typeof(string));
dataTable.Columns.Add("destination", typeof(string));
dataTable.Columns.Add("prixTotalfraisEnvoi", 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["idCommissionDevis"] = reader["idCommissionDevis"].ToString();
dr["destination"] = reader["destination"].ToString();
dr["prixTotalfraisEnvoi"] = serviceGeneral.separateurDesMilles(this.reader["fraisEnvoi"].ToString()) + "Ar";
trajet = serviceTrajet.selectTrajet(this.reader["numTrajet"].ToString());
if (trajet != null)
{
dr["trajet"] = trajet.villeD.NomVille + "-" + trajet.villeF.NomVille;
}
else
{
dr["trajet"] = "";
}
trajet = null;
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalCheque.getDataTableCheque(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numCheque", typeof(string));
dataTable.Columns.Add("numerosCheque", typeof(string));
dataTable.Columns.Add("banque", typeof(string));
dataTable.Columns.Add("dateCheque", typeof(DateTime));
dataTable.Columns.Add("montantCheque", 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["numCheque"] = reader["numCheque"].ToString();
dr["numerosCheque"] = reader["numerosCheque"].ToString();
dr["banque"] = reader["banque"].ToString();
try
{
dr["dateCheque"] = Convert.ToDateTime(this.reader["dateCheque"].ToString());
}
catch (Exception)
{
}
dr["montantCheque"] = serviceGeneral.separateurDesMilles(this.reader["montantCheque"].ToString()) + "Ar";
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalVoyage.getDataTableVoyageFB(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("idVoyage", typeof(string));
dataTable.Columns.Add("client", typeof(string));
dataTable.Columns.Add("pieceIdentite", typeof(string));
dataTable.Columns.Add("destination", typeof(string));
dataTable.Columns.Add("numPlace", typeof(string));
dataTable.Columns.Add("poidBagage", typeof(string));
dataTable.Columns.Add("prixTrajet", typeof(string));
dataTable.Columns.Add("numBillet", 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["idVoyage"] = reader["idVoyage"].ToString();
dr["client"] = reader["nomIndividu"].ToString() + " " + reader["prenomIndividu"].ToString();
dr["pieceIdentite"] = reader["pieceIdentite"].ToString();
dr["destination"] = reader["destination"].ToString();
dr["numPlace"] = reader["numPlace"].ToString();
dr["poidBagage"] = reader["poidBagage"].ToString() + "Kg";
dr["prixTrajet"] = serviceGeneral.separateurDesMilles(reader["prixBillet"].ToString()) + "Ar";
dr["numBillet"] = reader["numBillet"].ToString();
dataTable.Rows.Add(dr);
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalUSPlageNombreBillet.getDataTablePlageNombreBillet(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numPlageNombreBillet", typeof(string));
dataTable.Columns.Add("plage", typeof(string));
dataTable.Columns.Add("dureeDeValidite", typeof(string));
dataTable.Columns.Add("reductionBillet", typeof(string));
dataTable.Columns.Add("reductionPourcentage", typeof(string));
dataTable.Columns.Add("reductionMontant", 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["numPlageNombreBillet"] = reader["numPlageNombreBillet"].ToString();
dr["plage"] = reader["nombreD"].ToString() + " à " + reader["nombreF"].ToString();
dr["dureeDeValidite"] = serviceGeneral.getTextTimeSpan(reader["dureeDeValidite"].ToString());
dr["reductionBillet"] = reader["reductionBillet"].ToString();
dr["reductionPourcentage"] = reader["reductionPourcentage"].ToString() + " %";
dr["reductionMontant"] = reader["reductionMontant"].ToString() + " Ar";
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalRecu.getDataTableRecuEncaisser(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numRecu", typeof(string));
dataTable.Columns.Add("libele", typeof(string));
dataTable.Columns.Add("montant", typeof(string));
dataTable.Columns.Add("dateRecu", typeof(DateTime));
dataTable.Columns.Add("modePaiement", 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["numRecu"] = reader["numRecu"].ToString();
dr["libele"] = reader["libele"].ToString();
dr["montant"] = serviceGeneral.separateurDesMilles(reader["montant"].ToString()) + "Ar";
dr["dateRecu"] = Convert.ToDateTime(reader["dateRecu"].ToString());
dr["modePaiement"] = reader["modePaiement"].ToString();
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalUSCarte.getDataTableCarte(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numCarte", typeof(string));
dataTable.Columns.Add("prixCarte", typeof(string));
dataTable.Columns.Add("numCarteReduction", typeof(string));
dataTable.Columns.Add("numAbonnement", 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["numCarte"] = reader["numCarte"].ToString();
dr["prixCarte"] = serviceGeneral.separateurDesMilles(reader["prixCarte"].ToString()) + " Ar";
dr["numCarteReduction"] = reader["numCarteReduction"].ToString();
dr["numAbonnement"] = reader["numAbonnement"].ToString();
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
crlUSPlageNombreBillet IntfDalUSPlageNombreBillet.selectUSPlageNombreBillet(string numPlageNombreBillet)
{
#region declaration
crlUSPlageNombreBillet plageNombreBillet = null;
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region impementation
if (numPlageNombreBillet != "")
{
this.strCommande = "SELECT * FROM `usplagenombrebillet` WHERE ";
this.strCommande += " `numPlageNombreBillet`='" + numPlageNombreBillet + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
plageNombreBillet = new crlUSPlageNombreBillet();
plageNombreBillet.NumPlageNombreBillet = this.reader["numPlageNombreBillet"].ToString();
try
{
plageNombreBillet.NombreD = int.Parse(this.reader["nombreD"].ToString());
}
catch (Exception) { }
try
{
plageNombreBillet.NombreF = int.Parse(this.reader["nombreF"].ToString());
}
catch (Exception) { }
plageNombreBillet.NumReductionBillet = this.reader["numReductionBillet"].ToString();
plageNombreBillet.DureeDeValidite = serviceGeneral.getTimeSpan(this.reader["dureeDeValidite"].ToString());
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(plageNombreBillet);
}
DataTable IntfDalTarifDeveloppement.getDataTableTarifDeveloppement(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region initialise table
dataTable.Columns.Add("numTarifDeveloppement", typeof(string));
dataTable.Columns.Add("zone", typeof(string));
dataTable.Columns.Add("montantTarifDeveloppement", typeof(string));
dataTable.Columns.Add("commentaireTarifDeveloppement", 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["numTarifDeveloppement"] = this.reader["numTarifDeveloppement"].ToString();
dr["zone"] = this.reader["zone"].ToString();
dr["montantTarifDeveloppement"] = serviceGeneral.separateurDesMilles(this.reader["montantTarifDeveloppement"].ToString()) + "Ar";
dr["commentaireTarifDeveloppement"] = this.reader["commentaireTarifDeveloppement"].ToString();
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
bool IntfDalRouteNationale.deleteRouteNationale(string routeNationale)
{
#region declaration
bool isDelete = false;
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
if (routeNationale != null)
{
serviceGeneral.delete("assovilleroutenationale", "routeNationale", routeNationale);
if (serviceGeneral.delete("routenationale", "routeNationale", routeNationale) == 1)
{
isDelete = true;
}
}
#endregion
return(isDelete);
}
DataTable IntfDalTypeCommission.getDataTableTypeCommission(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("typeCommission", typeof(string));
dataTable.Columns.Add("commentaireTypeCommission", 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["typeCommission"] = reader["typeCommission"].ToString();
dr["commentaireTypeCommission"] = reader["commentaireTypeCommission"].ToString();
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnection.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalVoyage.getDataTableVoyageAutorisationDepart(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("passager", typeof(string));
dataTable.Columns.Add("pieceIdentite", typeof(string));
dataTable.Columns.Add("destination", typeof(string));
dataTable.Columns.Add("numPlace", typeof(string));
dataTable.Columns.Add("poidBagage", typeof(string));
dataTable.Columns.Add("prixTrajet", typeof(string));
dataTable.Columns.Add("numBillet", typeof(string));
dataTable.Columns.Add("excedent", typeof(string));
dataTable.Columns.Add("somme", 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["passager"] = reader["nomIndividu"].ToString() + " " + reader["prenomIndividu"].ToString();
dr["pieceIdentite"] = reader["pieceIdentite"].ToString();
dr["destination"] = reader["destination"].ToString();
dr["numPlace"] = reader["numPlace"].ToString();
dr["poidBagage"] = reader["poidBagage"].ToString() + "Kg";
dr["prixTrajet"] = serviceGeneral.separateurDesMilles(reader["prixBillet"].ToString()) + "Ar";
dr["numBillet"] = reader["numBillet"].ToString();
if (reader["excedentPoid"].ToString().Trim() != "" && reader["prixExcedent"].ToString().Trim() != "")
{
dr["excedent"] = serviceGeneral.separateurDesMilles(reader["prixExcedent"].ToString()) + "Ar (" + reader["excedentPoid"] + "Kg)";
try
{
dr["somme"] = serviceGeneral.separateurDesMilles((double.Parse(reader["prixBillet"].ToString()) + double.Parse(reader["prixExcedent"].ToString())).ToString()) + "Ar";
}
catch (Exception)
{
}
}
else
{
dr["excedent"] = "-";
dr["somme"] = serviceGeneral.separateurDesMilles(reader["prixBillet"].ToString()) + "Ar";
}
dataTable.Rows.Add(dr);
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalDureeAbonnementDevis.getDataTableDureeAbonnementDevis(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
IntfDalTrajet serviceTrajet = new ImplDalTrajet();
crlTrajet trajet = null;
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numDureeAbonnementDevis", typeof(string));
dataTable.Columns.Add("zone", typeof(string));
dataTable.Columns.Add("valideDu", typeof(DateTime));
dataTable.Columns.Add("valideAu", typeof(DateTime));
dataTable.Columns.Add("prixTotal", typeof(string));
dataTable.Columns.Add("nombre", 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["numDureeAbonnementDevis"] = reader["numDureeAbonnementDevis"].ToString();
dr["zone"] = reader["zone"].ToString();
try
{
dr["valideDu"] = Convert.ToDateTime(reader["valideDu"].ToString());
}
catch (Exception)
{
}
try
{
dr["valideAu"] = Convert.ToDateTime(this.reader["valideAu"].ToString());
}
catch (Exception)
{
}
dr["prixTotal"] = serviceGeneral.separateurDesMilles(this.reader["prixTotal"].ToString()) + "Ar";
dr["nombre"] = this.reader["nombreDureeAbonnement"].ToString();
trajet = serviceTrajet.selectTrajet(this.reader["numTrajet"].ToString());
if (trajet != null)
{
dr["trajet"] = trajet.villeD.NomVille + "-" + trajet.villeF.NomVille;
}
else
{
dr["trajet"] = "";
}
trajet = null;
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalUSInfoPasse.getDataTableInfoPasse(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
IntfDalUSPlageNombreBillet serviceUSPlageNombreBillet = new ImplDalUSPlageNombreBillet();
IntfDalUSReductionBillet serviceUSReductionBillet = new ImplDalUSReductionBillet();
IntfDalUSPrixBase serviceUSPrixBase = new ImplDalUSPrixBase();
crlUSReductionBillet reduction = null;
crlUSPlageNombreBillet plageNombreBillet = null;
crlUSPrixBase prixBase = null;
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numInfoPasse", typeof(string));
dataTable.Columns.Add("nombrePasse", typeof(string));
dataTable.Columns.Add("niveau", typeof(string));
dataTable.Columns.Add("prixUnitaire", typeof(string));
dataTable.Columns.Add("dureeValidite", 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["numInfoPasse"] = reader["numInfoPasse"].ToString();
dr["nombrePasse"] = reader["nombrePasse"].ToString();
dr["niveau"] = reader["niveau"].ToString();
reduction = serviceUSReductionBillet.selectUSReductionBillet(this.reader["numReductionBillet"].ToString());
try
{
prixBase = serviceUSPrixBase.selectUSPrixBase(int.Parse(reader["niveau"].ToString()));
}
catch (Exception) { }
try
{
plageNombreBillet = serviceUSPlageNombreBillet.getPlageNombreBillet(int.Parse(reader["nombrePasse"].ToString()));
}
catch (Exception) { }
if (prixBase != null)
{
if (reduction != null)
{
if (reduction.ReductionMontant > 0)
{
dr["prixUnitaire"] = serviceGeneral.separateurDesMilles((prixBase.MontantPrixBase - reduction.ReductionMontant).ToString("0")) + " Ar";
}
else
{
dr["prixUnitaire"] = serviceGeneral.separateurDesMilles((prixBase.MontantPrixBase - (prixBase.MontantPrixBase * reduction.ReductionPourcentage / 100)).ToString("0")) + " Ar";
}
}
else
{
dr["prixUnitaire"] = serviceGeneral.separateurDesMilles(prixBase.MontantPrixBase.ToString("0")) + " Ar";
}
}
else
{
dr["prixUnitaire"] = "";
}
if (plageNombreBillet != null)
{
dr["dureeValidite"] = serviceGeneral.getTextTimeSpan(serviceGeneral.getStringTimeSpan(plageNombreBillet.DureeDeValidite));
}
else
{
dr["dureeValidite"] = "";
}
reduction = null;
prixBase = null;
plageNombreBillet = null;
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
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 IntfDalUSLigne.getDataTableLigne(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
crlUSArret arretD = null;
crlUSArret arretF = null;
crlUSLieu lieuD = null;
crlUSLieu lieuF = null;
crlQuartier quartierD = null;
crlQuartier quartierF = null;
IntfDalUSArret serviceUSArret = new ImplDalUSArret();
IntfDalUSLieu serviceUSLieu = new ImplDalUSLieu();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
IntfDalQuartier serviceQuartier = new ImplDalQuartier();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numLigne", typeof(string));
dataTable.Columns.Add("nomLigne", typeof(string));
dataTable.Columns.Add("nomCooperative", typeof(string));
dataTable.Columns.Add("zone", 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["numLigne"] = reader["numLigne"].ToString();
dr["nomLigne"] = reader["nomLigne"].ToString();
dr["nomCooperative"] = reader["nomCooperative"].ToString();
dr["zone"] = reader["zone"].ToString();
arretD = serviceUSArret.selectUSArret(this.reader["numArretD"].ToString());
arretF = serviceUSArret.selectUSArret(this.reader["numArretF"].ToString());
if (arretD != null && arretF != null)
{
lieuD = serviceUSLieu.selectUSLieu(arretD.NumLieu);
lieuF = serviceUSLieu.selectUSLieu(arretF.NumLieu);
if (lieuD != null && lieuF != null)
{
quartierD = serviceQuartier.selectQuartier(lieuD.NumQuartier);
quartierF = serviceQuartier.selectQuartier(lieuF.NumQuartier);
if (quartierF != null && quartierF != null)
{
dr["trajet"] = quartierD.Quartier + "/" + arretD.NomArret + "-" + quartierF.Quartier + "/" + arretF.NomArret;
}
else
{
dr["trajet"] = arretD.NomArret + "-" + arretF.NomArret;
}
}
else
{
dr["trajet"] = arretD.NomArret + "-" + arretF.NomArret;
}
}
else
{
dr["trajet"] = this.reader["numArretD"].ToString() + "-" + this.reader["numArretF"].ToString();
}
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalUSAbonnementNVDevis.getDataTableAbonnementNVDevisProforma(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
crlUSZone zoneD = null;
crlUSZone zoneF = null;
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numAbonnementNVDevis", typeof(string));
dataTable.Columns.Add("Zone", typeof(string));
dataTable.Columns.Add("prixUnitaireNV", typeof(string));
dataTable.Columns.Add("nombreVoyage", typeof(string));
dataTable.Columns.Add("montantNV", typeof(string));
dataTable.Columns.Add("montantCarte", 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["numAbonnementNVDevis"] = reader["numAbonnementNVDevis"].ToString();
zoneD = serviceUSZone.selectUSZone(this.reader["numZoneD"].ToString());
zoneF = serviceUSZone.selectUSZone(this.reader["numZoneF"].ToString());
if (zoneD != null && zoneF != null)
{
dr["Zone"] = zoneD.NomZone + "-" + zoneF.NomZone;
}
else
{
dr["Zone"] = this.reader["numZoneD"].ToString() + "-" + this.reader["numZoneF"].ToString();
}
dr["prixUnitaireNV"] = serviceGeneral.separateurDesMilles(reader["prixUnitaireNV"].ToString()) + " Ar";
dr["nombreVoyage"] = reader["nombrePasse"].ToString();
dr["montantNV"] = serviceGeneral.separateurDesMilles(reader["montantNV"].ToString()) + " Ar";
dr["montantCarte"] = serviceGeneral.separateurDesMilles(reader["montantCarte"].ToString()) + " Ar";
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);
}
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 IntfDalBonDeCommande.getDataTableBonDeCommandeNonPaieDateDF(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
crlOrganisme organisme = null;
crlSociete societe = null;
crlClient client = null;
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
IntfDalSociete serviceSociete = new ImplDalSociete();
IntfDalOrganisme serviceOrganisme = new ImplDalOrganisme();
IntfDalClient serviceClient = new ImplDalClient();
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numBonDeCommande", typeof(string));
dataTable.Columns.Add("datePaiement", typeof(DateTime));
dataTable.Columns.Add("montant", typeof(string));
dataTable.Columns.Add("client", typeof(string));
dataTable.Columns.Add("adresse", typeof(string));
dataTable.Columns.Add("contact", typeof(string));
dataTable.Columns.Add("respSociete", typeof(string));
dataTable.Columns.Add("respContact", 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["numBonDeCommande"] = reader["numBonDeCommande"].ToString();
dr["datePaiement"] = Convert.ToDateTime(this.reader["datePaiementBC"].ToString());
dr["montant"] = serviceGeneral.separateurDesMilles(this.reader["montantBC"].ToString()) + "Ar";
if (reader["numClient"].ToString() != "")
{
client = serviceClient.selectClient(reader["numClient"].ToString());
}
if (reader["numOrganisme"].ToString() != "")
{
organisme = serviceOrganisme.selectOrganisme(reader["numOrganisme"].ToString());
}
if (reader["numSociete"].ToString() != "")
{
societe = serviceSociete.selectSociete(reader["numSociete"].ToString());
}
if (client != null)
{
dr["client"] = client.PrenomClient + " " + client.NomClient;
dr["adresse"] = client.AdresseClient;
dr["contact"] = client.TelephoneClient + " / " + client.MobileClient;
dr["respSociete"] = "-";
dr["respContact"] = "-";
}
else if (societe != null)
{
dr["client"] = societe.NomSociete;
dr["adresse"] = societe.AdresseSociete;
dr["contact"] = societe.TelephoneFixeSociete + " / " + societe.TelephoneMobileSociete;
if (societe.individuResponsable != null)
{
dr["respSociete"] = societe.individuResponsable.PrenomIndividu + " " + societe.individuResponsable.NomIndividu;
dr["respContact"] = societe.individuResponsable.TelephoneFixeIndividu + " / " + societe.individuResponsable.TelephoneMobileIndividu;
}
}
else if (organisme != null)
{
dr["client"] = organisme.NomOrganisme;
dr["adresse"] = organisme.AdresseOrganisme;
dr["contact"] = organisme.TelephoneFixeOrganisme + " / " + organisme.TelephoneMobileOrganisme;
if (organisme.individuResponsable != null)
{
dr["respSociete"] = organisme.individuResponsable.PrenomIndividu + " " + organisme.individuResponsable.NomIndividu;
dr["respContact"] = organisme.individuResponsable.TelephoneFixeIndividu + " / " + organisme.individuResponsable.TelephoneMobileIndividu;
}
}
client = null;
societe = null;
organisme = null;
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalVehicule.getDataTableADForVehicule(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
crlItineraire itineraire = null;
IntfDalItineraire serviceItineraire = new ImplDalItineraire();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
#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("date", 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();
itineraire = serviceItineraire.selectItineraire(this.reader["idItineraire"].ToString());
dr["vehicule"] = this.reader["matriculeVehicule"].ToString() + " " + this.reader["marqueVehicule"].ToString() + " " + this.reader["couleurVehicule"].ToString();
dr["chauffeur"] = this.reader["prenomChauffeur"].ToString() + " " + this.reader["nomChauffeur"].ToString();
try
{
dr["date"] = Convert.ToDateTime(this.reader["dateHeurDepart"].ToString());
}
catch (Exception)
{
dr["date"] = DateTime.Now;
}
if (itineraire != null)
{
dr["itineraire"] = itineraire.villeD.NomVille + "-" + itineraire.villeF.NomVille;
}
else
{
dr["itineraire"] = "-";
}
dr["recette"] = serviceGeneral.separateurDesMilles(this.reader["recetteTotale"].ToString()) + "Ar";
dr["reste"] = serviceGeneral.separateurDesMilles(this.reader["resteRegle"].ToString()) + "Ar";
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnection.closeConnection();
#endregion
return(dataTable);
}
DataTable IntfDalVoyageAbonnementDevis.getDataTableVoyageAbonnementDevis(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalGeneral serviceGeneral = new ImplDalGeneral();
IntfDalTrajet serviceTrajet = new ImplDalTrajet();
crlTrajet trajet = null;
double montantTotal = 0;
double prixUnitaire = 0;
int nbVoyage = 0;
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numVoyageAbonnementDevis", typeof(string));
dataTable.Columns.Add("zone", typeof(string));
dataTable.Columns.Add("nbVoyageAbonnement", typeof(string));
dataTable.Columns.Add("prixTotal", 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["numVoyageAbonnementDevis"] = reader["numVoyageAbonnementDevis"].ToString();
dr["zone"] = reader["zone"].ToString();
try
{
nbVoyage = int.Parse(this.reader["nbVoyageAbonnement"].ToString());
}
catch (Exception)
{
}
try
{
prixUnitaire = double.Parse(this.reader["prixUnitaire"].ToString());
}
catch (Exception)
{
}
dr["nbVoyageAbonnement"] = this.reader["nbVoyageAbonnement"].ToString();
montantTotal = prixUnitaire * nbVoyage;
dr["prixTotal"] = serviceGeneral.separateurDesMilles(montantTotal.ToString("0")) + "Ar";
trajet = serviceTrajet.selectTrajet(this.reader["numTrajet"].ToString());
if (trajet != null)
{
dr["trajet"] = trajet.villeD.NomVille + "-" + trajet.villeF.NomVille;
}
else
{
dr["trajet"] = "";
}
nbVoyage = 0;
montantTotal = 0;
prixUnitaire = 0;
trajet = null;
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);
}