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