private TASK_MATRIXDC FillObject(DataRow row, int onHoldReasonsCount) { TASK_MATRIXDC taskMatrixDC = new TASK_MATRIXDC(); taskMatrixDC.JOB_ID = (int)row["JOB_ID"]; taskMatrixDC.PROJECT_ID = (int)row["PROJECT_ID"]; taskMatrixDC.HYLAN_PROJECT_ID = Convert.ToString(row["HYLAN_PROJECT_ID"]); taskMatrixDC.JOB_FILE_NUMBER = Convert.ToString(row["JOB_FILE_NUMBER"]); taskMatrixDC.CLIENT_NAME = Convert.ToString(row["CLIENT_NAME"]); taskMatrixDC.NEEDED_TASKS_COUNT = (int)row["NEEDED_TASKS_COUNT"]; taskMatrixDC.TASK_NAME = Convert.ToString(row["TASK_NAME"]); taskMatrixDC.ON_HOLD_REASONS = new List <DD_DTO>(); for (int colInd = row.Table.Columns.Count - 1; colInd >= (row.Table.Columns.Count - onHoldReasonsCount); colInd--) { DD_DTO onHoldReason = new DD_DTO(); onHoldReason.TEXT = row.Table.Columns[colInd].ColumnName.Replace(" ", "_").ToUpper(); if (row.Table.Columns[colInd].ColumnName == "ON_HOLD_REASON_OTHER") { onHoldReason.TEXT2 = Convert.ToString(row[row.Table.Columns[colInd].ColumnName]); } else { onHoldReason.VALUE = (int)row[row.Table.Columns[colInd].ColumnName]; } taskMatrixDC.ON_HOLD_REASONS.Add(onHoldReason); } //taskMatrixDC.REASON_A = (int)row["REASON_A"]; //taskMatrixDC.REASON_B = (int)row["REASON_B"]; //taskMatrixDC.Other = (int)row["Other"]; //taskMatrixDC.ON_HOLD_REASON_OTHER = Convert.ToString(row["ON_HOLD_REASON_OTHER"]); return(taskMatrixDC); }
public List <DD_DTO> GetJobFileNumbers(DBConnection Connection, string projectIDs) { List <DD_DTO> objDD_DTO = new List <DD_DTO>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_MANAGE_JOBSGetJobNumbers"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_PROJECT_IDs", DbType.String, projectIDs); DataSet ds = new DataSet(); if (Connection.Transaction != null) { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } foreach (DataRow drRow in ds.Tables[0].Rows) { DD_DTO DD_DTO = new DD_DTO(); if (drRow.Table.Columns.Contains("JOB_ID")) { DD_DTO.VALUE = Convert.ToInt32(drRow["JOB_ID"]); } if (drRow.Table.Columns.Contains("JOB_FILE_NUMBER")) { DD_DTO.TEXT = Convert.ToString(drRow["JOB_FILE_NUMBER"]); } if (drRow.Table.Columns.Contains("JOB_STATUS_NAME")) { DD_DTO.TEXT2 = Convert.ToString(drRow["JOB_STATUS_NAME"]); } objDD_DTO.Add(DD_DTO); } return(objDD_DTO); }