//=============================================================================== 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()); } }
//=============================================================================== 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; }
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(); }
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); }
//=============================================================================== public void extractListOfTableNames(clsMain.clsMain main) { Thread t = new Thread(ExtractTableNames); // Kick off a new thread t.Start(main); }
//=============================================================================== 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); }
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; } }