public async Task <IActionResult> FetchMasterDataAsync([FromBody] FormMetadataContext formMetadataContext)
{
try
{
var response = new AppServiceResponse <IDictionary <string, object> >();
var result = await _masterManager.FetchMasterMetaDataAsync(AppContext, formMetadataContext);
if (result == null)
{
return(NotFound());
}
response.Data = result;
return(Ok(response));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, ex.Message));
}
}
/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="applicationContext"></param>
/// <param name="formmetadataContext"></param>
/// <returns></returns>
public async Task <List <T> > FetchMasterMetadataAsync <T>(ApplicationContext applicationContext, FormMetadataContext formMetadataContext)
{
using (var conn = await _connectionFactory.CreateConnectionAsync(applicationContext, DatabaseType.TransactionDB))
{
if (conn.State != ConnectionState.Closed)
{
conn.Close(); conn.Open();
}
var parameters = new DynamicParameters();
parameters.Add("@i_formId", formMetadataContext.FormId, DbType.Int32, ParameterDirection.Input);
//parameters.Add("@i_fieldCategoryId", formMetadataContext.FormCatId, DbType.Int32, ParameterDirection.Input);
//parameters.Add("@i_fieldId", formMetadataContext.FormFieldId, DbType.Int32, ParameterDirection.Input);
var result = await conn.QueryAsync <T>(StoredProcedures.USP_GETMASTERTABLELIST, parameters, commandType : CommandType.StoredProcedure);
if (result == null)
{
return(null);
}
else
{
return(result.ToList());
}
}
}
