string IntfDalUSZone.insertUSZone(crlUSZone zone, string sigleAgence)
{
#region declaration
string numZone = "";
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
int nbInsert = 0;
#endregion
#region implemenation
if (zone != null && sigleAgence != "")
{
zone.NumZone = serviceUSZone.getNumUSZone(sigleAgence);
this.strCommande = "INSERT INTO `uszone` (`numZone`,`nomZone`,`niveau`,`numCommune`)";
this.strCommande += " VALUES ('" + zone.NumZone + "','" + zone.NomZone + "',";
this.strCommande += " '" + zone.Niveau.ToString("0") + "','" + zone.NumCommune + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numZone = zone.NumZone;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numZone);
}
int IntfDalUSPrixBase.getNiveauPrixBase(string numLieuD, string numLieuF)
{
#region declaration
int niveau = -1;
crlUSLieu lieuD = null;
crlUSLieu lieuF = null;
crlUSZone zoneD = null;
crlUSZone zoneF = null;
IntfDalUSLieu serviceUSLieu = new ImplDalUSLieu();
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
IntfDalUSPrixBase serviceUSPrixBase = new ImplDalUSPrixBase();
#endregion
#region implementation
if (numLieuD != "" && numLieuF != "")
{
lieuD = serviceUSLieu.selectUSLieu(numLieuD);
lieuF = serviceUSLieu.selectUSLieu(numLieuF);
if (lieuD != null && lieuF != null)
{
zoneD = serviceUSZone.selectUSZone(lieuD.NumZone);
zoneF = serviceUSZone.selectUSZone(lieuF.NumZone);
if (zoneD != null && zoneF != null)
{
if (zoneD.Niveau == 1 && zoneD.Niveau == zoneF.Niveau)
{
niveau = 1;
}
else
{
if (zoneD.Niveau == 1)
{
niveau = zoneF.Niveau;
}
else if (zoneF.Niveau == 1)
{
niveau = zoneD.Niveau;
}
else
{
if (serviceUSPrixBase.isMemeAxe(numLieuD, numLieuF))
{
niveau = Math.Abs(zoneD.Niveau - zoneF.Niveau) + 1;
}
else
{
niveau = zoneD.Niveau + zoneF.Niveau;
}
}
}
}
}
}
#endregion
return(niveau);
}
int IntfDalUSPrixBase.getNiveauPrixBase(string numZoneD, string numZoneF, bool isMemeAxe)
{
#region declaration
int niveau = -1;
crlUSZone zoneD = null;
crlUSZone zoneF = null;
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
#endregion
#region implementation
zoneD = serviceUSZone.selectUSZone(numZoneD);
zoneF = serviceUSZone.selectUSZone(numZoneF);
if (zoneD != null && zoneF != null)
{
if (zoneD.Niveau == 1 && zoneF.Niveau == 1)
{
niveau = 1;
}
else
{
if (zoneD.Niveau == 1 || zoneF.Niveau == 1)
{
if (zoneD.Niveau == 1)
{
niveau = zoneF.Niveau;
}
else
{
niveau = zoneD.Niveau;
}
}
else
{
if (isMemeAxe)
{
niveau = Math.Abs(zoneD.Niveau - zoneF.Niveau) + 1;
}
else
{
niveau = zoneF.Niveau + zoneD.Niveau;
}
}
}
}
#endregion
return(niveau);
}
void IntfDalUSAbonnementNV.loadDdlAbonnementNVNonCarte(DropDownList ddl, string numAbonnement)
{
#region declaration
crlUSZone zoneD = null;
crlUSZone zoneF = null;
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
#endregion
#region implementation
if (ddl != null)
{
ddl.Items.Clear();
ddl.Items.Add("");
this.strCommande = "SELECT usabonnementnv.numZoneD, usabonnementnv.numZoneF,";
this.strCommande += " usabonnementnv.numAbonnementNV FROM usabonnementnv";
this.strCommande += " Left Join uscarte ON uscarte.numAbonnementNV = usabonnementnv.numAbonnementNV";
this.strCommande += " WHERE usabonnementnv.numAbonnement = '" + numAbonnement + "' AND";
this.strCommande += " uscarte.numAbonnementNV IS NULL";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
while (this.reader.Read())
{
zoneD = serviceUSZone.selectUSZone(this.reader["numZoneD"].ToString());
zoneF = serviceUSZone.selectUSZone(this.reader["numZoneF"].ToString());
if (zoneD != null && zoneF != null)
{
ddl.Items.Add(new ListItem(zoneD.NomZone + "-" + zoneF.NomZone, this.reader["numAbonnementNV"].ToString()));
}
else
{
ddl.Items.Add(new ListItem(this.reader["numZoneD"].ToString() + "-" + this.reader["numZoneF"].ToString(), this.reader["numAbonnementNV"].ToString()));
}
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
}
string IntfDalUSLieu.isUSLieu(crlUSLieu lieu)
{
#region declaration
string numLieu = "";
string numCommune = "";
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
#endregion
#region implementation
if (lieu != null)
{
numCommune = serviceUSZone.getNumCommune(lieu.NumZone);
this.strCommande = "SELECT * FROM `uslieu`";
this.strCommande += " Inner Join uszone ON uszone.numZone = uslieu.numZone WHERE";
this.strCommande += " uszone.numCommune = '" + numCommune + "' AND";
this.strCommande += " `numQuartier`='" + lieu.NumQuartier + "' AND";
this.strCommande += " `numLieu`<>'" + lieu.NumLieu + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
numLieu = this.reader["numLieu"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numLieu);
}
crlUSBillet IntfDalUSBillet.selectUSBillet(string numBillet)
{
#region declaration
crlUSBillet billet = null;
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
#endregion
#region implementation
if (numBillet != "")
{
this.strCommande = "SELECT * FROM `usbillet` WHERE `numBillet`='" + numBillet + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
billet = new crlUSBillet();
try
{
billet.DateBillet = Convert.ToDateTime(this.reader["dateBillet"].ToString());
}
catch (Exception) { }
billet.MatriculeAgent = this.reader["matriculeAgent"].ToString();
billet.ModeDePaiement = this.reader["modeDePaiement"].ToString();
try
{
billet.Montant = double.Parse(this.reader["montant"].ToString());
}
catch (Exception) { }
try
{
billet.Niveau = int.Parse(this.reader["niveau"].ToString());
}
catch (Exception) { }
billet.NumCarteReduction = this.reader["numCarteReduction"].ToString();
billet.NumAbonnementNV = this.reader["numAbonnementNV"].ToString();
billet.NumBillet = this.reader["numBillet"].ToString();
billet.NumLieuD = this.reader["numLieuD"].ToString();
billet.NumLieuF = this.reader["numLieuF"].ToString();
billet.NumZoneD = this.reader["numZoneD"].ToString();
billet.NumZoneF = this.reader["numZoneF"].ToString();
try
{
billet.ValideAu = Convert.ToDateTime(this.reader["valideAu"].ToString());
}
catch (Exception) { }
billet.NumCategorieBillet = this.reader["numCategorieBillet"].ToString();
billet.NumReductionBillet = this.reader["numReductionBillet"].ToString();
billet.NumTicket = this.reader["numTicket"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (billet != null)
{
if (billet.NumZoneD != "")
{
billet.zoneD = serviceUSZone.selectUSZone(billet.NumZoneD);
}
if (billet.NumZoneF != "")
{
billet.zoneF = serviceUSZone.selectUSZone(billet.NumZoneF);
}
}
}
#endregion
return(billet);
}
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);
}
crlUSAbonnementNVDevis IntfDalUSAbonnementNVDevis.selectUSAbonnementNVDevis(string numAbonnementNVDevis)
{
#region declaration
crlUSAbonnementNVDevis abonnementNVDevis = null;
IntfDalUSInfoPasse serviceUSInfoPasse = new ImplDalUSInfoPasse();
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
#endregion
#region implementation
if (numAbonnementNVDevis != "")
{
this.strCommande = "SELECT * FROM `usabonnementnvdevis` WHERE `numAbonnementNVDevis`='" + numAbonnementNVDevis + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
abonnementNVDevis = new crlUSAbonnementNVDevis();
abonnementNVDevis.NumProforma = this.reader["numProforma"].ToString();
try
{
abonnementNVDevis.MontantNV = double.Parse(this.reader["montantNV"].ToString());
}
catch (Exception) { }
try
{
abonnementNVDevis.PrixUnitaireNV = double.Parse(this.reader["prixUnitaireNV"].ToString());
}
catch (Exception) { }
abonnementNVDevis.NumAbonnement = this.reader["numAbonnement"].ToString();
abonnementNVDevis.NumAbonnementNVDevis = this.reader["numAbonnementNVDevis"].ToString();
abonnementNVDevis.NumCategorieBillet = this.reader["numCategorieBillet"].ToString();
abonnementNVDevis.NumReductionBillet = this.reader["numReductionBillet"].ToString();
abonnementNVDevis.NumZoneD = this.reader["numZoneD"].ToString();
abonnementNVDevis.NumZoneF = this.reader["numZoneF"].ToString();
abonnementNVDevis.NumInfoPasse = this.reader["numInfoPasse"].ToString();
abonnementNVDevis.NumCarte = this.reader["numCarte"].ToString();
try
{
abonnementNVDevis.MontantCarte = double.Parse(this.reader["montantCarte"].ToString());
}
catch (Exception)
{
}
try
{
abonnementNVDevis.DateAbonnementNVDevis = Convert.ToDateTime(this.reader["dateAbonnementNVDevis"].ToString());
}
catch (Exception)
{
}
abonnementNVDevis.NumAbonnementNV = this.reader["numAbonnementNV"].ToString();
try
{
abonnementNVDevis.NombreVoyage = int.Parse(this.reader["nombreVoyage"].ToString());
}
catch (Exception)
{
}
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (abonnementNVDevis != null)
{
if (abonnementNVDevis.NumInfoPasse != "")
{
abonnementNVDevis.infoPasse = serviceUSInfoPasse.selectUSInfoPasse(abonnementNVDevis.NumInfoPasse);
}
if (abonnementNVDevis.NumZoneD != "")
{
abonnementNVDevis.zoneD = serviceUSZone.selectUSZone(abonnementNVDevis.NumZoneD);
}
if (abonnementNVDevis.NumZoneF != "")
{
abonnementNVDevis.zoneF = serviceUSZone.selectUSZone(abonnementNVDevis.NumZoneF);
}
}
}
#endregion
return(abonnementNVDevis);
}
DataTable IntfDalUSAbonnementNV.getDataTableAbonnementNV(string strRqst)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
crlUSZone zoneD = null;
crlUSZone zoneF = null;
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("numAbonnementNV", typeof(string));
dataTable.Columns.Add("dateValideAu", typeof(DateTime));
dataTable.Columns.Add("nombreVoyage", typeof(string));
dataTable.Columns.Add("zone", typeof(string));
dataTable.Columns.Add("numCarte", 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["numAbonnementNV"] = reader["numAbonnementNV"].ToString();
dr["dateValideAu"] = Convert.ToDateTime(reader["dateValideAu"].ToString());
dr["nombreVoyage"] = reader["nbVoyage"].ToString();
zoneD = serviceUSZone.selectUSZone(reader["numZoneD"].ToString());
zoneF = serviceUSZone.selectUSZone(reader["numZoneF"].ToString());
if (zoneD != null && zoneF != null)
{
dr["zone"] = zoneD.NomZone + "-" + zoneF.NomZone;
}
else
{
dr["zone"] = reader["numZoneD"].ToString() + "-" + reader["numZoneF"].ToString();
}
dr["numCarte"] = reader["numCarte"].ToString();
dataTable.Rows.Add(dr);
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
#endregion
return(dataTable);
}
List <crlUSAbonnementNVDevis> IntfDalUSAbonnementNV.getAbonnementNVDevisValide(string numAbonnementNV)
{
#region declaration
List <crlUSAbonnementNVDevis> abonnementNVDevisValide = null;
crlUSAbonnementNVDevis abonnementNVDevisTemp = null;
IntfDalUSZone serviceUSZone = new ImplDalUSZone();
IntfDalUSInfoPasse serviceUSInfoPasse = new ImplDalUSInfoPasse();
#endregion
#region implementation
if (numAbonnementNV != "")
{
this.strCommande = "SELECT usabonnementnvdevis.numAbonnementNVDevis, usabonnementnvdevis.numAbonnement,";
this.strCommande += " usabonnementnvdevis.prixUnitaireNV, usabonnementnvdevis.montantNV,";
this.strCommande += " usabonnementnvdevis.numZoneD, usabonnementnvdevis.numZoneF,";
this.strCommande += " usabonnementnvdevis.numReductionBillet, usabonnementnvdevis.numCategorieBillet,";
this.strCommande += " usabonnementnvdevis.numProforma, usabonnementnvdevis.numInfoPasse,";
this.strCommande += " usabonnementnvdevis.numCarte, usabonnementnvdevis.montantCarte,";
this.strCommande += " usabonnementnvdevis.dateAbonnementNVDevis, usabonnementnvdevis.numAbonnementNV,";
this.strCommande += " usabonnementnvdevis.nombreVoyage FROM usabonnementnvdevis";
this.strCommande += " WHERE usabonnementnvdevis.numAbonnementNV = '" + numAbonnementNV + "' AND";
this.strCommande += " usabonnementnvdevis.nombreVoyage > '0'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
abonnementNVDevisValide = new List <crlUSAbonnementNVDevis>();
while (this.reader.Read())
{
abonnementNVDevisTemp = new crlUSAbonnementNVDevis();
try
{
abonnementNVDevisTemp.DateAbonnementNVDevis = Convert.ToDateTime(this.reader["dateAbonnementNVDevis"].ToString());
}
catch (Exception)
{
}
try
{
abonnementNVDevisTemp.MontantCarte = double.Parse(this.reader["montantCarte"].ToString());
}
catch (Exception)
{
}
try
{
abonnementNVDevisTemp.MontantNV = double.Parse(this.reader["montantNV"].ToString());
}
catch (Exception)
{
}
try
{
abonnementNVDevisTemp.NombreVoyage = int.Parse(this.reader["nombreVoyage"].ToString());
}
catch (Exception)
{
}
abonnementNVDevisTemp.NumAbonnement = this.reader["numAbonnement"].ToString();
abonnementNVDevisTemp.NumAbonnementNV = this.reader["numAbonnementNV"].ToString();
abonnementNVDevisTemp.NumAbonnementNVDevis = this.reader["numAbonnementNVDevis"].ToString();
abonnementNVDevisTemp.NumCarte = this.reader["numCarte"].ToString();
abonnementNVDevisTemp.NumCategorieBillet = this.reader["numCategorieBillet"].ToString();
abonnementNVDevisTemp.NumInfoPasse = this.reader["numInfoPasse"].ToString();
abonnementNVDevisTemp.NumProforma = this.reader["numProforma"].ToString();
abonnementNVDevisTemp.NumReductionBillet = this.reader["numReductionBillet"].ToString();
abonnementNVDevisTemp.NumZoneD = this.reader["numZoneD"].ToString();
abonnementNVDevisTemp.NumZoneF = this.reader["numZoneF"].ToString();
try
{
abonnementNVDevisTemp.PrixUnitaireNV = double.Parse(this.reader["prixUnitaireNV"].ToString());
}
catch (Exception)
{
}
if (abonnementNVDevisTemp.NumInfoPasse != "")
{
abonnementNVDevisTemp.infoPasse = serviceUSInfoPasse.selectUSInfoPasse(abonnementNVDevisTemp.NumInfoPasse);
}
if (abonnementNVDevisTemp.NumZoneD != "")
{
abonnementNVDevisTemp.zoneD = serviceUSZone.selectUSZone(abonnementNVDevisTemp.NumZoneD);
}
if (abonnementNVDevisTemp.NumZoneF != "")
{
abonnementNVDevisTemp.zoneF = serviceUSZone.selectUSZone(abonnementNVDevisTemp.NumZoneF);
}
abonnementNVDevisValide.Add(abonnementNVDevisTemp);
abonnementNVDevisTemp = null;
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(abonnementNVDevisValide);
}