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 user_formation EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTouser_formation(user_formation user_formation) { base.AddObject("user_formation", user_formation); }
/// <summary> /// Create a new user_formation object. /// </summary> /// <param name="id">Initial value of the id property.</param> /// <param name="user">Initial value of the user property.</param> /// <param name="formation">Initial value of the formation property.</param> /// <param name="beginning_date">Initial value of the beginning_date property.</param> /// <param name="end_date">Initial value of the end_date property.</param> public static user_formation Createuser_formation(global::System.Int32 id, global::System.Guid user, global::System.Int32 formation, global::System.DateTime beginning_date, global::System.DateTime end_date) { user_formation user_formation = new user_formation(); user_formation.id = id; user_formation.user = user; user_formation.formation = formation; user_formation.beginning_date = beginning_date; user_formation.end_date = end_date; return user_formation; }