bool IntfDalDesignationCommission.deleteDesignationCommission(crlDesignationCommission DesignationCommission)
{
#region declaration
bool isDelete = false;
int nombreDelete = 0;
#endregion
#region implementation
if (DesignationCommission != null)
{
if (DesignationCommission.NumDesignation != "")
{
this.strCommande = "DELETE FROM `designationcommission` WHERE (`numDesignation` = '" + DesignationCommission.NumDesignation + "')";
this.serviceConnectBase.openConnection();
nombreDelete = this.serviceConnectBase.requete(this.strCommande);
if (nombreDelete == 1)
{
isDelete = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isDelete);
}
crlDesignationCommission IntfDalDesignationCommission.selectDesignationCommission(string numDesignation)
{
#region declaration
crlDesignationCommission DesignationCommission = null;
#endregion
#region implementation
if (numDesignation != "")
{
this.strCommande = "SELECT * FROM `designationcommission` WHERE (`numDesignation`='" + numDesignation + "')";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
DesignationCommission = new crlDesignationCommission();
reader.Read();
DesignationCommission.NumDesignation = reader["numDesignation"].ToString();
DesignationCommission.Designation = reader["designation"].ToString();
DesignationCommission.Paiement = int.Parse(reader["paiement"].ToString());
DesignationCommission.TypeCommission = reader["typeCommission"].ToString();
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(DesignationCommission);
}
string IntfDalDesignationCommission.insertDesignationCommission(crlDesignationCommission DesignationCommission, string sigleAgence)
{
#region declaration
IntfDalDesignationCommission serviceDesignationCommission = new ImplDalDesignationCommission();
int nombreInsertion = 0;
string numRecu = "";
#endregion
#region implementation
if (DesignationCommission != null)
{
DesignationCommission.NumDesignation = serviceDesignationCommission.getNumDesignation(sigleAgence);
this.strCommande = "INSERT INTO `designationcommission` (`numDesignation`,`designation`,`typeCommission`,`paiement`)";
this.strCommande += " VALUES ('" + DesignationCommission.NumDesignation + "', '" + DesignationCommission.Designation + "', ";
this.strCommande += " '" + DesignationCommission.TypeCommission + "', '" + DesignationCommission.Paiement + "')";
this.serviceConnectBase.openConnection();
nombreInsertion = this.serviceConnectBase.requete(this.strCommande);
if (nombreInsertion == 1)
{
numRecu = DesignationCommission.NumDesignation;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numRecu);
}
bool IntfDalDesignationCommission.updateDesignationCommission(crlDesignationCommission DesignationCommission)
{
#region declaration
bool isUpdate = false;
int nombreUpdate = 0;
#endregion
#region implementation
if (DesignationCommission != null)
{
if (DesignationCommission.NumDesignation != "")
{
this.strCommande = "UPDATE `designationcommission` SET `designation`='" + DesignationCommission.Designation + "', ";
this.strCommande += "`typeCommission`='" + DesignationCommission.TypeCommission + "', `paiement`='" + DesignationCommission.Paiement + "'";
this.strCommande += "WHERE (`numDesignation`='" + DesignationCommission.NumDesignation + "')";
this.serviceConnectBase.openConnection();
nombreUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nombreUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isUpdate);
}
string IntfDalDesignationCommission.isDesignationCommission(crlDesignationCommission DesignationCommission)
{
#region declaration
string numDesignationCommission = "";
#endregion
#region implementation
if (DesignationCommission != null)
{
this.strCommande = "SELECT * FROM `designationcommission`";
this.strCommande += " WHERE `numDesignation`<>'" + DesignationCommission.NumDesignation + "' AND";
this.strCommande += " `designation`='" + DesignationCommission.Designation + "' AND";
this.strCommande += " `paiement`='" + DesignationCommission.Paiement + "' AND";
this.strCommande += " `typeCommission`='" + DesignationCommission.TypeCommission + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
numDesignationCommission = this.reader["numDesignation"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numDesignationCommission);
}
protected void btnValiderDesignation_Click(object sender, EventArgs e)
{
#region declaration
crlDesignationCommission designationCommission = new crlDesignationCommission();
#endregion
#region implementation
this.insertToObjDesigantion(designationCommission);
designationCommission.NumDesignation = serviceDesignationCommission.isDesignationCommission(designationCommission);
if (designationCommission.NumDesignation.Equals(""))
{
designationCommission.NumDesignation = serviceDesignationCommission.insertDesignationCommission(designationCommission, agent.agence.SigleAgence);
if (designationCommission.NumDesignation != "")
{
this.initialiseGridDesignation();
}
else
{
//
}
}
else
{
//
}
#endregion
}
private void afficheDesignation(string numDesignation)
{
#region declaration
crlDesignationCommission designation = null;
string strConfirm = "";
#endregion
#region implementation
if (numDesignation != "")
{
designation = serviceDesignationCommission.selectDesignationCommission(numDesignation);
if (designation != null)
{
TextDesignation.Text = designation.Designation;
ddlTypeCommission.SelectedValue = designation.TypeCommission;
ddlModeCalcul.SelectedValue = designation.Paiement.ToString();
hfNumDesignation.Value = designation.NumDesignation;
strConfirm = "Voulez vous vraiment modifier le designation " + designation.Designation + "?";
btnModifierDesignation_ConfirmButtonExtenderbtnModifierDesignation.ConfirmText = strConfirm;
btnModifierDesignation.Enabled = true;
btnValiderDesignation.Enabled = false;
}
}
#endregion
}
private void insertToObjDesigantion(crlDesignationCommission designationCommission)
{
#region implementation
if (designationCommission != null)
{
designationCommission.Designation = TextDesignation.Text;
try
{
designationCommission.Paiement = int.Parse(ddlModeCalcul.SelectedValue);
}
catch (Exception)
{
}
designationCommission.TypeCommission = ddlTypeCommission.SelectedValue;
}
#endregion
}
public crlCommissionDevis()
{
this.IdCommissionDevis = "";
this.Destination = "";
this.FraisEnvoi = 0;
this.PieceJustificatif = "";
this.Poids = 0;
this.Nombre = 0;
this.NumDesignation = "";
this.NumTrajet = "";
this.TypeCommission = "";
this.NumProforma = "";
this.NumExpediteur = "";
this.NumRecepteur = "";
this.trajet = null;
this.typeCommssionObjet = null;
this.designationCommission = null;
this.expediteur = null;
this.recepteur = null;
}
protected void btnModifierDesignation_Click(object sender, EventArgs e)
{
#region declaration
crlDesignationCommission designationCommission = new crlDesignationCommission();
string strNumDesignation = "";
#endregion
#region implementation
if (hfNumDesignation.Value != "")
{
designationCommission = serviceDesignationCommission.selectDesignationCommission(hfNumDesignation.Value);
if (designationCommission != null)
{
this.insertToObjDesigantion(designationCommission);
strNumDesignation = serviceDesignationCommission.isDesignationCommission(designationCommission);
if (strNumDesignation.Equals(""))
{
if (serviceDesignationCommission.updateDesignationCommission(designationCommission))
{
this.initialiseGridDesignation();
}
else
{
//
}
}
else
{
//
}
}
}
#endregion
}
