public void DeleteFavorite(PhoneCall phoneCall)
{
DatabaseMgr dbMgr = new DatabaseMgr();
dbMgr.DeleteFavorite(phoneCall);
favoritesData = dbMgr.retrieveFavorites();
}
public KeyValuePair <List <string>, List <PhoneCall> > retrieveCallLog()
{
SQLiteConnection conn = new SQLiteConnection(DB_PATH);
//List<CallLogDB> retrievedTasks = conn.Table<CallLogDB>().ToList<CallLogDB>();
string query = "SELECT * FROM CallLog WHERE NOT EXISTS (SELECT * FROM FAVORITE WHERE FAVORITE.PHONENUMBER = CALLLOG.PHONENUMBER)";
List <CallLogDB> newCallLog = conn.Query <CallLogDB>(query);
List <string> phoneNumberList = new List <string>();
List <PhoneCall> phoneCallObjList = new List <PhoneCall>();
foreach (CallLogDB record in newCallLog)
{
PhoneCall phoneCall = new PhoneCall()
{
Name = record.Name,
CallDateTime = record.CallDateTime,
CallDateTimeStr = record.CallDateTime.ToString("d"),
PhoneNumber = record.PhoneNumber
};
phoneNumberList.Add(record.PhoneNumber);
phoneCallObjList.Add(phoneCall);
}
return(new KeyValuePair <List <string>, List <PhoneCall> >(phoneNumberList, phoneCallObjList));
}
public bool exists(PhoneCall phoneCall)
{
bool exists = false;
SQLiteConnection conn = new SQLiteConnection(DB_PATH);
string query = "SELECT * FROM Favorite WHERE FAVORITE.PHONENUMBER = " + phoneCall.PhoneNumber;
exists = conn.Find <FavoriteDB>(phoneCall.PhoneNumber) != null;
return(exists);
}
public void DeleteFavorite(PhoneCall phoneCall)
{
SQLiteConnection conn = new SQLiteConnection(DB_PATH);
FavoriteDB newfavorite = new FavoriteDB()
{
Name = phoneCall.Name,
PhoneNumber = phoneCall.PhoneNumber
};
conn.Delete <FavoriteDB>(newfavorite.PhoneNumber);
}
private void DeleteFavorite(object sender, RoutedEventArgs e)
{
MenuItem menuItem = (MenuItem)sender;
PhoneCall phoneDataContext = menuItem.DataContext as PhoneCall;
favorites.DeleteFavorite(phoneDataContext);
populateFavoritesList();
//var selected = (sender as MenuItem);
//MessageBox.Show("You chose to " + menuItem.Header.ToString(),"Result",MessageBoxButton.OK);
}
public void UpdateFavorite(PhoneCall phoneCall)
{
SQLiteConnection conn = new SQLiteConnection(DB_PATH);
FavoriteDB newfavorite = new FavoriteDB()
{
Name = phoneCall.Name,
PhoneNumber = phoneCall.PhoneNumber,
CallDateTimeStr = phoneCall.CallDateTimeStr
};
conn.Update(newfavorite);
}
public void AddCallLog(PhoneCall phoneCall)
{
SQLiteConnection conn = new SQLiteConnection(DB_PATH);
CallLogDB newCallLog = new CallLogDB()
{
Name = phoneCall.Name,
PhoneNumber = phoneCall.PhoneNumber,
CallDateTime = phoneCall.CallDateTime
};
conn.Insert(newCallLog);
}
public void AddFavorite(PhoneCall phoneCall)
{
SQLiteConnection conn = new SQLiteConnection(DB_PATH);
FavoriteDB newfavorite = new FavoriteDB()
{
Name = phoneCall.Name,
PhoneNumber = phoneCall.PhoneNumber,
CallDateTimeStr = phoneCall.CallDateTimeStr
};
conn.Insert(newfavorite);
//this.retrieveFavorites();
}
private List <PhoneCall> mineCallLog()
{
Dictionary <string, int> allCalls = new Dictionary <string, int>();
foreach (PhoneCall result in allCallLog)
{
if (!allCalls.ContainsKey(result.PhoneNumber))
{
allCalls.Add(result.PhoneNumber, 1);
}
else
{
int val = allCalls[result.PhoneNumber];
allCalls[result.PhoneNumber] = val + 1;
}
}
// Reverse sort.
// ... Can be looped over in the same way as above.
var items = from pair in allCalls
orderby pair.Value descending
select pair;
int count = 0;
mostFrequentNCalls = new List <PhoneCall>();
foreach (KeyValuePair <string, int> pair in items)
{
if (count < TopNFrequent)
{
int index = allPhoneNumList.IndexOf(pair.Key);
PhoneCall tmp = allCallLog[index];
mostFrequentNCalls.Add(tmp);
}
else
{
break;
}
count++;
Console.WriteLine("{0}: {1}", pair.Key, pair.Value);
}
return(mostFrequentNCalls);
}
public List <PhoneCall> retrieveFavorites()
{
SQLiteConnection conn = new SQLiteConnection(DB_PATH);
List <FavoriteDB> retrievedTasks = conn.Table <FavoriteDB>().ToList <FavoriteDB>();
List <PhoneCall> phoneCallList = new List <PhoneCall>();
foreach (FavoriteDB record in retrievedTasks)
{
PhoneCall phoneCall = new PhoneCall()
{
Name = record.Name,
PhoneNumber = record.PhoneNumber,
CallDateTimeStr = record.CallDateTimeStr
};
phoneCallList.Add(phoneCall);
}
return(phoneCallList);
}
public bool exists(PhoneCall phoneCall)
{
DatabaseMgr dbMgr = new DatabaseMgr();
return(dbMgr.exists(phoneCall));
}
public static void Update(PhoneCall phoneCall)
{
phoneCall.CallDateTimeStr = DateTime.Today.ToString("d");
new DatabaseMgr().UpdateFavorite(phoneCall);
}
public void AddFavorite(PhoneCall phoneCall)
{
new DatabaseMgr().AddFavorite(phoneCall);
favoritesData.Add(phoneCall);
}