bool IntfDalVille.deleteVille(crlVille Ville) { #region declaration bool isDelete = false; int nombreDelete = 0; #endregion #region implementation if (Ville != null) { if (Ville.NumVille != "") { this.strCommande = "DELETE FROM `ville` WHERE (`numVille` = '" + Ville.NumVille + "')"; this.serviceConnectBase.openConnection(); nombreDelete = this.serviceConnectBase.requete(this.strCommande); if (nombreDelete == 1) { isDelete = true; } this.serviceConnectBase.closeConnection(); } } #endregion return(isDelete); }
DataTable IntfDalFicheBord.getDataTableFicheBordSansAD(string strRqst) { #region declaration DataTable dataTable = new DataTable(); IntfDalVille serviceVille = new ImplDalVille(); crlVille villeD = new crlVille(); crlVille villeF = new crlVille(); #endregion #region implementation #region initialisation du dataTable dataTable = new DataTable(); dataTable.Columns.Add("numFb", typeof(string)); dataTable.Columns.Add("dateHeurPrevue", typeof(DateTime)); dataTable.Columns.Add("voiture", typeof(string)); dataTable.Columns.Add("chauffeur", typeof(string)); dataTable.Columns.Add("itineraire", typeof(string)); dataTable.Columns.Add("nbPlaceLibre", 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["numFb"] = reader["numFb"].ToString(); dr["dateHeurPrevue"] = Convert.ToDateTime(reader["dateHeurPrevue"].ToString()); dr["voiture"] = reader["matriculeVehicule"].ToString() + " " + reader["marqueVehicule"].ToString(); dr["chauffeur"] = reader["nomChauffeur"].ToString() + " " + reader["prenomChauffeur"].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["nbPlaceLibre"] = (int.Parse(reader["nbPlace"].ToString()) - int.Parse(reader["nbOccuper"].ToString())).ToString(); dataTable.Rows.Add(dr); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); #endregion return(dataTable); }
bool IntfDalVille.updateVille(crlVille Ville) { #region declaration bool isUpdate = false; int nombreUpdate = 0; #endregion #region implementation if (Ville != null) { if (Ville.NumVille != "") { this.strCommande = "UPDATE `ville` SET `nomVille`='" + Ville.NomVille + "',"; this.strCommande += " `nomRegion`='" + Ville.NomRegion + "',`nomProvince`='" + Ville.NomProvince + "'"; this.strCommande += " WHERE (`numVille`='" + Ville.NumVille + "')"; this.serviceConnectBase.openConnection(); nombreUpdate = this.serviceConnectBase.requete(this.strCommande); if (nombreUpdate == 1) { isUpdate = true; } this.serviceConnectBase.closeConnection(); } } #endregion return(isUpdate); }
string IntfDalVille.insertVille(crlVille Ville, string sigleAgence) { #region declaration IntfDalVille serviceVille = new ImplDalVille(); int nombreInsertion = 0; string numVille = ""; #endregion #region implementation if (Ville != null) { Ville.NumVille = serviceVille.getNumVille(sigleAgence); this.strCommande = "INSERT INTO `ville` (`numVille`,`nomVille`,`nomRegion`,`nomProvince`)"; this.strCommande += " VALUES ('" + Ville.NumVille + "','" + Ville.NomVille + "',"; this.strCommande += "'" + Ville.NomRegion + "', '" + Ville.NomProvince + "')"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { numVille = Ville.NumVille; } this.serviceConnectBase.closeConnection(); } #endregion return(numVille); }
DataTable IntfDalBillet.getDataTableBilletInsertToFB(string strRqst) { #region declaration DataTable dataTable = new DataTable(); IntfDalVille serviceVille = new ImplDalVille(); crlVille villeD = new crlVille(); crlVille villeF = new crlVille(); #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("client", 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["client"] = reader["nomIndividu"].ToString() + " " + reader["prenomIndividu"].ToString(); villeD = serviceVille.selectVille(reader["numVilleD"].ToString()); villeF = serviceVille.selectVille(reader["numVilleF"].ToString()); if (villeD != null && villeF != null) { dr["trajet"] = villeD.NomVille + "-" + villeF.NomVille; } else { dr["trajet"] = reader["numVilleD"].ToString() + "-" + reader["numVilleF"].ToString(); } dataTable.Rows.Add(dr); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); #endregion return(dataTable); }
private void insertToObjetVille(crlVille ville) { #region implementation if (ville != null) { ville.NomProvince = ddlProvince.SelectedValue; ville.NomRegion = ddlRegion.SelectedValue; ville.NomVille = TextNomVille.Text; } #endregion }
public crlAgence() { this.NumAgence = ""; this.NumVille = ""; this.TypeAgence = ""; this.SigleAgence = ""; this.NomAgence = ""; this.LocalisationAgence = ""; this.typeAgence = null; this.ville = null; this.sessionAgence = null; }
List <crlVille> IntfDalVille.selectVillesForRN(string routeNationale) { #region declaration List <crlVille> Villes = null; crlVille tempVille = null; #endregion #region implementation if (routeNationale != "") { this.strCommande = "SELECT ville.numVille, ville.nomVille, ville.nomRegion,"; this.strCommande += " ville.nomProvince FROM ville"; this.strCommande += " Inner Join assovilleroutenationale ON assovilleroutenationale.numVille = ville.numVille"; this.strCommande += " WHERE assovilleroutenationale.routeNationale = '" + routeNationale + "'"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { Villes = new List <crlVille>(); while (this.reader.Read()) { tempVille = new crlVille(); tempVille.NumVille = reader["numVille"].ToString(); tempVille.NomVille = reader["nomVille"].ToString(); tempVille.NomRegion = reader["nomRegion"].ToString(); tempVille.NomProvince = reader["nomProvince"].ToString(); tempVille.region = new crlRegion(); tempVille.region.NomRegion = tempVille.NomRegion; tempVille.province = new crlProvince(); tempVille.province.nomProvince = tempVille.NomProvince; Villes.Add(tempVille); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(Villes); }
private void afficheVille(string numVille) { #region declaration crlVille ville = null; string strConfirm = ""; #endregion #region implementation if (numVille != "") { ville = serviceVille.selectVille(numVille); if (ville != null) { try { ddlProvince.SelectedValue = ville.NomProvince; } catch (Exception) { } try { ddlRegion.SelectedValue = ville.NomRegion; } catch (Exception) { } TextNomVille.Text = ville.NomVille; hfNumVille.Value = ville.NumVille; strConfirm = "Voulez vous vraiment modifier le ville " + ville.NomVille + "?"; btnModifier_ConfirmButtonExtender.ConfirmText = strConfirm; btnModifier.Enabled = true; btnValider.Enabled = false; } } #endregion }
crlVille IntfDalVille.selectVilleNom(string nomVille) { #region declaration crlVille Ville = null; #endregion #region implementation if (nomVille != "") { this.strCommande = "SELECT * FROM `ville` WHERE (`nomVille`='" + nomVille + "')"; this.serviceConnectBase.openConnection(); this.reader = this.serviceConnectBase.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { Ville = new crlVille(); Ville.NumVille = reader["numVille"].ToString(); Ville.NomVille = reader["nomVille"].ToString(); Ville.NomRegion = reader["nomRegion"].ToString(); Ville.NomProvince = reader["nomProvince"].ToString(); Ville.region = new crlRegion(); Ville.region.NomRegion = Ville.NomRegion; Ville.province = new crlProvince(); Ville.province.nomProvince = Ville.NomProvince; } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(Ville); }
string IntfDalVille.isVille(crlVille Ville) { #region declaration string isVille = ""; #endregion #region implementation if (Ville != null) { this.strCommande = "SELECT * FROM `ville` WHERE (`numVille`<>'" + Ville.NumVille + "' AND"; this.strCommande += " `nomVille`='" + Ville.NomVille + "' AND `nomRegion`='" + Ville.NomRegion + "' AND"; this.strCommande += " `nomProvince`='" + Ville.NomProvince + "')"; this.serviceConnectBase.openConnection(); reader = this.serviceConnectBase.select(this.strCommande); if (reader != null) { if (reader.HasRows) { while (reader.Read()) { if (Ville.NomVille.Trim().ToLower().Equals(reader["nomVille"].ToString().Trim().ToLower()) && Ville.NomRegion.Trim().ToLower().Equals(reader["nomRegion"].ToString().Trim().ToLower()) && Ville.NomProvince.Trim().ToLower().Equals(reader["nomProvince"].ToString().Trim().ToLower())) { isVille = reader["numVille"].ToString(); break; } } } reader.Dispose(); } this.serviceConnectBase.closeConnection(); } #endregion return(isVille); }
protected void btnModifier_Click(object sender, EventArgs e) { #region declaration crlVille ville = null; string strIndication = ""; string numVille = ""; #endregion #region implementation if (hfNumVille.Value != "") { ville = serviceVille.selectVille(hfNumVille.Value); if (ville != null) { this.insertToObjetVille(ville); numVille = serviceVille.isVille(ville); if (numVille.Equals("")) { if (serviceVille.updateVille(ville)) { this.initialiseGridVille(); } else { } } else { // } } } #endregion }
protected void btnValider_Click(object sender, EventArgs e) { #region declaration crlVille ville = null; string strIndication = ""; #endregion #region implementation ville = new crlVille(); this.insertToObjetVille(ville); ville.NumVille = serviceVille.isVille(ville); if (ville.NumVille.Equals("")) { ville.NumVille = serviceVille.insertVille(ville, agent.agence.SigleAgence); if (ville.NumVille != "") { this.initialiseFormulaire(); strIndication = "Ville " + ville.NomVille + " bien enregistrer!"; this.divIndicationText(strIndication, "Black"); this.initialiseGridVille(); } else { strIndication = "Une erreur ce produit durant l'enregistrement!"; this.divIndicationText(strIndication, "Red"); } } else { this.afficheVille(ville.NumVille); } #endregion }
bool IntfDalTrajet.insertAssociationVilleTrajet(crlTrajet Trajet, crlVille Ville) { #region declaration bool isInsert = false; int nombreInsertion = 0; #endregion #region implementation if (Trajet != null && Ville != null) { this.strCommande = "INSERT INTO `associationvilletrajet` (`numTrajet`,`numVille`)"; this.strCommande += " VALUES ('" + Trajet.NumTrajet + "','" + Ville.NumVille + "')"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { isInsert = true; } this.serviceConnectBase.closeConnection(); } #endregion return(isInsert); }
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 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); }
DataTable IntfDalAgence.getDataTableAgenceListe(string strRqst) { #region declaration DataTable dataTable = new DataTable(); crlAgence agence = null; IntfDalVille serviceVille = new ImplDalVille(); IntfDalAgence serviceAgence = new ImplDalAgence(); crlVille ville = null; #endregion #region implemntation #region initialisation du dataTable dataTable = new DataTable(); dataTable.Columns.Add("numAgence", typeof(string)); dataTable.Columns.Add("villeAgence", typeof(string)); dataTable.Columns.Add("nomAgence", typeof(string)); dataTable.Columns.Add("localisation", typeof(string)); dataTable.Columns.Add("typeAgence", typeof(string)); dataTable.Columns.Add("sigleAgence", typeof(string)); dataTable.Columns.Add("statut", 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(); agence = serviceAgence.selectAgence(this.reader["numAgence"].ToString()); dr["numAgence"] = this.reader["numAgence"].ToString(); ville = serviceVille.selectVille(this.reader["numVille"].ToString()); if (ville != null) { dr["villeAgence"] = ville.NomVille; } else { dr["villeAgence"] = this.reader["numVille"].ToString(); } dr["nomAgence"] = this.reader["nomAgence"].ToString(); dr["sigleAgence"] = this.reader["sigleAgence"].ToString(); dr["localisation"] = this.reader["localisationAgence"].ToString(); dr["typeAgence"] = this.reader["typeAgence"].ToString(); if (agence.sessionAgence != null) { dr["statut"] = "vert16.png"; } else { dr["statut"] = "rouge16.png"; } dataTable.Rows.Add(dr); } } this.reader.Dispose(); } this.serviceConnectBase.closeConnection(); #endregion return(dataTable); }
DataTable IntfDalVerification.getDataTableVerificationNonValider(string strRqst) { #region declaration DataTable dataTable = new DataTable(); IntfDalVille serviceVille = new ImplDalVille(); crlVille villeD = null; crlVille villeF = null; #endregion #region implementation #region initialisation du dataTable dataTable = new DataTable(); dataTable.Columns.Add("idVerification", typeof(string)); dataTable.Columns.Add("dateVerification", typeof(DateTime)); dataTable.Columns.Add("vehicule", typeof(string)); dataTable.Columns.Add("chauffeur", typeof(string)); dataTable.Columns.Add("itineraire", 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["idVerification"] = reader["idVerification"].ToString(); dr["dateVerification"] = Convert.ToDateTime(reader["dateVerification"].ToString()); dr["vehicule"] = reader["matriculeVehicule"].ToString() + " " + reader["marqueVehicule"].ToString() + " " + reader["couleurVehicule"].ToString(); dr["chauffeur"] = reader["prenomChauffeur"].ToString() + " " + reader["nomChauffeur"].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(); } dataTable.Rows.Add(dr); } } this.reader.Dispose(); } this.serviceConnectBase.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 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); }