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