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);
}
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);
}
protected override DataTable GetData()
{
var dt = UserPreferenceDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile);
if (!string.IsNullOrEmpty(oSearchFilter.CategoryLIKE))
{
var dv = dt.DefaultView;
var categorylike = oSearchFilter.CategoryLIKE;
if (!categorylike.EndsWith("%"))
{
categorylike = categorylike + "%";
}
dv.RowFilter = "UserPreferenceCategory LIKE '" + categorylike + "'";
return(dv.ToTable());
}
return(dt);
}
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);
}
}
}
}
}
