crlRegion IntfDalRegion.selectRegion(string nomRegion) { #region declaration crlRegion region = null; #endregion #region implementation if (nomRegion != "") { this.strCommande = "SELECT * FROM `region` WHERE `nomRegion`='" + nomRegion + "'"; this.serviceConnection.openConnection(); this.reader = this.serviceConnection.select(this.strCommande); if (this.reader != null) { if (this.reader.HasRows) { if (this.reader.Read()) { region = new crlRegion(); region.NomRegion = this.reader["nomRegion"].ToString(); region.NomProvince = this.reader["nomProvince"].ToString(); } } this.reader.Dispose(); } this.serviceConnection.closeConnection(); } #endregion return(region); }
private void afficheQuartierRespSociete(string numQuartier) { #region delcaration crlQuartier quartier = null; crlCommune commune = null; crlDistrict district = null; crlRegion region = null; #endregion #region implementation if (numQuartier != "") { quartier = serviceQuartier.selectQuartier(numQuartier); if (quartier != null) { commune = serviceCommune.selectCommune(quartier.NumCommune); if (commune != null) { district = serviceDistrict.selectDistrict(commune.NumDistrict); if (district != null) { region = serviceRegion.selectRegion(district.NomRegion); if (region != null) { try { ddlprovinceRespSociete.SelectedValue = region.NomProvince; } catch (Exception) { } this.loadDdlRegionRespSociete(); try { ddlRegionRespSociete.SelectedValue = region.NomRegion; } catch (Exception) { } this.loadDdlDistrictRespSociete(); try { ddlDistrictRespSociete.SelectedValue = district.NumDistrict; } catch (Exception) { } this.loadDdlCommuneRespSociete(); try { ddlCommuneRespSociete.SelectedValue = commune.NumCommune; } catch (Exception) { } this.loadDdlArrondissementRespSociete(); try { ddlArrondissementRespSociete.SelectedValue = quartier.NumArrondissement; } catch (Exception) { } TextQuartierRespSociete.Text = quartier.Quartier; } else { this.loadDdlProvinceRespSociete(); } } else { this.loadDdlProvinceRespSociete(); } } else { this.loadDdlProvinceRespSociete(); } } else { this.loadDdlProvinceRespSociete(); } } #endregion }