public Response <DataSet> GetWXPOD(WXPODRequest wx)
{
Response <DataSet> response = new Response <DataSet>();
if (wx == null)
{
ArgumentNullException ex = new ArgumentNullException("GetWXPOD request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
int RowCount = 0;
response.Result = new WXPODServiceAccessor().GetWXPOD(wx);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public DataSet GetWXPOD(WXPODRequest wx)
{
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(connStr))
{
try
{
SqlCommand cmd = new SqlCommand("proc_Pod_Select", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustomerName", wx.Customer);
cmd.Parameters[0].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[0].Size = 50;
cmd.Parameters.AddWithValue("@PODTypeName", wx.PodType);
cmd.Parameters[1].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[1].Size = 50;
cmd.Parameters.AddWithValue("@ShipperTypeName", wx.ShipperType);
cmd.Parameters[2].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[2].Size = 50;
cmd.Parameters.AddWithValue("@StartCityName", wx.txtStart);
cmd.Parameters[3].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[3].Size = 50;
cmd.Parameters.AddWithValue("@EndCityName", wx.txtEnd);
cmd.Parameters[4].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[4].Size = 50;
cmd.Parameters.AddWithValue("@ActualDeliveryDate", wx.datetimes);
cmd.Parameters[5].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[5].Size = 100;
cmd.Parameters.AddWithValue("@CustomerOrderNumber", wx.st);
cmd.Parameters[6].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[6].Size = 200;
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
conn.Close();
}
catch
{ }
}
return(ds);
}
