Exemple #1
0
 //===============================================================================
 public void evaluateDataTable(clsMain.clsMain main, string Tablename)
 {
     main.DataTableToExtract = Tablename;
     ExtractDataTable(main);
     Thread t = new Thread(ExtractDataTable);   // Kick off a new thread
     t.Start(main);
 }
        internal void userAccessLoad(SqlConnection Conn,clsMain.clsMain Main,clsTable.clsTable clsTable,string usr,string Environment)
        {
            listBox1.Enabled = false;
            listBox2.Enabled = false;
            listBox3.Enabled = false;
            BaseConn = Conn;
            Base = Main;
            TB = clsTable;
            strUserid = usr;
            strEnvironment = Environment;

            DataTable userids = Base.SelectUserAccess(Base.BaseConnectionString);

            lstNames = TB.loadDistinctValuesFromColumn(userids, "USERID");

            foreach (string s in lstNames)
            {
                if (s != strUserid)
                {
                    comboBox1.Items.Add(s.ToString().Trim());
                }
            }

            //Fill listbox LEVEL1 with distict values
            DataTable level1 = Base.SelectUserAccess(Base.BaseConnectionString);

            lstNames = TB.loadDistinctValuesFromColumn(userids, "LEVEL1");

            foreach (string s in lstNames)
            {
                listBox1.Items.Add(s.ToString().Trim());
            }
        }
Exemple #3
0
        //===============================================================================
        public void copyFormulas(clsMain.clsMain main)
        {
            //A threat that will copy the formulas if not exist on Analysis.
            Thread t = new Thread(extractFormulas);   // Kick off a new thread
            t.Start(main);

            // main.CopyFormulas();
        }
        private void frmLogin_FormClosing(object sender, FormClosingEventArgs e)
        {
            clsForm = null;
            clsProc = null;
            clsM    = null;

            //ParentForm.Dispose();
            FM = null;
        }
Exemple #5
0
        private void frmPassChange_FormClosing(object sender, FormClosingEventArgs e)
        {
            int index = Common.Classes.clsMain.fncFindOpenFormIndex(this);

            uTab.Tabs.RemoveAt(index);
            Common.Classes.clsMain.fncExistOpenForm(this, "Remove");

            clsM = null;
            FM   = null;
            this.Dispose();
        }
Exemple #6
0
        private void frmUserPermissionTransfer_FormClosing(object sender, FormClosingEventArgs e)
        {
            int index = Common.Classes.clsMain.fncFindOpenFormIndex(this);

            uTab.Tabs.RemoveAt(index);
            Common.Classes.clsMain.fncExistOpenForm(this, "Remove");

            clsProc   = null;
            clsM      = null;
            dsList    = null;
            dsDetails = null;
            FM        = null;
        }
 private void extractPrimaryKeys(clsMain.clsMain main)
 {
     //A threat is started to extract the primary keys of selected tables.
     //The primary keys are stored in clsMain.
     //When the user select one of the selected tables tab on the front-end,
     //the list are passed from clsMain into the primary keys list.
     //No extracts are done from the databases and that makes the audit table fast.
     //ExtractKeys(Base);
     Thread t = new Thread(ExtractKeys);   // Kick off a new thread
     t.Start(main);
 }
Exemple #8
0
 //===============================================================================
 public void extractListOfTableNames(clsMain.clsMain main)
 {
     Thread t = new Thread(ExtractTableNames);   // Kick off a new thread
     t.Start(main);
 }
Exemple #9
0
 //===============================================================================
 public void createViews(clsMain.clsMain main)
 {
     //A threat is started to extract views on calculated tables.
     Thread t = new Thread(ExtractViews);   // Kick off a new thread
     t.Start(main);
 }
        private void txtUrl_KeyUp(object sender, KeyEventArgs e)
        {
            if (txtUrl.Text.Contains(Environment.NewLine))
            {
                txtUrl.Text = txtUrl.Text.Replace(Environment.NewLine, "");
                txtUrl.SelectionStart = txtUrl.Text.Length;
            }

            if (e.KeyCode == Keys.Enter && (txtUrl.Text == "" || !txtUrl.Text.Contains("www.youtube.com/watch?")))
            {
                CleanUp();
                lblStatus.Text = "Please enter a vaild url";
                txtUrl.Text = "";
                txtUrl_LostFocus(this, new EventArgs());
                this.Focus();
                return;
            }

            if (e.KeyCode == Keys.Enter)
            {
                txtUrl.Enabled = false;
                string strTextTmp = txtUrl.Text;
                CleanUp();
                picVideoPic.Focus();
                picVideoPic.Image = Properties.Resources.Loading;
                txtUrl.Text = strTextTmp;
                clsDownload = new clsMain(txtUrl.Text);
                clsDownload.Progress += new clsMain.ProgressEventHandler(clsDownload_Progress);
                clsDownload.DownloadLinksDone += new clsMain.ProgressEventHandler(clsDownload_DownloadLinksDone);
                clsDownload.VideoInfoReceived += new clsMain.VideoInfoEventHandler(clsDownload_VideoInfoReceived);
                clsDownload.Error += new clsMain.ErrorHandler(clsDownload_Error);
                clsDownload.Start();
            }
        }
        void clsDownload_VideoInfoReceived(clsMain.VideoInfoEventArgs VideoInfo)
        {
            SetTextHandler sth = new SetTextHandler(SetText);
            strCurrentVideoTitle = VideoInfo.strTitle;
            object[] text = { txtInfo, "[AUTHOR YOUTUBE CHANNEL:]" + Environment.NewLine + VideoInfo.strAuthor + Environment.NewLine + Environment.NewLine + "[VIDEO VIEWS:]" + Environment.NewLine + VideoInfo.strViews + Environment.NewLine + Environment.NewLine + "[LIKES:]" + Environment.NewLine + VideoInfo.strLikes + Environment.NewLine + Environment.NewLine + "[DISLIKES:]" + Environment.NewLine + VideoInfo.strDislikes + Environment.NewLine + Environment.NewLine + "[VIDEO DURATION:]" + Environment.NewLine + VideoInfo.strLength };
            txtInfo.Invoke(sth, text);
            SetImageHandler si = new SetImageHandler(SetImage);
            //object[] objLoading = { picVideoPic,Properties.Resources.Loading };
            //picVideoPic.Invoke(si, objLoading);

            object[] objImage = { picVideoPic, VideoInfo.strPic };
            picVideoPic.Invoke(si, objImage);
            SetControlPos scp = new SetControlPos(SetConPos);
            object[] objScroll = { lblScroll, pnlScroll.Left };
            lblScroll.Invoke(scp, objScroll);
            object[] strTitle = { lblScroll, VideoInfo.strTitle };
            lblScroll.Invoke(sth, strTitle);
        }
 void clsDownload_Progress(clsMain.ProgressEventArgs Status)
 {
     SetTextHandler sth = new SetTextHandler(SetText);
     if (Status.Status == "Donwload links done")
     {
         EnDisableControlHandler edch = new EnDisableControlHandler(EnDisableControl);
         object[] objState = { txtUrl, true };
         txtUrl.Invoke(edch, objState);
         object[] objLinks = { lblStatus, "Done (" + Status.strDownloadLinks.Count.ToString() + " download links found)" };
         lblStatus.Invoke(sth, objLinks);
     }
     else
     {
         object[] objStatus = { lblStatus, Status.Status };
         lblStatus.Invoke(sth, objStatus);
     }
 }
        void clsDownload_DownloadLinksDone(clsMain.ProgressEventArgs Status)
        {
            string DownloadLinks = "";
            SetTextHandler sth = new SetTextHandler(SetText);
            ComboBoxAddItemhandler cbaih = new ComboBoxAddItemhandler(ComboBoxAddItem);
            for (int i = 0; i < Status.strDownloadLinks.Count; i++)
            {
                //object[] objCombo = {cbDownOpt, Status.strDownloadLinks[i]};
                object[] objCombo = { cbDownOpt, Status.strQuality[i] + " ( " + Status.strType[i] + " ) [" + Status.strSize[i] + " ]" };
                cbDownOpt.Invoke(cbaih, objCombo);
                DownloadLinks += Status.strDownloadLinks[i] + "\t\t" + Status.strQuality[i] + "\t\t" + Status.strType[i] + Environment.NewLine + Environment.NewLine; //+ "\t\t\t"  +Status.strQuality[i] + Status.strType[i] + Environment.NewLine + Environment.NewLine;

                strDownloadLinks.Add(new LinkInfo());
                LinkInfo liTmp = strDownloadLinks[i];
                liTmp.strVideoTitle = strCurrentVideoTitle;
                liTmp.strVideoSize = Status.strSize[i];
                liTmp.strVideoType = Status.strType[i];
                liTmp.strQuality = Status.strQuality[i];
                liTmp.strVideoLink = Status.strDownloadLinks[i];
                strDownloadLinks[i] = liTmp;

            }
            EnDisableControlHandler edch = new EnDisableControlHandler(EnDisableControl);
            object[] objEnable = { cbDownOpt, true };
            cbDownOpt.Invoke(edch, objEnable);
        }
Exemple #14
0
        internal void PayrollSendLoad(SqlConnection myConn, SqlConnection BConn, clsBL.clsBL classBL, clsTable.clsTable classTable, clsTableFormulas classTableFormulas, clsMain.clsMain Main, string section)
        {
            if (section == "MANUAL")
            {

                globalSection = section;
                Base = Main;
                TBFormulas = classTableFormulas;
                TB = classTable;
                BusinessLanguage = classBL;

                tstConn = myConn;
                BaseConn = BConn;

                txtBussUnit.Text = BusinessLanguage.BussUnit + " - " + BusinessLanguage.Region;
                txtBussUnit.Enabled = false;
                cboPayrollGroup.Text = TB.TBName.Trim();

                DateTime today = DateTime.Today;
                strDay = strDay.Substring(0, 2 - today.Day.ToString().Trim().Length) + today.Day.ToString().Trim();
                strMonth = strMonth.Substring(0, 2 - today.Month.ToString().Trim().Length) + today.Month.ToString().Trim();

                cboMiningType.Text = BusinessLanguage.MiningType;

                cboBonusType.Text = BusinessLanguage.BonusType;  //amp
                cboSection.Text = globalSection;
                earnCode = TB.createDataTableWithAdapterSelectAll(Base.DBConnectionString, "EARNINGSCODES", " Where Tablename = 'MANUALPAY'"); //amp
                List<string> employeeType = TB.loadDistinctValuesFromColumn(earnCode, "EMPLOYEETYPE");

                foreach (string s in employeeType)
                {
                    cboEmployeeType.Items.Add(s.ToString().Trim());
                }

                txtPeriod.Text = Base.Period;
                cboPayRollInd.Enabled = false;
                cboEarningsCode.Enabled = false;
                cboMiningType.Enabled = false;
                cboBonusType.Enabled = false;
                cboSection.Enabled = false;
                btnGenerate.Visible = false;

            }
            else
            {
                btnManual.Visible = false;
                globalSection = section;
                Base = Main;
                TBFormulas = classTableFormulas;
                TB = classTable;
                BusinessLanguage = classBL;

                tstConn = myConn;
                BaseConn = BConn;

                txtBussUnit.Text = BusinessLanguage.BussUnit + " - " + BusinessLanguage.Region;
                txtBussUnit.Enabled = false;
                cboPayrollGroup.Text = TB.TBName.Trim();

                DateTime today = DateTime.Today;
                strDay = strDay.Substring(0, 2 - today.Day.ToString().Trim().Length) + today.Day.ToString().Trim();
                strMonth = strMonth.Substring(0, 2 - today.Month.ToString().Trim().Length) + today.Month.ToString().Trim();

                cboMiningType.Text = BusinessLanguage.MiningType;

                cboBonusType.Text = BusinessLanguage.BonusType;

                cboSection.Text = globalSection;

                //dt = Base.GetDataByRegion(BusinessLanguage.Region, Base.DBConnectionString);
                earnCode = TB.createDataTableWithAdapterSelectAll(Base.DBConnectionString, "EARNINGSCODES", "Where Tablename != 'MANUALPAY'");
                List<string> employeeType = TB.loadDistinctValuesFromColumn(earnCode, "EMPLOYEETYPE");

                foreach (string s in employeeType)
                {
                    cboEmployeeType.Items.Add(s.ToString().Trim());
                }

                txtPeriod.Text = Base.Period;
                cboPayRollInd.Enabled = false;
                cboEarningsCode.Enabled = false;
                cboMiningType.Enabled = false;
                cboBonusType.Enabled = false;
                cboSection.Enabled = false;

            }
        }