private void fillMonths(ref DtoWrapper.Supplier supplier)
{
supplier.MonthsDtos = new List <MonthsViewObject>()
{
new MonthsViewObject()
{
NUMERO_MES = 1, MES = "Enero"
},
new MonthsViewObject()
{
NUMERO_MES = 2, MES = "Febrero"
},
new MonthsViewObject()
{
NUMERO_MES = 3, MES = "Marzo"
},
new MonthsViewObject()
{
NUMERO_MES = 4, MES = "Avril"
},
new MonthsViewObject()
{
NUMERO_MES = 5, MES = "Mayo"
},
new MonthsViewObject()
{
NUMERO_MES = 6, MES = "Junio"
},
new MonthsViewObject()
{
NUMERO_MES = 7, MES = "Julio"
},
new MonthsViewObject()
{
NUMERO_MES = 8, MES = "Agosto"
},
new MonthsViewObject()
{
NUMERO_MES = 9, MES = "Septiembre"
},
new MonthsViewObject()
{
NUMERO_MES = 10, MES = "Octubre"
},
new MonthsViewObject()
{
NUMERO_MES = 11, MES = "Noviembre"
},
new MonthsViewObject()
{
NUMERO_MES = 12, MES = "Diciembre"
}
};
}
public async Task <ISupplierData> LoadValueAsync(string code)
{
var model = new DtoWrapper.Supplier();
fillMonths(ref model);
using (var connection = _sqlExecutor.OpenNewDbConnection())
{
if (connection != null)
{
var queryStore = _queryStoreFactory.GetQueryStore();
queryStore.AddParam(QueryType.QuerySupplierById, code);
var currentQuery = queryStore.BuildQuery();
var queryResult = await connection.QueryFirstOrDefaultAsync <SupplierPoco>(currentQuery).ConfigureAwait(false);
if (queryResult != null)
{
var internalQueryStore = _queryStoreFactory.GetQueryStore();
}
}
}
return(model);
}
