Exemple #1
0
        static public List <ProgramExe> ReadPrograms()
        {
            string            query   = "SELECT * FROM Programs";
            SQLiteCommand     command = new SQLiteCommand(query, con);
            List <ProgramExe> list    = new List <ProgramExe>();

            try
            {
                SQLiteDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    int        id     = Convert.ToInt16(reader["id"]);
                    string     name   = reader["name"].ToString();
                    string     exe    = reader["exe"].ToString();
                    bool       filter = Convert.ToBoolean(reader["filter"]);
                    ProgramExe prog   = new ProgramExe(id, name, exe, filter);
                    list.Add(prog);
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            list = list.OrderBy(o => o._name).ToList();
            return(list);
        }
        public void CheckBoxFilter(DataGridView filterGrid)
        {
            List <ProgramExe> programList = new List <ProgramExe>();

            try
            {
                foreach (DataGridViewRow row in filterGrid.Rows)
                {
                    bool       check   = (bool)row.Cells["checkbox"].Value;
                    int        id      = (int)row.Cells["id"].Value;
                    ProgramExe program = new ProgramExe(id, check);
                    programList.Add(program);
                }
                DBUtils.OpenConection();
                foreach (var item in programList)
                {
                    string query = string.Format("UPDATE Programs SET filter={0} WHERE Id={1} ", Convert.ToInt16(item._filter), item._id);
                    DBUtils.ExecuteQueries(query);
                }
                DBUtils.CloseConnection();
                // mistakes.MistakesHub(); JEIGU MISTAKES FILTRAS NEVEKIA BRING THIS BACK

                string connectionString = "Data Source=DatabaseLite.sqlite;Version=3;PRAGMA journal_mode=WAL;";

                OrmLiteConnectionFactory dbFactory = new OrmLiteConnectionFactory(connectionString, SqliteDialect.Provider);

                //DateTime test = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");


                using (IDbConnection db = dbFactory.OpenDbConnection())
                {
                    //var filteredData = db.TABLE.Where(t => t.DATE > startDate && t.DATE < endDate);

                    //var rows = db.From<Heatmap>().Where(x => x.date.CompareTo("2018-05-05 00:00:00") >= 0 && x.date.CompareTo("2018-06-21 23:59:59") <= 0);
                    var rows = db.From <Heatmap>().Where <Heatmap>(x => x.program_id == 12);

                    //db.From<Program>().Insert()
                }
            }
            catch (Exception xe)
            {
                MessageBox.Show(xe.ToString());
            }
        }