public static bool Exists(string subject, string senderEmail, DateTime receivedTime) { var result = false; var sqlEngine = new SqlEngine.Server(Constants.ConnectionString); using (var command = sqlEngine.Connection.CreateCommand()) { string queryString = @"SELECT TOP 1 id FROM emails"; queryString += @" WHERE sender_mail='" + senderEmail + "'"; queryString += @" AND subject='" + subject + "'"; queryString += @" AND received_at='" + sqlEngine.ConvertToSqlDateTimeFormat(receivedTime) + "'"; command.CommandType = CommandType.Text; command.CommandText = queryString; try { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var value = reader.GetValue(0); if (value != DBNull.Value) { result = true; } } } } catch (SqlException ex) { throw ex; } } sqlEngine.Dispose(); return(result); }
public static DateTime LastEmailReceived() { var result = DateTime.MinValue; var sqlEngine = new SqlEngine.Server(Constants.ConnectionString); using (var command = sqlEngine.Connection.CreateCommand()) { string queryString = @"SELECT TOP 1 option_value FROM options WHERE option_key='email_last_received'"; command.CommandType = CommandType.Text; command.CommandText = queryString; try { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var value = reader.GetValue(0); if (value != DBNull.Value) { result = DateTime.Parse(value.ToString()); } } } } catch (SqlException ex) { throw ex; } } sqlEngine.Dispose(); return(result); }