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);
}
bool IntfDalUSZone.updateUSZone(crlUSZone zone)
{
#region declaration
bool isUpdate = false;
int nbUpdate = 0;
#endregion
#region implementation
if (zone != null)
{
this.strCommande = "UPDATE `uszone` SET `nomZone`='" + zone.NomZone + "',";
this.strCommande += " `niveau`='" + zone.Niveau + "',`numCommune`='" + zone.NumCommune + "'";
this.strCommande += " WHERE `numZone`='" + zone.NumZone + "'";
this.serviceConnectBase.openConnection();
nbUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nbUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isUpdate);
}
string IntfDalUSZone.isUSZone(crlUSZone zone)
{
#region declaration
string numZone = "";
#endregion
#region implementation
if (zone != null)
{
this.strCommande = "SELECT * FROM `uszone` WHERE (`numZone`<>'" + zone.NumZone + "'";
this.strCommande += " AND `nomZone`='" + zone.NomZone + "' AND `umCommune`='" + zone.NumCommune + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
numZone = this.reader["numZone"].ToString();
}
}
this.reader.Dispose();
}
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
}
int IntfDalUSPrixBase.getNiveauPrixBase(crlUSZone zoneD, crlUSZone zoneF, bool isMemeAxe)
{
#region declaration
int niveau = -1;
#endregion
#region implementation
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);
}
crlUSZone IntfDalUSZone.selectUSZone(string numZone)
{
#region declaration
crlUSZone zone = null;
#endregion
#region implementation
if (numZone != "")
{
this.strCommande = "SELECT * FROM `uszone` WHERE (`numZone`='" + numZone + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
zone = new crlUSZone();
zone.NumZone = this.reader["numZone"].ToString();
zone.NomZone = this.reader["nomZone"].ToString();
try
{
zone.Niveau = int.Parse(this.reader["niveau"].ToString());
}
catch (Exception) { }
zone.NumCommune = this.reader["numCommune"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(zone);
}
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 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);
}
