private void rbnFileOption_Click(object sender, EventArgs e)
{
RadioButton myRadioButton = (RadioButton)sender;
this.txtFilePath.Text = "";
if (myRadioButton.Name == "rbnBackupFile")
{
dgvUserDataGridView.Height -= intUserExtraHeight;
dgvSelectedUserDataGridView.Height -= intSelectedUserExtraHeight;
this.btnFile.Visible = false;
this.lblFilesHeader.Visible = true;
this.dgvFilesDataGridView.Visible = true;
string strPayrollRunDate = "";
try
{
byte[] byteCompress = (byte[])clsISClientUtilities.DynamicFunction("Get_Restore_Files", null, false);
pvtDataSet = null;
pvtDataSet = clsISClientUtilities.DeCompress_Array_To_DataSet(byteCompress);
this.dgvFilesDataGridView.Rows.Clear();
pvtblnFilesDataGridViewLoaded = false;
pvtDataView = null;
pvtDataView = new DataView(pvtDataSet.Tables["RestoreFiles"], "", "RESTORE_DATETIME DESC", DataViewRowState.CurrentRows);
for (int intRow = 0; intRow < pvtDataView.Count; intRow++)
{
if (pvtDataView[intRow]["RESTORE_DATETIME"] != System.DBNull.Value)
{
strPayrollRunDate = Convert.ToDateTime(pvtDataView[intRow]["RESTORE_DATETIME"]).ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
strPayrollRunDate = "";
}
this.dgvFilesDataGridView.Rows.Add(strPayrollRunDate,
pvtDataView[intRow]["RESTORE_FILE"].ToString());
}
pvtblnFilesDataGridViewLoaded = true;
if (this.dgvFilesDataGridView.Rows.Count > 0)
{
Set_DataGridView_SelectedRowIndex(dgvFilesDataGridView, 0);
}
}
catch (Exception ex)
{
}
}
else
{
//File
this.btnFile.Visible = true;
this.lblFilesHeader.Visible = false;
this.dgvFilesDataGridView.Visible = false;
dgvUserDataGridView.Height += intUserExtraHeight;
dgvSelectedUserDataGridView.Height += intSelectedUserExtraHeight;
}
}
static void Main(string[] args)
{
try
{
if (args.Length == 0)
{
pvtblnFromWindowsService = false;
}
if (pvtblnFromWindowsService == false)
{
Console.WriteLine("Entered ValiditeClockingsSyncViaDB");
}
Check_Log_For_Archiving();
string strConfig = AppDomain.CurrentDomain.BaseDirectory + "URLClientConfig.txt";
FileInfo fiFileInfo = new FileInfo(strConfig);
if (fiFileInfo.Exists == true)
{
StreamReader srStreamReader = File.OpenText(strConfig);
string strURLPath = srStreamReader.ReadLine();
srStreamReader.Close();
AppDomain.CurrentDomain.SetData("URLClientPath", strURLPath);
}
else
{
AppDomain.CurrentDomain.SetData("URLClientPath", "");
}
clsISClientUtilities = new clsISClientUtilities(null, "busValiditeClockingsSyncViaDB");
pvtDataSet = new DataSet();
object[] objParm = new object[1];
objParm[0] = "Hullo";
byte[] bytCompress = (byte[])clsISClientUtilities.DynamicFunction("Insert_Records", objParm, false);
pvtDataSet = clsISClientUtilities.DeCompress_Array_To_DataSet(bytCompress);
if (pvtDataSet.Tables["LinksMissing"].Rows.Count > 0)
{
if (pvtblnFromWindowsService == false)
{
Console.WriteLine("EMPLOYEES NOT LINKED START*********");
}
WriteLog("EMPLOYEES NOT LINKED START*********");
for (int intCount = 0; intCount < pvtDataSet.Tables["LinksMissing"].Rows.Count; intCount++)
{
if (pvtblnFromWindowsService == false)
{
Console.WriteLine("Employee " + pvtDataSet.Tables["LinksMissing"].Rows[intCount]["EMPLOYEE_NO"].ToString());
}
WriteLog("Employee " + pvtDataSet.Tables["LinksMissing"].Rows[intCount]["EMPLOYEE_NO"].ToString());
}
if (pvtblnFromWindowsService == false)
{
Console.WriteLine("EMPLOYEES NOT LINKED END*********");
}
WriteLog("EMPLOYEES NOT LINKED END*********");
}
if (pvtblnFromWindowsService == false)
{
Console.WriteLine("Number of Records Inserted = " + pvtDataSet.Tables["Clockings"].Rows.Count);
}
WriteLog("Number of Records Inserted = " + pvtDataSet.Tables["Clockings"].Rows.Count);
if (pvtblnFromWindowsService == false)
{
Console.WriteLine("Exit ValiditeClockingsSyncViaDB");
}
}
catch (Exception ex)
{
string strException = ex.Message;
if (ex.InnerException != null)
{
strException = strException + " " + ex.InnerException.Message;
}
if (pvtblnFromWindowsService == false)
{
Console.WriteLine("Exception = " + strException);
}
WriteExceptionLog("ClockingsService", ex);
}
finally
{
if (pvtblnFromWindowsService == false)
{
Console.ReadLine();
}
}
}
private void btnOK_Click(object sender, System.EventArgs e)
{
try
{
DialogResult dlgResult = CustomMessageBox.Show("Are you sure you want to Upload this Data?",
this.Text,
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
if (dlgResult == DialogResult.Yes)
{
string strPayCategoryWhere = "";
//DataSetClient = null;
//DataSetClient = new DataSet();
for (int intRow = 0; intRow < this.dgvPayCategoryDataGridView.Rows.Count; intRow++)
{
if (intRow == 0)
{
strPayCategoryWhere = " AND EPC.PAY_CATEGORY_NO IN (" + this.dgvPayCategoryDataGridView[5, intRow].Value.ToString();
}
else
{
strPayCategoryWhere += "," + this.dgvPayCategoryDataGridView[5, 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] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
objParm[1] = pvtstrPayrollType;
objParm[2] = strPayCategoryWhere;
objParm[3] = Convert.ToDateTime(this.pvtPayCategoryDataView[0]["TIMESHEET_UPLOAD_DATETIME"]).ToString("yyyy-MM-dd");
objParm[4] = pvtbytCompress;
blnclsISClientUtilities = 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")
{
CustomMessageBox.Show("There are Time Sheets with Errors on the Client Database.\n\nYou Need to Fix these TimeSheets on (Interact Time & Attendance 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] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
objParm[1] = pvtstrPayrollType;
objParm[2] = strPayCategoryWhere;
objParm[3] = Convert.ToDateTime(DataSetClient.Tables["Dates"].Rows[intRow]["TIMESHEET_DATE"]).ToString("yyyy-MM-dd");
blnclsISClientUtilities = true;
pvtbytCompress = (byte[])this.clsISClientUtilities.DynamicFunction("Get_Upload_Data_For_Day", objParm, false);
//Internet Database Insert
objParm = new object[6];
objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
objParm[1] = Convert.ToDateTime(DataSetClient.Tables["Dates"].Rows[intRow]["TIMESHEET_DATE"]);
objParm[2] = pvtbytCompress;
objParm[3] = pvtstrPayrollType;
objParm[4] = Convert.ToDateTime(this.pvtPayCategoryDataView[0]["PAY_PERIOD_DATE"]).ToString("yyyy-MM-dd");
objParm[5] = Convert.ToDateTime(this.pvtPayCategoryDataView[0]["TIMESHEET_UPLOAD_DATETIME"]).ToString("yyyy-MM-dd");
blnclsISClientUtilities = false;
string strUploadDateTime = (string)clsISUtilities.DynamicFunction("Insert_TimeSheet_Records", objParm, false);
//Update Client PAYCATEGORY Records with Date TimeStamp
objParm = new object[3];
objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
objParm[1] = strUploadDateTime;
objParm[2] = pvtbytCompress;
blnclsISClientUtilities = true;
this.clsISClientUtilities.DynamicFunction("Update_PayCategory_Last_Upload_DateTime", objParm, false);
this.pgbProgressBar.Value += 1;
}
this.Refresh();
objParm = new object[3];
objParm[0] = Convert.ToInt64(AppDomain.CurrentDomain.GetData("CompanyNo"));
objParm[1] = pvtstrPayrollType;
objParm[2] = strPayCategoryWhere;
blnclsISClientUtilities = true;
this.clsISClientUtilities.DynamicFunction("Move_Data_To_History_And_Cleanup", objParm, false);
this.pgbProgressBar.Value += 1;
this.Refresh();
CustomMessageBox.Show("Upload Successful.",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
CustomMessageBox.Show("There is NO Data to Upload",
this.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
this.grbUploadProgress.Visible = false;
}
}
catch (Exception eException)
{
if (blnclsISClientUtilities == true)
{
clsISClientUtilities.ErrorHandler(eException);
}
else
{
clsISUtilities.ErrorHandler(eException);
}
}
}
