Example #1
0
 private void ListeDuzenle_Load(object sender, EventArgs e)
 {
     textBox1.Text = DBCommands.getListNames(1);
     textBox2.Text = DBCommands.getListNames(2);
     textBox3.Text = DBCommands.getListNames(3);
     textBox4.Text = DBCommands.getListNames(4);
 }
Example #2
0
        public static void historyView()
        {
            DataSet ds = new DataSet();

            ds            = DBCommands.getList("History");
            da.DataSource = ds.Tables[0];
        }
Example #3
0
 private void Listelerim_Load(object sender, EventArgs e)
 {
     button1.Text = DBCommands.getListNames(1);
     button2.Text = DBCommands.getListNames(2);
     button3.Text = DBCommands.getListNames(3);
     button4.Text = DBCommands.getListNames(4);
 }
Example #4
0
 private void GelismisArama_Load(object sender, EventArgs e)
 {
     radioButton1.Text = DBCommands.getListNames(1);
     radioButton2.Text = DBCommands.getListNames(2);
     radioButton3.Text = DBCommands.getListNames(3);
     radioButton4.Text = DBCommands.getListNames(4);
 }
Example #5
0
 private void GörevDüzenle_Load(object sender, EventArgs e)
 {
     textBox1.Text        = DBCommands.getData("Title", id);
     comboBox1.Text       = DBCommands.getData("Priority", id);
     dateTimePicker1.Text = DBCommands.getData("Date", id);
     richTextBox1.Text    = DBCommands.getData("Text", id);
 }
Example #6
0
        private void List_Load(object sender, EventArgs e)
        {
            dg = dataGridView1;
            DataSet ds = DBCommands.getList("Tasks", "ListNo", Taskup.selectedList.ToString());

            dataGridView1.DataSource = ds.Tables[0];
            button5.Text             = DBCommands.getListNames(Taskup.selectedList);
        }
Example #7
0
        private void button2_Click(object sender, EventArgs e)
        {
            string date = dateTimePicker1.Value.ToString("yyyy-MM-dd");

            DBCommands.updateTask(date, textBox1.Text, richTextBox1.Text, comboBox1.Text.ToString(), id);
            GelismisArama.refresh();
            this.Hide();
        }
Example #8
0
 private void button3_Click(object sender, EventArgs e)
 {
     foreach (DataGridViewRow drow in dataGridView1.SelectedRows)
     {
         int id = Convert.ToInt32(drow.Cells[0].Value);
         DBCommands.deleteTask(id.ToString());
         refresh();
     }
 }
Example #9
0
 private void Taskup_Load(object sender, EventArgs e)
 {
     mpanel          = panel;
     pbtnListeler    = btnListeler;
     pbtnHareketler  = btnHareketler;
     pbtnAyarlar     = btnAyarlar;
     pcolor_bar      = color_bar;
     pmenuListeler   = menuListeler;
     pmenuHareketler = menuHareketler;
     pmenuAyarlar    = menuAyarlar;
     DBCommands.dbCreate();
 }
Example #10
0
 private void button4_Click(object sender, EventArgs e)
 {
     DBCommands.dbConnect();
     using (DBCommands.con)
     {
         using (SQLiteCommand cmd = new SQLiteCommand(DBCommands.con))
         {
             cmd.CommandText = "update Lists set ListName='" + textBox4.Text + "' Where ListNo=4";
             cmd.ExecuteNonQuery();
             DBCommands.dbDisconnect();
         }
     }
 }
Example #11
0
        public static void refresh()
        {
            DataSet ds = DBCommands.getList("Tasks", "ListNo", Taskup.selectedList.ToString());

            dg.DataSource = ds.Tables[0];
        }
Example #12
0
 private void button2_Click(object sender, EventArgs e)
 {
     DBCommands.insertTask(Taskup.selectedList.ToString(), dateTimePicker1.Value, textBox1.Text, richTextBox1.Text, comboBox1.SelectedItem.ToString(), "Devam Ediyor");
     List.refresh();
     this.Hide();
 }