void IntfDalUSCarteReduction.insertToGridCarteReduction(GridView gridView, string param, string paramLike, string valueLike) { #region declaration IntfDalUSCarteReduction serviceUSCarteReduction = new ImplDalUSCarteReduction(); #endregion #region implementation this.strCommande = "SELECT client.numClient, client.nomClient, client.prenomClient, client.adresseClient,"; this.strCommande += " client.cinClient, client.telephoneClient, client.mobileClient, client.isCheque,"; this.strCommande += " client.isBonCommande, uscartereduction.numCarteReduction,"; this.strCommande += " uscartereduction.numClient, uscartereduction.etatCivil,"; this.strCommande += " uscartereduction.dateNaissance, dateAtestationEmployeur, dateDelivranceCertificatScolarite,"; this.strCommande += " uscartereduction.dateValideDu, uscartereduction.dateValideAu,"; this.strCommande += " uscartereduction.isLundi, uscartereduction.isMardi, uscartereduction.isMercredi,"; this.strCommande += " uscartereduction.isJeudi, uscartereduction.isVendredi, uscartereduction.isSamedi,"; this.strCommande += " uscartereduction.isDimanche, uscartereduction.numCategorieBillet,"; this.strCommande += " uscartereduction.imageCarteReduction FROM uscartereduction"; this.strCommande += " Inner Join client ON client.numClient = uscartereduction.numClient"; this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%'"; this.strCommande += " ORDER BY " + param; gridView.DataSource = serviceUSCarteReduction.getDataTableCarteReduction(this.strCommande); gridView.DataBind(); #endregion }
bool IntfDalUSCarteReduction.isCarteReductionValide(string numCarteReduction, DateTime date) { #region declaration bool isValide = false; crlUSCarteReduction carteReduction = null; IntfDalUSCarteReduction serviceUSCarteReduction = new ImplDalUSCarteReduction(); int jourSemaine = -1; #endregion #region implementation if (numCarteReduction != "") { carteReduction = serviceUSCarteReduction.selectUSCarteReduction(numCarteReduction); if (carteReduction != null) { if (carteReduction.DateValideDu <= date && carteReduction.DateValideAu >= date) { try { jourSemaine = int.Parse(date.DayOfWeek.ToString("d")); } catch (Exception) { } if (jourSemaine == 0 && carteReduction.IsDimanche == 1) { isValide = true; } if (jourSemaine == 1 && carteReduction.IsLundi == 1) { isValide = true; } if (jourSemaine == 2 && carteReduction.IsMardi == 1) { isValide = true; } if (jourSemaine == 3 && carteReduction.IsMercredi == 1) { isValide = true; } if (jourSemaine == 4 && carteReduction.IsJeudi == 1) { isValide = true; } if (jourSemaine == 5 && carteReduction.IsVendredi == 1) { isValide = true; } if (jourSemaine == 6 && carteReduction.IsSamedi == 1) { isValide = true; } } } } #endregion return isValide; }
string IntfDalUSCarteReduction.insertUSCarteReduction(crlUSCarteReduction carteReduction, string sigleAgence) { #region declaration string numCarteReduction = ""; IntfDalUSCarteReduction serviceUSCarteReduction = new ImplDalUSCarteReduction(); int nbInsert = 0; string dateDelivranceCertificatScolarite = "NULL"; string dateAtestationEmployeur = "NULL"; string numEtablissementScolaire = "NULL"; string numSociete = "NULL"; #endregion #region implemenbtation if (carteReduction != null) { if (carteReduction.DateDelivranceCertificatScolarite.Year > 1) { dateDelivranceCertificatScolarite = "'" + carteReduction.DateDelivranceCertificatScolarite.ToString("yyyy-MM-dd") + "'"; } if (carteReduction.DateAtestationEmployeur.Year > 1) { dateAtestationEmployeur = "'" + carteReduction.DateAtestationEmployeur.ToString("yyyy-MM-dd") + "'"; } if (carteReduction.NumEtablissementScolaire != "") { numEtablissementScolaire = "'" + carteReduction.NumEtablissementScolaire + "'"; } if (carteReduction.NumSociete != "") { numSociete = "'" + carteReduction.NumSociete + "'"; } carteReduction.NumCarteReduction = serviceUSCarteReduction.getNumUSCarteReduction(sigleAgence); this.strCommande = "INSERT INTO `uscartereduction` (`numCarteReduction`,`numClient`,`numCategorieBillet`,"; this.strCommande += " `dateValideDu`,`dateValideAu`,`isLundi`,`isMardi`,`isMercredi`,`isJeudi`,`isVendredi`,"; this.strCommande += " `isSamedi`,`isDimanche`,`etatCivil`,`dateNaissance`,`imageCarteReduction`,"; this.strCommande += " `dateDelivranceCertificatScolarite`,`dateAtestationEmployeur`,`numEtablissementScolaire`,"; this.strCommande += " `numSociete`) VALUES ('" + carteReduction.NumCarteReduction + "',"; this.strCommande += " '" + carteReduction.NumClient + "','" + carteReduction.NumCategorieBillet + "',"; this.strCommande += " '" + carteReduction.DateValideDu.ToString("yyyy-MM-dd") + "',"; this.strCommande += " '" + carteReduction.DateValideAu.ToString("yyyy-MM-dd") + "',"; this.strCommande += " '" + carteReduction.IsLundi.ToString("0") + "','" + carteReduction.IsMardi.ToString("0") + "',"; this.strCommande += " '" + carteReduction.IsMercredi.ToString("0") + "',"; this.strCommande += " '" + carteReduction.IsJeudi.ToString("0") + "','" + carteReduction.IsVendredi.ToString("0") + "',"; this.strCommande += " '" + carteReduction.IsSamedi.ToString("0") + "','" + carteReduction.IsDimanche.ToString("0") + "',"; this.strCommande += " '" + carteReduction.EtatCivil + "',"; this.strCommande += " '" + carteReduction.DateNaissance.ToString("yyyy-MM-dd") + "','" + carteReduction.ImageCarteReduction + "',"; this.strCommande += " " + dateDelivranceCertificatScolarite + "," + dateAtestationEmployeur + ","; this.strCommande += " " + numEtablissementScolaire + "," + numSociete + ")"; this.serviceConnectBase.openConnection(); nbInsert = this.serviceConnectBase.requete(this.strCommande); if (nbInsert == 1) { numCarteReduction = carteReduction.NumCarteReduction; } this.serviceConnectBase.closeConnection(); } #endregion return numCarteReduction; }