/// <summary>
/// Создает новый учебный план.
/// </summary>
/// <param name="plan">Учебный план.</param>
/// <returns>Идентификатор созданного учебного плана.</returns>
public int Create(PlanItem plan)
{
using (var sqlh = new SqlHelper())
{
return sqlh.ExecScalar<int>(@"
insert into TrainingPlan.specialty_plan
(
name,
specialty_detail,
semester,
lesson_type,
discipline,
auditory
)
values
(
@Name,
@SpecialtyDetail,
@Semester,
@LessonType,
@Discipline,
@Auditory
)
select scope_identity()", plan);
}
}
/// <summary>
/// Обновляет данные по учебному плану.
/// </summary>
/// <param name="plan">Учебный план.</param>
public void Update(PlanItem plan)
{
using (var sqlh = new SqlHelper())
{
sqlh.ExecNoQuery(@"
update TrainingPlan.specialty_plan
set
name = @Name,
specialty_detail = @SpecialtyDetail,
semester = @Semester,
lesson_type = @LessonType,
discipline = @Discipline,
auditory = @Auditory
where specialty_plan = @Id", plan);
}
}