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