private void insertToObj(crlSessionAgence sessionAgence)
{
#region implementation
if (sessionAgence != null)
{
sessionAgence.MatriculeAgentOuverture = agent.matriculeAgent;
sessionAgence.NumAgence = hfNumAgence.Value;
}
#endregion
}
public crlAgence()
{
this.NumAgence = "";
this.NumVille = "";
this.TypeAgence = "";
this.SigleAgence = "";
this.NomAgence = "";
this.LocalisationAgence = "";
this.typeAgence = null;
this.ville = null;
this.sessionAgence = null;
}
crlSessionAgence IntfDalSessionAgence.getSessionAgenceEncours(string numAgence)
{
#region declaration
crlSessionAgence sessionAgence = null;
#endregion
#region implementation
if (numAgence != "")
{
this.strCommande = "SELECT * FROM `sessionagence` WHERE sessionagence.matriculeAgentFermeture IS NULL AND";
this.strCommande += " sessionagence.numAgence = '" + numAgence + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
sessionAgence = new crlSessionAgence();
try
{
sessionAgence.DateHeureOuverture = Convert.ToDateTime(this.reader["dateHeureOuverutre"].ToString());
}
catch (Exception)
{
sessionAgence.DateHeureOuverture = DateTime.Now;
}
try
{
sessionAgence.DateHeureFermeture = Convert.ToDateTime(this.reader["dateHeureFermeture"].ToString());
}
catch (Exception)
{
sessionAgence.DateHeureOuverture = DateTime.Now;
}
sessionAgence.NumAgence = this.reader["numAgence"].ToString();
sessionAgence.MatriculeAgentFermeture = this.reader["matriculeAgentFermeture"].ToString();
sessionAgence.MatriculeAgentOuverture = this.reader["matriculeAgentOuverture"].ToString();
sessionAgence.NumSessionAgence = this.reader["numSessionAgence"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(sessionAgence);
}
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);
}
bool IntfDalSessionAgence.updateSessionAgence(crlSessionAgence sessionAgence)
{
#region declaration
bool isUpdate = false;
int nbUpdate = 0;
string matriculeAgentFermeture = "NULL";
string matriculeAgentOuverture = "NULL";
#endregion
#region implementation
if (sessionAgence != null)
{
if (sessionAgence.MatriculeAgentFermeture != "")
{
matriculeAgentFermeture = "'" + sessionAgence.MatriculeAgentFermeture + "'";
}
if (sessionAgence.MatriculeAgentOuverture != "")
{
matriculeAgentOuverture = "'" + sessionAgence.MatriculeAgentOuverture + "'";
}
this.strCommande = "UPDATE `sessionagence` SET `numAgence`='" + sessionAgence.NumAgence + "',";
this.strCommande += " `matriculeAgentOuverture`=" + matriculeAgentOuverture + ",";
this.strCommande += " `matriculeAgentFermeture`=" + matriculeAgentFermeture + ",";
this.strCommande += " `dateHeureOuverutre`='" + sessionAgence.DateHeureOuverture.ToString("yyyy-MM-dd HH:mm:ss") + "',";
this.strCommande += " `dateHeureFermeture`='" + sessionAgence.DateHeureFermeture.ToString("yyyy-MM-dd HH:mm:ss") + "'";
this.strCommande += " WHERE `numSessionAgence`='" + sessionAgence.NumSessionAgence + "'";
this.serviceConnectBase.openConnection();
nbUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nbUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isUpdate);
}
protected void btnOuvrirSession_Click(object sender, EventArgs e)
{
#region declaration
crlAgence agence = null;
crlSessionAgence sessionAgence = null;
#endregion
#region implementation
if (hfNumAgence.Value != "")
{
agence = serviceAgence.selectAgence(hfNumAgence.Value);
if (agence != null)
{
if (agence.sessionAgence != null)
{
//
}
else
{
sessionAgence = new crlSessionAgence();
this.insertToObj(sessionAgence);
sessionAgence.NumSessionAgence = serviceSessionAgence.insertSessionAgence(sessionAgence, agent.agence.SigleAgence);
if (sessionAgence.NumSessionAgence != "")
{
this.afficheAgence(sessionAgence.NumAgence);
this.initialiseGridAgence();
}
else
{
//
}
}
}
}
#endregion
}
private void afficheMontantTotal(string numSessionAgence)
{
#region declaration
double montantBillet = 0;
double montantCommission = 0;
double montantDureeAbonnement = 0;
double montantVoyageAbonnement = 0;
double montantRecuEncaisser = 0;
double montantRecuEncaisserCheque = 0;
double montantTotalSession = 0;
double montantTotalSessionCheque = 0;
double montantRecuAD = 0;
crlSessionAgence sessionAgence = null;
Convertisseuse convertisseuse = new Convertisseuse();
#endregion
#region implementation
if (numSessionAgence != "")
{
sessionAgence = serviceSessionAgence.selectSessionAgence(numSessionAgence);
montantBillet = serviceSessionAgence.getMontantTotalBillet(numSessionAgence);
montantCommission = serviceSessionAgence.getMontantTotalCommission(numSessionAgence);
montantDureeAbonnement = serviceSessionAgence.getMontantTotalDureeAbonnement(numSessionAgence);
montantRecuEncaisser = serviceSessionAgence.getMontantTotalRecuEncaisserEspece(numSessionAgence);
montantRecuEncaisserCheque = serviceSessionAgence.getMontantTotalRecuEncaisserCheque(numSessionAgence);
montantVoyageAbonnement = serviceSessionAgence.getMontantTotalVoyageAbonnement(numSessionAgence);
montantRecuAD = serviceSessionAgence.getMontantTotalRecuAD(numSessionAgence);
montantTotalSession = montantBillet + montantCommission + montantDureeAbonnement + montantRecuEncaisser + montantVoyageAbonnement - montantRecuAD;
montantTotalSessionCheque = montantRecuEncaisserCheque;
if (montantBillet > 0)
{
Panel_BilletMontantTotal.Visible = true;
LabelMontantTotalBillet.Text = serviceGeneral.separateurDesMilles(montantBillet.ToString("0")) + "Ar";
LabelMontantTotalLettreBillet.Text = convertisseuse.convertion(montantBillet.ToString("0")) + " Ariary";
}
else
{
Panel_BilletMontantTotal.Visible = false;
LabelMontantTotalBillet.Text = "0Ar";
LabelMontantTotalLettreBillet.Text = "Zéro Ariary";
}
if (montantCommission > 0)
{
Panel_CommissionMontantTotal.Visible = true;
LabelMontantTotalCommission.Text = serviceGeneral.separateurDesMilles(montantCommission.ToString("0")) + "Ar";
LabelMontantTotalCommissionLettre.Text = convertisseuse.convertion(montantCommission.ToString("0")) + " Ariary";
}
else
{
Panel_CommissionMontantTotal.Visible = false;
LabelMontantTotalCommission.Text = "0Ar";
LabelMontantTotalCommissionLettre.Text = "Zéro Ariary";
}
if (montantDureeAbonnement > 0)
{
Panel_DureeAbonnementMontantTotal.Visible = true;
LabelMotantTotalDureeAbonnement.Text = serviceGeneral.separateurDesMilles(montantDureeAbonnement.ToString("0")) + "Ar";
LabelMontantTotalDureeAbonnementLettre.Text = convertisseuse.convertion(montantDureeAbonnement.ToString("0")) + " Ariary";
}
else
{
Panel_DureeAbonnementMontantTotal.Visible = false;
LabelMotantTotalDureeAbonnement.Text = "0Ar";
LabelMontantTotalDureeAbonnementLettre.Text = "Zéro Ariary";
}
if (montantRecuEncaisser > 0 || montantRecuEncaisserCheque > 0)
{
Panel_RecuEncaisserMontantTotal.Visible = true;
LabelMontantTotalRecuEncaisser.Text = serviceGeneral.separateurDesMilles(montantRecuEncaisser.ToString("0")) + "Ar";
LabelMontantTotalRecuEncaisserLettre.Text = convertisseuse.convertion(montantRecuEncaisser.ToString("0")) + " Ariary";
LabelMontantTotalRecuEnCaisserCheque.Text = serviceGeneral.separateurDesMilles(montantRecuEncaisserCheque.ToString("0")) + "Ar";
LabelMontantTotalRecuEnCaisserChequeLettre.Text = convertisseuse.convertion(montantRecuEncaisserCheque.ToString("0")) + "Ariary";
}
else
{
Panel_RecuEncaisserMontantTotal.Visible = false;
LabelMontantTotalRecuEncaisser.Text = "0Ar";
LabelMontantTotalRecuEncaisserLettre.Text = "Zéro Ariary";
LabelMontantTotalRecuEnCaisserCheque.Text = "0Ar";
LabelMontantTotalRecuEnCaisserChequeLettre.Text = "Zéro Ariary";
}
if (montantVoyageAbonnement > 0)
{
Panel_VoyageAbonnementMontantTotal.Visible = true;
LabelMontantTotalVoyageAbonnement.Text = serviceGeneral.separateurDesMilles(montantVoyageAbonnement.ToString("0")) + "Ar";
LabelMontantTotalVoyageAbonnementLettre.Text = convertisseuse.convertion(montantVoyageAbonnement.ToString("0")) + " Ariary";
}
else
{
Panel_VoyageAbonnementMontantTotal.Visible = false;
LabelMontantTotalVoyageAbonnement.Text = "0Ar";
LabelMontantTotalVoyageAbonnementLettre.Text = "Zéro Ariary";
}
if (montantRecuAD > 0)
{
Panel_RecuADTotal.Visible = true;
LabelMontantTotalRecuDecaisser.Text = serviceGeneral.separateurDesMilles(montantRecuAD.ToString("0")) + "Ar";
LabelMontantTotalRecuDecaisserLettre.Text = convertisseuse.convertion(montantRecuAD.ToString("0")) + " Ariary";
}
else
{
Panel_RecuADTotal.Visible = false;
LabelMontantTotalRecuDecaisser.Text = "0Ar";
LabelMontantTotalRecuDecaisserLettre.Text = "Zéro Ariary";
}
Panel_MontantTotalSessionCaisse.Visible = true;
if (montantTotalSession >= 0)
{
LabelMontantTotalSessionLettre.Text = convertisseuse.convertion(montantTotalSession.ToString("0")) + " Ariary";
LabelMontantTotalSession.Text = serviceGeneral.separateurDesMilles(montantTotalSession.ToString("0")) + "Ar";
}
else
{
LabelMontantTotalSession.Text = "(" + serviceGeneral.separateurDesMilles(montantTotalSession.ToString("0")) + ") Ar";
LabelMontantTotalSessionLettre.Text = "(- " + convertisseuse.convertion((montantTotalSession * -1).ToString("0")) + ") Ariary";
}
if (montantTotalSessionCheque >= 0)
{
LabelMontantTotalSessionChequelettre.Text = convertisseuse.convertion(montantTotalSessionCheque.ToString("0")) + " Ariary";
LabelMontantTotalSessionCheque.Text = serviceGeneral.separateurDesMilles(montantTotalSessionCheque.ToString("0")) + "Ar";
}
else
{
LabelMontantTotalSessionCheque.Text = "(" + serviceGeneral.separateurDesMilles(montantTotalSessionCheque.ToString("0")) + ") Ar";
LabelMontantTotalSessionChequelettre.Text = "(- " + convertisseuse.convertion((montantTotalSessionCheque * -1).ToString("0")) + ") Ariary";
}
if (sessionAgence != null)
{
LabelDateDebutSession.Text = sessionAgence.DateHeureOuverture.ToString("dd MMMM yyyy");
}
}
#endregion
}
