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