/// <summary>
/// Gets a single MTA IP Addresses from the Database.
/// </summary>
/// <returns></returns>
public static VirtualMta.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.VirtualMTA>(cmd, CreateAndFillVirtualMtaFromRecord));
}
}
/// <summary>
/// Gets a Virtual MTA Group from the database; doesn't include Virtual MTA objects.
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
internal static VirtualMta.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 <VirtualMta.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));
}
}
