private void btnKaydet_Click(object sender, EventArgs e)
{
connection = SqlConn.MakeConnection();
SqlCommand command = new SqlCommand("INSERT INTO Egitimlerim (Baslik,AltBaslik,Saat,Dakika,Durum) VALUES (@Baslik,@AltBaslik,@Saat,@Dakika,@Durum)", connection);
command.Parameters.AddWithValue("@Baslik", txtEgitimBasligi.Text);
command.Parameters.AddWithValue("@AltBaslik", txtEgitimAltBasligi.Text);
command.Parameters.AddWithValue("@Saat", txtSaat.Text);
command.Parameters.AddWithValue("@Dakika", txtDakika.Text);
command.Parameters.AddWithValue("@Durum", "Başlamadı");
command.ExecuteNonQuery();
MessageBox.Show("Kayıt Başarılı");
if (txtEgitimAltBasligi.Text == "")
{
txtEgitimBasligi.Text = string.Empty;
txtEgitimAltBasligi.Text = string.Empty;
txtSaat.Text = string.Empty;
txtDakika.Text = string.Empty;
txtEgitimBasligi.Focus();
}
else
{
txtEgitimAltBasligi.Text = string.Empty;
txtSaat.Text = string.Empty;
txtDakika.Text = string.Empty;
txtEgitimAltBasligi.Focus();
}
}
public int ToplamSaat()
{
int toplamSaat = 0;
connection = SqlConn.MakeConnection();
SqlCommand command = new SqlCommand("SELECT SUM(Saat) AS ToplamSaat FROM Egitimlerim WHERE Durum='Başlamadı' OR Durum='Başladı'", connection);
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
toplamSaat = Convert.ToInt32(dr["ToplamSaat"]);
}
return(toplamSaat);
}
public int ToplamDakika()
{
int toplamDakika = 0;
connection = SqlConn.MakeConnection();
SqlCommand command = new SqlCommand("SELECT SUM(Dakika) AS ToplamDakika FROM Egitimlerim WHERE Durum='Başlamadı' OR Durum='Başladı'", connection);
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
toplamDakika = Convert.ToInt32(dr["ToplamDakika"]);
}
dr.Close();
return(toplamDakika);
}
//public void GetList(bool tumu)
//{
// connection = SqlConn.MakeConnection();
// string command_str = "";
// if (tumu)
// {
// command_str = "SELECT * FROM Egitimlerim";
// }
// else
// {
// command_str = "SELECT * FROM Egitimlerim WHERE Durum IN ('Başlamadı','Başladı')";
// }
// SqlCommand command = new SqlCommand(command_str, connection);
// SqlDataReader dr = command.ExecuteReader();
// DataTable dt = new DataTable();
// dt.Load(dr);
// dgwEgitimlerim.DataSource = dt;
// dr.Close();
//}
public void GetAllList()
{
connection = SqlConn.MakeConnection();
SqlCommand command = new SqlCommand("SELECT * FROM Egitimlerim", connection);
SqlDataReader dr = command.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
dgwEgitimlerim.DataSource = dt;
dr.Close();
SqlCommand comm = new SqlCommand("SELECT COUNT(DISTINCT Baslik) AS Count FROM Egitimlerim", connection);
SqlDataReader dr1 = comm.ExecuteReader();
if (dr1.Read())
{
label8.Visible = true;
label8.Text = dr1["Count"].ToString() + " adet eğitim";
}
dr1.Close();
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
var row = dgwEgitimlerim.SelectedRows[0];
connection = SqlConn.MakeConnection();
SqlCommand command = new SqlCommand("UPDATE Egitimlerim SET Baslik=@Baslik, AltBaslik=@AltBaslik, Saat=@Saat, Dakika=@Dakika, Durum=@Durum WHERE Id=@Id", connection);
command.Parameters.AddWithValue("@Id", row.Cells[0].Value.ToString());
command.Parameters.AddWithValue("@Baslik", txtEgitimBasligi.Text);
command.Parameters.AddWithValue("@AltBaslik", txtEgitimAltBasligi.Text);
command.Parameters.AddWithValue("@Saat", txtSaat.Text);
command.Parameters.AddWithValue("@Dakika", txtDakika.Text);
command.Parameters.AddWithValue("@Durum", cmbDurumu.SelectedItem.ToString());
command.ExecuteNonQuery();
MessageBox.Show("Güncelleme Başarılı!");
if (chkTum.Checked)
{
GetAllList();
}
else
{
GetList();
}
}
