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