Exemplo n.º 1
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            try
            {
                DialogResult dlgResult = CustomMessageBox.Show("Are you sure you want to Delete this File?",
                                                               this.Text,
                                                               MessageBoxButtons.YesNo,
                                                               MessageBoxIcon.Warning);

                if (dlgResult == DialogResult.Yes)
                {
                    object[] objParm = new object[3];
                    objParm[0] = pvtintUserNo;
                    objParm[1] = pvtstrFileUploadDatetime;
                    objParm[2] = pvtstrFileName;

                    clsISUtilities.DynamicFunction("Delete_Record", objParm);

                    this.pvtUserFileDataview[pvtintUserFileDataGridViewRowIndex].Delete();

                    this.pvtDataSet.AcceptChanges();

                    this.Set_DataGridView_SelectedRowIndex(this.dgvUserDataGridView, this.Get_DataGridView_SelectedRowIndex(this.dgvUserDataGridView));
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 2
0
        private void btnFile_Click(object sender, EventArgs e)
        {
            try
            {
                OpenFileDialog dialog = new OpenFileDialog();
                dialog.Filter = "All files (*.*)|*.*";
                dialog.Title  = "Select a File to Upload.";

                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    this.txtFilePath.Text = dialog.FileName;

                    pvtstrFileName = dialog.SafeFileName;

                    this.btnUpload.Enabled = true;
                }
                else
                {
                    this.txtFilePath.Text = "";
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 3
0
        private void rbnSelectedEmployees_Click(object sender, EventArgs e)
        {
            try
            {
                if (rbnSelectedEmployees.Checked == true
                    & this.dgvPayPeriodDataGridView.Rows.Count > 0)
                {
                    this.grbEmployeeSelection.Enabled = true;

                    this.Clear_DataGridView(this.dgvPayCategoryDataGridView);

                    this.Clear_DataGridView(this.dgvEmployeeDataGridView);
                    this.Clear_DataGridView(this.dgvChosenEmployeeDataGridView);

                    pvtblnPayCategoryDataGridViewLoaded = false;

                    pvtPayCategoryDataView = null;
                    pvtPayCategoryDataView = new DataView(this.pvtDataSet.Tables["PayCategory"],
                                                          "COMPANY_NO = " + Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")) + " AND PAY_CATEGORY_TYPE = '" + pvtstrPayrollType + "'",
                                                          "PAY_CATEGORY_DESC",
                                                          DataViewRowState.CurrentRows);

                    for (int intRow = 0; intRow < pvtPayCategoryDataView.Count; intRow++)
                    {
                        this.dgvPayCategoryDataGridView.Rows.Add(pvtPayCategoryDataView[intRow]["PAY_CATEGORY_DESC"].ToString(),
                                                                 pvtPayCategoryDataView[intRow]["PAY_CATEGORY_NO"].ToString());
                    }

                    pvtblnPayCategoryDataGridViewLoaded = true;

                    if (this.dgvPayCategoryDataGridView.Rows.Count > 0)
                    {
                        this.Set_DataGridView_SelectedRowIndex(this.dgvPayCategoryDataGridView, 0);
                    }

                    this.btnAdd.Enabled       = true;
                    this.btnAddAll.Enabled    = true;
                    this.btnRemove.Enabled    = true;
                    this.btnRemoveAll.Enabled = true;

                    this.tabControl.SelectedIndex = 0;
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
        private void frmConvertEmployeeType_Load(object sender, EventArgs e)
        {
            try
            {
                clsISUtilities = new clsISUtilities(this, "busConvertEmployeeType");

                this.lblEmployee.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblCostCentreSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblPayrollType.Paint           += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblPayCategoryDesc.Paint       += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblPayCategorySelectDesc.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblNormalLeave.Paint           += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblNormalLeaveSelected.Paint   += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                pvtDataSet = new DataSet();

                object[] objParm = new object[1];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));

                byte[] bytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress);

                Load_CurrentForm_Records();
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
        private void frmResetEmployeeTakeOn_Load(object sender, EventArgs e)
        {
            try
            {
                this.pvtint64CompanyNo = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));

                clsISUtilities = new clsISUtilities(this, "busResetEmployeeTakeOn");

                this.lblPayrollType.Paint    += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblPayCategory.Paint    += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblEmployee.Paint       += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblChosenEmployee.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                object[] objParm = new object[1];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));

                pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm);
                pvtDataSet     = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress);

                this.dgvPayrollTypeDataGridView.Rows.Add("Wages");
                this.dgvPayrollTypeDataGridView.Rows.Add("Salaries");
                this.dgvPayrollTypeDataGridView.Rows.Add("Time Attendance");

                this.pvtblnPayrollTypeDataGridViewLoaded = true;

                this.Set_DataGridView_SelectedRowIndex(this.dgvPayrollTypeDataGridView, 0);
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 6
0
        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);
            }
        }
Exemplo n.º 7
0
        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)
                {
                    CustomMessageBox.Show("Setup a Valid IP Number.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return;
                }
                else
                {
                    object[] obj = null;

                    string strOk = (string)clsISUtilities.DynamicFunction("Ping", obj);

                    if (strOk == "OK")
                    {
                        CustomMessageBox.Show("Communication Successful.", "Communication", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            catch (Exception ex)
            {
                clsISUtilities.ErrorHandler(ex);
            }
        }
        private void frmTimeAttendanceCompany_Load(object sender, System.EventArgs e)
        {
            try
            {
                PayrollLinkDataGridViewCellStyle                    = new DataGridViewCellStyle();
                PayrollLinkDataGridViewCellStyle.BackColor          = Color.Magenta;
                PayrollLinkDataGridViewCellStyle.SelectionBackColor = Color.Magenta;

                clsISUtilities = new clsISUtilities(this, "busCompany");

                this.lblCompanySpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                pvtDataSet = new DataSet();

                object[] objParm = new object[2];
                objParm[0] = AppDomain.CurrentDomain.GetData("AccessInd").ToString();
                objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo"));

                pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress);

                Set_Form_For_Read();
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 9
0
        private void frmPublicHoliday_Load(object sender, System.EventArgs e)
        {
            try
            {
                clsISUtilities = new clsISUtilities(this, "busPublicHoliday");

                if (AppDomain.CurrentDomain.GetData("AccessInd").ToString() == "S")
                {
                    this.btnAll.Visible = true;
                }

                this.lblDescription.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();

                byte[] bytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress);

                this.dgvPublicHolidayDataGridView.Columns[0].HeaderText = "Date (" + AppDomain.CurrentDomain.GetData("DateFormat").ToString() + ")";

                Load_CurrentForm_Records();

                Set_Form_For_Read();
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 10
0
        private void frmFileDownload_Load(object sender, EventArgs e)
        {
            try
            {
                clsISUtilities = new clsISUtilities(this, "busFileDownload");
                clsCrc32       = new clsCrc32();

                this.lblUserSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblFileDesc.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();

                if (AppDomain.CurrentDomain.GetData("AccessInd").ToString() != "S")
                {
                    this.btnDelete.Visible = false;
                    this.btnClose.Top      = this.btnDelete.Top;
                    this.grbToUser.Visible = false;
                }

                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());
                }

                pvtblnUserDataGridViewLoaded = true;

                if (this.dgvUserDataGridView.Rows.Count > 0)
                {
                    this.Set_DataGridView_SelectedRowIndex(this.dgvUserDataGridView, 0);
                }
                else
                {
                    CustomMessageBox.Show("There are No Files to Download.", "File Download", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 11
0
        public void btnSave_Click(object sender, System.EventArgs e)
        {
            try
            {
                int intDataViewRow = 0;

                for (int intRow = 0; intRow < pvtEmployeeDataView.Count; intRow++)
                {
                    intDataViewRow = Convert.ToInt32(this.dgvEmployeesDataGridView[7, intRow].Value);

                    if (Convert.ToDouble(this.dgvEmployeesDataGridView[4, intRow].Value) == Convert.ToDouble(pvtEmployeeDataView[intDataViewRow]["PREV_NORMAL_LEAVE_DAYS"])
                        & Convert.ToDouble(this.dgvEmployeesDataGridView[5, intRow].Value) == Convert.ToDouble(pvtEmployeeDataView[intDataViewRow]["NORMAL_LEAVE_DAYS"])
                        & Convert.ToDouble(this.dgvEmployeesDataGridView[6, intRow].Value) == Convert.ToDouble(pvtEmployeeDataView[intDataViewRow]["SICK_LEAVE_DAYS"]))
                    {
                        continue;
                    }

                    pvtEmployeeDataView[intDataViewRow]["PREV_NORMAL_LEAVE_DAYS"] = Math.Round(Convert.ToDouble(this.dgvEmployeesDataGridView[4, intRow].Value), 2);
                    pvtEmployeeDataView[intDataViewRow]["NORMAL_LEAVE_DAYS"]      = Math.Round(Convert.ToDouble(this.dgvEmployeesDataGridView[5, intRow].Value), 2);
                    pvtEmployeeDataView[intDataViewRow]["SICK_LEAVE_DAYS"]        = Math.Round(Convert.ToDouble(this.dgvEmployeesDataGridView[6, intRow].Value), 2);
                }

                pvtTempDataSet = null;
                pvtTempDataSet = new DataSet();

                DataTable myDataTable = this.pvtDataSet.Tables["Employee"].Clone();
                pvtTempDataSet.Tables.Add(myDataTable);

                if (pvtEmployeeDataView != null)
                {
                    for (int intRow = 0; intRow < pvtEmployeeDataView.Count; intRow++)
                    {
                        if (pvtEmployeeDataView[intRow].Row.RowState == DataRowState.Modified)
                        {
                            pvtTempDataSet.Tables["Employee"].ImportRow(pvtEmployeeDataView[intRow].Row);
                        }
                    }
                }

                if (pvtTempDataSet.Tables["Employee"].Rows.Count > 0)
                {
                    //Compress DataSet
                    pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet);

                    object[] objParm = new object[2];
                    objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
                    objParm[1] = pvtbytCompress;

                    clsISUtilities.DynamicFunction("Update_Record", objParm);
                }

                this.pvtDataSet.AcceptChanges();

                btnCancel_Click(sender, e);
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 12
0
        private void frmEmployeeLeaveTakeOn_Load(object sender, System.EventArgs e)
        {
            try
            {
                clsISUtilities = new clsISUtilities(this, "busEmployeeLeaveTakeOn");

                this.lblPayrollType.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblEmployee.Paint    += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblNormalLeave.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblSickLeave.Paint   += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                object[] objParm = new object[1];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));

                pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress);

                for (int intRow = 0; intRow < pvtDataSet.Tables["PayrollType"].Rows.Count; intRow++)
                {
                    this.dgvPayrollTypeDataGridView.Rows.Add(pvtDataSet.Tables["PayrollType"].Rows[intRow]["PAYROLL_TYPE_DESC"].ToString());
                }

                pvtblnPayrollTypeDataGridViewLoaded = true;

                if (pvtDataSet.Tables["PayrollType"].Rows.Count > 0)
                {
                    this.Set_DataGridView_SelectedRowIndex(dgvPayrollTypeDataGridView, 0);
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
        private void frmUserMenuAccess_Load(object sender, System.EventArgs e)
        {
            try
            {
                //This Must Replace TreeView First Row (Happens When GUI is Changed)
                //AAEAAAD/////AQAAAAAAAAAMAgAAAFdTeXN0ZW0uV2luZG93cy5Gb3JtcywgVmVyc2lvbj0yLjAuMC4w

                clsISUtilities = new clsISUtilities(this, "busUserMenuAccess");

                this.lblUserSpreadsheetHeader.Paint          += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblCompanySpreadsheetHeader.Paint       += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblMenuStructureSpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblMenuAccessSpreadsheetHeader.Paint    += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                Build_Menu_Structure();

                pvtDataSet = new DataSet();

                object[] objParm = new object[3];
                objParm[0] = AppDomain.CurrentDomain.GetData("FromProgramInd").ToString();
                objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo"));
                objParm[2] = AppDomain.CurrentDomain.GetData("AccessInd").ToString();

                pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Users", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress);

                Load_Users();
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 14
0
        private void frmCalender_Load(object sender, System.EventArgs e)
        {
            try
            {
                clsISUtilities = new clsISUtilities(this, "busCalender");

                object[] objParm = new object[1];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));

                byte[] pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress);

                for (int intYear = 2007; intYear < DateTime.Now.Year + 2; intYear++)
                {
                    this.cboYear.Items.Add(intYear.ToString());
                }

                for (int intRow = 0; intRow < 6; intRow++)
                {
                    this.dgvCalenderDataGridView.Rows.Add("",
                                                          "",
                                                          "",
                                                          "",
                                                          "",
                                                          "",
                                                          "",
                                                          "",
                                                          "");
                }

                pvtblnCalenderDataGridViewLoaded = true;

                this.btnToday.Text = DateTime.Now.ToString(pvtstrDateFormat);

                SatSunDataGridViewCellStyle                    = new DataGridViewCellStyle();
                SatSunDataGridViewCellStyle.ForeColor          = Color.Navy;
                SatSunDataGridViewCellStyle.SelectionForeColor = Color.Navy;

                PublicHolidayDataGridViewCellStyle                    = new DataGridViewCellStyle();
                PublicHolidayDataGridViewCellStyle.ForeColor          = Color.Red;
                PublicHolidayDataGridViewCellStyle.SelectionForeColor = Color.Red;

                NormalDataGridViewCellStyle                    = new DataGridViewCellStyle();
                NormalDataGridViewCellStyle.ForeColor          = Color.Black;
                NormalDataGridViewCellStyle.SelectionForeColor = Color.Black;

                LightDataGridViewCellStyle                    = new DataGridViewCellStyle();
                LightDataGridViewCellStyle.ForeColor          = Color.Gray;
                LightDataGridViewCellStyle.SelectionForeColor = Color.Gray;

                Set_Date(DateTime.Now.ToString(pvtstrDateFormat));
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 15
0
        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);
            }
        }
        private void rbnEmployeeSelected_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                if (rbnEmployeeSelected.Checked == true)
                {
                    pvtblnPayCategoryDataGridViewLoaded = false;

                    this.Clear_DataGridView(this.dgvPayCategoryDataGridView);
                    this.Clear_DataGridView(this.dgvEmployeeDataGridView);
                    this.Clear_DataGridView(this.dgvChosenEmployeeDataGridView);

                    this.btnEmployeeAdd.Enabled       = true;
                    this.btnEmployeeAddAll.Enabled    = true;
                    this.btnEmployeeRemoveAll.Enabled = true;
                    this.btnEmployeeRemove.Enabled    = true;

                    this.grbEmployeeSelection.Enabled = true;
                    this.rbnByPayCategory.Checked     = true;

                    for (int intIndex = 0; intIndex < pvtPayCategoryDataView.Count; intIndex++)
                    {
                        this.dgvPayCategoryDataGridView.Rows.Add(pvtPayCategoryDataView[intIndex]["PAY_CATEGORY_DESC"].ToString(),
                                                                 pvtPayCategoryDataView[intIndex]["PAY_CATEGORY_NO"].ToString());
                    }

                    pvtblnPayCategoryDataGridViewLoaded = true;

                    if (this.dgvPayCategoryDataGridView.Rows.Count > 0)
                    {
                        this.Set_DataGridView_SelectedRowIndex(this.dgvPayCategoryDataGridView, 0);
                    }

                    this.tabControl.SelectedIndex = 0;
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 17
0
        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();
            }
        }
Exemplo n.º 18
0
 private void frmEmployeeRecover_Load(object sender, EventArgs e)
 {
     try
     {
         clsISUtilities         = new clsISUtilities();
         clsDBConnectionObjects = new InteractPayroll.clsDBConnectionObjects();
     }
     catch (Exception eException)
     {
         clsISUtilities.ErrorHandler(eException);
     }
 }
Exemplo n.º 19
0
        private void Load_CurrentForm_Records()
        {
            try
            {
                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);

                this.Clear_DataGridView(this.dgvUserDataGridView);

                pvtblnUserDataGridViewLoaded = false;

                for (int intRowCount = 0; intRowCount < this.pvtDataSet.Tables["User"].Rows.Count; intRowCount++)
                {
                    this.dgvUserDataGridView.Rows.Add(this.pvtDataSet.Tables["User"].Rows[intRowCount]["USER_ID"].ToString(),
                                                      this.pvtDataSet.Tables["User"].Rows[intRowCount]["SURNAME"].ToString(),
                                                      this.pvtDataSet.Tables["User"].Rows[intRowCount]["FIRSTNAME"].ToString(),
                                                      this.pvtDataSet.Tables["User"].Rows[intRowCount]["USER_NO"].ToString());
                }

                pvtblnUserDataGridViewLoaded = true;

                if (this.dgvUserDataGridView.Rows.Count > 0)
                {
                    this.Set_DataGridView_SelectedRowIndex(this.dgvUserDataGridView, 0);
                }
                else
                {
                    this.btnOK.Enabled = false;
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                DataSet tempDataSet = new DataSet();

                tempDataSet.Tables.Add(pvtDataSet.Tables["Earning"].Clone());

                pvtEarningDataView = null;
                pvtEarningDataView = new DataView(this.pvtDataSet.Tables["Earning"],
                                                  "PAY_CATEGORY_NO = " + pvtintPayCategoryNo + " AND EMPLOYEE_NO = " + this.pvtintEmployeeNo,
                                                  "",
                                                  DataViewRowState.Added | DataViewRowState.ModifiedCurrent);

                for (int intRow = 0; intRow < pvtEarningDataView.Count; intRow++)
                {
                    tempDataSet.Tables["Earning"].ImportRow(pvtEarningDataView[intRow].Row);
                }

                tempDataSet.Tables.Add(pvtDataSet.Tables["Deduction"].Clone());

                pvtEarningDataView = null;
                pvtEarningDataView = new DataView(this.pvtDataSet.Tables["Deduction"],
                                                  "EMPLOYEE_NO = " + this.pvtintEmployeeNo,
                                                  "",
                                                  DataViewRowState.Added | DataViewRowState.ModifiedCurrent);

                for (int intRow = 0; intRow < pvtEarningDataView.Count; intRow++)
                {
                    tempDataSet.Tables["Deduction"].ImportRow(pvtEarningDataView[intRow].Row);
                }

                byte[] bytCompress = clsISUtilities.Compress_DataSet(tempDataSet);

                object[] objParm = new object[5];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
                objParm[1] = pvtintPayCategoryNo;
                objParm[2] = pvtstrNormPaidPerPeriod;
                objParm[3] = pvtstrSickPaidPerPeriod;
                objParm[4] = bytCompress;

                clsISUtilities.DynamicFunction("Update_Employee_Earnings_Deductions", objParm);

                this.pvtDataSet.AcceptChanges();

                btnCancel_Click(null, e);
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 21
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                DataSet TempDataSet = new DataSet();

                TempDataSet.Tables.Add(this.pvtDataSet.Tables["EtiEmployeeSave"].Clone());

                for (int intRow = 0; intRow < this.dgvEmployeeDataGridView.Rows.Count; intRow++)
                {
                    DataRow DataRow = TempDataSet.Tables["EtiEmployeeSave"].NewRow();

                    DataRow["EMPLOYEE_NO"]    = Convert.ToInt32(this.dgvEmployeeDataGridView[EmployeeNoCol, intRow].Value);
                    DataRow["ETI_MONTH"]      = Convert.ToInt32(this.dgvEmployeeDataGridView[EmployeeEtiMonthCol, intRow].Value);
                    DataRow["TOTAL_HOURS"]    = Convert.ToDecimal(this.dgvEmployeeDataGridView[EmployeeTotalHoursCol, intRow].Value);
                    DataRow["FACTOR"]         = Convert.ToDecimal(this.dgvEmployeeDataGridView[EmployeeFactorCol, intRow].Value);
                    DataRow["TOTAL_EARNINGS"] = Convert.ToDecimal(this.dgvEmployeeDataGridView[EmployeeTotalAmountCol, intRow].Value);
                    DataRow["ETI_EARNINGS"]   = Convert.ToDecimal(this.dgvEmployeeDataGridView[EmployeeEtiAmountCol, intRow].Value);
                    DataRow["ETI_VALUE"]      = Convert.ToDecimal(this.dgvEmployeeDataGridView[EmployeeEtiCalculatedCol, intRow].Value);

                    TempDataSet.Tables["EtiEmployeeSave"].Rows.Add(DataRow);
                }

                byte[] pvtbytCompress = clsISUtilities.Compress_DataSet(TempDataSet);

                object[] objParm = new object[5];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
                objParm[1] = AppDomain.CurrentDomain.GetData("AccessInd").ToString();
                objParm[2] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo"));
                objParm[3] = Convert.ToDateTime(this.pvtDataSet.Tables["EtiRunDate"].Rows[intSelectedRowIndex]["ETI_RUN_DATE"]).ToString("yyyy-MM-dd");
                objParm[4] = pvtbytCompress;

                byte[] bytCompress = (byte[])clsISUtilities.DynamicFunction("Insert_Eti_Records", objParm, true);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress);

                cboEtiRunDate.Items.Clear();
                this.dgvEmployeeDataGridView.Rows.Clear();
                this.dgvEmployeeExcludedDataGridView.Rows.Clear();

                for (int intRow = 0; intRow < this.pvtDataSet.Tables["EtiRunDate"].Rows.Count; intRow++)
                {
                    cboEtiRunDate.Items.Add(Convert.ToDateTime(this.pvtDataSet.Tables["EtiRunDate"].Rows[intRow]["ETI_RUN_DATE"]).ToString("MMMM yyyy"));
                }

                this.btnSave.Enabled = false;
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 22
0
        private void frmLeaveType_Load(object sender, System.EventArgs e)
        {
            try
            {
                clsISUtilities = new clsISUtilities(this, "busLeaveType");

                this.lblLeaveType.Paint   += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblPayrollType.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                PayrollLinkDataGridViewCellStyle                    = new DataGridViewCellStyle();
                PayrollLinkDataGridViewCellStyle.BackColor          = Color.Magenta;
                PayrollLinkDataGridViewCellStyle.SelectionBackColor = Color.Magenta;

                this.dgvPayrollTypeDataGridView.Rows.Add("Wages");
                this.dgvPayrollTypeDataGridView.Rows.Add("Salaries");

                this.pvtblnPayrollTypeDataGridViewLoaded = true;

                this.Set_DataGridView_SelectedRowIndex(this.dgvPayrollTypeDataGridView, 0);

                object[] objParm = new object[1];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));

                byte[] bytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress);

                DataRow dtDataRow;

                //Table
                DataTable DataTable = new DataTable("PERCENT_PAID");
                DataTable.Columns.Add("PERCENT_PAID_VALUE", typeof(System.Int16));
                pvtDataSet.Tables.Add(DataTable);

                for (int intValue = 1; intValue < 101; intValue++)
                {
                    dtDataRow = pvtDataSet.Tables["PERCENT_PAID"].NewRow();
                    dtDataRow["PERCENT_PAID_VALUE"] = intValue;
                    pvtDataSet.Tables["PERCENT_PAID"].Rows.Add(dtDataRow);
                }

                pvtDataSet.AcceptChanges();

                clsISUtilities.DataBind_ComboBox_Load(this.cboPercentage, pvtDataSet.Tables["PERCENT_PAID"], "PERCENT_PAID_VALUE", "PERCENT_PAID_VALUE");

                Load_CurrentForm_Records();
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 23
0
        public void btnSave_Click(object sender, System.EventArgs e)
        {
            try
            {
                pvtTempDataSet = null;
                pvtTempDataSet = new DataSet();
                DataTable myDataTable;

                myDataTable = this.pvtDataSet.Tables["EmployeeEarning"].Clone();

                pvtTempDataSet.Tables.Add(myDataTable);

                for (int intRow = 0; intRow < pvtEmployeeEarningDataView.Count; intRow++)
                {
                    if (pvtEmployeeEarningDataView[intRow].Row.RowState == DataRowState.Modified)
                    {
                        pvtTempDataSet.Tables["EmployeeEarning"].ImportRow(pvtEmployeeEarningDataView[intRow].Row);
                    }
                }

                myDataTable = this.pvtDataSet.Tables["EmployeeDeduction"].Clone();

                pvtTempDataSet.Tables.Add(myDataTable);

                for (int intRow = 0; intRow < pvtEmployeeDeductionDataView.Count; intRow++)
                {
                    if (pvtEmployeeDeductionDataView[intRow].Row.RowState == DataRowState.Modified)
                    {
                        pvtTempDataSet.Tables["EmployeeDeduction"].ImportRow(pvtEmployeeDeductionDataView[intRow].Row);
                    }
                }

                //Compress DataSet
                pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet);

                object[] objParm = new object[3];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
                objParm[1] = pvtbytCompress;
                objParm[2] = this.dgvPayrollTypeDataGridView[0, this.Get_DataGridView_SelectedRowIndex(dgvPayrollTypeDataGridView)].Value.ToString().Substring(0, 1);

                clsISUtilities.DynamicFunction("Update_Records", objParm, true);

                this.pvtDataSet.AcceptChanges();

                btnCancel_Click(null, null);
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 24
0
        private void btnOK_Click(object sender, System.EventArgs e)
        {
            try
            {
                if (this.txtPassword1.Text.Trim().ToUpper() == this.txtPassword2.Text.Trim().ToUpper())
                {
                    if (this.txtPassword1.Text.Trim() == "")
                    {
                        CustomMessageBox.Show("Enter Passwords", this.Text,
                                              MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

                        this.txtPassword1.Focus();
                        return;
                    }
                }
                else
                {
                    CustomMessageBox.Show("Passwords are NOT the same", this.Text,
                                          MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

                    this.txtPassword1.Focus();
                    return;
                }

                DialogResult dlgResult = CustomMessageBox.Show("Are you sure you want to Change your Password?",
                                                               this.Text,
                                                               MessageBoxButtons.YesNo,
                                                               MessageBoxIcon.Question);

                if (dlgResult == DialogResult.Yes)
                {
                    string strPassword        = this.txtPassword1.Text.Trim().ToUpper();
                    Int64  int64CurrentUserNo = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo"));

                    object[] objParm = new object[2];
                    objParm[0] = int64CurrentUserNo;
                    objParm[1] = strPassword;

                    clsISUtilities.DynamicFunction("Update_Password", objParm, true);

                    AppDomain.CurrentDomain.SetData("PasswordChanged", "Y");
                    AppDomain.CurrentDomain.SetData("NewPassword", strPassword);

                    this.Close();
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
        private void pbxHorzPage1_Click(object sender, System.EventArgs e)
        {
            try
            {
                object[] objParm = new object[6];
                objParm[0] = pvtint64CompanyNo;
                objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo"));
                objParm[2] = 1;
                objParm[3] = pvtintNumberHorizontalPages;
                objParm[4] = pvtstrEmployeePrintOrder;
                objParm[5] = pvtblnByPayCategoryParameter;

                pvtbyteCompress = (byte[])clsISUtilities.DynamicFunction("Print_Horizontal_SpreadSheet_Page", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbyteCompress);

                //Company DataTable
                DataTable myCompanyDataTable = pvtTempDataSet.Tables["Company"].Copy();

                pvtDataSet.Tables.Add(myCompanyDataTable);

                //CompanyHeaderDetails DataTable
                DataTable myCompanyHeaderDetailsDataTable = pvtTempDataSet.Tables["CompanyHeaderDetails"].Copy();

                pvtDataSet.Tables.Add(myCompanyHeaderDetailsDataTable);

                frmRptEarningsDeductionsSpreadSheet           = new frmRptEarningsDeductionsSpreadSheet(this, pvtDataSet, pvtblnConsolidate, pvtblnByPayCategoryParameter, 1, pvtintNumberHorizontalPages, pvtstrReportHeader, pvtstrEmployeePrintOrder, "S");
                frmRptEarningsDeductionsSpreadSheet.MdiParent = this.MdiParent;
                frmRptEarningsDeductionsSpreadSheet.Text      = this.Text;
                frmRptEarningsDeductionsSpreadSheet.Show();

                this.Hide();
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
        private void frmEmployeeActivateSelection_Load(object sender, System.EventArgs e)
        {
            try
            {
                Pen3Pixels = new Pen(Color.Black, 3);
                Pen1Pixel  = new Pen(Color.Black, 1);

                clsISUtilities = new clsISUtilities(this, "busEmployeeActivateSelection");

                this.lblPayrollType.Paint    += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblEmployee.Paint       += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblChosenEmployee.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                clsISUtilities.Create_Calender_Control_From_TextBox(this.txtDate);

                clsISUtilities.NotDataBound_Date_TextBox(txtDate, "Capture Tax Effective Date.");
                clsISUtilities.NotDataBound_ComboBox(this.cboRunDate, "Select Tax Effective Date.");

                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", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress);

                pvtSalaryDateDataView = null;
                pvtSalaryDateDataView = new DataView(pvtDataSet.Tables["SalaryPrevDate"],
                                                     "COMPANY_NO = " + Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")),
                                                     "",
                                                     DataViewRowState.CurrentRows);

                for (int intRow = 0; intRow < pvtDataSet.Tables["PayrollType"].Rows.Count; intRow++)
                {
                    this.dgvPayrollTypeDataGridView.Rows.Add(pvtDataSet.Tables["PayrollType"].Rows[intRow]["PAYROLL_TYPE_DESC"].ToString());
                }

                pvtblnPayrollTypeDataGridViewLoaded = true;

                if (dgvPayrollTypeDataGridView.Rows.Count > 0)
                {
                    this.Set_DataGridView_SelectedRowIndex(dgvPayrollTypeDataGridView, 0);
                    dgvPayrollTypeDataGridView.Refresh();
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 27
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            try
            {
                object[] objParm = new object[4];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
                objParm[1] = pvtstrPayrollType;
                objParm[2] = pvtintPayCategoryNo;
                objParm[3] = pvtintPayCategoryShiftScheduleNo;

                pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Print_Report", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress);

                frmRptRoster = new frmRptRoster(pvtDataSet);

                frmRptRoster.ShowDialog();
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 28
0
        private void btnTestConnection_Click(object sender, EventArgs e)
        {
            try
            {
                string strNewURL = "";
#if (DEBUG)
#else
                strNewURL = this.txtIP1.Text + "." + this.txtIP2.Text + "." + this.txtIP3.Text + "." + this.txtIP4.Text;
#endif
                AppDomain.CurrentDomain.SetData("URLPath", strNewURL);

                clsISUtilities = null;
                clsISUtilities = new clsISUtilities(null, "busPayrollLogon");

                clsISUtilities.Set_WebService_Timeout_Value(15000);

                string strOk = (string)clsISUtilities.DynamicFunction("Ping", null);

                if (strOk == "OK")
                {
                    MessageBox.Show("Communication Successful.", "Communication", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    clsISUtilities = null;
                    clsISUtilities = new clsISUtilities(null, "busEmployeeRecover");

                    this.btnRunFix.Enabled = true;
                }
                else
                {
                    this.btnRunFix.Enabled = true;
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 29
0
        private void frmPassword_Load(object sender, System.EventArgs e)
        {
            try
            {
                clsISUtilities = new clsISUtilities(this, "busPasswordReset");

                this.lblUser.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                Load_CurrentForm_Records();
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }
Exemplo n.º 30
0
        private void frmEtiRun_Load(object sender, EventArgs e)
        {
            try
            {
                clsISUtilities = new clsISUtilities(this, "busEtiRun");

                EarnsTooMuchDataGridViewCellStyle                    = new DataGridViewCellStyle();
                EarnsTooMuchDataGridViewCellStyle.BackColor          = Color.Coral;
                EarnsTooMuchDataGridViewCellStyle.SelectionBackColor = Color.Coral;

                BeyondPeriodDataGridViewCellStyle                    = new DataGridViewCellStyle();
                BeyondPeriodDataGridViewCellStyle.BackColor          = Color.MediumTurquoise;
                BeyondPeriodDataGridViewCellStyle.SelectionBackColor = Color.MediumTurquoise;

                YoungerThanEighteenDataGridViewCellStyle                    = new DataGridViewCellStyle();
                YoungerThanEighteenDataGridViewCellStyle.BackColor          = Color.Lime;
                YoungerThanEighteenDataGridViewCellStyle.SelectionBackColor = Color.Lime;

                OlderThanThirtyDataGridViewCellStyle                    = new DataGridViewCellStyle();
                OlderThanThirtyDataGridViewCellStyle.BackColor          = Color.Plum;
                OlderThanThirtyDataGridViewCellStyle.SelectionBackColor = Color.Plum;

                this.lblEmployee.Paint         += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);
                this.lblEmployeeExcluded.Paint += new System.Windows.Forms.PaintEventHandler(clsISUtilities.Label_Paint);

                object[] objParm = new object[3];
                objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
                objParm[1] = AppDomain.CurrentDomain.GetData("AccessInd").ToString();
                objParm[2] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo"));

                byte[] bytCompress = (byte[])clsISUtilities.DynamicFunction("Get_Form_Records", objParm);

                pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress);

                this.lblEarnAmount.Text = "Earns More than R" + Convert.ToDecimal(this.pvtDataSet.Tables["EtiMaxAmount"].Rows[0]["MAX_ETI_AMOUNT"]).ToString("#####0.00");

                for (int intRow = 0; intRow < this.pvtDataSet.Tables["EtiRunDate"].Rows.Count; intRow++)
                {
                    cboEtiRunDate.Items.Add(Convert.ToDateTime(this.pvtDataSet.Tables["EtiRunDate"].Rows[intRow]["ETI_RUN_DATE"]).ToString("MMMM yyyy"));
                }
            }
            catch (Exception eException)
            {
                clsISUtilities.ErrorHandler(eException);
            }
        }