void IntfDalRecuAD.insertToGridAvanceAutorisationDepart(GridView gridView, string numAutorisationDepart)
{
#region declaration
IntfDalRecuAD serviceRecuAD = new ImplDalRecuAD();
#endregion
#region implementation
this.strCommande = "SELECT recuad.numRecuAD, recuad.matriculeAgent, recuad.libele, recuad.montant,";
this.strCommande += " recuad.dateRecu, recuad.numPrelevement, typeprelevement.commentaire FROM recuad";
this.strCommande += " Inner Join prelevement ON prelevement.numPrelevement = recuad.numPrelevement";
this.strCommande += " Inner Join typeprelevement ON typeprelevement.typePrelevement = prelevement.typePrelevement";
this.strCommande += " WHERE prelevement.numAutorisationDepart = '" + numAutorisationDepart + "'";
gridView.DataSource = serviceRecuAD.getDataTableAvanceAutorisationDepart(this.strCommande);
gridView.DataBind();
#endregion
}
void IntfDalRecuAD.insertToGridRecuADDecaisser(GridView gridView, string param, string paramLike, string valueLike, string matriculeAgent, DateTime dateDebut, DateTime dateFin)
{
#region declaration
IntfDalRecuAD serviceRecuAD = new ImplDalRecuAD();
#endregion
#region implementation
this.strCommande = "SELECT recuad.numRecuAD, recuad.matriculeAgent, recuad.libele, recuad.montant,";
this.strCommande += " recuad.dateRecu, recuad.numPrelevement, typeprelevement.commentaire FROM recuad";
this.strCommande += " Inner Join prelevement ON prelevement.numPrelevement = recuad.numPrelevement";
this.strCommande += " Inner Join typeprelevement ON typeprelevement.typePrelevement = prelevement.typePrelevement";
this.strCommande += " WHERE recuad.matriculeAgent = '" + matriculeAgent + "' AND";
this.strCommande += " recuad.dateRecu <= '" + dateFin.ToString("yyyy-MM-dd") + "' AND";
this.strCommande += " recuad.dateRecu >= '" + dateDebut.ToString("yyyy-MM-dd") + "'";
gridView.DataSource = serviceRecuAD.getDataTableRecuADDecaisser(this.strCommande);
gridView.DataBind();
#endregion
}
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);
}
string IntfDalRecuAD.insertRecuADAssociation(crlRecuAD RecuAD, string numAutorisationDepart)
{
#region declaration
string numRecuAD = "";
IntfDalRecuAD serviceRecuAD = new ImplDalRecuAD();
#endregion
#region implementation
if (RecuAD != null && numAutorisationDepart != "")
{
RecuAD.NumRecuAD = serviceRecuAD.insertRecuAD(RecuAD);
if (RecuAD.NumRecuAD != "")
{
if (serviceRecuAD.insertAssociationRecuADAD(RecuAD.NumRecuAD, numAutorisationDepart))
{
numRecuAD = RecuAD.NumRecuAD;
}
}
}
#endregion
return(numRecuAD);
}
