public void UpdateDraftApplication(ApplicationDraft applicationDraft)
{
string query = $@"
UPDATE [{nameof(Applications)}]
SET [{nameof(Applications.REESTR_NUM)}] = @{nameof(ApplicationDraft.reestr_num)}
,[{nameof(Applications.DOCUMENT_OUT_NUM)}] = @{nameof(ApplicationDraft.DOCUMENT_OUT_NUM)}
,[{nameof(Applications.DOCUMENT_OUT_DATE)}] = @{nameof(ApplicationDraft.DOCUMENT_OUT_DATE)}
,[{nameof(Applications.CAT_RECORD_TYPE)}] = @{nameof(ApplicationDraft.CAT_RECORD_TYPE)}
,[{nameof(Applications.CAT_RECORD_NUM)}] = @{nameof(ApplicationDraft.CAT_RECORD_NUM)}
WHERE {nameof(Applications.Id)} = @{nameof(ApplicationDraft.Id)}
";
_unitOfWork.DbConnection.Execute(query,
applicationDraft,
transaction: _unitOfWork.DbTransaction);
string queryAssessment = $@"
UPDATE [{nameof(Applications_Assessment)}]
SET [{nameof(Applications_Assessment.OTI_EXPERTIES_TYPE)}] = @{nameof(ApplicationDraft.OTI_EXPERTIES_TYPE)}
,[{nameof(Applications_Assessment.OTI_EXPERTIES_DATE)}] = @{nameof(ApplicationDraft.OTI_EXPERTIES_DATE)}
WHERE {nameof(Applications_Assessment.Application_Id)} = @{nameof(ApplicationDraft.Id)}
";
_unitOfWork.DbConnection.Execute(queryAssessment,
applicationDraft,
transaction: _unitOfWork.DbTransaction);
}
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 WrappedResponse <object> UpdateDraftApplication(ApplicationDraft applicationTemplate)
{
if (_userApplicationRepository.GetUserIdByApplicationId(applicationTemplate.Id) == _userContextRepository.GetCurrentUserId())
{
return(_applicationService.UpdateDraftApplication(applicationTemplate));
}
else
{
return(new WrappedResponse <object>()
{
status = ResponseStatus.NotFound, message = "Запрошенная заявка не найдена."
});
}
}
public IActionResult Get(long id, int agency, int status)
{
ApplicationDraft result = _applicationService.GetDraftApplication(new GetDraftApplicationDto()
{
agency = agency,
applicationId = id,
status = status
});
return(new OkObjectResult(new WrappedResponse <ApplicationDraft>()
{
content = result
}));
}
public IActionResult Create(int agency)
{
ApplicationDraft result = _applicationService.CreateDraftApplication(
new Zit.Application.Interfaces.Dto.CreateDraftAppDto()
{
Agency = (Zit.Dto.DtoModels.Agency)agency,
Process = Zit.Dto.DtoModels.Process.assessment
});
return(new OkObjectResult(new WrappedResponse <ApplicationDraft>()
{
content = result
}));
}
public WrappedResponse <object> UpdateDraftApplication(ApplicationDraft applicationTemplate)
{
try
{
_unitOfWork.OpenConnection();
_unitOfWork.Begin();
var result = _applicationService.UpdateDraftApplication(applicationTemplate);
_unitOfWork.Commit();
return(result);
}
finally
{
_unitOfWork.CloseConnection();
}
}
public ApplicationDraft CreateDraftApplication(CreateDraftAppDto draftAppDto)
{
try
{
_unitOfWork.OpenConnection();
_unitOfWork.Begin();
ApplicationDraft result = _applicationService.CreateDraftApplication(draftAppDto);
_unitOfWork.Commit();
return(result);
}
finally
{
_unitOfWork.CloseConnection();
}
}
public WrappedResponse <object> UpdateDraftApplication(ApplicationDraft applicationTemplate)
{
_applicationRepository.UpdateDraftApplication(applicationTemplate);
return(new WrappedResponse <object>());
}
public IActionResult Update([FromBody] ApplicationDraft applicationDraft)
{
WrappedResponse <object> result = _applicationService.UpdateDraftApplication(applicationDraft);
return(new OkObjectResult(result));
}