public void ProcessOpenRunFromQueue(OpenRunQueue openRunQueue) { if (openRunQueue.PayCategoryType == "W") { busOpenPayrollRun.Insert_Wage_Run_Records(openRunQueue.CompanyNo, openRunQueue.PayPeriodDate, openRunQueue.PayCategoryNumberArray); } else { if (openRunQueue.PayCategoryType == "S") { busOpenPayrollRun.Insert_Salary_Run_Records(openRunQueue.CompanyNo, openRunQueue.PayPeriodDate, openRunQueue.PayCategoryNumberArray); } else { busOpenPayrollRun.Insert_TimeAttendance_Run_Records(openRunQueue.CompanyNo, openRunQueue.PayPeriodDate, openRunQueue.PayCategoryNumberArray); } } }
private void ProcessOpenRunQueue() { DataSet DataSetProcessOpenRunQueue = 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.OPEN_RUN_QUEUE"); strQry.AppendLine(" WHERE OPEN_RUN_QUEUE_IND IS NULL"); intWhere = 1; clsDBConnectionObjectsProcessOpenRunQueue.Create_DataTable(strQry.ToString(), DataSetProcessOpenRunQueue, "OpenRunQueue", -1); intWhere = 2; if (DataSetProcessOpenRunQueue.Tables["OpenRunQueue"].Rows.Count > 0) { List <OpenRunQueue> openRunQueueList = new List <OpenRunQueue>(); intWhere = 3; for (int intRow = 0; intRow < DataSetProcessOpenRunQueue.Tables["OpenRunQueue"].Rows.Count; intRow++) { OpenRunQueue openRunQueue = new OpenRunQueue(); openRunQueue.UserNo = Convert.ToInt64(DataSetProcessOpenRunQueue.Tables["OpenRunQueue"].Rows[intRow]["USER_NO"]); openRunQueue.CompanyNo = Convert.ToInt64(DataSetProcessOpenRunQueue.Tables["OpenRunQueue"].Rows[intRow]["COMPANY_NO"]); openRunQueue.PayCategoryType = DataSetProcessOpenRunQueue.Tables["OpenRunQueue"].Rows[intRow]["PAY_CATEGORY_TYPE"].ToString(); openRunQueue.PayCategoryNumberArray = DataSetProcessOpenRunQueue.Tables["OpenRunQueue"].Rows[intRow]["PAY_CATEGORY_NUMBERS"].ToString(); openRunQueue.PayPeriodDate = Convert.ToDateTime(DataSetProcessOpenRunQueue.Tables["OpenRunQueue"].Rows[intRow]["PAY_PERIOD_DATE"]); intWhere = 4; openRunQueueList.Add(openRunQueue); } intWhere = 5; ProcessOpenRunQueueParallel(openRunQueueList); } } catch (Exception ex) { WriteExceptionErrorLog("ProcessOpenRunQueue " + intWhere.ToString(), ex); } finally { DataSetProcessOpenRunQueue.Dispose(); } }