protected void btnChangePassword_Click(object sender, EventArgs e)
    {
        try
        {
            usersTableAdapters.GetSpecificUserTableAdapter user = new usersTableAdapters.GetSpecificUserTableAdapter();
            users.GetSpecificUserRow tblUser = user.GetSpecificUser(MySessionManager.CurrentUser.UserID)[0];

            if (tblUser.datPassword == txtOldPassword.Text)
            {
                if (txtNewPassword.Text == txtConfirmPassword.Text)
                {
                    usersTableAdapters.UsersTableAdapter userData = new usersTableAdapters.UsersTableAdapter();
                    userData.UpdatePassword(txtNewPassword.Text,
                                            MySessionManager.CurrentUser.UserID);
                }
                else
                { ShowMessageBox("The password provided and the Confirmed password does not match"); }
            }
            else 
            {
                ShowMessageBox("The Old password is incorrect");            
            }
        }
        catch (Exception ex) { }

    }
    protected void btnChangePassword_Click(object sender, EventArgs e)
    {
        try
        {
            usersTableAdapters.GetSpecificUserTableAdapter user = new usersTableAdapters.GetSpecificUserTableAdapter();
            users.GetSpecificUserRow tblUser = user.GetSpecificUser(MySessionManager.CurrentUser.UserID)[0];

            if (tblUser.datPassword == txtOldPassword.Text)
            {
                if (txtNewPassword.Text == txtConfirmPassword.Text)
                {
                    usersTableAdapters.UsersTableAdapter userData = new usersTableAdapters.UsersTableAdapter();
                    userData.UpdatePassword(txtNewPassword.Text,
                                            MySessionManager.CurrentUser.UserID);
                }
                else
                {
                    ShowMessageBox("The password provided and the Confirmed password does not match");
                }
            }
            else
            {
                ShowMessageBox("The Old password is incorrect");
            }
        }
        catch (Exception ex) { }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            usersTableAdapters.UsersTableAdapter user = new usersTableAdapters.UsersTableAdapter();

            if (type == "update")
            {
                user.updateUser(ddlTitle.SelectedValue,
                                txtsurname.Value,
                                txtfirstname.Value,
                                Convert.ToDateTime(txtBirthdate.Text),
                                txtMobileNo.Value.Trim(),
                                txtEmail.Value.Trim(),
                                "",
                                "",
                                Convert.ToInt32(ddlTeam.SelectedValue),
                                Convert.ToInt32(ddlDesignation.SelectedValue),
                                txtPosition.Value.Trim());



            }
            else
            {
                user.InsertUser(ddlTitle.SelectedValue,
                                txtsurname.Value,
                                txtfirstname.Value,
                                Convert.ToDateTime(txtBirthdate.Text),
                                txtEmail.Value.Trim(),
                                txtMobileNo.Value.Trim(),
                                DateTime.Now,
                                GeneratePassword(DateTime.Now),
                                "",
                                Convert.ToInt32(ddlTeam.SelectedValue),
                                Convert.ToInt32(ddlDesignation.SelectedValue),
                                txtPosition.Value,
                                1);

            }
        }
        catch (Exception ex) { }

    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            usersTableAdapters.UsersTableAdapter user = new usersTableAdapters.UsersTableAdapter();

            if (type == "update")
            {
                user.updateUser(ddlTitle.SelectedValue,
                                txtsurname.Value,
                                txtfirstname.Value,
                                Convert.ToDateTime(txtBirthdate.Text),
                                txtMobileNo.Value.Trim(),
                                txtEmail.Value.Trim(),
                                "",
                                "",
                                Convert.ToInt32(ddlTeam.SelectedValue),
                                Convert.ToInt32(ddlDesignation.SelectedValue),
                                txtPosition.Value.Trim());
            }
            else
            {
                user.InsertUser(ddlTitle.SelectedValue,
                                txtsurname.Value,
                                txtfirstname.Value,
                                Convert.ToDateTime(txtBirthdate.Text),
                                txtEmail.Value.Trim(),
                                txtMobileNo.Value.Trim(),
                                DateTime.Now,
                                GeneratePassword(DateTime.Now),
                                "",
                                Convert.ToInt32(ddlTeam.SelectedValue),
                                Convert.ToInt32(ddlDesignation.SelectedValue),
                                txtPosition.Value,
                                1);
            }
        }
        catch (Exception ex) { }
    }