crlAgence IntfDalAgence.selectAgence(string numAgence)
{
#region declaration
crlAgence agence = null;
IntfDalTypeAgence serviceTypeAgence = new ImplDalTypeAgence();
IntfDalVille serviceVille = new ImplDalVille();
IntfDalSessionAgence serviceSessionAgence = new ImplDalSessionAgence();
#endregion
#region implementation
if (numAgence != "")
{
this.strCommande = "SELECT * FROM agence WHERE `numagence`='" + numAgence + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
agence = new crlAgence();
agence.NumAgence = this.reader["numAgence"].ToString();
agence.NumVille = this.reader["numVille"].ToString();
agence.NomAgence = this.reader["nomAgence"].ToString();
agence.SigleAgence = this.reader["sigleAgence"].ToString();
agence.TypeAgence = this.reader["typeAgence"].ToString();
agence.LocalisationAgence = this.reader["localisationAgence"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (agence != null)
{
if (agence.TypeAgence != "")
{
agence.typeAgenceObj = serviceTypeAgence.selectTypeAgence(agence.TypeAgence);
}
if (agence.NumVille != "")
{
agence.ville = serviceVille.selectVille(agence.NumVille);
}
if (agence.NumAgence != "")
{
agence.sessionAgence = serviceSessionAgence.getSessionAgenceEncours(agence.NumAgence);
}
}
}
#endregion
return(agence);
}
string IntfDalSessionAgence.insertSessionAgence(crlSessionAgence sessionAgence, string sigleAgence)
{
#region declaration
string numSessionCaisse = "";
int nbInsert = 0;
string matriculeAgentFermeture = "NULL";
string matriculeAgentOuverture = "NULL";
IntfDalSessionAgence serviceSessionAgence = new ImplDalSessionAgence();
#endregion
#region implementation
if (sessionAgence != null)
{
if (sessionAgence.MatriculeAgentFermeture != "")
{
matriculeAgentFermeture = "'" + sessionAgence.MatriculeAgentFermeture + "'";
}
if (sessionAgence.MatriculeAgentOuverture != "")
{
matriculeAgentOuverture = "'" + sessionAgence.MatriculeAgentOuverture + "'";
}
sessionAgence.NumSessionAgence = serviceSessionAgence.getNumSessionAgence(sigleAgence);
this.strCommande = "INSERT INTO `sessionagence` (`numSessionAgence`,`numAgence`,`matriculeAgentOuverture`,";
this.strCommande += " `matriculeAgentFermeture`,`dateHeureOuverutre`,`dateHeureFermeture`) VALUES";
this.strCommande += " ('" + sessionAgence.NumSessionAgence + "','" + sessionAgence.NumAgence + "',";
this.strCommande += " " + matriculeAgentOuverture + "," + matriculeAgentFermeture + ",";
this.strCommande += " '" + sessionAgence.DateHeureOuverture.ToString("yyyy-MM-dd HH:mm:ss") + "',";
this.strCommande += " '" + sessionAgence.DateHeureFermeture.ToString("yyyy-MM-dd HH:mm:ss") + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numSessionCaisse = sessionAgence.NumSessionAgence;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numSessionCaisse);
}