示例#1
0
        private void fillDataGrid()
        {
            this.Enabled = false;

            LoadingWindow loadingWindow = new LoadingWindow();

            loadingWindow.Show();

            Application.DoEvents();

            DatabaseControl.ConnectDB();

            string           sql     = "SELECT * FROM recipes ORDER BY title ASC";
            SQLiteCommand    command = new SQLiteCommand(sql, DatabaseControl.m_dbConnection);
            SQLiteDataReader reader  = command.ExecuteReader();

            dataGridView1.Rows.Clear();
            dataGridView1.Refresh();
            while (reader.Read())
            {
                dataGridView1.Rows.Add();
                dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["id"].Value    = reader["id"];
                dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Title"].Value = reader["title"];

                Bitmap img;

                try
                {
                    System.Net.WebRequest request = System.Net.WebRequest.Create(reader["img"].ToString());
                    request.Timeout = 500;
                    System.Net.WebResponse response       = request.GetResponse();
                    System.IO.Stream       responseStream = response.GetResponseStream();
                    img = new Bitmap(responseStream);
                }
                catch (Exception ex)
                {
                    img = null;
                }

                dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Image"].Value            = img;
                dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Time"].Value             = reader["time"];
                dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Difficulty_level"].Value = reader["difficulty_level"];
            }

            ((DataGridViewImageColumn)dataGridView1.Columns[2]).ImageLayout = DataGridViewImageCellLayout.Stretch;

            DatabaseControl.DisonnectDB();

            this.Enabled = true;
            loadingWindow.Close();
        }
示例#2
0
        private void runAlgorithmButton_Click(object sender, EventArgs e)
        {
            Dictionary <string, string> MyIngredientsList = new Dictionary <string, string>();

            this.Enabled = false;

            LoadingWindow loadingWindow = new LoadingWindow();

            loadingWindow.Show();

            Application.DoEvents();

            DatabaseControl.ConnectDB();
            string           sql     = "SELECT * FROM my_ingredients";
            SQLiteCommand    command = new SQLiteCommand(sql, DatabaseControl.m_dbConnection);
            SQLiteDataReader reader  = command.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    MyIngredientsList.Add(reader["id"].ToString(), reader["count"].ToString());
                }

                DatabaseControl.DisonnectDB();
                DatabaseControl.ConnectDB();

                string ColumnNames = "pragma table_info(recipes)";
                command = new SQLiteCommand(ColumnNames, DatabaseControl.m_dbConnection);
                reader  = command.ExecuteReader();
                sql     = "SELECT * FROM recipes WHERE ";
                for (int i = 0; i < 7; ++i)
                {
                    reader.Read();
                }
                if (reader.HasRows)
                {
                    string IngredientColumn = reader["name"].ToString();
                    if (MyIngredientsList.ContainsKey(ColumnNameToId(IngredientColumn)))
                    {
                        sql += IngredientColumn + " <= " + MyIngredientsList[ColumnNameToId(IngredientColumn)].Replace(',', '.');
                    }
                    else
                    {
                        sql += IngredientColumn + " = 0.0";
                    }
                    while (reader.Read())
                    {
                        IngredientColumn = reader["name"].ToString();
                        if (MyIngredientsList.ContainsKey(ColumnNameToId(IngredientColumn)))
                        {
                            sql += " AND " + IngredientColumn + " <= " + MyIngredientsList[ColumnNameToId(IngredientColumn)].Replace(',', '.');
                        }
                        else
                        {
                            sql += " AND " + IngredientColumn + " = 0.0";
                        }
                    }
                    sql    += " ORDER BY title ASC";
                    command = new SQLiteCommand(sql, DatabaseControl.m_dbConnection);
                    reader  = command.ExecuteReader();

                    if (reader.HasRows)
                    {
                        dataGridView1.Rows.Clear();
                        while (reader.Read())
                        {
                            Bitmap img;

                            try
                            {
                                System.Net.WebRequest request = System.Net.WebRequest.Create(reader["img"].ToString());
                                request.Timeout = 500;
                                System.Net.WebResponse response       = request.GetResponse();
                                System.IO.Stream       responseStream = response.GetResponseStream();
                                img = new Bitmap(responseStream);
                            }
                            catch (Exception ex)
                            {
                                img = null;
                            }

                            dataGridView1.Rows.Add();
                            dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["id"].Value    = reader["id"];
                            dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Title"].Value = reader["title"];


                            dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Image"].Value            = img;
                            dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Time"].Value             = reader["time"];
                            dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Difficulty_level"].Value = reader["difficulty_level"];
                        }
                        ((DataGridViewImageColumn)dataGridView1.Columns[2]).ImageLayout = DataGridViewImageCellLayout.Stretch;
                        dataGridView1.Refresh();

                        this.Enabled = true;
                        loadingWindow.Close();
                    }
                    else
                    {
                        this.Enabled = true;
                        loadingWindow.Close();
                        dataGridView1.Rows.Clear();
                        MessageBox.Show("Nie znaleziono żadnych przepisów!", "Brak przepisów", MessageBoxButtons.OK);
                    }

                    DatabaseControl.DisonnectDB();
                }
                else
                {
                    this.Enabled = true;
                    loadingWindow.Close();
                    dataGridView1.Rows.Clear();
                    this.Show();
                    MessageBox.Show("Nie znaleziono żadnych przepisów!", "Brak przepisów", MessageBoxButtons.OK);
                }
            }
            else
            {
                DatabaseControl.DisonnectDB();
                DatabaseControl.ConnectDB();
                this.Enabled = true;
                loadingWindow.Close();
                dataGridView1.Rows.Clear();
                MessageBox.Show("Nie posiadasz żadnych składników!", "Brak składników", MessageBoxButtons.OK);
            }
        }