/// <summary>
/// Создает Факультет.
/// </summary>
/// <param name="faculty">Факультет.</param>
/// <returns>Идентификаторо созданного факультета.</returns>
public int Create(FacultyItem faculty)
{
if (string.IsNullOrEmpty(faculty.FullName))
{
throw new Exception("Поле 'FullName' не должно быть пустым.");
}
if (string.IsNullOrEmpty(faculty.ShortName))
{
throw new Exception("Поле 'ShortName' не должно быть пустым.");
}
return _facultyRepository.Create(faculty);
}
public void SetUp()
{
_transactionScope = new TransactionScope();
_facultyRepository = new FacultyRepository();
_faculty = new FacultyItem()
{
FullName = "Экономический",
ShortName = "Э",
};
_facultyNew = new FacultyItem()
{
FullName = "Социальный",
ShortName = "С",
};
}
/// <summary>
/// Создает новый факультет.
/// </summary>
/// <param name="faculty">Факультет.</param>
/// <returns>Идентификатор созданного факультета.</returns>
public int Create(FacultyItem faculty)
{
using (var sqlh = new SqlHelper())
{
return sqlh.ExecScalar<int>(@"
insert into Faculty.faculty
(
full_name,
short_name
)
values
(
@FullName,
@ShortName
)
select scope_identity()", faculty);
}
}
public void SetUp()
{
_transactionScope = new TransactionScope();
_cathedraRepository = new CathedraRepository();
_specialtyRepository = new SpecialtyRepository();
_facultyIdRepository = new FacultyRepository();
_faculty = new FacultyItem()
{
FullName = "Информационный",
ShortName = "И",
};
_cathedra = new CathedraItem()
{
FullName = "Информациионных систем и технологий",
ShortName = "ИСиТ",
FacultyId = _facultyIdRepository.Create(_faculty)
};
_cathedraNew = new CathedraItem()
{
FullName = "Экономика и организация производлства",
ShortName = "ЭиОП",
FacultyId = _facultyIdRepository.Create(_faculty)
};
_specialty = new SpecialtyItem()
{
FullName = "Программное обеспечение вычислительной техники и автоматизированных систем",
ShortName = "Ифн",
Code = "230105",
CathedraId = _cathedraRepository.Create(_cathedra)
};
_specialtyNew = new SpecialtyItem()
{
FullName = "Сисадмин",
ShortName = "Сис",
Code = "123456",
CathedraId = _cathedraRepository.Create(_cathedraNew)
};
}
public void SetUp()
{
_transactionScope = new TransactionScope();
_facultyRepository = new FacultyRepository();
_cathedraRepository = new CathedraRepository();
_faculty = new FacultyItem()
{
FullName = "Информационный",
ShortName = "И",
};
_facultyNew = new FacultyItem()
{
FullName = "Экономический",
ShortName = "Э",
};
_cathedra = new CathedraItem()
{
FullName = "Информациионных систем и технологий",
ShortName = "ИСиТ",
FacultyId = _facultyRepository.Create(_faculty)
};
_cathedraNew = new CathedraItem()
{
FullName = "Экономики и управления",
ShortName = "ЭиЭ",
FacultyId = _facultyRepository.Create(_facultyNew)
};
}
public void SetUp()
{
_transactionScope = new TransactionScope();
_lecturerRepository = new LecturerRepository();
_cathedraRepository = new CathedraRepository();
_facultyRepository = new FacultyRepository();
_personRepository = new PersonRepository();
_faculty = new FacultyItem()
{
FullName = "Информационный",
ShortName = "И",
};
_cathedra = new CathedraItem()
{
FullName = "Информациионных систем и технологий",
ShortName = "ИСиТ",
FacultyId = _facultyRepository.Create(_faculty)
};
_person = new PersonItem()
{
Birthday = DateTime.Now.AddDays(2).Date,
FatherName = "Сидорович",
FirstName = "Сидор",
LastName = "Сидоров",
};
_lecturer = new LecturerItem()
{
CathedraId = _cathedraRepository.Create(_cathedra),
Birthday = _person.Birthday,
FatherName = _person.FatherName,
FirstName = _person.FirstName,
Id = _personRepository.Create(_person),
LastName = _person.LastName,
};
_personNew = new PersonItem()
{
Birthday = DateTime.Now.AddDays(3).Date,
FatherName = "Петрович",
FirstName = "Петр",
LastName = "Петров",
};
_lecturerNew = new LecturerItem()
{
CathedraId = _cathedraRepository.Create(_cathedra),
Birthday = _personNew.Birthday,
FatherName = _personNew.FatherName,
FirstName = _personNew.FirstName,
Id = _personRepository.Create(_person),
LastName = _personNew.LastName
};
}
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="faculty">Факультет.</param>
public void Update(FacultyItem faculty)
{
using (var sqlh = new SqlHelper())
{
sqlh.ExecNoQuery(@"
update Faculty.faculty
set
full_name = @FullName,
short_name = @ShortName
where faculty = @Id", faculty);
}
}
/// <summary>
/// Измененяет данные о факультете.
/// </summary>
/// <param name="faculty">Факультет.</param>
public void Update(FacultyItem faculty)
{
if (string.IsNullOrEmpty(faculty.FullName))
{
throw new Exception("Поле 'FullName' не должно быть пустым.");
}
if (string.IsNullOrEmpty(faculty.ShortName))
{
throw new Exception("Поле 'ShortName' не должно быть пустым.");
}
if (GetById(faculty.Id) == null)
{
throw new Exception("Факультет не найден.");
}
_facultyRepository.Update(faculty);
}
public ActionResult Create(FacultyItem faculty)
{
Access.CheckAccess("Faculty.Creator");
return RedirectToAction("Index", new {id = _facultyService.Create(faculty)});
}
public ActionResult Update(FacultyItem faculty)
{
Access.CheckAccess("Faculty.Updater");
_facultyService.Update(faculty);
return RedirectToAction("Index", new {id = faculty.Id});
}
/// <summary>
/// Интерфейс для создания записи о факультете.
/// </summary>
/// <returns></returns>
public ActionResult New()
{
Access.CheckAccess("Faculty.Creator");
var default_item = new FacultyItem
{
FullName = "",
ShortName = ""
};
return View(default_item);
}
public void SetUp()
{
_facultyRepository = Mock.Of<IFacultyRepository>();
_facultyService = new FacultyService(_facultyRepository);
_faculty = new FacultyItem()
{
FullName = "Экономический",
ShortName = "Э"
};
}
/// <summary>
/// Проверяет эквивалентны ли два факультета.
/// </summary>
/// <param name="first_faculty"></param>
/// <param name="second_faculty"></param>
private void AreEqualFaculties(FacultyItem first_faculty, FacultyItem second_faculty)
{
Assert.AreEqual(first_faculty.Id, second_faculty.Id);
Assert.AreEqual(first_faculty.FullName, second_faculty.FullName);
Assert.AreEqual(first_faculty.ShortName, second_faculty.ShortName);
}
