private List <Galatee.Silverlight.ServiceParametrage.CsLibelle> ConstruireListeTypeDeBaseDeDonnees() { List <CsLibelle> ListeDeRetour = new List <CsLibelle>(); CsLibelle TypeDeBaseDeDonnees = null; try { //SQL SERVER TypeDeBaseDeDonnees = new CsLibelle(); TypeDeBaseDeDonnees.CODE = "SQL SERVER"; TypeDeBaseDeDonnees.LIBELLE = "System.Data.SqlClient"; ListeDeRetour.Add(TypeDeBaseDeDonnees); // POSTGRESQL TypeDeBaseDeDonnees = new CsLibelle(); TypeDeBaseDeDonnees.CODE = "POSTGRESQL"; TypeDeBaseDeDonnees.LIBELLE = "Devart.Data.PostgreSql"; ListeDeRetour.Add(TypeDeBaseDeDonnees); // ORACLE TypeDeBaseDeDonnees = new CsLibelle(); TypeDeBaseDeDonnees.CODE = "ORACLE"; TypeDeBaseDeDonnees.LIBELLE = "Oracle.DataAccess.Client"; ListeDeRetour.Add(TypeDeBaseDeDonnees); return(ListeDeRetour); } catch (Exception ex) { throw ex; } }
public static List <CsLibelle> FillTa(SqlDataReader reader, List <CsLibelle> rows, int start, int pageLength) { for (int i = 0; i < start; i++) { if (!reader.Read()) { return(rows); } } string LClient = string.Empty; for (int i = 0; i < pageLength; i++) { if (!reader.Read()) { break; } try { CsLibelle c = new CsLibelle(); c.CODE = (Convert.IsDBNull(reader["CODE"])) ? String.Empty : (System.String)reader["CODE"]; c.LIBELLE = (Convert.IsDBNull(reader["LIBELLE"])) ? String.Empty : (System.String)reader["LIBELLE"]; rows.Add(c); } catch (Exception ex) { throw ex; } } return(rows); }
private List <CsLibelle> ConstituerListeGroupeBoxSaisie() { try { List <CsLibelle> ListeLibelle = new List <CsLibelle>(); CsLibelle Facultatif = new CsLibelle(); Facultatif.CODE = "F"; Facultatif.LIBELLE = Languages.LibFacultatif; ListeLibelle.Add(Facultatif); CsLibelle Interdit = new CsLibelle(); Interdit.CODE = "I"; Interdit.LIBELLE = Languages.LibInterdit; ListeLibelle.Add(Interdit); CsLibelle Obligatoire = new CsLibelle(); Obligatoire.CODE = "O"; Obligatoire.LIBELLE = Languages.LibObligatoire; ListeLibelle.Add(Obligatoire); return(ListeLibelle); } catch (Exception ex) { throw ex; } }
private List <CsLibelle> ConstruireListeRedevance() { List <CsLibelle> ListeRedevance = new List <CsLibelle>(); CsLibelle RedevanceNormale = new CsLibelle(); RedevanceNormale.CODE = "0"; RedevanceNormale.LIBELLE = Languages.RedevanceNormale; ListeRedevance.Add(RedevanceNormale); CsLibelle RedevanceParametreAutre = new CsLibelle(); RedevanceParametreAutre.CODE = "1"; RedevanceParametreAutre.LIBELLE = Languages.RedevanceParametreAutre; ListeRedevance.Add(RedevanceParametreAutre); CsLibelle RedevanceAdmettantRedevanceEnParametre = new CsLibelle(); RedevanceAdmettantRedevanceEnParametre.CODE = "2"; RedevanceAdmettantRedevanceEnParametre.LIBELLE = Languages.RedevanceAdmettantRedevanceEnParametre; ListeRedevance.Add(RedevanceAdmettantRedevanceEnParametre); CsLibelle RedevanceParametreAutreAdmettantRedevanceEnParametre = new CsLibelle(); RedevanceParametreAutreAdmettantRedevanceEnParametre.CODE = "3"; RedevanceParametreAutreAdmettantRedevanceEnParametre.LIBELLE = Languages.RedevanceParametreAutreAdmettantRedevanceEnParametre; ListeRedevance.Add(RedevanceParametreAutreAdmettantRedevanceEnParametre); return(ListeRedevance); }
private List <CsLibelle> ConstituerListeGroupeBoxFacturation() { List <CsLibelle> ListeLibelle = new List <CsLibelle>(); try { CsLibelle Normale = new CsLibelle(); Normale.CODE = "1"; Normale.LIBELLE = Languages.LibNormale; ListeLibelle.Add(Normale); CsLibelle Forfait = new CsLibelle(); Forfait.CODE = "2"; Forfait.LIBELLE = Languages.LibForfait; ListeLibelle.Add(Forfait); CsLibelle BloqueSansRegularisation = new CsLibelle(); BloqueSansRegularisation.CODE = "3"; BloqueSansRegularisation.LIBELLE = Languages.LibBloqueeSansRegularisation; ListeLibelle.Add(BloqueSansRegularisation); CsLibelle SansTarifUnitaire = new CsLibelle(); SansTarifUnitaire.CODE = "4"; SansTarifUnitaire.LIBELLE = Languages.LibSansTarifUnitaire; ListeLibelle.Add(SansTarifUnitaire); CsLibelle SansTarifAnnuel = new CsLibelle(); SansTarifAnnuel.CODE = "5"; SansTarifAnnuel.LIBELLE = Languages.LibSansTarifAnnuel; ListeLibelle.Add(SansTarifAnnuel); CsLibelle ForfaitSansRegularisation = new CsLibelle(); ForfaitSansRegularisation.CODE = "6"; ForfaitSansRegularisation.LIBELLE = Languages.LibForfaitSansRegularisation; ListeLibelle.Add(ForfaitSansRegularisation); CsLibelle BloqueAvecRegulation = new CsLibelle(); BloqueAvecRegulation.CODE = "7"; BloqueAvecRegulation.LIBELLE = Languages.LibBloqueeAvecRegularisation; ListeLibelle.Add(BloqueAvecRegulation); CsLibelle EstimeAvecRegularisation = new CsLibelle(); EstimeAvecRegularisation.CODE = "8"; EstimeAvecRegularisation.LIBELLE = Languages.LibEstimeeAvecRegularisation; ListeLibelle.Add(EstimeAvecRegularisation); CsLibelle EstimeSansRegularisation = new CsLibelle(); EstimeSansRegularisation.CODE = "9"; EstimeSansRegularisation.LIBELLE = Languages.LibEstimeeSansRegularisation; ListeLibelle.Add(EstimeSansRegularisation); return(ListeLibelle); } catch (Exception ex) { throw ex; } }
public List <CsLibelle> RetourneSousMenuCompta() { CsLibelle _ta; List <CsLibelle> ListeTA = new List <CsLibelle>(); cn = new SqlConnection(ConnectionString); cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SPX_INTERFACE_RETOURNE_SOUS_MENUS_COMPTA_FAC"; try { if (this.cn.State == ConnectionState.Closed) { this.cn.Open(); } SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); // throw new Exception("Erreur survenue."); } while (reader.Read()) { _ta = new CsLibelle(); _ta.CODE = string.IsNullOrEmpty(reader.GetValue(0).ToString()) ? string.Empty : reader.GetValue(0).ToString().Trim(); _ta.LIBELLE = string.IsNullOrEmpty(reader.GetValue(1).ToString()) ? string.Empty : reader.GetValue(1).ToString().Trim(); ListeTA.Add(_ta); } //Fermeture reader reader.Close(); return(ListeTA); } catch (Exception ex) { throw new Exception("SPX_INTERFACE_RETOURNE_SOUS_MENUS_COMPTA_FAC" + ":" + ex.Message); } finally { if (this.cn.State == ConnectionState.Open) { this.cn.Close(); // Fermeture de la connection } cmd.Dispose(); } }
public List <CsLibelle> RetourneActiviteProduits() { CsLibelle _ta; List <CsLibelle> ListeTA = new List <CsLibelle>(); cn = new SqlConnection(ConnectionString); cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = EnumProcedureStockee.SelectActiviteProduit; try { if (this.cn.State == ConnectionState.Closed) { this.cn.Open(); } SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); throw new Exception(EnumProcedureStockee.SelectActiviteProduit + ":" + " n'a retourné aucun jeu de caractères"); } while (reader.Read()) { _ta = new CsLibelle(); _ta.CODE = string.IsNullOrEmpty(reader.GetValue(0).ToString()) ? string.Empty : reader.GetValue(0).ToString().Trim(); _ta.LIBELLE = string.IsNullOrEmpty(reader.GetValue(1).ToString()) ? string.Empty : reader.GetValue(1).ToString().Trim(); ListeTA.Add(_ta); } //Fermeture reader reader.Close(); return(ListeTA); } catch (Exception ex) { throw new Exception(EnumProcedureStockee.SelectActiviteProduit + ":" + ex.Message); } finally { if (this.cn.State == ConnectionState.Open) { this.cn.Close(); // Fermeture de la connection } cmd.Dispose(); } }
/// <summary> /// SelectTDEM_LIBELLE_TDEM /// </summary> /// <returns></returns> /// public List <CsLibelle> SelectCoperLibelle100() { List <CsLibelle> COPER = new List <CsLibelle>(); CsLibelle typedem; CsLibelle ObjtypedemVide = new CsLibelle(); cn = new SqlConnection(ConnectionString); cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = EnumProcedureStockee.SelectCOPER_LIBELLE100; try { if (cn.State == ConnectionState.Closed) { cn.Open(); } StartTransaction(cn); SqlDataReader reader = cmd.ExecuteReader(); CommitTransaction(cmd.Transaction); while (reader.Read()) { typedem = new CsLibelle(); typedem.CODE = reader.GetValue(0).ToString().Trim(); typedem.LIBELLE = reader.GetValue(1).ToString().Trim(); COPER.Add(typedem); } //Fermeture reader reader.Close(); return(COPER); } catch (Exception ex) { RollBackTransaction(cmd.Transaction); throw new Exception(EnumProcedureStockee.SelectTDEMLIBELLE + ":" + ex.Message); } finally { if (cn.State == ConnectionState.Open) { cn.Close(); // Fermeture de la connection } cmd.Dispose(); } }
private List<CsLibelle> ConstruireListeSupport() { List<CsLibelle> ListeSupport = new List<CsLibelle>(); CsLibelle Piece = new CsLibelle(); Piece.CODE = "0"; Piece.LIBELLE = Languages.Piece; ListeSupport.Add(Piece); CsLibelle Billet = new CsLibelle(); Billet.CODE = "1"; Billet.LIBELLE = Languages.Billet; ListeSupport.Add(Billet); return ListeSupport; }
public List <CsLibelle> RetourneTousMoisComptables() { CsLibelle _ta; List <CsLibelle> ListeTA = new List <CsLibelle>(); cn = new SqlConnection(ConnectionString); cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = EnumProcedureStockee.SelectARRETE; try { if (this.cn.State == ConnectionState.Closed) { this.cn.Open(); } SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); // throw new Exception("Erreur survenue."); } while (reader.Read()) { _ta = new CsLibelle(); _ta.LIBELLE = reader.GetValue(0).ToString().Trim(); ListeTA.Add(_ta); } //Fermeture reader reader.Close(); return(ListeTA); } catch (Exception ex) { throw new Exception(EnumProcedureStockee.SelectARRETE + ":" + ex.Message); } finally { if (this.cn.State == ConnectionState.Open) { this.cn.Close(); // Fermeture de la connection } cmd.Dispose(); } }
private List <CsLibelle> Fill(SqlDataReader reader, List <CsLibelle> rows, int start, int pageLength) { for (int i = 0; i < start; i++) { if (!reader.Read()) { return(rows); } } for (int i = 0; i < pageLength; i++) { if (!reader.Read()) { break; } CsLibelle c = new CsLibelle(); c.fk_Site = (Convert.IsDBNull(reader["Site"])) ? string.Empty : (System.String)reader["Site"]; c.fk_Centre = (Convert.IsDBNull(reader["Centre"])) ? string.Empty : (System.String)reader["Centre"]; rows.Add(c); } return(rows); }