string IntfDalUSArret.insertUSArret(crlUSArret arret, string sigleAgence)
{
#region declaration
string numArret = "";
IntfDalUSArret serviceUSArret = new ImplDalUSArret();
int nbInsert = 0;
#endregion
#region implemenation
if (arret != null && sigleAgence != "")
{
arret.NumArret = serviceUSArret.getNumUSArret(sigleAgence);
this.strCommande = "INSERT INTO `usarret` (`numArret`,`numLieu`,`nomArret`,`descriptionArret`)";
this.strCommande += " VALUES ('" + arret.NumArret + "','" + arret.NumLieu + "','" + arret.NomArret + "',";
this.strCommande += " '" + arret.DescriptionArret + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numArret = arret.NomArret;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numArret);
}
crlUSTrajet IntfDalUSTrajet.selectUSTrajet(string numTrajet)
{
#region declaration
crlUSTrajet trajet = null;
IntfDalUSArret serviceUSArret = new ImplDalUSArret();
#endregion
#region implementation
if (numTrajet != "")
{
this.strCommande = "SELECT * FROM `ustrajet` WHERE (`numTrajet`='" + numTrajet + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
trajet = new crlUSTrajet();
trajet.NumArretD = this.reader["numArretD"].ToString();
trajet.NumArretF = this.reader["numArretF"].ToString();
try
{
trajet.DistanceTrajet = double.Parse(this.reader["distanceTrajet"].ToString());
}
catch (Exception) { }
trajet.DureeTrajet = this.reader["dureeTrajet"].ToString();
trajet.NumTrajet = this.reader["numTrajet"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (trajet != null)
{
trajet.arretD = serviceUSArret.selectUSArret(trajet.NumArretD);
trajet.arretF = serviceUSArret.selectUSArret(trajet.NumArretF);
}
}
#endregion
return(trajet);
}
crlUSLigne IntfDalUSLigne.selectUSLigne(string numLigne)
{
#region declaration
crlUSLigne ligne = null;
IntfDalUSArret serviceUSArret = new ImplDalUSArret();
#endregion
#region implementation
if (numLigne != "")
{
this.strCommande = "SELECT * FROM `usligne` WHERE (`numLigne`='" + numLigne + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
ligne = new crlUSLigne();
ligne.NumLigne = this.reader["numLigne"].ToString();
ligne.DescriptionLigne = this.reader["descriptionLigne"].ToString();
ligne.NumCooperative = this.reader["numCooperative"].ToString();
ligne.NomLigne = this.reader["nomLigne"].ToString();
ligne.Zone = this.reader["zone"].ToString();
ligne.NumArretD = this.reader["numArretD"].ToString();
ligne.NumArretF = this.reader["numArretF"].ToString();
ligne.NumAxe = this.reader["numAxe"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (ligne != null)
{
ligne.arretD = serviceUSArret.selectUSArret(ligne.NumArretD);
ligne.arretF = serviceUSArret.selectUSArret(ligne.NumArretF);
}
}
#endregion
return(ligne);
}
void IntfDalUSArret.insertToGridArretLigne(GridView gridView, string param, string paramLike, string valueLike, string numLigne)
{
#region declaration
IntfDalUSArret serviceUSArret = new ImplDalUSArret();
#endregion
#region implementation
this.strCommande = "SELECT usarret.numArret, usarret.numLieu, usarret.nomArret,";
this.strCommande += " usarret.descriptionArret, uslieu.nomLieu,";
this.strCommande += " uszone.nomZone FROM usarret";
this.strCommande += " Inner Join uslieu ON uslieu.numLieu = usarret.numLieu";
this.strCommande += " Inner Join uszone ON uszone.numZone = uslieu.numZone";
this.strCommande += " Inner Join usassoclignearret ON usassoclignearret.numArret = usarret.numArret";
this.strCommande += " WHERE usassoclignearret.numLigne = '" + numLigne + "' AND";
this.strCommande += " " + paramLike + " LIKE '%" + valueLike + "%'";
this.strCommande += " ORDER BY " + param;
gridView.DataSource = serviceUSArret.getDataTableArretLigne(this.strCommande);
gridView.DataBind();
#endregion
}
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);
}
