예제 #1
0
파일: TEST.cs 프로젝트: ibeae/ThinkAway.net
        public void MsSqlTest()
        {
            DbHelper dbHelper = new MsSQL("test");

            using (TransactionScope transactionScope = new TransactionScope())
            {
                for (int i = 0; i < 10; i++)
                {
                    ContentValues contentValues = new ContentValues();
                    contentValues.Add("Name", "lsong");
                    contentValues.Add("Password", "123456");
                    dbHelper.Insert("myTable", contentValues);
                }
                transactionScope.Complete();
            }


            using (Cursor cursor = dbHelper.Query("myTable", null, null, null))
            {
                while (cursor.Next())
                {
                    System.Console.Write(cursor[0] + "    ");
                    System.Console.Write(cursor[1] + "    ");
                    System.Console.Write(cursor[2]);
                    System.Console.WriteLine();
                }
            }


            System.Console.ReadKey(true);
        }
예제 #2
0
        private void bunifuThinButton21_Click(object sender, EventArgs e)
        {
            DataTable table = database.Select("Signin", null, " Us = '" + txtUser.Text + "' OR Em = '" + txtEmail.Text + "'");

            if (table.Rows.Count == 0)
            {
                if (txtUser.Text == "" || txtEmail.Text == "" || txtPassword.Text == "" || txtConfirm.Text == "")
                {
                    MessageBox.Show("Please Fill out Information!", "Failed!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
                else
                {
                    if (txtPassword.Text == txtConfirm.Text)
                    {
                        ContentValues data = new ContentValues();
                        data.Add("Us", txtUser.Text);
                        data.Add("Pass", txtPassword.Text);
                        data.Add("Em", txtEmail.Text);


                        database.Insert("Signin", data);
                        MessageBox.Show("Credentials Inserted Successfully");
                    }
                    else
                    {
                        MessageBox.Show("Password didn't match!", "Failed!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                }
            }
            else
            {
                MessageBox.Show("Username or Email Already Exists! Please try again");
            }
        }
예제 #3
0
 private void materialRaisedButton1_Click(object sender, EventArgs e)
 {
     if (txtTitle.Text == "" || txtDescription.Text == "" || txtImagePath.Text == "" || txtPDFPath.Text == "")
     {
         MessageBox.Show("Please Complete All The Fields");
     }
     else
     {
         String[]      image  = txtImagePath.Text.Split('.');
         String[]      pdf    = txtPDFPath.Text.Split('.');
         ContentValues values = new ContentValues();
         values.Add("Title", txtTitle.Text);
         values.Add("Image_Path", "Images/" + txtTitle.Text + "." + image[image.Length - 1]);
         values.Add("PDFPath", "PDFs/" + txtTitle.Text + "." + pdf[pdf.Length - 1]);
         values.Add("Description", txtDescription.Text);
         if (lblID.Visible == false)
         {
             database.Insert("Module_Data", values);
             if (!File.Exists(AppDomain.CurrentDomain.BaseDirectory + "/Images/" + txtTitle.Text + "." + image[image.Length - 1]))
             {
                 File.Copy(txtImagePath.Text, AppDomain.CurrentDomain.BaseDirectory + "/Images/" + txtTitle.Text + "." + image[image.Length - 1]);
             }
             if (!File.Exists(AppDomain.CurrentDomain.BaseDirectory + "/PDFs/" + txtTitle.Text + "." + pdf[pdf.Length - 1]))
             {
                 File.Copy(txtPDFPath.Text, AppDomain.CurrentDomain.BaseDirectory + "/PDFs/" + txtTitle.Text + "." + pdf[pdf.Length - 1]);
             }
             MessageBox.Show("Module Added Succesfully");
         }
         else
         {
             database.Update("Module_Data", values, " ID  = " + lblID.Text);
             try
             {
                 if (IMGPATH.Equals(txtImagePath.Text))
                 {
                 }
                 else if (PDFPATH.Equals(txtPDFPath.Text))
                 {
                 }
                 else
                 {
                     if (!File.Exists(AppDomain.CurrentDomain.BaseDirectory + "/Images/" + txtTitle.Text + "." + image[image.Length - 1]))
                     {
                         File.Copy(txtImagePath.Text, AppDomain.CurrentDomain.BaseDirectory + "/Images/" + txtTitle.Text + "." + image[image.Length - 1]);
                     }
                     if (!File.Exists(AppDomain.CurrentDomain.BaseDirectory + "/PDFs/" + pdf[pdf.Length - 1]))
                     {
                         File.Copy(txtPDFPath.Text, AppDomain.CurrentDomain.BaseDirectory + "/PDFs/" + txtTitle.Text + "." + pdf[pdf.Length - 1]);
                     }
                     MessageBox.Show("Updated Added Succesfully");
                 }
             }
             catch (Exception ex)
             {
                 MessageBox.Show("An error occur " + ex);
             }
         }
     }
 }
예제 #4
0
        public CheckQuiz(List <String> checkAnswer, String Title)
        {
            InitializeComponent();
            this.Text = Title;
            database  = new Database(new OleDbConnection(Properties.Settings.Default.ConnectionString), new OleDbCommand());
            database.setAdapter(new OleDbDataAdapter());

            var materialSkinManager = MaterialSkinManager.Instance;

            materialSkinManager.AddFormToManage(this);
            materialSkinManager.Theme       = MaterialSkinManager.Themes.LIGHT;
            materialSkinManager.ColorScheme = new ColorScheme(Primary.Cyan800, Primary.Cyan900, Primary.Cyan500, Accent.LightBlue200, TextShade.WHITE);
            foreach (String a in checkAnswer)
            {
                CorrectAnswers answers = new CorrectAnswers(parseString(a)[0], parseString(a)[1], parseString(a)[2], Boolean.Parse(parseString(a)[3]));
                answers.Top  = posY;
                answers.Left = 4;
                posY         = (answers.Top + answers.Height + 4);
                this.panel1.Controls.Add(answers);
                if (Boolean.Parse(parseString(a)[3]))
                {
                    score++;
                }
            }
            DataTable count = database.Select("Quiz", null, " Quiz_Title = '" + this.Text + "'");

            countControls = count.Rows.Count;
            DataTable table = database.Select("Score", null, " Quiz_Title = '" + this.Text + "'");
            DataTable user  = database.Select("Signin", null, " Us = '" + Properties.Settings.Default.Username + "'");

            table.DefaultView.Sort = "ID";
            table = table.DefaultView.ToTable();
            ContentValues values = new ContentValues();

            values.Add("Quiz_Title", this.Text);
            values.Add("Score", score + " / " + countControls);
            values.Add("isPass", score > (countControls / 2) ? "True" : "False");
            values.Add("Us", Properties.Settings.Default.Username);
            values.Add("Email", user.Rows[0]["Em"].ToString());
            if (table.Rows.Count != 0)
            {
                database.Update("Score", values, " Quiz_Title = '" + this.Text + "'");
            }
            else
            {
                database.Insert("Score", values);
            }
            timer1.Interval = 1000;
            timer1.Start();
        }
예제 #5
0
 private void materialRaisedButton1_Click(object sender, EventArgs e)
 {
     if (!rbAdmin.Checked && !rbStudent.Checked)
     {
         MessageBox.Show("Select Account Type!");
     }
     else if (txtUser.Text == "")
     {
         MessageBox.Show("Please Enter Username!");
     }
     else if (txtEmail.Text == "")
     {
         MessageBox.Show("Please Enter Email!");
     }
     else if (txtPassword.Text == "")
     {
         MessageBox.Show("Please Enter Password!");
     }
     else
     {
         if (lblID.Visible == true)
         {
             ContentValues values = new ContentValues();
             values.Add("Account_Type", rbAdmin.Checked ? "Admin" : "User");
             values.Add("Us", txtUser.Text);
             values.Add("Pass", txtPassword.Text);
             values.Add("Em", txtEmail.Text);
             database.Update("Signin", values, " ID = " + lblID.Text);
         }
         else
         {
             ContentValues values = new ContentValues();
             values.Add("Account_Type", rbAdmin.Checked ? "Admin" : "User");
             values.Add("Us", txtUser.Text);
             values.Add("Pass", txtPassword.Text);
             values.Add("Em", txtEmail.Text);
             database.Insert("Signin", values);
         }
     }
 }
예제 #6
0
        private void materialRaisedButton1_Click(object sender, EventArgs e)
        {
            ContentValues values = new ContentValues();

            values.Add("Quiz_Title", dropdown.selectedValue);
            values.Add("QuestionNo", lblNo.Text);
            values.Add("Question", txtQuestion.Text);
            String[] choices = txtChoices.Text.Split('\n');
            values.Add("A", choices[0]);
            values.Add("B", choices[1]);
            values.Add("C", choices[2]);
            values.Add("D", choices[3]);
            values.Add("Correct_Answer", txtCorrectAnswer.Text);
            if (lblID.Visible == false)
            {
                database.Insert("Quiz", values);
                MessageBox.Show("Data Added Succesfully");
            }
            else
            {
                database.Update("Quiz", values, " ID = " + lblID.Text);
                MessageBox.Show("Data Updated Succesfully");
            }
        }