public List <HoursRecordsDTO> DataTableToDTO(SAPbouiCOM.DataTable pObjDataTable)
{
List <HoursRecordsDTO> lLstHoursRecords = new List <HoursRecordsDTO>();
for (int i = 0; i < pObjDataTable.Rows.Count; i++)
{
HoursRecordsDTO lObjHoursRecords = new HoursRecordsDTO();
lObjHoursRecords.Code = pObjDataTable.GetValue("CodeHrs", i).ToString();
lObjHoursRecords.IdRise = int.Parse(pObjDataTable.GetValue("IdRiHrs", i).ToString());
lObjHoursRecords.ContractEntry = int.Parse(pObjDataTable.GetValue("ContOVHrs", i).ToString());
lObjHoursRecords.ContractDocNum = int.Parse(pObjDataTable.GetValue("CDEOVHrs", i).ToString());
lObjHoursRecords.DateHour = DateTime.Parse(pObjDataTable.GetValue("DateHrs", i).ToString());
lObjHoursRecords.SupervisorId = int.Parse(pObjDataTable.GetValue("SupIdHrs", i).ToString());
lObjHoursRecords.Supervisor = pObjDataTable.GetValue("SupNmHrs", i).ToString();
lObjHoursRecords.OperatorId = int.Parse(pObjDataTable.GetValue("OpdIdHrs", i).ToString());
lObjHoursRecords.OperatorName = pObjDataTable.GetValue("OpdNmHrs", i).ToString();
lObjHoursRecords.PrcCode = pObjDataTable.GetValue("EqpHrs", i).ToString();
lObjHoursRecords.EcoNum = pObjDataTable.GetValue("NumEcnHrs", i).ToString();
lObjHoursRecords.HrFeet = double.Parse(pObjDataTable.GetValue("HrsFeetHr", i).ToString());
lObjHoursRecords.SectionId = int.Parse(pObjDataTable.GetValue("SctnIdHrs", i).ToString());
lObjHoursRecords.Section = pObjDataTable.GetValue("SctnNnHrs", i).ToString();
lObjHoursRecords.KmHt = double.Parse(pObjDataTable.GetValue("KmHcHrs", i).ToString());
lObjHoursRecords.Pending = double.Parse(pObjDataTable.GetValue("PendHrs", i).ToString());
lObjHoursRecords.Close = pObjDataTable.GetValue("CloseHrs", i).ToString();
lLstHoursRecords.Add(lObjHoursRecords);
}
return(lLstHoursRecords);
}
public List <HoursRecordsDTO> GetHoursRecordsByRiseId(int pIntRiseId)
{
List <HoursRecordsDTO> lLstHoursRecordsDTO = new List <HoursRecordsDTO>();
Recordset lObjRecordset = null;
try
{
lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset);
string lStrQuery = this.GetSQL("GetHoursUDTByRiseId").InjectSingleValue("RiseId", pIntRiseId.ToString());
lObjRecordset.DoQuery(lStrQuery);
if (lObjRecordset.RecordCount > 0)
{
for (int i = 0; i < lObjRecordset.RecordCount; i++)
{
HoursRecordsDTO lObjHoursRecordsDTO = new HoursRecordsDTO
{
Code = lObjRecordset.Fields.Item("Code").Value.ToString(),
ContractEntry = int.Parse(lObjRecordset.Fields.Item("DocEntry").Value.ToString()),
ContractDocNum = int.Parse(lObjRecordset.Fields.Item("DocNum").Value.ToString()),
IdRise = int.Parse(lObjRecordset.Fields.Item("U_IdRise").Value.ToString()),
DateHour = DateTime.Parse(lObjRecordset.Fields.Item("U_DateHour").Value.ToString()),
SupervisorId = int.Parse(lObjRecordset.Fields.Item("U_Supervisor").Value.ToString()),
Supervisor = lObjRecordset.Fields.Item("SupervisorName").Value.ToString(),
OperatorId = int.Parse(lObjRecordset.Fields.Item("U_Operator").Value.ToString()),
OperatorName = lObjRecordset.Fields.Item("OperatorName").Value.ToString(),
PrcCode = lObjRecordset.Fields.Item("U_PrcCode").Value.ToString(),
EcoNum = lObjRecordset.Fields.Item("U_EcoNum").Value.ToString(),
HrFeet = double.Parse(lObjRecordset.Fields.Item("U_HrFeet").Value.ToString()),
SectionId = int.Parse(lObjRecordset.Fields.Item("U_Section").Value.ToString()),
Section = lObjRecordset.Fields.Item("SectionName").Value.ToString(), //string.Empty,
KmHt = double.Parse(lObjRecordset.Fields.Item("U_KmHt").Value.ToString()),
Pending = double.Parse(lObjRecordset.Fields.Item("U_Pending").Value.ToString()),
Close = lObjRecordset.Fields.Item("U_Close").Value.ToString(),
ContractClient = lObjRecordset.Fields.Item("ClientName").Value.ToString(),
};
lLstHoursRecordsDTO.Add(lObjHoursRecordsDTO);
lObjRecordset.MoveNext();
}
}
}
catch (Exception lObjException)
{
LogService.WriteError(string.Format("[HoursRecordsDAO - GetHoursRecordsByRiseId: {0}]", lObjException.Message));
throw new DAOException(lObjException.Message, lObjException);
}
finally
{
MemoryUtility.ReleaseComObject(lObjRecordset);
}
return(lLstHoursRecordsDTO);
}
