public static YakitTuru GetObjectById(int id) { YakitTuru item = null; string connectionString = "Server=localhost;Database=aracalissatis;Uid=root;Pwd=P@ssw0rd1!;"; string commandString = "SELECT * FROM tbl_yakitturu WHERE YakitTuruID=@YakitTuruID"; using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(commandString, con)) { cmd.Parameters.AddWithValue("@YakitTuruID", id); MySqlDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { item = new YakitTuru(); item.YakitTuruAdi = dr["Yakit_Turu"] != DBNull.Value ? dr["Yakit_Turu"].ToString() : string.Empty; item.YakitTuruID = Convert.ToInt32(dr["YakitTuruID"]); } } } return(item); }
private void btnEdit_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { MessageBox.Show("Düzenlemek istediğiniz satırı seçin", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int yakitTuruId = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value); YakitTuru yakitTuru = YakitTuruManager.GetObjectById(yakitTuruId); frmYakitTuruDetay frm = new frmYakitTuruDetay(yakitTuru); frm.ShowDialog(); }
public static void Insert(YakitTuru item) { string connectionString = "Server=localhost;Database=aracalissatis;Uid=root;Pwd=P@ssw0rd1!;"; string commandString = "INSERT INTO tbl_yakitturu(YakitTuruID,Yakit_Turu) VALUES(0,@Yakit_Turu)"; using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(commandString, con)) { cmd.Parameters.AddWithValue("@Yakit_Turu", item.YakitTuruAdi); cmd.ExecuteNonQuery(); } } }
public static void Update(YakitTuru item) { string connectionString = "Server=localhost;Database=aracalissatis;Uid=root;Pwd=P@ssw0rd1!;"; string commandString = "UPDATE tbl_yakitturu SET Yakit_Turu=@Yakit_Turu WHERE YakitTuruID=@YakitTuruID"; using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(commandString, con)) { cmd.Parameters.AddWithValue("@Yakit_Turu", item.YakitTuruAdi); cmd.Parameters.AddWithValue("@YakitTuruID", item.YakitTuruID); cmd.ExecuteNonQuery(); } } }
static void Main() { LastikTuru araba = new LastikTuru(); araba.Coupe = "BMW"; YakitTuru benzin = new YakitTuru(); benzin.Coupe = "Vw"; ArabaTuru araba2 = araba; Galeri galeri = new Galeri(); //galeri.Satis(benzin); galeri.Satis(araba2); // galeri.Satis(araba); }
public static List <YakitTuru> GetObjects() { List <YakitTuru> items = new List <YakitTuru>(); string connectionString = "Server=localhost;Database=aracalissatis;Uid=root;Pwd=P@ssw0rd1!;"; string commandString = "SELECT * FROM tbl_yakitturu"; using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(commandString, con)) { MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { YakitTuru item = new YakitTuru(); item.YakitTuruAdi = dr["Yakit_Turu"] != DBNull.Value ? dr["Yakit_Turu"].ToString() : string.Empty; item.YakitTuruID = Convert.ToInt32(dr["YakitTuruID"]); items.Add(item); } } } return(items); }
private void btnSave_Click(object sender, EventArgs e) { try { if (willUpdateItem != null) { willUpdateItem.YakitTuruAdi = txtYakitTuru.Text; YakitTuruManager.Update(willUpdateItem); } else { YakitTuru yakitTuru = new YakitTuru(); yakitTuru.YakitTuruAdi = txtYakitTuru.Text; YakitTuruManager.Insert(yakitTuru); } MessageBox.Show("İşleminiz başarıyla gerçekleşti", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (Exception ex) { MessageBox.Show("İşleminiz gerçekleştirilirken hata oluştu :" + ex.Message); } }
public frmYakitTuruDetay(YakitTuru item) { InitializeComponent(); willUpdateItem = item; txtYakitTuru.Text = item.YakitTuruAdi; }