Ejemplo n.º 1
0
        public static EnterpriseDataset TrackCartonsForStoreByPickupDate(string clientID, string store, DateTime fromDate, DateTime toDate, string vendorID)
        {
            //
            EnterpriseDataset cartons = new EnterpriseDataset();
            CRMServiceClient  client  = new CRMServiceClient();

            try {
                DataSet ds = null;
                if (store.Trim().Length > 0)
                {
                    ds = client.TrackCartonsForStoreByPickupDate(clientID, store, fromDate, toDate, vendorID);
                }
                client.Close();

                if (ds != null && ds.Tables["CartonDetailForStoreTable"] != null && ds.Tables["CartonDetailForStoreTable"].Rows.Count > 0)
                {
                    cartons.Merge(ds, true, MissingSchemaAction.Ignore);
                }
            }
            catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); }
            catch (FaultException <TrackingFault> tfe) { client.Abort(); throw new ApplicationException(tfe.Detail.Message); }
            catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); }
            catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); }
            return(cartons);
        }
Ejemplo n.º 2
0
        private void OnTrack(object sender, EventArgs e)
        {
            //
            this.Cursor = Cursors.WaitCursor;
            try {
                this.mTLs.Clear();
                this.mCartons.Clear();
                this.mDetail = new EnterpriseDataset();
                if (!this.DesignMode)
                {
                    //DataSet ds = Argix.Enterprise.EnterpriseGateway.TrackCartonsForStoreByDeliveryDate(this.cboClient.SelectedValue.ToString(),this.mskStoreNumber.Text,this.dtpFrom.Value,this.dtpTo.Value,null);
                    if (this.cboDateType.Text == "Delivery")
                    {
                        this.mDetail.Merge(Argix.Enterprise.EnterpriseGateway.TrackCartonsForStoreByDeliveryDate(this.cboClient.SelectedValue.ToString(), this.mskStoreNumber.Text, this.dtpFrom.Value, this.dtpTo.Value, null));
                    }
                    else
                    {
                        this.mDetail.Merge(Argix.Enterprise.EnterpriseGateway.TrackCartonsForStoreByPickupDate(this.cboClient.SelectedValue.ToString(), this.mskStoreNumber.Text, this.dtpFrom.Value, this.dtpTo.Value, null));
                    }

                    EnterpriseDataset summary = new EnterpriseDataset();
                    summary.Merge(this.mDetail.CartonDetailForStoreTable.DefaultView.ToTable(true, new string[] { "TL" }));
                    foreach (EnterpriseDataset.CartonDetailForStoreTableRow row in summary.CartonDetailForStoreTable.Rows)
                    {
                        row.CartonCount = this.mDetail.CartonDetailForStoreTable.Select("TL='" + row.TL + "'").Length;
                        row.Weight      = int.Parse(this.mDetail.CartonDetailForStoreTable.Compute("Sum(weight)", "TL='" + row.TL + "'").ToString());
                        object minDate = this.mDetail.CartonDetailForStoreTable.Compute("Min(PodDate)", "TL='" + row.TL + "' AND (IsNull(PodDate,#01/01/1900#) <> #01/01/1900#)");

                        EnterpriseDataset.CartonDetailForStoreTableRow row0 = (EnterpriseDataset.CartonDetailForStoreTableRow)(this.mDetail.CartonDetailForStoreTable.Select("TL='" + row.TL + "'"))[0];
                        if (minDate != System.DBNull.Value)
                        {
                            row.PodDate = DateTime.Parse(minDate.ToString());
                        }
                        else
                        {
                            if (!row0.IsOFD1Null())
                            {
                                row.OFD1 = row0.OFD1;
                            }
                        }
                        row.Zone   = row0.Zone;
                        row.Store  = row0.Store;
                        row.CBOL   = row0.IsCBOLNull() ? "" : row0.CBOL;
                        row.AG     = !row0.IsAGNull() ? row0.AG : "";
                        row.AgName = row0.Trf == "N" ? row0.AgName : row0.AgName + " (Transfer)";
                        row.AcceptChanges();
                    }
                    this.mTLs.Merge(summary);
                }
            }
            catch (Exception ex) { App.ReportError(new ApplicationException(ex.Message)); }
            finally { this.Cursor = Cursors.Default; }
        }
Ejemplo n.º 3
0
        public static EnterpriseDataset GetClients(string vendorID)
        {
            //
            EnterpriseDataset clients = new EnterpriseDataset();
            CRMServiceClient  client  = new CRMServiceClient();

            try {
                DataSet ds = client.GetClients(vendorID);
                client.Close();

                if (ds.Tables["ClientTable"] != null && ds.Tables["ClientTable"].Rows.Count > 0)
                {
                    clients.Merge(ds);
                }
            }
            catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); }
            catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); }
            catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); }
            return(clients);
        }
Ejemplo n.º 4
0
 public Argix.Enterprise.Terminals GetTerminals()
 {
     //Returns a list of terminals
     Argix.Enterprise.Terminals terminals = null;
     try {
         terminals = new Argix.Enterprise.Terminals();
         DataSet ds = new TLViewerGateway().GetTerminals();
         if (ds != null)
         {
             EnterpriseDataset tDS = new EnterpriseDataset();
             tDS.Merge(ds);
             for (int i = 0; i < tDS.TerminalTable.Rows.Count; i++)
             {
                 Argix.Enterprise.Terminal terminal = new Argix.Enterprise.Terminal(tDS.TerminalTable[i]);
                 terminals.Add(terminal);
             }
         }
     }
     catch (Exception ex) { throw new ApplicationException(ex.Message, ex); }
     return(terminals);
 }