public static void InsertNewSkill(String name, String description, int level,Guid userId)
{
bindedinEntities bie = SingletonEntities.Instance;
var existing = from c in bie.competences
where c.description.Equals(description)
where c.name.Equals(name)
select c;
if (existing.Count() == 0)
{
competence comp = new competence
{
name=name,
description=description
};
bie.competences.AddObject(comp);
bie.SaveChanges();
}
var idComp = from c in bie.competences
where c.name.Equals(name)
where c.description.Equals(description)
select c.id;
user_competence uc = new user_competence
{
user=userId,
competence=idComp.First(),
level=level,
};
bie.user_competence.AddObject(uc);
bie.SaveChanges();
}
/// <summary>
/// Deprecated Method for adding a new object to the user_competence EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTouser_competence(user_competence user_competence)
{
base.AddObject("user_competence", user_competence);
}
/// <summary>
/// Create a new user_competence object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="user">Initial value of the user property.</param>
/// <param name="competence">Initial value of the competence property.</param>
/// <param name="level">Initial value of the level property.</param>
public static user_competence Createuser_competence(global::System.Int32 id, global::System.Guid user, global::System.Int32 competence, global::System.Int32 level)
{
user_competence user_competence = new user_competence();
user_competence.id = id;
user_competence.user = user;
user_competence.competence = competence;
user_competence.level = level;
return user_competence;
}
