private void Btn_save_MouseClick(object sender, System.Windows.Forms.MouseEventArgs e)
{
Appointment appointment = new Appointment();
using (var dE = new Model.DataModel.databaseEntities())
{
dE.Appointments.Add(appointment);
dE.SaveChanges();
}
ClinicPanel clinicPanel = ClinicPanel.getThis();
clinicPanel.switchLateralPanel(new ListViewPanel(1), SlidePanel.Slide.Right);
}
private void loadList(string model)
{
clinic_listview.Clear();
using (var dE = new Model.DataModel.databaseEntities())
{
if (model == "appointment")
{
var results = from a in dE.Appointments
select new
{
Numero = a.id,
Pessoa = a.person_id,
Convênio = a.healthplan_id,
Data = a.schedule
};
string[] items = { "", "Número", "Pessoa", "Convênio", "Data" };
foreach (string s in items)
{
clinic_listview.Columns.Add(s);
}
foreach (var i in results)
{
ListViewItem lvitem = new ListViewItem();
lvitem.SubItems.Add(i.Numero.ToString());
lvitem.SubItems.Add(i.Pessoa.ToString());
lvitem.SubItems.Add(i.Convênio.ToString());
if (i.Data != null)
{
lvitem.SubItems.Add(i.Data.ToString());
}
else
{
lvitem.SubItems.Add("Sem data registrada");
}
clinic_listview.Items.Add(lvitem);
}
}
else if (model == "doctor")
{
var results = from d in dE.People
where d.specialization_id >= 0
join spec in dE.Specializations on d.specialization_id equals spec.id
select new
{
Id = d.id,
Nome = d.name,
Idade = d.age,
Especialização = spec.name
};
string[] items = { "", "Identificador", "Nome", "Idade", "Especialização" };
foreach (string s in items)
{
clinic_listview.Columns.Add(s);
}
foreach (var i in results)
{
ListViewItem lvitem = new ListViewItem();
lvitem.SubItems.Add(i.Id.ToString());
if (i.Nome != null)
{
lvitem.SubItems.Add(i.Nome.ToString());
}
else
{
lvitem.SubItems.Add("Sem nome registrada");
}
if (i.Idade != null)
{
lvitem.SubItems.Add(i.Idade.ToString());
}
else
{
lvitem.SubItems.Add("Sem idade registrada");
}
if (i.Especialização != null)
{
lvitem.SubItems.Add(i.Especialização.ToString());
}
else
{
lvitem.SubItems.Add("Sem data registrada");
}
clinic_listview.Items.Add(lvitem);
}
}
else if (model == "pacient")
{
var results = from p in dE.People
where p.specialization_id == 0
select new
{
Id = p.id,
Nome = p.name,
Idade = p.age,
Telefone = p.phone,
Endereço = p.address,
Spec = p.specialization_id
};
string[] items = { "", "Identificador", "Nome", "Idade", "Telefone", "Endereço" };
foreach (string s in items)
{
clinic_listview.Columns.Add(s);
}
foreach (var i in results)
{
ListViewItem lvitem = new ListViewItem();
lvitem.SubItems.Add(i.Id.ToString());
if (i.Nome != null)
{
lvitem.SubItems.Add(i.Nome.ToString());
}
else
{
lvitem.SubItems.Add("Sem nome registrada");
}
if (i.Idade != null)
{
lvitem.SubItems.Add(i.Idade.ToString());
}
//else
//lvitem.SubItems.Add("Sem idade registrada");
if (i.Endereço != null)
{
lvitem.SubItems.Add(i.Endereço.ToString());
}
//else
//lvitem.SubItems.Add("");
clinic_listview.Items.Add(lvitem);
}
}
else if (model == "healthplan")
{
var results = from hp in dE.Healthplans
select new
{
Id = hp.id,
Nome = hp.name,
};
string[] items = { "", "Identificador", "Nome" };
foreach (string s in items)
{
clinic_listview.Columns.Add(s);
}
foreach (var i in results)
{
ListViewItem lvitem = new ListViewItem();
lvitem.SubItems.Add(i.Id.ToString());
if (i.Nome != null)
{
lvitem.SubItems.Add(i.Nome.ToString());
}
else
{
lvitem.SubItems.Add("Sem nome registrada");
}
clinic_listview.Items.Add(lvitem);
}
}
else if (model == "prescription")
{
var results = from p in dE.Prescriptions
select new
{
Id = p.id,
Nome = p.name
};
string[] items = { "", "Identificador", "Nome" };
foreach (string s in items)
{
clinic_listview.Columns.Add(s);
}
foreach (var i in results)
{
ListViewItem lvitem = new ListViewItem();
lvitem.SubItems.Add(i.Id.ToString());
if (i.Nome != null)
{
lvitem.SubItems.Add(i.Nome.ToString());
}
else
{
lvitem.SubItems.Add("Sem nome registrada");
}
clinic_listview.Items.Add(lvitem);
}
}
}
clinic_listview.Columns[0].Width = 0;
int widht = clinic_listview.Width / (clinic_listview.Columns.Count - 1);
for (int i = 1; i < clinic_listview.Columns.Count; i++)
{
clinic_listview.Columns[i].Width = widht;
}
clinic_listview.MultiSelect = false;
clinic_listview.FullRowSelect = true;
clinic_listview.View = View.Details;
}
