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