public List <RiseDTO> GetRiseRelations()
{
List <RiseDTO> lLstRiseDTO = new List <RiseDTO>();
Recordset lObjRecordset = null;
try
{
lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset);
string lStrQuery = this.GetSQL("GetRelationsFolios");
lObjRecordset.DoQuery(lStrQuery);
if (lObjRecordset.RecordCount > 0)
{
for (int i = 0; i < lObjRecordset.RecordCount; i++)
{
RiseDTO lObjRiseDTO = new RiseDTO
{
Code = int.Parse(lObjRecordset.Fields.Item("Code").Value.ToString()),
Client = lObjRecordset.Fields.Item("U_Client").Value.ToString(),
CreatedDate = DateTime.Parse(lObjRecordset.Fields.Item("U_CreatedDate").Value.ToString()),
FolioRelation = int.Parse(lObjRecordset.Fields.Item("U_DocRef").Value.ToString()),
DocStatus = (RiseStatusEnum)int.Parse(lObjRecordset.Fields.Item("U_DocStatus").Value.ToString()),
IdRise = int.Parse(lObjRecordset.Fields.Item("U_IdRise").Value.ToString()),
SupervisorId = int.Parse(lObjRecordset.Fields.Item("U_Supervisor").Value.ToString()),
UserId = int.Parse(lObjRecordset.Fields.Item("U_UserId").Value.ToString()),
ClientName = lObjRecordset.Fields.Item("ClientName").Value.ToString(),
};
lLstRiseDTO.Add(lObjRiseDTO);
lObjRecordset.MoveNext();
}
}
}
catch (Exception lObjException)
{
LogService.WriteError(string.Format("[RiseDAO - GetRiseRelations: {0}]", lObjException.Message));
throw new DAOException(lObjException.Message, lObjException);
}
finally
{
MemoryUtility.ReleaseComObject(lObjRecordset);
}
return(lLstRiseDTO);
}
public RiseDTO GetRiseById(int pIntRiseId)
{
RiseDTO lObjRiseDTO = null;
Recordset lObjRecordset = null;
try
{
lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset);
string lStrQuery = this.GetSQL("GetRiseById").InjectSingleValue("RiseId", pIntRiseId.ToString());
lObjRecordset.DoQuery(lStrQuery);
if (lObjRecordset.RecordCount > 0)
{
lObjRiseDTO = new RiseDTO
{
Code = int.Parse(lObjRecordset.Fields.Item("Code").Value.ToString()),
IdRise = int.Parse(lObjRecordset.Fields.Item("U_IdRise").Value.ToString()),
CreatedDate = DateTime.Parse(lObjRecordset.Fields.Item("U_CreatedDate").Value.ToString()),
StartDate = DateTime.Parse(lObjRecordset.Fields.Item("U_StartDate").Value.ToString()),
EndDate = DateTime.Parse(lObjRecordset.Fields.Item("U_EndDate").Value.ToString()),
Client = lObjRecordset.Fields.Item("U_Client").Value.ToString(),
ClientName = lObjRecordset.Fields.Item("CardName").Value.ToString(),
SupervisorId = int.Parse(lObjRecordset.Fields.Item("U_Supervisor").Value.ToString()),
SupervisorName = lObjRecordset.Fields.Item("SupervisorName").Value.ToString(),
DocStatus = (RiseStatusEnum)int.Parse(lObjRecordset.Fields.Item("U_DocStatus").Value.ToString()),
FolioRelation = int.Parse(lObjRecordset.Fields.Item("U_DocRef").Value.ToString()),
UserId = int.Parse(lObjRecordset.Fields.Item("U_UserId").Value.ToString()),
};
}
}
catch (Exception lObjException)
{
LogService.WriteError(string.Format("[RiseDAO - GetRiseById: {0}]", lObjException.Message));
throw new DAOException(lObjException.Message, lObjException);
}
finally
{
MemoryUtility.ReleaseComObject(lObjRecordset);
}
return(lObjRiseDTO);
}
public Rise ToEntity(RiseDTO pObjRise)
{
if (pObjRise == null)
{
return(null);
}
return(new Rise
{
RowCode = pObjRise.Code.ToString(),
IdRise = pObjRise.IdRise,
CreatedDate = pObjRise.CreatedDate,
StartDate = pObjRise.StartDate,
EndDate = pObjRise.EndDate,
Client = pObjRise.Client,
Supervisor = pObjRise.SupervisorId,
DocStatus = (int)pObjRise.DocStatus,
DocRef = pObjRise.FolioRelation,
UserId = pObjRise.UserId,
});
}
