public bool selectid(string patfname, string patlname, string docffname, string doclname, string docrol, string dayo) { registrGANEntities connect = new registrGANEntities(); mycls.idrasp = connect.Registr .Include(i => i.Patients) .Include(ii => ii.Rasp.Doctors) .Where(w => w.Patients.LastName == patlname && w.Patients.FirstName == patfname && w.Rasp.Doctors.FirstName == docffname && w.Rasp.Doctors.LastName == doclname && w.date == dayo && w.Rasp.Doctors.Role == docrol) .Select(s => s.idRegistr) .FirstOrDefault(); mycls.into = connect.Doctorsappoin.Where(w => w.idregistr == mycls.idrasp).Select(s => s.iddoctorappoint).FirstOrDefault(); if (mycls.into != 0 || mycls.into != -1) { windowfolder.windowifin won = new windowifin(); this.Hide(); won.ShowDialog(); this.Close(); return(true); } else { MessageBox.Show("" + mycls.idrasp); return(false); } }
public bool rsad(int iddocpoint, int idreg) { registrGANEntities con = new registrGANEntities(); var abc = con.Doctorsappoin .Include(i => i.Registr) .Include(i => i.Registr.Patients) .Include(i => i.Registr.Rasp.Doctors) .Include(i => i.Medicament) .Include(i => i.Disease) .Where(w => w.iddoctorappoint == iddocpoint && w.idregistr == idreg) .ToList(); if (abc.Count() == 0 && !abc.Any()) { return(false); } else { gridtable.ItemsSource = con.Doctorsappoin .Include(i => i.Registr) .Include(i => i.Registr.Patients) .Include(i => i.Registr.Rasp.Doctors) .Include(i => i.Medicament) .Include(i => i.Disease) .Where(w => w.iddoctorappoint == iddocpoint && w.idregistr == idreg) .ToList(); return(true); } }
public bool regup(string fname, string lname, string timme, string adres, string dayof, int typepay, int rasp, int ddd) { registrGANEntities connect = new registrGANEntities(); int idp = connect.Patients.Where(w => w.FirstName == fname && w.LastName == lname && w.Adress == adres).Select(s => s.idPatiens).FirstOrDefault(); if (idp != 0 && idp != -1 && rasp != 0 && rasp != -1) { Registr reg = new Registr() { date = dayof, idrasp = rasp, idPatient = idp, time = timme, idTypepay = typepay, iduserRegistr = ddd }; connect.Registr.Add(reg); connect.SaveChanges(); return(true); } else { return(false); } }
private void btn1_Click(object sender, RoutedEventArgs e) { registrGANEntities connect = new registrGANEntities(); string dayforsearch = weeklist.Text; string finame = firsname.Text; string laname = lasname.Text; if (dayforsearch == "" && finame == "" && laname == "") { MessageBox.Show("Не введены критерии поиска"); } else if (dayforsearch == "") { MessageBoxResult result = MessageBox.Show("Упорядочить по данным доктора?", "Подтверждение", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { if (takedoc(finame, laname) == true) { gridtable.ItemsSource = connect.Rasp.Include(i => i.Doctors).Include(ii => ii.Doctors.cabin).Where(w => w.Doctors.FirstName == finame && w.Doctors.LastName == laname).ToList(); } else { MessageBox.Show("В данный день нет приемов"); } } else { } } else if (finame == "" && laname == "") { MessageBoxResult result = MessageBox.Show("Упорядочить по дню недели?", "Подтверждение", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { if (takeday(dayforsearch) == true) { gridtable.ItemsSource = connect.Rasp.Include(i => i.Doctors).Include(ii => ii.Doctors.cabin).Where(w => w.weekday == dayforsearch).ToList(); } else { MessageBox.Show("В данный день нет приемов"); } } else { } } else { if (takeall(dayforsearch, finame, laname) == true) { gridtable.ItemsSource = connect.Rasp.Include(i => i.Doctors).Include(ii => ii.Doctors.cabin).Where(w => w.weekday == dayforsearch && w.Doctors.FirstName == finame && w.Doctors.LastName == laname).ToList(); } else { MessageBox.Show("В данный день нет приемов"); } } }
private void gridtable_SelectionChanged(object sender, SelectionChangedEventArgs e) { Patients pts = gridtable.SelectedItem as Patients; registrGANEntities connect = new registrGANEntities(); if (pts != null) { mycls.id = connect.Patients.Where(w => w.FirstName == pts.FirstName && w.LastName == pts.LastName && w.MiddleName == pts.MiddleName && w.Adress == pts.Adress).Select(s => s.idPatiens).FirstOrDefault(); } }
public bool registration(string FirstN, string LastN, string MiddleN, string emal, string Adrss, string phne) { registrGANEntities Connect = new registrGANEntities(); Patients asd = new Patients(); if (FirstN == "" && LastN == "" && emal == "" && Adrss == "" && phne == "") { MessageBox.Show("Нужно заполнить все данные"); return(false); } else if (FirstN == "") { MessageBox.Show("Вы не ввели Имя"); return(false); } else if (LastN == "") { MessageBox.Show("Вы не ввели Фамилию"); return(false); } else if (emal == "") { MessageBox.Show("Вы не ввели электронную почту"); return(false); } else if (Adrss == "") { MessageBox.Show("Вы не ввели адресс"); return(false); } else if (phne == "") { MessageBox.Show("Вы не ввели номер телефона"); return(false); } else { Patients newpa = new Patients() { FirstName = FirstN, LastName = LastN, Email = emal, MiddleName = MiddleN, Adress = Adrss, Phone = phne }; asd = newpa; }; Connect.Patients.Add(asd); Connect.SaveChanges(); this.Close(); return(true); }
public bool takedoc(string fname, string lname) { registrGANEntities connect = new registrGANEntities(); var take = connect.Rasp.Include(i => i.Doctors).Include(ii => ii.Doctors.cabin).Where(w => w.Doctors.FirstName == fname && w.Doctors.LastName == lname).ToList(); if (take.Count() == 0 && !take.Any()) { return(false); } else { return(true); } }
public bool search(string fname, string lname) { registrGANEntities connect = new registrGANEntities(); var take = connect.Patients.Where(w => w.FirstName == fname && w.LastName == lname).ToList(); if (take.Count() == 0 && !take.Any()) { return(false); } else { return(true); } }
public bool takeday(string day) { registrGANEntities connect = new registrGANEntities(); var take = connect.Rasp.Include(i => i.Doctors).Include(ii => ii.Doctors.cabin).Where(w => w.weekday == day).ToList(); if (take.Count() == 0 && !take.Any()) { return(false); } else { return(true); } }
private void btn3_Click(object sender, RoutedEventArgs e) { registrGANEntities connect = new registrGANEntities(); string first = firsname.Text; string last = lasname.Text; if (search(first, last) == true) { gridtable.ItemsSource = connect.Patients.Where(w => w.FirstName == first && w.LastName == last).ToList();; } else { MessageBox.Show("Больного не существует"); } }
public bool loadsearch(string role) { registrGANEntities con = new registrGANEntities(); var doc = con.Doctors.Where(w => w.Role == role).ToList(); if (!doc.Any() && doc.Count == 0) { return(false); } else { gridtable.ItemsSource = con.Doctors.Where(w => w.Role == role).ToList(); return(true); } }
private void gridtable_SelectionChanged(object sender, SelectionChangedEventArgs e) { Rasp pts = gridtable.SelectedItem as Rasp; registrGANEntities connect = new registrGANEntities(); if (pts != null) { mycls.iddoct = connect.Rasp .Include(x => x.Doctors) .Where(w => w.Doctors.LastName == pts.Doctors.LastName && w.Doctors.FirstName == pts.Doctors.FirstName && w.Doctors.Role == pts.Doctors.Role) .Select(s => s.Doctors.iddoctors) .FirstOrDefault(); mycls.idrasp = connect.Rasp.Where(w => w.Doctors.iddoctors == mycls.iddoct && w.weekday == pts.weekday && w.day == pts.day).Select(s => s.idrasp).FirstOrDefault(); mycls.weekdy = pts.weekday; mycls.daywer = pts.day; } }
public update() { InitializeComponent(); registrGANEntities connect = new registrGANEntities(); if (mycls.id == -1 || mycls.id == 0) { } else { var thisupdate = connect.Patients.Where(w => w.idPatiens == mycls.id).FirstOrDefault(); firstname.Text = thisupdate.FirstName; lastname.Text = thisupdate.LastName; Middlename.Text = thisupdate.MiddleName; Phonenumber.Text = thisupdate.Phone; Email.Text = thisupdate.Email; adress.Text = thisupdate.Adress; } }
private void gridtable_SelectionChanged(object sender, SelectionChangedEventArgs e) { Doctors pts = gridtable.SelectedItem as Doctors; registrGANEntities connect = new registrGANEntities(); if (pts != null) { firsname.Text = pts.FirstName; lasname.Text = pts.LastName; weeklist.Text = pts.Role; adress.Text = pts.Adress; email.Text = pts.Email; phone.Text = pts.Phone; ids2 = connect.Doctors.Where(w => w.FirstName == firsname.Text && w.LastName == lasname.Text && w.Role == weeklist.Text).Select(s => s.iddoctors).FirstOrDefault(); } else { return; } }
public bool thisupdate(string dayys, string timmes, int idd, int id) { registrGANEntities connect = new registrGANEntities(); var chec = connect.Registr.Where(w => w.idRegistr == id).ToList(); if (idd == -1 || idd == 0 || !chec.Any() || chec.Count == 0) { return(false); } else { var thisupdate = connect.Registr.Where(w => w.idRegistr == id).FirstOrDefault(); thisupdate.date = dayys; thisupdate.time = timmes; thisupdate.idTypepay = idd; connect.SaveChanges(); this.Close(); return(true); } }
public Window2() { InitializeComponent(); registrGANEntities connect = new registrGANEntities(); if (mycls.idrasp == -1 || mycls.idrasp == 0) { MessageBox.Show(""); } else { var regi = connect.Registr.Where(w => w.idRegistr == mycls.idrasp).FirstOrDefault(); patientsfname.Text = regi.Patients.FirstName; patientslname.Text = regi.Patients.LastName; docfname.Text = regi.Rasp.Doctors.FirstName; doclname.Text = regi.Rasp.Doctors.LastName; docrole.Text = regi.Rasp.Doctors.Role; dayy.Text = regi.date; timee.Text = regi.time; typepayer.Text = regi.Typepay.name; } }
public bool tthisupdate(string fname, string lname, string role, string phon, string emaill, string adresss, int idd) { registrGANEntities connect = new registrGANEntities(); var check = connect.Doctors.Where(w => w.iddoctors == idd).ToList(); if (idd == -1 || idd == 0 || !check.Any() || check.Count == 0) { return(false); } else { var thisupdate = connect.Doctors.Where(w => w.iddoctors == idd).FirstOrDefault(); thisupdate.FirstName = fname; thisupdate.LastName = lname; thisupdate.Role = role; thisupdate.Phone = phon; thisupdate.Email = emaill; thisupdate.Adress = adresss; connect.SaveChanges(); return(true); } }
public bool thisupdate(string fname, string lname, string middlen, string phon, string emaill, string adresss, int idd) { registrGANEntities connect = new registrGANEntities(); var com = connect.Patients.Where(w => w.idPatiens == idd).ToList(); if (idd == -1 || idd == 0 || com.Count == 0 || !com.Any()) { return(false); } else { var thisupdate = connect.Patients.Where(w => w.idPatiens == idd).FirstOrDefault(); thisupdate.FirstName = fname; thisupdate.LastName = lname; thisupdate.MiddleName = middlen; thisupdate.Phone = phon; thisupdate.Email = emaill; thisupdate.Adress = adresss; connect.SaveChanges(); this.Close(); return(true); } }
public bool delete(int idd) { registrGANEntities connector = new registrGANEntities(); if (idd != 0 || idd != -1) { var dlee = connector.Patients.Where(w => w.idPatiens == idd).ToList(); if (dlee.Count != 0 && dlee.Any()) { var dlee1 = connector.Patients.Where(w => w.idPatiens == idd).FirstOrDefault(); connector.Patients.Remove(dlee1); connector.SaveChanges(); return(true); } else { return(false); } } else { return(false); } }
public void bck() { registrGANEntities connect = new registrGANEntities(); gridtable.ItemsSource = connect.Rasp.Include(i => i.Doctors).Include(ii => ii.Doctors.cabin).ToList(); }
public void load() { registrGANEntities con = new registrGANEntities(); gridtable.ItemsSource = con.Doctors.ToList(); }
public void table() { registrGANEntities connect = new registrGANEntities(); gridtable.ItemsSource = connect.Patients.ToList(); }