public ReceteEntities RandevuIdyeGore(int RandevuID) { ReceteEntities currentUser = new ReceteEntities(); cmd = new SqlCommand("Select * From receteler Where RandevuID = @id", conn); cmd.Parameters.AddWithValue("@id", RandevuID); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); reader.Read(); currentUser.ReceteID = reader.GetInt32(0); currentUser.IlacID = reader.GetInt32(1); currentUser.RandevuID = reader.GetInt32(2); reader.Close(); return(currentUser); }
public MuayeneFrm(RandevuHastaDTO randevudakiHasta) { InitializeComponent(); teshisController = new TeshisController(); tahlilController = new TahlilController(); randevuController = new RandevuController(); muayeneController = new MuayeneController(); receteController = new ReceteController(); dctController = new DoktorCalismaTakvimiController(); recete = new ReceteEntities(); ilacController = new IlacController(); muayene = new MuayeneEntities(); this.randevudakiHasta = randevudakiHasta; lblHasta.Text = randevudakiHasta.HastaFullAd; gBoxTeshis.Hide(); gBoxTahlil.Hide(); }
public MuayeneFrm(MuayeneEntities muane, HastaEntities hasta) { InitializeComponent(); this.FormBorderStyle = FormBorderStyle.Sizable; teshisController = new TeshisController(); tahlilController = new TahlilController(); randevuController = new RandevuController(); muayeneController = new MuayeneController(); receteController = new ReceteController(); recete = new ReceteEntities(); ilacController = new IlacController(); muayene = new MuayeneEntities(); lblHasta.Text = hasta.Adi + " " + hasta.Soyadi; foreach (Control item in this.Controls) { item.Enabled = false; } txtNot.Text = muane.Not; if (muane.TeshisID == 0) { rButtonTahlil.Checked = true; gBoxTahlil.Show(); cmbTahlil.SelectedIndex = muane.TahlilID; } else if (muane.TahlilID == 0) { rButtonTeshis.Checked = true; gBoxTeshis.Show(); cmbTeshis.SelectedIndex = muane.TeshisID; cmbIlac.DataSource = null; } else { MessageBox.Show("Sıkıntı var"); } }
public List <ReceteEntities> TumReceteleriGetir() { List <ReceteEntities> ReceteList = new List <ReceteEntities>(); cmd = new SqlCommand("Select * From Receteler", conn); ReceteEntities currentUser = null; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { currentUser = new ReceteEntities() { ReceteID = reader.GetInt32(0), IlacID = reader.GetInt32(1), RandevuID = reader.GetInt32(2) }; ReceteList.Add(currentUser); } reader.Close(); return(ReceteList); }
public bool Add(ReceteEntities recete) { return(receteManagement.Add(recete) > 0); }
public int Add(ReceteEntities recete) { cmd = new SqlCommand("INSERT INTO Receteler VALUES (@ilacID,@randevuID)", conn); AddParametersToCommand(recete); return(ExecuteCommand()); }
void AddParametersToCommand(ReceteEntities recete) { cmd.Parameters.AddWithValue("@ilacID", recete.IlacID); cmd.Parameters.AddWithValue("@randevuID", recete.RandevuID); }