public Masa getir(int masaID) { try { sqlConnection.Open(); cmd = new SqlCommand("SELECT * FROM Masa where masaID=" + masaID, sqlConnection); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { Masa masa = new Masa(); masa.masaID = masaID; masa.masaAdi = dr["masaAdi"].ToString(); masa.masaDurumu = dr["masaDurumu"].ToString(); dr.Close(); sqlConnection.Close(); return(masa); } } } catch (Exception) { dr.Close(); if (sqlConnection.State == System.Data.ConnectionState.Open) { sqlConnection.Close(); } } return(null); }
public Masa[] liste() { List <Masa> masaListesi = new List <Masa>(); try { sqlConnection.Open(); cmd = new SqlCommand("SELECT * FROM Masa", sqlConnection); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { Masa masa = new Masa(); masa.masaID = Convert.ToInt32(dr["masaID"]); masa.masaAdi = dr["masaAdi"].ToString(); masa.masaDurumu = dr["masaDurumu"].ToString(); masaListesi.Add(masa); } } } catch (Exception) { dr.Close(); if (sqlConnection.State == System.Data.ConnectionState.Open) { sqlConnection.Close(); } } dr.Close(); sqlConnection.Close(); return(masaListesi.ToArray()); }
public string ekle(Masa masa) { try { sqlConnection.Open(); cmd = new SqlCommand("insert into Masa (masaAdi,masaDurumu) values(@masaAdi,@masaDurumu)", sqlConnection); cmd.Parameters.AddWithValue("@masaAdi", masa.masaAdi); cmd.Parameters.AddWithValue("@masaDurumu", masa.masaDurumu); sqlConnection.Close(); return("Masa eklendi."); } catch (Exception e) { if (sqlConnection.State == System.Data.ConnectionState.Open) { sqlConnection.Close(); } return("Bir hata oluştu.\nHata mesajı:" + e.Message); } }