public static VitesTuru GetObjectById(int id) { VitesTuru item = null; string connectionString = "Server=localhost;Database=aracalissatis;Uid=root;Pwd=P@ssw0rd1!;"; string commandString = "SELECT * FROM tbl_vitesturu WHERE VitesTuruID=@VitesTuruID"; using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(commandString, con)) { cmd.Parameters.AddWithValue("@VitesTuruID", id); MySqlDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { item = new VitesTuru(); item.VitesTuruAdi = dr["Vites_Turu"] != DBNull.Value ? dr["Vites_Turu"].ToString() : string.Empty; item.VitesTuruID = Convert.ToInt32(dr["VitesTuruID"]); } } } return(item); }
public static void Insert(VitesTuru item) { string connectionString = "Server=localhost;Database=aracalissatis;Uid=root;Pwd=P@ssw0rd1!;"; string commandString = "INSERT INTO tbl_vitesturu(VitesTuruID,Vites_Turu) VALUES(0,@Vites_Turu)"; using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(commandString, con)) { cmd.Parameters.AddWithValue("@Vites_Turu", item.VitesTuruAdi); cmd.ExecuteNonQuery(); } } }
public static void Update(VitesTuru item) { string connectionString = "Server=localhost;Database=aracalissatis;Uid=root;Pwd=P@ssw0rd1!;"; string commandString = "UPDATE tbl_vitesturu SET Vites_Turu=@Vites_Turu WHERE VitesTuruID=@VitesTuruID"; using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(commandString, con)) { cmd.Parameters.AddWithValue("@Vites_Turu", item.VitesTuruAdi); cmd.Parameters.AddWithValue("@VitesTuruID", item.VitesTuruID); cmd.ExecuteNonQuery(); } } }
public static List <VitesTuru> GetObjects() { List <VitesTuru> items = new List <VitesTuru>(); string connectionString = "Server=localhost;Database=aracalissatis;Uid=root;Pwd=P@ssw0rd1!;"; string commandString = "SELECT * FROM tbl_vitesturu"; using (MySqlConnection con = new MySqlConnection(connectionString)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(commandString, con)) { MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { VitesTuru item = new VitesTuru(); item.VitesTuruAdi = dr["Vites_Turu"] != DBNull.Value ? dr["Vites_Turu"].ToString() : string.Empty; item.VitesTuruID = Convert.ToInt32(dr["VitesTuruID"]); items.Add(item); } } } return(items); }