private System.Data.DataTable GetData() { var data = new UserPreferenceDataModel(); var dt = UserPreferenceDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new UserPreferenceDataModel(); data.UserPreferenceId = int.Parse(index); UserPreferenceDataManager.Delete(data, SessionVariables.RequestProfile); } Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.UserPreference, SessionVariables.RequestProfile); Response.Redirect(Page.GetRouteUrl("UserPreferenceEntityRoute", new { Action = "Default", SetId = true }), false); //var userMode = String.Empty; //if (!string.IsNullOrEmpty(Request.QueryString["user"])) //{ // userMode = "&user="******"user"]; //} //Response.Redirect("Default.aspx?Deleted=" + true + userMode, false); } catch (Exception ex) { Response.Write(ex.Message); } }
private void SetUpCountryDropDown() { var countryData = Framework.Components.Core.CountryDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(countryData, drpCountry, StandardDataModel.StandardDataColumns.Name, CountryDataModel.DataColumns.CountryId); var dataKey = new UserPreferenceKeyDataModel(); dataKey.Name = "UserCountry"; var dtKeys = Framework.Components.UserPreference.UserPreferenceKeyDataManager.Search(dataKey, SessionVariables.RequestProfile); if (dtKeys != null && dtKeys.Rows.Count > 0) { UserCountryKeyId = Convert.ToInt32(dtKeys.Rows[0][UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId]); UserCountryDataTypeId = Convert.ToInt32(dtKeys.Rows[0][UserPreferenceKeyDataModel.DataColumns.DataTypeId]); var data = new UserPreferenceDataModel(); data.ApplicationUserId = SessionVariables.RequestProfile.AuditId; data.UserPreferenceKeyId = UserCountryKeyId; var dt = UserPreferenceDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count > 0) { UserCountryPreferenceId = Convert.ToInt32(dt.Rows[0][UserPreferenceDataModel.DataColumns.UserPreferenceId]); drpCountry.SelectedValue = Convert.ToString(dt.Rows[0][UserPreferenceDataModel.DataColumns.Value]); } } }
protected override void ShowData(int userPreferenceId) { oDetailButtonPanel.SetId = SetId; var data = new UserPreferenceDataModel(); data.UserPreferenceId = userPreferenceId; var items = UserPreferenceDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; lblUserPreferenceId.Text = item.UserPreferenceId.ToString(); lblApplicationUserId.Text = item.ApplicationUserId.ToString(); lblUserPreferenceCategory.Text = item.UserPreferenceCategoryId.ToString(); lblDataTypeId.Text = item.DataTypeId.ToString(); lblUserPreferenceKeyId.Text = item.UserPreferenceKeyId.ToString(); lblValue.Text = item.Value.ToString(); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, userPreferenceId, "UserPreference"); } else { Clear(); } }
private DataTable GetData(string applicationUserId) { var data = new UserPreferenceDataModel(); data.ApplicationUserId = int.Parse(applicationUserId); var dt = UserPreferenceDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
private System.Data.DataTable GetData() { var data = new UserPreferenceDataModel(); data.UserPreferenceKeyId = Convert.ToInt32(txtUserPreferenceKeyId.Text); data.Value = txtValue.Text.Trim(); var topN = Convert.ToInt32(Session["TopNCount"]); var dt = UserPreferenceDataManager.GetTopNUserPreferences(data, topN, SessionVariables.RequestProfile); return(dt); }
protected override void Clear() { base.Clear(); var data = new UserPreferenceDataModel(); UserPreferenceId = data.UserPreferenceId; UserPreferenceCategoryId = data.UserPreferenceCategoryId; UserPreferenceKeyId = data.UserPreferenceKeyId; ApplicationUserId = data.ApplicationUserId; Value = data.Value; DataTypeId = data.DataTypeId; }
public void LoadData(int userPreferenceId, bool showId) { // clear UI Clear(); // set up parameters var data = new UserPreferenceDataModel(); data.UserPreferenceId = userPreferenceId; // get data var items = UserPreferenceDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; txtUserPreferenceKeyId.Text = item.UserPreferenceKeyId.ToString(); txtApplicationUserId.Text = item.ApplicationUserId.ToString(); txtValue.Text = item.Value.ToString(); txtDataTypeId.Text = item.DataTypeId.ToString(); txtUserPreferenceCategoryId.Text = Convert.ToString(item.UserPreferenceCategoryId); drpUserPreferenceKeyList.SelectedValue = item.UserPreferenceKeyId.ToString(); drpDataTypeList.SelectedValue = item.DataTypeId.ToString(); drpApplicationUserList.SelectedValue = Convert.ToString(item.ApplicationUserId); drpUserPreferenceCategoryList.SelectedValue = Convert.ToString(item.UserPreferenceCategoryId); if (!showId) { txtUserPreferenceId.Text = item.UserPreferenceId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, userPreferenceId, PrimaryEntityKey); } else { txtUserPreferenceId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
private void SetUserCountry() { if (drpCountry.SelectedValue != "-1") { //UserCountryId = Convert.ToInt32(drpCountry.SelectedValue); var data = new UserPreferenceDataModel(); if (UserCountryPreferenceId != null) { data.UserPreferenceId = UserCountryPreferenceId; var dt = UserPreferenceDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count > 0) { data.UserPreferenceCategoryId = Convert.ToInt32(dt.Rows[0][UserPreferenceDataModel.DataColumns.UserPreferenceCategoryId]); data.UserPreferenceKeyId = Convert.ToInt32(dt.Rows[0][UserPreferenceDataModel.DataColumns.UserPreferenceKeyId]); data.DataTypeId = Convert.ToInt32(dt.Rows[0][UserPreferenceDataModel.DataColumns.DataTypeId]); data.Value = Convert.ToString(drpCountry.SelectedValue); data.ApplicationUserId = SessionVariables.RequestProfile.AuditId; data.ApplicationId = SessionVariables.RequestProfile.ApplicationId; UserPreferenceDataManager.Update(data, SessionVariables.RequestProfile); } } else { data.UserPreferenceCategoryId = 1; data.UserPreferenceKeyId = UserCountryKeyId; data.Value = Convert.ToString(drpCountry.SelectedValue); data.ApplicationUserId = SessionVariables.RequestProfile.AuditId; data.DataTypeId = UserCountryDataTypeId; data.ApplicationId = SessionVariables.RequestProfile.ApplicationId; UserPreferenceDataManager.Create(data, SessionVariables.RequestProfile); } var dataCountry = new CountryDataModel(); dataCountry.CountryId = Convert.ToInt32(drpCountry.SelectedValue); var dtCountry = Framework.Components.Core.CountryDataManager.Search(dataCountry, SessionVariables.RequestProfile); if (dtCountry.Rows.Count > 0) { var timeZoneId = Convert.ToInt32(dtCountry.Rows[0][CountryDataModel.DataColumns.TimeZoneId]); var dataKey = new UserPreferenceKeyDataModel(); dataKey.Name = "UserTimeZone"; var dtKeys = Framework.Components.UserPreference.UserPreferenceKeyDataManager.Search(dataKey, SessionVariables.RequestProfile); if (dtKeys != null && dtKeys.Rows.Count > 0) { var keyId = Convert.ToInt32(dtKeys.Rows[0][UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId]); var dataTypeId = Convert.ToInt32(dtKeys.Rows[0][UserPreferenceKeyDataModel.DataColumns.DataTypeId]); data = new UserPreferenceDataModel(); data.UserPreferenceKeyId = keyId; var dt = UserPreferenceDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count > 0) { data.Value = Convert.ToString(timeZoneId); data.UserPreferenceCategoryId = Convert.ToInt32(dt.Rows[0][UserPreferenceDataModel.DataColumns.UserPreferenceCategoryId]); data.UserPreferenceId = Convert.ToInt32(dt.Rows[0][UserPreferenceDataModel.DataColumns.UserPreferenceId]); data.DataTypeId = Convert.ToInt32(dt.Rows[0][UserPreferenceDataModel.DataColumns.DataTypeId]); data.ApplicationUserId = SessionVariables.RequestProfile.AuditId; data.ApplicationId = SessionVariables.RequestProfile.ApplicationId; UserPreferenceDataManager.Update(data, SessionVariables.RequestProfile); } else { data.Value = Convert.ToString(timeZoneId); data.DataTypeId = dataTypeId; data.UserPreferenceKeyId = keyId; data.UserPreferenceCategoryId = 1; data.ApplicationUserId = SessionVariables.RequestProfile.AuditId; data.ApplicationId = SessionVariables.RequestProfile.ApplicationId; UserPreferenceDataManager.Create(data, SessionVariables.RequestProfile); } } } } }