public async Task <DlmtCaseSummaryUpdateResponse> UpdateDlmtCaseSummaryAsync(DlmtCaseSummaryUpdateRequest req)
{
using (var conn = new SqlConnection(_connectionSettings.DefaultConnection))
{
var result = new DlmtCaseSummaryUpdateResponse();
const string storeproc = @"[dbo].[uspCaseMainSave_New]";
await conn.OpenAsync();
var dynParm = new
{
req.CaseSummary.Id,
req.CaseSummary.CaseNumber,
req.CaseSummary.CaseTypeId,
req.CaseSummary.AgencyId,
req.CaseSummary.PlanningOfficeId,
req.CaseSummary.ZoneAreaId,
req.CaseSummary.UpdatedBy,
req.CaseSummary.UpdatedDate
};
var rawResult = await conn.QueryAsync <DlmtCaseSummaryDTO>(storeproc, dynParm, null, null, CommandType.StoredProcedure);
result.Data = rawResult.FirstOrDefault();
return(result);
}
}
public async Task <IActionResult> DlmtCaseSummaryUpdateAsync(DlmtCaseSummaryUpdateRequest req)
{
req.CaseSummary.UpdatedBy = User.CurrentUserName();
var result = await _dlmtCasemanager.UpdateDlmtCaseSummaryAsync(req);
return(Ok(result));
}
public async Task <DlmtCaseSummaryUpdateResponse> UpdateDlmtCaseSummaryAsync(DlmtCaseSummaryUpdateRequest req)
{
var result = new DlmtCaseSummaryUpdateResponse();
var validateResult = await ValidateDlmtCaseSummaryModel(req);
if (validateResult != null && validateResult.Any())
{
result.HasError = true;
result.ErrorMsgs = validateResult;
return(result);
}
req.CaseSummary.UpdatedDate = DateTime.Today;
return(await _repos.UpdateDlmtCaseSummaryAsync(req));
}
private async Task <IList <ErrorDTO> > ValidateDlmtCaseSummaryModel(DlmtCaseSummaryUpdateRequest req)
{
var result = new List <ErrorDTO>();
var existingRecord = await _repos.GetCaseSummaryByCaseNumberAsync(req.CaseSummary.CaseNumber);
if (existingRecord != null)
{
if (req.CaseSummary.Id != existingRecord.CaseId && existingRecord.CaseNumber.Equals(req.CaseSummary.CaseNumber.ToLower()))
{
result.Add(new ErrorDTO {
ErrorMsg = "Duplicate Case Number Detected."
});
}
}
if (req.CaseSummary.AgencyId <= 0)
{
result.Add(new ErrorDTO {
ErrorMsg = "Agency is required."
});
}
if (req.CaseSummary.CaseTypeId <= 0)
{
result.Add(new ErrorDTO {
ErrorMsg = "Case type is required."
});
}
if (req.CaseSummary.PlanningOfficeId <= 0)
{
result.Add(new ErrorDTO {
ErrorMsg = "Planning office is required."
});
}
if (req.CaseSummary.ZoneAreaId <= 0)
{
result.Add(new ErrorDTO {
ErrorMsg = "Zone is required."
});
}
return(result);
}
