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;
}