string IntfDalDistrict.isDistrict(crlDistrict district)
{
#region declaration
string numDisrict = "";
#endregion
#region implementation
if (district != null)
{
this.strCommande = "SELECT * FROM `district` WHERE";
this.strCommande += " district.district = '" + district.District + "' AND";
this.strCommande += " district.nomRegion = '" + district.NomRegion + "' AND";
this.strCommande += " district.numDistrict <> '" + district.NumDistrict + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
numDisrict = this.reader["numDisrict"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numDisrict);
}
string IntfDalDistrict.insertDistrict(crlDistrict district, string sigleAgence)
{
#region declaration
IntfDalDistrict serviceDistrict = new ImplDalDistrict();
string numDistrict = "";
int nbInsert = 0;
#endregion
#region implementation
if (district != null)
{
district.NumDistrict = serviceDistrict.getNumDistrict(sigleAgence);
this.strCommande = "INSERT INTO `district` (`numDistrict`,`district`,`nomRegion`)";
this.strCommande += " VALUES ('" + district.NumDistrict + "','" + district.District + "',";
this.strCommande += " '" + district.NomRegion + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numDistrict = district.NumDistrict;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numDistrict);
}
bool IntfDalDistrict.updateDistrict(crlDistrict district)
{
#region declaration
bool isUpdate = false;
int nbUpdate = 0;
#endregion
#region implementation
if (district != null)
{
this.strCommande = "UPDATE `district` SET `district`='" + district.District + "',";
this.strCommande += " `nomRegion`='" + district.NomRegion + "' WHERE";
this.strCommande += " `numDistrict`='" + district.NumDistrict + "'";
this.serviceConnectBase.openConnection();
nbUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nbUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isUpdate);
}
crlDistrict IntfDalDistrict.selectDistrict(string numDistrict)
{
#region declaration
crlDistrict district = null;
#endregion
#region implementation
if (numDistrict != "")
{
this.strCommande = "SELECT * FROM `district` WHERE `numDistrict`='" + numDistrict + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
district = new crlDistrict();
district.District = this.reader["district"].ToString();
district.NomRegion = this.reader["nomRegion"].ToString();
district.NumDistrict = this.reader["numDistrict"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(district);
}
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
}
