public static void DeleteFromDB(LoginUser loginUser, Guid systemEMailID) { EMailAlternateInbound result = new EMailAlternateInbound(loginUser); using (SqlCommand command = new SqlCommand()) { command.CommandText = "DELETE FROM EMailAlternateInbound WHERE (SystemEmailID = @SystemEmailID)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@SystemEmailID", systemEMailID); result.ExecuteNonQuery(command, "EMailAlternateInbound"); } }
public static EMailAlternateInboundItem GetEMailAlternateInboundItem(LoginUser loginUser, int systemEMailID) { EMailAlternateInbound eMailAlternateInbound = new EMailAlternateInbound(loginUser); eMailAlternateInbound.LoadBySystemEMailID(systemEMailID); if (eMailAlternateInbound.IsEmpty) { return(null); } else { return(eMailAlternateInbound[0]); } }
public static EMailAlternateInboundItem GetItem(LoginUser loginUser, Guid systemID) { EMailAlternateInbound result = new EMailAlternateInbound(loginUser); using (SqlCommand command = new SqlCommand()) { command.CommandText = @"SELECT eai.*, ISNULL(p.Name, 'Unassigned') AS ProductName, ISNULL(g.Name, 'Unassigned') AS GroupName, ISNULL(tt.Name, 'Unassigned') AS TicketTypeName FROM EMailAlternateInbound eai LEFT JOIN Products p ON p.ProductID = eai.ProductID LEFT JOIN Groups g ON g.GroupID = eai.GroupToAssign LEFT JOIN TicketTypes tt ON tt.TicketTypeID = eai.DefaultTicketType WHERE (eai.SystemEmailID = @SystemEmailID)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@SystemEmailID", systemID); result.Fill(command); } return(result.IsEmpty ? null : result[0]); }
public EMailAlternateInboundItem(DataRow row, EMailAlternateInbound eMailAlternateInbound) : base(row, eMailAlternateInbound) { _eMailAlternateInbound = eMailAlternateInbound; }