public static DialogResult Show(string message, string headerText, MessageBoxButtons messageBoxButtons, MessageBoxIcon messageBoxIcon)
{
using (CustomClientMessageBox form = new CustomClientMessageBox(message, headerText, messageBoxButtons, messageBoxIcon))
{
return(form.ShowDialog());
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
DialogResult dlgResult = CustomClientMessageBox.Show("Delete Device '" + pvtDataView[pvtintDataViewReaderIndex]["DEVICE_DESC"].ToString() + "'",
this.Text,
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
if (dlgResult == DialogResult.Yes)
{
object[] objParm = new object[1];
objParm[0] = Convert.ToInt32(pvtDataView[pvtintDataViewReaderIndex]["DEVICE_NO"]);
clsISClientUtilities.DynamicFunction("Delete_Record", objParm, true);
pvtDataView[pvtintDataViewReaderIndex].Delete();
this.pvtDataSet.AcceptChanges();
this.Load_CurrentForm_Records();
}
}
catch (Exception eException)
{
clsISClientUtilities.ErrorHandler(eException);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
DialogResult myDialogResult = CustomClientMessageBox.Show("Are you sure you want to Backup the Database?",
this.Text,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (myDialogResult == System.Windows.Forms.DialogResult.Yes)
{
int intReturnCode = (int)clsISClientUtilities.DynamicFunction("Backup_DataBase", null, false);
if (intReturnCode == 0)
{
CustomClientMessageBox.Show("Backup Successful.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
CustomClientMessageBox.Show("Backup Failed.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
catch (Exception eException)
{
clsISClientUtilities.ErrorHandler(eException);
}
}
public void btnDelete_Click(object sender, System.EventArgs e)
{
try
{
DialogResult dlgResult = CustomClientMessageBox.Show("Delete All Employees / Cost Centres / Departments / Groups Linked to Device '" + this.dgvDeviceDataGridView[0, this.dgvDeviceDataGridView.CurrentRow.Index].Value.ToString() + "'",
this.Text,
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
if (dlgResult == DialogResult.Yes)
{
DataView EmployeeChosenDataView = new DataView(pvtDataSet.Tables["EmployeeChosen"], "DEVICE_NO = " + this.pvtintDeviceNo + " AND COMPANY_NO = " + pvtint64CompanyNo, "", DataViewRowState.CurrentRows);
for (int intRow = 0; intRow < EmployeeChosenDataView.Count; intRow++)
{
EmployeeChosenDataView[intRow].Delete();
intRow -= 1;
}
DataView PayCategoryChosenDataView = new DataView(pvtDataSet.Tables["PayCategoryChosen"], "DEVICE_NO = " + this.pvtintDeviceNo + " AND COMPANY_NO = " + pvtint64CompanyNo, "", DataViewRowState.CurrentRows);
for (int intRow = 0; intRow < PayCategoryChosenDataView.Count; intRow++)
{
PayCategoryChosenDataView[intRow].Delete();
intRow -= 1;
}
DataView DepartmentChosenDataView = new DataView(pvtDataSet.Tables["DepartmentChosen"], "DEVICE_NO = " + this.pvtintDeviceNo + " AND COMPANY_NO = " + pvtint64CompanyNo, "", DataViewRowState.CurrentRows);
for (int intRow = 0; intRow < DepartmentChosenDataView.Count; intRow++)
{
DepartmentChosenDataView[intRow].Delete();
intRow -= 1;
}
DataView GroupChosenDataView = new DataView(pvtDataSet.Tables["GroupChosen"], "DEVICE_NO = " + this.pvtintDeviceNo + " AND COMPANY_NO = " + pvtint64CompanyNo, "", DataViewRowState.CurrentRows);
for (int intRow = 0; intRow < GroupChosenDataView.Count; intRow++)
{
GroupChosenDataView[intRow].Delete();
intRow -= 1;
}
pvtDataSet.AcceptChanges();
object[] objParm = new object[2];
objParm[0] = pvtint64CompanyNo;
objParm[1] = pvtintDeviceNo;
clsISClientUtilities.DynamicFunction("Delete_Records", objParm, true);
this.Load_CurrentForm_Records();
}
}
catch (Exception ex)
{
clsISClientUtilities.ErrorHandler(ex);
}
}
private void frmClientConvertCostCentre_Load(object sender, EventArgs e)
{
try
{
miLinkedMenuItem = (ToolStripMenuItem)AppDomain.CurrentDomain.GetData("LinkedMenuItem");
clsISClientUtilities = new clsISClientUtilities(this, "busClientConvertCostCentre");
this.lblCompanySpreadsheetHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISClientUtilities.Label_Paint);
this.lblPayrollTypeHeader.Paint += new System.Windows.Forms.PaintEventHandler(clsISClientUtilities.Label_Paint);
this.lblPayCategoryDesc.Paint += new System.Windows.Forms.PaintEventHandler(clsISClientUtilities.Label_Paint);
this.lblPayCategorySelectDesc.Paint += new System.Windows.Forms.PaintEventHandler(clsISClientUtilities.Label_Paint);
this.dgvConvertToPayrollTypeDataGridView.Rows.Add("Wages");
this.dgvConvertToPayrollTypeDataGridView.Rows.Add("TimeSheets");
this.dgvConvertToPayrollTypeDataGridView.Rows.Add("Salaries");
pvtblnConvertToPayrollTypeDataGridViewLoaded = true;
this.Set_DataGridView_SelectedRowIndex(this.dgvConvertToPayrollTypeDataGridView, 0);
try
{
clsISUtilities = new InteractPayroll.clsISUtilities(this, "busConvertCostCentre");
}
catch (Exception ex)
{
CustomClientMessageBox.Show("Connection to Internet Database Could Not be Established", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
object[] objParm = new object[0];
pvtbytCompress = (byte[])clsISClientUtilities.DynamicFunction("Get_Form_Records", objParm, false);
pvtDataSet = clsISClientUtilities.DeCompress_Array_To_DataSet(pvtbytCompress);
for (int intRow = 0; intRow < this.pvtDataSet.Tables["Company"].Rows.Count; intRow++)
{
this.dgvCompanyDataGridView.Rows.Add(this.pvtDataSet.Tables["Company"].Rows[intRow]["COMPANY_DESC"].ToString(),
this.pvtDataSet.Tables["Company"].Rows[intRow]["COMPANY_NO"].ToString());
}
pvtblnCompanyDataGridViewLoaded = true;
if (this.dgvCompanyDataGridView.Rows.Count > 0)
{
this.Set_DataGridView_SelectedRowIndex(this.dgvCompanyDataGridView, 0);
}
}
catch (Exception eException)
{
clsISClientUtilities.ErrorHandler(eException);
}
}
// Close the splash window and show the main window
private void Close_SplasScreen_And_Show_Main()
{
try
{
//SET ALL GLOBAL VARIABLES HERE
AppDomain.CurrentDomain.SetData("UserNo", pvtint64UserNo);
AppDomain.CurrentDomain.SetData("AccessInd", pvtstrAccessInd);
AppDomain.CurrentDomain.SetData("CurrentForm", "");
AppDomain.CurrentDomain.SetData("DataSet", this.pvtDataSet);
try
{
string strPath = "";
string strBasePath = "";
strPath = AppDomain.CurrentDomain.BaseDirectory + "TimeAttendanceMain.dll";
strBasePath = AppDomain.CurrentDomain.BaseDirectory;
this.Hide();
AppDomainSetup myDomainInfo = new AppDomainSetup();
myDomainInfo.ApplicationBase = @strBasePath;
// Creates the application domain.
AppDomain mydomain = AppDomain.CreateDomain("TimeAttendanceMain", null, myDomainInfo);
Assembly myAssembly = Assembly.LoadFile(@strPath);
System.Windows.Forms.Form frm = (System.Windows.Forms.Form)myAssembly.CreateInstance("InteractPayrollClient.frmTimeAttendanceMain");
frm.ShowDialog();
frm.Dispose();
AppDomain.Unload(mydomain);
this.Close();
}
catch (System.Exception ex)
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Late Binding Error " + ex.ToString(), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
}
}
catch (Exception eException)
{
clsISClientUtilities.ErrorHandler(eException);
this.Close();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
DialogResult myDialogResult = CustomClientMessageBox.Show("Are you sure you want to Delete the Backup File?",
this.Text,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (myDialogResult == System.Windows.Forms.DialogResult.Yes)
{
string strFileName = this.dgvFilesDataGridView[1, this.Get_DataGridView_SelectedRowIndex(this.dgvFilesDataGridView)].Value.ToString();
object[] objParm = new object[1];
//#if(DEBUG)
// MessageBox.Show("Delete NOT Available in DEBUG Mode");
//#else
objParm[0] = strFileName;
clsISClientUtilities.DynamicFunction("Delete_Backup_File", objParm, false);
this.Refresh();
CustomClientMessageBox.Show("Delete of Backup File Successful.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
//#endif
this.dgvFilesDataGridView.Rows.RemoveAt(this.Get_DataGridView_SelectedRowIndex(this.dgvFilesDataGridView));
if (this.dgvFilesDataGridView.Rows.Count == 0)
{
this.btnOK.Enabled = false;
this.btnDelete.Visible = false;
}
}
}
catch (Exception eException)
{
clsISClientUtilities.ErrorHandler(eException);
}
}
public void btnDelete_Click(object sender, System.EventArgs e)
{
try
{
DialogResult dlgResult = CustomClientMessageBox.Show("Delete Group '" + pvtGroupDataView[this.pvtintGroupDataViewRow]["GROUP_DESC"].ToString() + "'",
this.Text,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (dlgResult == DialogResult.Yes)
{
object[] objParm = new object[2];
objParm[0] = pvtint64CompanyNo;
objParm[1] = pvtintGroupNo;
clsISClientUtilities.DynamicFunction("Delete_Group", objParm, true);
pvtGroupDataView[pvtintGroupDataViewRow].Delete();
DataView EmployeeLinkDataView = new DataView(pvtDataSet.Tables["EmployeeLink"], "GROUP_NO = " + pvtintGroupNo + " AND COMPANY_NO = " + pvtint64CompanyNo, "", DataViewRowState.CurrentRows);
for (int intRow = 0; intRow < EmployeeLinkDataView.Count; intRow++)
{
EmployeeLinkDataView[intRow].Delete();
intRow -= 1;
}
this.pvtDataSet.AcceptChanges();
pvtintGroupNo = -1;
this.Load_CurrentForm_Records();
}
}
catch (Exception eException)
{
clsISClientUtilities.ErrorHandler(eException);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
string strTimeFrom = "";
string strTimeTo = "";
if (this.cboCompany.SelectedIndex == -1)
{
CustomClientMessageBox.Show("Select Company that owns Clock Reader.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.cboCompany.Focus();
return;
}
if (this.txtReader.Text.Trim() == "")
{
CustomClientMessageBox.Show("Enter Clock Reader Description.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtReader.Focus();
return;
}
else
{
pvtstrDeviceDesc = this.txtReader.Text.Trim();
}
pvtstrTimeAttendClockFirstLastInd = "";
if (this.rbnTimeAttend.Checked == true)
{
pvtstrDeviceUsage = "T";
}
else
{
if (this.rbnAccess.Checked == true)
{
pvtstrDeviceUsage = "A";
}
else
{
if (this.rbnBoth.Checked == true)
{
pvtstrDeviceUsage = "B";
if (this.rbnClockNormal.Checked == true)
{
pvtstrTimeAttendClockFirstLastInd = "N";
}
else
{
if (this.rbnClockFirstLast.Checked == true)
{
pvtstrTimeAttendClockFirstLastInd = "Y";
}
else
{
CustomClientMessageBox.Show("Choose Access / Time & Attendance Option.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
else
{
CustomClientMessageBox.Show("Choose Device Usage.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
if (this.rbnInOnly.Checked == true)
{
pvtstrClockInOutParm = "I";
}
else
{
if (this.rbnOutOnly.Checked == true)
{
pvtstrClockInOutParm = "O";
}
else
{
if (this.rbnDynamic.Checked == true)
{
pvtstrClockInOutParm = "D";
}
else
{
if (this.rbnClockRange.Checked == true)
{
if (this.cboFromHour.SelectedIndex == -1)
{
this.cboFromHour.Focus();
CustomClientMessageBox.Show("Select From Hour.\n\n(Clock Range - In Range)", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.cboFromMinute.SelectedIndex == -1)
{
this.cboFromMinute.Focus();
CustomClientMessageBox.Show("Select From Minute.\n\n(Clock Range - In Range)", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.cboToHour.SelectedIndex == -1)
{
this.cboToHour.Focus();
CustomClientMessageBox.Show("Select To Hour.\n\n(Clock Range - In Range)", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (this.cboToMinute.SelectedIndex == -1)
{
this.cboToMinute.Focus();
CustomClientMessageBox.Show("Select To Minute.\n\n(Clock Range - In Range)", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
pvtstrClockInOutParm = "R";
strTimeFrom = this.cboFromHour.SelectedItem.ToString() + this.cboFromMinute.SelectedItem.ToString();
strTimeTo = this.cboToHour.SelectedItem.ToString() + this.cboToMinute.SelectedItem.ToString();
pvtintClockInRangeFrom = Convert.ToInt32(strTimeFrom);
pvtintClockInRangeTo = Convert.ToInt32(strTimeTo);
}
else
{
CustomClientMessageBox.Show("Select a " + this.grbClockOptions.Text + ".", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
}
if (this.cboLockOut.SelectedIndex == -1)
{
CustomClientMessageBox.Show("Select Lock Out Time.\n\n(Access Control - Employee Lock Out)", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.cboLockOut.Focus();
return;
}
else
{
pvtintLockOutMinutes = Convert.ToInt32(this.cboLockOut.SelectedItem.ToString());
}
if (this.cboCompany.Items.Count > 0)
{
if (this.cboCompany.SelectedIndex == -1)
{
CustomClientMessageBox.Show("Select Company that owns Clock Reader.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.cboCompany.Focus();
return;
}
else
{
pvtintCompanyNo = Convert.ToInt32(pvtDataSet.Tables["Company"].Rows[this.cboCompany.SelectedIndex]["COMPANY_NO"]);
}
}
else
{
pvtintCompanyNo = -1;
}
if (this.rbnWAN.Checked == true)
{
pvtstrLanWanInd = "W";
}
else
{
pvtstrLanWanInd = "L";
}
if (this.cboFAR.SelectedIndex == -1)
{
CustomClientMessageBox.Show("Select False Acceptance Read Value.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.cboFAR.Focus();
return;
}
else
{
pvtintFARRequested = intPossibleFARValuesArray[this.cboFAR.SelectedIndex];
}
DataSet TempDataSet = new DataSet();
TempDataSet.Tables.Add(pvtDataSet.Tables["Clock"].Clone());
if (this.Text.IndexOf(" - New") > 0)
{
DataRowView drvDataRowView = this.pvtDataView.AddNew();
//Set Key for Find
drvDataRowView["DEVICE_NO"] = 0;
drvDataRowView["DEVICE_DESC"] = pvtstrDeviceDesc;
drvDataRowView["DEVICE_USAGE"] = pvtstrDeviceUsage;
drvDataRowView["TIME_ATTEND_CLOCK_FIRST_LAST_IND"] = pvtstrTimeAttendClockFirstLastInd;
drvDataRowView["CLOCK_IN_OUT_PARM"] = pvtstrClockInOutParm;
drvDataRowView["CLOCK_IN_RANGE_FROM"] = pvtintClockInRangeFrom;
drvDataRowView["CLOCK_IN_RANGE_TO"] = pvtintClockInRangeTo;
drvDataRowView["LOCK_OUT_MINUTES"] = pvtintLockOutMinutes;
drvDataRowView["COMPANY_NO"] = pvtintCompanyNo;
drvDataRowView["LAN_WAN_IND"] = pvtstrLanWanInd;
drvDataRowView["FAR_REQUESTED"] = pvtintFARRequested;
drvDataRowView.EndEdit();
TempDataSet.Tables["Clock"].ImportRow(drvDataRowView.Row);
//Compress DataSet
byte[] pvtbytCompress = clsISClientUtilities.Compress_DataSet(TempDataSet);
object[] objParm = new object[1];
objParm[0] = pvtbytCompress;
drvDataRowView["DEVICE_NO"] = clsISClientUtilities.DynamicFunction("Insert_Record", objParm, true);
this.pvtintDeviceNo = Convert.ToInt32(drvDataRowView["DEVICE_NO"]);
}
else
{
pvtDataView[pvtintDataViewReaderIndex]["DEVICE_DESC"] = pvtstrDeviceDesc;
pvtDataView[pvtintDataViewReaderIndex]["DEVICE_USAGE"] = pvtstrDeviceUsage;
pvtDataView[pvtintDataViewReaderIndex]["TIME_ATTEND_CLOCK_FIRST_LAST_IND"] = pvtstrTimeAttendClockFirstLastInd;
pvtDataView[pvtintDataViewReaderIndex]["CLOCK_IN_OUT_PARM"] = pvtstrClockInOutParm;
pvtDataView[pvtintDataViewReaderIndex]["CLOCK_IN_RANGE_FROM"] = pvtintClockInRangeFrom;
pvtDataView[pvtintDataViewReaderIndex]["CLOCK_IN_RANGE_TO"] = pvtintClockInRangeTo;
pvtDataView[pvtintDataViewReaderIndex]["LOCK_OUT_MINUTES"] = pvtintLockOutMinutes;
pvtDataView[pvtintDataViewReaderIndex]["COMPANY_NO"] = pvtintCompanyNo;
pvtDataView[pvtintDataViewReaderIndex]["LAN_WAN_IND"] = pvtstrLanWanInd;
pvtDataView[pvtintDataViewReaderIndex]["FAR_REQUESTED"] = pvtintFARRequested;
TempDataSet.Tables["Clock"].ImportRow(pvtDataView[pvtintDataViewReaderIndex].Row);
//Compress DataSet
byte[] pvtbytCompress = clsISClientUtilities.Compress_DataSet(TempDataSet);
object[] objParm = new object[1];
objParm[0] = pvtbytCompress;
clsISClientUtilities.DynamicFunction("Update_Record", objParm, true);
this.dgvClockDataGridView[pvtintClockDescCol, this.dgvClockDataGridView.CurrentRow.Index].Value = pvtstrDeviceDesc;
}
pvtDataSet.AcceptChanges();
if (this.Text.IndexOf(" - New") > 0)
{
Load_CurrentForm_Records();
}
btnCancel_Click(sender, e);
}
catch (Exception ex)
{
clsISClientUtilities.ErrorHandler(ex);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
bool blnServerDatabaseConverted = false;
try
{
if (this.dgvChosenPayCategoryDataGridView.Rows.Count == 0)
{
CustomClientMessageBox.Show("There are NO Selected Cost Centres.\nFix to Continue.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
DialogResult dlgResult = CustomClientMessageBox.Show("Are you absolutely sure you want to Convert the Selected Cost Centre/s to '" + dgvConvertToPayrollTypeDataGridView[0, pvtintConvertToPayrollTypeDataGridViewRowIndex].Value.ToString() + "'",
this.Text,
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
if (dlgResult == DialogResult.Yes)
{
DataSet DataSet = new DataSet();
DataTable myDataTable = this.pvtDataSet.Tables["PayCategory"].Clone();
for (int intRow = 0; intRow < this.dgvChosenPayCategoryDataGridView.Rows.Count; intRow++)
{
DataRow drDataRow = myDataTable.NewRow();
drDataRow["COMPANY_NO"] = pvtInt64CompanyNo;
drDataRow["PAY_CATEGORY_NO"] = Convert.ToInt32(this.dgvChosenPayCategoryDataGridView[2, intRow].Value);
drDataRow["PAY_CATEGORY_TYPE"] = this.dgvChosenPayCategoryDataGridView[1, intRow].Value.ToString();
myDataTable.Rows.Add(drDataRow);
}
DataSet.Tables.Add(myDataTable);
//Compress DataSet
pvtbytCompress = clsISClientUtilities.Compress_DataSet(DataSet);
object[] objParm = new object[3];
objParm[0] = pvtInt64CompanyNo;
objParm[1] = pvtstrToPayCategoryType;
objParm[2] = pvtbytCompress;
//Backup Internet Database
int intReturnCode = (int)clsISUtilities.DynamicFunction("Check_Run", objParm, false);
if (intReturnCode == 9)
{
CustomClientMessageBox.Show("You do NOT have permission to perform this operation.\nSpeak to System Administrator.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
goto btnSave_Click_Continue;
}
else
{
if (intReturnCode == 1)
{
this.tmrProcess.Enabled = false;
this.picDatabaseConvertInternet.Image = global::ConvertCostCentre.Properties.Resources.Error;
CustomClientMessageBox.Show("There is Currently a Payroll/Time Attendance Run Date Open.\nFix to Continue.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
goto btnSave_Click_Continue;
}
}
pvtintProcessNo = 0;
pvtblnShowImage = false;
this.picDatabaseBackupInternet.Image = null;
this.picDatabaseBackupLocal.Image = null;
this.picDatabaseConvertInternet.Image = null;
this.picDatabaseConvertLocal.Image = null;
this.grbConversionProcess.Visible = true;
this.Refresh();
this.tmrProcess.Enabled = true;
DateTime dtDateTimeNext = DateTime.Now.AddSeconds(pvtintTimeDelaySeconds);
clsISUtilities.Set_New_BusinessObjectName("busBackupRestoreDatabase");
objParm = new object[2];
objParm[0] = pvtInt64CompanyNo;
objParm[1] = "_Backup_Before_CostCentre_Conversion";
//Backup Internet Database
intReturnCode = (int)clsISUtilities.DynamicFunction("Backup_DataBase_New", objParm, false);
if (intReturnCode != 0)
{
this.tmrProcess.Enabled = false;
this.picDatabaseBackupInternet.Image = global::ConvertCostCentre.Properties.Resources.Error;
CustomClientMessageBox.Show("Error Backing up Internet Database.\nFix to Continue.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
goto btnSave_Click_Continue;
}
while (DateTime.Now < dtDateTimeNext)
{
Application.DoEvents();
}
this.picDatabaseBackupInternet.Image = global::ConvertCostCentre.Properties.Resources.Ok;
this.pvtintProcessNo += 1;
dtDateTimeNext = DateTime.Now.AddSeconds(pvtintTimeDelaySeconds);
//Reset Class
clsISUtilities.Set_New_BusinessObjectName("busConvertCostCentre");
this.pnlDatabaseLocalBackup.Visible = true;
this.Refresh();
clsISClientUtilities.Set_New_BusinessObjectName("busBackupRestoreClientDatabase");
objParm = new object[1];
objParm[0] = "_Backup_Before_CostCentre_Conversion";
//Backup Client Database
intReturnCode = (int)clsISClientUtilities.DynamicFunction("Backup_DataBase_New", objParm, false);
if (intReturnCode != 0)
{
this.tmrProcess.Enabled = false;
this.picDatabaseBackupLocal.Image = global::ConvertCostCentre.Properties.Resources.Error;
CustomClientMessageBox.Show("Error Backing up Client Database.\nFix to Continue.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
goto btnSave_Click_Continue;
}
while (DateTime.Now < dtDateTimeNext)
{
Application.DoEvents();
}
this.picDatabaseBackupLocal.Image = global::ConvertCostCentre.Properties.Resources.Ok;
this.pvtintProcessNo += 1;
dtDateTimeNext = DateTime.Now.AddSeconds(pvtintTimeDelaySeconds);
//Reset Class
clsISClientUtilities.Set_New_BusinessObjectName("busClientConvertCostCentre");
objParm = new object[3];
objParm[0] = pvtInt64CompanyNo;
objParm[1] = pvtstrToPayCategoryType;
objParm[2] = pvtbytCompress;
//Convert Server
intReturnCode = (int)clsISUtilities.DynamicFunction("Convert_Records", objParm, false);
if (intReturnCode == 0)
{
blnServerDatabaseConverted = true;
while (DateTime.Now < dtDateTimeNext)
{
Application.DoEvents();
}
this.picDatabaseConvertInternet.Image = global::ConvertCostCentre.Properties.Resources.Ok;
this.pvtintProcessNo += 1;
dtDateTimeNext = DateTime.Now.AddSeconds(pvtintTimeDelaySeconds);
//Convert Client Databases
clsISClientUtilities.DynamicFunction("Convert_Client_Records", objParm, true);
while (DateTime.Now < dtDateTimeNext)
{
Application.DoEvents();
}
this.tmrProcess.Enabled = false;
this.picDatabaseConvertLocal.Image = global::ConvertCostCentre.Properties.Resources.Ok;
CustomClientMessageBox.Show("Conversion Successful.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
btnSave_Click_Continue:
btnCancel_Click(sender, e);
}
}
catch (Exception eException)
{
this.tmrProcess.Enabled = false;
if (pvtintProcessNo == 0)
{
this.picDatabaseBackupInternet.Image = global::ConvertCostCentre.Properties.Resources.Error;
}
else
{
if (pvtintProcessNo == 1)
{
this.picDatabaseBackupLocal.Image = global::ConvertCostCentre.Properties.Resources.Error;
}
else
{
if (pvtintProcessNo == 2)
{
this.picDatabaseConvertInternet.Image = global::ConvertCostCentre.Properties.Resources.Error;
}
else
{
if (pvtintProcessNo == 3)
{
this.picDatabaseConvertLocal.Image = global::ConvertCostCentre.Properties.Resources.Error;
}
}
}
}
if (blnServerDatabaseConverted == true)
{
CustomClientMessageBox.Show("Server Database Converted. / Local Database CONVERT FAILURE.\nURGENT - Speak to System Administrator.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
clsISClientUtilities.ErrorHandler(eException);
}
}
private void btnOK_Click(object sender, System.EventArgs e)
{
try
{
if (this.txtUserId.Text.Trim() == "")
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Enter User Id.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
frmMessageBox.ShowDialog();
this.txtUserId.Focus();
}
else
{
if (this.txtPassword.Text.Trim() == "")
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Enter Password.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
frmMessageBox.ShowDialog();
this.txtPassword.Focus();
}
else
{
this.Cursor = Cursors.AppStarting;
this.txtUserId.Enabled = false;
this.txtPassword.Enabled = false;
this.btnOK.Enabled = false;
string strUserInformation = this.txtUserId.Text.Trim().ToUpper() + "|" + this.txtPassword.Text.Trim().ToUpper();
object[] objParm = new object[1];
objParm[0] = strUserInformation;
byte[] bytCompress = null;
if (this.rbnLocal.Checked == true)
{
pvtblnLocalWebService = true;
bytCompress = (byte[])clsISClientUtilities.DynamicFunction("Logon_User", objParm, false);
}
else
{
pvtblnLocalWebService = false;
bytCompress = (byte[])clsISUtilities.DynamicFunction("Logon_Client_User", objParm, false);
}
pvtDataSet = clsISClientUtilities.DeCompress_Array_To_DataSet(bytCompress);
this.Cursor = Cursors.Default;
this.txtUserId.Enabled = true;
this.txtPassword.Enabled = true;
this.btnOK.Enabled = true;
if (this.rbnLocal.Checked == true)
{
if (pvtDataSet.Tables["ReturnValues"].Rows[0]["DB_CREATE_FOR_ENGINE"].ToString() == "")
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("There is Currently NO Database for SQL Server.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
this.Close();
return;
}
}
//From Local Machine
if (pvtDataSet.Tables["ReturnValues"].Rows[0]["NO_USERS_IND"].ToString() == "Y")
{
//Not Found
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("There are Currently NO Users on Local Machine.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
}
else
{
if (pvtDataSet.Tables["ReturnValues"].Rows[0]["DOWNLOAD_IND"].ToString() != "")
{
//CRC Error
if (pvtDataSet.Tables["ReturnValues"].Rows[0]["DOWNLOAD_IND"].ToString() == "C")
{
//Not Found
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Server CRC File Error\n\nTry Re-Login\n\nIf Problem Persists, Speak to Administrator.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
}
else
{
//Not Found
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Server Download Error\n\nTry Re-Login\n\nIf Problem Persists, Speak to Administrator.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
}
this.Close();
return;
}
else
{
if (pvtDataSet.Tables["ReturnValues"].Rows[0]["USER_NO"].ToString() == "-1")
{
//Not Found
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("User Id / Password NOT Found.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
frmMessageBox.ShowDialog();
}
else
{
btnOK_Click_Continue:
if (pvtDataSet.Tables["ReturnValues"].Rows[0]["RESET"].ToString() == "Y")
{
if (this.rbnLocal.Checked == true)
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("User Needs To Login To Internet Site to Change Password.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
}
else
{
AppDomain.CurrentDomain.SetData("UserNo", pvtDataSet.Tables["ReturnValues"].Rows[0]["USER_NO"].ToString());
frmPasswordChange = null;
frmPasswordChange = new frmPasswordChange();
frmPasswordChange.ShowDialog();
if (AppDomain.CurrentDomain.GetData("PasswordChanged").ToString() != "Y")
{
//Set so That Lower Down in Program it Closes in exe
AppDomain.CurrentDomain.SetData("UserNo", -1);
}
else
{
pvtDataSet.Tables["ReturnValues"].Rows[0]["RESET"] = "N";
goto btnOK_Click_Continue;
}
}
}
else
{
pvtint64UserNo = Convert.ToInt64(pvtDataSet.Tables["ReturnValues"].Rows[0]["USER_NO"]);
pvtstrAccessInd = pvtDataSet.Tables["ReturnValues"].Rows[0]["ACCESS_IND"].ToString();
if (this.rbnLocal.Checked == true)
{
string strApplicationPath = AppDomain.CurrentDomain.BaseDirectory;
#if (DEBUG)
strApplicationPath = AppDomain.CurrentDomain.BaseDirectory + "bin\\";
#endif
FileInfo fiFileInfo;
BinaryReader brBinaryReader;
FileStream fsFileStream;
BinaryWriter bwBinaryWriter;
long lngFileStartOffset = 0;
byte[] bytFileBytes;
byte[] bytFileChunkBytes;
byte[] bytDecompressedBytes;
byte[] bytTempBytes;
string strDownLoadFileName = "";
bool blnRestartProgram = false;
#if (DEBUG)
//pvtDataSet.Tables["Files"].Rows.Clear();
#endif
if (pvtDataSet.Tables["Files"].Rows.Count > 0)
{
for (int intRow = 0; intRow < pvtDataSet.Tables["Files"].Rows.Count; intRow++)
{
fiFileInfo = new FileInfo(strApplicationPath + pvtDataSet.Tables["Files"].Rows[intRow]["FILE_NAME"].ToString());
if (fiFileInfo.Exists == true)
{
if (fiFileInfo.LastWriteTime >= Convert.ToDateTime(pvtDataSet.Tables["Files"].Rows[intRow]["FILE_LAST_UPDATED_DATE"]).AddSeconds(-3)
& fiFileInfo.LastWriteTime <= Convert.ToDateTime(pvtDataSet.Tables["Files"].Rows[intRow]["FILE_LAST_UPDATED_DATE"]).AddSeconds(3))
{
continue;
}
}
if (pvtDataSet.Tables["Files"].Rows[intRow]["FILE_NAME"].ToString() == "TimeAttendanceClient.exe")
{
//Check If TimeAttendanceClient.exe_ Exists (Can only be Replaced Via Fix or Manual Process)
FileInfo fiFileInfoTemp = new FileInfo(strApplicationPath + pvtDataSet.Tables["Files"].Rows[intRow]["FILE_NAME"].ToString() + "_");
if (fiFileInfoTemp.Exists == true)
{
if (fiFileInfoTemp.LastWriteTime >= Convert.ToDateTime(pvtDataSet.Tables["Files"].Rows[intRow]["FILE_LAST_UPDATED_DATE"]).AddSeconds(-3)
& fiFileInfoTemp.LastWriteTime <= Convert.ToDateTime(pvtDataSet.Tables["Files"].Rows[intRow]["FILE_LAST_UPDATED_DATE"]).AddSeconds(3))
{
continue;
}
}
}
pvtDataSet.Tables["Files"].Rows[intRow]["DOWNLOAD_IND"] = "Y";
}
DataView FilesDataView = new DataView(pvtDataSet.Tables["Files"],
"DOWNLOAD_IND = 'Y'",
"",
DataViewRowState.CurrentRows);
if (FilesDataView.Count > 0)
{
int intProgressBarCombinedMaxValue = 0;
int intProgressBarMaxValue = 0;
for (int intRow = 0; intRow < FilesDataView.Count; intRow++)
{
//strFileName = parDataTable.Rows[intRow]["FILE_NAME"].ToString();
intProgressBarCombinedMaxValue += Convert.ToInt32(FilesDataView[intRow]["MAX_FILE_CHUNK_NO"]);
}
frmReadWriteFile = new frmReadWriteFile();
frmReadWriteFile.Show();
frmReadWriteFile.Refresh();
frmReadWriteFile.prbAllFileProgress.Maximum = intProgressBarCombinedMaxValue;
frmReadWriteFile.prbAllFileProgress.Value = 0;
//This Must Be Fixed
for (int intRow = 0; intRow < FilesDataView.Count; intRow++)
{
DateTime dtMinLoopTime = DateTime.Now.AddSeconds(1);
strDownLoadFileName = FilesDataView[intRow]["FILE_NAME"].ToString();
if (strDownLoadFileName == "URLConfig.dll"
| strDownLoadFileName == "clsISUtilities.dll"
| strDownLoadFileName == "PasswordChange.dll"
| strDownLoadFileName == "DownloadFiles.dll"
| strDownLoadFileName == "clsISClientUtilities.dll"
| strDownLoadFileName == "TimeAttendanceLogon.dll"
| strDownLoadFileName == "TimeAttendanceClient.exe"
| strDownLoadFileName == "TimeAttendanceClientIS.exe")
{
if (strDownLoadFileName == "TimeAttendanceClient.exe")
{
//Fix Will have to Be done Manually or via Fix
}
else
{
blnRestartProgram = true;
}
strDownLoadFileName += "_";
}
intProgressBarMaxValue = Convert.ToInt32(FilesDataView[intRow]["MAX_FILE_CHUNK_NO"]);
frmReadWriteFile.prbFileProgress.Maximum = intProgressBarMaxValue;
frmReadWriteFile.prbFileProgress.Value = 0;
frmReadWriteFile.lblFileName.Text = strDownLoadFileName;
bytFileBytes = new byte[Convert.ToInt32(FilesDataView[intRow]["FILE_SIZE_COMPRESSED"])];
lngFileStartOffset = 0;
for (int intChunkRow = 1; intChunkRow <= Convert.ToInt32(FilesDataView[intRow]["MAX_FILE_CHUNK_NO"]); intChunkRow++)
{
objParm = new object[2];
objParm[0] = FilesDataView[intRow]["FILE_NAME"].ToString();
objParm[1] = intChunkRow;
pvtblnLocalWebService = true;
bytTempBytes = (byte[])clsISClientUtilities.DynamicFunction("Get_File_Chunk", objParm, false);
this.pvtTempDataSet = clsISClientUtilities.DeCompress_Array_To_DataSet(bytTempBytes);
bytFileChunkBytes = (byte[])pvtTempDataSet.Tables["FileChunk"].Rows[0]["FILE_CHUNK"];
Array.Copy(bytFileChunkBytes, 0, bytFileBytes, lngFileStartOffset, bytFileChunkBytes.Length);
lngFileStartOffset += bytFileChunkBytes.Length;
frmReadWriteFile.prbAllFileProgress.Value += 1;
frmReadWriteFile.prbFileProgress.Value += 1;
this.Refresh();
Application.DoEvents();
}
bytDecompressedBytes = null;
bytDecompressedBytes = new byte[Convert.ToInt32(FilesDataView[intRow]["FILE_SIZE"])];
//Open Memory Stream with Compressed Data
MemoryStream msMemoryStream = new MemoryStream(bytFileBytes);
System.IO.Compression.GZipStream GZipStreamDecompress = new GZipStream(msMemoryStream, CompressionMode.Decompress);
//Decompress Bytes
brBinaryReader = new BinaryReader(GZipStreamDecompress);
bytDecompressedBytes = brBinaryReader.ReadBytes(Convert.ToInt32(FilesDataView[intRow]["FILE_SIZE"]));
if (FilesDataView[intRow]["FILE_CRC_VALUE"].ToString() != "")
{
//CRC32 Value
string strCRC32Value = "";
foreach (byte b in clsCrc32.ComputeHash(bytDecompressedBytes))
{
strCRC32Value += b.ToString("x2").ToLower();
}
if (strCRC32Value != FilesDataView[intRow]["FILE_CRC_VALUE"].ToString())
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Client CRC File Error\n\nTry Re-Login\n\nIf Problem Persists, Speak to Administrator.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
this.Close();
return;
}
}
fsFileStream = null;
bwBinaryWriter = null;
fsFileStream = new FileStream(strApplicationPath + strDownLoadFileName, FileMode.Create);
bwBinaryWriter = new BinaryWriter(fsFileStream);
bwBinaryWriter.Write(bytDecompressedBytes);
//Write Memory Portion To Disk
bwBinaryWriter.Close();
File.SetLastWriteTime(strApplicationPath + strDownLoadFileName, Convert.ToDateTime(FilesDataView[intRow]["FILE_LAST_UPDATED_DATE"]));
while (dtMinLoopTime > DateTime.Now)
{
this.Refresh();
Application.DoEvents();
}
this.Refresh();
Application.DoEvents();
}
frmReadWriteFile.Close();
frmReadWriteFile.Dispose();
}
}
pvtDataSet.Tables.Remove(pvtDataSet.Tables["Files"]);
if (blnRestartProgram == true
| pvtDataSet.Tables["ReturnValues"].Rows[0]["REBOOT_IND"].ToString() == "Y")
{
bool blnCloseProgram = true;
if (pvtDataSet.Tables["ReturnValues"].Rows[0]["REBOOT_IND"].ToString() == "Y")
{
frmRestartService frmRestartService = new frmRestartService(pvtDataSet.Tables["ReturnValues"].Rows[0]["MACHINE_NAME"].ToString(), pvtDataSet.Tables["ReturnValues"].Rows[0]["MACHINE_IP"].ToString());
frmRestartService.Show();
try
{
clsRestartFingerPrintClockTimeAttendanceService clsRestartFingerPrintClockTimeAttendanceService;
if (AppDomain.CurrentDomain.GetData("URLClientPath").ToString() != "")
{
//Calls Web Service Internally
clsRestartFingerPrintClockTimeAttendanceService = new clsRestartFingerPrintClockTimeAttendanceService("");
InteractPayrollClient.Restart Restart = (InteractPayrollClient.Restart)clsRestartFingerPrintClockTimeAttendanceService.DynamicFunction("RestartFingerPrintClockTimeAttendanceService", null);
if (Restart.OK == "Y")
{
if (blnRestartProgram == false)
{
blnCloseProgram = false;
}
}
else
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Failed to Restart 'FingerPrintClockTimeAttendanceService' Service.\n\nSpeak to System Administrator.\n\nReboot of Machine '" + pvtDataSet.Tables["ReturnValues"].Rows[0]["MACHINE_NAME"].ToString() + "' (IP = " + pvtDataSet.Tables["ReturnValues"].Rows[0]["MACHINE_IP"].ToString() + ")\n will Allow you to Continue.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
}
}
else
{
clsRestartFingerPrintClockTimeAttendanceService = new clsRestartFingerPrintClockTimeAttendanceService("FingerPrintClockServiceStartStop");
object Restart = clsRestartFingerPrintClockTimeAttendanceService.DynamicFunction("RestartFingerPrintClockTimeAttendanceService", null);
string strRestart = Restart.ToString();
if (strRestart.IndexOf("FingerPrintClockServer.Restart") > -1)
{
//Not Really True
if (blnRestartProgram == false)
{
blnCloseProgram = false;
}
}
else
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Failed to Restart 'FingerPrintClockTimeAttendanceService' Service.\n\nSpeak to System Administrator.\n\nReboot of Machine '" + pvtDataSet.Tables["ReturnValues"].Rows[0]["MACHINE_NAME"].ToString() + "' (IP = " + pvtDataSet.Tables["ReturnValues"].Rows[0]["MACHINE_IP"].ToString() + ")\n will Allow you to Continue.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
}
}
}
catch
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Failed to Restart 'FingerPrintClockTimeAttendanceService' Service.\n\nSpeak to System Administrator.\n\nReboot of Machine '" + pvtDataSet.Tables["ReturnValues"].Rows[0]["MACHINE_NAME"].ToString() + "' (IP = " + pvtDataSet.Tables["ReturnValues"].Rows[0]["MACHINE_IP"].ToString() + ")\n will Allow you to Continue.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
frmMessageBox.ShowDialog();
}
frmRestartService.Close();
}
if (blnRestartProgram == true)
{
InteractPayrollClient.CustomClientMessageBox frmMessageBox = new CustomClientMessageBox("Changes Have been Made to the Main Program.\nYou need to Restart the Program.", "Program Changes", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
frmMessageBox.ShowDialog();
}
if (blnCloseProgram == true)
{
this.Close();
return;
}
}
}
else
{
//2013-11-01
objParm = new object[5];
objParm[0] = Convert.ToInt64(pvtDataSet.Tables["ReturnValues"].Rows[0]["USER_NO"]);
objParm[1] = this.txtUserId.Text.Trim().ToUpper();
if (AppDomain.CurrentDomain.GetData("NewPassword") != null)
{
objParm[2] = AppDomain.CurrentDomain.GetData("NewPassword");
}
else
{
objParm[2] = this.txtPassword.Text.Trim().ToUpper();
}
//Access Ind
objParm[3] = pvtDataSet.Tables["ReturnValues"].Rows[0]["ACCESS_IND"].ToString();
string strCompanies = "";
if (pvtDataSet.Tables["ReturnValues"].Rows[0]["ACCESS_IND"].ToString() != "S")
{
for (int intRow = 0; intRow < pvtDataSet.Tables["CompanyAccess"].Rows.Count; intRow++)
{
if (intRow == 0)
{
strCompanies = pvtDataSet.Tables["CompanyAccess"].Rows[intRow]["COMPANY_NO"].ToString();
}
else
{
strCompanies += "#" + pvtDataSet.Tables["CompanyAccess"].Rows[intRow]["COMPANY_NO"].ToString();
}
}
}
objParm[4] = strCompanies;
clsISClientUtilities.DynamicFunction("Update_New_User_Details_From_Internet", objParm, false);
}
Close_SplasScreen_And_Show_Main();
}
}
}
}
}
}
}
catch (Exception eException)
{
this.Cursor = Cursors.Default;
this.txtUserId.Enabled = true;
this.txtPassword.Enabled = true;
this.btnOK.Enabled = true;
if (pvtblnLocalWebService == true)
{
clsISClientUtilities.ErrorHandler(eException);
}
else
{
clsISUtilities.ErrorHandler(eException);
}
//this.Close();
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
DialogResult myDialogResult = CustomClientMessageBox.Show("Are you sure you want to Restore this Database?",
this.Text,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (myDialogResult == System.Windows.Forms.DialogResult.Yes)
{
this.btnOK.Enabled = false;
pvtintProcess = 0;
grbActivationProcess.Visible = true;
this.pnlRestoreDatabase.Visible = false;
this.picBackupBefore.Image = (Image)global::InteractPayrollClient.Properties.Resources.Question;
this.picRestoreDatabase.Image = null;
DateTime dtWaitTime = DateTime.Now.AddSeconds(3);
this.tmrTimer.Enabled = true;
int intReturnCode = 0;
intReturnCode = (int)clsISClientUtilities.DynamicFunction("Backup_DataBase_Before_Restore", null, false);
this.tmrTimer.Enabled = false;
this.picBackupBefore.Visible = true;
if (intReturnCode == 0)
{
while (dtWaitTime > DateTime.Now)
{
Application.DoEvents();
}
dtWaitTime = DateTime.Now.AddSeconds(3);
this.picBackupBefore.Image = (Image)global::InteractPayrollClient.Properties.Resources.Ok;
pvtintProcess += 1;
this.pnlRestoreDatabase.Visible = true;
this.picRestoreDatabase.Image = (Image)global::InteractPayrollClient.Properties.Resources.Question;
this.tmrTimer.Enabled = true;
object[] objParm = new object[1];
objParm[0] = dgvFilesDataGridView[1, dgvFilesDataGridView.SelectedRows[0].Index].Value.ToString();
intReturnCode = (int)clsISClientUtilities.DynamicFunction("Restore_DataBase", objParm, false);
this.tmrTimer.Enabled = false;
this.picRestoreDatabase.Visible = true;
while (dtWaitTime > DateTime.Now)
{
Application.DoEvents();
}
if (intReturnCode == 0)
{
this.picRestoreDatabase.Image = (Image)global::InteractPayrollClient.Properties.Resources.Ok;
this.Refresh();
CustomClientMessageBox.Show("Restore Successful.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
this.picRestoreDatabase.Image = (Image)global::InteractPayrollClient.Properties.Resources.Error;
this.Refresh();
CustomClientMessageBox.Show("Restore Failed.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
else
{
this.picBackupBefore.Image = (Image)global::InteractPayrollClient.Properties.Resources.Error;
CustomClientMessageBox.Show("Backup of Database Before Restore Failed.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
Load_Restore_Files();
this.grbActivationProcess.Visible = false;
}
}
catch (Exception eException)
{
clsISClientUtilities.ErrorHandler(eException);
}
}
public void btnSave_Click(object sender, System.EventArgs e)
{
try
{
if (this.txtGroup.Text.Trim() == "")
{
CustomClientMessageBox.Show("Enter Group Description.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtGroup.Focus();
return;
}
if (this.dgvEmployeeLinkedDataGridView.Rows.Count == 0)
{
CustomClientMessageBox.Show("Select Employees.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.btnAdd.Focus();
return;
}
if (this.Text.IndexOf(" - New") > 0)
{
pvtintGroupNo = 0;
}
//NB - New Will Not Remove Any Records
DataView EmployeeLinkDataView = new DataView(pvtDataSet.Tables["EmployeeLink"], "GROUP_NO = " + pvtintGroupNo + " AND COMPANY_NO = " + pvtint64CompanyNo, "", DataViewRowState.CurrentRows);
for (int intRow = 0; intRow < EmployeeLinkDataView.Count; intRow++)
{
EmployeeLinkDataView[intRow].Delete();
intRow -= 1;
}
pvtDataSet.AcceptChanges();
for (int intRowCount = 0; intRowCount < this.dgvEmployeeLinkedDataGridView.Rows.Count; intRowCount++)
{
DataRowView drvDataRowView = EmployeeLinkDataView.AddNew();
drvDataRowView["GROUP_NO"] = pvtintGroupNo;
drvDataRowView["COMPANY_NO"] = pvtint64CompanyNo;
drvDataRowView["EMPLOYEE_NO"] = Convert.ToInt32(this.dgvEmployeeLinkedDataGridView[pvtintEmployeeNoCol, intRowCount].Value);
drvDataRowView["PAY_CATEGORY_NO"] = Convert.ToInt32(this.dgvEmployeeLinkedDataGridView[pvtintPayCategoryNoCol, intRowCount].Value);
drvDataRowView["PAY_CATEGORY_TYPE"] = this.dgvEmployeeLinkedDataGridView[pvtintPayCategoryTypeCol, intRowCount].Value.ToString();
drvDataRowView.EndEdit();
}
DataSet TempDataSet = new DataSet();
//Add EmployeePayCategory Table
TempDataSet.Tables.Add(pvtDataSet.Tables["EmployeeLink"].Clone());
for (int intRow = 0; intRow < EmployeeLinkDataView.Count; intRow++)
{
TempDataSet.Tables["EmployeeLink"].ImportRow(EmployeeLinkDataView[intRow].Row);
}
//Compress DataSet
byte[] pvtbytCompress = clsISClientUtilities.Compress_DataSet(TempDataSet);
this.Cursor = Cursors.WaitCursor;
if (this.Text.IndexOf(" - New") > 0)
{
object[] objParm = new object[3];
objParm[0] = pvtint64CompanyNo;
objParm[1] = this.txtGroup.Text.Trim();
objParm[2] = pvtbytCompress;
pvtintGroupNo = (int)clsISClientUtilities.DynamicFunction("Insert_Group", objParm, true);
for (int intRowCount = 0; intRowCount < EmployeeLinkDataView.Count; intRowCount++)
{
EmployeeLinkDataView[intRowCount]["GROUP_NO"] = pvtintGroupNo;
intRowCount -= 1;
}
DataRowView drvDataRowView = this.pvtGroupDataView.AddNew();
//Set Key for Find
drvDataRowView["COMPANY_NO"] = pvtDataSet.Tables["Company"].Rows[pvtintCompanyDataTableRow]["COMPANY_NO"].ToString();
drvDataRowView["GROUP_DESC"] = this.txtGroup.Text.Trim();
drvDataRowView["GROUP_NO"] = pvtintGroupNo;
drvDataRowView.EndEdit();
}
else
{
object[] objParm = new object[4];
objParm[0] = Convert.ToInt64(pvtDataSet.Tables["Company"].Rows[pvtintCompanyDataTableRow]["COMPANY_NO"]);
objParm[1] = pvtintGroupNo;
objParm[2] = this.txtGroup.Text.Trim();
objParm[3] = pvtbytCompress;
clsISClientUtilities.DynamicFunction("Update_Group", objParm, true);
this.dgvGroupDataGridView[0, this.dgvGroupDataGridView.CurrentRow.Index].Value = this.txtGroup.Text.Trim();
pvtGroupDataView[pvtintGroupDataViewRow]["GROUP_DESC"] = this.txtGroup.Text.Trim();
}
pvtDataSet.AcceptChanges();
if (this.Text.IndexOf(" - New") > 0)
{
Load_CurrentForm_Records();
}
btnCancel_Click(sender, e);
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
clsISClientUtilities.ErrorHandler(ex);
}
}
