bool IntfDalRecuAD.isValideMontant(double montant, string numAutorisationDepart)
{
#region declaration
bool isValide = false;
IntfDalAutorisationDepart serviceAutorisationDepart = new ImplDalAutorisationDepart();
IntfDalFicheBord serviceFicheBord = new ImplDalFicheBord();
crlAutorisationDepart autorisationDepart = null;
double montantFacture = 0.00;
double montantReste = 0.00;
#endregion
#region implementation
if (numAutorisationDepart != "")
{
autorisationDepart = serviceAutorisationDepart.selectAutorisationDepart(numAutorisationDepart);
if (autorisationDepart != null)
{
/*montantFacture = serviceFicheBord.getPrixTotalBagage(autorisationDepart.NumerosFB) +
* serviceFicheBord.getPrixTotalBillet(autorisationDepart.NumerosFB) +
* serviceFicheBord.getPrixTotalCommission(autorisationDepart.NumerosFB);
*
* montantReste = montantFacture - serviceAutorisationDepart.getMontanRecu(numAutorisationDepart);*/
if (autorisationDepart.ResteRegle >= montant)
{
isValide = true;
}
}
}
#endregion
return(isValide);
}
List <crlAutorisationDepart> IntfDalFacture.selectADForFacture(string numFacture)
{
#region declaration
List <crlAutorisationDepart> autorisationDeparts = null;
IntfDalAutorisationDepart serviceAutorisationDepart = new ImplDalAutorisationDepart();
#endregion
#region implementation
if (numFacture != "")
{
this.strCommande = "SELECT autorisationdepart.numAutorisationDepart FROM autorisationdepart";
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 (this.reader != null)
{
if (this.reader.HasRows)
{
autorisationDeparts = new List <crlAutorisationDepart>();
while (this.reader.Read())
{
autorisationDeparts.Add(serviceAutorisationDepart.selectAutorisationDepart(this.reader["numAutorisationDepart"].ToString()));
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(autorisationDeparts);
}
crlPrelevement IntfDalPrelevement.selectPrelevement(string numPrelevement)
{
#region declaration
crlPrelevement Prelevement = null;
IntfDalAgent serviceAgent = new ImplDalAgent();
IntfDalTypePrelevement serviceTypePrelevement = new ImplDalTypePrelevement();
IntfDalAutorisationDepart serviceAutorisationDepart = new ImplDalAutorisationDepart();
#endregion
#region implementation
if (numPrelevement != "")
{
this.strCommande = "SELECT * FROM `prelevement` WHERE (`numPrelevement`='" + numPrelevement + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
Prelevement = new crlPrelevement();
Prelevement.NumPrelevement = this.reader["numPrelevement"].ToString();
Prelevement.DatePrelevement = Convert.ToDateTime(this.reader["datePrelevement"].ToString());
Prelevement.MatriculeAgent = this.reader["matriculeAgent"].ToString();
Prelevement.MontantPrelevement = double.Parse(this.reader["montantPrelevement"].ToString());
Prelevement.NumAutorisationDepart = this.reader["numAutorisationDepart"].ToString();
Prelevement.TypePrelevement = this.reader["typePrelevement"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (Prelevement != null)
{
if (Prelevement.MatriculeAgent != "")
{
Prelevement.agent = serviceAgent.selectAgent(Prelevement.MatriculeAgent);
}
if (Prelevement.NumAutorisationDepart != "")
{
Prelevement.autorisationDepart = serviceAutorisationDepart.selectAutorisationDepart(Prelevement.NumAutorisationDepart);
}
if (Prelevement.TypePrelevement != "")
{
Prelevement.objTypePrelevement = serviceTypePrelevement.selectTypePrelevement(Prelevement.TypePrelevement);
}
}
}
#endregion
return(Prelevement);
}
List <crlAutorisationDepart> IntfDalVehicule.getAutorisationDepartsForFacture(string numVehicule)
{
#region declaration
List <crlAutorisationDepart> autorisationDepart = null;
IntfDalAutorisationDepart serviceAutorisationDepart = new ImplDalAutorisationDepart();
#endregion
#region implementation
if (numVehicule != "")
{
this.strCommande = "SELECT autorisationdepart.numAutorisationDepart FROM autorisationdepart";
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 += " WHERE licence.numVehicule = '" + numVehicule + "' AND";
this.strCommande += " autorisationdepart.resteRegle > '0'";
this.serviceConnection.openConnection();
this.reader = this.serviceConnection.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
autorisationDepart = new List <crlAutorisationDepart>();
while (this.reader.Read())
{
autorisationDepart.Add(serviceAutorisationDepart.selectAutorisationDepart(this.reader["numAutorisationDepart"].ToString()));
}
}
this.reader.Dispose();
}
this.serviceConnection.closeConnection();
}
#endregion
return(autorisationDepart);
}