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 }