protected void btnOk_Click(object sender, EventArgs e)
    {
        try
        {
            int              selected_userId;
            UserClass        uc  = new UserClass();
            PatientClass     pc  = new PatientClass();
            UserPatientClass upc = new UserPatientClass();
            LogUserClass     luc = new LogUserClass();
            LogPatientClass  lpc = new LogPatientClass();

            /*Delete Users' and Patient's record
             * Insert values on Log_UsersWholeFieldWithName and Log_PatientWholeFieldWithName table*/
            /*Getting userId from username from Users table*/
            DataTable dt = uc.SelectAllUsersFromUsername(Session["selectedRow_Username"].ToString());
            if (dt.Rows.Count > 0)
            {
                Session["selected_userId"] = dt.Rows[0]["userId"].ToString();
                selected_userId            = Convert.ToInt32(Session["selected_userId"]);

                /*Getting patientRecord from userId from Patient table*/
                DataTable dtPatient = pc.SelectAllPatientFromUserId(selected_userId);
                if (dtPatient.Rows.Count > 0)
                {
                    Session["selected_patientId"] = dtPatient.Rows[0]["patientId"].ToString();
                    int selected_patientId = Convert.ToInt32(Session["selected_patientId"]);

                    String selected_patientFirstName  = dtPatient.Rows[0]["patientFirstName"].ToString();
                    String selected_patientMiddleName = dtPatient.Rows[0]["patientMiddleName"].ToString();
                    String selected_patientLastName   = dtPatient.Rows[0]["patientLastName"].ToString();
                    Session["selected_patientName"] = selected_patientFirstName + " "
                                                      + selected_patientMiddleName + " " + selected_patientLastName;

                    luc.insertOn_Log_UsersWholeFieldWithName_WithDeleteOperation(selected_userId, Session["selectedRow_Username"].ToString());
                    lpc.insertOn_Log_PatientWholeFieldWithName_WithDeleteOperation(selected_userId, selected_patientId, Session["selected_patientName"].ToString());
                    uc.delete_UsersFrom_userId(selected_userId);
                    pc.delete_PatientFrom_userId(selected_userId);
                }
                //else { ltrMessage.Text = "Error 2nd if"; }
            }
            //else { ltrMessage.Text += "Error 1st if"; }
        }
        catch (Exception ex)
        {
            ltrMessage.Text = ex.Message;
        }
        finally
        {
            ltrDelMsg.Visible = false;
            btnOk.Visible     = false;
            loadData();
        }
    }
    protected void btnRegister_Click(object sender, EventArgs e)
    {
        try
        {
            UserPatientClass upc = new UserPatientClass();

            /*Check normal conditions*/
            //1. Checking Patient Age Group if not <1
            DateTime currentDateNTime = DateTime.Now;
            int      currentYear      = currentDateNTime.Year; //Getting current year

            DateTime dob;
            dob = Convert.ToDateTime(txtboxDob.Text);
            int dobYear = dob.Year; //Getting dob year

            int age = currentYear - dobYear;

            if (age < 1)
            {
                ltrMessage.Text = "Invalid Date of Birth!";
            }

            /*Passwords matching checking*/
            else if (txtboxPassword.Text != txtboxConfirmPassword.Text)
            {
                ltrMessage.Text = "The Passwords did not match!";
            }

            /*2 emails matching checking*/
            else if (txtboxEmail.Text == txtboxSecEmail.Text)
            {
                ltrMessage.Text = "The 2 Email addresses you provided should not be same!";
            }

            /*2 contacts matching checking*/
            else if (txtboxContact.Text == txtboxSecContact.Text)
            {
                ltrMessage.Text = "The 2 Contact Numbers you provided should not be same!";
            }

            /*Putting Country as Nepal by default*/
            else if (txtboxCountry.Text == null)
            {
                txtboxCountry.Text = "Nepal";
                //Console.WriteLine("Went to this condition!");
            }
            else
            {
                upc.RegisterPatient_Users(txtboxUsername.Text, txtboxPassword.Text, txtboxEmail.Text, txtboxSecEmail.Text);
                upc.RegisterPatient_Patient(txtboxUsername.Text, txtboxFirstName.Text, txtboxMiddleName.Text, txtboxLastName.Text, txtboxDob.Text, dropdownlistGender.Text, txtboxContact.Text, txtboxSecContact.Text, txtboxHouseAdd.Text, txtboxDistrict.Text, txtboxCity.Text, txtboxCountry.Text);

                Session["username"] = txtboxUsername.Text;
                Response.Redirect("Home_Patient.aspx");
                //ltrMessageGreen.Text = "New Account registered!";

                //txtboxUsername.Text = "";
                //txtboxPassword.Text = "";
                //txtboxEmail.Text = "";
                //txtboxSecEmail.Text = "";

                //txtboxFirstName.Text = "";
                //txtboxMiddleName.Text = "";
                //txtboxLastName.Text = "";
                //txtboxDob.Text = "";
                //dropdownlistGender.Text = "";
                //txtboxContact.Text = "";
                //txtboxSecContact.Text = "";
                //txtboxHouseAdd.Text = "";
                //txtboxDistrict.Text = "";
                //txtboxCity.Text = "";
                //txtboxCountry.Text = "";

                //txtboxFirstName.Focus();
            }
        }
        catch (Exception ex)
        {
            ltrMessage.Text = ex.Message;
        }
    }