protected void btnValider_Click(object sender, EventArgs e)
{
#region declaration
crlRecuAD recuAD = null;
#endregion
#region implementation
if (hfNumFacture.Value != "")
{
recuAD = new crlRecuAD();
recuAD.Libele = "Paiement transporteur.";
recuAD.MatriculeAgent = agent.matriculeAgent;
recuAD.Montant = TextMontantFacture.Text.Replace(" ", "");
recuAD.NumFacture = hfNumFacture.Value;
recuAD.agent = agent;
recuAD.NumRecuAD = serviceRecuAD.insertRecuAD(recuAD);
if (recuAD.NumRecuAD != "")
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "pdf",
string.Format("window.open('{0}','_blank','width={1},height={2},top={3},left={4}');", "../print/print.aspx?param=recuAD&numRecuAD=" + recuAD.NumRecuAD, 700,
500, 10, 10), true);
}
else
{
//
}
}
else
{
//
}
#endregion
}
bool IntfDalRecuAD.deleteRecuAD(crlRecuAD RecuAD)
{
#region declaration
bool isDelete = false;
int nombreDelete = 0;
#endregion
#region implementation
if (RecuAD != null)
{
if (RecuAD.NumRecuAD != "")
{
this.strCommande = "DELETE FROM `recuad` WHERE (`numRecuAD` = '" + RecuAD.NumRecuAD + "')";
this.serviceConnectBase.openConnection();
nombreDelete = this.serviceConnectBase.requete(this.strCommande);
if (nombreDelete == 1)
{
isDelete = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isDelete);
}
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);
}
private void prelevementFond(string numAutorisationDepart)
{
#region declaration
crlPrelevement prelevement = null;
crlAutorisationDepart autorisationDepart = null;
crlRecuAD recuAD = null;
#endregion
#region implementation
if (numAutorisationDepart != "")
{
autorisationDepart = serviceAutorisationDepart.selectAutorisationDepart(numAutorisationDepart);
if (autorisationDepart != null)
{
if (autorisationDepart.ficheBord.autorisationVoyage.Verification.Licence.vehicule.paramVehicule.Fond > 0)
{
prelevement = new crlPrelevement();
prelevement.agent = agent;
prelevement.MatriculeAgent = agent.matriculeAgent;
prelevement.MontantPrelevement = autorisationDepart.ficheBord.autorisationVoyage.Verification.Licence.vehicule.paramVehicule.Fond;
prelevement.NumAutorisationDepart = autorisationDepart.NumAutorisationDepart;
prelevement.TypePrelevement = "Fond";
prelevement.NumPrelevement = servicePrelevement.insertPrelevement(prelevement);
if (prelevement.NumPrelevement != "")
{
recuAD = new crlRecuAD();
recuAD.Libele = "Fond";
recuAD.agent = agent;
recuAD.MatriculeAgent = agent.matriculeAgent;
recuAD.Montant = prelevement.MontantPrelevement.ToString("0");
recuAD.NumPrelevement = prelevement.NumPrelevement;
recuAD.NumRecuAD = serviceRecuAD.insertRecuAD(recuAD);
autorisationDepart.ResteRegle = autorisationDepart.ResteRegle - prelevement.MontantPrelevement;
serviceAutorisationDepart.updateAutorisationDepart(autorisationDepart);
}
else
{
}
}
}
}
#endregion
}
bool IntfDalRecuAD.updateRecuAD(crlRecuAD RecuAD)
{
#region declaration
bool isUpdate = false;
int nombreUpdate = 0;
string numPrelevement = "NULL";
string numFacture = "NULL";
#endregion
#region implementation
if (RecuAD != null)
{
if (RecuAD.NumRecuAD != "")
{
if (RecuAD.NumPrelevement != "")
{
numPrelevement = "'" + RecuAD.NumPrelevement + "'";
}
if (RecuAD.NumFacture != "")
{
numFacture = "'" + RecuAD.NumFacture + "'";
}
this.strCommande = "UPDATE `recuad` SET `numPrelevement`=" + numPrelevement + ", `matriculeAgent`='" + RecuAD.MatriculeAgent + "', ";
this.strCommande += "`libele`='" + RecuAD.Libele + "', `montant`='" + RecuAD.Montant + "',`dateRecu`='" + RecuAD.Date.ToString("yyyy-MM-dd") + "',";
this.strCommande += "`numFacture`=" + numFacture + " ";
this.strCommande += "WHERE (`numRecuAD`='" + RecuAD.NumRecuAD + "')";
this.serviceConnectBase.openConnection();
nombreUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nombreUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isUpdate);
}
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);
}
protected void btnValideAvance_Click(object sender, EventArgs e)
{
#region declaration
crlRecuAD recu = null;
crlPrelevement prelevement = null;
crlAutorisationDepart autorisationDepart = null;
#endregion
#region implementation
if (hfPrelevement.Value != "" && hfAutorisationDepart.Value != "")
{
if (agent.sessionCaisse != null)
{
autorisationDepart = serviceAutorisationDepart.selectAutorisationDepart(hfAutorisationDepart.Value);
prelevement = servicePrelevement.selectPrelevement(hfPrelevement.Value);
if (prelevement != null && autorisationDepart != null)
{
if (serviceRecuAD.isValideMontant(prelevement.MontantPrelevement, autorisationDepart.NumAutorisationDepart))
{
recu = new crlRecuAD();
recu.agent = agent;
recu.Date = DateTime.Now;
recu.Libele = ddlLibelle.Text;
recu.MatriculeAgent = agent.matriculeAgent;
recu.Montant = prelevement.MontantPrelevement.ToString("0");
recu.NumPrelevement = prelevement.NumPrelevement;
recu.NumRecuAD = serviceRecuAD.insertRecuAD(recu);
if (recu.NumRecuAD != "")
{
serviceSessionCaisse.insertAssocSessionCaisseRecuAD(recu.NumRecuAD, agent.sessionCaisse.NumSessionCaisse);
this.initialiseGridPrelevement();
this.initialiseGridRecuAD();
autorisationDepart.ResteRegle = autorisationDepart.ResteRegle - prelevement.MontantPrelevement;
serviceAutorisationDepart.updateAutorisationDepart(autorisationDepart);
TextMontant.Text = "";
TextType.Text = "";
hfPrelevement.Value = "";
ddlLibelle.SelectedValue = "";
this.afficheAutorisationDepart(hfAutorisationDepart.Value);
Page.ClientScript.RegisterClientScriptBlock(GetType(), "pdf",
string.Format("window.open('{0}','_blank','width={1},height={2},top={3},left={4}');", "../print/print.aspx?param=recuAD&numRecuAD=" + recu.NumRecuAD, 700,
500, 10, 10), true);
}
else
{
//
}
}
else
{
//
}
}
}
else
{
//
}
}
else
{
//
}
#endregion
}
protected void btnAutorisationDepart_Click(object sender, EventArgs e)
{
#region declaration
crlAutorisationDepart autorisationDepart = null;
crlTarifDeveloppement tarifDeveloppement = null;
crlPrelevement prelevement = null;
crlRecuAD recuAD = null;
#endregion
#region implementation
if (hfNumerosFB.Value != "")
{
autorisationDepart = new crlAutorisationDepart();
this.insertObjetAD(autorisationDepart);
autorisationDepart.NumAutorisationDepart = serviceAutorisationDepart.insertAutorisationDepart(autorisationDepart);
if (autorisationDepart.NumAutorisationDepart != "")
{
autorisationDepart = serviceAutorisationDepart.selectAutorisationDepart(autorisationDepart.NumAutorisationDepart);
if (autorisationDepart != null)
{
tarifDeveloppement = serviceTarifDeveloppement.selectTarifDeveloppementZone(autorisationDepart.ficheBord.autorisationVoyage.Verification.Licence.Zone);
if (tarifDeveloppement != null)
{
prelevement = new crlPrelevement();
prelevement.agent = agent;
prelevement.MatriculeAgent = agent.matriculeAgent;
prelevement.MontantPrelevement = tarifDeveloppement.MontantTarifDeveloppement;
prelevement.NumAutorisationDepart = autorisationDepart.NumAutorisationDepart;
prelevement.TypePrelevement = "Développement";
prelevement.NumPrelevement = servicePrelevement.insertPrelevement(prelevement);
if (prelevement.NumPrelevement != "")
{
recuAD = new crlRecuAD();
recuAD.Libele = "Développement";
recuAD.agent = agent;
recuAD.MatriculeAgent = agent.matriculeAgent;
recuAD.Montant = prelevement.MontantPrelevement.ToString("0");
recuAD.NumPrelevement = prelevement.NumPrelevement;
recuAD.NumRecuAD = serviceRecuAD.insertRecuAD(recuAD);
autorisationDepart.ResteRegle = autorisationDepart.ResteRegle - prelevement.MontantPrelevement;
serviceAutorisationDepart.updateAutorisationDepart(autorisationDepart);
this.prelevementFond(autorisationDepart.NumAutorisationDepart);
}
else
{
}
}
else
{
}
}
ficheDebord = serviceFicheBord.selectFicheBord(hfNumerosFB.Value);
ficheDebord.DateHeurDepart = DateTime.Now;
serviceFicheBord.updateFicheBord(ficheDebord);
Response.Redirect("~/ihmActeur/controleur/PlanningCalendarJourAD.aspx");
//Page.ClientScript.RegisterClientScriptBlock(GetType(), "Alert", "alert('" + ReAutorisationDepart.ADBienEnregistre + "');", true);
}
else
{
this.divIndicationText(ReAutorisationDepart.ADNonEnregistre, "Red");
}
}
else
{
Response.Redirect("PlanningCalendarJour.aspx");
}
#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);
}
List <crlRecuAD> IntfDalRecuAD.selectRecuADProprietaireResteNonNull(string numProprietaire)
{
#region declaration
crlRecuAD tempRecuAD = null;
List <crlRecuAD> recuADs = null;
IntfDalAgent serviceAgent = new ImplDalAgent();
#endregion
#region implementation
if (numProprietaire != "")
{
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 asociationautorisationdepartrecu ON asociationautorisationdepartrecu.numRecuAD = recuad.numRecuAD";
this.strCommande += " Inner Join autorisationdepart ON autorisationdepart.numAutorisationDepart = asociationautorisationdepartrecu.numAutorisationDepart";
this.strCommande += " Inner Join fichebord ON fichebord.numerosFB = autorisationdepart.numerosFB";
this.strCommande += " Inner Join autorisationvoyage ON autorisationvoyage.numerosAV = fichebord.numerosAV";
this.strCommande += " Inner Join verification ON verification.idVerification = autorisationvoyage.idVerification";
this.strCommande += " Inner Join licence ON licence.numLicence = verification.numLicence";
this.strCommande += " Inner Join vehicule ON vehicule.numVehicule = licence.numVehicule";
this.strCommande += " WHERE autorisationdepart.resteRegle > 0 AND";
this.strCommande += " vehicule.numProprietaire = '" + numProprietaire + "'";
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);
}
}
}
}
#endregion
return(recuADs);
}
