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