Example #1
0
        public RegPatient(Patient patient)
        {
            InitializeComponent();
            initialiseCombos();
            btnClear.Visible = false;

            try
            {
                txtPatientId.Text = patient.PatientId.ToString();
                txtFirstName.Text = patient.FirstName;
                txtMiddlename.Text = patient.MiddleName;
                txtSurname.Text = patient.Surname;
                cbxNumberOfChildren.SelectedIndex = patient.NumberOfChildren;
                dtcDateOfBirth.Text = patient.DateOfBirth.Date.ToString();
                dateOfAssesment.Text = patient.AssesmentDate.Date.ToString();
                cbxBreadWinner.SelectedItem = patient.BreadWinner;
                cbxPositionInFamily.SelectedItem = patient.PositionInFamily;

                cbxMaritalStatus.SelectedItem = patient.MaritalStatus;
                cbxSex.SelectedItem = patient.Sex;

                txtNrcNumber.Text = patient.NrcNumber;
                txtReligion.Text = patient.Religion;

                cbxParish.SelectedItem = patient.Parish;
                cbxSection.SelectedItem = patient.Section;
                cbxCompound.SelectedItem = patient.Compound;
            }
            catch(Exception ex)
            {

            }
        }
Example #2
0
 public PatientSummary(Patient patient, Login p)
 {
     parent = p;
     InitializeComponent();
     this.patient = patient;
     //PopulateDataGridView();
     secure();
 }
Example #3
0
        private void RegPatient_Enter(object sender, EventArgs e)
        {
            if (Entity.CurrentPatient==null)
            {

                pat = new Patient();
                //pat.PatientId = Entity.generateNewPatientId();
            }
            else
            {
                //Entity.CurrentPatient = new Patient();
                //pat = new

            }
        }
Example #4
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            if(txtPatientId.Text=="")
            {
                string temp = "doesntexist";
                pat=new Patient();
                pat.PatientId = Int32.Parse(Entity.validatePatientID(temp));
            }
            else
            {
                pat = Entity.CurrentPatient;
                pat.PatientId = Int32.Parse(txtPatientId.Text);
            }
            pat.FirstName = txtFirstName.Text;
            pat.Surname = txtSurname.Text;
            pat.MiddleName = txtMiddlename.Text;
            pat.DateOfBirth = dtcDateOfBirth.Value;
            pat.Sex = cbxSex.Text;
            pat.Compound = cbxCompound.Text;
            pat.NrcNumber = txtNrcNumber.Text;
            pat.PositionInFamily = cbxPositionInFamily.Text;
            pat.Parish = cbxParish.Text;
            pat.Section = cbxSection.Text;
            pat.BreadWinner = cbxBreadWinner.Text;
            pat.Religion = txtReligion.Text;
            try
            {
                pat.NumberOfChildren = Int32.Parse(cbxNumberOfChildren.Text);
            }catch(Exception ex)
            {
                pat.NumberOfChildren = 0;
            }
            pat.MaritalStatus = cbxMaritalStatus.Text;
            pat.AssesmentDate = dateOfAssesment.Value;

            Entity.saveReg(pat);
            Entity.CurrentPatient = pat;
            parent.SetUserControl(new PatientSummary(Entity.CurrentPatient,parent));
        }
Example #5
0
 public static void ClearCurrentState()
 {
     _currentPatient = null;
        CurrentSiteId = -1;
        CurrentUser = null;
 }
Example #6
0
        public static void saveReg(Patient patient)
        {
            string query;
            if (!patIdExist(patient.PatientId))
            {
                query = string.Format(@"INSERT INTO
                                            registration VALUES({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}')", patient.PatientId, Utility.parseString(patient.FirstName), Utility.parseString(patient.Surname), patient.MiddleName, formartDateForMySQL(patient.DateOfBirth), patient.Sex, patient.Compound, patient.NrcNumber, patient.PositionInFamily, patient.Parish, patient.Section, patient.BreadWinner, patient.NumberOfChildren, patient.MaritalStatus, formartDateForMySQL(patient.AssesmentDate), patient.Religion);
            }
            else
            {
                query = string.Format(@"UPDATE
                                        registration SET patientID={0},firstname='{1}',surname='{2}',middle_name='{3}',dateofbirth='{4}',sex='{5}',compound='{6}',nrc_number='{7}',position_in_family='{8}',parish='{9}',section='{10}',bread_winner='{11}',number_of_children={12},marital_status='{13}',assesment_date='{14}', religion='{15}' where patientId={0}", patient.PatientId, Utility.parseString(patient.FirstName), patient.Surname, patient.MiddleName, formartDateForMySQL(patient.DateOfBirth), patient.Sex, patient.Compound, patient.NrcNumber, patient.PositionInFamily, patient.Parish, patient.Section, patient.BreadWinner, patient.NumberOfChildren, patient.MaritalStatus, formartDateForMySQL(patient.AssesmentDate), patient.Religion);
            }

            db.runNonQuery(query);
        }
Example #7
0
 public static void savePatientToDb(Patient patient)
 {
     saveReg(patient);
     //saveVisitsInfo(patient);
 }
Example #8
0
 public static Patient LoadReg(string patientid)
 {
     Patient pa = new Patient();
     return pa;
 }
Example #9
0
        public static Patient loadPatient(int patientId)
        {
            string query = string.Format(@"select patientID,firstname,surname,middle_name,dateofbirth,sex,compound,nrc_number,position_in_family,parish,section,bread_winner,number_of_children,marital_status,assesment_date, religion from registration where patientid={0}", patientId);

            string[] loadPat = db.singleRow(query);
            int count = 0;

            CurrentPatient = new Patient(Int32.Parse(loadPat[0]), loadPat[1], loadPat[2], loadPat[3], DateTime.Parse(loadPat[4]), loadPat[5], loadPat[6], loadPat[7], loadPat[8], loadPat[9], loadPat[10], loadPat[11], Int32.Parse(loadPat[12]), loadPat[13], DateTime.Parse(loadPat[14]), loadPat[15]);
            Entity.CurrentPatient.Visits = loadPatientVisits(Entity.CurrentPatient.PatientId);
            return CurrentPatient;
        }