public static async Task <Models.SqlServer.Enriquecimento.LayoutSaida> GetLayoutSaida(int origemAppsettingsJson, long idLayoutSaida)
{
Models.SqlServer.Enriquecimento.LayoutSaida layoutSaida = new Models.SqlServer.Enriquecimento.LayoutSaida();
layoutSaida = await Data.SqlServer.Enriquecimento.LayoutSaida.GetByIdLayoutSaida(origemAppsettingsJson, idLayoutSaida);
return(layoutSaida);
}
public static async Task <Models.SqlServer.Enriquecimento.LayoutSaida> GetByIdLayoutSaida(int origemAppsettingsJson, long idLayoutSaida)
{
var parametros = new DynamicParameters();
Models.SqlServer.Enriquecimento.LayoutSaida layoutSaida = new Models.SqlServer.Enriquecimento.LayoutSaida();
List <Models.SqlServer.Enriquecimento.LayoutSaida> list = new List <Models.SqlServer.Enriquecimento.LayoutSaida>();
parametros.Add("@IdLayoutSaida", idLayoutSaida, DbType.Int64, ParameterDirection.Input, null);
using (SqlConnection db = new SqlConnection(Utils.AppConfiguration.GetAppConfiguration(origemAppsettingsJson).GetConnectionString(connectionString)))
{
var result = (await db.QueryAsync <Models.SqlServer.Enriquecimento.LayoutSaida>(
"[LayoutSaidaGetByIdLayoutSaida]",
parametros,
commandType: CommandType.StoredProcedure));
if (result != null)
{
list = result.ToList <Models.SqlServer.Enriquecimento.LayoutSaida>();
}
}
if ((list != null) && (list.Count > 0))
{
layoutSaida = list.First();
}
else
{
layoutSaida = new Models.SqlServer.Enriquecimento.LayoutSaida();
}
return(layoutSaida);
}