string IntfDalUSPoint.insertUSPoint(crlUSPoint point, string sigleAgence)
{
#region declaration
string numPoint = "";
int nbInsert = 0;
IntfDalUSPoint serviceUSPoint = new ImplDalUSPoint();
#endregion
#region implementation
if (point != null)
{
point.NumPoint = serviceUSPoint.getNumUSPoint(sigleAgence);
this.strCommande = "INSERT INTO `uspoint` (`numPoint`,`matriculeAgent`,`dateHeurePoint`,";
this.strCommande += " `numVoyage`,`commentaire`,`numArret`) VALUES ('" + point.NumPoint + "',";
this.strCommande += " '" + point.MatriculeAgent + "','" + point.DateHeurePoint.ToString("yyyy-MM-dd HH:mm:ss") + "',";
this.strCommande += " '" + point.NumVoyage + "','" + point.Commentaire + "','" + point.NumArret + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numPoint = point.NumPoint;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numPoint);
}
void IntfDalUSPoint.insertToGridPointVoyage(GridView gridView, string param, string paramLike, string valueLike, string numVoyage)
{
#region declaration
IntfDalUSPoint serviceUSPoint = new ImplDalUSPoint();
#endregion
#region implementation
this.strCommande = "SELECT uspoint.numPoint, uspoint.matriculeAgent, uspoint.dateHeurePoint,";
this.strCommande += " uspoint.numVoyage, uspoint.commentaire, uspoint.numArret,";
this.strCommande += " usarret.nomArret, uslieu.nomLieu FROM uspoint";
this.strCommande += " Inner Join usarret ON usarret.numArret = uspoint.numArret";
this.strCommande += " Inner Join uslieu ON uslieu.numLieu = usarret.numLieu";
this.strCommande += " WHERE uspoint.numVoyage = '" + numVoyage + "' AND";
this.strCommande += " " + paramLike + " LIKE '%" + valueLike + "%'";
this.strCommande += " ORDER BY " + param;
gridView.DataSource = serviceUSPoint.getDataTablePointVoyage(this.strCommande);
gridView.DataBind();
#endregion
}
