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