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(); } }