protected void loadPageInfo(int space_id)
    {
        qSoc_Space space = new qSoc_Space(space_id);
        string html = string.Empty;

        var active_campaigns = qSoc_SpaceCampaign_View.GetAllSpaceCampaignsBySpaceByAvailability(space_id, "Yes");
        var archived_campaigns = qSoc_SpaceCampaign_View.GetAllSpaceCampaignsBySpaceByAvailability(space_id, "No");

        if (active_campaigns != null)
        {
            foreach (var a in active_campaigns)
            {
                html += "<li><a href=\"/manage/campaigns/campaign-details.aspx?campaignID=" + a.CampaignID + "\">" + a.CampaignName + "</a></li>";
            }

            litActiveCampaigns.Text = html;
        }

        html = string.Empty;

        if (archived_campaigns != null)
        {
            foreach (var a in archived_campaigns)
            {
                html += "<li><a href=\"/manage/campaigns/campaign-details.aspx?campaignID=" + a.CampaignID + "\">" + a.CampaignName + "</a></li>";
            }

            litArchivedCampaigns.Text = html;
        }
    }
    protected void btnAddMember_Click(object sender, EventArgs e)
    {
        if (!String.IsNullOrEmpty(rblNewMemberRole.SelectedValue) && !String.IsNullOrEmpty(txtMemberUserName.Text))
        {
            // make sure user exists
            qPtl_User new_member = new qPtl_User(txtMemberUserName.Text);

            if (new_member.UserID > 0)
            {
                var existing_space_id = qSoc_UserSpace.GetMostRecentAddedUserSpace(new_member.UserID);
                if (existing_space_id == 0)
                {
                    // member can now be added
                    qSoc_UserSpace u_space = new qSoc_UserSpace();
                    u_space.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                    u_space.Available = "Yes";
                    u_space.Created = DateTime.Now;
                    u_space.CreatedBy = Convert.ToInt32(Context.Items["UserID"]);
                    u_space.LastModified = DateTime.Now;
                    u_space.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                    u_space.MarkAsDelete = 0;
                    u_space.UserID = new_member.UserID;
                    u_space.SpaceID = Convert.ToInt32(Request.QueryString["spaceID"]);
                    if (rblNewMemberRole.SelectedValue == "Advisor")
                    {
                        u_space.SpaceRole = "Moderator";
                        qPtl_SpaceAdmin admin = new qPtl_SpaceAdmin();
                        admin.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                        admin.Available = "Yes";
                        admin.Created = DateTime.Now;
                        admin.CreatedBy = Convert.ToInt32(Context.Items["UserID"]);
                        admin.LastModified = DateTime.Now;
                        admin.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                        admin.MarkAsDelete = 0;
                        admin.UserID = new_member.UserID;
                        admin.SpaceID = Convert.ToInt32(Request.QueryString["spaceID"]);
                        admin.Insert();
                    }
                    u_space.Insert();

                    Response.Redirect("/manage/members/space-edit.aspx?spaceID=" + Request.QueryString["spaceID"]);
                }
                else
                {
                    qSoc_Space e_space = new qSoc_Space(existing_space_id);
                    lblMessageMember.Text = "&nbsp;&nbsp;<strong>***ERROR***</strong> This member is already a member of the group: <strong>" + e_space.SpaceShortName + "</strong>. The member must first be removed from this group.";
                }
            }
            else
            {
                lblMessageMember.Text = "&nbsp;&nbsp;<strong>***ERROR***</strong> This member does not exist; please enter another username";
            }
        }
        else
            lblMessageMember.Text = "&nbsp;&nbsp;<strong>***ERROR***</strong> You need to enter a username and select a role";
    }
    protected void btnChangeGroup_Click(object sender, EventArgs e)
    {
        // delete existing group
        if (!String.IsNullOrEmpty(ddlSpaces.SelectedValue))
        {
            int curr_user_id = Convert.ToInt32(Context.Items["UserID"]);
            int profile_id = Convert.ToInt32(Request.QueryString["userID"]);
            var user_space = qSoc_UserSpace_View.GetMostRecentUserspace(profile_id);

            if (user_space != null)
            {
                //DeleteSpaceItems(user_space);     // no longer do this so we can support multiple groups
            }

            // create new group based on selected items
            qSoc_Space space = new qSoc_Space(Convert.ToInt32(ddlSpaces.SelectedValue));

            qPtl_User user = new qPtl_User(profile_id);

            qSoc_UserSpace u_space = new qSoc_UserSpace();
            u_space.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
            u_space.Available = "Yes";
            u_space.Created = DateTime.Now;
            u_space.CreatedBy = curr_user_id;
            u_space.LastModified = DateTime.Now;
            u_space.LastModifiedBy = curr_user_id;
            u_space.MarkAsDelete = 0;
            u_space.UserID = profile_id;
            u_space.SpaceID = space.SpaceID;
            if (user.HighestRole == "Advisor")
                u_space.SpaceRole = "Moderator";
            u_space.Insert();

            // create new school
            if (space.SchoolID > 0)
            {
                qOrg_UserSchool u_school = new qOrg_UserSchool();
                u_school.Available = "Yes";
                u_school.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                u_school.MarkAsDelete = 0;
                u_school.Created = DateTime.Now;
                u_school.CreatedBy = curr_user_id;
                u_school.LastModified = DateTime.Now;
                u_school.LastModifiedBy = curr_user_id;
                u_school.MarkAsDelete = 0;
                u_school.UserID = profile_id;
                u_school.SchoolID = space.SchoolID;
                u_school.Insert();
            }

            Response.Redirect("/manage/members/member-profile.aspx?userID=" + profile_id + "&currTab=group&message=successfully updated user group");
        }
        else
            lblGroupMessage.Text = "*** You must first select a group ***";
    }
    protected void loadPageInfo()
    {
        string list_html = string.Empty;

        var list = qSoc_Space.GetSpaces();
        if (list != null)
        {
            foreach (var l in list)
            {
                qSoc_Space item = new qSoc_Space(l.SpaceID);
                list_html += "<li><a href=\"/manage/spaces/default.aspx?spaceID=" + item.SpaceID + "\">" + item.SpaceShortName + "</a></li>";
            }

            litList.Text = list_html;
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            int invitation_id = 0;
            invitation_id = Convert.ToInt32(Request.QueryString["invitationID"]);

            qPtl_Invitation invite = new qPtl_Invitation(invitation_id);
            int space_id = invite.SpaceID;

            qSoc_Space space = new qSoc_Space(space_id);

            var group_invites = qPtl_Invitation_View.GetInvitationsBySpaceID(space_id);

            string tableHTML = string.Empty;
            tableHTML =     "<table align=\"center\" width=\"650\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\" style=\"border:solid 1px #000; background:#CCC;\">";
            tableHTML +=    "<tr>";
            tableHTML +=    "<td colspan=\"2\" style=\"text-align: center; font-weight:bold; font-size:16px;\"><div style=\"height:10px;\"></div>Group: " + space.SpaceShortName + "<div style=\"height:10px;\"></div>";
            tableHTML +=    "</td><tr>";
            tableHTML +=    "<td align=\"center\"><b>Group Members</b></td><td align=\"center\"><b>Invitation Code</b></td></tr>";

            if (group_invites != null)
            {
                foreach (var i in group_invites)
                {
                    tableHTML += "<tr><td align=\"center\">";
                    tableHTML += Convert.ToString(i.RoleName);
                    tableHTML += "</td><td align=\"center\">";
                    tableHTML += Convert.ToString(i.InviteCode);
                    tableHTML += "</td><td align=\"center\">";
                }
            }

            tableHTML += "<br /><div style=\"height:10px;\"></div></td></tr></table>";

            litInvitationHTML.Text = tableHTML;
            lblSpaceID.Text = "Space ID=" + invite.SpaceID;

            int scope_id = Convert.ToInt32(Context.Items["ScopeID"]);
            qPtl_InvitationTemplate template = qPtl_InvitationTemplate.GetTemplateByScopeID(scope_id);
            litHeader.Text = template.Header;
            litFooter.Text = template.Footer;
        }
    }
Example #6
0
    protected void loadPageInfo(int space_id)
    {
        qSoc_Space space = new qSoc_Space(space_id);

        //litDashboardImage.Text = "<h3>" + space.SpaceShortName  + "</h3><img src=\"" + resources_url + "/spaces/" + space_id + "/reports/report.png\">";
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            populateSchoolDistricts();

            if (!String.IsNullOrEmpty(Convert.ToString(Context.Items["UserID"])))
            {
                qPtl_User curr_user = new qPtl_User(Convert.ToInt32(Context.Items["UserID"]));
                if (curr_user.UserID > 0)
                    Response.Redirect("~/utilities/manage-user-access.aspx");
            }

            if (invitation_required == true)
                plhInvitation.Visible = true;
            else
                plhInvitation.Visible = false;

            if (space_code_available == true && invitation_required == false)
                plhSpaceCode.Visible = true;
            else
                plhSpaceCode.Visible = false;

            if (sms_available == true)
                plhMobileAvailable.Visible = false;     // HACK - always set to false
            else
                plhMobileAvailable.Visible = false;

            if (race_available == true)
                plhRace.Visible = true;
            else
                plhRace.Visible = false;

            if (school_available == true)
            {
                plhSchool.Visible = true;
                plhSchoolInfo.Visible = false;
            }
            else
            {
                plhSchool.Visible = false;
            }

            // see if registration code passed
            string reg_code = string.Empty;

            // check to see if matches space
            if (!String.IsNullOrEmpty(Request.QueryString["code"]))
            {
                reg_code = Request.QueryString["code"];
                qSoc_Space space = new qSoc_Space(reg_code);

                if (space.SpaceID > 0)
                {
                    txtSpaceCode.Text = reg_code;
                    lblSpaceDescription.Text = "<br><span class=\"label label-success\"><i class=\"icon-ok\"></i>&nbsp;" + space.SpaceShortName + " group.</span><br>";
                }

                // if no space match, then check to see if it matches a campaign
                if (space.SpaceID == 0)
                {
                    qSoc_Campaign campaign = new qSoc_Campaign(reg_code);

                    if (campaign.CampaignID > 0)
                    {
                        txtSpaceCode.Text = reg_code;
                        lblSpaceDescription.Text = "<br><span class=\"label label-success\"><i class=\"icon-ok\"></i>&nbsp;" + campaign.CampaignName + " channel.</span><br>";
                    }
                }
            }

            // populate the year dropdown
            DateTime currDate = DateTime.Now;
            int currYear = Convert.ToInt32(currDate.Year);
            int startYear = Convert.ToInt32(currDate.Year) - 108;
            DataTable dtYears = new DataTable();
            DataColumn year = new DataColumn("Year");
            year.DataType = System.Type.GetType("System.Int32");
            dtYears.Columns.Add(year);

            for (int i = startYear; i <= currYear; i++)
            {
                DataRow row = dtYears.NewRow();
                row[year] = i;
                dtYears.Rows.Add(row);
            }

            dtYears.DefaultView.Sort = "Year DESC";

            ddlYear.DataSource = dtYears;
            ddlYear.DataTextField = "Year";
            ddlYear.DataValueField = "Year";
            ddlYear.DataBind();
            ddlYear.Items.Insert(0, new ListItem("", string.Empty));

            ddlMonth.SelectedIndex = 0;
            ddlDay.SelectedIndex = 0;
            ddlYear.SelectedIndex = 0;

            // configure gender
            string gender_options = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["Register_SupportedGenderValues"]);
            ddlGender.Items.FindByValue("Intersex").Enabled = false;
            ddlGender.Items.FindByValue("Transgender").Enabled = false;
            if (gender_options.Contains("Intersex"))
                ddlGender.Items.FindByValue("Intersex").Enabled = true;
            if (gender_options.Contains("Transgender"))
                ddlGender.Items.FindByValue("Transgender").Enabled = true;

            // look for custom home value
            string hplBack_custom = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["Site_PublicHomePage"]);
            if (!String.IsNullOrEmpty(hplBack_custom))
                hplBack.NavigateUrl = hplBack_custom;
            else
                hplBack.NavigateUrl = "~/default.aspx";
        }
    }
    protected void btnSignUp_Click(object sender, EventArgs e)
    {
        Page.Validate("register");

        if (Page.IsValid)
        {
            string sqlCode = string.Empty;
            string returnMessage = string.Empty;
            qDbs_SQLcode sql = new qDbs_SQLcode();
            string register_mode = "new";
            int existing_user_id = 0;
            int scope_id = 1;   // would have to be changed to support multiple organizations on a single platform
            int role_id = 0;
            int moderator_role_id = 0;
            if (!String.IsNullOrEmpty(Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["Register_ModeratorRoleID"])))
                moderator_role_id = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["Register_ModeratorRoleID"]);

            // ****************************************************
            // STEP 1: DETERMINE IF USER IS ALREADY A LIMITED MOBILE USER
            if (plhMobileNumber.Visible == true)
            {
                //Determine if upgrade of mobile account or new registration
                qPtl_UserProfile mobile_test = qPtl_UserProfile.GetProfileByMobileNumber(txtMobileNumber.Text);

                if (mobile_test != null)
                {
                    if (mobile_test.UserID > 0)
                    {
                        // make sure that the user is eligible for upgrade from mobile only status
                        qPtl_User eval_user = new qPtl_User(mobile_test.UserID);

                        if (eval_user.HighestRole == "Mobile")
                        {
                            register_mode = "update";
                            existing_user_id = mobile_test.UserID;
                        }
                    }
                    else
                    {
                        register_mode = "new";
                    }
                }
                else
                {
                    register_mode = "new";
                }
            }

            // ****************************************************
            // STEP 2a: Mode == new; then add new user
            string currAvailableStatus = string.Empty;
            currAvailableStatus = "Yes";

            if (register_mode == "new")
            {
                qPtl_User new_user = new qPtl_User();
                new_user.Available = "Yes";
                new_user.ScopeID = scope_id;
                new_user.Created = DateTime.Now;
                new_user.CreatedBy = 0;
                new_user.LastModified = DateTime.Now;
                new_user.LastModifiedBy = 0;
                new_user.MarkAsDelete = 0;
                new_user.Status = "";       // used to include a default message for their status, now leave blank
                new_user.FirstName = txtFirstName.Text;
                new_user.LastName = txtLastName.Text;
                new_user.Email = txtEmail.Text;
                new_user.UserName = txtUserName.Text;
                string password_for_storing = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "sha1");
                new_user.Password = password_for_storing;
                new_user.AccountStatus = "Active";
                new_user.Insert();
                existing_user_id = new_user.UserID;

                DateTime DOB;
                try
                {
                    DOB = new DateTime(int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), int.Parse(ddlDay.SelectedValue)); ;//Convert.ToDateTime(ddlMonth.SelectedValue + "/" + ddlDay.SelectedValue + "/" + ddlYear.SelectedValue);
                }
                catch
                {
                    // no valid date so use default value
                    DOB = new DateTime(1900, 1, 1); ////Convert.ToDateTime("1/1/1900");
                }
                qPtl_UserProfile new_profile = new qPtl_UserProfile();
                new_profile.UserID = existing_user_id;
                new_profile.ScopeID = scope_id;
                new_profile.Available = "Yes";
                new_profile.Created = DateTime.Now;
                new_profile.CreatedBy = existing_user_id;
                new_profile.LastModified = DateTime.Now;
                new_profile.LastModifiedBy = existing_user_id;
                new_profile.MarkAsDelete = 0;
                new_profile.Style = "default";
                new_profile.Visibility = "all";
                new_profile.Gender = ddlGender.SelectedValue;
                new_profile.DOB = DOB;

                if (plhRace.Visible == true)
                {
                    string race = string.Empty;
                    int n = 0;
                    foreach (ListItem item in cblRace.Items)
                    {
                        if (item.Selected)
                        {
                            if (n > 0)
                            {
                                race += "," + item.Value;
                            }
                            else
                            {
                                race += item.Value;
                            }
                            n++;
                        }
                    }
                    n = 0;
                    new_profile.Race = race;
                }
                new_profile.Insert();
            }
            qPtl_User user = new qPtl_User(existing_user_id);

            // STEP 2b: Mode == update; then update mobile info
            //mode mobile = update existing account
            if (register_mode == "update")
            {
                user.FirstName = txtFirstName.Text;
                user.LastName = txtLastName.Text;
                user.UserName = txtEmail.Text;
                user.Email = txtEmail.Text;
                string password_for_storing = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "sha1");
                user.Password = password_for_storing;
                user.AccountStatus = "Mobile Verification Pending";
                user.Update();
            }

            // ****************************************************
            // STEP 3: Process invitation & perform invitation-specific work
            // OPTION #1 -- an invitation is required as part of the registration process and a collection of additional actions are related to that
            string code = string.Empty;
            string process_code_mode = string.Empty;
            if (plhInvitation.Visible == true)
            {
                code = txtInvitationCode.Text;
                if (String.IsNullOrEmpty(process_code_mode))
                    process_code_mode = "invitation";                // deal with default/null values
            }
            else if (plhSpaceCode.Visible == true)
            {
                code = txtSpaceCode.Text;
                if (String.IsNullOrEmpty(process_code_mode))
                {
                    qSoc_Space space = new qSoc_Space(code);

                    if (space.SpaceID > 0)
                    {
                        process_code_mode = "space";
                    }
                    else
                    {
                        qSoc_Campaign campaign = new qSoc_Campaign(code);

                        if (campaign.CampaignID > 0)
                        {
                            process_code_mode = "campaign";
                        }
                    }
                }
            }

            if (!String.IsNullOrEmpty(code) && process_code_mode == "invitation")
            {
                //Process invitation
                int invitationID = 0;
                qPtl_Invitation invite = null;
                invite = new qPtl_Invitation(code);
                invitationID = invite.InvitationID;
                role_id = invite.RoleID;

                // update invitation records as necessary
                if (invite.InvitationAudience == "family")
                {
                    invite.UserID = user.UserID;
                    invite.InvitationStatus = "Redeemed";
                    invite.LastModified = DateTime.Now;
                    invite.LastModifiedBy = user.UserID;
                    invite.CurrRedemptions = invite.CurrRedemptions + 1;
                }
                else if (invite.InvitationAudience == "individual")
                {
                    invite.UserID = user.UserID;
                    invite.InvitationStatus = "Redeemed";
                    invite.LastModified = DateTime.Now;
                    invite.LastModifiedBy = user.UserID;
                    invite.CurrRedemptions = invite.CurrRedemptions + 1;
                }
                else if (invite.InvitationAudience == "group")
                {
                    invite.UserID = user.UserID;
                    invite.LastModified = DateTime.Now;
                    invite.LastModifiedBy = user.UserID;
                    invite.CurrRedemptions = invite.CurrRedemptions + 1;

                    if (invite.MaxRedemptions > 0 && invite.CurrRedemptions >= invite.MaxRedemptions)
                        invite.InvitationStatus = "Redeemed";
                }
                else if (invite.InvitationAudience == "moderated group")
                {
                    invite.UserID = user.UserID;
                    invite.LastModified = DateTime.Now;
                    invite.LastModifiedBy = user.UserID;
                    invite.CurrRedemptions = invite.CurrRedemptions + 1;

                    if (invite.MaxRedemptions > 0 && invite.CurrRedemptions >= invite.MaxRedemptions)
                        invite.InvitationStatus = "Redeemed";
                }
                invite.Update();

                // add possible space associated with invitation & space-specific elements

                if (invite.SpaceID > 0)
                {
                    qSoc_Space space = new qSoc_Space(invite.SpaceID);
                    if (space != null)
                    {
                        if (space.SpaceID > 0)
                        {
                            qSoc_UserSpace u_space = new qSoc_UserSpace();
                            u_space.ScopeID = scope_id;
                            u_space.Available = "Yes";
                            u_space.Created = DateTime.Now;
                            u_space.CreatedBy = user.UserID;
                            u_space.LastModified = DateTime.Now;
                            u_space.LastModifiedBy = user.UserID;
                            u_space.MarkAsDelete = 0;
                            u_space.UserID = user.UserID;
                            u_space.SpaceID = space.SpaceID;
                            u_space.PrimarySpace = true;
                            if (role_id == moderator_role_id)
                                u_space.SpaceRole = "Moderator";
                            u_space.Insert();
                        }

                        if (space.SchoolID > 0)
                        {
                            qOrg_UserSchool school = new qOrg_UserSchool();
                            school.UserID = user.UserID;
                            school.SchoolID = space.SchoolID;
                            school.Insert();
                        }

                        // set space to visibile in directory it not already visible
                        if (space.VisibleInDirectory == "No")
                        {
                            space.VisibleInDirectory = "Yes";
                            space.Update();
                        }

                        // add campaign -- includes check to insure that campaigns aren't added twice
                        AddSpaceCampaigns(space, user, scope_id);
                    }
                }

                // add possible campaign associated with invitation -- includes check to insure that campaigns aren't added twice
                if (invite.CampaignID > 0)
                {
                    qSoc_UserCampaign checkc = new qSoc_UserCampaign(user.UserID, invite.CampaignID);
                    if (checkc.UserCampaignID == 0)
                    {
                        AddUserCampaign(invite.CampaignID, scope_id, user);
                    }
                }

                if (invite.FunctionalRoleID > 0)
                {
                    sqlCode = "INSERT INTO qLrn_UserFunctionalRoles ([UserID],[FunctionalRoleID]) VALUES(" + user.UserID + "," + invite.FunctionalRoleID + ")";
                    sql.ExecuteSQL(sqlCode);

                    UserFunctions.AddUserTrainingsByFunctionalRole(user.UserID, invite.FunctionalRoleID);
                }
            }
            else
            {
                // else use default role types
                int teen_max_age = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["Register_TeenMaxAge"]);

                qPtl_UserProfile profile = new qPtl_UserProfile(user.UserID);
                if (profile.Age <= teen_max_age)
                    role_id = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["Register_TeenRoleID"]);
                else
                    role_id = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["Register_ParentRoleID"]);
            }

            // OPTION #2 -- User might have entered a registration code; this will assign them to a space which might have one or more associated campaigns
            if (!String.IsNullOrEmpty(code) && process_code_mode == "space")
            {
                if (!string.IsNullOrEmpty(code))
                {
                    qSoc_Space space = new qSoc_Space(code);

                    if (space != null)
                    {
                        if (space.SpaceID > 0)
                        {
                            qSoc_UserSpace u_space = new qSoc_UserSpace();
                            u_space.ScopeID = scope_id;
                            u_space.Available = "Yes";
                            u_space.Created = DateTime.Now;
                            u_space.CreatedBy = user.UserID;
                            u_space.LastModified = DateTime.Now;
                            u_space.LastModifiedBy = user.UserID;
                            u_space.MarkAsDelete = 0;
                            u_space.UserID = user.UserID;
                            u_space.SpaceID = space.SpaceID;
                            u_space.PrimarySpace = true;
                            if (role_id == moderator_role_id)
                                u_space.SpaceRole = "Moderator";
                            u_space.Insert();
                        }

                        space_redirect = true;
                        new_space_id = space.SpaceID;

                        AddSpaceCampaigns(space, user, scope_id);
                    }
                }
            }
            else if (!String.IsNullOrEmpty(code) && process_code_mode == "campaign")
            {
                qSoc_Campaign campaign = new qSoc_Campaign(code);

                AddUserCampaign(campaign.CampaignID, scope_id, user);
            }

            // ****************************************************
            // STEP 4: Add School Information
            if (plhSchool.Visible == true)
            {
                string school_name = string.Empty;
                string school_other_name = string.Empty;

                if (radCBSearch.Visible == true)
                    school_name = radCBSearch.SelectedValue;
                else
                {
                    school_other_name = txtSchoolOther.Text;
                    school_name = "Other";
                }

                var school = qOrg_School.GetSchoolFromAutoPopulateDropdown(school_name);

                if (school != null)
                {
                    if (school.SchoolID > 0)
                    {
                        qOrg_UserSchool user_school = new qOrg_UserSchool();
                        user_school.Available = "Yes";
                        user_school.ScopeID = scope_id;
                        user_school.Created = DateTime.Now;
                        user_school.CreatedBy = user.UserID;
                        user_school.LastModified = DateTime.Now;
                        user_school.LastModifiedBy = user.UserID;
                        user_school.MarkAsDelete = 0;
                        user_school.UserID = user.UserID;
                        user_school.SchoolID = school.SchoolID;
                        user_school.OtherName = school_other_name;
                        user_school.Insert();

                        // see if this school is already a space
                        var school_space = qSoc_Space.GetSpacesBySchool(school.SchoolID);

                        qSoc_Space curr_space = new qSoc_Space();
                        if (school_space == null)
                        {
                            qSoc_Space new_space = new qSoc_Space();
                            new_space.ScopeID = scope_id;
                            new_space.Available = "Yes";
                            new_space.Created = DateTime.Now;
                            new_space.CreatedBy = 0;
                            new_space.LastModified = DateTime.Now;
                            new_space.LastModifiedBy = 0;
                            new_space.MarkAsDelete = 0;
                            new_space.SpaceName = school.School;
                            new_space.SpaceShortName = school.School;
                            new_space.SpaceType = "school";
                            new_space.AccessMode = "open";
                            new_space.VisibleInDirectory = "Yes";
                            new_space.SpaceCategoryID = 1;
                            new_space.SchoolID = school.SchoolID;
                            new_space.Insert();

                            school_space = new_space;
                        }

                        if (school_space != null)
                        {
                            qSoc_UserSpace s_space = new qSoc_UserSpace();
                            s_space.ScopeID = scope_id;
                            s_space.Available = "Yes";
                            s_space.Created = DateTime.Now;
                            s_space.CreatedBy = user.UserID;
                            s_space.LastModified = DateTime.Now;
                            s_space.LastModifiedBy = user.UserID;
                            s_space.MarkAsDelete = 0;
                            s_space.UserID = user.UserID;
                            s_space.SpaceID = school_space.SpaceID;
                            s_space.PrimarySpace = true;
                            if (role_id == moderator_role_id)
                                s_space.SpaceRole = "Moderator";
                            s_space.Insert();
                        }
                    }
                }
            }

            // ****************************************************
            // STEP 5: Add User Role & Supporting Role Structures
            // Add role
            /*
            qPtl_UserRole role = new qPtl_UserRole();
            role.UserID = user.UserID;
            role.RoleID = role_id;
            role.Insert();
             */
            sqlCode = "INSERT INTO qPtl_UserRoles ([UserID],[RoleID]) VALUES(" + user.UserID + "," + role_id + ")";
            sql.ExecuteSQL(sqlCode);

            // Add possible role actions for the new user role
            AddRoleAction(role_id, scope_id, user);

            // Add possible role campaigns
            AddRoleCampaigns(role_id, scope_id, user);

            // Redundancy check -- write Highest Level into qPtl_User table in case DB trigger not working
            qPtl_Role role = new qPtl_Role(role_id);
            user.HighestRank = role.RoleRank;
            user.HighestRole = role.RoleName;
            user.Update();

            // ****************************************************
            // STEP 6: User Utilties to finalize/prep account
            // Add username folder for images
            string rootLocation = Server.MapPath("~/") + "user_data\\";

            if (!Directory.Exists(rootLocation + user.UserName))
                Directory.CreateDirectory(rootLocation + user.UserName);

            // Create default album
            qSoc_Album album = new qSoc_Album();
            album.ScopeID = scope_id;
            album.Available = "Yes";
            album.Created = DateTime.Now;
            album.CreatedBy = user.UserID;
            album.LastModified = DateTime.Now;
            album.LastModifiedBy = user.UserID;
            album.MarkAsDelete = 0;
            album.UserID = user.UserID;
            album.Name = "My Pics";
            album.Insert();

            // Add communications preferences
            if (register_mode == "new")
            {
                qCom_UserPreference connect = new qCom_UserPreference();
                connect.UserID = user.UserID;
                connect.Created = DateTime.Now;
                connect.CreatedBy = user.UserID;
                connect.LastModified = DateTime.Now;
                connect.LastModifiedBy = user.UserID;
                connect.Available = "Yes";
                connect.ScopeID = 1;
                connect.MarkAsDelete = 0;
                connect.OkBulkEmail = "Yes";
                connect.OkEmail = "Yes";
                connect.OkSms = "Yes";
                connect.LanguageID = 1;
                connect.Insert();
            }

            qCom_UserPreference user_connect = qCom_UserPreference.GetUserPreference(user.UserID);
            user_connect.OkBulkEmail = "Yes";
            user_connect.OkEmail = "Yes";
            user_connect.Update();

            // ****************************************************
            // STEP 7: Log user in and redirect to account setup page/
            // initial session created -- will last for 24 hours before timing out
            qPtl_Sessions session = new qPtl_Sessions();
            session.Created = DateTime.Now;
            session.StartTime = DateTime.Now;
            session.LastTimeSeen = DateTime.Now;
            session.ScopeID = user.ScopeID;
            session.UserID = user.UserID;
            session.BrowserType = Request.Browser.Browser;
            session.ComputerType = Request.Browser.Platform;
            session.Insert();
            int sessionID = session.SessionID;
            int scopeID = user.ScopeID;

            var u_roles = qPtl_UserRole_View.GetUserRoles(user.UserID);
            string role_list = string.Empty;

            if (u_roles != null)
            {
                foreach (var u in u_roles)
                {
                    role_list += string.Format("{0},", u.RoleName, ",");
                }
            }

            role_list.TrimEnd(',');

            string userData = string.Format("{0};{1};{2}", sessionID, role_list, scopeID);

            FormsAuthenticationTicket tkt;
            string cookiestr;
            HttpCookie ck;
            tkt = new FormsAuthenticationTicket(1, user.UserID.ToString(), DateTime.Now, DateTime.Now.AddMinutes(3600), false, userData);
            cookiestr = FormsAuthentication.Encrypt(tkt);
            ck = new HttpCookie(FormsAuthentication.FormsCookieName, cookiestr);
            ck.Path = FormsAuthentication.FormsCookiePath;
            Response.Cookies.Add(ck);

            HttpCookie cookie2 = new HttpCookie("UserID", Convert.ToString(user.UserID));
            if (tkt.IsPersistent) { cookie2.Expires = tkt.Expiration.AddMinutes(3605); }
            Response.Cookies.Add(cookie2);

            if (space_redirect == true && new_space_id > 0)
                Response.Redirect("~/utilities/manage-user-access.aspx?mode=registration&spaceID=" + new_space_id);
            else
                Response.Redirect("~/utilities/manage-user-access.aspx?mode=registration");
        }
    }
    protected void AddSpaceCampaigns(qSoc_Space space, qPtl_User user, int scope_id)
    {
        //Add space campaigns
        string sqlCode = string.Empty;
        string returnMessage = string.Empty;
        qDbs_SQLcode sql = new qDbs_SQLcode();

        sqlCode = string.Format("SELECT * FROM qSoc_SpaceCampaigns WHERE SpaceID = " + space.SpaceID + " AND Available = 'Yes' AND ScopeID = " + scope_id);

        int campaignID = 0;
        string progressMode = string.Empty;

        using (SqlDataReader sReader = sql.GetDataReader(sqlCode))
        {
            if (sReader.HasRows)
            {
                while (sReader.Read())
                {
                    campaignID = Convert.ToInt32(sReader["CampaignID"]);

                    qSoc_UserCampaign checkc = new qSoc_UserCampaign(user.UserID, campaignID);
                    if (checkc.UserCampaignID == 0)
                    {
                        //create campaign for user
                        qSoc_Campaign campaign = new qSoc_Campaign(campaignID);

                        AddUserCampaign(campaign.CampaignID, scope_id, user);
                    }
                }
            }
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            populateSchools();
            populateSpaceCategories();

            hplBackTop.NavigateUrl = "spaces-list.aspx";
            hplBackBottom.NavigateUrl = "spaces-list.aspx";

            hplRefreshBottom.NavigateUrl = Request.Url.ToString();
            hplRefreshTop.NavigateUrl = Request.Url.ToString();

            if (!String.IsNullOrEmpty(Request.QueryString["spaceID"]))
            {
                space_id = Convert.ToInt32(Request.QueryString["spaceID"]);
                qSoc_Space space = new qSoc_Space(space_id);
                txtGroupNameNew.Text = space.SpaceShortName;
                txtGroupNameNewFull.Text = space.SpaceName;
                ddlGroupTypeNew.SelectedValue = space.SpaceType;
                if (!String.IsNullOrEmpty(Convert.ToString(space.SchoolID)))
                    ddlSchoolNew.SelectedValue = Convert.ToString(space.SchoolID);
                if (!String.IsNullOrEmpty(Convert.ToString(space.SpaceCategoryID)))
                    ddlSpaceCategoriesNew.SelectedValue = Convert.ToString(space.SpaceCategoryID);
                lblPostedTime.Text = Convert.ToString(space.Created);
                lblTitle.Text = "Edit Group (ID: " + space.SpaceID + ")";
                rblAvailableNew.Text = space.Available;
                rblVisibleInDirectory.Text = space.VisibleInDirectory;
                ddlEnrollmentType.SelectedValue = space.AccessMode;

                qPtl_User user = new qPtl_User(space.LastModifiedBy);
                user_id = user.UserID;
                username = user.UserName;

                qPtl_User reviewed_by = new qPtl_User(space.LastModifiedBy);
                lblPostedTime.Text = " at " + space.LastModified;
                plhMoreInfo.Visible = true;

                // get existing invitations
                var invitations = qPtl_Invitation_View.GetInvitationsBySpaceID(space_id);
                string invitation_html = string.Empty;

                foreach (var i in invitations)
                {
                    string invite_html = "<tr>";

                    invite_html += "<td><font color=\"gray\">" + i.InvitationAudience + "</font></td>";
                    invite_html += "<td class=\"hidden-1024\">" + i.RoleName + "</td>";
                    invite_html += "<td class=\"hidden-480\">" + i.InviteCode + "</td>";
                    invite_html += "</tr>";

                    invitation_html += invite_html;
                }

                if (!String.IsNullOrEmpty(invitation_html))
                {
                    litInvitations.Text = invitation_html;
                    plhInvitations.Visible = true;
                }
                else
                    plhInvitations.Visible = false;
            }
            else
            {
                lblTitle.Text = "Create New Group";
                rblVisibleInDirectory.SelectedValue = "No";
                rblAvailableNew.Text = "Yes";
                plhMoreInfo.Visible = false;
                plhTools.Visible = false;
            }

        }
    }
    protected void btnSave_OnClick(object sender, System.EventArgs e)
    {
        Page.Validate("form");

        if (Page.IsValid)
        {
            int user_id = Convert.ToInt32(Context.Items["UserID"]);
            int space_id = 0;

            if (!String.IsNullOrEmpty(Request.QueryString["spaceID"]))
            {
                space_id = Convert.ToInt32(Request.QueryString["spaceID"]);
                qSoc_Space space = new qSoc_Space(space_id);
                space.LastModified = DateTime.Now;
                space.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                space.MarkAsDelete = 0;
                space.SpaceShortName = txtGroupNameNew.Text;
                space.SpaceType = ddlGroupTypeNew.SelectedValue;
                space.SpaceName = txtGroupNameNewFull.Text;
                space.AccessMode = ddlEnrollmentType.SelectedValue;
                space.VisibleInDirectory = rblVisibleInDirectory.SelectedValue;
                space.SpaceType = ddlGroupTypeNew.SelectedValue;
                if (!String.IsNullOrEmpty(ddlSchoolNew.SelectedValue))
                    space.SchoolID = Convert.ToInt32(ddlSchoolNew.SelectedValue);
                if (!String.IsNullOrEmpty(ddlSpaceCategoriesNew.SelectedValue))
                    space.SpaceCategoryID = Convert.ToInt32(ddlSpaceCategoriesNew.SelectedValue);
                space.Available = rblAvailableNew.SelectedValue;
                space.Update();

                space_id = space.SpaceID;
            }
            else
            {
                qSoc_Space space = new qSoc_Space();
                space.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                space.Created = DateTime.Now;
                space.CreatedBy = Convert.ToInt32(Context.Items["UserID"]);
                space.LastModified = DateTime.Now;
                space.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                space.MarkAsDelete = 0;
                space.SpaceShortName = txtGroupNameNew.Text;
                space.SpaceName = txtGroupNameNewFull.Text;
                space.SpaceType = ddlGroupTypeNew.SelectedValue;
                space.AccessMode = ddlEnrollmentType.SelectedValue;
                space.VisibleInDirectory = rblVisibleInDirectory.SelectedValue;
                space.SpaceType = ddlGroupTypeNew.SelectedValue;
                if (!String.IsNullOrEmpty(ddlSchoolNew.SelectedValue))
                    space.SchoolID = Convert.ToInt32(ddlSchoolNew.SelectedValue);
                if (!String.IsNullOrEmpty(ddlSpaceCategoriesNew.SelectedValue))
                    space.SpaceCategoryID = Convert.ToInt32(ddlSpaceCategoriesNew.SelectedValue);
                space.Available = rblAvailableNew.SelectedValue;
                space.Insert();

                space_id = space.SpaceID;
            }

            Response.Redirect("/manage/members/space-edit.aspx?spaceID=" + space_id);
        }
    }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        space_id = Convert.ToInt32(Request.QueryString["spaceID"]);
        qSoc_Space space = new qSoc_Space(space_id);
        space.Available = "No";
        space.MarkAsDelete = 1;
        space.VisibleInDirectory = "No";
        space.Update();

        // loop through all users and delete their space records
        var space_users = qSoc_UserSpace_View.GetSpaceUsers(space_id);

        if (space_users != null)
        {
            foreach (var u in space_users)
            {
                qSoc_UserSpace.DeleteUserSpace(u.UserID, u.SpaceID);
            }
        }

        Response.Redirect("~/manage/members/spaces-list.aspx");
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            // configure type pull down menu based on site preferences
            ddlInvitationAudience.Items.FindByValue("family").Enabled = false;
            ddlInvitationAudience.Items.FindByValue("new family").Enabled = false;
            ddlInvitationAudience.Items.FindByValue("group").Enabled = false;
            ddlInvitationAudience.Items.FindByValue("new group").Enabled = false;
            ddlInvitationAudience.Items.FindByValue("moderated group").Enabled = false;
            ddlInvitationAudience.Items.FindByValue("new moderated group").Enabled = false;
            ddlInvitationAudience.Items.FindByValue("individual").Enabled = false;
            string invitation_types = Convert.ToString(ConfigurationManager.AppSettings["Members_InvitationTypes"]);
            if (invitation_types.ToLower().Contains("family"))
            {
                ddlInvitationAudience.Items.FindByValue("family").Enabled = true;
                ddlInvitationAudience.Items.FindByValue("new family").Enabled = true;
            }
            if (invitation_types.ToLower().Contains("simple group"))
            {
                ddlInvitationAudience.Items.FindByValue("group").Enabled = true;
                ddlInvitationAudience.Items.FindByValue("new group").Enabled = true;
            }
            if (invitation_types.ToLower().Contains("moderated group"))
            {
                ddlInvitationAudience.Items.FindByValue("moderatedGroup").Enabled = true;
                plhSchools.Visible = true;
            }

            if (invitation_types.ToLower().Contains("individual"))
            {
                ddlInvitationAudience.Items.FindByValue("individual").Enabled = true;
            }

            if (!String.IsNullOrEmpty(Request.QueryString["invitationID"]))
            {
                ddlInvitationAudience.Items.FindByValue("individual").Enabled = true;
            }

            invitation_id = Convert.ToInt32(Request.QueryString["invitationID"]);
            string invite_audience = Convert.ToString(Request.QueryString["audience"]);

            qPtl_Invitation invite = new qPtl_Invitation(invitation_id);

            txtAudienceName.Text = invite.InvitationAudienceName;
            lblAudienceName.Text = invite.InvitationAudienceName;
            lblAudienceName.Visible = false;
            txtModeratedGroupNameShort.Text = invite.InvitationAudienceName;
            txtInvitationCode.Text = invite.InviteCode;
            rblAvailable.SelectedValue = invite.Available;
            ddlInvitationAudience.SelectedValue = invite.InvitationAudience;
            if (invite.MaxRedemptions > 0)
                txtMaxRedemptions.Text = Convert.ToString(invite.MaxRedemptions);
            else
                txtMaxRedemptions.Text = "";
            lblCurrRedemptions.Text = Convert.ToString(invite.CurrRedemptions);
            rdtStartTime.SelectedDate = invite.StartDate;
            rdtEndTime.SelectedDate = invite.EndDate;

            if (Convert.ToString(Request.QueryString["mode"]) == "add-successful")
            {
                lblMessage.Text = "*** Record Successfully Added ***";
            }

            // configure print link
            string baseURL = ConfigurationManager.AppSettings["returnURL"];
            string invitation_audience = Request.QueryString["audience"];
            string rawURL = string.Empty;

            plhNumRedemptions.Visible = true;
            plhCurrRedemptions.Visible = true;

            if (invitation_audience == "individual")
            {
                rawURL = baseURL + "/qDbs/print/print-individual-invitations.aspx?invitationID=" + Request.QueryString["invitationID"];
                lblTitle.Text = "Edit Individual Invitation (ID: " + invite.InvitationID + ")";
                ddlInvitationAudience.Items.FindByValue("family").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("new family").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("group").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("moderated group").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("").Enabled = false;
                lblAudience.Text = "Individual Name *";
                hplBackTop.NavigateUrl = "invitations-list-individuals.aspx";
                hplBackBottom.NavigateUrl = "invitations-list-individuals.aspx";
                plhExistingFamily.Visible = false;
                plhFamilyContactInfo.Visible = false;
                plhEditAudienceName.Visible = true;
            }
            else if (invitation_audience == "family")
            {
                plhSchools.Visible = false;
                populateFamilies();
                populateGroups();
                rawURL = baseURL + "/qDbs/print/print-family-invitations.aspx?invitationID=" + Request.QueryString["invitationID"];
                lblTitle.Text = "Edit Family Invitation (ID: " + invite.InvitationID + ")";
                // load family information
                qPtl_Family family = new qPtl_Family(invite.FamilyID);
                txtFirstName.Text = family.ContactFirstName;
                txtLastName.Text = family.ContactLastName;
                txtAddress1.Text = family.ContactAddress1;
                txtAddress2.Text = family.ContactAddress2;
                txtCity.Text = family.ContactCity;
                txtStateProvince.Text = family.ContactStateProvince;
                txtPostalCode.Text = family.ContactPostalCode;
                txtCountry.Text = family.ContactCountry;
                txtPhone1.Text = family.ContactPhone1;
                if (!String.IsNullOrEmpty(family.ContactPhone1Type))
                    ddlPhone1Type.SelectedValue = family.ContactPhone1Type;
                txtPhone2.Text = family.ContactPhone2;
                if (!String.IsNullOrEmpty(family.ContactPhone2Type))
                    ddlPhone2Type.SelectedValue = family.ContactPhone2Type;
                txtEmail.Text = family.ContactEmail;
                txtRelationship.Text = family.ContactRelationship;
                ddlInvitationAudience.Items.FindByValue("individual").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("group").Enabled = false;
                //ddlInvitationAudience.Items.FindByValue("new family").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("moderated group").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("").Enabled = false;
                plhExistingFamily.Visible = false;
                lblAudience.Text = "Family Name *";
                hplBackTop.NavigateUrl = "invitations-list-families.aspx";
                hplBackBottom.NavigateUrl = "invitations-list-families.aspx";
                hplBackTop.Text = "<i class=\"icon-circle-arrow-left\"></i>&nbsp;&nbsp;Back to Family Invitations";
                hplBackBottom.Text = "<i class=\"icon-circle-arrow-left\"></i>&nbsp;&nbsp;Back to Family Invitations";
            }
            else if (invitation_audience == "moderatedGroup")
            {
                populateSchools();
                rawURL = baseURL + "/qDbs/print/print-moderated-group-invitations.aspx?invitationID=" + Request.QueryString["invitationID"];
                lblTitle.Text = "Edit Moderated Group Invitation (ID: " + invite.InvitationID + ")";
                plhExistingFamily.Visible = false;
                plhFamilyContactInfo.Visible = false;
                plhModeratedGroupInfo.Visible = true;
                qPtl_Role invite_role = new qPtl_Role(invite.RoleID);
                lblInvitationForUserRole.Text = invite_role.RoleName;
                txtAudienceName.Visible = false;
                lblAudienceName.Visible = true;
                plhExistingGroup.Visible = false;
                plhEditAudienceName.Visible = false;
                plhCreateNewModeratedGroup.Visible = true;

                if (invite.SpaceID > 0)
                {
                    qSoc_Space space = new qSoc_Space(invite.SpaceID);
                    if (space.SchoolID > 0)
                    {
                        ddlSchools.SelectedValue = Convert.ToString(space.SchoolID);
                    }
                    txtModeratedGroupNameShort.Text = space.SpaceShortName;
                    txtModeratedGroupName.Text = space.SpaceName;
                    ddlGroupType.SelectedValue = space.SpaceType;
                }
                /*
                // load group information
                qPtl_Family family = new qPtl_Family(invite.FamilyID);
                txtFirstName.Text = family.ContactFirstName;
                txtLastName.Text = family.ContactLastName;
                txtAddress1.Text = family.ContactAddress1;
                txtAddress2.Text = family.ContactAddress2;
                txtCity.Text = family.ContactCity;
                txtStateProvince.Text = family.ContactStateProvince;
                txtPostalCode.Text = family.ContactPostalCode;
                txtCountry.Text = family.ContactCountry;
                txtPhone1.Text = family.ContactPhone1;
                if (!String.IsNullOrEmpty(family.ContactPhone1Type))
                    ddlPhone1Type.SelectedValue = family.ContactPhone1Type;
                txtPhone2.Text = family.ContactPhone2;
                if (!String.IsNullOrEmpty(family.ContactPhone2Type))
                    ddlPhone2Type.SelectedValue = family.ContactPhone2Type;
                txtEmail.Text = family.ContactEmail;
                txtRelationship.Text = family.ContactRelationship;
                    */
                ddlInvitationAudience.Items.FindByValue("individual").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("group").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("new family").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("family").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("new group").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("new moderated group").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("").Enabled = false;
                plhExistingFamily.Visible = false;
                lblAudience.Text = "Group Name *";
                hplBackTop.NavigateUrl = "invitations-list-moderated-groups.aspx";
                hplBackBottom.NavigateUrl = "invitations-list-moderated-groups.aspx";
            }
            else if (invitation_audience == "group")
            {
                rawURL = baseURL + "/qDbs/print/print-group-invitations.aspx?invitationID=" + Request.QueryString["invitationID"];
                lblTitle.Text = "Edit Group Invitation (ID: " + invite.InvitationID + ")";
                ddlInvitationAudience.Items.FindByValue("family").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("new family").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("individual").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("moderated group").Enabled = false;
                ddlInvitationAudience.Items.FindByValue("").Enabled = false;
                lblAudience.Text = "Group Name *";
                hplBackTop.NavigateUrl = "invitations-list-groups.aspx";
                hplBackBottom.NavigateUrl = "invitations-list-groups.aspx";
                plhExistingFamily.Visible = false;
                plhFamilyContactInfo.Visible = false;
                plhEditAudienceName.Visible = true;
            }

            //hplRefreshBottom.NavigateUrl = Request.Url.ToString();
            //hplRefreshTop.NavigateUrl = Request.Url.ToString();

            string passURL = Server.UrlEncode(rawURL);
            string timeStamp = Convert.ToString(DateTime.Now.Month) + "-" + Convert.ToString(DateTime.Now.Day) + "-" + Convert.ToString(DateTime.Now.Year);

            hplPrint.NavigateUrl = "~/qDbs/GeneratePDF.aspx?PageOrientation=landscape&htmlSource=" + passURL + "&mode=read&pdfOutput=" + invitation_audience + " invitation_id_" + invitation_id + "_" + timeStamp + ".pdf";
            hplPrint.Target = "_blank";

            plhInvitationCode.Visible = true;
            plhTools.Visible = true;
        }
        else
        {
            rblAvailable.SelectedValue = "Yes";
            if (!String.IsNullOrEmpty(Request.QueryString["audience"]))
                ddlInvitationAudience.SelectedValue = Convert.ToString(Request.QueryString["audience"]);
            plhInvitationCode.Visible = false;
            plhTools.Visible = false;
            plhCurrRedemptions.Visible = false;

            string invitation_audience = Request.QueryString["audience"];

            //hplRefreshBottom.NavigateUrl = Request.Url.ToString();
            //hplRefreshTop.NavigateUrl = Request.Url.ToString();
            if (invitation_audience == "individual")
            {
                lblTitle.Text = "New Invitation";
                hplBackTop.NavigateUrl = "invitations-list-individuals.aspx";
                hplBackBottom.NavigateUrl = "invitations-list-individuals.aspx";
                lblAudience.Text = "Individual Name *";
                plhCreateFamilyInvitationSettings.Visible = false;
                plhNumRedemptions.Visible = true;
                txtMaxRedemptions.Text = Convert.ToString(1);
                txtMaxRedemptions.Enabled = false;
                plhExistingFamily.Visible = false;
                plhFamilyContactInfo.Visible = false;
                plhEditAudienceName.Visible = true;
                ddlExistingGroups.Visible = false;
            }
            else if (invitation_audience == "family")
            {
                lblTitle.Text = "New Invitation";
                hplBackTop.NavigateUrl = "invitations-list-families.aspx";
                hplBackBottom.NavigateUrl = "invitations-list-families.aspx";
                lblAudience.Text = "Family Name *";
                plhCreateFamilyInvitationSettings.Visible = true;
                txtNumParents.Text = Convert.ToString(2);
                txtNumTeens.Text = Convert.ToString(1);
                plhNumRedemptions.Visible = false;
                populateFamilies();
                plhFamilyContactInfo.Visible = true;
                plhExistingFamily.Visible = false;
                ddlInvitationAudience.SelectedValue = "new family";
                ddlExistingGroups.Visible = false;
            }
            else if (invitation_audience == "group")
            {
                lblTitle.Text = "New Invitation";
                hplBackTop.NavigateUrl = "invitations-list-groups.aspx";
                hplBackBottom.NavigateUrl = "invitations-list-groups.aspx";
                lblAudience.Text = "Group Name *";
                plhCreateFamilyInvitationSettings.Visible = false;
                plhNumRedemptions.Visible = true;
                plhExistingFamily.Visible = false;
                plhFamilyContactInfo.Visible = false;
                plhEditAudienceName.Visible = true;
                ddlExistingGroups.Visible = false;
            }
            else if (invitation_audience == "moderatedGroup")
            {
                lblTitle.Text = "New Invitation";
                hplBackTop.NavigateUrl = "invitations-list-moderated-groups.aspx";
                hplBackBottom.NavigateUrl = "invitations-list-moderated-groups.aspx";
                lblAudience.Text = "Group Name *";
                plhCreateFamilyInvitationSettings.Visible = false;
                plhNumRedemptions.Visible = true;
                plhExistingFamily.Visible = false;
                plhFamilyContactInfo.Visible = false;
                plhEditAudienceName.Visible = true;
                ddlInvitationAudience.SelectedValue = "new moderated group";
                plhExistingGroup.Visible = false;
                plhCreateModeratedGroupInvitationSettings.Visible = true;
                lblMaxRedemptions.Text = "Max Number of Member Redemptions";
                plhCreateNewModeratedGroup.Visible = true;
                plhEditAudienceName.Visible = false;
            }
        }
    }
    protected void btnSave_OnClick(object sender, System.EventArgs e)
    {
        Page.Validate("form");

        if (Page.IsValid)
        {
            int user_id = Convert.ToInt32(Context.Items["UserID"]);

            if (!String.IsNullOrEmpty(Request.QueryString["invitationID"]))
            {
                invitation_id = Convert.ToInt32(Request.QueryString["invitationID"]);

                qPtl_Invitation invite = new qPtl_Invitation(invitation_id);
                invite.InvitationAudience = ddlInvitationAudience.SelectedValue;
                invite.InvitationAudienceName = txtAudienceName.Text;
                invite.Available = rblAvailable.SelectedValue;
                invite.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                invite.LastModified = DateTime.Now;
                if (!String.IsNullOrEmpty(Convert.ToString(rdtStartTime.SelectedDate)))
                    invite.StartDate = rdtStartTime.SelectedDate;
                if (!String.IsNullOrEmpty(Convert.ToString(rdtEndTime.SelectedDate)))
                    invite.EndDate = rdtEndTime.SelectedDate;

                if (!String.IsNullOrEmpty(ddlSchools.SelectedValue))
                {
                    if (invite.SpaceID > 0)
                    {
                        qSoc_Space space = new qSoc_Space(invite.SpaceID);
                        space.SchoolID = Convert.ToInt32(ddlSchools.SelectedValue);
                        space.Update();
                    }
                }

                invite.Update();
            }
            else
            {
                int functional_role_id = Convert.ToInt32(ConfigurationManager.AppSettings["register_InvitationFunctionalRoleID"]);
                int member_role_id = Convert.ToInt32(ConfigurationManager.AppSettings["register_DefaultRoleID"]);
                int parent_role_id = Convert.ToInt32(ConfigurationManager.AppSettings["register_ParentRoleID"]);
                int moderator_role_id = Convert.ToInt32(ConfigurationManager.AppSettings["register_ModeratorRoleID"]);
                string invitation_type = Convert.ToString(ConfigurationManager.AppSettings["register_InvitationType"]);
                int invite_length = Convert.ToInt32(ConfigurationManager.AppSettings["register_InvitationLength"]);

                DateTime start_time = new DateTime();
                DateTime end_time = new DateTime();

                start_time = Convert.ToDateTime(rdtStartTime.SelectedDate);
                end_time = Convert.ToDateTime(rdtEndTime.SelectedDate);

                if (ddlInvitationAudience.SelectedValue == "individual")
                {
                    var invite = qPtl_Invitation.GenerateInvite(0, start_time, end_time, Convert.ToInt32(Context.Items["UserID"]), 0, invite_length, invitation_type, member_role_id, functional_role_id);

                    invite.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                    invite.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                    invite.LastModified = DateTime.Now;
                    invite.MarkAsDelete = 0;
                    invite.InvitationAudience = ddlInvitationAudience.SelectedValue;
                    invite.InvitationAudienceName = txtAudienceName.Text;
                    invite.Available = rblAvailable.SelectedValue;
                    invite.InvitationStatus = "Redeemable";
                    invite.CurrRedemptions = 0;
                    invite.MaxRedemptions = 1;

                    invite.Update();
                    invitation_id = invite.InvitationID;
                }
                else if (ddlInvitationAudience.SelectedValue == "group")
                {
                    var invite = qPtl_Invitation.GenerateInvite(0, start_time, end_time, Convert.ToInt32(Context.Items["UserID"]), 0, invite_length, invitation_type, member_role_id, functional_role_id);

                    invite.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                    invite.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                    invite.LastModified = DateTime.Now;
                    invite.MarkAsDelete = 0;
                    invite.InvitationAudience = ddlInvitationAudience.SelectedValue;
                    invite.InvitationAudienceName = txtAudienceName.Text;
                    invite.Available = rblAvailable.SelectedValue;
                    invite.InvitationStatus = "Redeemable";
                    invite.CurrRedemptions = 0;
                    if (!String.IsNullOrEmpty(txtMaxRedemptions.Text))
                        invite.MaxRedemptions = Convert.ToInt32(txtMaxRedemptions.Text);

                    invite.Update();
                    invitation_id = invite.InvitationID;
                }
                else if (ddlInvitationAudience.SelectedValue == "family" || ddlInvitationAudience.SelectedValue == "new family")
                {
                    int family_id = 0;
                    string audience_name = string.Empty;

                    if (ddlInvitationAudience.SelectedValue == "new family")
                    {
                        // create family and add information
                        qPtl_Family family = new qPtl_Family();

                        family.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                        family.Available = rblAvailable.SelectedValue;
                        family.Created = DateTime.Now;
                        family.CreatedBy = Convert.ToInt32(Context.Items["UserID"]);
                        family.LastModified = DateTime.Now;
                        family.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                        family.MarkAsDelete = 0;
                        family.FamilyName = txtAudienceName.Text;
                        family.ContactFirstName = txtFirstName.Text;
                        family.ContactLastName = txtLastName.Text;
                        family.ContactAddress1 = txtAddress1.Text;
                        family.ContactAddress2 = txtAddress2.Text;
                        family.ContactCity = txtCity.Text;
                        family.ContactStateProvince = txtStateProvince.Text;
                        family.ContactPostalCode = txtPostalCode.Text;
                        family.ContactCountry = txtCountry.Text;
                        family.ContactPhone1 = txtPhone1.Text;
                        if (!String.IsNullOrEmpty(ddlPhone1Type.SelectedValue))
                            family.ContactPhone1Type = ddlPhone1Type.SelectedValue;
                        family.ContactPhone2 = txtPhone2.Text;
                        if (!String.IsNullOrEmpty(ddlPhone2Type.SelectedValue))
                            family.ContactPhone2Type = ddlPhone2Type.SelectedValue;
                        family.ContactEmail = txtEmail.Text;
                        family.ContactRelationship = txtRelationship.Text;

                        family.Insert();

                        family_id = family.FamilyID;
                        audience_name = txtAudienceName.Text;
                    }
                }
                else if (ddlInvitationAudience.SelectedValue == "moderated group" || ddlInvitationAudience.SelectedValue == "new moderated group")
                {
                    int space_id = 0;
                    string group_audience_name = string.Empty;

                    if (ddlInvitationAudience.SelectedValue == "new moderated group" || ddlInvitationAudience.SelectedValue == "moderatedGroup")
                    {
                        // create space
                        qSoc_Space space = new qSoc_Space();
                        space.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                        space.Available = rblAvailable.SelectedValue;
                        space.Created = DateTime.Now;
                        space.CreatedBy = Convert.ToInt32(Context.Items["UserID"]);
                        space.LastModified = DateTime.Now;
                        space.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                        space.MarkAsDelete = 0;
                        space.SpaceShortName = txtModeratedGroupNameShort.Text;
                        space.SpaceName = txtModeratedGroupName.Text;
                        space.AccessMode = "invitation";
                        space.VisibleInDirectory = "No";
                        space.SpaceType = ddlGroupType.SelectedValue;
                        if (!String.IsNullOrEmpty(ddlSchools.SelectedValue))
                        {
                            space.SchoolID = Convert.ToInt32(ddlSchools.SelectedValue);
                        }
                        space.Insert();

                        space_id = space.SpaceID;
                        group_audience_name = txtModeratedGroupName.Text;
                    }
                    else
                    {
                        space_id = Convert.ToInt32(ddlExistingGroups.SelectedValue);
                        qSoc_Space space = new qSoc_Space(space_id);
                        group_audience_name = space.SpaceShortName;
                    }

                    // create necessary invitations -- moderators
                    int num_moderators = Convert.ToInt32(txtNumGroupModerators.Text);
                    for (int i = 0; i < num_moderators; i++)
                    {
                        var invite = qPtl_Invitation.GenerateInvite(0, start_time, end_time, Convert.ToInt32(Context.Items["UserID"]), 0, invite_length, invitation_type, moderator_role_id, functional_role_id);
                        invite.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                        invite.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                        invite.LastModified = DateTime.Now;
                        invite.MarkAsDelete = 0;
                        invite.InvitationAudience = "moderated group";
                        invite.InvitationAudienceName = group_audience_name;
                        invite.Available = rblAvailable.SelectedValue;
                        invite.InvitationStatus = "Redeemable";
                        invite.CurrRedemptions = 0;
                        invite.MaxRedemptions = 1;
                        invite.SpaceID = space_id;
                        invite.Update();
                    }

                    // create single teen invitation
                    var invite_t = qPtl_Invitation.GenerateInvite(0, start_time, end_time, Convert.ToInt32(Context.Items["UserID"]), 0, invite_length, invitation_type, member_role_id, functional_role_id);
                    invite_t.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
                    invite_t.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
                    invite_t.LastModified = DateTime.Now;
                    invite_t.MarkAsDelete = 0;
                    invite_t.InvitationAudience = "moderated group";
                    invite_t.InvitationAudienceName = group_audience_name;
                    invite_t.Available = rblAvailable.SelectedValue;
                    invite_t.InvitationStatus = "Redeemable";
                    invite_t.CurrRedemptions = 0;
                    if (!String.IsNullOrEmpty(txtNumTeens.Text))
                        invite_t.MaxRedemptions = Convert.ToInt32(txtNumTeens.Text);
                    else
                        invite_t.MaxRedemptions = -1;
                    invite_t.SpaceID = space_id;
                    invite_t.Update();
                    invitation_id = invite_t.InvitationID;

                    qSoc_Space existing_space = new qSoc_Space(space_id);
                    existing_space.SpaceCode = invite_t.InviteCode;
                    existing_space.Update();
                }
            }

            if (!String.IsNullOrEmpty(Request.QueryString["invitationID"]))
            {
                lblMessage.Text = "*** Record Successfully Updated ***";
                lblMessageBottom.Text = "*** Record Successfully Updated ***";
                plhInvitationCode.Visible = true;
            }
            else
            {
                Response.Redirect(Request.Url.ToString() + "&mode=add-successful&invitationID=" + invitation_id);
            }
        }
    }
    protected void loadPageInfo(int space_id)
    {
        qSoc_Space space = new qSoc_Space(space_id);

        //litDashboardImage.Text = "<h3>" + space.SpaceShortName  + "</h3><img src=\"" + resources_url + "/spaces/" + space_id + "/reports/report.png\">";
    }