string IntfDalQuartier.insertQuartier(crlQuartier quartier, string sigleAgence)
{
#region declaration
IntfDalQuartier serviceQuartier = new ImplDalQuartier();
string numQuartier = "";
int nbInsert = 0;
string numArrondissement = "NULL";
#endregion
#region implementation
if (quartier != null)
{
if (quartier.NumArrondissement != "")
{
numArrondissement = "'" + quartier.NumArrondissement + "'";
}
quartier.NumQuartier = serviceQuartier.getNumQuartier(sigleAgence);
this.strCommande = "INSERT INTO `quartier` (`numQuartier`,`quartier`,`numCommune`,`numArrondissement`)";
this.strCommande += " VALUES ('" + quartier.NumQuartier + "','" + quartier.Quartier + "',";
this.strCommande += " '" + quartier.NumCommune + "'," + numArrondissement + ")";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numQuartier = quartier.NumQuartier;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numQuartier);
}
bool IntfDalQuartier.updateQuartier(crlQuartier quartier)
{
#region declaration
bool isUpdate = false;
int nbUpdate = 0;
string numArrondissement = "NULL";
#endregion
#region implementation
if (quartier != null)
{
if (quartier.NumArrondissement != "")
{
numArrondissement = "'" + quartier.NumArrondissement + "'";
}
this.strCommande = "UPDATE `quartier` SET `quartier`='" + quartier.Quartier + "',";
this.strCommande += " `numCommune`='" + quartier.NumCommune + "',";
this.strCommande += " `numArrondissement`=" + numArrondissement + " WHERE";
this.strCommande += " `numQuartier`='" + quartier.NumQuartier + "'";
this.serviceConnectBase.openConnection();
nbUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nbUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isUpdate);
}
crlQuartier IntfDalQuartier.selectQuartier(string numQuartier)
{
#region declaration
crlQuartier quartier = null;
#endregion
#region implementation
if (numQuartier != "")
{
this.strCommande = "SELECT * FROM `quartier` WHERE `numQuartier`='" + numQuartier + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
quartier = new crlQuartier();
quartier.NumArrondissement = this.reader["numArrondissement"].ToString();
quartier.NumCommune = this.reader["numCommune"].ToString();
quartier.NumQuartier = this.reader["numQuartier"].ToString();
quartier.Quartier = this.reader["quartier"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(quartier);
}
string IntfDalQuartier.getNumQuartier(string quartier, string numCommune, string numArrondissement, string sigleAgence)
{
#region declaration
string numQuartier = "";
crlQuartier quartierObj = null;
IntfDalQuartier serviceQuartier = new ImplDalQuartier();
#endregion
#region implementation
if (quartier != null)
{
quartierObj = new crlQuartier();
quartierObj.Quartier = quartier;
quartierObj.NumArrondissement = numArrondissement;
quartierObj.NumCommune = numCommune;
numQuartier = serviceQuartier.isQuartier(quartierObj);
if (numQuartier.Equals(""))
{
numQuartier = serviceQuartier.insertQuartier(quartierObj, sigleAgence);
}
}
#endregion
return(numQuartier);
}
string IntfDalQuartier.isQuartier(crlQuartier quartier)
{
#region declaration
string numQuartier = "";
#endregion
#region implementation
if (quartier != null)
{
this.strCommande = "SELECT * FROM `quartier` WHERE";
this.strCommande += " quartier.quartier = '" + quartier.Quartier + "' AND";
this.strCommande += " quartier.numArrondissement = '" + quartier.NumArrondissement + "' AND";
this.strCommande += " quartier.numCommune = '" + quartier.NumCommune + "' AND";
this.strCommande += " quartier.numQuartier <> '" + quartier.NumQuartier + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
numQuartier = this.reader["numQuartier"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numQuartier);
}
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);
}
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
}
