private void View_Form_Load(object sender, EventArgs e)
{
labelNume.Text = Pacient.Nume.ToString().Trim();
ViewData.Hide();
RetetaData.Hide();
BiletData.Hide();
}
private void buttonAfisare_Click(object sender, EventArgs e)
{
try
{
button1.Hide();
string tipConsutatie = comboBoxTipC.SelectedItem.ToString();
if (comboBoxTipC.SelectedItem != null)
{
using (var context = new Cabinet_MedicalEntities())
{
RetetaData.Show();
ViewData.Hide();
BiletData.Hide();
var q = from i in context.History_Patients
where i.ID_Pacient.Equals(Pacient.ID)
select i;
if (Equals(tipConsutatie, "Reteta"))
{
foreach (var reteta in q)
{
var query = (from r in context.Recipes
where r.ID_Istoric.Equals(reteta.ID)
select new
{
r.ID_Medicament,
r.Numar_Flacoane
}).FirstOrDefault();
if (query != null)
{
var afect = (from a in context.Diseases
where a.ID.Equals(reteta.ID_Afectiune)
select a).FirstOrDefault();
var med = (from m in context.Employees
where m.ID.Equals(reteta.ID_Medic)
select m).FirstOrDefault();
var medicament = (from d in context.Drugs
where d.ID.Equals(query.ID_Medicament)
select d).FirstOrDefault();
RetetaData.Rows.Add(reteta.Data.ToString().Trim(), med.Nume.ToString().Trim(), afect.Denumire.ToString().Trim(), medicament.Denumire.ToString().Trim(), query.Numar_Flacoane.ToString().Trim());
}
}
}
else if (Equals(tipConsutatie, "Bilet internare"))
{
RetetaData.Hide();
ViewData.Hide();
BiletData.Show();
foreach (var bilet in q)
{
var query = (from b in context.Internment_Tickets
where b.ID_Istoric.Equals(bilet.ID)
select new
{
b.Descriere,
b.Numar_Bilet,
}).FirstOrDefault();
if (query != null)
{
var afect = (from af in context.Diseases
where af.ID.Equals(bilet.ID_Afectiune)
select af).FirstOrDefault();
var med = (from mm in context.Employees
where mm.ID.Equals(bilet.ID_Medic)
select mm).FirstOrDefault();
BiletData.Rows.Add(bilet.Data.ToString().Trim(), med.Nume.ToString().Trim(), afect.Denumire.ToString().Trim(), query.Descriere.ToString().Trim(), query.Numar_Bilet.ToString().Trim());
}
}
}
else if (Equals(tipConsutatie, "Scutire"))
{
ViewData.Show();
RetetaData.Hide();
BiletData.Hide();
foreach (var scutire in q)
{
var query = (from s in context.Exemptions
where s.ID_Istoric.Equals(scutire.ID)
select new
{
s.Zile_Repaus,
s.Tip
}).FirstOrDefault();
if (query != null)
{
var afect = (from aa in context.Diseases
where aa.ID.Equals(scutire.ID_Afectiune)
select aa).FirstOrDefault();
var med = (from n in context.Employees
where n.ID.Equals(scutire.ID_Medic)
select n).FirstOrDefault();
ViewData.Rows.Add(scutire.Data.ToString().Trim(), med.Nume.ToString().Trim(), afect.Denumire.ToString().Trim(), query.Tip.ToString().Trim(), query.Zile_Repaus.ToString().Trim());
}
}
}
}
}
else
{
throw new Exception("Selectati un camp!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}