public static bool OdulCezaGuncelle(OdulCeza odulceza) { string sql = "UPDATE odulceza set ceza1 = " + odulceza.Ceza1 + ", ceza2=" + odulceza.Ceza2 + ", odul1 = " + odulceza.Odul1 + ", odul2 = " + odulceza.Odul2 + " where id = 1"; _connection.Open(); MySqlCommand cmd = new MySqlCommand(sql, _connection); int res = cmd.ExecuteNonQuery(); _connection.Close(); if (res != -1) { MessageBox.Show("Başarıyla güncellendi"); return(true); } MessageBox.Show("Bir sorun oluştu!"); return(false); }
public static OdulCeza OdulCezaCek() { string sql = "select *from odulceza"; _connection.Open(); MySqlCommand cmd = new MySqlCommand(sql, _connection); MySqlDataReader reader = cmd.ExecuteReader(); OdulCeza odulceza = new OdulCeza(); if (reader.Read()) { odulceza.ID = reader.GetInt32(0); odulceza.Ceza1 = reader.GetInt32(1); odulceza.Ceza2 = reader.GetInt32(2); odulceza.Odul1 = reader.GetInt32(3); odulceza.Odul2 = reader.GetInt32(4); } _connection.Close(); return(odulceza); }