public bool HizmetDuzenle(Hizmetler h) { bool Sonuc = false; SqlCommand comm = new SqlCommand("Update Hizmetler set hizmetAdi=@hizmetAdi,aciklama=@aciklama,klinikID=@klinikID,ucret=@ucret where hizmetID=@hizmetID", conn); comm.Parameters.Add("@hizmetAdi", SqlDbType.VarChar).Value = h._hizmetAdi; comm.Parameters.Add("@klinikID", SqlDbType.Int).Value = h._klinikID; comm.Parameters.Add("@ucret", SqlDbType.Int).Value = h._ucret; comm.Parameters.Add("@aciklama", SqlDbType.VarChar).Value = h._aciklama; comm.Parameters.Add("@hizmetID", SqlDbType.Int).Value = h._hizmetID; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } return(Sonuc); }
public bool HizmetEkle(Hizmetler h) { bool Sonuc = false; SqlCommand comm = new SqlCommand("Insert into Hizmetler(hizmetAdi,klinikID,aciklama,ucret) values (@hizmetAdi,@klinikID,@aciklama,@ucret)", conn); comm.Parameters.Add("@hizmetAdi", SqlDbType.VarChar).Value = h._hizmetAdi; comm.Parameters.Add("@klinikID", SqlDbType.Int).Value = h._klinikID; comm.Parameters.Add("@aciklama", SqlDbType.VarChar).Value = h._aciklama; comm.Parameters.Add("@ucret", SqlDbType.Int).Value = h._ucret; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } return(Sonuc); }
public bool HizmetSil(Hizmetler h) { bool Sonuc = false; SqlCommand comm = new SqlCommand("Update Hizmetler set silindi=1 where hizmetID=@hizmetID ", conn); comm.Parameters.Add("@hizmetID", SqlDbType.Int).Value = h._hizmetID; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } return(Sonuc); }