internal NotificationProfileEntity GetNotificationProfileById(int id) { NotificationProfileEntity results = new NotificationProfileEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetNotificationProfileById"; sproc.StoredProceduresParameter.Add(GetParam("@NotificationProfileID", id.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { NotificationProfileAdapter ta = new NotificationProfileAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.AdaptItem(rw, dt); } } } catch (Exception) { throw; } return(results); }
internal List <NotificationProfileEntity> GetAllNotificationProfile() { List <NotificationProfileEntity> results = new List <NotificationProfileEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetAllNotificationProfile"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { NotificationProfileAdapter ta = new NotificationProfileAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.Adapt(dt); } } } catch (Exception) { throw; } return(results); }
internal List <NotificationProfileEntity> GetNotificationProfile(int CredentialId) { List <NotificationProfileEntity> results = new List <NotificationProfileEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetNotificationProfile"; sproc.StoredProceduresParameter.Add(GetParam("@CredentialId", CredentialId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.ReadWrite.ToString()); if (dt != null && dt.Rows.Count > 0) { results = new NotificationProfileAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }