protected void btnSave_Click(object sender, EventArgs e) { Response.Write("just clicked"); string sqlQuery = string.Empty; if (Request.QueryString["sendEventID"] != null && Request.QueryString["sendEventID"] != "") { sqlQuery = "UPDATE qCom_SendEvents SET [SearchID] = " + ddlSearches.SelectedValue + ", [EmailID] = " + ddlEmails.SelectedValue + ", [StartDate] = '" + datStart.SelectedDate + "',[Recurring] = '" + rblRecurring.SelectedItem + "',[Running] = '" + rblRunning.SelectedItem + "',[IncludeHeader] = '" + rblHeader.SelectedItem + "',[IncludeFooter] = '" + rblFooter.SelectedItem + "',[IncludeUnsubscribe] = '" + rblUnsubscribe.SelectedItem + "' WHERE SendEventID = " + Request.QueryString["sendEventID"]; } else { sqlQuery = "INSERT qCom_SendEvents ([ScopeID],[SearchID],[EmailID],[StartDate],[Recurring],[Running],[IncludeHeader],[IncludeFooter],[IncludeUnsubscribe]) VALUES (" + Context.Items["ScopeID"] + "," + ddlSearches.SelectedValue + " , " + ddlEmails.SelectedValue + " ,'" + datStart.SelectedDate + "','" + rblRecurring.SelectedItem + "','" + rblRunning.SelectedItem + "','" + rblHeader.SelectedItem + "','" + rblFooter.SelectedItem + "','" + rblUnsubscribe.SelectedItem + "')"; } //Response.Write("sql code = " + sqlQuery); qDbs_SQLcode sql = new qDbs_SQLcode(); sql.ExecuteSQL(sqlQuery); Response.Redirect("send-event-list.aspx"); }
protected void btnSave_OnClick(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { // step 1: create account using registration model (single user role) int curr_default_role_id = Convert.ToInt32(ddlUserRoles.SelectedValue); RegistrationData data = new RegistrationData(); data.scope_id = 1; data.invite_code = ""; data.space_code = ""; data.campaign_code = ""; data.mobile_number = ""; data.email = txtEmail.Text; data.username = txtUserName.Text; data.password = ""; data.firstname = txtFirstName.Text; data.lastname = txtLastName.Text; data.degrees = ""; data.position = ""; data.agency = ""; data.division = ""; data.address = ""; data.address2 = ""; data.city = ""; data.state = ""; data.postal_code = ""; data.work_phone = ""; data.first_event = ""; data.dob = ""; data.gender = ""; data.ethnicity = ""; data.race = ""; data.profession = ""; data.employment_setting = ""; data.employment_location = ""; data.employment_sites = ""; data.registration_type = "manager"; data.registration_notes = ""; data.default_role_id = curr_default_role_id; data.browser = ""; data.platform = ""; qPtl_User user = new qPtl_User(); user = UserFunctions.RegisterNewUser(data); user.RegistrationNotes = txtRegistrationNotes.Text; user.RegistrationType = ddlRegistrationTypes.SelectedValue; user.Update(); // process functional roles if (plhFunctionalRoles.Visible == true) { string sqlCode = string.Empty; string returnMessage = string.Empty; qDbs_SQLcode sql = new qDbs_SQLcode(); // first delete all existing roles sqlCode = "DELETE FROM qLrn_UserFunctionalRoles WHERE UserID = " + user.UserID; sql.ExecuteSQL(sqlCode); // create records for all new roles int n; string selectedItems = string.Empty; n = 0; foreach (ListItem item in cblFunctionalRoles.Items) { if (item.Selected) { sqlCode = "INSERT INTO qLrn_UserFunctionalRoles (UserID, FunctionalRoleID)"; sqlCode += " VALUES (" + user.UserID + "," + item.Value + ")"; sql.ExecuteSQL(sqlCode); if (n > 0) { selectedItems += "," + item.Value; } else { selectedItems += item.Value; } n++; } } int daysBetweenTrainings = 0; if (!String.IsNullOrEmpty(System.Configuration.ConfigurationManager.AppSettings["Learning_DaysBetweenTrainings"])) daysBetweenTrainings = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["Learning_DaysBetweenTrainings"]); int daysTillUnavailable = 5000; DateTime seedDate = DateTime.Now; string trainingMode = "open"; string surveyRequired = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["Learning_SurveyRequired"]); qLrn_UserTraining.manageUserTrainings(user.UserID, daysBetweenTrainings, daysTillUnavailable, trainingMode, "add", 0, seedDate, surveyRequired); // redirect to new user tools page Response.Redirect("member-profile.aspx?userID=" + user.UserID); } } }
public static string ProcessWorkflow(Int32 workflow_id, Int32 userID) { qDbs_SQLcode sql = new qDbs_SQLcode(); qPtl_Workflow c_workflow = new qPtl_Workflow(workflow_id); string returnMessage = string.Empty; if (c_workflow.WorkflowActionType == "sql") { // get sql and then replace the parameters string finalSql = c_workflow.SQL; // replace values finalSql = finalSql.Replace("{UserID}", Convert.ToString(userID)); if (c_workflow.ReferenceID > 0) finalSql = finalSql.Replace("{ReferenceID}", Convert.ToString(c_workflow.ReferenceID)); if (c_workflow.WorkflowActionReferenceID > 0) finalSql = finalSql.Replace("{WorkflowActionReferenceID}", Convert.ToString(c_workflow.WorkflowActionReferenceID)); returnMessage = sql.ExecuteSQL(finalSql); } return returnMessage; }
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["pollID"])) { poll_id = Convert.ToInt32(Request.QueryString["pollID"]); qSoc_Poll2 poll = new qSoc_Poll2(poll_id); poll.Question = txtQuestion.Text; poll.LastModified = DateTime.Now; poll.LastModifiedBy = user_id; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) poll.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); else poll.ThemeID = 0; DateTime start_time = new DateTime(); DateTime end_time = new DateTime(); if (rblAvailable.SelectedValue == "Yes") { poll.Available = "Yes"; start_time = DateTime.Now; end_time = DateTime.Now.AddYears(10); poll.StartDate = start_time; poll.EndDate = end_time; /* // code no longer used since use defaults for setting these values if (!String.IsNullOrEmpty(Convert.ToString(rdtStartTime.SelectedDate))) poll.StartDate = Convert.ToDateTime(rdtStartTime.SelectedDate); if (!String.IsNullOrEmpty(Convert.ToString(rdtEndTime.SelectedDate))) poll.EndDate = Convert.ToDateTime(rdtEndTime.SelectedDate); */ } else { poll.Available = "No"; start_time = DateTime.Now.AddDays(-2); end_time = DateTime.Now.AddDays(-1); poll.StartDate = start_time; poll.EndDate = end_time; /* // code no longer used since use defaults for setting these values if (!String.IsNullOrEmpty(Convert.ToString(rdtStartTime.SelectedDate))) poll.StartDate = null; if (!String.IsNullOrEmpty(Convert.ToString(rdtEndTime.SelectedDate))) poll.EndDate = null; */ } poll.Update(); } else { qSoc_Poll2 poll = new qSoc_Poll2(); poll.ScopeID = 1; poll.Created = DateTime.Now; poll.CreatedBy = user_id; poll.LastModified = DateTime.Now; poll.LastModifiedBy = user_id; poll.Available = "Yes"; poll.MarkAsDelete = 0; poll.Question = txtQuestion.Text; if (ddlPollType.SelectedValue == "Think") { poll.PollType = "Opinion"; poll.ExperienceType = "Think"; } else if (ddlPollType.SelectedValue == "Fact") { poll.PollType = "Fact"; poll.ExperienceType = "Poll"; } else if (ddlPollType.SelectedValue == "Opinion") { poll.PollType = "Opinion"; poll.ExperienceType = "Poll"; } poll.Available = "No"; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) poll.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); // default to start time is today and end time is 20 years from now poll.StartDate = DateTime.Now; poll.EndDate = DateTime.Now.AddYears(20); poll.Insert(); /* if (!String.IsNullOrEmpty(Convert.ToString(rdtStartTime.SelectedDate))) poll.StartDate = Convert.ToDateTime(rdtStartTime.SelectedDate); if (!String.IsNullOrEmpty(Convert.ToString(rdtEndTime.SelectedDate))) poll.EndDate = Convert.ToDateTime(rdtEndTime.SelectedDate); */ poll_id = poll.PollID; if (ddlPollType.SelectedValue == "Think") { int curr_choice_id = createNewChoice(poll_id, "Agree", false); curr_choice_id = createNewChoice(poll_id, "Disagree", false); } } // process if highlighted poll qDbs_SQLcode sql = new qDbs_SQLcode(); string sqlCode = string.Empty; sqlCode = "UPDATE qSoc_Polls SET Highlighted = null"; if (lblHighlightedMessage.Text.Contains("current") && chkHighlightedPoll.Checked == false) { sql.ExecuteSQL(sqlCode); // // clear all highlighted options } else if (chkHighlightedPoll.Checked && lblHighlightedMessage.Text.Contains("current")) { sql.ExecuteSQL(sqlCode); // clear all highlighted options qSoc_Poll2 poll = new qSoc_Poll2(poll_id); poll.Highlighted = true; poll.Update(); } else if (chkHighlightedPoll.Checked && lblHighlightedMessage.Text.Contains("Check")) { sql.ExecuteSQL(sqlCode); // clear all highlighted options qSoc_Poll2 poll = new qSoc_Poll2(poll_id); poll.Highlighted = true; poll.Update(); } // add keywords string owner_keywords = string.Empty; qPtl_KeywordReference.DeleteKeywordReferencesByContent((int)qSoc_ContentType.Types.Poll, poll_id); foreach (ListItem item in cblKeywords.Items) { if (item.Selected) { if (!String.IsNullOrEmpty(owner_keywords)) owner_keywords += "," + item.Text; else owner_keywords += item.Text; qPtl_KeywordReference keyword = new qPtl_KeywordReference(); keyword.Available = "Yes"; keyword.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]); keyword.KeywordID = Convert.ToInt32(item.Value); keyword.ContentTypeID = (int)qSoc_ContentType.Types.Poll; keyword.ReferenceID = poll_id; keyword.Created = DateTime.Now; keyword.LastModified = DateTime.Now; keyword.CreatedBy = Convert.ToInt32(Context.Items["UserID"]); keyword.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]); keyword.MarkAsDelete = 0; keyword.Insert(); } } string reserved_keywords = string.Empty; foreach (ListItem item in chkTopics.Items) { if (item.Selected) { if (!String.IsNullOrEmpty(reserved_keywords)) reserved_keywords += "," + item.Text; else reserved_keywords += item.Text; } } qSoc_Feed feed = new qSoc_Feed((int)qSoc_ContentType.Types.Poll, poll_id); if (!chkDisplayInFeed.Checked && !chkDisplayInExplore.Checked) { if (feed != null) { if (feed.FeedID > 0) { feed.MarkAsDelete = 1; feed.Available = "No"; feed.ReservedKeywords = reserved_keywords; if (!chkDisplayInFeed.Checked) feed.VisibleFeed = false; if (!chkDisplayInExplore.Checked) feed.VisibleExplore = false; feed.Update(); } } } else if (chkDisplayInFeed.Checked || chkDisplayInExplore.Checked || !string.IsNullOrEmpty(reserved_keywords)) { qSoc_Poll2 poll = new qSoc_Poll2(poll_id); int p_user_id = user_id; if (post_as_user_id > 0) p_user_id = post_as_user_id; qPtl_User user = new qPtl_User(p_user_id); var u_space = qSoc_UserSpace_View.GetUserSpaces(poll.CreatedBy); // evaluate title and description string p_title = q_Helper.replaceSpecialCharacters(poll.Question); string p_description = string.Empty; // add choices to description field var choices = qSoc_PollChoice2.GetAvailablePollChoices(poll_id); string choices_html = string.Empty; int i = 1; if (choices != null) { foreach (var c in choices) { if (!String.IsNullOrEmpty(choices_html)) choices_html += "<br>"; choices_html += i + ") " + c.Choice; i++; } } if (!String.IsNullOrEmpty(choices_html)) { p_description = choices_html; } if (feed != null) { if (feed.FeedID > 0) { feed.CreatedBy = user.UserID; feed.Available = poll.Available; if (chkMoveToTop.Checked) feed.LastModified = DateTime.Now; feed.LastModifiedBy = user.UserID; feed.MarkAsDelete = poll.MarkAsDelete; feed.OwnerMarkAsDelete = poll.MarkAsDelete; feed.ContentTypeID = (int)qSoc_ContentType.Types.Poll; feed.ReferenceID = poll_id; feed.OwnerID = user.UserID; feed.OwnerName = user.UserName; feed.OwnerProfilePic = user.ProfilePict; feed.Type = "poll"; feed.Title = p_title; feed.Description = p_description; feed.Body = p_description; feed.OwnerRole = user.HighestRole; feed.OwnerRoleID = user.HighestRank; feed.OwnerKeywords = owner_keywords; feed.ReservedKeywords = reserved_keywords; feed.UploadedFrom = "manager"; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) { feed.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); feed.ThemeName = Convert.ToString(ddlTheme.SelectedItem); } if (chkDisplayInFeed.Checked) feed.VisibleFeed = true; else feed.VisibleFeed = false; if (chkDisplayInExplore.Checked) feed.VisibleExplore = true; else feed.VisibleExplore = false; feed.Update(); } else { // create new feed item if (u_space != null) { foreach (var s in u_space) { feed.SpaceID = s.SpaceID; feed.SpaceName = s.SpaceShortName; } } feed.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]); feed.Available = poll.Available; feed.Created = DateTime.Now; feed.CreatedBy = user.UserID; feed.LastModified = DateTime.Now; feed.LastModifiedBy = user.UserID; feed.MarkAsDelete = poll.MarkAsDelete; feed.OwnerMarkAsDelete = poll.MarkAsDelete; feed.ContentTypeID = (int)qSoc_ContentType.Types.Poll; feed.ReferenceID = poll_id; feed.OwnerID = user.UserID; feed.OwnerName = user.UserName; feed.OwnerProfilePic = user.ProfilePict; feed.Type = "poll"; feed.Title = p_title; feed.Description = p_description; feed.Body = p_description; feed.OwnerRole = user.HighestRole; feed.OwnerRoleID = user.HighestRank; feed.VisibleAll = true; feed.VisibleFriends = true; feed.VisibleFollowers = true; feed.VisibleSpace = true; feed.VisiblePrivate = true; feed.VisibleFeed = true; feed.VisibleOwnerFeed = true; feed.VisibleOwnerProfile = true; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) { feed.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); feed.ThemeName = Convert.ToString(ddlTheme.SelectedItem); } feed.ReservedKeywords = reserved_keywords; if (!String.IsNullOrEmpty(owner_keywords)) { feed.OwnerKeywords = owner_keywords; } feed.UploadedFrom = "manager"; if (chkDisplayInFeed.Checked) feed.VisibleFeed = true; else feed.VisibleFeed = false; if (chkDisplayInExplore.Checked) feed.VisibleExplore = true; else feed.VisibleExplore = false; feed.Insert(); } } } // redirect to page to add poll + keywords if (!String.IsNullOrEmpty(Request.QueryString["pollID"])) { Response.Redirect("poll-edit.aspx?pollID=" + poll_id); } else { Response.Redirect(Request.Url.ToString() + "?mode=add-successful&pollID=" + poll_id); } } else { lblMessage.Text = "*** A problem has occurred -- make sure all the required information has been entered ***"; lblMessageBottom.Text = "*** A problem has occurred -- make sure all the required information has been entered ***"; } }
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 btnSave_Click(object sender, EventArgs e) { // first delete all existing roles int user_id = Convert.ToInt32(Request.QueryString["userID"]); string sqlCode = "DELETE FROM qPtl_UserRoles WHERE UserID = " + user_id; qDbs_SQLcode sql = new qDbs_SQLcode(); sql.ExecuteSQL(sqlCode); // delete from usermember group -- > cms permissions //qPtl_UserGroupMembers.DeleteUserGroupMember(user_id); // create records for all new roles int n; string selectedItems = string.Empty; n = 0; foreach (ListItem item in cblRoles.Items) { if (item.Selected) { sqlCode = "INSERT INTO qPtl_UserRoles (UserID, RoleID)"; sqlCode += " VALUES (" + Request.QueryString["userID"] + "," + item.Value + ")"; sql.ExecuteSQL(sqlCode); if (n > 0) { selectedItems += "," + item.Value; } else { selectedItems += item.Value; } n++; } } Response.Redirect("/manage/members/member-profile.aspx?userID=" + user_id + "&currTab=permissions&message=successfully updated"); }
protected void btnSave_OnClick(object sender, System.EventArgs e) { Page.Validate("form"); if (Page.IsValid) { int user_id = Convert.ToInt32(Context.Items["UserID"]); video_id = Convert.ToInt32(Request.QueryString["videoID"]); string user_name = (new qPtl_User(user_id)).UserName; qSoc_Video video = new qSoc_Video(video_id); video.Title = txtTitle.Text; video.Description = txtDescription.Text; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) video.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); video.Status = "Approved"; video.Created = video.Created; video.CreatedBy = video.CreatedBy; video.Approved = DateTime.Now; video.Source = lblVideoType.Text; video.LastModified = DateTime.Now; video.LastModifiedBy = user_id; video.Length = video.Length; video.EmbedCode = txtEmbed.Text; if (txtPreviewImage.Visible == true) video.ThumbnailURL = txtPreviewImage.Text; video.SourceVideoID = txtSourceVideoID.Text; if (!String.IsNullOrEmpty(ddlExternalSource.SelectedValue)) video.ExternalSourceName = ddlExternalSource.SelectedValue; string author = string.Empty; author = ddlAuthor.SelectedValue; if (!String.IsNullOrEmpty(author)) video.AuthorID = Convert.ToInt32(ddlAuthor.SelectedValue); video.Available = rblAvailable.SelectedValue; // process if highlighted video qDbs_SQLcode sql = new qDbs_SQLcode(); string sqlCode = string.Empty; sqlCode = "UPDATE qSoc_Videos SET HighlightedWF = null"; qSoc_HighlightedVideo.Delete(video_id); if (lblHighlightedMessage.Text.Contains("current") && chkHighlightedVideo.Checked == false) { sql.ExecuteSQL(sqlCode); video.HighlightedWF = null; } else if (chkHighlightedVideo.Checked && lblHighlightedMessage.Text.Contains("current")) { sql.ExecuteSQL(sqlCode); qSoc_HighlightedVideo high_video = new qSoc_HighlightedVideo(); high_video = qSoc_HighlightedVideo.GetLatest(); high_video.Available = "No"; high_video.Created = DateTime.Now; high_video.CreatedBy = user_id; high_video.LastModified = DateTime.Now; high_video.LastModifiedBy = user_id; high_video.MarkAsDelete = 1; high_video.Status = "Hidden"; high_video.Update(); } else if (chkHighlightedVideo.Checked && lblHighlightedMessage.Text.Contains("Check")) { sql.ExecuteSQL(sqlCode); qSoc_HighlightedVideo new_highlighted = new qSoc_HighlightedVideo(); new_highlighted.VideoID = video_id; new_highlighted.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]); new_highlighted.Available = "Yes"; new_highlighted.Created = DateTime.Now; new_highlighted.CreatedBy = user_id; new_highlighted.LastModified = DateTime.Now; new_highlighted.LastModifiedBy = user_id; new_highlighted.MarkAsDelete = 0; new_highlighted.Status = "Visible"; new_highlighted.Insert(); video.HighlightedWF = "Yes"; } video.Update(); // add keywords string owner_keywords = string.Empty; qPtl_KeywordReference.DeleteKeywordReferencesByContent((int)qSoc_ContentType.Types.Video, video_id); foreach (ListItem item in cblKeywords.Items) { if (item.Selected) { if (!String.IsNullOrEmpty(owner_keywords)) owner_keywords += "," + item.Text; else owner_keywords += item.Text; qPtl_KeywordReference keyword = new qPtl_KeywordReference(); keyword.Available = "Yes"; keyword.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]); keyword.KeywordID = Convert.ToInt32(item.Value); keyword.ContentTypeID = (int)qSoc_ContentType.Types.Video; keyword.ReferenceID = video_id; keyword.Created = DateTime.Now; keyword.LastModified = DateTime.Now; keyword.CreatedBy = Convert.ToInt32(Context.Items["UserID"]); keyword.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]); keyword.MarkAsDelete = 0; keyword.Insert(); } } string reserved_keywords = string.Empty; foreach (ListItem item in chkTopics.Items) { if (item.Selected) { if (!String.IsNullOrEmpty(reserved_keywords)) reserved_keywords += "," + item.Text; else reserved_keywords += item.Text; } } qSoc_Feed feed = new qSoc_Feed((int)qSoc_ContentType.Types.Video, video.VideoID); if (!chkDisplayInFeed.Checked && !chkDisplayInExplore.Checked) { if (feed != null) { if (feed.FeedID > 0) { feed.MarkAsDelete = 1; feed.Available = "No"; feed.ReservedKeywords = reserved_keywords; if (!chkDisplayInFeed.Checked) feed.VisibleFeed = false; if (!chkDisplayInExplore.Checked) feed.VisibleExplore = false; feed.Update(); } } } else if (chkDisplayInFeed.Checked || chkDisplayInExplore.Checked || !string.IsNullOrEmpty(reserved_keywords)) { int p_user_id = user_id; if (post_as_user_id > 0) p_user_id = post_as_user_id; qPtl_User user = new qPtl_User(p_user_id); var u_space = qSoc_UserSpace_View.GetUserSpaces(video.CreatedBy); if (feed != null) { if (feed.FeedID > 0) { feed.Available = video.Available; feed.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]); feed.CreatedBy = user.UserID; if (chkMoveToTop.Checked) feed.LastModified = DateTime.Now; feed.LastModified = video.LastModified; feed.LastModifiedBy = user.UserID; feed.MarkAsDelete = video.MarkAsDelete; feed.OwnerMarkAsDelete = video.MarkAsDelete; feed.ContentTypeID = (int)qSoc_ContentType.Types.Video; feed.ReferenceID = video.VideoID; feed.OwnerID = user.UserID; feed.OwnerName = user.UserName; feed.OwnerProfilePic = user.ProfilePict; feed.Type = "video"; feed.Title = video.Title; feed.Description = video.Description; feed.OwnerRole = user.HighestRole; feed.OwnerRoleID = user.HighestRank; feed.OwnerKeywords = owner_keywords; feed.UploadedFrom = "manager"; feed.ReservedKeywords = reserved_keywords; feed.Thumbnail = video.ThumbnailURL; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) { feed.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); feed.ThemeName = Convert.ToString(ddlTheme.SelectedItem); } if (video.Source == "internal") { feed.VideoKey = video.ViddlerID; } else { string embed_code = Convert.ToString(video.EmbedCode); feed.Embed = embed_code; feed.VideoKey = null; } if (chkDisplayInFeed.Checked) feed.VisibleFeed = true; else feed.VisibleFeed = false; if (chkDisplayInExplore.Checked) feed.VisibleExplore = true; else feed.VisibleExplore = false; feed.Update(); } else { // create new feed item if (u_space != null) { foreach (var s in u_space) { feed.SpaceID = s.SpaceID; feed.SpaceName = s.SpaceShortName; } } feed.Available = video.Available; feed.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]); feed.Created = DateTime.Now; //video.Created; feed.CreatedBy = user.UserID; feed.LastModified = DateTime.Now; feed.LastModifiedBy = user.UserID; feed.MarkAsDelete = video.MarkAsDelete; feed.OwnerMarkAsDelete = video.MarkAsDelete; feed.ContentTypeID = (int)qSoc_ContentType.Types.Video; feed.ReferenceID = video.VideoID; feed.OwnerID = user.UserID; feed.OwnerName = user.UserName; feed.OwnerProfilePic = user.ProfilePict; feed.Type = "video"; feed.Title = video.Title; feed.Description = video.Description; feed.OwnerRole = user.HighestRole; feed.OwnerRoleID = user.HighestRank; feed.OwnerKeywords = owner_keywords; feed.UploadedFrom = "manager"; feed.ReservedKeywords = reserved_keywords; feed.Thumbnail = video.ThumbnailURL; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) { feed.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); feed.ThemeName = Convert.ToString(ddlTheme.SelectedItem); } if (video.Source == "internal") { feed.VideoKey = video.ViddlerID; } else { string embed_code = Convert.ToString(video.EmbedCode); feed.Embed = embed_code; } feed.VisibleAll = true; feed.VisibleFriends = true; feed.VisibleFollowers = true; feed.VisibleSpace = true; feed.VisiblePrivate = true; feed.VisibleFeed = true; feed.VisibleOwnerFeed = true; feed.VisibleOwnerProfile = true; if (!String.IsNullOrEmpty(owner_keywords)) { feed.OwnerKeywords = owner_keywords; } if (chkDisplayInFeed.Checked) feed.VisibleFeed = true; else feed.VisibleFeed = false; if (chkDisplayInExplore.Checked) feed.VisibleExplore = true; else feed.VisibleExplore = false; feed.Insert(); } } } // see if there is a pending task for this video if (video.Status == "Approved") { qPtl_Task task = new qPtl_Task((int)qSoc_ContentType.Types.Video, video_id); if (task != null) { if (task.TaskID > 0) { task.PercentCompleted = 100; task.Status = "Completed"; task.Update(); } } } // redirect to page to add theme + keywords // Response.Redirect("~/qSoc/videos-list.aspx"); lblMessage.Text = "*** Record Successfully Updated ***"; lblMessageBottom.Text = "*** Record Successfully Updated ***"; } }
protected void btnSave_OnClick(object sender, System.EventArgs e) { int user_id = Convert.ToInt32(Context.Items["UserID"]); if (!String.IsNullOrEmpty(Request.QueryString["BlogID"])) { blog_id = Convert.ToInt32(Request.QueryString["BlogID"]); qSoc_Blog2 blog = new qSoc_Blog2(blog_id); blog.Title = txtTitle.Text; blog.Summary = txtSummary.Text; blog.Text = reContent.Content; blog.LastModified = DateTime.Now; blog.LastModifiedBy = user_id; if (!String.IsNullOrEmpty(ddlAuthor.SelectedValue)) blog.AuthorID = Convert.ToInt32(ddlAuthor.SelectedValue); if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) blog.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); blog.Available = rblAvailable.SelectedValue; blog.Type = rblType.SelectedValue; blog.ApprovedStatus = ddlStatus.SelectedValue; if (ddlStatus.SelectedValue == "Approved") { blog.ApprovedBy = user_id; blog.Approved = DateTime.Now; } blog.Update(); } else { qSoc_Blog2 blog = new qSoc_Blog2(); blog.ScopeID = 1; blog.Created = DateTime.Now; blog.CreatedBy = user_id; blog.LastModified = DateTime.Now; blog.LastModifiedBy = user_id; blog.Available = "Yes"; blog.MarkAsDelete = 0; blog.UserID = user_id; blog.Title = txtTitle.Text; blog.Summary = txtSummary.Text; blog.Text = reContent.Content; blog.LastModified = DateTime.Now; blog.LastModifiedBy = user_id; if (!String.IsNullOrEmpty(ddlAuthor.SelectedValue)) blog.AuthorID = Convert.ToInt32(ddlAuthor.SelectedValue); if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) blog.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); blog.Available = rblAvailable.SelectedValue; blog.Type = rblType.SelectedValue; blog.ApprovedStatus = ddlStatus.SelectedValue; if (ddlStatus.SelectedValue == "Approved") { blog.ApprovedBy = user_id; blog.Approved = DateTime.Now; } blog.UploadedFrom = "manager"; blog.Insert(); blog_id = blog.BlogID; } string user_name = (new qPtl_User(user_id)).UserName; // add keywords string owner_keywords = string.Empty; qPtl_KeywordReference.DeleteKeywordReferencesByContent((int)qSoc_ContentType.Types.Story, blog_id); foreach (ListItem item in cblKeywords.Items) { if (item.Selected) { if (!String.IsNullOrEmpty(owner_keywords)) owner_keywords += "," + item.Text; else owner_keywords += item.Text; qPtl_KeywordReference keyword = new qPtl_KeywordReference(); keyword.Available = "Yes"; keyword.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]); keyword.KeywordID = Convert.ToInt32(item.Value); keyword.ContentTypeID = (int)qSoc_ContentType.Types.Story; keyword.ReferenceID = blog_id; keyword.Created = DateTime.Now; keyword.LastModified = DateTime.Now; keyword.CreatedBy = Convert.ToInt32(Context.Items["UserID"]); keyword.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]); keyword.MarkAsDelete = 0; keyword.Insert(); } } string reserved_keywords = string.Empty; foreach (ListItem item in chkTopics.Items) { if (item.Selected) { if (!String.IsNullOrEmpty(reserved_keywords)) reserved_keywords += "," + item.Text; else reserved_keywords += item.Text; } } // process if highlighted blog qDbs_SQLcode sql = new qDbs_SQLcode(); string sqlCode = string.Empty; sqlCode = "UPDATE qSoc_Blogs SET Highlighted = null"; if (lblHighlightedMessage.Text.Contains("current") && chkHighlightedItem.Checked == false) { sql.ExecuteSQL(sqlCode); // clear all highlighted options } else if (chkHighlightedItem.Checked && lblHighlightedMessage.Text.Contains("current")) { sql.ExecuteSQL(sqlCode); // clear all highlighted options qSoc_Blog2 curr_item = new qSoc_Blog2(blog_id); curr_item.Highlighted = true; curr_item.Update(); } else if (chkHighlightedItem.Checked && lblHighlightedMessage.Text.Contains("Check")) { sql.ExecuteSQL(sqlCode); // clear all highlighted options qSoc_Blog2 blog = new qSoc_Blog2(blog_id); blog.Highlighted = true; blog.Update(); } qSoc_Feed feed = new qSoc_Feed((int)qSoc_ContentType.Types.Story, blog_id); if (!chkDisplayInFeed.Checked && !chkDisplayInExplore.Checked) { if (feed != null) { if (feed.FeedID > 0) { feed.MarkAsDelete = 1; feed.Available = "No"; feed.ReservedKeywords = reserved_keywords; if (!chkDisplayInFeed.Checked) feed.VisibleFeed = false; if (!chkDisplayInExplore.Checked) feed.VisibleExplore = false; feed.Update(); } } } else if (chkDisplayInFeed.Checked || chkDisplayInExplore.Checked || !string.IsNullOrEmpty(reserved_keywords)) { qSoc_Blog2 blog = new qSoc_Blog2(blog_id); int p_user_id = user_id; if (post_as_user_id > 0) p_user_id = post_as_user_id; qPtl_User user = new qPtl_User(p_user_id); var u_space = qSoc_UserSpace_View.GetUserSpaces(blog.CreatedBy); // evaluate title and description string p_title = blog.Title.Replace("'", "\""); p_title = q_Helper.replaceSpecialCharacters(p_title); string p_description = q_Helper.replaceSpecialCharacters(blog.Summary); if (feed != null) { if (feed.FeedID > 0) { feed.CreatedBy = user.UserID; feed.Available = blog.Available; if (chkMoveToTop.Checked) feed.LastModified = DateTime.Now; feed.LastModifiedBy = user.UserID; feed.MarkAsDelete = blog.MarkAsDelete; feed.OwnerMarkAsDelete = blog.MarkAsDelete; feed.ContentTypeID = (int)qSoc_ContentType.Types.Story; feed.ReferenceID = blog_id; feed.OwnerID = user.UserID; feed.OwnerName = user.UserName; feed.OwnerProfilePic = user.ProfilePict; feed.Type = "blog"; feed.Title = p_title; feed.Description = p_description; feed.Body = p_description; feed.OwnerRole = user.HighestRole; feed.OwnerRoleID = user.HighestRank; feed.OwnerKeywords = owner_keywords; feed.ReservedKeywords = reserved_keywords; feed.UploadedFrom = "manager"; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) { feed.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); feed.ThemeName = Convert.ToString(ddlTheme.SelectedItem); } if (chkDisplayInFeed.Checked) feed.VisibleFeed = true; else feed.VisibleFeed = false; if (chkDisplayInExplore.Checked) feed.VisibleExplore = true; else feed.VisibleExplore = false; feed.Update(); } else { // create new feed item if (u_space != null) { foreach (var s in u_space) { feed.SpaceID = s.SpaceID; feed.SpaceName = s.SpaceShortName; } } feed.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]); feed.Available = blog.Available; feed.Created = DateTime.Now; feed.CreatedBy = user.UserID; feed.LastModified = DateTime.Now; feed.LastModifiedBy = user.UserID; feed.MarkAsDelete = blog.MarkAsDelete; feed.OwnerMarkAsDelete = blog.MarkAsDelete; feed.ContentTypeID = (int)qSoc_ContentType.Types.Story; feed.ReferenceID = blog_id; feed.OwnerID = user.UserID; feed.OwnerName = user.UserName; feed.OwnerProfilePic = user.ProfilePict; feed.Type = "blog"; feed.Title = p_title; feed.Description = p_description; feed.Body = p_description; feed.OwnerRole = user.HighestRole; feed.OwnerRoleID = user.HighestRank; feed.VisibleAll = true; feed.VisibleFriends = true; feed.VisibleFollowers = true; feed.VisibleSpace = true; feed.VisiblePrivate = true; feed.VisibleFeed = true; feed.VisibleOwnerFeed = true; feed.VisibleOwnerProfile = true; if (!String.IsNullOrEmpty(ddlTheme.SelectedValue)) { feed.ThemeID = Convert.ToInt32(ddlTheme.SelectedValue); feed.ThemeName = Convert.ToString(ddlTheme.SelectedItem); } feed.ReservedKeywords = reserved_keywords; if (!String.IsNullOrEmpty(owner_keywords)) { feed.OwnerKeywords = owner_keywords; } feed.UploadedFrom = "manager"; if (chkDisplayInFeed.Checked) feed.VisibleFeed = true; else feed.VisibleFeed = false; if (chkDisplayInExplore.Checked) feed.VisibleExplore = true; else feed.VisibleExplore = false; feed.Insert(); } } } //Response.Redirect("~/qSoc/blogs-list.aspx"); if (!String.IsNullOrEmpty(Request.QueryString["BlogID"])) { lblMessage.Text = "*** Record Successfully Updated ***"; lblMessageBottom.Text = "*** Record Successfully Updated ***"; } else { if (!String.IsNullOrEmpty(Request.QueryString["type"])) Response.Redirect(Request.Url.ToString() + "&mode=add-successful&BlogID=" + blog_id); else Response.Redirect(Request.Url.ToString() + "?mode=add-successful&BlogID=" + blog_id); } }
public static qPtl_User RegisterNewUser(RegistrationData data) { int existing_user_id = 0; int new_space_id = 0; string sqlCode = string.Empty; // Redundancy check -- write Highest Level into qPtl_User table in case DB trigger not working qPtl_Role role = new qPtl_Role(data.default_role_id); // add user qPtl_User new_user = new qPtl_User(); new_user.Available = "Yes"; new_user.OrgUnitID = data.scope_id; new_user.ScopeID = data.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 = data.firstname; new_user.LastName = data.lastname; new_user.Email = data.email; new_user.UserName = data.username; string password_for_storing = FormsAuthentication.HashPasswordForStoringInConfigFile(data.password, "sha1"); new_user.Password = password_for_storing; new_user.AccountStatus = "Active"; new_user.HighestRank = role.RoleRank; new_user.HighestRole = role.RoleName; new_user.Insert(); existing_user_id = new_user.UserID; DateTime DOB; try { DOB = Convert.ToDateTime(data.dob); } catch { // no valid date so use default value DOB = Convert.ToDateTime("1/1/1900"); } // add user profile qPtl_UserProfile new_profile = new qPtl_UserProfile(); new_profile.UserID = existing_user_id; new_profile.ScopeID = data.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.Division = data.division; new_profile.Agency = data.agency; new_profile.Position = data.position; new_profile.Degrees = data.degrees; new_profile.Address1 = data.address; new_profile.Address2 = data.address2; new_profile.City = data.city; new_profile.StateProvince = data.state; new_profile.PostalCode = data.postal_code; new_profile.Country = data.country; new_profile.Gender = data.gender; new_profile.DOB = DOB; new_profile.Race = data.race; new_profile.EmploymentLocation = data.employment_location; new_profile.EmploymentSetting = data.employment_setting; new_profile.WorkSites = data.employment_sites; new_profile.Profession = data.profession; new_profile.Phone1 = data.work_phone; new_profile.Phone1Type = "work"; new_profile.Insert(); qPtl_User user = new qPtl_User(existing_user_id); // add user communication preference if (!String.IsNullOrEmpty(user.Email)) { 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(); } // **************************************************** // 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(); */ qDbs_SQLcode sql = new qDbs_SQLcode(); sqlCode = "INSERT INTO qPtl_UserRoles ([UserID],[RoleID]) VALUES(" + user.UserID + "," + data.default_role_id + ")"; sql.ExecuteSQL(sqlCode); // Add possible role actions for the new user role AddRoleAction(data.default_role_id, data.scope_id, user); // add folder for user_data string rootLocation = HttpContext.Current.Server.MapPath("~/") + "user_data\\"; if (!Directory.Exists(rootLocation + user.UserName)) Directory.CreateDirectory(rootLocation + user.UserName); if (new_user.UserID > 0) return new_user; else return null; }