public static ComposantModel GetComposant(int id) { using (GDA_Context context = new GDA_Context()) { return(context.Composants.FirstOrDefault(x => x.Id == id)?.ToComposantModel()); } }
public static List <ComposantType> GetAllTypes() { using (GDA_Context context = new GDA_Context()) { return(context.ComposantTypes.ToList()); } }
public static void CreerComposant(ComposantModel nouveauComposant) { using (GDA_Context context = new GDA_Context()) { var composant = new Composant { Nom = nouveauComposant.Nom, Abreviation = nouveauComposant.Abreviation, Version = nouveauComposant.Version, Description = nouveauComposant.Description, ComposantTypeId = nouveauComposant.Type.Id, NomBD = nouveauComposant.NomBD, SourceControlPath = nouveauComposant.SourceControlPath, BC = nouveauComposant.BC, BW = nouveauComposant.BW, DerniereMAJ = DateTime.Now }; context.Composants.InsertOnSubmit(composant); context.SubmitChanges(); nouveauComposant.Id = composant.Id; //Set the newly inserted id CreerEnvironnements(context, nouveauComposant); //This call has to be made before adding dependencies ModifierClients(context, nouveauComposant); ModifierResponsables(context, nouveauComposant); ModifierTechnologies(context, nouveauComposant); ModifierDependances(context, nouveauComposant); } }
private static void ModifierTechnologies(GDA_Context context, ComposantModel composantModif) { var technologies = context.ComposantTechnologies.Where(x => x.ComposantId == composantModif.Id); context.ComposantTechnologies.DeleteAllOnSubmit(technologies); //New technologies if (composantModif.Technologies.Any(x => x.Id == 0)) { var nouvellesTechnologies = composantModif.Technologies.Where(x => x.Id == 0).Select(x => new Technologie { Nom = x.Nom }).ToList(); TechnologieBL.CreerTechnologies(nouvellesTechnologies); context.ComposantTechnologies.InsertAllOnSubmit(nouvellesTechnologies.Select(x => new ComposantTechnologie { TechnologieId = x.Id, ComposantId = composantModif.Id })); } //Existing technologies context.ComposantTechnologies.InsertAllOnSubmit(composantModif.Technologies.Where(x => x.Id != 0).Select(x => new ComposantTechnologie { TechnologieId = x.Id, ComposantId = composantModif.Id })); context.SubmitChanges(); }
public static List <Dependance> GetDependances(int[] typesDependance) { using (GDA_Context context = new GDA_Context()) { return(context.ComposantDependances.Where(x => typesDependance.Contains(x.DependanceTypeId)).DistinctBy(x => x.DependanceId).Select(x => x.Dependance).ToList()); } }
private static void ModifierClients(GDA_Context context, ComposantModel composantModif) { var clients = context.ComposantClients.Where(x => x.ComposantId == composantModif.Id); context.ComposantClients.DeleteAllOnSubmit(clients); //New clients if (composantModif.Clients.Any(x => x.Id == 0)) { var nouveauxClients = composantModif.Clients.Where(x => x.Id == 0).Select(x => new Client { Nom = x.Nom }).ToList(); ClientBL.CreerClients(nouveauxClients); context.ComposantClients.InsertAllOnSubmit(nouveauxClients.Select(x => new ComposantClient { ClientId = x.Id, ComposantId = composantModif.Id })); } //Existing clients context.ComposantClients.InsertAllOnSubmit(composantModif.Clients.Where(x => x.Id != 0).Select(x => new ComposantClient { ClientId = x.Id, ComposantId = composantModif.Id })); context.SubmitChanges(); }
private static void ModifierResponsables(GDA_Context context, ComposantModel composantModif) { var responsables = context.ComposantResponsables.Where(x => x.ComposantId == composantModif.Id); context.ComposantResponsables.DeleteAllOnSubmit(responsables); //New responsables if (composantModif.Responsables.Any(x => x.Id == 0)) { var nouveauxResponsables = composantModif.Responsables.Where(x => x.Id == 0).Select(x => new Responsable { Nom = x.Nom }).ToList(); ResponsableBL.CreerResponsables(nouveauxResponsables); context.ComposantResponsables.InsertAllOnSubmit(nouveauxResponsables.Select(x => new ComposantResponsable { ResponsableId = x.Id, ComposantId = composantModif.Id })); } //Existing responsables context.ComposantResponsables.InsertAllOnSubmit(composantModif.Responsables.Where(x => x.Id != 0).Select(x => new ComposantResponsable { ResponsableId = x.Id, ComposantId = composantModif.Id })); context.SubmitChanges(); }
public static List <Client> GetAllClients() { using (GDA_Context context = new GDA_Context()) { return(context.Clients.ToList()); } }
public static List <Technologie> GetAllTechnologies() { using (GDA_Context context = new GDA_Context()) { return(context.Technologies.ToList()); } }
public List <App> Apps() { using (GDA_Context context = new GDA_Context()) { return(context.Apps.ToList()); } }
public static void ModifierComposant(ComposantModel composantModif) { using (GDA_Context context = new GDA_Context()) { var composant = context.Composants.FirstOrDefault(x => x.Id == composantModif.Id); composant.Nom = composantModif.Nom; composant.Abreviation = composantModif.Abreviation; composant.Version = composantModif.Version; composant.Description = composantModif.Description; composant.ComposantTypeId = composantModif.Type.Id; composant.NomBD = composantModif.NomBD; composant.SourceControlPath = composantModif.SourceControlPath; composant.BC = composantModif.BC; composant.BW = composantModif.BW; composant.DerniereMAJ = DateTime.Now; context.SubmitChanges(); ModifierClients(context, composantModif); ModifierResponsables(context, composantModif); ModifierTechnologies(context, composantModif); ModifierDependances(context, composantModif); } }
public static void CreerDeploiement(DeploiementModel nouveauDeploiement) { using (GDA_Context context = new GDA_Context()) { var deploiement = new Deploiement { ComposantId = nouveauDeploiement.Composant.Id, PremierDeploiement = nouveauDeploiement.PremierDeploiement, Date = nouveauDeploiement.DateDeploiement, BrancheTag = nouveauDeploiement.BrancheTag, URLDestination = nouveauDeploiement.UrlDestination, PortailGroupe = nouveauDeploiement.PortailGroupe, PortailDescription = nouveauDeploiement.PortailDescription, Details = nouveauDeploiement.Details, EnvironnementId = nouveauDeploiement.Environnement.Id, DerniereMAJ = DateTime.Now, Web = nouveauDeploiement.Web, BD = nouveauDeploiement.BD, Rapport = nouveauDeploiement.Rapport, Interface = nouveauDeploiement.Interface, Job = nouveauDeploiement.Job }; context.Deploiements.InsertOnSubmit(deploiement); context.SubmitChanges(); nouveauDeploiement.Id = deploiement.Id; //Set the newly inserted id } }
public static DeploiementModel GetDeploiement(int id) { using (GDA_Context context = new GDA_Context()) { return(context.Deploiements.FirstOrDefault(x => x.Id == id)?.ToDeploiementModel()); } }
public static List <Responsable> GetAllResponsables() { using (GDA_Context context = new GDA_Context()) { return(context.Responsables.ToList()); } }
public static List <ComposantBase> GetListComposantBase() { using (GDA_Context context = new GDA_Context()) { return(context.Composants.Select(x => x.ToComposantBaseModel()).ToList()); } }
public static List <Environnement> GetDefaultEnvironnements() { using (GDA_Context context = new GDA_Context()) { return(context.Environnements.Where(x => x.EstDefault).OrderBy(x => x.Ordre).ToList()); } }
public static void CreerResponsables(List <Responsable> responsables) { using (GDA_Context context = new GDA_Context()) { context.Responsables.InsertAllOnSubmit(responsables); context.SubmitChanges(); } }
public static void CreerClients(List <Client> clients) { using (GDA_Context context = new GDA_Context()) { context.Clients.InsertAllOnSubmit(clients); context.SubmitChanges(); } }
public static void CreerTechnologies(List <Technologie> technologies) { using (GDA_Context context = new GDA_Context()) { context.Technologies.InsertAllOnSubmit(technologies); context.SubmitChanges(); } }
public static void CreerDependances(List <Dependance> dependances) { using (GDA_Context context = new GDA_Context()) { context.Dependances.InsertAllOnSubmit(dependances); context.SubmitChanges(); } }
public static void SupprimerDeploiement(int id) { using (GDA_Context context = new GDA_Context()) { var deploiement = context.Deploiements.FirstOrDefault(x => x.Id == id); context.Deploiements.DeleteOnSubmit(deploiement); context.SubmitChanges(); } }
private static void CreerEnvironnements(GDA_Context context, ComposantModel composant) { var environnements = context.Environnements.ToList(); context.ComposantEnvironnements.InsertAllOnSubmit(environnements.Select(x => new ComposantEnvironnement { ComposantId = composant.Id, EnvironnementId = x.Id, Ordre = x.Ordre })); context.SubmitChanges(); }
public static List <ComposantListeModel> GetList(int take = int.MaxValue - 1, int offset = 0, string filtre = null) { using (GDA_Context context = new GDA_Context()) { var query = context.Composants.Select(x => x); if (!String.IsNullOrEmpty(filtre)) { query = query.FilterQuery(filtre); } return(query.Skip(offset).Take(take + 1).Select(x => x.ToComposantListeModel()).ToList()); } }
public static void SupprimerComposant(int id) { using (GDA_Context context = new GDA_Context()) { var composant = context.Composants.FirstOrDefault(x => x.Id == id); context.ComposantClients.DeleteAllOnSubmit(context.ComposantClients.Where(x => x.ComposantId == id)); context.ComposantDependances.DeleteAllOnSubmit(context.ComposantDependances.Where(x => x.ComposantId == id)); context.ComposantEnvironnements.DeleteAllOnSubmit(context.ComposantEnvironnements.Where(x => x.ComposantId == id)); context.ComposantResponsables.DeleteAllOnSubmit(context.ComposantResponsables.Where(x => x.ComposantId == id)); context.ComposantTechnologies.DeleteAllOnSubmit(context.ComposantTechnologies.Where(x => x.ComposantId == id)); context.Deploiements.DeleteAllOnSubmit(context.Deploiements.Where(x => x.ComposantId == id)); context.Composants.DeleteOnSubmit(composant); context.SubmitChanges(); } }
public static List <T> GetCSVList <T>(string filtre = null) { using (GDA_Context context = new GDA_Context()) { var query = context.Composants.Select(x => x); if (!String.IsNullOrEmpty(filtre)) { query = query.FilterQuery(filtre.ToLowerInvariant()); } if (typeof(T) == typeof(CSVComposantListeModelLong)) { return(query.Select(x => (T)Convert.ChangeType(x.ToCSVComposantListeModelLong(), typeof(T))).ToList()); } else if (typeof(T) == typeof(CSVComposantListeModelCourt)) { return(query.Select(x => (T)Convert.ChangeType(x.ToCSVComposantListeModelCourt(), typeof(T))).ToList()); } throw new NotSupportedException($"Type : {typeof(T).Name} is not supported."); } }
public static List <DeploiementListeModel> GetList(int take = int.MaxValue - 1, int offset = 0, string filtre = null) { using (GDA_Context context = new GDA_Context()) { DateTime now = DateTime.Now; var query = context.GetSortableDeploiements(now); if (!String.IsNullOrEmpty(filtre)) { query = query.Where( d => d.ComposantNom.ToLower().Contains(filtre) || d.ComposantAbreviation.ToLower().Contains(filtre) || d.EnvironnementNom.ToLower().Contains(filtre)); } return(query .OrderBy(d => d.EstPasse) .ThenBy(d => d.EcartMinutes) .Skip(offset) .Take(take + 1) .Select(d => d.ToDeploiementListeModel()) .ToList()); } }
public static void ModifierDeploiement(DeploiementModel deploiementModif) { using (GDA_Context context = new GDA_Context()) { var deploiement = context.Deploiements.FirstOrDefault(x => x.Id == deploiementModif.Id); deploiement.ComposantId = deploiementModif.Composant.Id; deploiement.PremierDeploiement = deploiementModif.PremierDeploiement; deploiement.Date = deploiementModif.DateDeploiement; deploiement.BrancheTag = deploiementModif.BrancheTag; deploiement.URLDestination = deploiementModif.UrlDestination; deploiement.PortailGroupe = deploiementModif.PortailGroupe; deploiement.PortailDescription = deploiementModif.PortailDescription; deploiement.Details = deploiementModif.Details; deploiement.EnvironnementId = deploiementModif.Environnement.Id; deploiement.DerniereMAJ = DateTime.Now; deploiement.Web = deploiementModif.Web; deploiement.BD = deploiementModif.BD; deploiement.Rapport = deploiementModif.Rapport; deploiement.Interface = deploiementModif.Interface; deploiement.Job = deploiementModif.Job; context.SubmitChanges(); } }
private static void ModifierDependances(GDA_Context context, ComposantModel composantModif) { var dependances = context.ComposantDependances.Where(x => x.ComposantId == composantModif.Id); context.ComposantDependances.DeleteAllOnSubmit(dependances); //New dependencies if (composantModif.RawDependances.Any(x => x.Etiquette.Id == 0)) { var nouvellesDependances = composantModif.RawDependances.Where(x => x.Etiquette.Id == 0).DistinctBy(x => x.Etiquette.Nom).Select(x => new Dependance { Nom = x.Etiquette.Nom }).ToList(); DependanceBL.CreerDependances(nouvellesDependances); context.ComposantDependances.InsertAllOnSubmit(composantModif.RawDependances.Where(x => x.Etiquette.Id == 0).Select(x => new ComposantDependance { DependanceId = nouvellesDependances.SingleOrDefault(nd => nd.Nom == x.Etiquette.Nom).Id, ComposantId = composantModif.Id, EnvironnementId = x.EnvironnementId, DependanceTypeId = x.Type.Id })); } //Existing dependencies context.ComposantDependances.InsertAllOnSubmit(composantModif.RawDependances.Where(x => x.Etiquette.Id != 0).Select(x => new ComposantDependance { DependanceId = x.Etiquette.Id, ComposantId = composantModif.Id, EnvironnementId = x.EnvironnementId, DependanceTypeId = x.Type.Id })); context.SubmitChanges(); }