private void InitializeInfo()
        {
            DataTable _paymentterms = Cache.GetCachedTable("paymentterms");

            if (_paymentterms != null)
            {
                DataRow[] _rows = _paymentterms.Select("[PaymentTerm] LIKE '" + _paymentterm.ToSqlValidString(true) + "'");
                if (_rows.Length > 0)
                {
                    DataRow _row = _rows[0];
                    if (!Materia.IsNullOrNothing(_row["PaymentTerm"]))
                    {
                        txtPaymentTerm.Text = _row["PaymentTerm"].ToString();
                    }
                    if (!Materia.IsNullOrNothing(_row["Description"]))
                    {
                        txtDescription.Text = _row["Description"].ToString();
                    }
                    if (!Materia.IsNullOrNothing(_row["Term"]))
                    {
                        cboTerms.SelectedValue = _row["Term"].ToString();
                    }
                    if (VisualBasic.IsNumeric(_row["Days"]))
                    {
                        txtDays.Value = VisualBasic.CInt(_row["Days"]);
                    }
                    if (VisualBasic.IsNumeric(_row["Months"]))
                    {
                        txtMonths.Value = VisualBasic.CInt(_row["Months"]);
                    }
                }
            }
        }
Exemple #2
0
        private void InitializeInfo()
        {
            DataTable _bankmisc = Cache.GetCachedTable("bankmiscellaneous");

            if (_bankmisc != null)
            {
                DataRow[] _rows = _bankmisc.Select("[BankMiscellaneous] LIKE '" + _bankmiscellaneous.ToSqlValidString(true) + "'");
                if (_rows.Length > 0)
                {
                    DataRow _row = _rows[0];
                    if (!Materia.IsNullOrNothing(_row["BankMiscellaneous"]))
                    {
                        txtDescription.Text = _row["BankMiscellaneous"].ToString();
                    }
                    if (VisualBasic.IsNumeric(_row["AccountCode"]))
                    {
                        cboAccount.SelectedValue = _row["AccountCode"];
                    }
                    if (VisualBasic.IsNumeric(_row["Type"]))
                    {
                        cboType.SelectedIndex = VisualBasic.CInt(_row["Type"]);
                    }
                }
            }
        }
        private void trvwModules_AfterNodeSelect(object sender, DevComponents.AdvTree.AdvTreeNodeEventArgs e)
        {
            if (_nodesloading)
            {
                return;
            }
            if (e.Node == null)
            {
                return;
            }
            _selectedsubmodule = SubModule.None;

            if (e.Node.Nodes.Count > 0)
            {
                DisableButtons(); grdRecords.Hide();
                if (lstvwRecords.Redraw)
                {
                    lstvwRecords.BeginUpdate();
                }
                lstvwRecords.ImageList = _images32; lstvwRecords.Show();
                lstvwRecords.ListItems.Clear();

                for (int i = 0; i <= (e.Node.Nodes.Count - 1); i++)
                {
                    ListViewGridItem _item = new ListViewGridItem(e.Node.Nodes[i].Name, e.Node.Nodes[i].Text.Replace(" ", "\n"), e.Node.Nodes[i].Name);
                    _item.Tag = e.Node.Nodes[i].Tag;
                    lstvwRecords.ListItems.Add(_item);
                }

                while (!lstvwRecords.Redraw)
                {
                    lstvwRecords.EndUpdate();
                }
            }
            else
            {
                if (VisualBasic.IsNumeric(e.Node.Tag))
                {
                    if (VisualBasic.CInt(e.Node.Tag) > 0)
                    {
                        try { _selectedsubmodule = (SubModule)e.Node.Tag; }
                        catch { _selectedsubmodule = SubModule.None; }

                        grdRecords.Show(); lstvwRecords.Hide();
                        InitializeDataSource();
                    }
                }
            }
        }
Exemple #4
0
        /// <summary>
        /// Creates a DSN connection using the specified database information.
        /// </summary>
        /// <param name="connectionstring">Database connection string</param>
        /// <returns></returns>
        public static IDbConnection CreateDSN(string connectionstring)
        {
            string _server   = connectionstring.ConnectionStringValue(ConnectionStringSection.Server);
            string _database = connectionstring.ConnectionStringValue(ConnectionStringSection.Database);
            string _uid      = connectionstring.ConnectionStringValue(ConnectionStringSection.UID);
            string _pwd      = connectionstring.ConnectionStringValue(ConnectionStringSection.PWD);
            string _port     = connectionstring.ConnectionStringValue(ConnectionStringSection.Port);

            if (String.IsNullOrEmpty(_port))
            {
                _port = "3306";
            }

            return(CreateDSN(_server, _database, _uid, _pwd, VisualBasic.CInt(_port)));
        }
        private string GetModuleName()
        {
            string    _modulename = "";
            string    _path       = Application.StartupPath + "\\Xml\\modules.xml";
            DataTable _modules    = SCMS.XmlToTable(_path);

            if (_modules != null)
            {
                DataRow[] _rows = _modules.Select("[Id] = " + VisualBasic.CInt(_selectedmodule).ToString());
                if (_rows.Length > 0)
                {
                    _modulename = _rows[0]["Text"].ToString();
                }
                _modules.Dispose(); _modules = null;
                Materia.RefreshAndManageCurrentProcess();
            }

            return(_modulename);
        }
Exemple #6
0
        private void UploadFile(int index)
        {
            _currentuploadsize = 0; FireEventFromWorker(UploadTransitions.FileUploadAttempting);

            UploadFileInfo _file = Uploads[index]; double _size = 0;

            byte[]    _readbytes = new byte[PacketSize]; int _currentpackagesize = 0;
            FileInfo  _fileinfo = new FileInfo(_file.Path); FileStream _filestream = null;
            Stopwatch _speedtimer = new Stopwatch(); Stream _stream = null;
            Int32     _readings = 0; Exception _ex = null; int _packet = PacketSize;

            try { _size = _fileinfo.Length; }
            catch { }

            FtpWebRequest _request = null; FtpWebResponse _response = null;

            try
            {
                string _ftpaddress = Path.GetDirectoryName(Address).ToLower().Replace("ftp:\\", "ftp://").Replace("\\", "/") + "/" + Path.GetFileName(_file.Path);
                _request = (FtpWebRequest)WebRequest.Create(_ftpaddress);
                if (_credential != null)
                {
                    _request.Credentials = _credential;
                }
                _request.KeepAlive     = true; _request.UseBinary = true;
                _request.Method        = WebRequestMethods.Ftp.UploadFile;
                _filestream            = new FileStream(_file.Path, FileMode.Open);
                _request.ContentLength = VisualBasic.CLng(_size); _stream = _request.GetRequestStream();
            }
            catch (Exception ex) { _ex = ex; }

            _currentuploadsize = _size; FireEventFromWorker(UploadTransitions.FileUploadStarted);

            if (_ex != null)
            {
                _uploaderworker.ReportProgress((int)UploadInvokations.FileUploadFailedRaiser, _ex);
            }
            else
            {
                _currentlyuploaded = 0; _currentpackagesize = 0;

                do
                {
                    if (_uploaderworker.CancellationPending)
                    {
                        _filestream.Close(); _stream.Close(); _speedtimer.Stop();
                        if (_response != null)
                        {
                            _response.Close();
                        }
                        return;
                    }

                    _trigger.WaitOne(); _speedtimer.Start();
                    if (_stream == null &&
                        _response != null)
                    {
                        _stream = _response.GetResponseStream();
                    }


                    if (_readbytes.Length < PacketSize)
                    {
                        _packet = _readbytes.Length;
                    }
                    else
                    {
                        _packet = PacketSize;
                    }

                    _currentpackagesize = _filestream.Read(_readbytes, 0, _packet);
                    _currentlyuploaded += _currentpackagesize; _totaluploaded += _currentpackagesize;
                    FireEventFromWorker(UploadTransitions.ProgressChanged);

                    _stream.Write(_readbytes, 0, _currentpackagesize); _readings += 1;

                    if (_readings >= StopWatchCycle)
                    {
                        _uploadspeed = VisualBasic.CInt(_packet * StopWatchCycle * 1000 / (_speedtimer.ElapsedMilliseconds + 1));
                        _speedtimer.Reset(); _readings = 0;
                    }
                } while (_currentpackagesize != 0);

                _stream.Close(); _filestream.Close(); _speedtimer.Stop();
                FireEventFromWorker(UploadTransitions.FileUploadSucceeded);
            }

            FireEventFromWorker(UploadTransitions.FileUploadStopped);
        }
        private void InitializeModules(ModuleGroup modules)
        {
            string    _path  = Application.StartupPath + "\\Xml\\modules.xml";
            DataTable _table = SCMS.XmlToTable(_path);

            if (_table != null)
            {
                DataRow[] _rows = _table.Select("[Group] = " + VisualBasic.CInt(modules).ToString(), "[Order]");
                if (_rows != null)
                {
                    if (_rows.Length > 0)
                    {
                        brModules.Items.Clear();

                        for (int i = 0; i <= (_rows.Length - 1); i++)
                        {
                            DataRow _row        = _rows[i];
                            Image   _image      = (Image)Properties.Resources.Brick.Clone();
                            bool    _begingroup = VisualBasic.CBool(brModules.Items.Count > 0);

                            ButtonItem _button = new ButtonItem("btnModule" + _row["Id"].ToString(), _row["Text"].ToString());
                            _button.ButtonStyle = eButtonStyle.ImageAndText;
                            if (_moduleimages.Images.ContainsKey(_row["ImageKey"].ToString()))
                            {
                                _image = _moduleimages.Images[_row["ImageKey"].ToString()];
                            }
                            _button.Image         = _image; _button.ImageFixedSize = new Size(32, 32);
                            _button.ImagePosition = eImagePosition.Top;
                            _button.Tag           = _row["Id"]; _button.FixedSize = new Size(120, 75);
                            _button.BeginGroup    = _begingroup; _button.Cursor = Cursors.Hand;
                            _button.Click        += new EventHandler(_button_Click);
                            brModules.Items.Add(_button);
                        }

                        _selectedmodulegroup = modules;
                    }
                }

                _table.Dispose(); _table = null;
                Materia.RefreshAndManageCurrentProcess();
            }

            ButtonItem _modulebutton      = null;
            Image      _modulebuttonimage = (Image)Properties.Resources.Brick.Clone();

            switch (modules)
            {
            case ModuleGroup.Operations:
                _modulebutton = new ButtonItem("btnFinance", "Finance");
                if (_moduleimages.Images.ContainsKey("Finance"))
                {
                    _modulebuttonimage = _moduleimages.Images["Finance"];
                }
                _modulebutton.Image = _modulebuttonimage;
                _modulebutton.Tag   = ModuleGroup.Finance;
                break;

            case ModuleGroup.Finance:
                _modulebutton = new ButtonItem("btnOperations", "Operations");
                if (_moduleimages.Images.ContainsKey("Operations"))
                {
                    _modulebuttonimage = _moduleimages.Images["Operations"];
                }
                _modulebutton.Image = _modulebuttonimage;
                _modulebutton.Tag   = ModuleGroup.Operations;
                break;

            default: break;
            }

            if (_modulebutton != null)
            {
                _modulebutton.ButtonStyle    = eButtonStyle.ImageAndText;
                _modulebutton.ImageFixedSize = new Size(32, 32);
                _modulebutton.FixedSize      = new Size(120, 75);
                _modulebutton.ImagePosition  = eImagePosition.Top;
                bool _begingroup = VisualBasic.CBool(brModules.Items.Count > 0);
                _modulebutton.BeginGroup = _begingroup;
                _modulebutton.Click     += new EventHandler(_button_Click);
                _modulebutton.Cursor     = Cursors.Hand;
                brModules.Items.Add(_modulebutton);
            }

            brModules.RecalcSize();
            brModules.Refresh(); brModules.Update();

            Materia.RefreshAndManageCurrentProcess();
        }
        private void InitializeModuleNodes()
        {
            if (!_nodesloading)
            {
                _nodesloading = true;
            }

            trvwModules.BeginUpdate(); trvwModules.Nodes.Clear();
            trvwModules.ImageList = _images16; trvwModules.DragDropEnabled = false;

            DevComponents.AdvTree.Node _scmsnode = new DevComponents.AdvTree.Node();
            _scmsnode.Name       = "SCMS"; _scmsnode.Text = "Supply Chain Management System";
            _scmsnode.Selectable = true; _scmsnode.Enabled = true;
            _scmsnode.ImageKey   = "SCMS"; _scmsnode.Editable = false;

            trvwModules.Nodes.Add(_scmsnode);

            string    _path  = Application.StartupPath + "\\Xml\\nodes.xml";
            DataTable _nodes = SCMS.XmlToTable(_path);

            if (_nodes != null)
            {
                var _query = from _n in _nodes.AsEnumerable()
                             where _n.Field <int>("Module") == VisualBasic.CInt(_selectedmodule)
                             select _n;

                DataTable _modulenodes = null;

                try { _modulenodes = _query.CopyToDataTable(); }
                catch { }

                if (_modulenodes != null)
                {
                    _modulenodes.TableName        = "nodes";
                    _modulenodes.DefaultView.Sort = "[Ordering]";
                    DataTable _viewtable = _modulenodes.DefaultView.ToTable();

                    if (_viewtable.Rows.Count > 0)
                    {
                        for (int i = 0; i <= (_viewtable.Rows.Count - 1); i++)
                        {
                            DataRow _row = _viewtable.Rows[i];
                            DevComponents.AdvTree.Node[] _parentnodes = trvwModules.Nodes.Find(_row["ParentKey"].ToString(), true);
                            if (_parentnodes.Length > 0)
                            {
                                DevComponents.AdvTree.Node _parentnode = _parentnodes[0];
                                DevComponents.AdvTree.Node _childnode  = new DevComponents.AdvTree.Node();
                                _childnode.Name       = _row["NodeKey"].ToString(); _childnode.Text = _row["Text"].ToString();
                                _childnode.ImageKey   = _row["NodeKey"].ToString();
                                _childnode.Editable   = false; _childnode.Enabled = true;
                                _childnode.Selectable = true; _childnode.Tag = _row["SubModuleEnum"];

                                _parentnode.Nodes.Add(_childnode);
                            }
                        }
                    }

                    _viewtable.Dispose(); _viewtable     = null;
                    _modulenodes.Dispose(); _modulenodes = null;
                    _nodes.Dispose(); _nodes             = null;
                    Materia.RefreshAndManageCurrentProcess();
                }
            }

            trvwModules.ExpandAll(); trvwModules.EndUpdate();
            if (_nodesloading)
            {
                _nodesloading = false;
            }

            if (_scmsnode.Nodes.Count > 0)
            {
                DevComponents.AdvTree.Node _selectednode = _scmsnode.Nodes[0];
                trvwModules.SelectedNode = _selectednode;
            }
        }