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