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);
}
public static void historyView()
{
DataSet ds = new DataSet();
ds = DBCommands.getList("History");
da.DataSource = ds.Tables[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);
}
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);
}
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);
}
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);
}
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();
}
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();
}
}
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();
}
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();
}
}
}
public static void refresh()
{
DataSet ds = DBCommands.getList("Tasks", "ListNo", Taskup.selectedList.ToString());
dg.DataSource = ds.Tables[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();
}