/// <summary> /// Интерфейс для создания учебного курса. /// </summary> /// <returns></returns> public ActionResult New() { Access.CheckAccess("SpecialtyDetail.Creator"); var defaultitem = new SpecialtyDetailItem(); return(View(defaultitem)); }
public void SetUp() { _transactionScope = new TransactionScope(); _specialtyRepository = new SpecialtyRepository(); _specialtyDetailRepository = new SpecialtyDetailRepository(); _cathedraRepository = new CathedraRepository(); _facultyRepository = new FacultyRepository(); _faculty = new FacultyItem() { FullName = "Информационный", ShortName = "И", }; _cathedra = new CathedraItem() { FullName = "Информациионных систем и технологий", ShortName = "ИСиТ", FacultyId = _facultyRepository.Create(_faculty) }; _specialty = new SpecialtyItem() { FullName = "Программное обеспечение вычислительной техники и автоматизированных систем", ShortName = "Ифн", Code = "230105", CathedraId = _cathedraRepository.Create(_cathedra) }; _specialtyNew = new SpecialtyItem() { FullName = "Экономика и технология производства", ShortName = "ЭТП", Code = "230221", CathedraId = _cathedraRepository.Create(_cathedra) }; _specialtyDetail = new SpecialtyDetailItem() { ActualDate = new DateTime(2015, 01, 01), SpecialtyId = _specialtyRepository.Create(_specialty), SemestrCount = 1, TrainingPeriod = 1, Qualification = Qualification.Bachelor, FormStudy = FormStudy.Distance, PaySpace = 15, LowcostSpace = 4, }; _specialtyDetailNew = new SpecialtyDetailItem() { ActualDate = new DateTime(2015, 01, 02), SpecialtyId = _specialtyRepository.Create(_specialtyNew), SemestrCount = 2, TrainingPeriod = 2, Qualification = Qualification.Master, FormStudy = FormStudy.Fulltime, PaySpace = 30, LowcostSpace = 6, }; }
/// <summary> /// Создает новый учебный курс. /// </summary> /// <param name="specialty_detail">Учебный курс.</param> /// <returns>Идентификатор созданного учебного курса.</returns> public int Create(SpecialtyDetailItem specialty_detail) { using (var sqlh = new SqlHelper()) { return(sqlh.ExecScalar <int>(@" insert into Specialty.specialty_detail ( actual_date, specialty, semestr_count, training_period, qualification, form_study, pay_space, lowcost_space ) values ( @ActualDate, @SpecialtyId, @SemestrCount, @TrainingPeriod, (select top 1 q.qualification from Specialty.qualification q where q.code = @Qualification), (select top 1 fs.form_study from Specialty.form_study fs where fs.code = @FormStudy), @PaySpace, @LowcostSpace ) select scope_identity()", specialty_detail)); } }
/// <summary> /// Обновляет данные по учебному курсу. /// </summary> /// <param name="specialty_detail">Учебный курс.</param> public void Update(SpecialtyDetailItem specialty_detail) { if (GetById(specialty_detail.Id) == null) { throw new Exception("Учебный курс не найден."); } _specialtydetailRepository.Update(specialty_detail); }
/// <summary> /// Проверяет эквивалентны ли два учебных курса. /// </summary> /// <param name="first_specialty_detail">Первый учебный курс</param> /// <param name="second_specialty_detail">Второй учебный курс</param> private void AreEqualSpecialtyDetails(SpecialtyDetailItem first_specialty_detail, SpecialtyDetailItem second_specialty_detail) { Assert.AreEqual(first_specialty_detail.Id, second_specialty_detail.Id); Assert.AreEqual(first_specialty_detail.ActualDate, second_specialty_detail.ActualDate); Assert.AreEqual(first_specialty_detail.SemestrCount, second_specialty_detail.SemestrCount); Assert.AreEqual(first_specialty_detail.TrainingPeriod, second_specialty_detail.TrainingPeriod); Assert.AreEqual(first_specialty_detail.PaySpace, second_specialty_detail.PaySpace); Assert.AreEqual(first_specialty_detail.LowcostSpace, second_specialty_detail.LowcostSpace); }
public void SetUp() { _specialtyDetailRepository = Mock.Of <ISpecialtyDetailRepository>(); _specialtyDetailService = new SpecialtyDetailService(_specialtyDetailRepository); _specialtyDetail = new SpecialtyDetailItem() { ActualDate = new DateTime(2015, 01, 01), SpecialtyId = 1, SemestrCount = 1, TrainingPeriod = 1, Qualification = Qualification.Bachelor, FormStudy = FormStudy.Distance, PaySpace = 15, LowcostSpace = 4, }; }
/// <summary> /// Обновляет данные по учебному курсу. /// </summary> /// <param name="specialty_detail">Учебный курс.</param> public void Update(SpecialtyDetailItem specialty_detail) { using (var sqlh = new SqlHelper()) { sqlh.ExecNoQuery(@" update Specialty.specialty_detail set actual_date = @ActualDate, specialty = @SpecialtyId, semestr_count = @SemestrCount, training_period = @TrainingPeriod, qualification = (select top 1 q.qualification from Specialty.qualification q where q.code = @Qualification), form_study = (select top 1 fs.form_study from Specialty.form_study fs where fs.code = @FormStudy), pay_space = @PaySpace, lowcost_space = @LowcostSpace where specialty_detail = @Id", specialty_detail); } }
public void SetUp() { _transactionScope = new TransactionScope(); _teamRepository = new TeamRepository(); _specialtyDetailRepository = new SpecialtyDetailRepository(); _specialtyRepository = new SpecialtyRepository(); _cathedraRepository = new CathedraRepository(); _facultyRepository = new FacultyRepository(); var specialty_detail = new SpecialtyDetailItem() { SpecialtyId = _specialtyRepository.Create(new SpecialtyItem() { CathedraId = _cathedraRepository.Create(new CathedraItem() { FacultyId = _facultyRepository.Create(new FacultyItem()), FullName = "Кафедра", ShortName = "K" }), FullName = "Специальность", ShortName = "С", Code = "1" }), ActualDate = DateTime.Now }; _team = new TeamItem() { Name = "ПЕ-22б", CreateDate = DateTime.Now.Date, SpecialtyDetailId = _specialtyDetailRepository.Create(specialty_detail) }; _teamNew = new TeamItem() { Name = "ПЕ-21б", CreateDate = DateTime.Now.AddYears(-1).Date, SpecialtyDetailId = _specialtyDetailRepository.Create(specialty_detail) }; }
public ActionResult Update(SpecialtyDetailItem specialty_detail) { Access.CheckAccess("SpecialtyDetail.Updater"); _specialtyDetailService.Update(specialty_detail); return(RedirectToAction("Index", new { id = specialty_detail.Id })); }
public ActionResult Create(SpecialtyDetailItem specialty_detail) { Access.CheckAccess("SpecialtyDetail.Creator"); return(RedirectToAction("List", new { id = _specialtyDetailService.Create(specialty_detail) })); }
/// <summary> /// Создает новый учебный курс. /// </summary> /// <param name="specialty_detail">Учебный курс.</param> /// <returns>Идентификатор созданного учебного курса.</returns> public int Create(SpecialtyDetailItem specialty_detail) { return(_specialtydetailRepository.Create(specialty_detail)); }