public string CREATE_SUBJECT_ARHIVE(SubjectArchive SubjectArchive)
{
return($"insert into {GeneralConsts.SCHEMA_NAME}.SubjectArchive (subjectUUID, name, description, creationDate, departmentUUID, creatorUUID, moderatorUUID, changeDate) " +
$"values ('{SubjectArchive.subjectUUID}', '{SubjectArchive.name}', '{SubjectArchive.description}', " +
$"'{SubjectArchive.creationDate}', '{SubjectArchive.department.uuid}', '{SubjectArchive.creator.uuid}', " +
$"'{SubjectArchive.moderator.uuid}', '{SubjectArchive.changeDate}');");
}
//CREATE
public SubjectArchiveResponseDTO Create(CreateSubjectArchiveRequestDTO requestDTO)
{
SubjectArchive subjectArchive = new SubjectArchive()
{
subjectUUID = requestDTO.subjectUUID,
name = requestDTO.name,
description = requestDTO.description,
creationDate = requestDTO.creationDate,
department = new Department()
{
uuid = requestDTO.departmentUUID
},
moderator = new User()
{
uuid = requestDTO.moderatorUUID
},
creator = new User()
{
uuid = requestDTO.creatorUUID
},
changeDate = requestDTO.changeDate
};
subjectArchive = this._queryExecutor.Execute <SubjectArchive>(DatabaseConsts.USER_SCHEMA, this._sqlCommands.CREATE_SUBJECT_ARHIVE(subjectArchive), this._modelMapper.MapToSubjectArchive);
return(this._autoMapper.Map <SubjectArchiveResponseDTO>(subjectArchive));;
}
