//select query for favrouites table
public UserObject Favouriteselection(int user_id)
{
var selectQuery = "SELECT * FROM " + TableFavourite + " WHERE " + ColumnId + " ='" + user_id + "'";
ICursor c = dbWritablObject.RawQuery(selectQuery, null);
UserObject user;
while (c.MoveToNext())
{
var idInfo = c.GetInt(c.GetColumnIndexOrThrow(ColumnId));
System.Console.WriteLine("Value of id : " + idInfo);
var nameInfo = c.GetString(c.GetColumnIndexOrThrow(ColumnName));
System.Console.WriteLine("Value of name : " + nameInfo);
var addressInfo = c.GetString(c.GetColumnIndexOrThrow(ColumnAddress));
System.Console.WriteLine("Value of address : " + addressInfo);
var dayInfo = c.GetString(c.GetColumnIndexOrThrow(ColumnDay));
System.Console.WriteLine("Value of day : " + dayInfo);
var priceInfo = c.GetInt(c.GetColumnIndexOrThrow(ColumnPrice));
System.Console.WriteLine("Value of price : " + priceInfo);
var categoryInfo = c.GetString(c.GetColumnIndexOrThrow(ColumnCategory));
System.Console.WriteLine("Value of category : " + categoryInfo);
if (user_id.Equals(idInfo))
{
user = new UserObject(idInfo, nameInfo, addressInfo, dayInfo, priceInfo, categoryInfo);
c.Close();
return(user);
}
}
return(null);
}