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); } }
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); } }
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); } }
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); } }
public void btnSave_Click(object sender, System.EventArgs e) { try { pvtTempDataSet = null; pvtTempDataSet = new DataSet(); DataTable DataTable = this.pvtDataSet.Tables["Employee"].Clone(); pvtTempDataSet.Tables.Add(DataTable); pvtEmployeeDataView = null; pvtEmployeeDataView = new DataView(pvtDataSet.Tables["Employee"], "PAY_CATEGORY_TYPE = '" + this.dgvPayrollTypeDataGridView[0, this.Get_DataGridView_SelectedRowIndex(dgvPayrollTypeDataGridView)].Value.ToString().Substring(0, 1) + "'", "EMPLOYEE_CODE", DataViewRowState.ModifiedCurrent); for (int intRow = 0; intRow < pvtEmployeeDataView.Count; intRow++) { pvtTempDataSet.Tables["Employee"].ImportRow(pvtEmployeeDataView[intRow].Row); } //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet); object[] objParm = new object[4]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = pvtstrMenuId; objParm[3] = pvtbytCompress; clsISUtilities.DynamicFunction("Update_Employee_Link", objParm, true); this.pvtDataSet.AcceptChanges(); btnCancel_Click(sender, e); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
public void btnSave_Click(object sender, System.EventArgs e) { try { int intReturnCode = clsISUtilities.DataBind_Save_Check(); if (intReturnCode != 0) { return; } pvtTempDataSet = null; pvtTempDataSet = new DataSet(); pvtTempDataSet.Tables.Add(this.pvtDataSet.Tables["Leave"].Clone()); pvtTempDataSet.Tables[0].ImportRow(pvtLeaveDataView[clsISUtilities.DataViewIndex].Row); //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet); if (this.Text.IndexOf(" - New", 0) > 0) { object[] objParm = new object[3]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = pvtbytCompress; pvtintLeaveNo = (int)clsISUtilities.DynamicFunction("Insert_New_Record", objParm, true); pvtLeaveDataView[clsISUtilities.DataViewIndex]["LEAVE_SHIFT_NO"] = pvtintLeaveNo; //Reset From 0 To Null pvtLeaveDataView[clsISUtilities.DataViewIndex]["PAYROLL_LINK"] = System.DBNull.Value; } else { object[] objParm = new object[3]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = pvtbytCompress; pvtintReturnCode = (int)clsISUtilities.DynamicFunction("Update_Record", objParm, true); if (pvtintReturnCode == 9999) { this.pvtDataSet.RejectChanges(); this.dgvNormalSickLeaveCategoryDataGridView[0, this.Get_DataGridView_SelectedRowIndex(dgvNormalSickLeaveCategoryDataGridView)].Style = this.PayrollLinkDataGridViewCellStyle; pvtLeaveDataView[clsISUtilities.DataViewIndex]["PAYROLL_LINK"] = 0; DialogResult dlgResult = CustomMessageBox.Show("This Normal Leave and Sick Leave Category is currently being used in a Payroll Run.\r\n\r\nUpdate Cancelled.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { this.dgvNormalSickLeaveCategoryDataGridView[1, this.Get_DataGridView_SelectedRowIndex(dgvNormalSickLeaveCategoryDataGridView)].Value = this.txtLeave.Text.Trim(); } } this.pvtDataSet.Tables["Leave"].AcceptChanges(); if (this.clsISUtilities.pubintReloadSpreadsheet == true) { Load_CurrentForm_Records(); } else { btnCancel_Click(sender, e); } } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
private void btnSave_Click(object sender, System.EventArgs e) { try { int intReturnCode = Save_Check(); if (intReturnCode != 0) { return; } DataSet TempDataSet = new DataSet(); DataTable myDataTable = this.pvtDataSet.Tables["PaidHoliday"].Clone(); TempDataSet.Tables.Add(myDataTable); pvtDataView = null; pvtDataView = new DataView(this.pvtDataSet.Tables["PaidHoliday"], "", "", DataViewRowState.Added | DataViewRowState.Deleted | DataViewRowState.ModifiedCurrent); for (int intRow = 0; intRow < pvtDataView.Count; intRow++) { if (pvtDataView[intRow]["PUBLIC_HOLIDAY_DESC"].ToString().Trim() == "" & pvtDataView[intRow]["PUBLIC_HOLIDAY_DATE"] == System.DBNull.Value) { continue; } TempDataSet.Tables[0].ImportRow(pvtDataView[intRow].Row); } if (TempDataSet.Tables[0].Rows.Count > 0) { Int64 Int64CompanyNo = 999999; if (this.btnAll.Text == "All") { Int64CompanyNo = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); } byte[] bytCompress = clsISUtilities.Compress_DataSet(TempDataSet); object[] objParm = new object[3]; objParm[0] = Int64CompanyNo; objParm[1] = bytCompress; objParm[2] = AppDomain.CurrentDomain.GetData("FromProgramInd").ToString(); bytCompress = (byte[])clsISUtilities.DynamicFunction("Update_Records", objParm, true); pvtDataSet = null; pvtDataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress); } btnCancel_Click(sender, e); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
private void btnOK_Click(object sender, System.EventArgs e) { try { string strPayCategoryFilterWages = " AND PAY_CATEGORY_NO IN ("; string strPayCategoryFilterSalaries = " AND PAY_CATEGORY_NO IN ("; string strPayCategoryFilterTimeAttendance = " AND PAY_CATEGORY_NO IN ("; string strCostCentresWages = ""; string strCostCentresSalaries = ""; string strCostCentresTimeAttendance = ""; object[] objFind = new object[3]; object[] objParm; if (this.dgvCostCentreChosenDataGridView.Rows.Count == 0) { //Test DialogResult myDialogResult = InteractPayroll.CustomMessageBox.Show("Would you like to DELETE this Company From the Local Database?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (myDialogResult == DialogResult.Yes) { objParm = new object[2]; objParm[0] = pvtint64CompanyNo; objParm[1] = "B"; pvtblnLocalWebService = true; clsISClientUtilities.DynamicFunction("Delete_All_PayCategory_Records_New", objParm, false); //Test InteractPayroll.CustomMessageBox.Show("Delete from Local Database Successful.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Set_DataGridView_SelectedRowIndex(this.dgvCompanyDataGridView, Get_DataGridView_SelectedRowIndex(this.dgvCompanyDataGridView)); } return; } else { for (int intRow = 0; intRow < this.dgvCostCentreChosenDataGridView.Rows.Count; intRow++) { if (dgvCostCentreChosenDataGridView[2, intRow].Value.ToString().Substring(0, 1) == "W") { if (strCostCentresWages == "") { strCostCentresWages = this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); strPayCategoryFilterWages += this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); } else { strCostCentresWages += "|" + this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); strPayCategoryFilterWages += "," + this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); } } else { if (dgvCostCentreChosenDataGridView[2, intRow].Value.ToString().Substring(0, 1) == "S") { if (strCostCentresSalaries == "") { strCostCentresSalaries = this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); strPayCategoryFilterSalaries += this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); } else { strCostCentresSalaries += "|" + this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); strPayCategoryFilterSalaries += "," + this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); } } else { if (strCostCentresTimeAttendance == "") { strCostCentresTimeAttendance = this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); strPayCategoryFilterTimeAttendance += this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); } else { strCostCentresTimeAttendance += "|" + this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); strPayCategoryFilterTimeAttendance += "," + this.dgvCostCentreChosenDataGridView[3, intRow].Value.ToString(); } } } } } if (strPayCategoryFilterWages != " AND PAY_CATEGORY_NO IN (") { strPayCategoryFilterWages += ")"; } else { strPayCategoryFilterWages += "-1)"; } if (strPayCategoryFilterSalaries != " AND PAY_CATEGORY_NO IN (") { strPayCategoryFilterSalaries += ")"; } else { strPayCategoryFilterSalaries += "-1)"; } if (strPayCategoryFilterTimeAttendance != " AND PAY_CATEGORY_NO IN (") { strPayCategoryFilterTimeAttendance += ")"; } else { strPayCategoryFilterTimeAttendance += "-1)"; } objParm = new object[4]; objParm[0] = pvtint64CompanyNo; objParm[1] = strPayCategoryFilterWages; objParm[2] = strPayCategoryFilterSalaries; objParm[3] = strPayCategoryFilterTimeAttendance; pvtblnLocalWebService = true; byte[] bytClientDataSetCompress = (byte[])clsISClientUtilities.DynamicFunction("Check_PayCategory_Records_New", objParm, false); DataSet DataSetClient = clsISUtilities.DeCompress_Array_To_DataSet(bytClientDataSetCompress); if (DataSetClient.Tables["Temp"].Rows.Count > 0) { string strPayCategoryDesc = "Cost Centre\n\n"; string strPayCategoryNoWages = "("; string strPayCategoryNoSalaries = "("; string strPayCategoryNoTimeAttendance = "("; for (int intRow = 0; intRow < DataSetClient.Tables["Temp"].Rows.Count; intRow++) { if (DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_TYPE"].ToString() == "W") { strPayCategoryDesc += DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_DESC"].ToString() + " (Wages)\n"; if (strPayCategoryNoWages == "(") { strPayCategoryNoWages += DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_NO"].ToString(); } else { strPayCategoryNoWages += "," + DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_NO"].ToString(); } } else { if (DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_TYPE"].ToString() == "S") { strPayCategoryDesc += DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_DESC"].ToString() + " (Salaries)\n"; if (strPayCategoryNoSalaries == "(") { strPayCategoryNoSalaries += DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_NO"].ToString(); } else { strPayCategoryNoSalaries += "," + DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_NO"].ToString(); } } else { strPayCategoryDesc += DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_DESC"].ToString() + " (Time Attendance)\n"; if (strPayCategoryNoTimeAttendance == "(") { strPayCategoryNoTimeAttendance += DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_NO"].ToString(); } else { strPayCategoryNoTimeAttendance += "," + DataSetClient.Tables["Temp"].Rows[intRow]["PAY_CATEGORY_NO"].ToString(); } } } } if (strPayCategoryNoWages != "(") { strPayCategoryNoWages += ")"; } else { strPayCategoryNoWages += "-1)"; } if (strPayCategoryNoSalaries != "(") { strPayCategoryNoSalaries += ")"; } else { strPayCategoryNoSalaries += "-1)"; } if (strPayCategoryNoTimeAttendance != "(") { strPayCategoryNoTimeAttendance += ")"; } else { strPayCategoryNoTimeAttendance += "-1)"; } strPayCategoryDesc += "\nExist on Local Database.\n\nClick Yes to Delete this Cost Centre and also Synchronize Selected Cost Centre.\n\nClick No to Synchronize Selected Cost Centre Only."; if (DataSetClient.Tables["Temp"].Rows.Count > 1) { strPayCategoryDesc = strPayCategoryDesc.Replace("Centre", "Centres"); strPayCategoryDesc = strPayCategoryDesc.Replace("this", "these"); } else { strPayCategoryDesc = strPayCategoryDesc.Replace("Exist", "Exists"); } //Leave As Is DialogResult myDialogResult = MessageBox.Show(strPayCategoryDesc, this.Text, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning); if (myDialogResult == System.Windows.Forms.DialogResult.Cancel) { return; } else { if (myDialogResult == System.Windows.Forms.DialogResult.Yes) { objParm = new object[5]; objParm[0] = pvtint64CompanyNo; objParm[1] = strPayCategoryNoWages; objParm[2] = strPayCategoryNoSalaries; objParm[3] = strPayCategoryNoTimeAttendance; objParm[4] = bytClientDataSetCompress; pvtblnLocalWebService = true; this.clsISClientUtilities.DynamicFunction("Delete_Certain_PayCategory_Records_New", objParm, false); } } } else { //Test DialogResult myDialogResult = InteractPayroll.CustomMessageBox.Show("Would you like to Synchronize the Selected Cost Centre/s?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (myDialogResult == System.Windows.Forms.DialogResult.No) { return; } } //get Records from Internet Database objParm = new object[5]; objParm[0] = pvtint64CompanyNo; objParm[1] = strCostCentresWages; objParm[2] = strCostCentresSalaries; objParm[3] = strCostCentresTimeAttendance; //2017-09-28 (Upload Employee Parameters) objParm[4] = bytClientDataSetCompress; pvtblnLocalWebService = false; pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Download_Records_Fix_Parameters", objParm); pvtTempDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); pvtDataSet.Merge(pvtTempDataSet); pvtbytCompress = clsISUtilities.Compress_DataSet(pvtDataSet); //Insert Records Into Client Database objParm = new object[8]; objParm[0] = pvtint64CompanyNo; objParm[1] = strPayCategoryFilterWages; objParm[2] = strPayCategoryFilterSalaries; objParm[3] = strPayCategoryFilterTimeAttendance; objParm[4] = strCostCentresWages; objParm[5] = strCostCentresSalaries; objParm[6] = strCostCentresTimeAttendance; objParm[7] = pvtbytCompress; pvtblnLocalWebService = true; pvtbytCompress = (byte[])this.clsISClientUtilities.DynamicFunction("Download_Records_New", objParm, false); pvtTempDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); if (pvtTempDataSet.Tables["EmployeeFingerPrintTemplateUpload"].Rows.Count > 0 || pvtTempDataSet.Tables["EmployeeFingerPrintTemplateDelete"].Rows.Count > 0 || pvtTempDataSet.Tables["UserFingerPrintTemplateUpload"].Rows.Count > 0 || pvtTempDataSet.Tables["UserFingerPrintTemplateDelete"].Rows.Count > 0 || pvtTempDataSet.Tables["PayCategoryInteractInd"].Rows.Count > 0) { objParm = new object[2]; objParm[0] = pvtint64CompanyNo; objParm[1] = pvtbytCompress; pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Maintain_Templates", objParm); objParm = new object[2]; objParm[0] = pvtint64CompanyNo; objParm[1] = pvtbytCompress; //Update CREATION_DATETIME which comes from Server clsISClientUtilities.DynamicFunction("Maintain_Templates", objParm, false); } //Test InteractPayroll.CustomMessageBox.Show("Synchronization of Databases Successful.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Set_DataGridView_SelectedRowIndex(this.dgvCompanyDataGridView, Get_DataGridView_SelectedRowIndex(this.dgvCompanyDataGridView)); } catch (Exception eException) { if (pvtblnLocalWebService == true) { clsISClientUtilities.ErrorHandler(eException); } else { clsISUtilities.ErrorHandler(eException); } } }
private void btnSave_Click(object sender, EventArgs e) { try { //Tables to Be Moved to Business Layer DataSet TempDataSet = new DataSet(); DataTable myDataTable = this.pvtDataSet.Tables["EmployeeShiftSchedule"].Clone(); //Check Roster for (int intRow = 0; intRow < dgvShiftScheduleDataGridView.Rows.Count; intRow++) { if (this.dgvShiftScheduleDataGridView.Rows[intRow].HeaderCell.Style == ErrorDataGridViewCellStyle) { //Set Cell if (dgvShiftScheduleDataGridView[pvtintNamesCol, intRow].Style.BackColor.ToArgb() == Color.White.ToArgb()) { MessageBox.Show("Background Color is White.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } MessageBox.Show("Error Exists in Roster.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (dgvShiftScheduleDataGridView[this.pvtintFromHHMMCol, intRow].Value.ToString().Trim() != "") { DataRow myDataRow = myDataTable.NewRow(); myDataRow["COMPANY_NO"] = Convert.ToInt32(AppDomain.CurrentDomain.GetData("CompanyNo")); myDataRow["EMPLOYEE_NO"] = dgvShiftScheduleDataGridView[this.pvtintEmployeeNoCol, intRow].Value.ToString(); myDataRow["PAY_CATEGORY_NO"] = pvtintPayCategoryNo; myDataRow["PAY_CATEGORY_TYPE"] = pvtstrPayrollType; myDataRow["PAY_CATEGORY_SHIFT_SCHEDULE_NO"] = pvtintPayCategoryShiftScheduleNo; myDataRow["SHIFT_SCHEDULE_DATETIME"] = dgvShiftScheduleDataGridView[this.pvtintDateYYYYMMDDCol, intRow].Value.ToString(); myDataRow["FROM_HHMM"] = dgvShiftScheduleDataGridView[this.pvtintFromHHMMCol, intRow].Value.ToString(); myDataRow["TO_HHMM"] = dgvShiftScheduleDataGridView[this.pvtintToHHMMCol, intRow].Value.ToString(); myDataTable.Rows.Add(myDataRow); } } } for (int intRow = 0; intRow < pvtEmployeeShiftScheduleDataView.Count; intRow++) { pvtEmployeeShiftScheduleDataView[intRow].Delete(); intRow -= 1; } TempDataSet.Tables.Add(myDataTable); //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(TempDataSet); object[] objParm = new object[4]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = pvtbytCompress; objParm[3] = this.dgvPayrollTypeDataGridView[0, this.Get_DataGridView_SelectedRowIndex(dgvPayrollTypeDataGridView)].Value.ToString().Substring(0, 1); pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Update_Record", objParm, true); TempDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); pvtDataSet.Merge(TempDataSet); this.pvtDataSet.AcceptChanges(); Load_PayCategory_SpreadSheet(); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
public void btnSave_Click(object sender, System.EventArgs e) { try { foreach (TreeNode ndeLevel1 in this.tvwCompany.Nodes) { if (ndeLevel1.GetNodeCount(true) > 0) { foreach (TreeNode ndeLevel2 in ndeLevel1.Nodes) { if (ndeLevel2.GetNodeCount(true) == 0) { pvtintFindRow = pvtUserMenuDataView.Find(ndeLevel2.Tag.ToString()); if (ndeLevel2.ImageIndex == 1) { if (pvtintFindRow == -1) { pvtDataRowView = pvtUserMenuDataView.AddNew(); pvtDataRowView.BeginEdit(); pvtDataRowView["COMPANY_NO"] = pvtint64CompanyNo; pvtDataRowView["USER_NO"] = pvtint64UserNo; pvtDataRowView["MENU_ITEM_ID"] = ndeLevel2.Tag.ToString(); pvtDataRowView["ACCESS_IND"] = "A"; pvtDataRowView.EndEdit(); } } else { if (pvtintFindRow > -1) { pvtUserMenuDataView[pvtintFindRow].Delete(); } } } else { foreach (TreeNode ndeLevel3 in ndeLevel2.Nodes) { if (ndeLevel3.GetNodeCount(true) == 0) { pvtintFindRow = pvtUserMenuDataView.Find(ndeLevel3.Tag.ToString()); if (ndeLevel3.ImageIndex == 1) { if (pvtintFindRow == -1) { pvtDataRowView = pvtUserMenuDataView.AddNew(); pvtDataRowView.BeginEdit(); pvtDataRowView["COMPANY_NO"] = pvtint64CompanyNo; pvtDataRowView["USER_NO"] = pvtint64UserNo; pvtDataRowView["MENU_ITEM_ID"] = ndeLevel3.Tag.ToString(); pvtDataRowView["ACCESS_IND"] = "A"; pvtDataRowView.EndEdit(); } } else { if (pvtintFindRow > -1) { pvtUserMenuDataView[pvtintFindRow].Delete(); } } } else { foreach (TreeNode ndeLevel4 in ndeLevel3.Nodes) { if (ndeLevel4.GetNodeCount(true) == 0) { if (ndeLevel4.ImageIndex == 1) { pvtintFindRow = pvtUserMenuDataView.Find(ndeLevel4.Tag.ToString()); if (pvtintFindRow == -1) { pvtDataRowView = pvtUserMenuDataView.AddNew(); pvtDataRowView.BeginEdit(); pvtDataRowView["COMPANY_NO"] = pvtint64CompanyNo; pvtDataRowView["USER_NO"] = pvtint64UserNo; pvtDataRowView["MENU_ITEM_ID"] = ndeLevel4.Tag.ToString(); pvtDataRowView["ACCESS_IND"] = "A"; pvtDataRowView.EndEdit(); } } else { if (pvtintFindRow > -1) { pvtUserMenuDataView[pvtintFindRow].Delete(); } } } } } } } } } } pvtTempDataSet = null; pvtTempDataSet = new DataSet(); DataTable myDataTable = this.pvtDataSet.Tables["UserMenu"].Clone(); pvtTempDataSet.Tables.Add(myDataTable); for (int intRow = 0; intRow < this.pvtUserMenuDataView.Count; intRow++) { if (this.pvtUserMenuDataView[intRow].Row.RowState == DataRowState.Added | this.pvtUserMenuDataView[intRow].Row.RowState == DataRowState.Deleted | this.pvtUserMenuDataView[intRow].Row.RowState == DataRowState.Modified) { pvtTempDataSet.Tables["UserMenu"].ImportRow(this.pvtUserMenuDataView[intRow].Row); } } //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet); if (pvtTempDataSet.Tables["UserMenu"].Rows.Count > 0) { object[] objParm = new object[3]; objParm[0] = AppDomain.CurrentDomain.GetData("FromProgramInd").ToString(); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = pvtbytCompress; pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Update_User_Menus", objParm, true); pvtUserMenuDataView = null; pvtUserMenuDataView = new DataView(pvtDataSet.Tables["UserMenu"], "USER_NO = " + pvtint64UserNo, "MENU_ITEM_ID", DataViewRowState.CurrentRows | DataViewRowState.Deleted); for (int intRow = 0; intRow < this.pvtUserMenuDataView.Count; intRow++) { this.pvtUserMenuDataView[intRow].Delete(); } pvtTempDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); pvtDataSet.Merge(pvtTempDataSet); pvtDataSet.AcceptChanges(); } btnCancel_Click(sender, e); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
public void btnSave_Click(object sender, System.EventArgs e) { try { int intReturnCode = clsISUtilities.DataBind_Save_Check(); if (intReturnCode != 0) { return; } if (Convert.ToDouble(this.txtRate1.Text) > Convert.ToDouble(this.txtRate2.Text) & Convert.ToDouble(this.txtRate2.Text) != 0) { CustomMessageBox.Show("Overtime Rate 1 cannot be Greater than Overtime Rate 2", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.txtRate1.Focus(); return; } if (Convert.ToDouble(this.txtRate2.Text) > Convert.ToDouble(this.txtRate3.Text) & Convert.ToDouble(this.txtRate3.Text) != 0) { CustomMessageBox.Show("Overtime Rate 2 cannot be Greater than Overtime Rate 3", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.txtRate2.Focus(); return; } if (Convert.ToDouble(this.txtSalaryRate1.Text) > Convert.ToDouble(this.txtSalaryRate2.Text) & Convert.ToDouble(this.txtSalaryRate2.Text) != 0) { CustomMessageBox.Show("Overtime Rate 1 cannot be Greater than Overtime Rate 2", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.txtSalaryRate1.Focus(); return; } if (Convert.ToDouble(this.txtSalaryRate2.Text) > Convert.ToDouble(this.txtSalaryRate3.Text) & Convert.ToDouble(this.txtSalaryRate3.Text) != 0) { CustomMessageBox.Show("Overtime Rate 2 cannot be Greater than Overtime Rate 3", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.txtSalaryRate2.Focus(); return; } pvtTempDataSet = null; pvtTempDataSet = new DataSet(); pvtTempDataSet.Tables.Add(this.pvtDataSet.Tables["Company"].Clone()); pvtTempDataSet.Tables["Company"].ImportRow(this.pvtCompanyDataView[clsISUtilities.DataViewIndex].Row); pvtTempDataSet.Tables.Add(this.pvtDataSet.Tables["EfilingPeriod"].Clone()); //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet); if (this.Text.EndsWith(" - New") == true) { object[] objParm = new object[3]; objParm[0] = AppDomain.CurrentDomain.GetData("AccessInd").ToString(); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = this.pvtbytCompress; pvtint64CompanyNo = (Int64)clsISUtilities.DynamicFunction("Insert_New_Record", objParm, true); AppDomain.CurrentDomain.SetData("LastCompanyNo", pvtint64CompanyNo); //Get Main DataSet DataSet TempDataSet = (DataSet)AppDomain.CurrentDomain.GetData("DataSet"); DataRow dtDataRow = TempDataSet.Tables["Company"].NewRow(); dtDataRow["COMPANY_NO"] = pvtint64CompanyNo; dtDataRow["COMPANY_DESC"] = this.txtCompany.Text; if (rbnYYYY.Checked == true) { dtDataRow["DATE_FORMAT"] = "yyyy-MM-dd"; } else { dtDataRow["DATE_FORMAT"] = "dd-MM-yyyy"; } dtDataRow["COMPANY_ACCESS_IND"] = "A"; TempDataSet.Tables["Company"].Rows.Add(dtDataRow); TempDataSet.AcceptChanges(); //Fire Off Load Of Companies ComboBox on PayrollMain Form Timer tmrTimerReloadCompanies = (Timer)AppDomain.CurrentDomain.GetData("TimerReloadCompanies"); tmrTimerReloadCompanies.Enabled = true; pvtCompanyDataView[clsISUtilities.DataViewIndex]["COMPANY_NO"] = pvtint64CompanyNo; } else { object[] objParm = new object[3]; objParm[0] = pvtint64CompanyNo; objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = this.pvtbytCompress; clsISUtilities.DynamicFunction("Update_Record", objParm, true); //Get Main DataSet DataSet TempDataSet = (DataSet)AppDomain.CurrentDomain.GetData("DataSet"); for (int intRow = 0; intRow < TempDataSet.Tables["Company"].Rows.Count; intRow++) { if (Convert.ToInt64(TempDataSet.Tables["Company"].Rows[intRow]["COMPANY_NO"]) == pvtint64CompanyNo) { if (rbnYYYY.Checked == true) { TempDataSet.Tables["Company"].Rows[intRow]["DATE_FORMAT"] = "yyyy-MM-dd"; } else { TempDataSet.Tables["Company"].Rows[intRow]["DATE_FORMAT"] = "dd-MM-yyyy"; } break; } } } //Current Company Selected Globally if (Convert.ToInt32(AppDomain.CurrentDomain.GetData("CompanyNo")) == pvtint64CompanyNo) { if (rbnYYYY.Checked == true) { AppDomain.CurrentDomain.SetData("DateFormat", "yyyy-MM-dd"); } else { AppDomain.CurrentDomain.SetData("DateFormat", "dd-MM-yyyy"); } } this.pvtDataSet.AcceptChanges(); btnCancel_Click(sender, e); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
private void btnSave_Click(object sender, EventArgs e) { try { int intIndex = 0; string strType = "P"; string strEmployeeNos = ""; DataSet DataSet = new System.Data.DataSet(); DataSet.Tables.Add(pvtDataSet.Tables["Employee"].Clone()); if (rbnPercent.Checked == true) { if (this.txtIncrease.Text.Trim().Replace(".", "") == "") { this.txtIncrease.Text = ""; CustomMessageBox.Show("Enter Percent Increase / Decrease Value.", "", MessageBoxButtons.OK, MessageBoxIcon.Error); this.txtIncrease.Focus(); return; } else { if (Convert.ToDouble(this.txtIncrease.Text.Trim()) == 0) { CustomMessageBox.Show("Percent Increase / Decrease Value Cannot be Zero.", "", MessageBoxButtons.OK, MessageBoxIcon.Error); this.txtIncrease.Focus(); return; } } if (dgvEmployeeSelectedDataGridView.Rows.Count == 0) { CustomMessageBox.Show("You need to Select at least 1 Employee.", "", MessageBoxButtons.OK, MessageBoxIcon.Error); this.btnAdd.Focus(); return; } for (int intRow = 0; intRow < this.dgvEmployeeSelectedDataGridView.Rows.Count; intRow++) { intIndex = Convert.ToInt32(this.dgvEmployeeSelectedDataGridView[6, intRow].Value); DataSet.Tables["Employee"].ImportRow(pvtEmployeeDataView[intIndex].Row); if (intRow == 0) { strEmployeeNos = pvtEmployeeDataView[intIndex]["EMPLOYEE_NO"].ToString(); } else { strEmployeeNos += "," + pvtEmployeeDataView[intIndex]["EMPLOYEE_NO"].ToString(); } } } else { strType = "A"; for (int intRow = 0; intRow < this.dgvEmployeeDataGridView.Rows.Count; intRow++) { if (this.dgvEmployeeDataGridView[3, intRow].Value != null) { if (this.dgvEmployeeDataGridView[3, intRow].Value.ToString() != "") { intIndex = Convert.ToInt32(this.dgvEmployeeDataGridView[6, intRow].Value); pvtEmployeeDataView[intIndex]["HOURLY_RATE"] = Convert.ToDouble(this.dgvEmployeeDataGridView[3, intRow].Value); pvtEmployeeDataView[intIndex]["SALARY_WAGE_INCREASE"] = Convert.ToDouble(this.dgvEmployeeDataGridView[4, intRow].Value); DataSet.Tables["Employee"].ImportRow(pvtEmployeeDataView[intIndex].Row); if (intRow == 0) { strEmployeeNos = pvtEmployeeDataView[intIndex]["EMPLOYEE_NO"].ToString(); } else { strEmployeeNos += "," + pvtEmployeeDataView[intIndex]["EMPLOYEE_NO"].ToString(); } } } } if (strEmployeeNos == "") { CustomMessageBox.Show("Enter at least 1 Value into the 'New' Column in the 'List of Employees' Spreadsheet.", "", MessageBoxButtons.OK, MessageBoxIcon.Error); this.dgvEmployeeDataGridView.Focus(); return; } this.txtIncrease.Text = "0"; } pvtEmployeeDataView.RowFilter = pvtEmployeeDataView.RowFilter + " AND EMPLOYEE_NO IN (" + strEmployeeNos + ")"; //Compress DataSet byte[] bytCompress = clsISUtilities.Compress_DataSet(DataSet); object[] objParm = new object[8]; objParm[0] = parInt64CompanyNo; objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = AppDomain.CurrentDomain.GetData("AccessInd").ToString(); objParm[3] = pvtintPayCategoryNo; objParm[4] = this.pvtstrPayrollType; objParm[5] = strType; objParm[6] = Convert.ToDouble(this.txtIncrease.Text); objParm[7] = bytCompress; bytCompress = (byte[])clsISUtilities.DynamicFunction("Update_Records", objParm, true); DataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress); //Remove Rows from DataTable for (int intRow = 0; intRow < pvtEmployeeDataView.Count; intRow++) { pvtEmployeeDataView[intRow].Delete(); intRow -= 1; } pvtDataSet.AcceptChanges(); pvtDataSet.Merge(DataSet); btnCancel_Click(sender, e); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
private void btnOK_Click(object sender, System.EventArgs e) { try { DialogResult dlgResult = InteractPayroll.CustomMessageBox.Show("Are you sure you want to Upload this Data?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlgResult == DialogResult.Yes) { string strPayCategoryWhere = ""; int pvtPayCategoryDataViewIndex = -1; for (int intRow = 0; intRow < this.dgvPayCategoryDataGridView.Rows.Count; intRow++) { if (intRow == 0) { strPayCategoryWhere = " AND EPC.PAY_CATEGORY_NO IN (" + this.dgvPayCategoryDataGridView[4, intRow].Value.ToString(); pvtPayCategoryDataViewIndex = Convert.ToInt32(this.dgvPayCategoryDataGridView[8, intRow].Value); } else { strPayCategoryWhere += "," + this.dgvPayCategoryDataGridView[4, intRow].Value.ToString(); } } strPayCategoryWhere += ")"; pvtTempDataSet = null; pvtTempDataSet = new DataSet(); DataTable myEmployeeDataTable; myEmployeeDataTable = pvtDataSet.Tables["Employee"].Copy(); pvtTempDataSet.Tables.Add(myEmployeeDataTable); DataTable myEmployeePayCategoryDataTable; myEmployeePayCategoryDataTable = pvtDataSet.Tables["EmployeePayCategory"].Copy(); pvtTempDataSet.Tables.Add(myEmployeePayCategoryDataTable); //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet); object[] objParm = new object[5]; objParm[0] = pvtint64CompanyNo; objParm[1] = pvtstrPayrollType; objParm[2] = strPayCategoryWhere; objParm[3] = Convert.ToDateTime(this.pvtPayCategoryDataView[pvtPayCategoryDataViewIndex]["TIMESHEET_UPLOAD_DATETIME"]).ToString("yyyy-MM-dd"); objParm[4] = pvtbytCompress; pvtblnLocalWebService = true; pvtbytCompress = (byte[])this.clsISClientUtilities.DynamicFunction("Get_Upload_Data", objParm, false); DataSet DataSetClient = clsISClientUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); if (DataSetClient.Tables["ErrorCount"].Rows.Count > 0) { if (DataSetClient.Tables["ErrorCount"].Rows[0]["INDICATOR"].ToString() == "X") { //Test InteractPayroll.CustomMessageBox.Show("There are Time Sheets with Errors on the Client Database.\n\nYou Need to Fix these TimeSheets on (Validite Client Program) to Proceed.\n\nProcess Cancelled.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } if (DataSetClient.Tables["Dates"].Rows.Count > 0) { this.grbUploadProgress.Visible = true; this.pgbProgressBar.Maximum = DataSetClient.Tables["Dates"].Rows.Count + 1; for (int intRow = 0; intRow < DataSetClient.Tables["Dates"].Rows.Count; intRow++) { //From Clint Database objParm = new object[4]; objParm[0] = pvtint64CompanyNo; objParm[1] = pvtstrPayrollType; objParm[2] = strPayCategoryWhere; objParm[3] = Convert.ToDateTime(DataSetClient.Tables["Dates"].Rows[intRow]["TIMESHEET_DATE"]).ToString("yyyy-MM-dd"); pvtblnLocalWebService = true; pvtbytCompress = (byte[])this.clsISClientUtilities.DynamicFunction("Get_Upload_Data_For_Day", objParm, false); //Internet Database Insert objParm = new object[6]; objParm[0] = pvtint64CompanyNo; objParm[1] = Convert.ToDateTime(DataSetClient.Tables["Dates"].Rows[intRow]["TIMESHEET_DATE"]); objParm[2] = pvtbytCompress; objParm[3] = pvtstrPayrollType; objParm[4] = Convert.ToDateTime(this.pvtPayCategoryDataView[pvtPayCategoryDataViewIndex]["PAY_PERIOD_DATE"]).ToString("yyyy-MM-dd"); objParm[5] = Convert.ToDateTime(this.pvtPayCategoryDataView[pvtPayCategoryDataViewIndex]["TIMESHEET_UPLOAD_DATETIME"]).ToString("yyyy-MM-dd"); pvtblnLocalWebService = false; string strUploadDateTime = (string)clsISUtilities.DynamicFunction("Insert_TimeSheet_Records", objParm); //Update Client PAYCATEGORY Records with Date TimeStamp objParm = new object[3]; objParm[0] = pvtint64CompanyNo; objParm[1] = strUploadDateTime; objParm[2] = pvtbytCompress; pvtblnLocalWebService = true; this.clsISClientUtilities.DynamicFunction("Update_PayCategory_Last_Upload_DateTime", objParm, false); this.pgbProgressBar.Value += 1; } this.Refresh(); objParm = new object[3]; objParm[0] = pvtint64CompanyNo; objParm[1] = pvtstrPayrollType; objParm[2] = strPayCategoryWhere; this.clsISClientUtilities.DynamicFunction("Move_Data_To_History_And_Cleanup", objParm, false); this.pgbProgressBar.Value += 1; this.Refresh(); InteractPayroll.CustomMessageBox.Show("Upload Successful.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { InteractPayroll.CustomMessageBox.Show("There is NO Data to Upload", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } this.Close(); } } catch (Exception eException) { if (pvtblnLocalWebService == true) { clsISClientUtilities.ErrorHandler(eException); } else { clsISUtilities.ErrorHandler(eException); } } }
public void btnSave_Click(object sender, System.EventArgs e) { try { int intReturnCode = clsISUtilities.DataBind_Save_Check(); if (intReturnCode != 0) { return; } DataSet TempDataSet = new DataSet(); TempDataSet.Tables.Add(this.pvtDataSet.Tables["LeaveType"].Clone()); TempDataSet.Tables["LeaveType"].ImportRow(this.pvtLeaveTypeDataView[clsISUtilities.DataViewIndex].Row); //Compress DataSet byte[] bytCompress = clsISUtilities.Compress_DataSet(TempDataSet); if (this.Text.EndsWith(" - New") == true) { object[] objParm = new object[3]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = bytCompress; pvtintLeaveTypeNo = (int)clsISUtilities.DynamicFunction("Insert_New_Record", objParm, true); pvtLeaveTypeDataView[clsISUtilities.DataViewIndex]["EARNING_NO"] = pvtintLeaveTypeNo; } else { object[] objParm = new object[3]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = bytCompress; intReturnCode = (int)clsISUtilities.DynamicFunction("Update_Record", objParm, true); if (intReturnCode == 9999) { this.pvtDataSet.RejectChanges(); pvtLeaveTypeDataView[this.clsISUtilities.DataViewIndex]["PAYROLL_LINK"] = 0; this.dgvLeaveTypeDataGridView[0, this.Get_DataGridView_SelectedRowIndex(dgvLeaveTypeDataGridView)].Style = this.PayrollLinkDataGridViewCellStyle; CustomMessageBox.Show("This Leave Type is currently being used in a Payroll Run.\r\n\r\nUpdate Cancelled.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { this.dgvLeaveTypeDataGridView[1, this.Get_DataGridView_SelectedRowIndex(dgvLeaveTypeDataGridView)].Value = this.txtLeaveType.Text.Trim(); } } this.pvtDataSet.AcceptChanges(); if (this.clsISUtilities.pubintReloadSpreadsheet == true) { Load_CurrentForm_Records(); } else { btnCancel_Click(sender, e); } } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
public void btnSave_Click(object sender, System.EventArgs e) { try { pvtintReturnCode = clsISUtilities.DataBind_Save_Check(); if (pvtintReturnCode != 0) { return; } pvtintReturnCode = Save_Check(); if (pvtintReturnCode != 0) { return; } pvtTempDataSet = null; pvtTempDataSet = new DataSet(); pvtTempDataSet.Tables.Add(this.pvtDataSet.Tables["Deduction"].Clone()); pvtTempDataSet.Tables["Deduction"].ImportRow(pvtDeductionDataView[clsISUtilities.DataViewIndex].Row); pvtTempDataSet.Tables.Add(this.pvtDataSet.Tables["EarningPercentage"].Clone()); pvtEarningPercentageDataView = null; pvtEarningPercentageDataView = new DataView(pvtDataSet.Tables["EarningPercentage"], "COMPANY_NO = " + AppDomain.CurrentDomain.GetData("CompanyNo").ToString() + " AND PAY_CATEGORY_TYPE = '" + pvtstrPayrollType + "' AND DEDUCTION_NO = " + pvtintDeductionNo, "", DataViewRowState.Added | DataViewRowState.Deleted | DataViewRowState.ModifiedCurrent); for (int intRow = 0; intRow < pvtEarningPercentageDataView.Count; intRow++) { pvtTempDataSet.Tables["EarningPercentage"].ImportRow(pvtEarningPercentageDataView[intRow].Row); } //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet); if (this.Text.IndexOf(" - New", 0) > 0) { object[] objParm = new object[2]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[1] = pvtbytCompress; pvtintDeductionNo = (int)clsISUtilities.DynamicFunction("Insert_New_Record", objParm, true); pvtDeductionDataView[clsISUtilities.DataViewIndex]["DEDUCTION_NO"] = pvtintDeductionNo; pvtDeductionDataView[clsISUtilities.DataViewIndex]["PAYROLL_LINK"] = System.DBNull.Value; //2017-02-24 Create opposite PAY_CATEGORY_TYPE DataRowView DataRowView = pvtDeductionDataView.AddNew(); DataRowView.BeginEdit(); DataRowView["COMPANY_NO"] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); if (pvtDeductionDataView[clsISUtilities.DataViewIndex]["PAY_CATEGORY_TYPE"].ToString() == "W") { DataRowView["PAY_CATEGORY_TYPE"] = "S"; } else { DataRowView["PAY_CATEGORY_TYPE"] = "W"; } DataRowView["EMPLOYEE_NO"] = 0; DataRowView["DEDUCTION_NO"] = Convert.ToInt16(pvtDeductionDataView[clsISUtilities.DataViewIndex]["DEDUCTION_NO"]); DataRowView["DEDUCTION_SUB_ACCOUNT_NO"] = Convert.ToInt16(pvtDeductionDataView[clsISUtilities.DataViewIndex]["DEDUCTION_SUB_ACCOUNT_NO"]); DataRowView["DEDUCTION_DESC"] = pvtDeductionDataView[clsISUtilities.DataViewIndex]["DEDUCTION_DESC"].ToString(); DataRowView["DEDUCTION_SUB_ACCOUNT_COUNT"] = Convert.ToInt16(pvtDeductionDataView[clsISUtilities.DataViewIndex]["DEDUCTION_SUB_ACCOUNT_COUNT"]); if (pvtDeductionDataView[clsISUtilities.DataViewIndex]["IRP5_CODE"] != System.DBNull.Value) { DataRowView["IRP5_CODE"] = Convert.ToInt16(pvtDeductionDataView[clsISUtilities.DataViewIndex]["IRP5_CODE"]); } DataRowView["DEDUCTION_REPORT_HEADER1"] = pvtDeductionDataView[clsISUtilities.DataViewIndex]["DEDUCTION_REPORT_HEADER1"].ToString(); DataRowView["DEDUCTION_REPORT_HEADER2"] = pvtDeductionDataView[clsISUtilities.DataViewIndex]["DEDUCTION_REPORT_HEADER2"].ToString(); DataRowView["DEDUCTION_LOAN_TYPE_IND"] = pvtDeductionDataView[clsISUtilities.DataViewIndex]["DEDUCTION_LOAN_TYPE_IND"].ToString(); DataRowView["DEDUCTION_DEL_IND"] = "Y"; DataRowView["DEDUCTION_TYPE_IND"] = "U"; DataRowView["DEDUCTION_VALUE"] = 0; DataRowView["DEDUCTION_MIN_VALUE"] = 0; DataRowView["DEDUCTION_MAX_VALUE"] = 0; DataRowView["DEDUCTION_PERIOD_IND"] = "E"; DataRowView["DEDUCTION_DAY_VALUE"] = 0; DataRowView["TIE_BREAKER"] = 1; DataRowView.EndEdit(); pvtEarningPercentageDataView = null; pvtEarningPercentageDataView = new DataView(pvtDataSet.Tables["EarningPercentage"], "COMPANY_NO = " + AppDomain.CurrentDomain.GetData("CompanyNo").ToString() + " AND PAY_CATEGORY_TYPE = '" + pvtstrPayrollType + "' AND DEDUCTION_NO = 0 ", "", DataViewRowState.CurrentRows); for (int intRow = 0; intRow < pvtEarningPercentageDataView.Count; intRow++) { pvtEarningPercentageDataView[intRow]["DEDUCTION_NO"] = pvtintDeductionNo; intRow -= 1; } } else { object[] objParm = new object[3]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[2] = pvtbytCompress; pvtintReturnCode = (int)clsISUtilities.DynamicFunction("Update_Record", objParm, true); if (pvtintReturnCode == 9999) { this.pvtDataSet.Tables["Deduction"].RejectChanges(); pvtDeductionDataView[clsISUtilities.DataViewIndex]["PAYROLL_LINK"] = 0; this.dgvDeductionDataGridView.Rows[this.Get_DataGridView_SelectedRowIndex(this.dgvDeductionDataGridView)].HeaderCell.Style = LockedPayrollRunDataGridViewCellStyle; CustomMessageBox.Show("This Deduction is currently being used in a Payroll Run.\r\n\r\nUpdate Cancelled.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { if (pvtintReturnCode != 0) { CustomMessageBox.Show("Number of Sub-Accounts used = " + pvtintReturnCode.ToString() + "\r\n\r\nYou cannot set a Value of " + this.cboNumberSubAccount.SelectedItem.ToString(), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } else { dgvDeductionDataGridView[2, pvtintDeductionDataGridViewRowIndex].Value = this.txtDeduction.Text.Trim(); } } } this.pvtDataSet.AcceptChanges(); if (this.Text.EndsWith(" - New") == true) { Load_CurrentForm_Records(); } else { btnCancel_Click(sender, e); } } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
private void btnDateClose_Click(object sender, System.EventArgs e) { try { DateTime dtWageRunDateTime = DateTime.Now; DateTime dtSalaryRunDateTime = DateTime.Now; string strRunDesc = "Payroll"; if (AppDomain.CurrentDomain.GetData("FromProgramInd").ToString() == "X") { strRunDesc = "Time Attendance"; } DialogResult dlgResult = CustomMessageBox.Show("Are you sure you want to Close the " + strRunDesc + " Run?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlgResult == DialogResult.Yes) { int intReturnCode = 0; object[] objParm = null; string strPayrollType = ""; string strWagesPayCategoryNumber = ""; string strSalariesPayCategoryNumber = ""; this.btnCancel.Enabled = false; this.btnDateClose.Enabled = false; this.btnAddAll.Enabled = false; this.btnRemoveAll.Enabled = false; this.grbActivationProcess.Visible = true; this.Refresh(); for (int intChosenRow = 0; intChosenRow < this.dgvChosenPayCategoryDataGridView.Rows.Count; intChosenRow++) { if (this.dgvChosenPayCategoryDataGridView[1, intChosenRow].Value.ToString() == "S") { dtSalaryRunDateTime = DateTime.ParseExact(this.dgvChosenPayCategoryDataGridView[2, intChosenRow].Value.ToString(), AppDomain.CurrentDomain.GetData("DateFormat").ToString(), null); if (strSalariesPayCategoryNumber == "") { strSalariesPayCategoryNumber = this.dgvChosenPayCategoryDataGridView[4, intChosenRow].Value.ToString(); } else { strSalariesPayCategoryNumber += "," + this.dgvChosenPayCategoryDataGridView[4, intChosenRow].Value.ToString(); } } else { dtWageRunDateTime = DateTime.ParseExact(this.dgvChosenPayCategoryDataGridView[2, intChosenRow].Value.ToString(), AppDomain.CurrentDomain.GetData("DateFormat").ToString(), null); if (strWagesPayCategoryNumber == "") { strWagesPayCategoryNumber = this.dgvChosenPayCategoryDataGridView[4, intChosenRow].Value.ToString(); } else { strWagesPayCategoryNumber += "," + this.dgvChosenPayCategoryDataGridView[4, intChosenRow].Value.ToString(); } } } if (strWagesPayCategoryNumber != "" && strSalariesPayCategoryNumber != "") { strPayrollType = "B"; } else { if (strWagesPayCategoryNumber != "") { if (AppDomain.CurrentDomain.GetData("FromProgramInd").ToString() == "X") { strPayrollType = "T"; } else { strPayrollType = "W"; } } else { strPayrollType = "S"; } } pvtintProcess = 1; this.tmrTimer.Enabled = true; #if (DEBUG) DateTime waitDateTime = DateTime.Now.AddSeconds(1); #else DateTime waitDateTime = DateTime.Now.AddSeconds(5); #endif objParm = null; objParm = new object[2]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = strPayrollType; intReturnCode = (int)clsISUtilities.DynamicFunction("Backup_DataBase", objParm); while (waitDateTime > DateTime.Now) { Application.DoEvents(); } this.tmrTimer.Enabled = false; this.picBackupBefore.Visible = true; if (intReturnCode == 0) { this.picBackupBefore.Image = (Image)global::ClosePayrollRun.Properties.Resources.tick48; lblDatabaseBackupBeforeClose.Text = "Backup of Database Successful"; this.Refresh(); //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(pvtTempDataSet); objParm = null; #if (DEBUG) if (strPayrollType == "B") { objParm = new object[6]; } else { objParm = new object[4]; } objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); if (strPayrollType == "B") { objParm[1] = dtWageRunDateTime; objParm[2] = dtSalaryRunDateTime; objParm[3] = strWagesPayCategoryNumber; objParm[4] = strSalariesPayCategoryNumber; objParm[5] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); } else { if (strPayrollType == "S") { objParm[1] = dtSalaryRunDateTime; objParm[2] = strSalariesPayCategoryNumber; objParm[3] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); } else { objParm[1] = dtWageRunDateTime; objParm[2] = strWagesPayCategoryNumber; objParm[3] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); } } if (strPayrollType == "B") { intReturnCode = (int)clsISUtilities.DynamicFunction("Close_Both_Run", objParm); } else { if (strPayrollType == "W") { intReturnCode = (int)clsISUtilities.DynamicFunction("Close_Wage_Run", objParm); } else { if (strPayrollType == "S") { intReturnCode = (int)clsISUtilities.DynamicFunction("Close_Salary_Run", objParm); } else { intReturnCode = (int)clsISUtilities.DynamicFunction("Close_TimeAttendance_Run", objParm); } } } if (intReturnCode == 0) { CustomMessageBox.Show("Close " + strRunDesc + " Run Successful.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { CustomMessageBox.Show("CLOSE " + strRunDesc + " Run UNSUCCESSFUL.\n\nSpeak to your System Administrator.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } #else objParm = new object[7]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = dtWageRunDateTime; objParm[2] = dtSalaryRunDateTime; objParm[3] = strPayrollType; objParm[4] = strWagesPayCategoryNumber; objParm[5] = strSalariesPayCategoryNumber; objParm[6] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); intReturnCode = (int)clsISUtilities.DynamicFunction("Insert_Close_Into_Queue", objParm); if (intReturnCode == 0) { pvtstrRunType = strPayrollType; Busy_With_Run(); } else { CustomMessageBox.Show("Insert Close Job into Queue FAILED.\n\nSpeak To your System Administrator.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } #endif } else { this.picBackupBefore.Image = (Image)global::ClosePayrollRun.Properties.Resources.Cross48; this.Refresh(); this.lblDatabaseBackupBeforeClose.Text = "Backup of Database UNSUCCESSFUL"; CustomMessageBox.Show("Backup of Database Failed.\n\nSpeak To your System Administrator.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
private void btnSave_Click(object sender, EventArgs e) { try { DataSet tempDataSet = new DataSet(); int intLeaveShiftNo = -1; //Employee Earnings //Employee Earnings tempDataSet.Tables.Add(pvtDataSet.Tables["PayCategory"].Clone()); if (this.dgvChosenPayCategoryDataGridView.Rows.Count == 0) { CustomMessageBox.Show("Select at least 1 Cost Centre", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { bool blnDefault = false; for (int intRow = 0; intRow < dgvChosenPayCategoryDataGridView.Rows.Count; intRow++) { DataRow MyDataRow = tempDataSet.Tables["PayCategory"].NewRow(); MyDataRow["PAY_CATEGORY_NO"] = this.dgvChosenPayCategoryDataGridView[3, intRow].Value.ToString(); if (Convert.ToBoolean(this.dgvChosenPayCategoryDataGridView[2, intRow].Value) == true) { MyDataRow["DEFAULT_IND"] = "Y"; if (blnDefault == false) { blnDefault = true; } else { CustomMessageBox.Show("Only 1 Cost Centre can be set to Default", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { MyDataRow["DEFAULT_IND"] = "N"; } MyDataRow["REC_RATE"] = this.dgvChosenPayCategoryDataGridView[1, intRow].Value.ToString(); tempDataSet.Tables["PayCategory"].Rows.Add(MyDataRow); } if (blnDefault == false) { CustomMessageBox.Show("1 Cost Centre must be set to Default", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } if (this.dgvLeaveShiftSelectedDataGridView.Rows.Count == 0) { CustomMessageBox.Show("Select at least 1 Normal Leave / Sick Leave Category", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (this.dgvLeaveShiftSelectedDataGridView.Rows.Count == 1) { intLeaveShiftNo = Convert.ToInt32(this.dgvLeaveShiftSelectedDataGridView[1, 0].Value); } else { CustomMessageBox.Show("Only 1 Normal Leave / Sick Leave Category Record Allowed.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } DataView CurrentPayCategoryDataView = new DataView(pvtDataSet.Tables["CurrentPayCategory"], "EMPLOYEE_NO = " + pvtintEmployeeNo + " AND PAY_CATEGORY_TYPE = '" + pvtstrCurrentPayrollType + "'", "", DataViewRowState.CurrentRows); for (int intRow = 0; intRow < CurrentPayCategoryDataView.Count; intRow++) { CurrentPayCategoryDataView[intRow].Delete(); intRow -= 1; } DataView EmployeeDataView = new DataView(pvtDataSet.Tables["Employee"], "EMPLOYEE_NO = " + pvtintEmployeeNo + " AND PAY_CATEGORY_TYPE = '" + pvtstrCurrentPayrollType + "'", "", DataViewRowState.CurrentRows); for (int intRow = 0; intRow < EmployeeDataView.Count; intRow++) { EmployeeDataView[intRow].Delete(); intRow -= 1; } byte[] bytCompress = clsISUtilities.Compress_DataSet(tempDataSet); object[] objParm = new object[6]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = pvtstrPayrollType; objParm[2] = pvtstrCurrentPayrollType; objParm[3] = pvtintEmployeeNo; objParm[4] = intLeaveShiftNo; objParm[5] = bytCompress; bytCompress = (byte[])clsISUtilities.DynamicFunction("Update_Employee", objParm); tempDataSet = clsISUtilities.DeCompress_Array_To_DataSet(bytCompress); pvtDataSet.Merge(tempDataSet); pvtDataSet.AcceptChanges(); Load_CurrentForm_Records(); btnCancel_Click(sender, e); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }
private void btnSave_Click(object sender, EventArgs e) { try { DataSet TempDataSet = new DataSet(); TempDataSet.Tables.Add(this.pvtDataSet.Tables["EmployeePayCategoryLevel"].Clone()); for (int intRow = 0; intRow < this.dgvLeaveDataGridView.Rows.Count; intRow++) { DataRow drDataRow = TempDataSet.Tables["EmployeePayCategoryLevel"].NewRow(); drDataRow["COMPANY_NO"] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); drDataRow["EMPLOYEE_NO"] = pvtLeaveDataView[Convert.ToInt32(this.dgvLeaveDataGridView[pvtintColLeaveHoldingIndex, intRow].Value)]["EMPLOYEE_NO"].ToString(); drDataRow["PAY_CATEGORY_NO"] = pvtLeaveDataView[Convert.ToInt32(this.dgvLeaveDataGridView[pvtintColLeaveHoldingIndex, intRow].Value)]["PAY_CATEGORY_NO"].ToString(); drDataRow["PAY_CATEGORY_TYPE"] = pvtstrPayrollType; drDataRow["EARNING_NO"] = pvtLeaveDataView[Convert.ToInt32(this.dgvLeaveDataGridView[pvtintColLeaveHoldingIndex, intRow].Value)]["EARNING_NO"].ToString(); drDataRow["LEVEL_NO"] = pvtintAuthoriseLevel; drDataRow["LEAVE_REC_NO"] = pvtLeaveDataView[Convert.ToInt32(this.dgvLeaveDataGridView[pvtintColLeaveHoldingIndex, intRow].Value)]["LEAVE_REC_NO"].ToString(); if (Convert.ToBoolean(this.dgvLeaveDataGridView[pvtintColAuthorisation, intRow].Value) == true) { drDataRow["AUTHORISED_IND"] = "Y"; } else { drDataRow["AUTHORISED_IND"] = "N"; } TempDataSet.Tables["EmployeePayCategoryLevel"].Rows.Add(drDataRow); } //Delete - New Records will be Passed Back for CostCentre for (int intRow = 0; intRow < pvtEmployeePayCategoryLevelDataView.Count; intRow++) { pvtEmployeePayCategoryLevelDataView[intRow].Delete(); intRow -= 1; } for (int intRow = 0; intRow < pvtAuthorsiseLevelDataView.Count; intRow++) { pvtAuthorsiseLevelDataView[intRow].Delete(); intRow -= 1; } //Compress DataSet pvtbytCompress = clsISUtilities.Compress_DataSet(TempDataSet); object[] objParm = new object[7]; objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo")); objParm[1] = pvtstrPayrollType; objParm[2] = this.pvtintAuthoriseLevel; objParm[3] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("UserNo")); objParm[4] = AppDomain.CurrentDomain.GetData("AccessInd").ToString(); objParm[5] = AppDomain.CurrentDomain.GetData("FromProgramInd").ToString(); objParm[6] = pvtbytCompress; pvtbytCompress = null; pvtbytCompress = (byte[])clsISUtilities.DynamicFunction("Update_Record", objParm); TempDataSet = clsISUtilities.DeCompress_Array_To_DataSet(pvtbytCompress); pvtDataSet.Merge(TempDataSet); this.pvtDataSet.AcceptChanges(); btnCancel_Click(sender, e); } catch (Exception eException) { clsISUtilities.ErrorHandler(eException); } }