示例#1
0
        public double getbalance()
        {
            linkDataContext datacon = new linkDataContext();
            var             o       = from d in datacon.FincialRecords where d.P_id == pa.p_id select d.Balance;

            return(Convert.ToDouble(o.First()));
        }
示例#2
0
        public String getexaminationdata()
        {
            linkDataContext datacon = new linkDataContext();
            var             r       = from g in datacon.App_datas select g.Examination_data;

            datacon.SubmitChanges();
            return(r.Last());
        }
示例#3
0
        private void button2_Click(object sender, EventArgs e)
        {
            String          r       = resultdatatext.Text.Trim();
            linkDataContext datacon = new linkDataContext();
            var             rr      = from g in datacon.App_datas select g;

            datacon.App_datas.DeleteOnSubmit(rr.Last());
            rr.Last().Result_data = r;
            datacon.App_datas.InsertOnSubmit(rr.Last());
            datacon.SubmitChanges();
        }
示例#4
0
        private void button1_Click(object sender, EventArgs e)
        {
            String emp_name = Emp_nametextbox.Text.Trim();
            String emp_pass = Emp_passtextbox.Text.Trim();

            if (emp_name.Length <= 0 || emp_pass.Length <= 0)
            {
                MessageBox.Show("The Name Or The Password is Messing Make Sure You Enter It", "Warrning", MessageBoxButtons.OK, MessageBoxIcon.Information);

                return;
            }
            linkDataContext link = new linkDataContext();

            var s = from d in link.Employees where d.Emp_FirstName.Trim() + " " + d.Emp_LastName.Trim() == emp_name && d.Password == emp_pass select d;

            //  MessageBox.Show("this employee   " + s.Count().ToString()+ "   is a doctor");
            int ee = Convert.ToInt32(s.First().Emp_id);

            var type1 = from w in link.Doctors where w.Emp_id == ee select w;
            var type2 = from w in link.Nurses where w.Emp_id == ee select w;
            var type3 = from w in link.Secritaries where w.Emp_id == ee select w;

            if (type1.Count() > 0)
            {
                Doctor d = type1.First();

                //we have a docotr
                Doctor_profile doc = new Doctor_profile(s.First());
                doc.Show();
            }
            else if (type2.Count() > 0)
            {
                Nurse N = type2.First();
                //we have a Nurse
                Nurse_Profile n = new Nurse_Profile();
                n.Show();
            }
            else if (type3.Count() > 0)
            {
                Secritary N = type3.First();
                //we have a Secritary
            }
            else
            {
                // incorrect password or emp doen'nt exist
            }

            MessageBox.Show("this employee   " + type1.First().Extra_info + "   is a doctor");
            Doctor_profile f = new Doctor_profile(s.First());

            f.Show();
            // this.Close();
        }
示例#5
0
        private void button1_Click(object sender, EventArgs e)
        {
            int             appid = 0;
            linkDataContext db    = new linkDataContext();
            var             q     = from a in db.Appointments where a.Patient_id == this.id select a.App_id;

            foreach (var item in q)
            {
                appid = item;
            }

            App_data apdt = new App_data();

            apdt.App_id           = appid;
            apdt.P_id             = this.id;
            apdt.Examination_data = richTextBox1.Text;

            db.App_datas.InsertOnSubmit(apdt);
            db.App_datas.Context.SubmitChanges();

            MessageBox.Show("Data Inserted");
        }