protected void ExportSortedItems(ISDExportDataset sortedItems, string xsltFile, string csvFile) { //UNUSED: This is for an xsl-based approach //XmlTextWriter writer = null; //try { // // // XmlDataDocument xml = new XmlDataDocument(sortedItems); // XslTransform xslt = new XslTransform(); // xslt.Load(xsltFile); // writer = new XmlTextWriter(csvFile,Encoding.ASCII); // xslt.Transform(xml,null,writer,null); //} //catch(Exception ex) { throw new ApplicationException("Unexpected error while exporting sorted items.",ex); } //finally { if(writer != null) writer.Close(); } }
public static ISDExportDataset GetClients(string clientNumber) { ISDExportDataset configuration = null; try { configuration = new ISDExportDataset(); DataSet ds = fillDataset(USP_EXPORTFILECONFIG, TBL_EXPORTFILECONFIG, new object[] { clientNumber }); if (ds != null) { configuration.Merge(ds); } } catch (Exception ex) { throw new ApplicationException("", ex); } return(configuration); }
public static ISDExportDataset GetSortedItems(string pickupID) { //Get sorted items for a pickup ISDExportDataset sortedItems = null; try { sortedItems = new ISDExportDataset(); DataSet ds = fillDataset(USP_SORTEDITEMS, TBL_SORTEDITEMS, new object[] { pickupID }); if (ds != null) { sortedItems.Merge(ds, false, MissingSchemaAction.Ignore); } } catch (Exception ex) { throw ex; } return(sortedItems); }
public static ISDExportDataset GetPickups(DateTime pickupDate) { //Update a collection (dataset) of all pickups for the terminal on the local LAN database ISDExportDataset pickups = null; try { pickups = new ISDExportDataset(); DataSet ds = fillDataset(USP_PICKUPS, TBL_PICKUPS, new object[] { pickupDate }); if (ds != null) { pickups.Merge(ds); } } catch (Exception ex) { throw new ApplicationException("Unexpected error while reading pickups.", ex); } return(pickups); }
public static ISDExportDataset GetPickups(DateTime pickupDate) { // ISDExportDataset pickups = new ISDExportDataset(); ISDExportServiceClient client = new ISDExportServiceClient(); try { DataSet ds = client.GetPickups(int.Parse(Program.TerminalCode), pickupDate); if (ds != null) { pickups.Merge(ds); } client.Close(); } catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); } catch (FaultException <AgentLineHaulFault> afe) { client.Abort(); throw new ApplicationException(afe.Detail.Message); } catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); } catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); } return(pickups); }
public override bool Export(string exportFile, ISDClient isdClient, Pickup pickup, ISDExportDataset sortedItems) { //Exports sorted items dataset to a file specified by the database bool exported = false; StreamWriter writer = null; try { //Validate file is unique if (File.Exists(exportFile)) { throw new Exception("Export file " + exportFile + " already exists. "); } //Create the new file and save sorted items for this pickup to disk writer = new StreamWriter(new FileStream(exportFile, FileMode.Create, FileAccess.ReadWrite)); writer.BaseStream.Seek(0, SeekOrigin.Begin); for (int j = 0; j < sortedItems.SortedItemTable.Rows.Count; j++) { writer.WriteLine(formatSortedItemRecord((ISDExportDataset.SortedItemTableRow)sortedItems.SortedItemTable.Rows[j])); } writer.Flush(); exported = true; } catch (ApplicationException ex) { throw ex; } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } finally { if (writer != null) { writer.Close(); } } return(exported); }
public abstract bool Export(string exportFile, ISDClient isdClient, Pickup pickup, ISDExportDataset sortedItems);