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