public void ProcessPayrollRunFromQueue(RunQueue runQueue) { if (runQueue.PayCategoryType == "T") { busTimeAttendanceRun.Calculate_TimeAttendance_From_TimeSheets(runQueue.UserNo, runQueue.CompanyNo, runQueue.PayCategoryNumberArray, runQueue.PayCategoryType, runQueue.PayPeriodDate); } else { busTimeAttendanceRun.Calculate_Payroll_From_TimeSheets(runQueue.UserNo, runQueue.CompanyNo, runQueue.PayCategoryNumberArray, runQueue.PayCategoryType, runQueue.PayPeriodDate); } }
private void ProcessRunQueue() { DataSet DataSetProcessRunQueue = new DataSet(); int intWhere = 0; try { StringBuilder strQry = new StringBuilder(); strQry.Clear(); strQry.AppendLine(" SELECT TOP 2 "); strQry.AppendLine(" USER_NO"); strQry.AppendLine(",COMPANY_NO"); strQry.AppendLine(",PAY_CATEGORY_TYPE"); strQry.AppendLine(",PAY_PERIOD_DATE"); strQry.AppendLine(",PAY_CATEGORY_NUMBERS"); strQry.AppendLine(" FROM InteractPayroll.dbo.PAYROLL_RUN_QUEUE"); strQry.AppendLine(" WHERE PAYROLL_RUN_QUEUE_IND IS NULL"); intWhere = 1; clsDBConnectionObjectsProcessRunQueue.Create_DataTable(strQry.ToString(), DataSetProcessRunQueue, "JobQueue", -1); intWhere = 2; if (DataSetProcessRunQueue.Tables["JobQueue"].Rows.Count > 0) { intWhere = 3; List <RunQueue> runQueueList = new List <RunQueue>(); intWhere = 4; for (int intRow = 0; intRow < DataSetProcessRunQueue.Tables["JobQueue"].Rows.Count; intRow++) { intWhere = 5; RunQueue runQueue = new RunQueue(); runQueue.UserNo = Convert.ToInt64(DataSetProcessRunQueue.Tables["JobQueue"].Rows[intRow]["USER_NO"]); runQueue.CompanyNo = Convert.ToInt64(DataSetProcessRunQueue.Tables["JobQueue"].Rows[intRow]["COMPANY_NO"]); runQueue.PayCategoryType = DataSetProcessRunQueue.Tables["JobQueue"].Rows[intRow]["PAY_CATEGORY_TYPE"].ToString(); runQueue.PayCategoryNumberArray = DataSetProcessRunQueue.Tables["JobQueue"].Rows[intRow]["PAY_CATEGORY_NUMBERS"].ToString(); runQueue.PayPeriodDate = Convert.ToDateTime(DataSetProcessRunQueue.Tables["JobQueue"].Rows[intRow]["PAY_PERIOD_DATE"]); intWhere = 6; runQueueList.Add(runQueue); } intWhere = 7; ProcessRunQueueParallel(runQueueList); } } catch (Exception ex) { WriteExceptionErrorLog("ProcessRunQueue " + intWhere.ToString(), ex); } finally { DataSetProcessRunQueue.Dispose(); } }