private void frmDataDownload_Load(object sender, System.EventArgs e) { try { clsISUtilities = new InteractPayroll.clsISUtilities(this, "busDataDownload"); //Local clsISClientUtilities = new clsISClientUtilities(this, "busClientDataDownload"); this.lblCostCentreSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint); this.lblSelectedCostCentreSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint); this.lblCostCentreDelete.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint); object[] objParm = new object[2]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = AppDomain.CurrentDomain.GetData("FromProgramInd").ToString(); pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records_New", objParm); pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); Load_CurrentForm_Records(); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
private void frmFileUpload_Load(object sender, EventArgs e) { try { clsISUtilities = new clsISUtilities(this, "busFileUpload"); clsISClientUtilities = new clsISClientUtilities(this, "busBackupRestoreClientDatabase"); clsCrc32 = new clsCrc32(); this.lblUserSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint); this.lblSelectedUserSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint); this.lblFilesHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint); try { //User For Time Attendance Client (Not Payroll / Time Attendance Internet) miLinkedMenuItem = (ToolStripMenuItem)AppDomain.CurrentDomain.GetData("LinkedMenuItem"); } catch { } pvtDataSet = new DataSet(); object[] objParm = new object[2]; objParm[0] = AppDomain.CurrentDomain.GetData("AccessInd").ToString(); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); byte[] bytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm); pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress); for (int intRow = 0; intRow < pvtDataSet.Tables["User"].Rows.Count; intRow++) { this.dgvUserDataGridView.Rows.Add(pvtDataSet.Tables["User"].Rows[intRow]["USER_ID"].ToString(), pvtDataSet.Tables["User"].Rows[intRow]["SURNAME"].ToString(), pvtDataSet.Tables["User"].Rows[intRow]["FIRSTNAME"].ToString(), pvtDataSet.Tables["User"].Rows[intRow]["USER_NO"].ToString()); if (pvtDataSet.Tables["User"].Rows.Count == 1) { } } pvtblnUserDataGridViewLoaded = true; if (this.dgvUserDataGridView.Rows.Count > 0) { this.Set_DataGridView_SelectedRowIndex(this.dgvUserDataGridView, 0); } } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
public frmReadWriteFile() { InitializeComponent(); clsISUtilities = new clsISUtilities(this, "busPayrollLogon"); this.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Form_Paint); clsISClientUtilities = new InteractPayrollClient.clsISClientUtilities(this, "busClientPayrollLogon"); clsCrc32 = new clsCrc32(); }
public void frmSplashScreen_Load(object sender, System.EventArgs e) { try { AppDomain.CurrentDomain.SetData("KillApp", ""); this.Show(); this.Refresh(); Application.DoEvents(); this.Cursor = Cursors.AppStarting; clsFileDownLoad = new clsFileDownLoad(); pvtDataTable = new DataTable(); //Get File Version and Dates from Current Directories pvtDataTable = clsFileDownLoad.Get_Files_Directories(); clsISUtilities = null; clsISUtilities = new clsISUtilities(this, "busPayrollLogon"); pvtDataSet = new DataSet(); //Local Database clsISClientUtilities = new clsISClientUtilities(this, "busClientPayrollLogon"); #if (DEBUG) //this.txtUserId.Text = "JOHNNYH"; //this.txtPassword.Text = "JESUS*01"; this.txtUserId.Text = "Interact"; this.txtPassword.Text = "tcaretni"; //this.txtUserId.Text = "gary"; //this.txtPassword.Text = "garylr"; //this.txtUserId.Text = "errol"; //this.txtPassword.Text = "errol"; #endif this.txtUserId.Enabled = true; this.txtPassword.Enabled = true; this.btnOK.Enabled = true; this.txtUserId.Focus(); #if (DEBUG) SendKeys.Send("{ENTER}"); #endif this.Cursor = Cursors.Default; } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); this.Close(); } }
private void btnTest_Click(object sender, EventArgs e) { try { double dblTest = 0; if (double.TryParse(this.txtIP1.Text, out dblTest) == false | double.TryParse(this.txtIP2.Text, out dblTest) == false | double.TryParse(this.txtIP3.Text, out dblTest) == false | double.TryParse(this.txtIP4.Text, out dblTest) == false | double.TryParse(this.txtPortNumber.Text, out dblTest) == false) { CustomClientMessageBox.Show("Setup a Valid IP / Port Number.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { clsISClientUtilities = null; clsISClientUtilities = new clsISClientUtilities(this, "busTimeAttendanceLogon"); int intReturnCode = clsISClientUtilities.WebService_Ping_Test(); if (intReturnCode == 0) { CustomClientMessageBox.Show("Communication Successful.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //Form with Unsuccessful would show } } } catch (Exception eException) { } }
static void Main(string[] args) { try { if (args.Length == 0) { pvtblnFromWindowsService = false; } if (pvtblnFromWindowsService == false) { Console.WriteLine("Entered ValiditeClockingsSyncViaDB"); } Check_Log_For_Archiving(); string strConfig = AppDomain.CurrentDomain.BaseDirectory + "URLClientConfig.txt"; FileInfo fiFileInfo = new FileInfo(strConfig); if (fiFileInfo.Exists == true) { StreamReader srStreamReader = File.OpenText(strConfig); string strURLPath = srStreamReader.ReadLine(); srStreamReader.Close(); AppDomain.CurrentDomain.SetData("URLClientPath", strURLPath); } else { AppDomain.CurrentDomain.SetData("URLClientPath", ""); } clsISClientUtilities = new clsISClientUtilities(null, "busValiditeClockingsSyncViaDB"); pvtDataSet = new DataSet(); object[] objParm = new object[1]; objParm[0] = "Hullo"; byte[] bytCompress = (byte[])clsISClientUtilities.DynamicFunction("Insert_Records", objParm, false); pvtDataSet = clsISClientUtilities.DeCompress_Array_To_DataSet(bytCompress); if (pvtDataSet.Tables["LinksMissing"].Rows.Count > 0) { if (pvtblnFromWindowsService == false) { Console.WriteLine("EMPLOYEES NOT LINKED START*********"); } WriteLog("EMPLOYEES NOT LINKED START*********"); for (int intCount = 0; intCount < pvtDataSet.Tables["LinksMissing"].Rows.Count; intCount++) { if (pvtblnFromWindowsService == false) { Console.WriteLine("Employee " + pvtDataSet.Tables["LinksMissing"].Rows[intCount]["EMPLOYEE_NO"].ToString()); } WriteLog("Employee " + pvtDataSet.Tables["LinksMissing"].Rows[intCount]["EMPLOYEE_NO"].ToString()); } if (pvtblnFromWindowsService == false) { Console.WriteLine("EMPLOYEES NOT LINKED END*********"); } WriteLog("EMPLOYEES NOT LINKED END*********"); } if (pvtblnFromWindowsService == false) { Console.WriteLine("Number of Records Inserted = " + pvtDataSet.Tables["Clockings"].Rows.Count); } WriteLog("Number of Records Inserted = " + pvtDataSet.Tables["Clockings"].Rows.Count); if (pvtblnFromWindowsService == false) { Console.WriteLine("Exit ValiditeClockingsSyncViaDB"); } } catch (Exception ex) { string strException = ex.Message; if (ex.InnerException != null) { strException = strException + " " + ex.InnerException.Message; } if (pvtblnFromWindowsService == false) { Console.WriteLine("Exception = " + strException); } WriteExceptionLog("ClockingsService", ex); } finally { if (pvtblnFromWindowsService == false) { Console.ReadLine(); } } }
public void frmSplashScreen_Load(object sender, System.EventArgs e) { try { AppDomain.CurrentDomain.SetData("KillApp", ""); this.Show(); this.Refresh(); Application.DoEvents(); this.Focus(); this.Cursor = Cursors.AppStarting; clsFileDownLoad = new clsFileDownLoad(); pvtDataTable = new DataTable(); //Get File Version and Dates from Current Directories pvtDataTable = clsFileDownLoad.Get_Files_Directories(); pvtDataSet = new DataSet(); //Local Database clsISClientUtilities = new clsISClientUtilities(this, "busClientPayrollLogon"); //try //{ // //Try to Get DB Up (LocalDB) // object[] objParm = null; // clsISClientUtilities.DynamicFunction("Logon_Client_DataBase", objParm, false); //} //catch (Exception ex) //{ //} #if (DEBUG) //this.txtUserId.Text = "HelenaLR"; //this.txtPassword.Text = "monster"; this.txtUserId.Text = "Interact"; this.txtPassword.Text = "tcaretni"; //this.txtUserId.Text = "migs"; //this.txtPassword.Text = "migs"; //this.txtUserId.Text = "CasperB"; //this.txtPassword.Text = "DRIKKIE69"; //this.txtUserId.Text = "johnnyh"; //this.txtPassword.Text = "jesus*01"; //this.txtUserId.Text = "henk"; //this.txtPassword.Text = "henk"; //this.txtUserId.Text = "gary"; //this.txtPassword.Text = "garylr"; //this.txtUserId.Text = "errol"; //this.txtPassword.Text = "errol"; #endif this.txtUserId.Enabled = true; this.txtPassword.Enabled = true; this.btnOK.Enabled = true; this.btnConnection.Enabled = true; this.txtUserId.Focus(); #if (DEBUG) btnOK_Click(sender, e); #endif this.Cursor = Cursors.Default; this.Focus(); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); this.Close(); } }
private void frmDataUpload_Load(object sender, System.EventArgs e) { try { //Move Group Boxes Over each Other this.grbNoDateOpen.Top = this.grbRunTimeAttendance.Top; clsISUtilities = new clsISUtilities(this, "busDataUpload"); //Local clsISClientUtilities = new clsISClientUtilities(this, "busClientDataUpload"); if (AppDomain.CurrentDomain.GetData("AccessInd").ToString() == "U") { this.lblResetTimeAttendanceMenu.Visible = false; this.lblOpenPayrollMenu.Visible = false; } //Get Pay Categories on Local Mahine pvtDataSetClient = new DataSet(); object[] objParm = new object[1]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); blnclsISClientUtilities = true; pvtbytCompress = (byte[])this.clsISClientUtilities.DynamicFunction("Get_New_Company_Records", objParm, false); pvtDataSetClient = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); this.lblCostCentreSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint); this.lblPayrollTypeSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint); NoPayrollDateOpenDataGridViewCellStyle = new DataGridViewCellStyle(); NoPayrollDateOpenDataGridViewCellStyle.BackColor = Color.Red; NoPayrollDateOpenDataGridViewCellStyle.SelectionBackColor = Color.Red; RunTimeAttendancePendingDataGridViewCellStyle = new DataGridViewCellStyle(); RunTimeAttendancePendingDataGridViewCellStyle.BackColor = Color.Lime; RunTimeAttendancePendingDataGridViewCellStyle.SelectionBackColor = Color.Lime; RunTimeAttendanceAlreadyRunDataGridViewCellStyle = new DataGridViewCellStyle(); RunTimeAttendanceAlreadyRunDataGridViewCellStyle.BackColor = Color.Orange; RunTimeAttendanceAlreadyRunDataGridViewCellStyle.SelectionBackColor = Color.Orange; objParm = new object[2]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = AppDomain.CurrentDomain.GetData("FromProgramInd").ToString(); blnclsISClientUtilities = false; pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records_New", objParm); pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); string strPayrollType = ""; if (this.pvtDataSet.Tables["PayrollType"].Rows.Count > 0) { for (int intRow = 0; intRow < this.pvtDataSet.Tables["PayrollType"].Rows.Count; intRow++) { this.dgvPayrollTypeDataGridView.Rows.Add("", this.pvtDataSet.Tables["PayrollType"].Rows[intRow]["PAYROLL_TYPE"].ToString()); strPayrollType = this.pvtDataSet.Tables["PayrollType"].Rows[intRow]["PAYROLL_TYPE"].ToString().Substring(0, 1); pvtPayCategoryDataView = null; pvtPayCategoryDataView = new DataView(pvtDataSet.Tables["PayCategory"], "COMPANY_NO = " + AppDomain.CurrentDomain.GetData("CompanyNo").ToString() + "AND PAY_CATEGORY_TYPE = '" + strPayrollType + "'", "", DataViewRowState.CurrentRows); if (pvtPayCategoryDataView.Count == 0) { this.dgvPayrollTypeDataGridView[0, intRow].Style = this.NoPayrollDateOpenDataGridViewCellStyle; } else { switch (strPayrollType) { case "W": if (this.pvtDataSet.Tables["Company"].Rows[0]["WAGE_RUN_IND"].ToString() == "N") { this.dgvPayrollTypeDataGridView[0, intRow].Style = this.RunTimeAttendancePendingDataGridViewCellStyle; } else { this.dgvPayrollTypeDataGridView[0, intRow].Style = this.RunTimeAttendanceAlreadyRunDataGridViewCellStyle; } break; case "S": if (this.pvtDataSet.Tables["Company"].Rows[0]["SALARY_RUN_IND"].ToString() == "Y") { this.dgvPayrollTypeDataGridView[0, intRow].Style = this.RunTimeAttendancePendingDataGridViewCellStyle; } else { this.dgvPayrollTypeDataGridView[0, intRow].Style = this.RunTimeAttendanceAlreadyRunDataGridViewCellStyle; } break; case "T": if (this.pvtDataSet.Tables["Company"].Rows[0]["TIME_ATTENDANCE_RUN_IND"].ToString() == "N") { this.dgvPayrollTypeDataGridView[0, intRow].Style = this.RunTimeAttendancePendingDataGridViewCellStyle; } else { this.dgvPayrollTypeDataGridView[0, intRow].Style = this.RunTimeAttendanceAlreadyRunDataGridViewCellStyle; } break; } } } pvtblnPayrollTypeDataGridViewLoaded = true; this.Set_DataGridView_SelectedRowIndex(dgvPayrollTypeDataGridView, 0); } } catch (Exception eException) { if (blnclsISClientUtilities == true) { clsISClientUtilities.ErrorHandler(eException); } else { clsISUtilities.ErrorHandler(eException); } } }