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);
}
