public List <Muayeneler> GetAllExemination() { List <Muayeneler> ExeminationList = new List <Muayeneler>(); cmd = new SqlCommand("Select * from Muayeneler", conn); //reference tipli bir değişken olan user classı default tipi null o yüzden atama yaptık Muayeneler currentExemination = null; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { //her bir satırda oluşturmak gerekir. currentExemination = new Muayeneler(); //boxing-unboxing yapmadan veriyi isteğimiz formatta okuyup getiriyor. currentExemination.MuayeneID = reader.GetInt32(0); currentExemination.HastaGeldiMi = reader.GetByte(1); currentExemination.RandevuID = reader.GetInt32(2); currentExemination.MuayeneNot = reader.GetString(3); ExeminationList.Add(currentExemination); } reader.Close(); return(ExeminationList); }
public RandevuDetay(Randevular randevu) { InitializeComponent(); seciliRandevu = randevu; muayene = new Muayeneler(); _muayenelerController = new MuayenelerController(); _randevularController = new RandevularController(); }
public int Add(Muayeneler muayene) { string query = "Insert into Muayeneler values(@GeldiMi,@RandevuId,@MuayeneNot)"; cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@GeldiMi", muayene.HastaGeldiMi); cmd.Parameters.AddWithValue("@RandevuId", muayene.RandevuID); cmd.Parameters.AddWithValue("@MuayeneNot", muayene.MuayeneNot); conn.Open(); int result = cmd.ExecuteNonQuery(); conn.Close(); return(result); }
public Muayeneler GetExeminationByID(int exeId) { cmd = new SqlCommand("Select * from Muayeneler where MuayeneID=@Id", conn); cmd.Parameters.AddWithValue("@Id", exeId); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); reader.Read(); Muayeneler currentExemination = new Muayeneler(); currentExemination.MuayeneID = exeId; currentExemination.HastaGeldiMi = reader.GetByte(1); currentExemination.RandevuID = reader.GetInt32(2); currentExemination.MuayeneNot = reader.GetString(3); reader.Close(); return(currentExemination); }
public bool Delete(Muayeneler muayene) { int result = _muayenelerManagement.Delete(muayene.MuayeneID); return(result > 0); }
public bool Add(Muayeneler muayene) { int result = _muayenelerManagement.Add(muayene); return(result > 0); }