private void saveTicket_Click(object sender, EventArgs e)
        {
            try
            {
                using (var context = new Cabinet_MedicalEntities())
                {
                    var af = (from afect in context.Diseases
                              where afect.Denumire.Equals(diseaseBox.SelectedItem.ToString().Trim())
                              select afect.ID).ToList().First();
                    History_Patients hist = new History_Patients
                    {
                        ID_Afectiune = af,
                        ID_Pacient   = pacient.ID,
                        ID_Medic     = medic.ID,
                        Data         = DateTime.Now
                    };
                    context.History_Patients.Add(hist);
                    context.SaveChanges();

                    Internment_Tickets bilet = new Internment_Tickets
                    {
                        ID_Istoric = hist.ID,
                        Descriere  = diseaseBox.Text.ToString().Trim()
                    };
                    context.Internment_Tickets.Add(bilet);
                    context.SaveChanges();
                    MessageBox.Show("Biletul de trimitere a fost inregistrat!", "Succes!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Eroare!", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 2
0
        private void CSVExport(string filename)
        {
            var csv = new StringBuilder();

            using (var context = new Cabinet_MedicalEntities())
            {
                var query = from emp in context.Patients
                            select new
                {
                    emp.Nume,
                    emp.CNP,
                    emp.Serie_Buletin,
                    emp.Numar_Buletin,
                    emp.Data_Nasterii
                };


                foreach (var row in query)
                {
                    var newline = string.Format("{0},{1},{2},{3},{4}", row.Nume.ToString().Trim(),
                                                row.CNP.ToString().Trim(), row.Serie_Buletin.ToString().Trim(), row.Numar_Buletin.ToString().Trim(),
                                                row.Data_Nasterii.ToString().Trim());
                    csv.AppendLine(newline);
                }
                File.WriteAllText(filename, csv.ToString());
            }
        }
Ejemplo n.º 3
0
        private void View_Button_Click(object sender, EventArgs e)
        {
            try
            {
                using (var context = new Cabinet_MedicalEntities())
                {
                    string cell   = PacientsData.SelectedRows[0].Cells[0].Value.ToString();
                    var    query2 = (from pat in context.Patients
                                     where pat.Nume.Equals(cell)
                                     select pat).First();



                    if (PacientsData.SelectedRows.Count == 0)
                    {
                        throw new Exception("Selectati un pacient!");
                    }


                    else
                    {
                        this.Hide();

                        View_Form view = new View_Form(query2, this, Abouts);
                        view.Show();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 4
0
        private void ExcelExport(string filename)
        {
            try
            {
                Excel.Application xlApp;
                Excel.Workbook    xlWorkBook;
                Excel.Worksheet   xlWorkSheet;
                object            misValue = System.Reflection.Missing.Value;

                xlApp = new Microsoft.Office.Interop.Excel.Application();

                if (xlApp == null)
                {
                    throw new Exception("Eroare exportare foaie de calcul!");
                }

                xlWorkBook  = xlApp.Workbooks.Add(misValue);
                xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
                using (var context = new Cabinet_MedicalEntities())
                {
                    var query = from emp in context.Patients
                                select new
                    {
                        emp.Nume,
                        emp.CNP,
                        emp.Serie_Buletin,
                        emp.Numar_Buletin,
                        emp.Data_Nasterii
                    };

                    int i = 1;
                    foreach (var row in query)
                    {
                        xlWorkSheet.Cells[i, 1] = row.Nume.ToString().Trim();
                        xlWorkSheet.Cells[i, 2] = row.CNP.ToString().Trim();
                        xlWorkSheet.Cells[i, 3] = row.Serie_Buletin.ToString().Trim();
                        xlWorkSheet.Cells[i, 4] = row.Numar_Buletin.ToString().Trim();
                        xlWorkSheet.Cells[i, 5] = row.Data_Nasterii.ToString().Trim();
                        i++;
                    }
                }
                xlWorkBook.SaveAs(filename);
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 5
0
        private void Appointments_Form_Load(object sender, EventArgs e)
        {
            try
            {
                Name_Label.Text  = Abouts.Nume.ToString().Trim();
                Specs_Label.Text = Abouts.Specializare.ToString().Trim();


                using (var context = new Cabinet_MedicalEntities())
                {
                    var query = from app in context.Appointments
                                join pat in context.Patients
                                on app.ID_Pacient equals pat.ID
                                where app.ID_Medic.Equals(Abouts.ID)
                                select new
                    {
                        pat.Nume,
                        app.Date,
                        app.Accepted
                    };
                    if (query.Count() != 0)
                    {
                        foreach (var line in query)
                        {
                            if (line.Accepted == 1)
                            {
                                PatientsData.Rows.Add(line.Nume.ToString().Trim(), line.Date.ToString().Trim(), "In Asteptare");
                            }
                            else if (line.Accepted == 2)
                            {
                                PatientsData.Rows.Add(line.Nume.ToString().Trim(), line.Date.ToString().Trim(), "Consultat");
                            }
                            else if (line.Accepted == 3)
                            {
                                PatientsData.Rows.Add(line.Nume.ToString().Trim(), line.Date.ToString().Trim(), "Refuzat");
                            }
                        }
                    }
                    else
                    {
                        throw new Exception("Nu sunt programari in asteptare!");
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 6
0
 private void Accept_Button_Click(object sender, EventArgs e)
 {
     try
     {
         if (PatientsData.SelectedRows.Count == 0)
         {
             throw new Exception("Selectati o programare!");
         }
         if (PatientsData.SelectedCells[2].Value.ToString().Equals("Consultat"))
         {
             throw new Exception("Pacientul a fost deja consultat!");
         }
         if (PatientsData.SelectedCells[2].Value.ToString().Equals("Refuzat"))
         {
             throw new Exception("Pacientul a fost deja refuzat!");
         }
         Patient P;
         using (var context = new Cabinet_MedicalEntities())
         {
             string name  = PatientsData.SelectedCells[0].Value.ToString();
             var    query = (from app in context.Appointments
                             join pat in context.Patients
                             on app.ID_Pacient equals pat.ID
                             where pat.Nume.Equals(name)
                             select new
             {
                 app.Accepted,
                 pat.ID
             }).First();
             PatientsData.SelectedCells[2].Value = "Consultat";
             // var query2 = (from app in context.Appointments
             //              where app.ID_Pacient == query.ID
             //              select app).First();
             var query3 = (from pat in context.Patients
                           where pat.Nume.Equals(name)
                           select pat).First();
             context.SetData(name, 2);
             context.SaveChanges();
             P = query3;
         }
         Form p = new View_Form(P, this, Abouts);
         p.Show();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "Message",
                         MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
Ejemplo n.º 7
0
        private void Add_Pill_Click(object sender, EventArgs e)
        {
            try
            {
                if (Name_Box.Text.Length == 0)
                {
                    throw new Exception("Introduceti numele medicamentului!");
                }
                if (DatePick.Text.Length == 0)
                {
                    throw new Exception("Alegeti data expirarii!");
                }
                if (Username_Box.Text.Length == 0)
                {
                    throw new Exception("Introduceti numarul de produse!");
                }

                Drug med = new Drug();
                med.Denumire       = Name_Box.Text.Trim();
                med.Stoc           = Int32.Parse(Username_Box.Text.Trim());
                med.Data_Expirarii = DatePick.Value;

                using (var context = new Cabinet_MedicalEntities())
                {
                    var query = (from pill in context.Drugs
                                 where pill.Denumire.Equals(med.Denumire)
                                 select pill).First();
                    if (query != null)
                    {
                        query.Stoc += med.Stoc;
                        context.SaveChanges();
                        MessageBox.Show("Stocul de " + med.Denumire + " a fost actualizat!", "Message",
                                        MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        context.Drugs.Add(med);
                        context.SaveChanges();
                        MessageBox.Show("Adaugarea s-a efectuat cu succes!", "Message",
                                        MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 8
0
        private void saveAppointment_Click(object sender, EventArgs e)
        {
            try
            {
                if (Doctors.SelectedItem == null)
                {
                    throw new Exception("Selectati un medic!");
                }
                else if (dateTime.Checked == false)
                {
                    throw new Exception("Selectati o data!");
                }
                else
                {
                    using (var context = new Cabinet_MedicalEntities())
                    {
                        var medic = (from med in context.Employees
                                     where med.Nume.Equals(Doctors.SelectedItem.ToString())
                                     select med).First();

                        var newapp = new Appointment()
                        {
                            ID_Medic   = medic.ID,
                            ID_Pacient = Abouts.ID,
                            Date       = dateTime.Value,
                            Accepted   = 1
                        };
                        if (checkAppointment(newapp.ID_Medic, newapp.ID_Pacient, newapp.Date) == true)
                        {
                            throw new Exception("Ati mai facut o programare identica!\n");
                        }
                        else
                        {
                            context.Appointments.Add(newapp);
                            context.SaveChanges();
                        }
                    }
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show(exc.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            Doctors.Text            = "";
            Doctors.Enabled         = false;
            dateTime.Enabled        = false;
            saveAppointment.Enabled = false;
            Doctors.Items.Clear();
        }
 void FillCombo()
 {
     using (var context = new Cabinet_MedicalEntities())
     {
         var query = from emp in context.Diseases
                     select emp.Denumire;
         if (query.Count() != 0)
         {
             foreach (var dis in query)
             {
                 diseaseBox.Items.Add(dis.ToString().Trim());
             }
         }
     }
 }
Ejemplo n.º 10
0
 private void Add_Med_Click(object sender, EventArgs e)
 {
     try
     {
         if (Name_Box.Text.Length == 0)
         {
             throw new Exception("Introduceti numele!");
         }
         if (Spec_Box.Text.Length == 0)
         {
             throw new Exception("Introduceti specializarea!");
         }
         if (Username_Box.Text.Length == 0)
         {
             throw new Exception("Introduceti username-ul!");
         }
         if (Parola_Box.Text.Length == 0)
         {
             throw new Exception("Introduceti parola!");
         }
         Employee E = new Employee();
         E.Nume         = Name_Box.Text.Trim();
         E.Specializare = Spec_Box.Text.Trim();
         E.Username     = Username_Box.Text.Trim();
         E.Parola       = getMD5(Parola_Box.Text.Trim());
         //  E.Parola = Parola_Box.Text.Trim();
         using (var context = new Cabinet_MedicalEntities())
         {
             var query = from emp in context.Employees
                         where emp.Nume.Equals(E.Nume) ||
                         emp.Username.Equals(E.Username)
                         select emp;
             if (query.Count() != 0)
             {
                 throw new Exception("Medicul sau Username-ul exista deja in baza de date!");
             }
             context.Employees.Add(E);
             context.SaveChanges();
             MessageBox.Show("Adaugarea s-a efectuat cu succes!", "Message",
                             MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "Message",
                         MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
Ejemplo n.º 11
0
 void FillCombo()
 {
     using (var context = new Cabinet_MedicalEntities())
     {
         var query = from emp in context.Employees
                     where emp.Specializare != "Asistent" && emp.Nume != "admin"
                     select
                     emp.Nume;
         if (query.Count() != 0)
         {
             foreach (var doc in query)
             {
                 Doctors.Items.Add(doc.ToString());
             }
         }
     }
 }
Ejemplo n.º 12
0
        bool userExists(string user)
        {
            var context = new Cabinet_MedicalEntities();
            var query   = from username in context.Patients
                          select new
            {
                username.Username
            };

            foreach (var usr in query)
            {
                if (usr.Username.ToString().Trim().Equals(user))
                {
                    return(true);
                }
            }
            return(false);
        }
Ejemplo n.º 13
0
        private void Medic_Form_Load(object sender, EventArgs e)
        {
            this.Text        = Abouts.Nume.ToString().Trim() + " Window";
            Name_Label.Text  = Abouts.Nume.ToString().Trim();
            Specs_Label.Text = Abouts.Specializare.ToString().Trim();
            using (var context = new Cabinet_MedicalEntities())
            {
                var query = from emp in context.Patients
                            select new
                {
                    emp.Nume,
                    emp.CNP,
                    emp.Serie_Buletin,
                    emp.Numar_Buletin,
                    emp.Data_Nasterii
                };


                foreach (var row in query)
                {
                    PacientsData.Rows.Add(row.Nume.ToString().Trim(), row.CNP.ToString().Trim(),
                                          row.Serie_Buletin.ToString().Trim(), row.Numar_Buletin.ToString().Trim(),
                                          row.Data_Nasterii.ToString().Trim());
                }
            }
            using (var context = new Cabinet_MedicalEntities())
            {
                var query = from app in context.Appointments
                            where app.ID_Medic.Equals(Abouts.ID) && app.Accepted == 1
                            select app;
                Request_Label.Text = query.Count().ToString().Trim() + " Appointments";
                if (query.Count() != 0)
                {
                    Request_Label.BackColor = Color.Red;
                }
            }

            if (Equals(Abouts.Specializare.ToString().Trim(), "Asistent") == true)
            {
                Add_Button.Enabled    = false;
                Delete_Button.Enabled = false;
            }
        }
Ejemplo n.º 14
0
 private void historyButton_Click(object sender, EventArgs e)
 {
     try
     {
         History.Enabled         = true;
         Doctors.Enabled         = false;
         saveAppointment.Enabled = false;
         dateTime.Enabled        = false;
         using (var cont = new Cabinet_MedicalEntities())
         {
             var quer = from hist in cont.HistViews
                        where hist.ID.Equals(Abouts.ID)
                        select new
             {
                 hist.Denumire,
                 hist.Nume,
                 hist.Specializare,
                 hist.Data
             };
             DataTable tabel = new DataTable();
             tabel.Columns.Add("Afectiune", typeof(string));
             tabel.Columns.Add("Medic", typeof(string));
             tabel.Columns.Add("Specializare", typeof(string));
             tabel.Columns.Add("Data examinare", typeof(DateTime));
             foreach (var item in quer)
             {
                 DataRow Row = null;
                 Row = tabel.NewRow();
                 Row["Afectiune"]      = item.Denumire.ToString().Trim();
                 Row["Medic"]          = item.Nume.ToString().Trim();
                 Row["Specializare"]   = item.Specializare.ToString().Trim();
                 Row["Data examinare"] = item.Data;
                 tabel.Rows.Add(Row);
             }
             History.DataSource = tabel;
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "Eroare!", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
Ejemplo n.º 15
0
        private void PdfExport(string filename)
        {
            var Text       = new StringBuilder();
            var pdfDoc     = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
            var htmlparser = new HTMLWorker(pdfDoc);

            using (var context = new Cabinet_MedicalEntities())
            {
                var query = from emp in context.Patients
                            select new
                {
                    emp.Nume,
                    emp.CNP,
                    emp.Serie_Buletin,
                    emp.Numar_Buletin,
                    emp.Data_Nasterii
                };


                foreach (var row in query)
                {
                    var newline = string.Format("{0},{1},{2},{3},{4},\r\n", row.Nume.ToString().Trim(),
                                                row.CNP.ToString().Trim(), row.Serie_Buletin.ToString().Trim(), row.Numar_Buletin.ToString().Trim(),
                                                row.Data_Nasterii.ToString().Trim());
                    Text.AppendLine(newline);
                }
            }
            using (var memory = new MemoryStream())
            {
                var writer = PdfWriter.GetInstance(pdfDoc, memory);
                pdfDoc.Open();

                htmlparser.Parse(new StringReader(Text.ToString()));
                pdfDoc.Close();

                byte[] bytes = memory.ToArray();
                File.WriteAllBytes(filename, bytes);

                memory.Close();
            }
        }
Ejemplo n.º 16
0
        bool checkAppointment(int medic, int pacient, DateTime date)
        {
            var context = new Cabinet_MedicalEntities();
            var app     = from cab in context.Appointments
                          where cab.ID_Pacient.Equals(pacient) && cab.ID_Medic.Equals(medic) && cab.Date.Equals(date)
                          select new
            {
                cab.ID_Medic,
                cab.ID_Pacient,
                cab.Date
            };

            if (app.Count() != 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 17
0
        private void Login_Button_Click(object sender, EventArgs e)
        {
            try
            {
                if (Password_Box.Text.Length == 0)
                {
                    throw new Exception("Introduceti parola!");
                }
                string username = "******";
                string password = getMD5(Password_Box.Text.Trim());

                using (var context = new Cabinet_MedicalEntities())
                {
                    var query = from app in context.Employees
                                where app.Username.Equals(username) && app.Parola.Equals(password)
                                select app;
                    if (query.Count() == 0)
                    {
                        throw new Exception("Parola este incorecta!");
                    }

                    User_Label.Visible     = false;
                    Password_Label.Visible = false;
                    admin_label.Visible    = false;
                    Password_Box.Visible   = false;
                    Login_Button.Visible   = false;
                    Cancel_Button.Visible  = false;
                    DatePick.Visible       = false;
                    Exit.Visible           = true;
                    AddMed.Visible         = true;
                    AddPill.Visible        = true;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 18
0
        bool checkExists(string nume, string cnp, string Serie, string numar)
        {
            var context = new Cabinet_MedicalEntities();
            var query   = from pat in context.Patients
                          select new
            {
                pat.Nume,
                pat.CNP,
                pat.Serie_Buletin,
                pat.Numar_Buletin,
                //pat.Data_Nasterii
            };

            foreach (var patient in query)
            {
                if (nume.Equals(patient.Nume.Trim()) && cnp.Equals(patient.CNP.Trim()) && Serie.Equals(patient.Serie_Buletin.Trim()) && numar.Equals(patient.Numar_Buletin.Trim()) /*&& p.Data_Nasterii.Equals(patient.Data_Nasterii)*/)
                {
                    return(true);
                }
            }
            return(false);
        }
Ejemplo n.º 19
0
 public Vew_Stoc_Form(Form parentForm)
 {
     InitializeComponent();
     f = parentForm;
     using (var context = new Cabinet_MedicalEntities())
     {
         var query = from i in context.Drugs_Diseases
                     join m in context.Diseases on i.ID_Afectiune equals m.ID
                     join p in context.Drugs on i.ID_Medicament equals p.ID
                     select new {
             m.Denumire,
             den = p.Denumire,
             p.Data_Expirarii,
             p.Stoc
         };
         foreach (var j in query)
         {
             if (DateTime.Compare(DateTime.Now, j.Data_Expirarii) < 0)
             {
                 StocView.Rows.Add(j.Denumire.ToString().Trim(), j.den.ToString().Trim(), j.Data_Expirarii.ToString().Trim(), j.Stoc.ToString().Trim());
             }
         }
     }
 }
Ejemplo n.º 20
0
        private void Delete_Button_Click(object sender, EventArgs e)
        {
            try
            {
                if (PacientsData.SelectedRows.Count == 0)
                {
                    throw new Exception("Selectati un pacient!");
                }

                string name = PacientsData.SelectedCells[0].Value.ToString();

                using (var context = new Cabinet_MedicalEntities())
                {
                    context.DeletePatient(name);
                    context.SaveChanges();
                    PacientsData.Rows.Remove(PacientsData.SelectedRows[0]);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 21
0
        private void buttonAfisare_Click(object sender, EventArgs e)
        {
            try
            {
                button1.Hide();
                string tipConsutatie = comboBoxTipC.SelectedItem.ToString();
                if (comboBoxTipC.SelectedItem != null)
                {
                    using (var context = new Cabinet_MedicalEntities())
                    {
                        RetetaData.Show();
                        ViewData.Hide();
                        BiletData.Hide();
                        var q = from i in context.History_Patients
                                where i.ID_Pacient.Equals(Pacient.ID)
                                select i;


                        if (Equals(tipConsutatie, "Reteta"))
                        {
                            foreach (var reteta in q)
                            {
                                var query = (from r in context.Recipes
                                             where r.ID_Istoric.Equals(reteta.ID)
                                             select new
                                {
                                    r.ID_Medicament,
                                    r.Numar_Flacoane
                                }).FirstOrDefault();
                                if (query != null)
                                {
                                    var afect = (from a in context.Diseases
                                                 where a.ID.Equals(reteta.ID_Afectiune)
                                                 select a).FirstOrDefault();
                                    var med = (from m in context.Employees
                                               where m.ID.Equals(reteta.ID_Medic)
                                               select m).FirstOrDefault();
                                    var medicament = (from d in context.Drugs
                                                      where d.ID.Equals(query.ID_Medicament)
                                                      select d).FirstOrDefault();
                                    RetetaData.Rows.Add(reteta.Data.ToString().Trim(), med.Nume.ToString().Trim(), afect.Denumire.ToString().Trim(), medicament.Denumire.ToString().Trim(), query.Numar_Flacoane.ToString().Trim());
                                }
                            }
                        }
                        else if (Equals(tipConsutatie, "Bilet internare"))
                        {
                            RetetaData.Hide();
                            ViewData.Hide();
                            BiletData.Show();
                            foreach (var bilet in q)
                            {
                                var query = (from b in context.Internment_Tickets
                                             where b.ID_Istoric.Equals(bilet.ID)
                                             select new
                                {
                                    b.Descriere,
                                    b.Numar_Bilet,
                                }).FirstOrDefault();
                                if (query != null)
                                {
                                    var afect = (from af in context.Diseases
                                                 where af.ID.Equals(bilet.ID_Afectiune)
                                                 select af).FirstOrDefault();
                                    var med = (from mm in context.Employees
                                               where mm.ID.Equals(bilet.ID_Medic)
                                               select mm).FirstOrDefault();
                                    BiletData.Rows.Add(bilet.Data.ToString().Trim(), med.Nume.ToString().Trim(), afect.Denumire.ToString().Trim(), query.Descriere.ToString().Trim(), query.Numar_Bilet.ToString().Trim());
                                }
                            }
                        }
                        else if (Equals(tipConsutatie, "Scutire"))
                        {
                            ViewData.Show();
                            RetetaData.Hide();
                            BiletData.Hide();
                            foreach (var scutire in q)
                            {
                                var query = (from s in context.Exemptions
                                             where s.ID_Istoric.Equals(scutire.ID)
                                             select new
                                {
                                    s.Zile_Repaus,
                                    s.Tip
                                }).FirstOrDefault();
                                if (query != null)
                                {
                                    var afect = (from aa in context.Diseases
                                                 where aa.ID.Equals(scutire.ID_Afectiune)
                                                 select aa).FirstOrDefault();
                                    var med = (from n in context.Employees
                                               where n.ID.Equals(scutire.ID_Medic)
                                               select n).FirstOrDefault();

                                    ViewData.Rows.Add(scutire.Data.ToString().Trim(), med.Nume.ToString().Trim(), afect.Denumire.ToString().Trim(), query.Tip.ToString().Trim(), query.Zile_Repaus.ToString().Trim());
                                }
                            }
                        }
                    }
                }
                else
                {
                    throw new Exception("Selectati un camp!");
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 22
0
        private void buttonSave_Click(object sender, EventArgs e)
        {
            using (var context = new Cabinet_MedicalEntities())
            {
                try
                {
                    if (textBoxAf.Text.Length == 0)
                    {
                        throw new Exception("Nu ati introdus denumirea afectiunii!");
                    }
                    else if (textBoxMed.Text.Length == 0)
                    {
                        throw new Exception("Nu ati introdus denumirea medicamentului!");
                    }
                    else if (textBoxNrF.Text.Length == 0)
                    {
                        throw new Exception("Nu ati introdus numarul de flacoane!");
                    }

                    else
                    {
                        var res = (from p in context.Drugs
                                   where p.Denumire.Equals(textBoxMed.Text)
                                   select p).FirstOrDefault();
                        int numar = Int32.Parse(textBoxNrF.Text);



                        var query2 = (from a in context.Diseases

                                      where a.Denumire.Equals(textBoxAf.Text)
                                      select a).FirstOrDefault();



                        if (query2 == null)
                        {
                            throw new Exception("Denumirea afectiunii este incorecta!");
                        }
                        string den = res.Denumire;

                        if (res.Stoc > numar)
                        {
                            var addnew = new History_Patients
                            {
                                ID_Medic = m.ID,

                                Data         = DateTime.Now,
                                ID_Pacient   = Pacient.ID,
                                ID_Afectiune = query2.ID
                            };
                            context.History_Patients.Add(addnew);
                            context.SaveChanges();

                            var addret = new Recipe
                            {
                                ID_Istoric     = addnew.ID,
                                ID_Medicament  = res.ID,
                                Numar_Flacoane = numar
                            };


                            context.Recipes.Add(addret);
                            context.SaveChanges();

                            using (var dbContextTransaction = context.Database.BeginTransaction())
                            {
                                try
                                {
                                    var pp = from dr in context.Drugs
                                             where dr.Denumire.Equals(den)
                                             select dr;
                                    foreach (var pastile in pp)
                                    {
                                        pastile.Stoc = pastile.Stoc - numar;
                                    }
                                    context.SaveChanges();
                                    dbContextTransaction.Commit();
                                }
                                catch (Exception)
                                {
                                    dbContextTransaction.Rollback();
                                }
                            }
                            MessageBox.Show("Reteta a fost inregistrata cu succes!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            textBoxAf.Text  = "";
                            textBoxMed.Text = "";
                            textBoxNrF.Text = "";
                        }
                        else
                        {
                            MessageBox.Show("Stoc insuficient!");
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Message",
                                    MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Ejemplo n.º 23
0
        private void Login_Button_Click(object sender, EventArgs e)
        {
            try
            {
                if (Username_Box.Text.Length == 0)
                {
                    throw new Exception("Nu ati introdus numele utilizatorului!");
                }
                else if (Password_Box.Text.Length == 0)
                {
                    throw new Exception("Nu ati introdus parola utilizatorului!");
                }
                else if (Login_Type.SelectedItem == null)
                {
                    throw new Exception("Nu ati selectat tipul de utilizator!");
                }
                else
                {
                    string Username = Username_Box.Text.ToString();
                    string Password = getMD5(Password_Box.Text.ToString());
                    string Type     = Login_Type.SelectedItem.ToString();
                    using (var context = new Cabinet_MedicalEntities())
                    {
                        if (Equals(Type, "Pacient"))
                        {
                            var employee = (from emp in context.Patients
                                            where emp.Username.Equals(Username) &&
                                            emp.Parola.Equals(Password)
                                            select emp).ToList();
                            if (employee.Count == 0)
                            {
                                throw new Exception("Utilizatorul nu exista!");
                            }
                            else if (employee.Count == 1)
                            {
                                MessageBox.Show("Logarea s-a efectuat cu succes!",
                                                "Message", MessageBoxButtons.OK,
                                                MessageBoxIcon.Information);
                                Hide();
                                new Patient_Form(employee[0], this);
                                Username_Box.Text = "";
                                Password_Box.Text = "";
                                // Show();
                            }
                        }

                        else if (Equals(Type, "Medic/Asistent"))
                        {
                            var employee = (from emp in context.Employees
                                            where emp.Username.Equals(Username) &&
                                            emp.Parola.Equals(Password)
                                            select emp).ToList();
                            if (employee.Count == 0)
                            {
                                throw new Exception("Utilizatorul nu exista!");
                            }
                            else if (employee.Count == 1)
                            {
                                MessageBox.Show("Logarea s-a efectuat cu succes!",
                                                "Message", MessageBoxButtons.OK,
                                                MessageBoxIcon.Information);
                                Hide();
                                new Medic_Form(employee[0], this);
                                // Show();
                                Username_Box.Text = "";
                                Password_Box.Text = "";
                            }
                        }
                    }
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 24
0
        private void buttonSave_Click(object sender, EventArgs e)
        {
            try
            {
                using (var context = new Cabinet_MedicalEntities())
                {
                    string medic     = textBoxMedic.Text;
                    string afectiune = textBoxAfectiune.Text;
                    int    zile      = Int32.Parse(textBoxZile.Text);
                    if (textBoxMedic.Text.Length == 0)
                    {
                        throw new Exception("Nu ati introdus numele medicului/asistentului!");
                    }
                    else if (textBoxAfectiune.Text.Length == 0)
                    {
                        throw new Exception("Nu ati introdus denumirea afectiunii!");
                    }
                    else if (textBoxZile.Text.Length == 0)
                    {
                        throw new Exception("Nu ati introdus numarul de zile!");
                    }
                    else if (textBoxTipScutire.Text.Length == 0)
                    {
                        throw new Exception("Nu ati introdus tipul scutirii!");
                    }
                    else
                    {
                        var query = (from m in context.Employees
                                     where m.Nume.Equals(medic)
                                     select m).FirstOrDefault();

                        var query2 = (from a in context.Diseases

                                      where a.Denumire.Equals(afectiune)
                                      select a).FirstOrDefault();
                        if (query2 == null)
                        {
                            throw new Exception("Denumirea afectiunii este incorecta!");
                        }
                        else if (query == null)
                        {
                            throw new Exception("Numele medicului introdus esti incorect!");
                        }

                        else
                        {
                            var addnew = new History_Patients
                            {
                                ID_Medic = query.ID,

                                Data         = DateTime.Now,
                                ID_Pacient   = Pacient.ID,
                                ID_Afectiune = query2.ID
                            };
                            context.History_Patients.Add(addnew);
                            context.SaveChanges();

                            var addsc = new Exemption
                            {
                                ID_Istoric  = addnew.ID,
                                Zile_Repaus = zile,
                                Tip         = textBoxTipScutire.Text
                            };



                            context.Exemptions.Add(addsc);
                            context.SaveChanges();

                            MessageBox.Show("Scutirea a fost inregistrata cu succes!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            textBoxAfectiune.Text  = "";
                            textBoxMedic.Text      = "";
                            textBoxTipScutire.Text = "";
                            textBoxZile.Text       = "";
                        }
                    }
                }
            }


            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 25
0
        private void addButton_Click(object sender, EventArgs e)
        {
            try
            {
                if (nameBox.Text == "")
                {
                    throw new Exception("Campul nume nu a fost commpletat!");
                }
                else if (cnpBox.Text == "")
                {
                    throw new Exception("Campul CNP nu a fost completat!");
                }
                else if (serieBox.Text == "")
                {
                    throw new Exception("Campul Serie_buletin nu a fost completat!");
                }
                else if (numberBox.Text == "")
                {
                    throw new Exception("Campul Numar_buletin nu a fost completat!");
                }
                else if (data_nasterePick.Value == null)
                {
                    throw new Exception("Nu ati ales Data nasterii!");
                }
                else if (userBox.Text == "")
                {
                    throw new Exception("Nu ati ales un username!");
                }
                else if (passwordBox.Text == "")
                {
                    throw new Exception("Nu ati introdus o parola!");
                }
                else if (passwordBox.Text != confirmBox.Text)
                {
                    throw new Exception("Parola nu se potriveste!");
                }

                else
                {
                    if (cnpBox.Text.Length < 13)
                    {
                        throw new Exception("CNP-ul trebuie sa contina 13 cifre!");
                    }
                    if (serieBox.Text.Length < 2)
                    {
                        throw new Exception("Seria buletinului este formata din 2 litere!");
                    }
                    if (numberBox.Text.Length < 6)
                    {
                        throw new Exception("Numarul butletinului este format din 6 cifre!");
                    }
                    if (check_Pass(passwordBox.Text.ToString()) == false)
                    {
                        throw new Exception("Parola trebuie sa contina cel putin 6 caractere!");
                    }
                    if (numberOnly(cnpBox.Text.ToString()) == false)
                    {
                        throw new Exception("Campul CNP trebuie sa contina doar cifre!");
                    }
                    if (numberOnly(numberBox.Text.ToString()) == false)
                    {
                        throw new Exception("Campul Numar_buletin trebuie sa contina doar cifre!");
                    }
                    if (letterOnly(serieBox.Text.ToString()) == false)
                    {
                        throw new Exception("Campul Serie_buletin trebuie sa contina doar lietere!");
                    }

                    else
                    {
                        var p = new Patient {
                            Nume          = nameBox.Text.ToString(),
                            CNP           = cnpBox.Text.ToString(),
                            Serie_Buletin = serieBox.Text.ToString(),
                            Numar_Buletin = numberBox.Text.ToString(),
                            Data_Nasterii = data_nasterePick.Value,
                            Username      = userBox.Text.ToString(),
                            Parola        = getMD5(passwordBox.Text.ToString())
                        };
                        if (checkExists(nameBox.Text, cnpBox.Text, serieBox.Text, numberBox.Text) == true)
                        {
                            throw new Exception("Pacientul este deja inregistrat!");
                        }
                        else if (userExists(userBox.Text) == true)
                        {
                            throw new Exception("Username-ul este deja inregistrat!\nIncercati alt username!");
                        }
                        else
                        {
                            using (var context = new Cabinet_MedicalEntities())
                            {
                                context.Patients.Add(p);
                                context.SaveChanges();
                                MessageBox.Show("Pacientul a fost inregistrat cu succes!", "Succes!", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Reintroduceti datele", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }