public string GetAccountCode(ConfigurationsEnum pEnumConfig) { string lStrAccountCode = string.Empty; Recordset lObjRecordset = null; try { lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset); string lStrQuery = this.GetSQL("GetAccountCode").InjectSingleValue("ParameterName", pEnumConfig.GetDescription()); lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { lStrAccountCode = lObjRecordset.Fields.Item("AcctCode").Value.ToString(); } } catch (Exception lObjException) { LogService.WriteError(string.Format("[ConfigurationsDAO - GetAccountCode: {0}]", lObjException.Message)); throw new DAOException(lObjException.Message, lObjException); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lStrAccountCode); }
public ConfigurationsDTO GetConfigurationByName(ConfigurationsEnum pEnumConfig) { ConfigurationsDTO lObjConfigurationsDTO = null; Recordset lObjRecordset = null; try { lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset); string lStrQuery = this.GetSQL("GetConfigByName").InjectSingleValue("ParameterName", pEnumConfig.GetDescription()); lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { lObjConfigurationsDTO = new ConfigurationsDTO { Code = int.Parse(lObjRecordset.Fields.Item("Code").Value.ToString()), Name = lObjRecordset.Fields.Item("Name").Value.ToString(), Value = lObjRecordset.Fields.Item("U_Value").Value.ToString(), Comments = lObjRecordset.Fields.Item("U_Comentario").Value.ToString(), }; } else { throw new Exception(string.Format("No se encontró la configuración {0}", pEnumConfig.GetDescription())); } } catch (Exception lObjException) { LogService.WriteError(string.Format("[ConfigurationsDAO - GetConfigurationByName: {0}]", lObjException.Message)); throw new DAOException(lObjException.Message, lObjException); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lObjConfigurationsDTO); }
public string GetAccountCode(ConfigurationsEnum pEnumConfig) { return(lObjConfigurationsDAO.GetAccountCode(pEnumConfig)); }
public ConfigurationsDTO GetConfigurationByName(ConfigurationsEnum pEnumConfig) { return(lObjConfigurationsDAO.GetConfigurationByName(pEnumConfig)); }