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);
}
