string IntfDalRecuAD.insertRecuAD(crlRecuAD RecuAD)
{
#region declaration
IntfDalRecuAD serviceRecuAD = new ImplDalRecuAD();
int nombreInsertion = 0;
string numRecu = "";
string numPrelevement = "NULL";
string numFacture = "NULL";
#endregion
#region implementation
if (RecuAD != null)
{
if (RecuAD.NumPrelevement != "")
{
numPrelevement = "'" + RecuAD.NumPrelevement + "'";
}
if (RecuAD.NumFacture != "")
{
numFacture = "'" + RecuAD.NumFacture + "'";
}
RecuAD.NumRecuAD = serviceRecuAD.getNumRecuAD(RecuAD.agent.agence.SigleAgence);
this.strCommande = "INSERT INTO `recuad` (`numRecuAD`,`numPrelevement`,`matriculeAgent`,`libele`,`montant`,`dateRecu`,`numFacture`)";
this.strCommande += " VALUES ('" + RecuAD.NumRecuAD + "', " + numPrelevement + ", '" + RecuAD.MatriculeAgent + "',";
this.strCommande += " '" + RecuAD.Libele + "','" + RecuAD.Montant + "','" + RecuAD.Date.ToString("yyyy-MM-dd") + "'," + numFacture + ")";
this.serviceConnectBase.openConnection();
nombreInsertion = this.serviceConnectBase.requete(this.strCommande);
if (nombreInsertion == 1)
{
numRecu = RecuAD.NumRecuAD;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numRecu);
}
