string IntfDalFacture.insertFactureAssoc(crlFacture Facture)
{
#region declaration
string numFacture = "";
IntfDalFacture serviceFacture = new ImplDalFacture();
IntfDalAutorisationDepart serviceAutorisationDepart = new ImplDalAutorisationDepart();
#endregion
#region implementation
if (Facture != null)
{
if (Facture.autorisationDeparts != null)
{
Facture.NumFacture = serviceFacture.insertFacture(Facture);
if (Facture.NumFacture != "")
{
for (int i = 0; i < Facture.autorisationDeparts.Count; i++)
{
serviceFacture.insertAssocFactureAD(Facture.NumFacture, Facture.autorisationDeparts[i].NumAutorisationDepart);
Facture.autorisationDeparts[i].ResteRegle = 0;
serviceAutorisationDepart.updateAutorisationDepart(Facture.autorisationDeparts[i]);
}
numFacture = Facture.NumFacture;
}
}
}
#endregion
return(numFacture);
}
string IntfDalFacture.insertFacture(crlFacture Facture)
{
#region declaration
IntfDalFacture serviceFacture = new ImplDalFacture();
int nombreInsertion = 0;
string numFacture = "";
#endregion
#region implementation
if (Facture != null)
{
Facture.NumFacture = serviceFacture.getNumFacture(Facture.agent.agence.SigleAgence);
this.strCommande = "INSERT INTO `facture` (`numFacture`,`libele`,`montant`,`dateFacturation`,`matriculeAgent`)";
this.strCommande += " VALUES ('" + Facture.NumFacture + "', '" + Facture.Libele + "', ";
this.strCommande += " '" + Facture.Montant + "', '" + Facture.DateFacturation.ToString("yyyy-MM-dd") + "','" + Facture.MatriculeAgent + "')";
this.serviceConnectBase.openConnection();
nombreInsertion = this.serviceConnectBase.requete(this.strCommande);
if (nombreInsertion == 1)
{
numFacture = Facture.NumFacture;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numFacture);
}
bool IntfDalFacture.updateFacture(crlFacture Facture)
{
#region declaration
bool isUpdate = false;
int nombreUpdate = 0;
#endregion
#region implementation
if (Facture != null)
{
if (Facture.NumFacture != "")
{
this.strCommande = "UPDATE `facture` SET `libele`='" + Facture.Libele + "', ";
this.strCommande += "`montant`='" + Facture.Montant + "', `dateFacturation`='" + Facture.DateFacturation.ToString("yyyy-MM-dd") + "'";
this.strCommande += ",`matriculeAgent`='" + Facture.MatriculeAgent + "' WHERE (`numFacture`='" + Facture.NumFacture + "')";
this.serviceConnectBase.openConnection();
nombreUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nombreUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isUpdate);
}
bool IntfDalFacture.deleteFacture(crlFacture Facture)
{
#region declaration
bool isDelete = false;
int nombreDelete = 0;
#endregion
#region implementation
if (Facture != null)
{
if (Facture.NumFacture != "")
{
this.strCommande = "DELETE FROM `facture` WHERE (`numFacture` = '" + Facture.NumFacture + "')";
this.serviceConnectBase.openConnection();
nombreDelete = this.serviceConnectBase.requete(this.strCommande);
if (nombreDelete == 1)
{
isDelete = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isDelete);
}
crlFacture IntfDalFacture.selectFacture(string numFacture)
{
#region declaration
crlFacture Facture = null;
IntfDalAgent serviceAgent = new ImplDalAgent();
IntfDalFacture serviceFacture = new ImplDalFacture();
#endregion
#region implementation
if (numFacture != "")
{
this.strCommande = "SELECT * FROM `facture` WHERE (`numFacture`='" + numFacture + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
Facture = new crlFacture();
reader.Read();
Facture.NumFacture = reader["numFacture"].ToString();
Facture.Libele = reader["libele"].ToString();
Facture.Montant = reader["montant"].ToString();
Facture.MatriculeAgent = reader["matriculeAgent"].ToString();
try
{
Facture.DateFacturation = Convert.ToDateTime(reader["dateFacturation"].ToString());
}
catch (Exception)
{
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (Facture != null)
{
if (Facture.MatriculeAgent != "")
{
Facture.agent = serviceAgent.selectAgent(Facture.MatriculeAgent);
}
Facture.autorisationDeparts = serviceFacture.selectADForFacture(Facture.NumFacture);
}
}
#endregion
return(Facture);
}
protected void btnFacturer_Click(object sender, EventArgs e)
{
#region declaration
crlFacture facture = null;
double montantTotalRecettes = 0.00;
#endregion
#region implementation
if (hfNumVehicule.Value != "")
{
montantTotalRecettes = serviceVehicule.getTotalReste(hfNumVehicule.Value);
if (montantTotalRecettes > 0)
{
facture = new crlFacture();
facture.agent = agent;
facture.MatriculeAgent = agent.matriculeAgent;
facture.DateFacturation = DateTime.Now;
facture.Libele = ReLibeleFacture.libeleFactureForProprietaire;
facture.Montant = montantTotalRecettes.ToString("0");
facture.autorisationDeparts = serviceVehicule.getAutorisationDepartsForFacture(hfNumVehicule.Value);
facture.NumFacture = serviceFacture.insertFactureAssoc(facture);
if (facture.NumFacture != "")
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "pdf",
string.Format("window.open('{0}','_blank','width={1},height={2},top={3},left={4}');", "../print/print.aspx?param=facture&numFacture=" + facture.NumFacture, 700,
500, 10, 10), true);
}
else
{
//
}
}
else
{
//
}
}
else
{
//
}
#endregion
/*
#region implementation
* if (hfNumProprietaire.Value != "")
* {
* montantTotalRecettes = serviceProprietaire.getTotalReste(hfNumProprietaire.Value);
*
* facture = new crlFacture();
* facture.agent = agent;
* facture.MatriculeAgent = agent.matriculeAgent;
* facture.autorisationDeparts = serviceAutorisationDepart.selectADProprietaireResteNonNull(hfNumProprietaire.Value);
* facture.DateFacturation = DateTime.Now;
* facture.Libele = ReLibeleFacture.libeleFactureForProprietaire;
* facture.Montant = montantTotalRecettes.ToString("0");
*
* facture.NumFacture = serviceFacture.insertFactureAssoc(facture);
*
* if (facture.NumFacture != "")
* {
* Page.ClientScript.RegisterClientScriptBlock(GetType(), "pdf",
* string.Format("window.open('{0}','_blank','width={1},height={2},top={3},left={4}');", "../print/print.aspx?param=facture&numFacture=" + facture.NumFacture, 700,
* 500, 10, 10), true);
* }
* }
#endregion
* */
}
private void afficheFacture(string numFacture)
{
#region declaration
crlFacture facture = null;
crlProprietaire proprietaire = null;
#endregion
#region implementation
if (numFacture != "")
{
facture = serviceFacture.selectFacture(numFacture);
if (facture != null)
{
hfNumFacture.Value = facture.NumFacture;
LabNumFacture.Text = "N°" + facture.NumFacture;
if (facture.autorisationDeparts.Count > 0)
{
proprietaire = facture.autorisationDeparts[0].ficheBord.autorisationVoyage.Verification.Licence.vehicule.proprietaire;
TextMontantFacture.Text = serviceGeneral.separateurDesMilles(facture.Montant);
TextDate.Text = facture.DateFacturation.ToString("dd MMMM yyyy");
if (proprietaire.Individu != null)
{
LabelNomIndividu.Text = proprietaire.Individu.NomIndividu;
LabelPrenomIndividu.Text = proprietaire.Individu.PrenomIndividu;
LabelCINIndividu.Text = proprietaire.Individu.CinIndividu;
LabelAdresseIndividu.Text = proprietaire.Individu.Adresse;
LabelFixeIndividu.Text = proprietaire.Individu.TelephoneFixeIndividu;
LabelMobileIndividu.Text = proprietaire.Individu.TelephoneMobileIndividu;
Panel_Individu.Visible = true;
}
else
{
Panel_Individu.Visible = false;
}
if (proprietaire.organisme != null)
{
LabelAdresseOrganisme.Text = proprietaire.organisme.AdresseOrganisme;
LabelFixeOrganisme.Text = proprietaire.organisme.TelephoneFixeOrganisme;
LabelMailOrganisme.Text = proprietaire.organisme.MailOrganisme;
LabelMobileOrganisme.Text = proprietaire.organisme.TelephoneMobileOrganisme;
LabelNomOrganisme.Text = proprietaire.organisme.NomOrganisme;
if (proprietaire.organisme.individuResponsable != null)
{
LabelAdresseRespOrganisme.Text = proprietaire.organisme.individuResponsable.Adresse;
LabelCINRespOrganisme.Text = proprietaire.organisme.individuResponsable.CinIndividu;
LabelFixeRespOrganisme.Text = proprietaire.organisme.individuResponsable.TelephoneFixeIndividu;
LabelMobileRespOrganisme.Text = proprietaire.organisme.individuResponsable.TelephoneMobileIndividu;
LabelNomRespOrganisme.Text = proprietaire.organisme.individuResponsable.NomIndividu;
LabelPrenomRespOrganisme.Text = proprietaire.organisme.individuResponsable.PrenomIndividu;
}
Panel_Organisme.Visible = true;
}
else
{
Panel_Organisme.Visible = false;
}
if (proprietaire.societe != null)
{
LabelAdresseSociete.Text = proprietaire.societe.AdresseSociete;
LabelFixeSociete.Text = proprietaire.societe.TelephoneFixeSociete;
LabelMailSociete.Text = proprietaire.societe.MailSociete;
LabelMobileSociete.Text = proprietaire.societe.TelephoneMobileSociete;
LabelNomSociete.Text = proprietaire.societe.NomSociete;
LabelSecteurActiviteSociete.Text = proprietaire.societe.SecteurActiviteSociete;
if (proprietaire.societe.individuResponsable != null)
{
LabelAdresseRespSociete.Text = proprietaire.societe.individuResponsable.Adresse;
LabelCINRespSociete.Text = proprietaire.societe.individuResponsable.CinIndividu;
LabelFixeRespSociete.Text = proprietaire.societe.individuResponsable.TelephoneFixeIndividu;
LabelMobileRespSociete.Text = proprietaire.societe.individuResponsable.TelephoneMobileIndividu;
LabelNomRespSociete.Text = proprietaire.societe.individuResponsable.NomIndividu;
LabelPrenomRespSociete.Text = proprietaire.societe.individuResponsable.PrenomIndividu;
}
Panel_Societe.Visible = true;
}
else
{
Panel_Societe.Visible = false;
}
}
}
}
#endregion
}
