private void btnLogin_Click(object sender, EventArgs e)
{
if (tbUser.Text.Equals(Resources.AdminUser) &&
tbPass.Text.Equals(Resources.AdminPass))
{
Medic admin = new Medic()
{
isAdmin = true
};
Program.utilizator_curent = admin;
return;
}
var db = new CabinetEntities();
var user = (from u in db.Medic
where u.User.Equals(tbUser.Text) &&
u.Pass.Equals(tbPass.Text)
select u).FirstOrDefault();
if (user == null)
{
this.lblLoginError.Visible = true;
this.DialogResult = DialogResult.None;
}
else
{
Program.utilizator_curent = user;
}
}
private void ListaPreturiForm_Load(object sender, EventArgs e)
{
var ctx = new CabinetEntities();
var preturi = (
from p in ctx.Pret
where DateTime.Now <= p.DataSfarsit && DateTime.Now >= p.DataInceput
select p).ToList();
pretBindingSource.DataSource = preturi;
}
private void PacientiNrInterventii_Load(object sender, EventArgs e)
{
var ctx = new CabinetEntities();
var list = ctx
.Interventie
.Where(i => i.MedicID == 3)
.GroupBy(i => new { i.PacientID, i.Pacient.Nume, i.Pacient.Prenume })
.Select(g => new { Pacient = g.Key.Nume + ", " + g.Key.Prenume, Numar = g.Count() })
.OrderByDescending(x => x.Numar).ToList();
dataGridView1.DataSource = list;
}
private void ListaProgramariCurenteForm_Load(object sender, EventArgs e)
{
var ctx = new CabinetEntities();
var t0 = DateTime.Today.AddHours(+8.0);
var t1 = DateTime.Today.AddHours(+16.0);
var programari =
(from p in ctx.Programare
where p.MedicID == Program.utilizator_curent.MedicID &&
t0 <= p.DataOra && p.DataOra <= t1
select p).ToList();
programareBindingSource.DataSource = programari;
}
