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 = " <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 = " <strong>***ERROR***</strong> This member does not exist; please enter another username"; } } else lblMessageMember.Text = " <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; } }
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> " + 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> " + 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> Back to Family Invitations"; hplBackBottom.Text = "<i class=\"icon-circle-arrow-left\"></i> 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); } } }