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