/// <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);
}
}
public ActionResult Create(SpecialtyDetailItem specialty_detail)
{
Access.CheckAccess("SpecialtyDetail.Creator");
return RedirectToAction("List", new { id = _specialtyDetailService.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 });
}
/// <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="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);
}
/// <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="specialty_detail">Учебный курс.</param>
/// <returns>Идентификатор созданного учебного курса.</returns>
public int Create(SpecialtyDetailItem specialty_detail)
{
return _specialtydetailRepository.Create(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 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);
}
}
