public ApplicationDraft GetDraftApplication(GetDraftApplicationDto getDraftApplication)
{
ApplicationDraft result = _applicationRepository.GetDraftApplication(getDraftApplication);
result.Files = _fileRepository.GetFileInfos(getDraftApplication.applicationId);
return(result);
}
public ApplicationDraft GetDraftApplication(GetDraftApplicationDto getDraftApplication)
{
int userId = _userContextRepository.GetCurrentUserId();
string query = $@"
SELECT
a.{nameof(Applications.Id)} as {nameof(ApplicationDraft.Id)}
, a.{nameof(Applications.Agency)} as {nameof(ApplicationDraft.agency)}
, a.{nameof(Applications.ApplicationDate)} as {nameof(ApplicationDraft.ApplicationDate)}
, a.{nameof(Applications.CAT_RECORD_TYPE)} as {nameof(ApplicationDraft.CAT_RECORD_TYPE)}
, a.{nameof(Applications.DOCUMENT_OUT_DATE)} as {nameof(ApplicationDraft.DOCUMENT_OUT_DATE)}
, a.{nameof(Applications.DOCUMENT_OUT_NUM)} as {nameof(ApplicationDraft.DOCUMENT_OUT_NUM)}
, a.{nameof(Applications.Process)} as {nameof(ApplicationDraft.process)}
, a.{nameof(Applications.REESTR_NUM)} as {nameof(ApplicationDraft.reestr_num)}
, a.{nameof(Applications.Status)} as {nameof(ApplicationDraft.status)}
, a.{nameof(Applications.CAT_RECORD_NUM)} as {nameof(ApplicationDraft.CAT_RECORD_NUM)}
, aa.{nameof(Applications_Assessment.OTI_EXPERTIES_TYPE)} as {nameof(ApplicationDraft.OTI_EXPERTIES_TYPE)}
, aa.{nameof(Applications_Assessment.OTI_EXPERTIES_DATE)} as {nameof(ApplicationDraft.OTI_EXPERTIES_DATE)}
FROM {nameof(Applications)} a
join {nameof(Applications_Assessment)} aa on a.{nameof(Applications.Id)} = aa.{nameof(Applications_Assessment.Application_Id)}
WHERE {nameof(Applications.Id)} = @{nameof(GetDraftApplicationDto.applicationId)}
and {nameof(Applications.Agency)} = @{nameof(GetDraftApplicationDto.agency)}
and {nameof(Applications.Status)} = @{nameof(GetDraftApplicationDto.status)}
and {nameof(Applications.User_Id)} = @{nameof(userId)}
";
ApplicationDraft application = _unitOfWork.DbConnection
.QuerySingleOrDefault <ApplicationDraft>(query,
new { getDraftApplication.applicationId,
getDraftApplication.agency,
getDraftApplication.status,
userId },
transaction: _unitOfWork.DbTransaction);
return(application);
}
public ApplicationDraft GetDraftApplication(GetDraftApplicationDto getDraftApplication)
{
try
{
_unitOfWork.OpenConnection();
return(_applicationService.GetDraftApplication(getDraftApplication));
}
finally
{
_unitOfWork.CloseConnection();
}
}
public ApplicationDraft GetDraftApplication(GetDraftApplicationDto getDraftApplication)
{
return(_applicationService.GetDraftApplication(getDraftApplication));
}
