protected void Page_Load(object sender, EventArgs e)
{
#region Logged In User details
_loggedInMembershipUser = Membership.GetUser();
this.LoggedInMembership_UserId = _loggedInMembershipUser.ProviderUserKey.ToString();
_loggedInUser = new WTS_User();
_loggedInUser.Load(this.LoggedInMembership_UserId);
this.LoggedInProfileId = UserManagement.GetUserId(this.LoggedInMembership_UserId);
IsUserAdmin = UserManagement.UserIsUserAdmin(this.LoggedInProfileId);
#endregion Logged In User details
if (Request.QueryString["UserID"] != null && !string.IsNullOrWhiteSpace(Request.QueryString["UserID"]))
{
int.TryParse(this.Server.UrlDecode(this.Request.QueryString["UserID"]), out this.UserId);
}
if (this.LoggedInProfileId == this.UserId)
{
this.IsCurrentUser = true;
}
init();
loadUserData();
ddlMainView.Attributes.Add("original_value", ddlMainView.SelectedValue);
ddlView_Main.Attributes.Add("original_value", ddlView_Main.SelectedValue);
ddlView_Workload.Attributes.Add("original_value", ddlView_Workload.SelectedValue);
ddlView_Crosswalk.Attributes.Add("original_value", ddlView_Crosswalk.SelectedValue);
ddlView_Request.Attributes.Add("original_value", ddlView_Request.SelectedValue);
ddlView_Hotlist.Attributes.Add("original_value", ddlView_Hotlist.SelectedValue);
}
private static bool validateUserID(int userID, out WTS_User u, out string errorMsg)
{
u = null;
errorMsg = string.Empty;
if (userID == 0)
{
errorMsg = "Invalid user id specified";
return(false);
}
else
{
u = new WTS_User(userID);
u.Load();
if (u == null || u.ID == 0)
{
errorMsg = "User does not exist with specified id";
return(false);
}
else
{
return(true);
}
}
}
private void LoadUserAttributes(WTS_User u)
{
//get user's Resource_Attribute records
ListItem item = null;
DataTable dt = u.Resource_AttributeList_Get();
if (dt == null)
{
return;
}
string attrID = "", attr = "", resource_AttrID = "";
foreach (DataRow row in dt.Rows)
{
attrID = row["AttributeID"].ToString();
attr = row["Attribute"].ToString();
resource_AttrID = row["Attribute"].ToString();
if (row["Checked"].ToString().ToUpper() == "TRUE" ||
row["Checked"].ToString() == "1")
{
item = chkListAttributes.Items.FindByText(attr);
if (item != null)
{
item.Selected = true;
item.Attributes.Add("Resource_AttributeID", resource_AttrID);
}
}
}
}
protected void LoadData()
{
DataTable dt = null;
if (_refreshData || Session["dtUserCerts"] == null)
{
WTS_User u = new WTS_User(this.UserId);
dt = u.CertificationList_Get();
HttpContext.Current.Session["dtUserCerts"] = dt;
}
else
{
dt = (DataTable)HttpContext.Current.Session["dtUserCerts"];
}
if (dt != null)
{
this.DCC = dt.Columns;
Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None));
int count = dt.Rows.Count;
count = count > 0 ? count - 1 : count; //need to subtract the empty row
spanRowCount.InnerText = count.ToString();
InitializeColumnData(ref dt);
dt.AcceptChanges();
}
grdCerts.DataSource = dt;
grdCerts.DataBind();
}
public static string AddCertification(int userId, string certification, string description, string expirationDate, bool expired = false)
{
Dictionary <string, string> result = new Dictionary <string, string>()
{
{ "saved", "" }, { "id", "" }, { "error", "" }
};
bool saved = false;
int id = 0;
string errorMsg = string.Empty;
try
{
WTS_User u = new WTS_User(userId);
u.Load();
saved = u.Certification_Add(certification, description, expirationDate, expired, out id, out errorMsg);
}
catch (Exception ex)
{
LogUtility.LogException(ex);
saved = false;
errorMsg = ex.Message;
}
result["id"] = id.ToString();
result["saved"] = saved.ToString();
result["error"] = errorMsg;
return(JsonConvert.SerializeObject(result, Formatting.None));
}
private static bool validateUserIdString(string UserId, out WTS_User u, out string errorMsg)
{
u = null;
errorMsg = string.Empty;
int id = 0;
int.TryParse(UserId, out id);
if (id == 0)
{
errorMsg = "Invalid user id specified";
return(false);
}
else
{
u = new WTS_User(id);
u.Load();
if (u == null || u.ID == 0)
{
errorMsg = "User does not exist with specified id";
return(false);
}
else
{
return(true);
}
}
}
private void SubmitRequest(MembershipUser mu, out bool submitted, out bool emailed)
{
submitted = false;
emailed = false;
WTS_User u = new WTS_User(mu.ProviderUserKey.ToString());
u.Load_GUID();
Guid resetCode = Guid.Empty;
string errorMsg = string.Empty;
submitted = u.RequestPasswordReset(DateTime.Now.ToUniversalTime().Ticks, out resetCode, out errorMsg);
string msg = string.Empty;
if (submitted)
{
//show confirmation message
emailed = UserManagement.SendResetEmail(mu.Email, mu.UserName, resetCode, (Guid)mu.ProviderUserKey);
msg = "An email with steps to follow will be sent to your registered email address.";
}
else
{
msg = "We were unable to submit your password reset request.";
}
labelResultMessage.Text = msg;
this.divMessages.Style["display"] = "block";
}
private void InitControls()
{
LoadOrganizations();
LoadAvailableRoles();
WTS_User u = null;
if (!IsNew)
{
LoadUserValues(out u);
}
else
{
chkApproved.Visible = false;
chkApproved.Disabled = true;
labelForChkApproved.Visible = false;
chkLocked.Visible = false;
chkLocked.Disabled = true;
labelForChkLocked.Visible = false;
buttonUnlock.Visible = false;
buttonUnlock.Disabled = true;
chkArchive.Visible = false;
chkArchive.Disabled = true;
labelForChkArchive.Visible = false;
WTSUtility.SelectDdlItem(this.ddlOrganization, ((int)UserManagement.Organization.Unauthorized).ToString());
}
if (this.IsUserAdmin)
{
ddlOrganization.Enabled = true;
if (!IsNew)
{
chkApproved.Disabled = false;
if (u.IsLocked)
{
buttonUnlock.Visible = true;
buttonUnlock.Disabled = false;
}
else
{
buttonUnlock.Visible = false;
buttonUnlock.Disabled = true;
}
}
}
else
{
ddlOrganization.Enabled = false;
chkApproved.Disabled = true;
chkLocked.Disabled = true;
buttonUnlock.Visible = false;
chkArchive.Disabled = true;
}
if (ViewOnly)
{
DisableEdit();
}
}
private void InitControls()
{
grdHardware.RowDataBound += grdHardware_RowDataBound;
WTS_User u = null;
LoadData();
}
private void InitControls()
{
grdCerts.RowDataBound += grdCerts_RowDataBound;
WTS_User u = null;
LoadData();
}
protected void Page_Load(object sender, EventArgs e)
{
this.reportID = WTS_Reports.getReportIDbyName("Workload Summary Report");
DataTable dt = new DataTable();
MembershipUser u = Membership.GetUser();
WTS_User user = new WTS_User(u.ProviderUserKey.ToString());
user.Load_GUID();
this.userID = user.ID;
string userName = HttpContext.Current.User.Identity.Name;
WTS_Reports.get_Report_Parameter_List(ref dt, userID, this.reportID);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
string name = row.Field <string>("Name");
string value = row.Field <Int32>("ParamsID").ToString();
ListItem li = new ListItem(name, value);
if (row.Field <bool>("Process"))
{
li.Attributes.Add("OptionGroup", "Process Views");
}
else
{
li.Attributes.Add("OptionGroup", "Custom Views");
}
ddlParameters.Items.Insert(ddlParameters.Items.Count, li);
}
}
ListItem def = new ListItem("Default", "Default");
def.Attributes.Add("OptionGroup", "Process Views");
ddlParameters.Items.Insert(0, def);
// 13419 - 7:
ListItem defBacklog = new ListItem("Default (Backlog)", "Default (Backlog)");
def.Attributes.Add("OptionGroup", "Process Views");
ddlParameters.Items.Insert(1, defBacklog);
if (IsPostBack)
{
DataSet ds = (DataSet)Session["WorkloadSummaryData"];
String selectedColumns = (String)Session["SelectedColumns"];
String SummaryOverviewsSection1 = (String)Session["SummaryOverviewsSecion1"];
String SummaryOverviewsSection2 = (String)Session["SummaryOverviewsSecion2"];
String ddlValue = (String)Session["ddlValue"];
Excel = (String)Session["Excel"];
exportReport(ds, selectedColumns, SummaryOverviewsSection1, SummaryOverviewsSection2, ddlValue);
}
}
public static WTS_User GetLoggedInUser()
{
MembershipUser LoggedInMembershipUserStatic = Membership.GetUser();
string LoggedInMembershipUserIDStatic = LoggedInMembershipUserStatic.ProviderUserKey.ToString();
WTS_User LoggedInUserStatic = new WTS_User();
LoggedInUserStatic.Load(LoggedInMembershipUserIDStatic);
return(LoggedInUserStatic);
}
private void LoadUserValues(out WTS_User u)
{
u = new WTS_User();
u.Load(this.UserId);
if (!string.IsNullOrWhiteSpace(u.Username))
{
labelUserName.InnerText = u.Username;
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.CanEdit = UserManagement.UserCanEdit(WTSModuleOption.ResourceAdmin);
this.CanView = CanEdit || UserManagement.UserCanView(WTSModuleOption.ResourceAdmin);
#region QueryString
if (Request.QueryString["RefData"] == null || string.IsNullOrWhiteSpace(Request.QueryString["RefData"]) ||
Request.QueryString["RefData"].Trim() == "1" || Request.QueryString["RefData"].Trim().ToUpper() == "TRUE")
{
_refreshData = true;
}
if (Request.QueryString["popup"] == null || string.IsNullOrWhiteSpace(Request.QueryString["popup"]))
{
this.IsPopup = false;
}
else
{
bool.TryParse(this.Server.UrlDecode(Request.QueryString["popup"]).ToString().ToLower(), out this.IsPopup);
}
if (Request.QueryString["CurrentUser"] != null && !string.IsNullOrWhiteSpace(Request.QueryString["CurrentUser"]))
{
bool.TryParse(this.Server.UrlDecode(Request.QueryString["CurrentUser"]).ToString().ToLower(), out this.IsCurrentUser);
}
#endregion QueryString
#region Logged In User details
_loggedInMembershipUser = Membership.GetUser();
this.LoggedInMembership_UserId = _loggedInMembershipUser.ProviderUserKey.ToString();
_loggedInUser = new WTS_User();
_loggedInUser.Load(this.LoggedInMembership_UserId);
this.LoggedInProfileId = UserManagement.GetUserId(this.LoggedInMembership_UserId);
IsUserAdmin = UserManagement.UserIsUserAdmin(this.LoggedInProfileId);
#endregion Logged In User details
if (this.IsCurrentUser)
{
this.UserId = _loggedInUser.ID;
this.MembershipUserId = this.LoggedInMembership_UserId;
}
else
{
if (Request.QueryString["UserID"] != null && !string.IsNullOrWhiteSpace(Request.QueryString["UserID"]))
{
int.TryParse(this.Server.UrlDecode(this.Request.QueryString["UserID"]), out this.UserId);
}
}
InitControls();
}
public static string SaveProfile(int userId = 0, string membershipUserId = ""
, int organizationId = 0, string roles = "", bool archive = false)
{
Dictionary <string, string> result = new Dictionary <string, string>()
{
{ "saved", "" }, { "id", "" }, { "error", "" }, { "username", "" }, { "changedTheme", "" }
};
string[] rolesList = roles.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
bool saved = false;
string errorMsg = string.Empty;
try
{
//perform the save
WTS_User u = new WTS_User();
if (userId > 0)
{
u.ID = userId;
u.Load();
}
u.OrganizationID = organizationId == 0 ? (int)UserManagement.Organization.Unauthorized : organizationId;
u.Archive = archive;
if (userId == 0)
{
//error message
errorMsg = "No user to update was specified.";
}
else
{
saved = u.Update(out errorMsg);
MembershipUser mu = null;
mu = UserManagement.GetMembershipUser(u.Email, u.Username);
UpdateUserRoles(mu.UserName, rolesList);
}
}
catch (Exception ex)
{
saved = false;
errorMsg = ex.Message.ToString();
LogUtility.LogException(ex);
}
result["saved"] = saved.ToString();
result["id"] = userId.ToString();
result["error"] = errorMsg;
return(JsonConvert.SerializeObject(result, Formatting.None));
}
protected override void OnPreInit(EventArgs e)
{
base.OnPreInit(e);
LoggedInMembershipUser = Membership.GetUser();
LoggedInMembershipUserID = LoggedInMembershipUser.ProviderUserKey.ToString();
IsAdmin = Roles.IsUserInRole("Admin");
LoggedInUser = new WTS_User();
LoggedInUser.Load(LoggedInMembershipUserID);
LoggedInUserID = LoggedInUser.ID;
IsUserAdmin = UserManagement.UserIsUserAdmin(LoggedInUserID);
}
public static Dictionary <string, string> QueueReport(
int REPORT_TYPEID,
Dictionary <string, string> reportParameters,
string scheduledDate)
{
Dictionary <string, string> result = new Dictionary <string, string>()
{
{ "success", "false" }, { "guid", "" }, { "error", "" }
};
DateTime sd = DateTime.MinValue;
DateTime.TryParse(scheduledDate, out sd);
try
{
var loggedInMembershipUser = Membership.GetUser();
var loggedInMembershipUserId = loggedInMembershipUser.ProviderUserKey.ToString();
var loggedInUser = new WTS_User();
loggedInUser.Load(loggedInMembershipUserId);
QueuedReport rpt = ReportQueue.Instance.QueueReport(Guid.NewGuid().ToString(), loggedInUser.ID, REPORT_TYPEID, sd, reportParameters, reportParameters != null && reportParameters.ContainsKey("Title") ? reportParameters["Title"] : null);
IEvent evt = null;
if (rpt != null && rpt.ReportQueueID > 0)
{
evt = EventQueue.Instance.QueueRunReportEvent(rpt.ReportQueueID, DateTime.MinValue);
}
if (rpt != null && evt != null)
{
result["success"] = "true";
result["id"] = rpt.ReportQueueID.ToString();
result["guid"] = rpt.Guid;
}
else
{
LogUtility.Log("Unable to create report." + (rpt == null || rpt.ReportQueueID == 0 ? " Queued Report cannot be saved." : "") + (evt == null ? " Event could not be created." : ""));
}
}
catch (Exception ex)
{
result["error"] = ex.Message + " " + ex.StackTrace;
LogUtility.LogException(ex);
}
return(result);
}
public static string HideQuickAddWarning()
{
var result = WTSPage.CreateDefaultResult();
WTS_User u = WTSPage.GetLoggedInUser();
bool dup = false;
string err = "";
u.UserSetting_Update(0, 2, 0, "0", out dup, out err);
result["success"] = "true";
return(WTSPage.SerializeResult(result));
}
public static string DeleteUser(int userID)
{
Dictionary <string, string> result = new Dictionary <string, string>()
{
{ "Exists", "" }
, { "HasDependencies", "" }
, { "Deleted", "" }
, { "Archived", "" }
, { "Error", "" }
};
bool exists = false, hasDependencies = false, deleted = false, archived = false;
string errorMsg = string.Empty;
WTS_User u = null;
if (!validateUserID(userID, out u, out errorMsg))
{
exists = false;
hasDependencies = false;
deleted = false;
archived = false;
}
else
{
try
{
bool membershipDeleted = false;
deleted = u.Delete(out exists, out hasDependencies, out archived, out membershipDeleted);
}
catch (Exception ex)
{
LogUtility.LogException(ex);
exists = false;
hasDependencies = false;
deleted = false;
archived = false;
errorMsg = ex.Message;
}
}
result["Exists"] = exists.ToString();
result["HasDependencies"] = hasDependencies.ToString();
result["Deleted"] = deleted.ToString();
result["Archived"] = archived.ToString();
result["Error"] = errorMsg;
return(JsonConvert.SerializeObject(result, Formatting.None));
}
protected void Page_Load(object sender, EventArgs e)
{
#region QueryString
if (Request.QueryString["View"] == null || string.IsNullOrWhiteSpace(Request.QueryString["View"]))
{
ViewOnly = false;
}
else
{
bool.TryParse(this.Server.UrlDecode(Request.QueryString["View"]).ToLower(), out ViewOnly);
}
if (Request.QueryString["OrganizationID"] != null && !string.IsNullOrWhiteSpace(Request.QueryString["OrganizationID"]))
{
int.TryParse(this.Server.UrlDecode(this.Request.QueryString["OrganizationId"]), out OrganizationId);
}
if (OrganizationId > 0)
{
this.txtOrganizationId.Value = OrganizationId.ToString();
IsNew = false;
}
#endregion
#region Logged In User details
_loggedInMembershipUser = Membership.GetUser();
this.LoggedInMembership_UserId = _loggedInMembershipUser.ProviderUserKey.ToString();
this.IsAdmin = Roles.IsUserInRole("Admin");
_loggedInUser = new WTS_User();
_loggedInUser.Load(this.LoggedInMembership_UserId);
this.LoggedInProfileId = UserManagement.GetUserId(this.LoggedInMembership_UserId);
IsUserAdmin = UserManagement.UserIsUserAdmin(this.LoggedInProfileId);
#endregion Logged In User details
Page.Form.DefaultFocus = txtOrganization.ClientID;
InitControls();
}
public static string SaveCustomView(
int reportViewID,
string viewName,
int REPORT_TYPEID,
int processView,
Dictionary <string, string> reportParameters,
string reportLevels)
{
Dictionary <string, string> result = new Dictionary <string, string>()
{
{ "saved", "false" }, { "viewName", viewName }, { "viewID", reportViewID.ToString() }, { "customFilter", "" }, { "error", "" }
};
int savedID = -1;
string errorMsg = string.Empty;
try
{
var loggedInMembershipUser = Membership.GetUser();
var loggedInMembershipUserId = loggedInMembershipUser.ProviderUserKey.ToString();
var loggedInUser = new WTS_User();
loggedInUser.Load(loggedInMembershipUserId);
if (reportParameters != null)
{
savedID = Filtering.SaveCustomReportView((processView == 1 ? 0 : loggedInUser.ID), reportViewID, REPORT_TYPEID, viewName, reportParameters, reportLevels);
}
if (savedID > -1)
{
result["viewid"] = savedID.ToString();
result["saved"] = "True";
}
}
catch (Exception ex)
{
result["error"] = ex.Message + " " + ex.StackTrace;
LogUtility.LogException(ex);
}
result["error"] = errorMsg;
return(JsonConvert.SerializeObject(result, Newtonsoft.Json.Formatting.None));
}
private void CheckRoles()
{
#region Logged In User details
_loggedInMembershipUser = Membership.GetUser();
_loggedInUser = new WTS_User();
_loggedInUser.Load(_loggedInMembershipUser.ProviderUserKey.ToString());
#endregion Logged In User details
//enable/disable buttons
if (_loggedInUser.Organization.StartsWith("admin", StringComparison.CurrentCultureIgnoreCase) ||
User.IsInRole("Admin") ||
User.IsInRole("Administration") ||
User.IsInRole("ResourceManagement"))
{
this.AllowEdit = true;
this.AllowDelete = true;
}
}
public static string DeleteItem(int userId, int itemId, string item)
{
Dictionary <string, string> result = new Dictionary <string, string>()
{
{ "id", itemId.ToString() }
, { "item", item }
, { "exists", "" }
, { "deleted", "" }
, { "error", "" }
};
bool exists = false, deleted = false;
string errorMsg = string.Empty;
try
{
//delete
if (itemId == 0)
{
errorMsg = "You must specify an item to delete.";
}
else
{
WTS_User u = new WTS_User(userId);
u.Load();
deleted = u.Certification_Delete(itemId, out exists);
}
}
catch (Exception ex)
{
LogUtility.LogException(ex);
deleted = false;
errorMsg = ex.Message;
}
result["exists"] = exists.ToString();
result["deleted"] = deleted.ToString();
result["error"] = errorMsg;
return(JsonConvert.SerializeObject(result, Formatting.None));
}
private void LoadUserValues(out WTS_User u)
{
u = new WTS_User();
MembershipUser mu;
if (this.IsCurrentUser)
{
u = _loggedInUser;
mu = _loggedInMembershipUser;
LoadUserRoles(mu);
}
else
{
u.Load(this.UserId);
if (!string.IsNullOrWhiteSpace(u.Membership_UserID) && u.Membership_UserID != Guid.Empty.ToString())
{
mu = Membership.GetUser(new Guid(u.Membership_UserID));
LoadUserRoles(mu);
}
else
{
mu = UserManagement.GetMembershipUser(u.Email, u.Username);
if (mu != null)
{
u.Membership_UserID = mu.ProviderUserKey.ToString();
LoadUserRoles(mu);
}
}
}
this.MembershipUserId = u.Membership_UserID;
if (ddlOrganization.Items.FindByValue(u.OrganizationID.ToString()) == null)
{
ddlOrganization.Items.Add(new ListItem(u.Organization, u.OrganizationID.ToString()));
}
WTSUtility.SelectDdlItem(ddlOrganization, u.OrganizationID.ToString());
chkApproved.Checked = u.IsApproved;
chkLocked.Checked = u.IsLocked;
chkArchive.Checked = u.Archive;
}
private static bool validateID(long reportQueueID, bool validateDelete, bool validateArchive, bool loadData, out QueuedReport rpt, out string errorMsg)
{
errorMsg = string.Empty;
rpt = null;
var loggedInMembershipUser = Membership.GetUser();
var loggedInUser = new WTS_User();
loggedInUser.Load(loggedInMembershipUser.ProviderUserKey.ToString());
if (reportQueueID == 0)
{
errorMsg = "ReportQueueID missing or invalid.";
return(false);
}
else
{
rpt = ReportQueue.Instance.GetReport(reportQueueID, null, loadData);
if (rpt == null)
{
errorMsg = "Report (" + reportQueueID + ") is invalid.";
return(false);
}
if (validateDelete && rpt.WTS_RESOURCEID != loggedInUser.ID && !UserCanDeleteReports())
{
errorMsg = "User cannot delete this report.";
return(false);
}
if (validateArchive && rpt.WTS_RESOURCEID != loggedInUser.ID && !UserCanArchiveReports())
{
errorMsg = "User cannot archive this report.";
return(false);
}
}
return(true);
}
protected bool SaveProfile(string userName = "", string email = "", string userId = "", int profileId = 0)
{
string errorMsg = string.Empty;
bool saved = false;
//if (profileId == 0)
//{
// //search for existing profile
// DataTable dtUsers = UserManagement.FindUnregisteredUsers(userName.Trim(), email.Trim());
// if (dtUsers != null && dtUsers.Rows.Count > 0)
// {
// int.TryParse(dtUsers.Rows[0]["Id"].ToString(), out profileId);
// }
//}
bool isNew = (profileId == 0);
WTS_User u = new WTS_User();
if (!isNew)
{
u.Load(profileId);
}
//u.Username = userName;
//u.Membership_UserID = userId;
//u.Email = email;
//LoadProfileValues(ref u);
//if (isNew)
//{
// profileId = u.Add(out saved, out errorMsg);
//}
//else
//{
// saved = u.Update(out errorMsg);
//}
return(saved);
}
protected void Page_Load(object sender, EventArgs e)
{
this.CanEdit = UserManagement.UserCanEdit(WTSModuleOption.ResourceAdmin);
this.CanView = CanEdit || UserManagement.UserCanView(WTSModuleOption.ResourceAdmin);
readQueryString();
#region Logged In User details
_loggedInMembershipUser = Membership.GetUser();
_loggedInUser = new WTS_User();
_loggedInUser.Load(_loggedInMembershipUser.ProviderUserKey.ToString());
#endregion Logged In User details
//CheckRoles();
this.AllowEdit = true;
this.AllowDelete = true;
initControls();
LoadData(export: _export);
}
public static string CheckCustomView(
int REPORT_TYPEID,
string viewName,
Dictionary <string, string> reportParameters,
string reportLevels
)
{
Dictionary <string, string> result = new Dictionary <string, string>()
{
{ "exists", "false" }, { "error", "" }
};
bool exists = false;
string errorMsg = string.Empty;
try
{
var loggedInMembershipUser = Membership.GetUser();
var loggedInMembershipUserId = loggedInMembershipUser.ProviderUserKey.ToString();
var loggedInUser = new WTS_User();
loggedInUser.Load(loggedInMembershipUserId);
exists = Filtering.CheckReportViewExist(loggedInUser.ID, REPORT_TYPEID, viewName);
}
catch (Exception ex)
{
result["error"] = ex.Message + " " + ex.StackTrace;
LogUtility.LogException(ex);
}
result["viewName"] = viewName;
result["reportParameters"] = JsonConvert.SerializeObject(reportParameters, Newtonsoft.Json.Formatting.None);
result["reportLevels"] = reportLevels;
result["exists"] = exists.ToString();
return(JsonConvert.SerializeObject(result, Newtonsoft.Json.Formatting.None));
}
private void loadLookupData()
{
int UserId = UserManagement.GetUserId_FromUsername();
WTS_User u = new WTS_User(UserId);
u.Load();
DataTable dt = WTSData.GetViewOptions(userId: UserId, gridName: GridType);
DataTable dtSetting = u.UserSettingList_Get(u.ID, (int)UserSettingType.GridView, GridTypeEnum);
if (dt != null && dt.Rows.Count > 0)
{
ddlView.Items.Clear();
ListItem item = null;
foreach (DataRow row in dt.Rows)
{
item = new ListItem();
item.Text = row["ViewName"].ToString();
item.Value = row["GridViewID"].ToString();
item.Attributes.Add("OptionGroup", row["WTS_RESOURCEID"].ToString() != "" ? "Custom Views" : "Process Views");
item.Attributes.Add("MyView", row["MyView"].ToString());
item.Attributes.Add("Tier1RollupGroup", row["Tier1RollupGroup"].ToString());
item.Attributes.Add("Tier1ColumnOrder", row["Tier1ColumnOrder"].ToString());
item.Attributes.Add("Tier2ColumnOrder", row["Tier2ColumnOrder"].ToString());
item.Attributes.Add("DefaultSortType", row["Tier2SortOrder"].ToString());
item.Attributes.Add("SectionsXML", row["SectionsXML"].ToString());
// Set the default, over-write below if user has saved a view preference.
if (Session["Levels"] == null && item.Text.ToString().ToLower() == "default")
{
if (row["SectionsXML"].ToString() != "")
{
XmlDocument xml = new XmlDocument();
xml.LoadXml(row["SectionsXML"].ToString());
HttpContext.Current.Session["Levels"] = xml;
//------------------------------------------
}
}
ddlView.Items.Add(item);
try
{
if (Session[DefaultGridViewNameSessionKey] != null)
{
if (ddlView.Items.FindByText(row["ViewName"].ToString()) == null)
{
// If user has saved view preference, save that XML to Session.
if (Session[DefaultGridViewNameSessionKey].ToString().ToLower() == item.Text.ToString().ToLower())
{
if (row["SectionsXML"].ToString() != "")
{
XmlDocument xml = new XmlDocument();
xml.LoadXml(row["SectionsXML"].ToString());
HttpContext.Current.Session["Levels"] = xml;
//------------------------------------------
}
}
}
}
}
catch (Exception)
{
// Nothing to do here, will use default.
}
}
// 11626 - 2 > Use saved preferences:
if (Session[DefaultGridViewNameSessionKey] != null && !string.IsNullOrWhiteSpace(Session[DefaultGridViewNameSessionKey].ToString()) && ddlChanged_ML != "yes")
{
ListItem itemGridView = ddlView.Items.FindByText(Session[DefaultGridViewNameSessionKey].ToString());
if (itemGridView != null)
{
itemGridView.Selected = true;
}
else
{
this.Grid_View = string.Empty;
}
}
else // No saved view preference
{
if (!string.IsNullOrWhiteSpace(this.Grid_View))
{
ListItem itemGridView = ddlView.Items.FindByText(this.Grid_View);
if (itemGridView != null)
{
itemGridView.Selected = true;
}
else
{
this.Grid_View = string.Empty;
}
}
else
{
if (dtSetting != null && dtSetting.Rows.Count > 0)
{
WTSUtility.SelectDdlItem(ddlView, dtSetting.Rows[0]["SettingValue"].ToString().Trim());
}
}
}
if (Session[GridViewCurrentDropDownSessionKey] != null)
{
// Not working, may be because of "Process Views" "Custom Views"
//ddlView.SelectedIndex = Convert.ToInt32(Session["CurrentDropDown"].ToString());
}
if (Session[GridViewLevelsSessionKey] != null) // HttpContext.Current.
{
Page.ClientScript.RegisterArrayDeclaration("dtSectionsView", JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.None));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region QueryString
if (Request.QueryString["popup"] == null || string.IsNullOrWhiteSpace(Request.QueryString["popup"]))
{
this.IsPopup = false;
}
else
{
bool.TryParse(this.Server.UrlDecode(Request.QueryString["popup"]).ToString().ToLower(), out this.IsPopup);
}
if (Request.QueryString["View"] == null || string.IsNullOrWhiteSpace(Request.QueryString["View"]))
{
ViewOnly = false;
}
else
{
bool.TryParse(this.Server.UrlDecode(Request.QueryString["View"]).ToString().ToLower(), out this.ViewOnly);
}
if (Request.QueryString["CurrentUser"] == null || string.IsNullOrWhiteSpace(Request.QueryString["CurrentUser"]))
{
ViewOnly = false;
}
else
{
bool.TryParse(this.Server.UrlDecode(Request.QueryString["CurrentUser"]).ToString().ToLower(), out this.IsCurrentUser);
}
#endregion QueryString
#region Logged In User details
_loggedInMembershipUser = Membership.GetUser();
this.LoggedInMembership_UserId = _loggedInMembershipUser.ProviderUserKey.ToString();
_loggedInUser = new WTS_User();
_loggedInUser.Load(this.LoggedInMembership_UserId);
this.LoggedInProfileId = UserManagement.GetUserId(this.LoggedInMembership_UserId);
IsUserAdmin = UserManagement.UserIsUserAdmin(this.LoggedInProfileId);
#endregion Logged In User details
if (this.IsCurrentUser)
{
this.UserId = _loggedInUser.ID;
this.MembershipUserId = this.LoggedInMembership_UserId;
}
else
{
if (Request.QueryString["UserID"] != null && !string.IsNullOrWhiteSpace(Request.QueryString["UserID"]))
{
int.TryParse(this.Server.UrlDecode(this.Request.QueryString["UserID"]), out this.UserId);
}
}
if (this.IsCurrentUser || this.UserId > 0)
{
IsNew = false;
}
InitControls();
}
