void IntfDalCommissionDevis.insertToGridCommissionDevis(GridView gridView, string param, string paramLike, string valueLike, string numProforma)
{
#region declaration
IntfDalCommissionDevis serviceCommissionDevis = new ImplDalCommissionDevis();
#endregion
#region implementation
this.strCommande = "SELECT commissiondevis.idCommissionDevis, commissiondevis.destination, commissiondevis.poids,";
this.strCommande += " commissiondevis.nombre, commissiondevis.pieceJustificatif, commissiondevis.fraisEnvoi,";
this.strCommande += " commissiondevis.numDesignation, commissiondevis.typeCommission, commissiondevis.numTrajet,";
this.strCommande += " commissiondevis.numProforma FROM commissiondevis";
this.strCommande += " WHERE commissiondevis.numProforma = '" + numProforma + "' AND";
this.strCommande += " " + paramLike + " LIKE '%" + valueLike + "%'";
this.strCommande += " ORDER BY " + param;
gridView.DataSource = serviceCommissionDevis.getDataTableCommissionDevis(this.strCommande);
gridView.DataBind();
#endregion
}
string IntfDalCommissionDevis.insertCommissionDevis(crlCommissionDevis CommissionDevis, string sigleAgence)
{
#region declaration
IntfDalCommissionDevis serviceCommissionDevis = new ImplDalCommissionDevis();
int nombreInsertion = 0;
string idCommissionDevis = "";
string numRecepteur = "NULL";
#endregion
#region implementation
if (CommissionDevis != null)
{
if (CommissionDevis.NumRecepteur != "")
{
numRecepteur = "'" + CommissionDevis.NumRecepteur + "'";
}
CommissionDevis.IdCommissionDevis = serviceCommissionDevis.getidCommissionDevis(sigleAgence);
this.strCommande = "INSERT INTO `commissiondevis` (`idCommissionDevis`,`destination`,`poids`,`nombre`,`pieceJustificatif`,";
this.strCommande += " `fraisEnvoi`,`numDesignation`,`typeCommission`,`numTrajet`,`numProforma`,`numExpediteur`,`numRecepteur`)";
this.strCommande += " VALUES ('" + CommissionDevis.IdCommissionDevis + "','" + CommissionDevis.Destination + "',";
this.strCommande += "'" + CommissionDevis.Poids + "','" + CommissionDevis.Nombre + "','" + CommissionDevis.PieceJustificatif + "',";
this.strCommande += "'" + CommissionDevis.FraisEnvoi.ToString("0") + "','" + CommissionDevis.NumDesignation + "',";
this.strCommande += "'" + CommissionDevis.TypeCommission + "','" + CommissionDevis.NumTrajet + "','" + CommissionDevis.NumProforma + "',";
this.strCommande += "'" + CommissionDevis.NumExpediteur + "'," + numRecepteur + ")";
this.serviceConnectBase.openConnection();
nombreInsertion = this.serviceConnectBase.requete(this.strCommande);
if (nombreInsertion == 1)
{
idCommissionDevis = CommissionDevis.IdCommissionDevis;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(idCommissionDevis);
}
