GetDataTable() public method

Allows the programmer to run a query against the Database.
public GetDataTable ( string sql ) : DataTable
sql string The SQL to run
return DataTable
Esempio n. 1
0
        static void Main(string[] args)
        {
            string dbPath  = string.Empty;
            string csvPath = string.Empty;

            if (args.Length > 0)
            {
                dbPath  = args[0];
                csvPath = args[1];
            }
            else
            {
                dbPath  = @"E:\WorkSpace\client_Manghuangji_Trunk_Android\Assets\R\Inside\database\game.bytes";//args[0];
                csvPath = "../../../ExportCSV";
            }

            Console.WriteLine("dbPath:" + dbPath);
            Console.WriteLine("csvPath:" + csvPath);

            if (!File.Exists(dbPath))
            {
                Console.WriteLine("not found " + dbPath);
                Console.ReadKey();
            }

            SQLiteDatabase db = new SQLiteDatabase(dbPath);
            DataTable      dataTable;
            String         query = "SELECT name FROM sqlite_master " + "WHERE type = 'table'" + "ORDER BY 1";

            dataTable = db.GetDataTable(query);

            ArrayList dataTableList = new ArrayList();

            foreach (DataRow row in dataTable.Rows)
            {
                dataTableList.Add(row.ItemArray[0].ToString());
            }

            string exportDirName = csvPath;

            if (Directory.Exists(exportDirName))
            {
                Directory.Delete(exportDirName, true);
            }
            Directory.CreateDirectory(exportDirName);

            for (int tableIndex = 0; tableIndex < dataTableList.Count; tableIndex++)
            {
                Console.WriteLine(string.Format("{0}/{1}:{2}", tableIndex, dataTableList.Count, dataTableList[tableIndex]));

                DataTable tmpDataTable = db.GetDataTable("select * from " + dataTableList[tableIndex]);

                ExportToCSV(exportDirName, tmpDataTable);
            }

            Console.WriteLine("ExportSqliteToCVS Finish");
            Console.ReadKey();
        }
Esempio n. 2
0
        public Tournoi()
        {
            String query = "select count(*) from equipe";

            nbEquipes = Int32.Parse(db.ExecuteScalar(query));
            query     = "select * from equipe";
            DataTable data = db.GetDataTable(query);

            foreach (DataRow row in data.Rows)
            {
                Equipe equ = new Equipe(Int32.Parse(row["id"].ToString()), row["nom"].ToString(), Int32.Parse(row["capitaine_id"].ToString()));
                this.Equipes[equ.id] = equ;
            }

            query = "select * from exception";
            DataTable dataExc = db.GetDataTable(query);

            foreach (DataRow row in dataExc.Rows)
            {
                this.Equipes[Int32.Parse(row["equipe1_id"].ToString())].exceptions.Add(Int32.Parse(row["equipe2_id"].ToString()));
                this.Equipes[Int32.Parse(row["equipe2_id"].ToString())].exceptions.Add(Int32.Parse(row["equipe1_id"].ToString()));
            }

            query = "select * from personne where equipe_id is null and arbitre = 1";
            DataTable arb = db.GetDataTable(query);

            foreach (DataRow row in arb.Rows)
            {
                Personne pers;
                if (row["equipe_id"] == System.DBNull.Value)
                {
                    pers = new Personne(Int32.Parse(row["id"].ToString()), row["prenom"].ToString(), row["nom"].ToString(), 0, true);
                }
                else
                {
                    pers = new Personne(Int32.Parse(row["id"].ToString()), row["prenom"].ToString(), row["nom"].ToString(), Int32.Parse(row["equipe_id"].ToString()), true);
                }

                this.Arbitres[pers.id] = pers;
            }

            query = "select * from personne where equipe_id is not null and equipe_id > 0";
            DataTable players = db.GetDataTable(query);

            foreach (DataRow row in players.Rows)
            {
                Personne pers;
                pers = new Personne(Int32.Parse(row["id"].ToString()), row["prenom"].ToString(), row["nom"].ToString(), Int32.Parse(row["equipe_id"].ToString()), false);

                this.Joueurs[pers.id] = pers;
            }
            foreach (KeyValuePair <int, Equipe> equipe in this.Equipes)
            {
                equipe.Value.setJoueurs(this.Joueurs);
            }
        }
Esempio n. 3
0
        private EmployeeCard GetCurrentEmployee()
        {
            String    query = String.Format("select * from employees where employeeID={0};", TextBoxCardID.Text.Trim());
            DataTable dt    = sql.GetDataTable(query);

            if (dt.Rows.Count > 0)
            {
                return((EmployeeCard)dt.Rows[0].ItemArray);
            }
            else
            {
                return(null);
            }
        }
Esempio n. 4
0
        public static void ListBooks()
        {
            string query = "select TITLE \"Title\", AUTHOR \"Author\", " +
                           "PUBDATE \"Publish Date\", ISBN \"ISBN\" from Books";

            DataTable books = db.GetDataTable(query);

            foreach (DataRow r in books.Rows)
            {
                Console.WriteLine("{0}, {1}, {2}, {3}", r["Title"].ToString(),
                                  r["Author"].ToString(),
                                  r["Publish Date"].ToString(),
                                  r["ISBN"].ToString());
            }
        }
Esempio n. 5
0
        internal IList <Participant> GetReport()
        {
            SQLiteDatabase db = new SQLiteDatabase();

            DataTable reportTable = db.GetDataTable(Constants.SqlReport);

            IList <Participant> report = new List <Participant>();

            if (reportTable != null && reportTable.Rows.Count > 0)
            {
                Participant participant;
                foreach (DataRow row in reportTable.Rows)
                {
                    participant                = new Participant();
                    participant.Email          = row["email"].ToString();
                    participant.Identification = row["identification"].ToString();
                    participant.Name           = row["name"].ToString();
                    participant.Corrects       = row["corrects"].ToString();

                    report.Add(participant);
                }
            }

            return(report);
        }
Esempio n. 6
0
        public Delete()
        {
            InitializeComponent();
            try
            {
                SQLiteDatabase db = new SQLiteDatabase();

                DataTable Login;

                String query = "select name \"Name\", lastname \"lastname\", Lid \"Lid\",";

                query += "name \"name\", lastname \"lastname\", Lid \"Lid\"";

                query += "from Login;";

                Login = db.GetDataTable(query);

                List <string> UsersList = new List <string>();

                //Or looped through for some other reason
                foreach (DataRow r in Login.Rows)
                {
                    UsersList.Add(r["name"].ToString());
                }
                comboBox.ItemsSource   = UsersList;
                comboBox.SelectedIndex = 0;
            }
            catch (Exception fail)
            {
                String error = "The following error has occurred:\n\n";
                error += fail.Message.ToString() + "\n\n";
                MessageBox.Show(error);
                this.Close();
            }
        }
Esempio n. 7
0
    public byte[] GetFile(string file)
    {
        DataTable t = _db.GetDataTable("SELECT * FROM filestorage where name = @name", new Dictionary <string, object>()
        {
            { "@name", file }
        });

        if (t.Rows.Count == 0)
        {
            return(null);
        }
        long start = long.Parse(t.Rows[0]["start"].ToString());
        long end   = long.Parse(t.Rows[0]["end"].ToString());
        long size  = long.Parse(t.Rows[0]["size"].ToString());

        byte[] buffer = new byte[size];
        if (_file != string.Empty)
        {
            using (var fs = new FileStream(_file, FileMode.Open))
            {
                fs.Seek(start, SeekOrigin.Begin);
                fs.Read(buffer, 0, buffer.Length);
            }
        }
        else
        {
            _stream.Seek(start, SeekOrigin.Begin);
            _stream.Read(buffer, 0, buffer.Length);
        }

        return(buffer);
    }
Esempio n. 8
0
        private void button_Click(object sender, RoutedEventArgs e)
        {
            listBox.Items.Clear();
            try
            {
                SQLiteDatabase db = new SQLiteDatabase();

                DataTable Login;

                String query = "select name \"Name\", lastname \"lastname\",";

                query += "name \"name\", lastname \"last name\"";

                query += "from Login;";

                Login = db.GetDataTable(query);


                //Or looped through for some other reason
                foreach (DataRow r in Login.Rows)
                {
                    listBox.Items.Add(r["name"].ToString() + "   " + r["lastname"].ToString());
                }
            }
            catch (Exception fail)
            {
                String error = "The following error has occurred:\n\n";
                error += fail.Message.ToString() + "\n\n";
                MessageBox.Show(error);
                this.Close();
            }
        }
Esempio n. 9
0
 // Fill the listboxes from the database
 private void getDataFromDb(string query, ListBox lstBox)
 {
     try
     {
         lstBox.Items.Clear();
         data = db.GetDataTable(query);
         foreach (DataRow r in data.Rows)
         {
             lstBox.Items.Add(r[0].ToString());
         }
     }
     catch (Exception fail)
     {
         failure(fail);
     }
 }
Esempio n. 10
0
        public void test()
        {
            try
            {
                SQLiteDatabase db = new SQLiteDatabase();
                DataTable      recipe;
                String         query = "select NAME \"Name\", DESCRIPTION \"Description\",";
                query += "PREP_TIME \"Prep Time\", COOKING_TIME \"Cooking Time\"";
                query += "from RECIPE;";
                recipe = db.GetDataTable(query);
                // The results can be directly applied to a DataGridView control
                //recipeDataGrid.DataSource = recipe;


                /*
                 * // Or looped through for some other reason
                 * foreach (DataRow r in recipe.Rows)
                 * {
                 *  MessageBox.Show(r["Name"].ToString());
                 *  MessageBox.Show(r["Description"].ToString());
                 *  MessageBox.Show(r["Prep Time"].ToString());
                 *  MessageBox.Show(r["Cooking Time"].ToString());
                 * }
                 *
                 */
            }
            catch (Exception fail)
            {
                String error = "The following error has occurred:\n\n";
                error += fail.Message.ToString() + "\n\n";
                MessageBox.Show(error);
                this.Close();
            }
        }
Esempio n. 11
0
        private void bt_add_Click(object sender, EventArgs e)
        {
            AjoutException addIgnore = new AjoutException();

            addIgnore.ShowDialog();
            this.exceptions = db.GetDataTable(query);
        }
Esempio n. 12
0
        public itempage1()
        {
            InitializeComponent();
            try
            {
                var db = new SQLiteDatabase();
                DataTable recipe;
                String query = "select ID \"id\", NAME \"Description\",";
                query += "CLIP \"Text\"";
                query += "from CLIPBOARD;";
                recipe = db.GetDataTable(query);
                // The/ results can be directly applied to a DataGridView control
                //dataGrid.DataContext = recipe;
                /*
                // Or looped through for some other reason
                foreach (DataRow r in recipe.Rows)
                {
                    MessageBox.Show(r["Name"].ToString());
                    MessageBox.Show(r["Description"].ToString());
                    MessageBox.Show(r["Prep Time"].ToString());
                    MessageBox.Show(r["Cooking Time"].ToString());
                }

                */
            }
            catch (Exception fail)
            {
                String error = "The following error has occurred:\n\n";
                error += fail.Message.ToString() + "\n\n";
                MessageBox.Show(error);
                this.Close();
            }
        }
Esempio n. 13
0
 public static bool EmployeeExists(string employeeID, SQLiteDatabase sql)
 {
     // notify user if card wasn't found
     if (sql.GetDataTable("select * from employees where employeeID=" + employeeID.Trim() + ";").Rows.Count == 1)
         return true;
     else
         return false;
 }
Esempio n. 14
0
        private static void KartInfoTest()
        {
            DataTable data = _database.GetDataTable(string.Format("SELECT Kart, RacerName, MIN(BestLap) AS BestLap, AVG(BestLap) AS AvgLap, DateTime FROM Races INNER JOIN Racers ON Races.CustId = Racers.Id GROUP BY Kart WHERE;", DateTime.Now.Subtract(TimeSpan.FromDays(7)).ToString("G")));

            foreach (DataRow row in data.Rows)
            {
                Console.WriteLine("Kart - {0} || {1} || {2} || {3} || {4}", row["Kart"], row["RacerName"], row["BestLap"], row["AvgLap"], row["DateTime"]);
            }
        }
Esempio n. 15
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         string sql = "select * from userInfo order by id desc limit 200";
         SQLiteDatabase db = new SQLiteDatabase();
         var datatable = db.GetDataTable(sql);
         rptUserInfo.DataSource = datatable;
         rptUserInfo.DataBind();
     }
 }
Esempio n. 16
0
        public Form1(int selectedMail, int action)
        {
            InitializeComponent();

            // action:
            // 0 = new mail
            // 1 = reply
            // 2 = forward
            // 3 = send public key
            string selectedSender = "unknown";
            string selectedSubject = "unknown";
            string selectedBody = "unknown";
            if (action == 1 || action == 2)
            {
                SQLiteDatabase db = new SQLiteDatabase();
                DataTable Mail;
                String query = "select Sender \"Sender\", Subject \"Subject\",";
                query += "Body \"Body\", Timestamp \"Timestamp\"";
                query += "from Mails ";
                query += "where ID = " + selectedMail + ";";
                Mail = db.GetDataTable(query);
                foreach (DataRow r in Mail.Rows)
                {
                    selectedSender = r["Sender"].ToString();
                    selectedSubject = r["Subject"].ToString();
                    selectedBody = r["Body"].ToString();
                }
            }

            switch (action)
            {
                case 1: // Reply
                    textBoxTo.Text = selectedSender;
                    textBoxSub.Text = "RE: " + selectedSubject;
                    break;
                case 2: // Forward
                    textBoxTo.Text = "";
                    textBoxSub.Text = "FW: " + selectedSubject;
                    break;
                case 3:
                    textBoxSub.Text = "My public key";
                    textBoxBody.Text = Properties.Settings.Default.RSAPublic;
                    textBoxPublicKey.Visible = false;
                    label1.Visible = false;
                    checkBoxEncrypt.Visible = false;
                    checkBoxRSA.Visible = false;
                    break;
                default:
                    textBoxTo.Text = "";
                    textBoxSub.Text = "";
                    break;
            }
        }
Esempio n. 17
0
 static public bool EmployeeExists(string employeeID, SQLiteDatabase sql)
 {
     // notify user if card wasn't found
     if (sql.GetDataTable("select * from employees where employeeID=" + employeeID.Trim() + ";").Rows.Count == 1)
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
Esempio n. 18
0
        private void loadConfig()
        {
            db       = new SQLiteDatabase(Setting.sqlite_dbname);
            _appconf = new appConfig();
            DataTable dconfig = db.GetDataTable("select companyname,address,telephone,province,taxid,taxrate from configuration");
            DataTable dsale   = db.GetDataTable("select formtype,billlock,saleprice,costprice,gp,autopurch,docno,customer from saleconfig");
            DataTable ditem   = db.GetDataTable("select iscost,ismin,islowcost,ispricechange from itemconfig");


            if (ditem.Rows.Count > 0)
            {
                _appconf.iscost        = Convert.ToInt16(ditem.Rows[0]["iscost"]);
                _appconf.ismin         = Convert.ToInt16(ditem.Rows[0]["ismin"]);
                _appconf.islowcost     = Convert.ToInt16(ditem.Rows[0]["islowcost"]);
                _appconf.ispricechange = Convert.ToInt16(ditem.Rows[0]["ispricechange"]);
            }
            if (dsale.Rows.Count > 0)
            {
                _appconf.formtype    = dsale.Rows[0]["formtype"].ToString();
                _appconf.billlock    = Convert.ToInt16(dsale.Rows[0]["billlock"]);
                _appconf.saleprice   = Convert.ToInt16(dsale.Rows[0]["saleprice"]);
                _appconf.costprice   = Convert.ToInt16(dsale.Rows[0]["costprice"]);
                _appconf.gp          = Convert.ToInt16(dsale.Rows[0]["gp"]);
                _appconf.autopurch   = Convert.ToInt16(dsale.Rows[0]["autopurch"]);
                _appconf.defdocno    = dsale.Rows[0]["docno"].ToString();
                _appconf.defcustomer = dsale.Rows[0]["customer"].ToString();
            }
            if (dconfig.Rows.Count > 0)
            {
                _appconf.companyname = dconfig.Rows[0]["companyname"].ToString();
                _appconf.address     = dconfig.Rows[0]["address"].ToString();
                _appconf.telephone   = dconfig.Rows[0]["telephone"].ToString();
                _appconf.province    = dconfig.Rows[0]["province"].ToString();
                _appconf.taxid       = dconfig.Rows[0]["taxid"].ToString();
                _appconf.taxrate     = dconfig.Rows[0]["taxrate"].ToString();
            }
            //vGridControl1.DataSource = dconfig;
            //vGridControl2.DataSource = dsale;
            //vGridControl3.DataSource = ditem;
        }
Esempio n. 19
0
        static void TestSQLite()
        {
            var            table = CreateTestTable();
            SQLiteDatabase db    = new SQLiteDatabase("MYDB");

            db.CreateTable("MYTABLE", table);
            var table2 = db.InspectDatabase();
            var table3 = db.GetDataTable("MYTABLE");

            var obj    = CreateTestArray();
            var table4 = ExcelFriendlyConversion.ConvertObjectArrayToDataTable("MYTABLE4", obj);

            PrintTableInfoToConsole(table4);

            db.CreateTable("MYTABLE4", table4);
            var table5 = db.GetDataTable("MYTABLE4");

            PrintTableInfoToConsole(table5);


            Console.WriteLine("Database created ..");
        }
Esempio n. 20
0
        private static void RetrieveAndDisplayData(SQLiteDatabase db)
        {
            var results = db.GetDataTable("SELECT * From Log");

            //TODO: Use generics instead. Please don't go out there kicking a cute puppy because of this code :(
            foreach (DataRow item in results.Rows)
            {
                Console.WriteLine("Level: {0} - Location: {1} - Date and Time: {2}",
                                item["Level"].ToString().ToUpper(), item["Location"], item["TimeStamp"]);
                Console.WriteLine("Message: \n{0} \n", item["Message"]);
            }
            Console.ReadLine();
        }
Esempio n. 21
0
        private int GetParticipantId(string identification)
        {
            SQLiteDatabase db = new SQLiteDatabase();

            DataTable participanTable = db.GetDataTable(string.Format(Constants.SqlParticipantId, identification));

            if (participanTable != null && participanTable.Rows.Count > 0)
            {
                return(int.Parse(participanTable.Rows[0]["participant_id"].ToString()));
            }

            return(0);
        }
Esempio n. 22
0
        private void initDataRow()
        {
            db = new SQLiteDatabase(sqlite_dbname);

            dconfig = db.GetDataTable("select companyname,address,telephone,province,taxid,taxrate from configuration");
            dsale   = db.GetDataTable("select formtype,billlock,saleprice,costprice,gp,autopurch,docno,customer from saleconfig");
            ditem   = db.GetDataTable("select iscost,ismin,islowcost,ispricechange from itemconfig");
            if (ditem.Rows.Count > 0)
            {
                vGridControl3.Rows["editorRow6"].Properties.Value = Convert.ToInt16(ditem.Rows[0]["iscost"]) == 1 ? "เตือน" : "ไม่เตือน";
                vGridControl3.Rows["editorRow7"].Properties.Value = Convert.ToInt16(ditem.Rows[0]["ismin"]) == 1? "เตือน" : "ไม่เตือน";
                vGridControl3.Rows["editorRow8"].Properties.Value = Convert.ToInt16(ditem.Rows[0]["islowcost"]) == 1?"เตือน" : "ไม่เตือน";
                vGridControl3.Rows["editorRow9"].Properties.Value = Convert.ToInt16(ditem.Rows[0]["ispricechange"]) == 1?"เตือน" : "ไม่เตือน";
            }
            if (dsale.Rows.Count > 0)
            {
                vGridControl2.Rows["editorRow1"].Properties.Value = dsale.Rows[0]["formtype"].ToString();
                vGridControl2.Rows["editorRow2"].Properties.Value = dsale.Rows[0]["billlock"].ToString() == "1"?"ทำงาน":"ไม่ทำงาน";
                vGridControl2.Rows["editorRow3"].Properties.Value = dsale.Rows[0]["saleprice"].ToString();
                vGridControl2.Rows["editorRow4"].Properties.Value = dsale.Rows[0]["costprice"].ToString();
                vGridControl2.Rows["editorRow5"].Properties.Value = dsale.Rows[0]["gp"].ToString();
                vGridControl2.Rows["row5"].Properties.Value       = dsale.Rows[0]["autopurch"].ToString() == "1" ? "ทำงาน" : "ไม่ทำงาน";
                vGridControl2.Rows["row7"].Properties.Value       = dsale.Rows[0]["docno"].ToString();
                vGridControl2.Rows["row8"].Properties.Value       = dsale.Rows[0]["customer"].ToString();
            }
            if (dconfig.Rows.Count > 0)
            {
                vGridControl1.Rows["row"].Properties.Value  = dconfig.Rows[0]["companyname"].ToString();
                vGridControl1.Rows["row1"].Properties.Value = dconfig.Rows[0]["address"].ToString();
                vGridControl1.Rows["row2"].Properties.Value = dconfig.Rows[0]["telephone"].ToString();
                vGridControl1.Rows["row3"].Properties.Value = dconfig.Rows[0]["province"].ToString();
                vGridControl1.Rows["row4"].Properties.Value = dconfig.Rows[0]["taxid"].ToString();
                vGridControl1.Rows["row6"].Properties.Value = dconfig.Rows[0]["taxrate"].ToString();
            }
            //vGridControl1.DataSource = dconfig;
            //vGridControl2.DataSource = dsale;
            //vGridControl3.DataSource = ditem;
        }
Esempio n. 23
0
        /// <summary>Updates the live box score data grid.</summary>
        /// <param name="teamID">Name of the team.</param>
        /// <param name="playersList">The players list.</param>
        /// <param name="pbsList">The player box score list.</param>
        /// <param name="playersT">The players' SQLite table name.</param>
        /// <param name="loading">
        ///     if set to <c>true</c>, it is assumed that a pre-existing box score is being loaded.
        /// </param>
        private static void updateLiveBoxScoreDataGrid(
            int teamID,
            out ObservableCollection <KeyValuePair <int, string> > playersList,
            ref SortableBindingList <LivePlayerBoxScore> pbsList,
            string playersT,
            bool loading)
        {
            var db = new SQLiteDatabase(MainWindow.CurrentDB);
            var q  = "select * from " + playersT + " where TeamFin = \"" + teamID + "\"";

            q += " ORDER BY LastName ASC";
            var res = db.GetDataTable(q);

            playersList = new ObservableCollection <KeyValuePair <int, string> >();
            if (!loading)
            {
                pbsList = new SortableBindingList <LivePlayerBoxScore>();
            }

            foreach (DataRow r in res.Rows)
            {
                var ps = new PlayerStats(r, MainWindow.TST);
                playersList.Add(new KeyValuePair <int, string>(ps.ID, ps.LastName + ", " + ps.FirstName));
            }

            for (var i = 0; i < pbsList.Count; i++)
            {
                var cur    = pbsList[i];
                var name   = MainWindow.PST[cur.PlayerID].LastName + ", " + MainWindow.PST[cur.PlayerID].FirstName;
                var player = new KeyValuePair <int, string>(cur.PlayerID, name);
                cur.Name = name;
                if (!playersList.Contains(player))
                {
                    playersList.Add(player);
                }
                pbsList[i] = cur;
            }
            playersList = new ObservableCollection <KeyValuePair <int, string> >(playersList.OrderBy(item => item.Value));

            if (!loading)
            {
                foreach (var p in playersList)
                {
                    pbsList.Add(new LivePlayerBoxScore {
                        PlayerID = p.Key
                    });
                }
            }
        }
Esempio n. 24
0
        public Form1(int selectedMail, int action)
        {
            InitializeComponent();

            // Actions:
            // 0 = new mail
            // 1 = reply
            // 2 = forward

            string selectedSender = "unknown";
            string selectedSubject = "unknown";
            string selectedBody = "unknown";
            if (action == 1 || action == 2)
            {
                SQLiteDatabase db = new SQLiteDatabase();
                DataTable Mail;
                String query = "select Sender \"Sender\", Subject \"Subject\",";
                query += "Body \"Body\", Timestamp \"Timestamp\"";
                query += "from Mails ";
                query += "where ID = " + selectedMail + ";";
                Mail = db.GetDataTable(query);
                foreach (DataRow r in Mail.Rows)
                {
                    selectedSender = r["Sender"].ToString();
                    selectedSubject = r["Subject"].ToString();
                    selectedBody = r["Body"].ToString();
                }
            }

            switch (action)
            {
                case 1: // Reply
                    textBoxTo.Text = selectedSender;
                    textBoxSub.Text = "RE: " + selectedSubject;
                    break;
                case 2: // Forward
                    textBoxTo.Text = "";
                    textBoxSub.Text = "FW: " + selectedSubject;
                    break;
                default:
                    textBoxTo.Text = "";
                    textBoxFrom.Text = "";
                    textBoxSub.Text = "";
                    break;
            }

            //MessageBox.Show(selectedMail.ToString() + " - " + action.ToString());
        }
Esempio n. 25
0
        private void FillListView()
        {
            SQLiteDatabase db = new SQLiteDatabase();
            DataTable      dt = db.GetDataTable("select * from prestasi_slta");

            list_prestasi.Items.Clear();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow      dr       = dt.Rows[i];
                ListViewItem listitem = new ListViewItem(dr["NAMA_KEGIATAN"].ToString());
                listitem.SubItems.Add(dr["JENIS"].ToString());
                listitem.SubItems.Add(dr["TINGKAT"].ToString());
                listitem.SubItems.Add(dr["TAHUN"].ToString());
                listitem.SubItems.Add(dr["PENCAPAIAN"].ToString());
                list_prestasi.Items.Add(listitem);
            }
        }
Esempio n. 26
0
        private void LoadButton_Click(object sender, EventArgs e)
        {
            if (TextBoxCardID.Text != "")
            {
                try {
                    if (Helper.EmployeeExists(TextBoxCardID.Text, sql))
                    {
                        //Disable UIs
                        TextBoxCardID.Enabled = false;
                        LoadButton.Enabled    = false;

                        dt = sql.GetDataTable("select id, dayOfWeek as Day, clockIn, clockOut from avgHours where employeeId=" + TextBoxCardID.Text + " order by dayOfWeek asc;");

                        if (dt.Rows.Count > 0)
                        {
                            AvgHoursGridView.DataSource = dt;
                            AvgHoursGridView.ClearSelection();
                            AvgHoursGridView.Columns[0].Visible = false; // hide id column, used to determine which entry to update/remove

                            foreach (DataGridViewColumn column in AvgHoursGridView.Columns)
                            {
                                column.SortMode = DataGridViewColumnSortMode.NotSortable;
                            }

                            AvgHoursGridView.RowStateChanged += new System.Windows.Forms.DataGridViewRowStateChangedEventHandler(AvgHoursGridView_RowStateChanged);
                        }
                        else
                        {
                            MessageBox.Show("No entries were found for this ID,\n use the fields below to add one.", "No entries found!", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }

                        SetAddButton();
                    }
                    else
                    {
                        throw new ArgumentException("The ID you entered does not exist, please make sure ID was entered correctly.");
                    }
                } catch (Exception err) {
                    MessageBox.Show(err.Message, "An Error occured!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Esempio n. 27
0
 private void GererException_Load(object sender, EventArgs e)
 {
     try
     {
         db    = new SQLiteDatabase();
         query = "SELECT equipe1_id, equipe2_id, e1.nom as nom1, e2.nom as nom2 FROM exception"
                 + " LEFT JOIN equipe e1 ON equipe1_id = e1.id"
                 + " LEFT JOIN equipe e2 ON equipe2_id = e2.id";
         exceptions = db.GetDataTable(query);
         dataGridView1.DataSource            = exceptions;
         dataGridView1.Columns[0].Visible    = false;
         dataGridView1.Columns[1].Visible    = false;
         dataGridView1.Columns[2].HeaderText = "Equipe 1";
         dataGridView1.Columns[3].HeaderText = "Equipe 2";
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
Esempio n. 28
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int id = 0;
            if (Request["id"] != null)
            {
                int.TryParse(Request["id"], out id);

                if (id > 0)
                {
                    string sql = "select * from usercookie where infoId=" + id + " limit 200";
                    SQLiteDatabase db = new SQLiteDatabase();
                    var datatable = db.GetDataTable(sql);
                    rptCookieInfo.DataSource = datatable;
                    rptCookieInfo.DataBind();
                }
            }
        }
    }
Esempio n. 29
0
        private void ButtonRemove_Click(object sender, EventArgs e)
        {
            // vars
            bool found = false;

            dt = sql.GetDataTable("select * from employees where employeeID=" + TextBoxCardID.Text.Trim() + ";");

            // check if this is the card we're looking for
            if (dt.Rows.Count == 1)
            {
                // mark as found
                found = true;

                // confirm deletion of card
                if (MessageBox.Show(this, "Are you sure you want to delete " + dt.Rows[0].ItemArray[1].ToString() + "'s card?\n(Card/Student ID: " + dt.Rows[0].ItemArray[0].ToString() + ")", "Confirm Card Deletion", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
                {
                    // write to file
                    try {
                        sql.Delete("employees", String.Format("employeeID = {0}", dt.Rows[0].ItemArray[0].ToString()));

                        if (CheckBoxDelTimeLog.Checked == true)
                        {
                            sql.Delete("timeStamps", String.Format("employeeID = {0}", dt.Rows[0].ItemArray[0].ToString()));
                        }
                    } catch (Exception err) {
                        MessageBox.Show(this, "There was an error while trying to remove the card.\n\n" + err.Message, "File Deletion Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }

            // notify user if card wasn't found
            if (!found)
            {
                MessageBox.Show(this, "The card you entered wasn't found. Are you sure you typed it in correctly?", "Card Not Found!", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            // reset text box
            TextBoxCardID.Clear();
            TextBoxCardID.Focus();
        }
Esempio n. 30
0
        private void FillListView()
        {
            SQLiteDatabase db = new SQLiteDatabase();
            DataTable      dt = db.GetDataTable("select * from nilai_unas_slta");

            list_unas.Items.Clear();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow      dr       = dt.Rows[i];
                ListViewItem listitem = new ListViewItem(dr["TAHUN_AJARAN"].ToString());
                listitem.SubItems.Add(dr["NILAI_IPA"].ToString());
                listitem.SubItems.Add(dr["JUMLAH_MAPEL_IPA"].ToString());
                listitem.SubItems.Add(dr["NILAI_IPS"].ToString());
                listitem.SubItems.Add(dr["JUMLAH_MAPEL_IPS"].ToString());
                listitem.SubItems.Add(dr["NILAI_BAHASA"].ToString());
                listitem.SubItems.Add(dr["JUMLAH_MAPEL_BAHASA"].ToString());
                listitem.SubItems.Add(dr["NILAI_SMK"].ToString());
                listitem.SubItems.Add(dr["JUMLAH_MAPEL_SMK"].ToString());
                list_unas.Items.Add(listitem);
            }
        }
Esempio n. 31
0
        internal IList <Question> GetQuestions()
        {
            SQLiteDatabase db = new SQLiteDatabase();

            DataTable        questionsTable = db.GetDataTable(Constants.SqlQuestions);
            IList <Question> questions      = new List <Question>();

            if (questionsTable != null && questionsTable.Rows.Count > 0)
            {
                Question question;
                foreach (DataRow row in questionsTable.Rows)
                {
                    question             = new Question();
                    question.Answer      = row["answer"].ToString() == "1";
                    question.Description = row["question"].ToString();
                    question.Number      = int.Parse(row["number"].ToString());
                    question.QuestionId  = int.Parse(row["question_id"].ToString());

                    questions.Add(question);
                }
            }

            return(questions);
        }
Esempio n. 32
0
        // Here is the deal -
        // User asks "what files/folders are in /test"
        // Using a MPTT or adjacency list will not answer that question
        // Those store tree data - but would require resolving ALL paths in the tree to find the folder
        // Obviously we could store the full path as a lookup like I do - but then what would
        // MPTT or AL get me?
        // Nothing.
        // Folders will also be stored as entities
        // so that we can just query the entities table to determine what files/folders there are
        // If a user requests what entities are in /test - we can easily look that up by querying directories
        // table then query entities with dir = directory ID
        // But what if a user requests a full dump of all files?
        // It would resolve as a GetEntities("/") then GetEntities("/test") etc
        // Src: https://stackoverflow.com/questions/6802539/hierarchical-tree-database-for-directories-path-in-filesystem
        public ICollection <FileSystemPath> GetEntities(FileSystemPath path)
        {
            DataTable dir = db.GetDataTable("SELECT * FROM directories WHERE fullpath = @path",
                                            new Dictionary <string, object>()
            {
                { "@path", path.Path }
            });
            DataTable res = db.GetDataTable("SELECT * FROM entities WHERE dir = @dir", new Dictionary <string, object>()
            {
                { "@dir", dir.Rows[0]["id"].ToString() }
            });
            List <FileSystemPath> files = new List <FileSystemPath>();

            //files.Add(FileSystemPath.Parse("/test.txt"));
            foreach (DataRow r in res.Rows)
            {
                FileSystemPath p = FileSystemPath.Parse(path.Path + r["fname"].ToString());
                files.Add(p);
            }

            return(files);
        }
        /// <summary>
        ///     Initializes a new instance of the <see cref="DualListWindow" /> class. Used to enable/disable players/teams for the season.
        /// </summary>
        /// <param name="currentDB">The current DB.</param>
        /// <param name="curSeason">The cur season.</param>
        /// <param name="maxSeason">The max season.</param>
        /// <param name="mode">The mode.</param>
        public DualListWindow(string currentDB, int curSeason, int maxSeason, Mode mode)
            : this()
        {
            _mode = mode;

            _currentDB = currentDB;
            _curSeason = curSeason;
            _maxSeason = maxSeason;

            txbDescription.Text = "Current Season: " + _curSeason + "/" + _maxSeason;

            var db = new SQLiteDatabase(_currentDB);

            var teamsT = "Teams";

            _playersT = "Players";
            if (_curSeason != _maxSeason)
            {
                var s = "S" + _curSeason;
                teamsT    += s;
                _playersT += s;
            }

            if (mode == Mode.HiddenTeams)
            {
                var q = "select DisplayName, isHidden from " + teamsT + " ORDER BY DisplayName ASC";

                var res = db.GetDataTable(q);

                foreach (DataRow r in res.Rows)
                {
                    if (!ParseCell.GetBoolean(r, "isHidden"))
                    {
                        lstEnabled.Items.Add(ParseCell.GetString(r, "DisplayName"));
                    }
                    else
                    {
                        lstDisabled.Items.Add(ParseCell.GetString(r, "DisplayName"));
                    }
                }
                btnLoadList.Visibility = Visibility.Hidden;
            }
            else if (mode == Mode.HiddenPlayers)
            {
                Title = "Enable/Disable Players for Season";
                lblEnabled.Content  = "Enabled Players";
                lblDisabled.Content = "Disabled Players";

                var q = "SELECT (LastName || ', ' || FirstName || ' (' || TeamFin || ')') AS Name, ID, isHidden FROM " + _playersT
                        + " ORDER BY LastName";

                var res = db.GetDataTable(q);

                foreach (DataRow r in res.Rows)
                {
                    var s = ParseCell.GetString(r, "Name");
                    if (!ParseCell.GetBoolean(r, "isHidden"))
                    {
                        _shownPlayers.Add(new KeyValuePair <int, string>(ParseCell.GetInt32(r, "ID"), s));
                    }
                    else
                    {
                        _hiddenPlayers.Add(new KeyValuePair <int, string>(ParseCell.GetInt32(r, "ID"), s));
                    }
                }

                _shownPlayers.RaiseListChangedEvents = true;
                lstEnabled.DisplayMemberPath         = "Value";
                lstEnabled.SelectedValuePath         = "Key";
                lstEnabled.ItemsSource = _shownPlayers;

                _hiddenPlayers.RaiseListChangedEvents = true;
                lstDisabled.DisplayMemberPath         = "Value";
                lstDisabled.SelectedValuePath         = "Key";
                lstDisabled.ItemsSource = _hiddenPlayers;

                btnLoadList.Visibility = Visibility.Hidden;
            }
        }
Esempio n. 34
0
        //for migration purposes only. delete.
        public List<TicketResource> GetAllTickets()
        {
            SQLiteDatabase db = new SQLiteDatabase();
            string sql = "select * from Tickets";
            DataTable result = db.GetDataTable(sql);

            List<TicketResource> ticketResources = new List<TicketResource>();
            foreach (DataRow row in result.Rows)
            {
                //just do an insert here instead
                TicketResource ticketRes = ConvertDataRowToTicketResource(row);
                InsertNewTicket(ticketRes);
                ticketResources.Add(ticketRes);
            }
            return ticketResources;
        }
Esempio n. 35
0
        private void NouvelleEquipe_Load(object sender, EventArgs e)
        {
            db = new SQLiteDatabase();
            try
            {
                db = new SQLiteDatabase();

                String query = "";
                if (this.id_equipe != 0)
                {
                    query = "select nom from equipe where id = " + this.id_equipe;
                    String teamName = db.ExecuteScalar(query);
                    tb_nom.Text = teamName;
                    query       = "select capitaine_id from equipe where id = " + this.id_equipe;
                    capitaineId = Int32.Parse(db.ExecuteScalar(query));
                }

                query = "select * FROM personne WHERE equipe_id is null or equipe_id = 0";
                if (this.id_equipe != 0)
                {
                    query += " or equipe_id = " + this.id_equipe;
                }
                personnes = db.GetDataTable(query);
                DataColumn inTeam = new DataColumn("Selection", typeof(Boolean));
                personnes.Columns.Add(inTeam);
                DataColumn isCap = new DataColumn("Capitaine", typeof(Boolean));
                personnes.Columns.Add(isCap);

                foreach (DataRow r in personnes.Rows)
                {
                    if (r["equipe_id"] != System.DBNull.Value)
                    {
                        r["Selection"] = 1;
                        playerCount++;
                    }
                    else
                    {
                        r["Selection"] = 0;
                    }
                    if (Int32.Parse(r["id"].ToString()) == capitaineId)
                    {
                        r["Capitaine"] = 1;
                    }
                    else
                    {
                        r["Capitaine"] = 0;
                    }
                }
                dataGridView1.DataSource         = personnes;
                dataGridView1.Columns[0].Width   = 30;
                dataGridView1.Columns[3].Visible = false;
                dataGridView1.Columns[4].Visible = false;
                for (int i = 0; i < 5; i++)
                {
                    dataGridView1.Columns[i].ReadOnly = true;
                }
            }
            catch (Exception fail)
            {
                String error = "The following error has occurred:\n\n";
                error += fail.Message.ToString() + "\n\n";
                MessageBox.Show(error);
                this.Close();
            }
        }
Esempio n. 36
0
        void LoadedEventHandler(object sender, RoutedEventArgs e)
        {
            Logger.MonitoringLogger.Debug("Login window loaded event");
            LoadFromConfigurationFile();

            try
            {
                Logger.MonitoringLogger.Info("Populate profile list with information from the database");
                db = new SQLiteDatabase();
                DataTable resultQuery;
                String query = "select * FROM profileList;";
                resultQuery = db.GetDataTable(query);
                
                // Loop over all data
                foreach (DataRow r in resultQuery.Rows)
                {
                    ServerProfile serverProfile = new ServerProfile(r["profilName"].ToString(), r["hostname"].ToString(), Int32.Parse(r["port"].ToString()), r["password"].ToString(), Boolean.Parse(r["autoReconnect"].ToString()));
                    loginDataView.ServersProfiles.Add(serverProfile);
                    Logger.MonitoringLogger.Info(r.ToString());
                }
            }
            catch (Exception databaseException)
            {
                MessageDialog.ShowAsync(
                        "Erreur de lecture de la base de donnée",
                        "Erreur de lecture de la base de donnée ! Informations de debug :\n" + databaseException.ToString(),
                        MessageBoxButton.OK,
                        MessageDialogType.Light,
                        this);
            }

            NotifyBox.Show(
                           (DrawingImage)this.FindResource("SearchDrawingImage"),
                           "Astuce",
                           "Un clic droit permet d'ouvrir le menu application !",
                           false);
            Logger.MonitoringLogger.Debug(WINDOW_NAME + " loaded function ended");
        }
Esempio n. 37
0
        static void DumpSqlite(string filename)
        {
            Serializer s = new Serializer();
            try
            {
                var db = new SQLiteDatabase(filename);
                List <String> tableList = db.GetTables();
                List<SerializableDictionary<string, string>> dictList = new List<SerializableDictionary<string, string>>();
                foreach (string table in tableList)
                    {
                        String query = string.Format("select * from {0};", table);
                        DataTable recipe = db.GetDataTable(query);
                        foreach (DataRow r in recipe.Rows)
                            {
                                SerializableDictionary<string, string> item = new SerializableDictionary<string, string>();
                                foreach (DataColumn c in recipe.Columns)
                                    {
                                        item[c.ToString()] = r[c.ToString()].ToString();
                                    }
                                dictList.Add(item);
                            }
                        s.Serialize(string.Format("{0}.xml", table), dictList, table);
                        dictList.Clear();
                    }

            }
            catch (Exception fail)
            {
                String error = "The following error has occurred:\n\n";
                error += fail.Message + "\n\n";
            }
        }
Esempio n. 38
0
        public void Run()
        {
            string[]     arguments = Environment.GetCommandLineArgs();
            string       key;
            SettingsData data;

            if (File.Exists("settings.xml"))
            {
                data = SettingsFile.Read("settings.xml");
            }
            else
            {
                Console.WriteLine("Can't find settings.xml file - attempting to generate one");
                data = GenerateSettings();
                SettingsFile.Write(data, "settings.xml");
            }

            if (arguments.Length > 1 && arguments[1] == "fuse")
            {
                try
                {
                    Fuse.LazyUnmount(arguments[2]);
                    key = AESWrapper.GenerateKeyString(ConsoleEx.Password("Key: "), data.salt, data.iterations,
                                                       data.keySize);
                    using (var mount = Fuse.Mount(arguments[2], new DeDupeFuseFileSystem(key, data)))
                    {
                        Task t = mount.WaitForUnmountAsync();
                        t.Wait();
                    }
                }
                catch (FuseException fe)
                {
                    Console.WriteLine($"Fuse throw an exception: {fe}");

                    Console.WriteLine("Try unmounting the file system by executing:");
                    Console.WriteLine($"fuser -kM {arguments[2]}");
                    Console.WriteLine($"sudo umount -f {arguments[2]}");
                }
            }
            else
            {
                string         input            = "";
                FileSystemPath currentDirectory = FileSystemPath.Parse("/");


                string[] Scopes = { DriveService.Scope.Drive, DriveService.Scope.DriveFile };


                if (arguments.Length > 1)
                {
                    key = AESWrapper.GenerateKeyString(arguments[1], data.salt, data.iterations,
                                                       data.keySize);
                }
                else
                {
                    key = AESWrapper.GenerateKeyString(ConsoleEx.Password("Key: "), data.salt, data.iterations,
                                                       data.keySize);
                }

                using (EncryptedTempFile dbfile = new EncryptedTempFile("data.sqlite.enc", key))
                {
                    SQLiteDatabase db  = new SQLiteDatabase(dbfile.Path);
                    var            res = db.GetDataTable("PRAGMA table_info(settings)");
                    if (res.Rows.Count == 0)
                    {
                        this.setUpDatabase(db);
                    }

                    this.runMigrations(db);
                    dbfile.Flush();
                    //GDriveFileSystem gdrive = new GDriveFileSystem(Scopes, "DistrubtedDeDupe", dbfile.Path);
                    Log.Instance.Write("log.txt");


                    DeDupeFileSystem fs = new DeDupeFileSystem(dbfile.Path, key);
                    foreach (KeyValuePair <string, string> kv in data.locations)
                    {
                        fs.AddFileSystem(new DeDupeLocalFileSystem(kv.Value, kv.Key));
                    }

                    //fs.AddFileSystem(gdrive);
                    string fileName;
                    byte[] fileData;
                    do
                    {
                        if (currentDirectory.Path == "/")
                        {
                            Console.Write($"#:{currentDirectory.Path}> ");
                        }
                        else
                        {
                            Console.Write($"#:{currentDirectory.Path.TrimEnd('/')}> ");
                        }

                        if (arguments.Length > 1)
                        {
                            input = arguments[2];
                        }
                        else
                        {
                            input = Console.ReadLine();
                        }

                        switch (input.Split(" ")[0])
                        {
                        case "stats":
                            long entitySpaceUsed = long.Parse(db.ExecuteScalar("SELECT SUM(size) FROM entities"));
                            long blockSpaceUsed  = long.Parse(db.ExecuteScalar("SELECT SUM(size) FROM blocks"));
                            long chunks          = long.Parse(db.ExecuteScalar("SELECT count(id) from blocks"));
                            long diffSpace       = entitySpaceUsed - blockSpaceUsed;
                            Console.WriteLine($"Space used for entites => {entitySpaceUsed.GetBytesReadable()}");
                            Console.WriteLine($"Space used for blocks => {blockSpaceUsed.GetBytesReadable()}");
                            Console.WriteLine($"Space saved => {diffSpace.GetBytesReadable()}");
                            Console.WriteLine($"Blocks used => {chunks}");
                            break;

                        case "addstorage":
                            string location = input.Split(" ")[1].Trim();
                            string name     = input.Split(" ")[2].Trim();
                            data.locations[name] = Path.GetFullPath(location);
                            fs.AddFileSystem(new DeDupeLocalFileSystem(Path.GetFullPath(location), name));
                            SettingsFile.Write(data, "settings.xml");
                            break;

                        case "decryptdb":
                            fileName = input.Split(" ")[1].Trim();
                            //byte[] plain = AESWrapper.DecryptToByte(System.IO.File.ReadAllBytes(dbfile.Path), key);
                            System.IO.File.WriteAllBytes(fileName, System.IO.File.ReadAllBytes(dbfile.Path));
                            break;

                        case "help":
                            ShowHelp();
                            break;

                        case "changekey":
                            key = AESWrapper.GenerateKeyString(ConsoleEx.Password("Key: "), data.salt,
                                                               data.iterations,
                                                               data.keySize);
                            fs.UpdateKey(key);
                            break;

                        case "generate":
                            data = GenerateSettings();
                            if (data != null)
                            {
                                SettingsFile.Write(data, "settings.xml");
                                key = AESWrapper.GenerateKeyString(ConsoleEx.Password("Key: "), data.salt,
                                                                   data.iterations,
                                                                   data.keySize);
                                fs.UpdateKey(key);
                            }

                            break;

                        case "showsettings":
                            Console.WriteLine($"Iterations = {data.iterations}");
                            Console.WriteLine($"Salt = {data.salt}");
                            Console.WriteLine($"Key size = {data.keySize}");
                            foreach (var kv in data.locations)
                            {
                                Console.WriteLine($"{kv.Key} = {kv.Value}");
                            }

                            break;

                        case "ls":
                            Console.WriteLine(
                                VirtualDirectoryListing.List(fs.GetExtendedEntities(currentDirectory)));
                            break;

                        case "ll":
                            Console.WriteLine(
                                VirtualDirectoryListing.ListWithHash(fs.GetExtendedEntities(currentDirectory)));
                            break;

                        case "put":
                            if (data.locations.Count == 0)
                            {
                                Console.WriteLine("[Error]: No file locations setup");
                                break;
                            }

                            fileName = input.Split(" ")[1].Trim();
                            byte[] fileDataPut = System.IO.File.ReadAllBytes(fileName);
                            //string encFile = AESWrapper.EncryptToString(fileData, key);
                            Stopwatch watch1 = new Stopwatch();
                            watch1.Start();
                            using (Stream f = fs.CreateFile(FileSystemPath.Parse(currentDirectory.Path + fileName)))
                            {
                                f.Write(fileDataPut, 0, fileDataPut.Length);
                            }

                            fs.FlushTempFile();
                            dbfile.Flush();
                            watch1.Stop();
                            Console.WriteLine($"Elapsed time: {watch1.Elapsed.ToString("g")}");
                            break;

                        case "localcat":
                            if (data.locations.Count == 0)
                            {
                                Console.WriteLine("[Error]: No file locations setup");
                                break;
                            }

                            fileName = input.Split(" ")[1].Trim();
                            fileData = System.IO.File.ReadAllBytes(fileName);
                            Console.WriteLine(AESWrapper.DecryptToString(fileData, key));
                            break;

                        case "remotecat":
                            if (data.locations.Count == 0)
                            {
                                Console.WriteLine("[Error]: No file locations setup");
                                break;
                            }

                            fileName = input.Split(" ")[1].Trim();
                            try
                            {
                                using (Stream f = fs.OpenFile(
                                           FileSystemPath.Parse(currentDirectory.Path + fileName),
                                           FileAccess.Read))
                                {
                                    Console.WriteLine(f.ReadAllText());
                                }
                            }
                            catch (Exception e)
                            {
                                Console.WriteLine("[Error]: " + e.ToString());
                            }

                            break;

                        case "get":
                            if (data.locations.Count == 0)
                            {
                                Console.WriteLine("[Error]: No file locations setup");
                                break;
                            }

                            fileName = input.Split(" ")[1].Trim();
                            string    dstFileName = input.Split(" ")[2].Trim();
                            Stopwatch watch2      = new Stopwatch();
                            watch2.Start();
                            using (Stream f = fs.OpenFile(FileSystemPath.Parse(currentDirectory.Path + fileName),
                                                          FileAccess.Read))
                            {
                                byte[] test = f.ReadAllBytes();
                                System.IO.File.WriteAllBytes(dstFileName, test);
                            }

                            watch2.Stop();
                            Console.WriteLine($"Elapsed time: {watch2.Elapsed.ToString("g")}");
                            break;

                        case "mkdir":
                            string newDir = input.Split(" ")[1].Trim();
                            fs.CreateDirectory(currentDirectory.AppendDirectory(newDir));
                            dbfile.Flush();
                            break;

                        case "cd":
                            string dirtmpStr;
                            //dirtmp = currentDirectory.AppendDirectory(input.Split(" ")[1]);
                            dirtmpStr = ParseDotDot(currentDirectory.Path, input.Split(" ")[1]);
                            FileSystemPath dirtmp;
                            if (dirtmpStr == "/")
                            {
                                dirtmp = FileSystemPath.Parse(dirtmpStr);
                            }
                            else
                            {
                                dirtmp = FileSystemPath.Parse(dirtmpStr + "/");
                            }

                            if (fs.Exists(dirtmp))
                            {
                                //currentDirectory = currentDirectory.AppendDirectory(input.Split(" ")[1]);
                                currentDirectory = dirtmp;
                            }
                            else
                            {
                                Console.WriteLine("No such directory exists");
                            }

                            break;
                        }

                        if (arguments.Length > 1)
                        {
                            break;
                        }
                    } while (input != "exit" && input != "quit");

                    dbfile.Flush();
                }
            }
        }
Esempio n. 39
0
        static void Main(string[] args)
        {
            string tmpdbpath  = args[0];
            string tmpluapath = args[1];

            if (File.Exists(tmpdbpath) == false)
            {
                Console.WriteLine("not found " + tmpdbpath);
                Console.ReadKey();
            }


            SQLiteDatabase db = new SQLiteDatabase(tmpdbpath);
            DataTable      recipe;
            String         query = "SELECT name FROM sqlite_master " +
                                   "WHERE type = 'table'" +
                                   "ORDER BY 1";

            recipe = db.GetDataTable(query);

            ArrayList list = new ArrayList();

            foreach (DataRow row in recipe.Rows)
            {
                list.Add(row.ItemArray[0].ToString());
            }

            string tmpExportLuaDirName = tmpluapath;

            if (Directory.Exists(tmpExportLuaDirName) == false)
            {
                Directory.CreateDirectory(tmpExportLuaDirName);
            }

            //foreach (var item in list)
            for (int tableIndex = 0; tableIndex < list.Count; tableIndex++)
            {
                Console.WriteLine(tableIndex + "/" + list.Count + "    : " + list[tableIndex]);

                DataTable tmpDataTable = db.GetDataTable("select * from " + list[tableIndex]);

                StreamWriter tmpStreamWrite = new StreamWriter(tmpExportLuaDirName + "/" + tmpDataTable.TableName + ".lua");
                tmpStreamWrite.WriteLine(tmpDataTable.TableName + "=");
                tmpStreamWrite.WriteLine("{");

                foreach (var tableRow in tmpDataTable.Rows)
                {
                    string  tmpOneTableStr = "    {";
                    DataRow tmpRow         = tableRow as DataRow;
                    for (int i = 0; i < tmpRow.ItemArray.Length; i++)
                    {
                        if (i != 0)
                        {
                            tmpOneTableStr = tmpOneTableStr + ",";
                        }

                        if (tmpDataTable.Columns[i].DataType.Name == "String")
                        {
                            tmpOneTableStr = tmpOneTableStr + tmpDataTable.Columns[i].ColumnName + "=\"" + tmpRow.ItemArray[i] + "\"";
                        }
                        else
                        {
                            tmpOneTableStr = tmpOneTableStr + tmpDataTable.Columns[i].ColumnName + "=" + tmpRow.ItemArray[i];
                        }
                    }

                    tmpOneTableStr = tmpOneTableStr + "},";
                    tmpStreamWrite.WriteLine(tmpOneTableStr);
                }

                tmpStreamWrite.WriteLine("}");

                tmpStreamWrite.WriteLine("return " + tmpDataTable.TableName);
                tmpStreamWrite.Flush();
                tmpStreamWrite.Close();
            }

            Console.WriteLine("Finish");
            Console.ReadKey();
        }
Esempio n. 40
0
        /// <summary>
        /// Confirm identity of logging in user
        /// </summary>
        /// <param name="n"></param>
        /// <param name="e"></param>
        protected void loginconf(Network n, Irc.IrcEventArgs e)
        {
            if (IsMatch("^everify (?<nonce>.*?)$", e.Data.Message.Substring(BOT_CONTROL_SEQ.Length)))
            {
                string[] temp = Matches["nonce"].Value.Split(':');
                string name = temp[0];
                SQLiteDatabase db = new SQLiteDatabase();
                System.Data.DataTable accounts;
                String query = "SELECT id \"ID\", name \"NAME\", email \"EMAIL\", gpgkey \"key\", verify \"VERIFY\" FROM accounts;";
                accounts = db.GetDataTable(query);
                bool registered = false;
                int id = 0;
                foreach (DataRow account in accounts.Rows)
                {
                    id++;
                    if (account["NAME"] as string == name)
                    {
                        Answer(n, e, "Name from verify string:   " + name);
                        Answer(n, e, "Verify string from db:     " + account["VERIFY"].ToString());
                        Answer(n, e, "Verify string from irc:    " + Matches["nonce"].Value);

                        if (account["VERIFY"].ToString().ToLower() == Matches["nonce"].Value.ToLower() + "\n")
                        {
                            User u = new User();
                            u.nick = e.Data.Nick;
                            u.user = name;
                            u.kid = account["key"] as string;
                            loggedin.Add(u);

                            //LOGIN THE USER AT THE BOT LEVEL SO OTHER PLUGINS CAN SEE
                            Bot.LoginUser(u);

                            //JUST ANOTHER WAY TO REPLY TO THE USER
                            Answer(n, e, e.Data.Nick + ": You are now logged in.");
                            registered = true;
                        }
                        else
                        {
                            Answer(n, e, e.Data.Nick + ": Invalid login.");
                        }
                    }
                }

                if (!registered)
                {
                    Answer(n, e, e.Data.Nick + ": Your not registered.");
                }
            }
        }
        private void btnOK_Click(object sender, RoutedEventArgs e)
        {
            if (_mode == Mode.HiddenTeams)
            {
                var db = new SQLiteDatabase(_currentDB);

                var teamsT   = "Teams";
                var plTeamsT = "PlayoffTeams";
                var oppT     = "Opponents";
                var plOppT   = "PlayoffOpponents";
                if (_curSeason != _maxSeason)
                {
                    var s = "S" + _curSeason;
                    teamsT   += s;
                    plTeamsT += s;
                    oppT     += s;
                    plOppT   += s;
                }

                foreach (string name in lstEnabled.Items)
                {
                    var dict = new Dictionary <string, string> {
                        { "isHidden", "False" }
                    };
                    db.Update(teamsT, dict, "DisplayName LIKE \"" + name + "\"");
                    db.Update(plTeamsT, dict, "DisplayName LIKE \"" + name + "\"");
                    db.Update(oppT, dict, "DisplayName LIKE \"" + name + "\"");
                    db.Update(plOppT, dict, "DisplayName LIKE \"" + name + "\"");
                }

                foreach (string name in lstDisabled.Items)
                {
                    var q = "select * from GameResults where SeasonNum = " + _curSeason + " AND (Team1ID = "
                            + getTeamIDFromDisplayName(name) + " OR Team2ID = " + getTeamIDFromDisplayName(name) + ")";
                    var res = db.GetDataTable(q);

                    if (res.Rows.Count > 0)
                    {
                        var r = MessageBox.Show(
                            name + " have box scores this season. Are you sure you want to disable this team?",
                            "NBA Stats Tracker",
                            MessageBoxButton.YesNo,
                            MessageBoxImage.Question);

                        if (r == MessageBoxResult.No)
                        {
                            continue;
                        }
                    }

                    var dict = new Dictionary <string, string> {
                        { "isHidden", "True" }
                    };
                    db.Update(teamsT, dict, "DisplayName LIKE \"" + name + "\"");
                    db.Update(plTeamsT, dict, "DisplayName LIKE \"" + name + "\"");
                    db.Update(oppT, dict, "DisplayName LIKE \"" + name + "\"");
                    db.Update(plOppT, dict, "DisplayName LIKE \"" + name + "\"");
                }

                MainWindow.AddInfo = "$$TEAMSENABLED";
                Close();
            }
            else if (_mode == Mode.HiddenPlayers)
            {
                var db = new SQLiteDatabase(_currentDB);

                var dataList  = new List <Dictionary <string, string> >();
                var whereList = new List <string>();

                foreach (KeyValuePair <int, string> item in lstEnabled.Items)
                {
                    var dict = new Dictionary <string, string> {
                        { "isHidden", "False" }
                    };
                    dataList.Add(dict);
                    whereList.Add("ID = " + item.Key);
                }
                db.UpdateManyTransaction(_playersT, dataList, whereList);

                dataList  = new List <Dictionary <string, string> >();
                whereList = new List <string>();
                foreach (KeyValuePair <int, string> item in lstDisabled.Items)
                {
                    var q =
                        "select * from PlayerResults INNER JOIN GameResults ON GameResults.GameID = PlayerResults.GameID where SeasonNum = "
                        + _curSeason + " AND PlayerID = " + item.Key;
                    var res = db.GetDataTable(q, true);

                    if (res.Rows.Count > 0)
                    {
                        var r = MessageBox.Show(
                            item.Value + " has box scores this season. Are you sure you want to disable them?",
                            "NBA Stats Tracker",
                            MessageBoxButton.YesNo,
                            MessageBoxImage.Question);

                        if (r == MessageBoxResult.No)
                        {
                            continue;
                        }
                    }

                    var dict = new Dictionary <string, string> {
                        { "isHidden", "True" }, { "isActive", "False" }, { "TeamFin", "" }
                    };
                    dataList.Add(dict);
                    whereList.Add("ID = " + item.Key);
                }
                db.UpdateManyTransaction(_playersT, dataList, whereList);

                MainWindow.AddInfo = "$$PLAYERSENABLED";
                Close();
            }
            else if (_mode == Mode.REDitor)
            {
                if (lstEnabled.Items.Count != 30)
                {
                    MessageBox.Show(
                        "You can't have less or more than 30 teams enabled. You currently have " + lstEnabled.Items.Count + ".");
                    return;
                }

                //MainWindow.selectedTeams = new List<Dictionary<string, string>>(_activeTeams);
                MainWindow.SelectedTeams = new List <Dictionary <string, string> >();
                foreach (string team in lstEnabled.Items)
                {
                    var teamName = team.Split(new[] { " (ID: " }, StringSplitOptions.None)[0];
                    MainWindow.SelectedTeams.Add(
                        _validTeams.Find(
                            delegate(Dictionary <string, string> t)
                    {
                        if (t["Name"] == teamName)
                        {
                            return(true);
                        }
                        return(false);
                    }));
                }
                MainWindow.SelectedTeamsChanged = _changed;
                DialogResult = true;
                Close();
            }
            else if (_mode == Mode.TradePlayers)
            {
                foreach (var pair in _rosters)
                {
                    var newTeam = pair.Key;
                    foreach (var pID in pair.Value)
                    {
                        var oldTeam  = MainWindow.PST[pID].TeamF;
                        var oldTeamS = MainWindow.PST[pID].TeamS;
                        if (newTeam != oldTeam)
                        {
                            if (oldTeamS == -1)
                            {
                                MainWindow.PST[pID].TeamS = MainWindow.PST[pID].TeamF;
                            }
                            MainWindow.PST[pID].TeamF    = newTeam;
                            MainWindow.PST[pID].IsSigned = newTeam != -1;
                        }
                    }
                }

                DialogResult = true;
                Close();
            }
        }