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); }