public static bool AddPickup(RSReportsDataset.PickupTableRow pickup) { // bool added = false; RSReportsServiceClient client = new RSReportsServiceClient(); try { Pickup p = new Pickup(); p.RouteDate = !pickup.IsRt_DateNull() ? pickup.Rt_Date : DateTime.MinValue; p.Driver = !pickup.IsDriverNull() ? pickup.Driver : ""; p.RouteName = !pickup.IsRt_NameNull() ? pickup.Rt_Name : ""; p.ReturnTime = !pickup.IsRetnTimeNull() ? pickup.RetnTime : (short)0; p.CustomerID = !pickup.IsCustomer_IDNull() ? pickup.Customer_ID : ""; p.CustomerName = !pickup.IsCustomerNameNull() ? pickup.CustomerName : ""; p.CustomerType = !pickup.IsCustTypeNull() ? pickup.CustType : ""; p.CustomerAddress = !pickup.IsAddressNull() ? pickup.Address : ""; p.CustomerCity = !pickup.IsCityNull() ? pickup.City : ""; p.CustomerState = !pickup.IsStateNull() ? pickup.State : ""; p.CustomerZip = !pickup.IsZipNull() ? pickup.Zip : ""; p.OrderID = !pickup.IsOrderIDNull() ? pickup.OrderID : ""; p.ActualOrderSize = !pickup.IsActOrdSizeNull() ? pickup.ActOrdSize : 0; p.ActualOrderWeight = !pickup.IsActOrdLbsNull() ? pickup.ActOrdLbs : 0; p.UnscheduledPickup = !pickup.IsUnsched_PUNull() ? pickup.Unsched_PU : ""; p.Comments = !pickup.IsCommentsNull() ? pickup.Comments : ""; p.OrderType = !pickup.IsOrdTypNull() ? pickup.OrdTyp : ""; p.ActualCommodity = !pickup.IsActCmdtyNull() ? pickup.ActCmdty : ""; p.Depot = !pickup.IsDepotNull() ? pickup.Depot : ""; added = client.AddPickup(p); client.Close(); } catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); } catch (FaultException <RoadshowFault> rfe) { client.Abort(); throw new ApplicationException(rfe.Detail.Message); } catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); } catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); } return(added); }