bool IntfDalVerification.deleteVerification(crlVerification Verification)
{
#region declaration
bool isDelete = false;
int nombreDelete = 0;
#endregion
#region implementation
if (Verification != null)
{
if (Verification.IdVerification != "")
{
this.strCommande = "DELETE FROM `verification` WHERE (`idVerification` = '" + Verification.IdVerification + "')";
this.serviceConnectBase.openConnection();
nombreDelete = this.serviceConnectBase.requete(this.strCommande);
if (nombreDelete == 1)
{
isDelete = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isDelete);
}
string IntfDalVerification.insertVerification(crlVerification Verification, string sigleAgence)
{
#region declaration
int nombreInsertion = 0;
string idVerification = "";
IntfDalVerification serviceVerification = new ImplDalVerification();
#endregion
#region implementation
if (Verification != null)
{
Verification.IdVerification = serviceVerification.getIdVerification(sigleAgence);
this.strCommande = "INSERT INTO `verification` (`idVerification`,`numLicence`,`idItineraire`,";
this.strCommande += " `idChauffeur`,`matriculeAgent`,`verificationTechnique`,`aVoireVT`,`verificationPapier`,`aVoireVP`,`dateVerification`,`planDepart`) ";
this.strCommande += " VALUES ('" + Verification.IdVerification + "','" + Verification.NumLicence + "','" + Verification.IdItineraire + "'";
this.strCommande += " ,'" + Verification.IdChauffeur + "','" + Verification.MatriculeAgent + "'";
this.strCommande += " ,'" + Verification.VerificationTechnique + "', '" + Verification.AVoireVT + "'";
this.strCommande += " ,'" + Verification.VerificationPapier + "', '" + Verification.AVoireVP + "', '" + Verification.DateVerification.ToString("yyyy-MM-dd") + "','" + Verification.PlanDepart + "')";
this.serviceConnectBase.openConnection();
nombreInsertion = this.serviceConnectBase.requete(this.strCommande);
if (nombreInsertion == 1)
{
idVerification = Verification.IdVerification;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(idVerification);
}
bool IntfDalVerification.updateVerification(crlVerification Verification)
{
#region declaration
bool isUpdate = false;
int nombreUpdate = 0;
#endregion
#region implementation
if (Verification != null)
{
if (Verification.IdVerification != "")
{
this.strCommande = "UPDATE `verification` SET ";
this.strCommande += ",`numLicence`='" + Verification.NumLicence + "',`idChauffeur`='" + Verification.IdChauffeur + "',`idItineraire`='" + Verification.IdItineraire + "'";
this.strCommande += ",`matriculeAgent`='" + Verification.MatriculeAgent + "',`verificationTechnique`='" + Verification.VerificationTechnique + "'";
this.strCommande += ",`aVoireVT`='" + Verification.AVoireVT + "',`verificationPapier`='" + Verification.VerificationPapier + "'";
this.strCommande += ",`aVoireVP`='" + Verification.AVoireVP + "', `planDepart`='" + Verification.PlanDepart + "'";
this.strCommande += " WHERE (`idVerification`='" + Verification.IdVerification + "')";
this.serviceConnectBase.openConnection();
nombreUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nombreUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isUpdate);
}
crlVerification IntfDalVerification.selectVerification(string idVerification)
{
#region declaration
IntfDalLicence serviceLicence = new ImplDalLicence();
IntfDalAgent serviceAgent = new ImplDalAgent();
IntfDalChauffeur serviceChauffeur = new ImplDalChauffeur();
IntfDalItineraire serviceItineraire = new ImplDalItineraire();
crlVerification verification = null;
#endregion
#region implementation
if (idVerification != "")
{
this.strCommande = "SELECT * FROM `verification` WHERE (`idVerification`='" + idVerification + "')";
this.serviceConnectBase.openConnection();
reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
if (reader.Read())
{
verification = new crlVerification();
verification.AVoireVP = reader["aVoireVP"].ToString();
verification.AVoireVT = reader["aVoireVT"].ToString();
verification.IdItineraire = reader["idItineraire"].ToString();
try
{
verification.DateVerification = Convert.ToDateTime(reader["dateVerification"].ToString());
}
catch (Exception)
{
}
verification.IdChauffeur = reader["idChauffeur"].ToString();
verification.IdVerification = reader["idVerification"].ToString();
verification.MatriculeAgent = reader["matriculeAgent"].ToString();
verification.NumLicence = reader["numLicence"].ToString();
verification.ObservationProfessionnelle = reader["observationProfessionnelle"].ToString();
verification.VerificationPapier = int.Parse(reader["verificationPapier"].ToString());
verification.VerificationTechnique = int.Parse(reader["verificationTechnique"].ToString());
verification.PlanDepart = int.Parse(reader["planDepart"].ToString());
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (verification != null)
{
verification.Licence = serviceLicence.selectLicence(verification.NumLicence);
verification.Agent = serviceAgent.selectAgent(verification.MatriculeAgent);
verification.Chauffeur = serviceChauffeur.selectChauffeur(verification.IdChauffeur);
verification.Itineraire = serviceItineraire.selectItineraire(verification.IdItineraire);
}
}
#endregion
return(verification);
}
int IntfDalVerification.isVerification(crlVerification Verification)
{
#region declaration
int isTest = 0;
int nbVerification = 0;
#endregion
#region implementation
if (Verification != null)
{
this.strCommande = "SELECT Count(verification.idVerification) As nbVerification FROM verification";
this.strCommande += " WHERE verification.dateVerification = '" + DateTime.Now.ToString("yyyy-MM-dd") + "'";
this.strCommande += " AND (verification.numLicence = '" + Verification.NumLicence + "' OR";
this.strCommande += " verification.idChauffeur = '" + Verification.IdChauffeur + "')";
this.serviceConnectBase.openConnection();
reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
reader.Read();
nbVerification = int.Parse(reader["nbVerification"].ToString());
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (nbVerification < int.Parse(ReGlobalParam.nbVerificationParJourParVehicule))
{
isTest = 1;
}
}
#endregion
return(isTest);
}
