crlCommission IntfDalCommissionDevis.getCommission(crlCommissionDevis CommissionDevis, crlAgent agent)
{
#region declaration
crlCommission commission = null;
#endregion
#region implementation
if (CommissionDevis != null && agent != null)
{
commission = new crlCommission();
commission.agent = agent;
commission.designationCommission = CommissionDevis.designationCommission;
commission.Destination = CommissionDevis.Destination;
commission.expediteur = CommissionDevis.expediteur;
commission.FraisEnvoi = CommissionDevis.FraisEnvoi.ToString();
commission.MatriculeAgent = agent.matriculeAgent;
commission.ModePaiement = "Commande";
commission.Nombre = CommissionDevis.Nombre;
commission.NumDesignation = CommissionDevis.NumDesignation;
commission.NumExpediteur = CommissionDevis.NumExpediteur;
commission.NumRecepteur = CommissionDevis.NumRecepteur;
commission.NumTrajet = CommissionDevis.NumTrajet;
commission.PieceJustificatif = CommissionDevis.PieceJustificatif;
commission.Poids = CommissionDevis.Poids.ToString("0.00");
commission.recepteur = CommissionDevis.recepteur;
commission.TypeCommission = CommissionDevis.TypeCommission;
commission.typeCommssionObjet = CommissionDevis.typeCommssionObjet;
}
#endregion
return(commission);
}
bool IntfDalCommissionDevis.updateCommissionDevis(crlCommissionDevis CommissionDevis)
{
#region declaration
bool isUpdate = false;
int nombreUpdate = 0;
string numRecepteur = "NULL";
#endregion
#region implementation
if (CommissionDevis != null)
{
if (CommissionDevis.IdCommissionDevis != "")
{
if (CommissionDevis.NumRecepteur != "")
{
numRecepteur = "'" + CommissionDevis.NumRecepteur + "'";
}
this.strCommande = "UPDATE `commissiondevis` SET ";
this.strCommande += "`destination`='" + CommissionDevis.Destination + "', `poids`='" + CommissionDevis.Poids + "', `nombre`='" + CommissionDevis.Nombre + "',";
this.strCommande += "`pieceJustificatif`='" + CommissionDevis.PieceJustificatif + "', `fraisEnvoi`='" + CommissionDevis.FraisEnvoi.ToString("0") + "', ";
this.strCommande += "`numDesignation`='" + CommissionDevis.NumDesignation + "', `typeCommission`='" + CommissionDevis.TypeCommission + "', ";
this.strCommande += "`numProforma`='" + CommissionDevis.NumProforma + "', `numTrajet`='" + CommissionDevis.NumTrajet + "',";
this.strCommande += "`numExpediteur`='" + CommissionDevis.NumExpediteur + "', `numRecepteur`=" + numRecepteur;
this.strCommande += " WHERE (`idCommissionDevis`='" + CommissionDevis.IdCommissionDevis + "')";
this.serviceConnectBase.openConnection();
nombreUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nombreUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isUpdate);
}
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);
}
crlCommissionDevis IntfDalCommissionDevis.selectCommissionDevis(string idCommissionDevis)
{
#region initialisation
IntfDalDesignationCommission serviceDesignationCommission = new ImplDalDesignationCommission();
IntfDalTrajet serviceTrajet = new ImplDalTrajet();
IntfDalClient serviceClient = new ImplDalClient();
IntfDalReceptionnaire serviceReceptionnaire = new ImplDalReceptionnaire();
crlCommissionDevis CommissionDevis = null;
#endregion
#region implementation
if (idCommissionDevis != "")
{
this.strCommande = "SELECT * FROM `commissiondevis` WHERE (`idCommissionDevis`='" + idCommissionDevis + "')";
this.serviceConnectBase.openConnection();
reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
reader.Read();
CommissionDevis = new crlCommissionDevis();
CommissionDevis.Destination = reader["destination"].ToString();
try
{
CommissionDevis.FraisEnvoi = double.Parse(reader["fraisEnvoi"].ToString());
}
catch (Exception) { }
CommissionDevis.IdCommissionDevis = reader["idCommissionDevis"].ToString();
CommissionDevis.PieceJustificatif = reader["pieceJustificatif"].ToString();
try
{
CommissionDevis.Poids = double.Parse(reader["poids"].ToString());
}
catch (Exception) { }
CommissionDevis.TypeCommission = reader["typeCommission"].ToString();
CommissionDevis.NumDesignation = reader["numDesignation"].ToString();
try
{
CommissionDevis.Nombre = int.Parse(reader["nombre"].ToString());
}
catch (Exception) { }
CommissionDevis.NumTrajet = reader["numTrajet"].ToString();
CommissionDevis.NumProforma = reader["numProforma"].ToString();
CommissionDevis.NumExpediteur = reader["numExpediteur"].ToString();
CommissionDevis.NumRecepteur = reader["numRecepteur"].ToString();
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
if (CommissionDevis != null)
{
if (CommissionDevis.NumDesignation != "")
{
CommissionDevis.designationCommission = serviceDesignationCommission.selectDesignationCommission(CommissionDevis.NumDesignation);
}
if (CommissionDevis.NumTrajet != "")
{
CommissionDevis.trajet = serviceTrajet.selectTrajet(CommissionDevis.NumTrajet);
}
if (CommissionDevis.NumExpediteur != "")
{
CommissionDevis.expediteur = serviceClient.selectClient(CommissionDevis.NumExpediteur);
}
if (CommissionDevis.NumRecepteur != "")
{
CommissionDevis.recepteur = serviceReceptionnaire.selectPersonne(CommissionDevis.NumRecepteur);
}
}
}
#endregion
return(CommissionDevis);
}
