public bool HastaGecmisiEkle(HastaGecmisi hg) { bool Sonuc = false; SqlCommand comm = new SqlCommand("Insert into HastaGecmisi(aciklama,hastaID) values(@aciklama,@hastaID)", conn); comm.Parameters.Add("@hastaID", SqlDbType.Int).Value = hg._hastaID; comm.Parameters.Add("@aciklama", SqlDbType.VarChar).Value = hg._aciklama; 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 HastaGecmisiDuzenle(HastaGecmisi hg) { bool Sonuc = false; SqlCommand comm = new SqlCommand("Update HastaGecmisi set aciklama=@aciklama where gecmisID=@gecmisID", conn); comm.Parameters.Add("@gecmisID", SqlDbType.Int).Value = hg._gecmisID; comm.Parameters.Add("@aciklama", SqlDbType.VarChar).Value = hg._aciklama; 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); }