public static void InsertNewFormation(String nom, String description, String dateDebut, String dateFin, String etablissement,Guid userId) { bindedinEntities bie = SingletonEntities.Instance; var existingFormation = from f in bie.formations from s in bie.schools where f.name.Equals(nom) where f.school.Equals(s.id) where s.name.Equals(etablissement) select f; if (existingFormation.Count() == 0) { formation ord = new formation { name = nom, description = description, school = Business.SchoolsService.InsertSchool(etablissement, ""), }; bie.formations.AddObject(ord); bie.SaveChanges(); } var idFormation = from f in bie.formations where f.name.Equals(nom) where f.description.Equals(description) select f.id; user_formation uf = new user_formation { user=userId, formation=idFormation.First(), beginning_date = DateTime.Parse(dateDebut, CultureInfo.CreateSpecificCulture("en-US")), end_date = DateTime.Parse(dateFin, CultureInfo.CreateSpecificCulture("en-US")), }; bie.user_formation.AddObject(uf); bie.SaveChanges(); }
/// <summary> /// Deprecated Method for adding a new object to the formations EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToformations(formation formation) { base.AddObject("formations", formation); }
/// <summary> /// Create a new formation object. /// </summary> /// <param name="id">Initial value of the id property.</param> /// <param name="name">Initial value of the name property.</param> /// <param name="description">Initial value of the description property.</param> /// <param name="school">Initial value of the school property.</param> public static formation Createformation(global::System.Int32 id, global::System.String name, global::System.String description, global::System.Int32 school) { formation formation = new formation(); formation.id = id; formation.name = name; formation.description = description; formation.school = school; return formation; }