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
}
