void AddParametersToCommand(MuayeneEntities muayene) { cmd.Parameters.AddWithValue("@randevuID", muayene.RandevuID); cmd.Parameters.AddWithValue("@teshisID", muayene.TeshisID); cmd.Parameters.AddWithValue("@tahlilID", muayene.TahlilID); cmd.Parameters.AddWithValue("@not", muayene.Not); }
public List <MuayeneEntities> TumMuayeneleriGetir() { List <MuayeneEntities> MuayeneList = new List <MuayeneEntities>(); cmd = new SqlCommand("Select * From Muayeneler", conn); MuayeneEntities currentUser = null; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { currentUser = new MuayeneEntities() { MuayeneID = reader.GetInt32(0), RandevuID = reader.GetInt32(1), TeshisID = reader.GetInt32(2), TahlilID = reader.GetInt32(3), Not = reader.GetString(4) }; MuayeneList.Add(currentUser); } reader.Close(); return(MuayeneList); }
private void lsvMuaneler_DoubleClick(object sender, EventArgs e) { MuayeneEntities muayene = muayeneController.getMuayeneByID(int.Parse(lsvMuaneler.SelectedItems[0].Text)); this.Hide(); MuayeneFrm muayeneFrm = new MuayeneFrm(muayene, hasta); muayeneFrm.Show(); muayeneFrm.Owner = this; }
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 MuayeneEntities GetMuayeneByID(int ID) { MuayeneEntities muayene = new MuayeneEntities(); cmd = new SqlCommand("select * from Muayeneler where MuayeneID=@id", conn); cmd.Parameters.AddWithValue("@id", ID); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); reader.Read(); muayene.MuayeneID = reader.GetInt32(0); muayene.RandevuID = reader.GetInt32(1); muayene.TeshisID = reader.GetInt32(2); muayene.TahlilID = reader.GetInt32(3); muayene.Not = reader.GetString(4); reader.Close(); return(muayene); }
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 int Add(MuayeneEntities muayene) { cmd = new SqlCommand("INSERT INTO Muayeneler VALUES (@randevuID,@teshisID,@tahlilID,@not)", conn); AddParametersToCommand(muayene); return(ExecuteCommand()); }
public bool Add(MuayeneEntities muayene) { return(muayeneManagement.Add(muayene) > 0); }