string IntfDalObservationAgent.insertObservationAgent(crlObservationAgent observation, string sigleAgence)
{
#region declaration
string numObservation = "";
IntfDalObservationAgent serviceObservationAgent = new ImplDalObservationAgent();
int nbInsert = 0;
#endregion
#region implementation
if (observation != null && sigleAgence != "")
{
observation.NumObservation = serviceObservationAgent.getNumObservation(sigleAgence);
this.strCommande = "INSERT INTO `observationagent` (`numObservation`,`matriculeAgent`,`textObesvation`,";
this.strCommande += "`dateObservation`,`isListeNoire`) VALUES ('" + observation.NumObservation + "',";
this.strCommande += "'" + observation.MatriculeAgent + "','" + observation.TextObesvation + "',";
this.strCommande += "'" + observation.DateObservation.ToString("yyyy-MM-dd") + "','" + observation.IsListeNoire + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numObservation = observation.NumObservation;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numObservation);
}
void IntfDalObservationAgent.insertToGridObservationAgent(GridView gridView, string param, string paramLike, string valueLike, string matriculeAgent)
{
#region declaration
IntfDalObservationAgent serviceObservationAgent = new ImplDalObservationAgent();
#endregion
#region implementation
this.strCommande = "SELECT observationagent.numObservation, observationagent.matriculeAgent,";
this.strCommande += " observationagent.textObesvation, observationagent.dateObservation,";
this.strCommande += " observationagent.isListeNoire, agent.matriculeAgent, agent.typeAgent,";
this.strCommande += " agent.numAgence, agent.nomAgent, agent.prenomAgent,";
this.strCommande += " agent.dateNaissanceAgent, agent.lieuNaissanceAgent, agent.cinAgent,";
this.strCommande += " agent.adresseAgent, agent.telephoneAgent, agent.telephoneMobileAgent,";
this.strCommande += " agent.imageAgent, agent.situationFamilialeAgent FROM observationagent";
this.strCommande += " Inner Join agent ON agent.matriculeAgent = observationagent.matriculeAgent";
this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%' AND";
this.strCommande += " observationagent.matriculeAgent LIKE '%" + matriculeAgent + "%'";
this.strCommande += " ORDER BY " + param + " ASC";
gridView.DataSource = serviceObservationAgent.getDataTableObservationAgent(this.strCommande);
gridView.DataBind();
#endregion
}
