public static void Add(IContext context, IProjectSkill project_skill) { Context ctx = context as Context; if (ctx == null) throw new Exception(typeof(Context).FullName + " expected."); SqlCommand command = new SqlCommand("insert into Project_Skill (id_skill, id_project, level) values (@SkillID, @ProjectID, @Level)"); command.Parameters.Add(new SqlParameter("SkillID", project_skill.SkillID)); command.Parameters.Add(new SqlParameter("ProjectID", project_skill.ProjectID)); command.Parameters.Add(new SqlParameter("Level", project_skill.Level)); command.ExecuteNonQuery(); }
public static void Update(IContext context, IProjectSkill project_skill) { Context ctx = context as Context; if (ctx == null) throw new Exception(typeof(Context).FullName + " expected."); SqlCommand command = new SqlCommand("update Project_Skill set id_skill=@SkillID, id_project=@ProjectID, level=@Level where id_project_skill = @ProjectSkillID"); command.Parameters.Add(new SqlParameter("ProjectSkillID", project_skill.ProjectSkillID)); command.Parameters.Add(new SqlParameter("SkillID", project_skill.SkillID)); command.Parameters.Add(new SqlParameter("ProjectID", project_skill.ProjectID)); command.Parameters.Add(new SqlParameter("Level", project_skill.Level)); command.ExecuteNonQuery(); }