public async Task <ActionResult <FreezeDto> > GetFreezeForSelectedCompany(
string company,
[FromQuery] string companyList,
[FromQuery] DateTime freezeDate,
[FromQuery] DataVersionTypeDto dataVersionTypeId)
{
companyList = companyList + ',' + company;
var freeze = await _freezeQueries.GetFreezeForSelectedCompanyAsync(companyList, freezeDate, dataVersionTypeId);
return(Ok(freeze));
}
public async Task <ActionResult <FreezeDto> > GetFreeze(string company, DateTime freezeDate, DataVersionTypeDto dataVersionTypeId)
{
var freeze = await _freezeQueries.GetFreezeAsync(company, freezeDate, dataVersionTypeId);
return(Ok(freeze));
}
public async Task <ActionResult> CheckFreezeExists(string company, DateTime freezeDate, DataVersionTypeDto dataVersionTypeId)
{
var freeze = await _freezeQueries.GetFreezeAsync(company, freezeDate, dataVersionTypeId);
if (freeze != null)
{
return(Ok());
}
return(NoContent());
}
public async Task <IEnumerable <FreezeDto> > GetFreezeForSelectedCompanyAsync(string companyId, DateTime freezeDate, DataVersionTypeDto dataVersionTypeId)
{
var queryParameters = new DynamicParameters();
string[] selectedCompanies = new string[] { companyId };
queryParameters.Add("@CompanyId", ToSelectedCompanyTVP(selectedCompanies));
queryParameters.Add("@FreezeDate", freezeDate);
queryParameters.Add("@DataVersionTypeId", dataVersionTypeId);
var freeze = await ExecuteQueryAsync <FreezeDto>(StoredProcedureNames.GetFreeze, queryParameters);
return(freeze.ToList());
}
