public async Task <ConfigurationResponse> GetListOfConfigurationAsync() { DC.ConfigurationResponse configurationResponse1 = new DC.ConfigurationResponse(); try { Model.ConfigurationResponse configurationResponse = await _laptopDAL.GetListOfConfigurationAsync(); configurationResponse1 = _mapper.Map <DC.ConfigurationResponse>(configurationResponse); } catch (Exception) { } return(configurationResponse1); }
public async Task <MODEL.ConfigurationResponse> GetListOfConfigurationAsync() { MODEL.ConfigurationResponse configurationResponse = new MODEL.ConfigurationResponse(); try { List <MODEL.Configuration> list = new List <MODEL.Configuration>(); List <Ram> rams = new List <Ram>(); List <Hdd> hdds = new List <Hdd>(); List <Color> colors = new List <Color>(); using (var firstConnection = new SqliteConnection(DbConnection.connectionString)) { firstConnection.Open(); var selectCommand = firstConnection.CreateCommand(); selectCommand.CommandText = @" SELECT * FROM Ram "; SqliteDataReader adr = selectCommand.ExecuteReader(); while (adr.Read()) { MODEL.Ram ram = new MODEL.Ram(); ram.Id = adr.GetInt32(0); ram.Type = adr.GetString(1); ram.Price = adr.GetString(2); rams.Add(ram); } adr.Close(); selectCommand.CommandText = @" SELECT * FROM Hdd "; adr = selectCommand.ExecuteReader(); while (adr.Read()) { MODEL.Hdd hdd = new MODEL.Hdd(); hdd.Id = adr.GetInt32(0); hdd.Type = adr.GetString(1); hdd.Price = adr.GetString(2); hdds.Add(hdd); } adr.Close(); selectCommand.CommandText = @" SELECT * FROM Color "; adr = selectCommand.ExecuteReader(); while (adr.Read()) { MODEL.Color color = new MODEL.Color(); color.Id = adr.GetInt32(0); color.Type = adr.GetString(1); color.Price = adr.GetString(2); colors.Add(color); } } configurationResponse.Rams = rams; configurationResponse.Hdds = hdds; configurationResponse.Colors = colors; } catch (Exception) { } return(await Task.FromResult(configurationResponse)); }