crlRecuAD IntfDalRecuAD.selectRecuAD(string numRecuAD)
{
#region declaration
crlRecuAD RecuAD = null;
IntfDalAgent serviceAgent = new ImplDalAgent();
IntfDalPrelevement servicePrelevement = new ImplDalPrelevement();
#endregion
#region implementation
if (numRecuAD != "")
{
this.strCommande = "SELECT * FROM `recuad` WHERE (`numRecuAD`='" + numRecuAD + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
RecuAD = new crlRecuAD();
reader.Read();
RecuAD.NumRecuAD = reader["numRecuAD"].ToString();
RecuAD.MatriculeAgent = reader["matriculeAgent"].ToString();
RecuAD.NumPrelevement = reader["numPrelevement"].ToString();
RecuAD.Libele = reader["libele"].ToString();
RecuAD.Montant = reader["montant"].ToString();
RecuAD.NumFacture = reader["numFacture"].ToString();
try
{
RecuAD.Date = Convert.ToDateTime(reader["dateRecu"].ToString());
}
catch (Exception)
{
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (RecuAD != null)
{
if (RecuAD.MatriculeAgent != "")
{
RecuAD.agent = serviceAgent.selectAgent(RecuAD.MatriculeAgent);
}
if (RecuAD.NumPrelevement != "")
{
RecuAD.prelevement = servicePrelevement.selectPrelevement(RecuAD.NumPrelevement);
}
}
}
#endregion
return(RecuAD);
}
List <crlRecuAD> IntfDalRecuAD.selectRecuADFacture(string numFacture)
{
#region declaration
crlRecuAD tempRecuAD = null;
List <crlRecuAD> recuADs = null;
IntfDalAgent serviceAgent = new ImplDalAgent();
IntfDalPrelevement servicePrelevement = new ImplDalPrelevement();
#endregion
#region implementation
if (numFacture != "")
{
this.strCommande = "SELECT (recuad.numRecuAD) AS numR, recuad.numPrelevement, recuad.matriculeAgent, recuad.libele,";
this.strCommande += " recuad.montant, recuad.dateRecu FROM recuad";
this.strCommande += " Inner Join prelevement ON prelevement.numPrelevement = recuad.numPrelevement";
this.strCommande += " Inner Join autorisationdepart ON autorisationdepart.numAutorisationDepart = prelevement.numAutorisationDepart";
this.strCommande += " Inner Join assocautorisationdepartfacture ON assocautorisationdepartfacture.numAutorisationDepart = autorisationdepart.numAutorisationDepart";
this.strCommande += " WHERE assocautorisationdepartfacture.numFacture = '" + numFacture + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
recuADs = new List <crlRecuAD>();
while (reader.Read())
{
tempRecuAD = new crlRecuAD();
tempRecuAD.NumRecuAD = reader["numR"].ToString();
tempRecuAD.MatriculeAgent = reader["matriculeAgent"].ToString();
tempRecuAD.NumPrelevement = reader["numPrelevement"].ToString();
tempRecuAD.Libele = reader["libele"].ToString();
tempRecuAD.Montant = reader["montant"].ToString();
try
{
tempRecuAD.Date = Convert.ToDateTime(reader["dateRecu"].ToString());
}
catch (Exception)
{
}
recuADs.Add(tempRecuAD);
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (recuADs != null)
{
for (int i = 0; i < recuADs.Count; i++)
{
if (recuADs[i].MatriculeAgent != "")
{
recuADs[i].agent = serviceAgent.selectAgent(recuADs[i].MatriculeAgent);
}
if (recuADs[i].NumPrelevement != "")
{
recuADs[i].prelevement = servicePrelevement.selectPrelevement(recuADs[i].NumPrelevement);
}
}
}
}
#endregion
return(recuADs);
}
