string IntfDalPrelevement.insertPrelevement(crlPrelevement prelevement) { #region declaration int nombreInsertion = 0; string numPrelevement = ""; IntfDalPrelevement servicePrelevement = new ImplDalPrelevement(); #endregion #region implementation if (prelevement != null) { prelevement.NumPrelevement = servicePrelevement.getNumPrelevement(prelevement.agent.agence.SigleAgence); this.strCommande = "INSERT INTO `prelevement` (`numPrelevement`,`matriculeAgent`"; this.strCommande += " ,`typePrelevement`,`numAutorisationDepart`,`montantPrelevement`,`datePrelevement`) "; this.strCommande += " VALUES ('" + prelevement.NumPrelevement + "','" + prelevement.MatriculeAgent + "'"; this.strCommande += " ,'" + prelevement.TypePrelevement + "','" + prelevement.NumAutorisationDepart + "'"; this.strCommande += " ,'" + prelevement.MontantPrelevement + "','" + prelevement.DatePrelevement.ToString("yyyy-MM-dd") + "')"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { numPrelevement = prelevement.NumPrelevement; } this.serviceConnectBase.closeConnection(); } #endregion return(numPrelevement); }
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); }
void IntfDalPrelevement.insertToGridPrelevement(GridView gridView, string numAutorisationDepart) { #region declaration IntfDalPrelevement servicePrelevement = new ImplDalPrelevement(); #endregion #region implementation this.strCommande = "SELECT prelevement.typePrelevement, prelevement.numPrelevement,"; this.strCommande += " prelevement.matriculeAgent, prelevement.numAutorisationDepart,"; this.strCommande += " prelevement.montantPrelevement, prelevement.datePrelevement,"; this.strCommande += " typeprelevement.typePrelevement, typeprelevement.commentaire"; this.strCommande += " FROM prelevement Inner Join typeprelevement ON typeprelevement.typePrelevement = prelevement.typePrelevement"; this.strCommande += " WHERE prelevement.numAutorisationDepart = '" + numAutorisationDepart + "'"; gridView.DataSource = servicePrelevement.getDataTablePrelevement(this.strCommande); gridView.DataBind(); #endregion }
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); }