/// <summary> /// Gets a Virtual MTA Group from the database; doesn't include Virtual MTA objects. /// </summary> /// <param name="ID"></param> /// <returns></returns> public static VirtualMtaGroup GetVirtualMtaGroup(int id) { using (SqlConnection conn = MantaDB.GetSqlConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @" SELECT * FROM man_ip_group as [grp] WHERE [grp].ip_group_id = @groupID"; cmd.Parameters.AddWithValue("@groupID", id); return(DataRetrieval.GetSingleObjectFromDatabase <VirtualMtaGroup>(cmd, CreateAndFillVirtualMtaGroup)); } }
/// <summary> /// Gets a MantaEvent from the database. /// </summary> /// <returns>The event from the database of NULL if one wasn't found with the ID</returns> public static MantaEvent GetEvent(int ID) { using (SqlConnection conn = MantaDB.GetSqlConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT [evt].*, [bnc].evn_bounceCode_id, [bnc].evn_bounceEvent_message, [bnc].evn_bounceType_id FROM man_evn_event AS [evt] LEFT JOIN man_evn_bounceEvent AS [bnc] ON [evt].evn_event_id = [bnc].evn_event_id WHERE [evt].evn_event_id = @eventId"; cmd.Parameters.AddWithValue("@eventId", ID); return(DataRetrieval.GetSingleObjectFromDatabase <MantaEvent>(cmd, CreateAndFillMantaEventFromRecord)); } }
/// <summary> /// Gets a single MTA IP Addresses from the Database. /// </summary> /// <returns></returns> public static VirtualMTA GetVirtualMta(int id) { using (SqlConnection conn = MantaDB.GetSqlConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @" SELECT * FROM man_ip_ipAddress WHERE ip_ipAddress_id = @id"; cmd.Parameters.AddWithValue("@id", id); return(DataRetrieval.GetSingleObjectFromDatabase <VirtualMTA>(cmd, CreateAndFillVirtualMtaFromRecord)); } }