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