protected async Task <Adapters.Oal.dbo_consignment_initial> SearchConsignmentInitialAsync(string consignmentNo) { var adapter = new Adapters.Oal.dbo_consignment_initialAdapter(); var query = $"SELECT [dt_created_date_field] FROM [dbo].[consignment_initial] WHERE [number] = '{consignmentNo}'"; Adapters.Oal.dbo_consignment_initial consignmentInitial = null; using (var conn = new System.Data.SqlClient.SqlConnection(adapter.ConnectionString)) using (var cmd = new System.Data.SqlClient.SqlCommand(query, conn)) { await conn.OpenAsync(); using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { consignmentInitial = new Adapters.Oal.dbo_consignment_initial { dt_created_date_field = reader["dt_created_date_field"].ReadNullable <DateTime>() }; } } } return(consignmentInitial); }
protected async Task <Adapters.Oal.dbo_consignment_initial> SearchConsignmentInitialAsync(string consignmentNo) { var adapter = new Adapters.Oal.dbo_consignment_initialAdapter(); var query = $"SELECT [weight_double], [item_category], [shipper_address_country] FROM [dbo].[consignment_initial] WHERE [number] = '{consignmentNo}'"; Adapters.Oal.dbo_consignment_initial consignment = null; using (var conn = new System.Data.SqlClient.SqlConnection(adapter.ConnectionString)) using (var cmd = new System.Data.SqlClient.SqlCommand(query, conn)) { await conn.OpenAsync(); using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { consignment = new Adapters.Oal.dbo_consignment_initial { weight_double = reader["weight_double"].ReadNullable <double>(), item_category = reader["item_category"].ReadNullableString(), shipper_address_country = reader["shipper_address_country"].ReadNullableString() }; } } } return(consignment); }