示例#1
0
        public void VisitsSave(string date, string time, string pressure, string pulse, string temperature, string symptoms, string diagnosis, string recommedations, string medicines, string information, int pID, int dID)
        {
            using (Kartoteka_Entities1 context = new Kartoteka_Entities1())
            {
                var newPatient = context.Patients.FirstOrDefault(x => x.patientID == pID);
                var newDoctor  = context.Doctors.FirstOrDefault(x => x.doctorID == dID);

                Visits visit = new Visits
                {
                    patientID                  = newPatient.patientID,
                    doctorID                   = newDoctor.doctorID,
                    date                       = date,
                    time                       = time,
                    pressure                   = pressure,
                    pulse                      = Convert.ToInt16(pulse),
                    temperature                = Convert.ToDecimal(temperature),
                    symptoms                   = symptoms,
                    diagnosis                  = diagnosis,
                    recommendations            = recommedations,
                    visitMedicines             = medicines,
                    additionalVisitInformation = information,
                    mark                       = 1
                };
                context.Visits.Add(visit);
                context.SaveChanges();
            }
        }
示例#2
0
        private void bntSubmit_Click(object sender, RoutedEventArgs e)
        {
            var Login    = txtName.Text;
            var Password = txtPassword.Password;

            if (Login.Length != 0)
            {
                if (Password.Length != 0)
                {
                    using (Kartoteka_Entities1 context = new Kartoteka_Entities1())
                    {
                        var user = context.Nurse.FirstOrDefault(w => w.login == Login);
                        if (user != null)
                        {
                            var hasło = context.Nurse.FirstOrDefault(w => w.password == Password);
                            if (hasło != null)
                            {
                                MainWindow main = new MainWindow();
                                main.Show();
                                this.Close();
                            }
                            else
                            {
                                MessageBox.Show("Login lub hasło nierawidłowe!");
                            }
                        }
                        else
                        {
                            MessageBox.Show("Login lub hasło nierawidłowe!");
                        }
                    }
                }
                else
                {
                    MessageBox.Show("Brak hasła!");
                }
            }
            else

            {
                MessageBox.Show("Brak loginu!");
            }
        }
示例#3
0
        public void WorkIntervievSave(string profession, string practiced, string disease, string niuisance, string accidents, int ID)
        {
            using (Kartoteka_Entities1 context = new Kartoteka_Entities1())
            {
                var newPatient = context.Patients.FirstOrDefault(x => x.patientID == ID);

                WorkInterview work = new WorkInterview
                {
                    patientID           = newPatient.patientID,
                    profession          = profession,
                    practisedProfession = practiced,
                    ocupationalDisease  = disease,
                    nuisance            = niuisance,
                    accidents           = accidents
                };

                context.WorkInterview.Add(work);
                context.SaveChanges();
            }
        }
示例#4
0
        public void patientsSave(string name, string surname, string pesel, string sex, string birth, string adress, string city, int id)
        {
            using (Kartoteka_Entities1 context = new Kartoteka_Entities1())
            {
                var newDoctor = context.Doctors.FirstOrDefault(x => x.doctorID == id);

                Patients patient = new Patients
                {
                    name        = name,
                    surname     = surname,
                    pesel       = pesel,
                    sex         = sex,
                    dateOfBirth = birth,
                    adress      = adress,
                    Doctors     = newDoctor,
                    city        = city
                };
                context.Patients.Add(patient);
                context.SaveChanges();
                var idn = context.Patients.Where(x => x.pesel == pesel).FirstOrDefault();
                MessageBox.Show("Id pacjenta: " + idn.patientID.ToString());
            }
        }
示例#5
0
 public void anamnesisSave(string weight, string height, string treatment, string information, string diseases, string alergy, string medicine, string group, string rh, string alcohol, string cigarets, int id)
 {
     using (Kartoteka_Entities1 context = new Kartoteka_Entities1())
     {
         var       newPatient = context.Patients.FirstOrDefault(x => x.patientID == id);
         Anamnesis first      = new Anamnesis
         {
             patientID             = newPatient.patientID,
             weight                = Convert.ToDecimal(weight),
             height                = Convert.ToInt32(height),
             treatment             = treatment,
             additionalInformation = information,
             chronicDiseases       = diseases,
             allergy               = alergy,
             medicines             = medicine,
             bloodType             = group,
             rh        = rh,
             alcohol   = alcohol,
             cigaretts = cigarets
         };
         context.Anamnesis.Add(first);
         context.SaveChanges();
     }
 }