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