private void Recipe_view_screen_Load(object sender, EventArgs e)
{
//Display the title that is being selected from the viewlist in the previous screen.
titleOfSelectedFood.Text = Listof_items_screen.foodTitle;
//titleOfSelectedFood.SelectionAlignment = HorizontalAlignment.Center;//Align Title text in the center.
//Create a list of this object to be filled with data from the database.
List <Database_Items_Class> itemsFromDb = new List <Database_Items_Class>();
//Search database Title and put all items with that title into a list.
string query = "SELECT * from recipies WHERE Title='" + Listof_items_screen.foodTitle + "'";
using (SQLiteCommand cmd = new SQLiteCommand(query, databaseObject.myConnection))
{
databaseObject.myConnection.Open();
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Database_Items_Class item = new Database_Items_Class(); //Create the object and fill it's variables with database data.
item.Title = reader.GetString(0);
item.Category = reader.GetString(1);
item.Ingredients = reader.GetString(2);
//ingredientsTextBox.Text = reader.GetString(2);
item.Description = reader.GetString(3);
itemsFromDb.Add(item);
//Display the corresponding database cells to the text boxes.
ingredientsTextBox.Text = item.Ingredients;
descriptionTextBox.Text = item.Description;
}
}
databaseObject.myConnection.Close();
}
}
public static void exportDB()
{
Database_Items_Class databaseObject = new Database_Items_Class(); //sqlite object
Directory.CreateDirectory(folder_Creation);
SQLiteDataReader reader;
string query = "SELECT * FROM recipies WHERE Title='" + Listof_items_screen.foodTitle + "'";
string strDelimiter = "\n";
string strFilePath = @"C:\Recipies\" + Listof_items_screen.foodTitle + "_recipe.txt";;
databaseObject.OpenConnection();
using (reader = new SQLiteCommand(query, databaseObject.myConnection).ExecuteReader())
{
if (reader.HasRows)
{
StringBuilder sb = new StringBuilder();
Object[] items = new Object[reader.FieldCount];
List <Database_Items_Class> itemsFromDb = new List <Database_Items_Class>();
Database_Items_Class item = new Database_Items_Class(); //Create the object and fill it's variables with database data.
while (reader.Read())
{
reader.GetValues(items);
item.Title = reader.GetString(0);
item.Category = reader.GetString(1);
item.Ingredients = reader.GetString(2);
//ingredientsTextBox.Text = reader.GetString(2);
item.Description = reader.GetString(3);
itemsFromDb.Add(item);
//Console.WriteLine(item.Ingredients);
// Using two sb.Append is better because if you
// concat the two strings it will first build a new string
// and then discard it after its use.
//sb.Append(strDelimiter);
//sb.Append(item.ToString());
}
//Write into txt file
sb.Append("Title: " + item.Title + "\n");
sb.Append("===========================================================================\n");
sb.Append("Ingredients: \n\n" + item.Ingredients + "\n");
sb.Append("===========================================================================\n");
sb.Append("Description: \n\n" + item.Description + "\n");
File.WriteAllText(strFilePath, sb.ToString());
}
}
databaseObject.CloseConnection();
}