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;
}
