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); }