bool IntfDalParamVehicule.upDateParamVehicule(crlParamVehicule paramVehicule)
{
#region declaration
bool isUpdate = false;
int nombreUpdate = 0;
#endregion
#region implementation
if (paramVehicule != null)
{
this.strCommande = "UPDATE `paramvehicule` SET `nbPassagerMin`='" + paramVehicule.NbPassagerMin + "',";
this.strCommande += " `avanceCarburantMax`='" + paramVehicule.AvanceCarburantMax + "', `avanceChauffeurMax`='" + paramVehicule.AvanceChauffeurMax + "',";
this.strCommande += " `poidBagageMax`='" + paramVehicule.PoidBagageMax + "',`fond`='" + paramVehicule.Fond + "'";
this.strCommande += " WHERE `numParamVehicule`='" + paramVehicule.NumParamVehicule + "'";
this.serviceConnection.openConnection();
nombreUpdate = this.serviceConnection.requete(this.strCommande);
if (nombreUpdate == 1)
{
isUpdate = true;
}
this.serviceConnection.closeConnection();
}
#endregion
return(isUpdate);
}
string IntfDalParamVehicule.insertParamVehicule(crlParamVehicule paramVehicule, string sigleAgence)
{
#region declaration
string numParamVehicule = "";
IntfDalParamVehicule serviceParamVehicule = new ImplDalParamVehicule();
int nombreInsert = 0;
#endregion
#region implementation
if (paramVehicule != null)
{
if (sigleAgence != "")
{
paramVehicule.NumParamVehicule = serviceParamVehicule.getNumParamVehicule(sigleAgence);
this.strCommande = "INSERT INTO `paramvehicule` (`numParamVehicule`,`nbPassagerMin`,`avanceCarburantMax`,";
this.strCommande += " `avanceChauffeurMax`,`poidBagageMax`,`fond`) VALUES";
this.strCommande += " ('" + paramVehicule.NumParamVehicule + "', " + paramVehicule.NbPassagerMin + ",";
this.strCommande += " '" + paramVehicule.AvanceCarburantMax + "','" + paramVehicule.AvanceChauffeurMax + "',";
this.strCommande += " '" + paramVehicule.PoidBagageMax + "','" + paramVehicule.Fond + "')";
this.serviceConnection.openConnection();
nombreInsert = this.serviceConnection.requete(this.strCommande);
if (nombreInsert == 1)
{
numParamVehicule = paramVehicule.NumParamVehicule;
}
this.serviceConnection.closeConnection();
}
}
#endregion
return(numParamVehicule);
}
crlParamVehicule IntfDalParamVehicule.selectParamVehicule(string numParamVehicule)
{
#region declaration
crlParamVehicule paramVehicule = null;
#endregion
#region implementation
if (numParamVehicule != "")
{
this.strCommande = "SELECT * FROM `paramvehicule` WHERE (`numParamVehicule`='" + numParamVehicule + "')";
this.serviceConnection.openConnection();
this.reader = this.serviceConnection.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
paramVehicule = new crlParamVehicule();
if (this.reader.Read())
{
paramVehicule.NumParamVehicule = this.reader["numParamVehicule"].ToString();
try
{
paramVehicule.NbPassagerMin = int.Parse(this.reader["nbPassagerMin"].ToString());
}
catch (Exception)
{
}
try
{
paramVehicule.AvanceCarburantMax = double.Parse(this.reader["avanceCarburantMax"].ToString());
}
catch (Exception)
{
}
try
{
paramVehicule.AvanceChauffeurMax = double.Parse(this.reader["avanceChauffeurMax"].ToString());
}
catch (Exception)
{
}
try
{
paramVehicule.PoidBagageMax = double.Parse(this.reader["poidBagageMax"].ToString());
}
catch (Exception)
{
}
try
{
paramVehicule.Fond = double.Parse(this.reader["fond"].ToString());
}
catch (Exception)
{
}
}
}
this.reader.Dispose();
}
this.serviceConnection.closeConnection();
}
#endregion
return(paramVehicule);
}
