public void LoadData(int userPreferenceKeyId) { var oData = new UserPreferenceKeyDataModel(); oData.UserPreferenceKeyId = userPreferenceKeyId; var items = UserPreferenceKeyDataManager.GetEntityDetails(oData, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; txtUserPreferenceKeyId.Text = Convert.ToString(item.UserPreferenceKeyId); txtName.Text = Convert.ToString(item.Name); txtValue.Text = Convert.ToString(item.Value); txtDataTypeId.Text = Convert.ToString(item.DataTypeId); txtDescription.InnerText = Convert.ToString(item.Description); txtSortOrder.Text = Convert.ToString(item.SortOrder); drpDataTypeList.SelectedValue = Convert.ToString(item.DataTypeId); oHistoryList.Setup(PrimaryEntity, userPreferenceKeyId, PrimaryEntityKey); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); } else { txtUserPreferenceKeyId.Text = String.Empty; txtName.Text = String.Empty; txtValue.Text = String.Empty; txtDataTypeId.Text = String.Empty; txtDescription.InnerText = String.Empty; txtSortOrder.Text = String.Empty; } }
public static DataTable GetDetailsByApplication(UserPreferenceKeyDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.UserPreferenceKeySearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = dataQuery.ApplicationId , UserPreferenceKeyId = dataQuery.UserPreferenceKeyId , Name = dataQuery.Name , ReturnAuditInfo = returnAuditInfo , DataTypeId = dataQuery.DataTypeId }; List <UserPreferenceKeyDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <UserPreferenceKeyDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } var table = result.ToDataTable(); return(table); }
protected override void ShowData(int userPreferenceKeyId) { oDetailButtonPanel.SetId = SetId; var data = new UserPreferenceKeyDataModel(); data.UserPreferenceKeyId = userPreferenceKeyId; var items = UserPreferenceKeyDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; lblUserPreferenceKeyId.Text = Convert.ToString(item.UserPreferenceKeyId); lblDataTypeId.Text = Convert.ToString(item.DataTypeId); lblName.Text = Convert.ToString(item.Name); lblValue.Text = Convert.ToString(item.Value); lblDescription.Text = Convert.ToString(item.Description); lblSortOrder.Text = Convert.ToString(item.SortOrder); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, userPreferenceKeyId, "UserPreferenceKey"); } else { Clear(); } }
public static int?GetUserTimeZone(int applicationUserId, RequestProfile requestProfile) { var dataKey = new UserPreferenceKeyDataModel(); dataKey.Name = "UserTimeZone"; var dtKeys = UserPreferenceKeyDataManager.Search(dataKey, requestProfile); if (dtKeys != null && dtKeys.Rows.Count > 0) { var keyId = Convert.ToInt32(dtKeys.Rows[0][UserPreferenceDataModel.DataColumns.UserPreferenceKeyId]); var data = new UserPreferenceDataModel(); data.ApplicationUserId = applicationUserId; data.UserPreferenceKeyId = keyId; var dt = Search(data, requestProfile); if (dt.Rows.Count > 0) { return(Convert.ToInt32(dt.Rows[0][UserPreferenceDataModel.DataColumns.Value])); } } return(null); }
private static string Save(UserPreferenceKeyDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.UserPreferenceKeyInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.UserPreferenceKeyUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Name) + ", " + ToSQLParameter(data, UserPreferenceKeyDataModel.DataColumns.Value) + ", " + ToSQLParameter(data, UserPreferenceKeyDataModel.DataColumns.DataTypeId) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Description) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.SortOrder); return(sql); }
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]); } } }
public static List <UserPreferenceKeyDataModel> GetUserPreferenceKeyList(RequestProfile requestProfile) { var sql = "EXEC dbo.UserPreferenceKeySearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); var result = new List <UserPreferenceKeyDataModel>(); using (var reader = new DBDataReader("Get List", sql, DataStoreKey)) { var dbReader = reader.DBReader; while (dbReader.Read()) { var dataItem = new UserPreferenceKeyDataModel(); dataItem.UserPreferenceKeyId = (int)dbReader[UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId]; dataItem.Name = dbReader[StandardDataModel.StandardDataColumns.Name].ToString(); dataItem.Description = dbReader[StandardDataModel.StandardDataColumns.Description].ToString(); dataItem.SortOrder = (int)dbReader[StandardDataModel.StandardDataColumns.SortOrder]; result.Add(dataItem); } } return(result); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new UserPreferenceKeyDataModel(); var dt = Framework.Components.UserPreference.UserPreferenceKeyDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
public static DataTable Search(UserPreferenceKeyDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
public static string ToSQLParameter(UserPreferenceKeyDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId: if (data.UserPreferenceKeyId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId, data.UserPreferenceKeyId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId); } break; case UserPreferenceKeyDataModel.DataColumns.Value: if (!string.IsNullOrEmpty(data.Value)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UserPreferenceKeyDataModel.DataColumns.Value, data.Value); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserPreferenceKeyDataModel.DataColumns.Value); } break; case UserPreferenceKeyDataModel.DataColumns.DataTypeId: if (data.DataTypeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UserPreferenceKeyDataModel.DataColumns.DataTypeId, data.DataTypeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserPreferenceKeyDataModel.DataColumns.DataTypeId); } break; case UserPreferenceKeyDataModel.DataColumns.DataType: if (!string.IsNullOrEmpty(data.DataType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UserPreferenceKeyDataModel.DataColumns.DataType, data.DataType); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UserPreferenceKeyDataModel.DataColumns.DataType); } break; default: returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
private DataTable GetData(string name) { var data = new UserPreferenceKeyDataModel(); data.Name = name; var dt = UserPreferenceKeyDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
private static DataSet GetChildren(UserPreferenceKeyDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.UserPreferenceKeyChildrenGet " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId); var oDT = new DBDataSet("Get Children", sql, DataStoreKey); return(oDT.DBDataset); }
public static bool DoesExist(UserPreferenceKeyDataModel data, RequestProfile requestProfile) { var doesExistRequest = new UserPreferenceKeyDataModel(); doesExistRequest.Name = data.Name; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
protected override void Clear() { base.Clear(); var data = new UserPreferenceKeyDataModel(); UserPreferenceKeyId = data.UserPreferenceKeyId; Name = data.Name; Description = data.Description; SortOrder = data.SortOrder; DataTypeId = data.DataTypeId; Value = data.Value; }
public static void Delete(UserPreferenceKeyDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.UserPreferenceKeyDelete "; var parameters = new { AuditId = requestProfile.AuditId , UserPreferenceKeyId = data.UserPreferenceKeyId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public static void Sync(int newApplicationId, int oldApplicationId, RequestProfile requestProfile) { // get all records for old Application Id var sql = "EXEC dbo.UserPreferenceKeySearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, oldApplicationId); var oDT = new DBDataTable("UserPreferenceKey.Search", sql, DataStoreKey); // formaulate a new request Profile which will have new Applicationid var newRequestProfile = new RequestProfile(); newRequestProfile.ApplicationId = newApplicationId; newRequestProfile.AuditId = requestProfile.AuditId; var dataTypedata = new UserPreferenceDataTypeDataModel(); var dataTypeList = UserPreferenceDataTypeDataManager.GetEntityDetails(dataTypedata, newRequestProfile); foreach (DataRow dr in oDT.DBTable.Rows) { var data = new UserPreferenceKeyDataModel(); data.ApplicationId = newApplicationId; data.Name = dr[StandardDataModel.StandardDataColumns.Name].ToString(); // check for existing record in new Application Id if (!DoesExist(data, newRequestProfile)) { var dataType = dr[UserPreferenceKeyDataModel.DataColumns.DataType].ToString(); //get new fc mode id based on fc mode name var newDataTypeId = dataTypeList.Find(x => x.Name == dataType).UserPreferenceDataTypeId; data.Description = dr[StandardDataModel.StandardDataColumns.Description].ToString(); data.Value = dr[UserPreferenceKeyDataModel.DataColumns.Value].ToString(); if (string.IsNullOrEmpty(data.Value)) { data.Value = " "; } data.DataTypeId = newDataTypeId; data.SortOrder = Convert.ToInt32(dr[StandardDataModel.StandardDataColumns.SortOrder]); //create in new application id Create(data, newRequestProfile); } } }
protected void btnDelete_Click(object sender, EventArgs e) { try { var notDeletableIds = new List <int>(); string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new UserPreferenceKeyDataModel(); data.UserPreferenceKeyId = int.Parse(index); if (!Framework.Components.UserPreference.UserPreferenceKeyDataManager.IsDeletable(data, SessionVariables.RequestProfile)) { notDeletableIds.Add(Convert.ToInt32(data.UserPreferenceKeyId)); } } if (notDeletableIds.Count == 0) { foreach (string index in deleteIndexList) { var data = new UserPreferenceKeyDataModel(); data.UserPreferenceKeyId = int.Parse(index); Framework.Components.UserPreference.UserPreferenceKeyDataManager.Delete(data, SessionVariables.RequestProfile); } Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.UserPreferenceKey, SessionVariables.RequestProfile); Response.Redirect(Page.GetRouteUrl("UserPreferenceKeyEntityRoute", new { Action = "Default", SetId = true }), false); } else { var msg = String.Empty; foreach (var id in notDeletableIds) { if (!string.IsNullOrEmpty(msg)) { msg += ", <br/>"; } msg += "UserPreferenceKeyId: " + id + " has detail records"; } Response.Write(msg); } } catch (Exception ex) { Response.Write(ex.Message); } }
public static bool IsDeletable(UserPreferenceKeyDataModel data, RequestProfile requestProfile) { var isDeletable = true; var ds = GetChildren(data, requestProfile); if (ds != null && ds.Tables.Count > 0) { foreach (DataTable dt in ds.Tables) { if (dt.Rows.Count > 0) { isDeletable = false; break; } } } return(isDeletable); }
public void LoadData(int userPreferenceKeyId, bool showId) { // clear UI Clear(); // set up parameters var data = new UserPreferenceKeyDataModel(); data.UserPreferenceKeyId = userPreferenceKeyId; // get data var items = UserPreferenceKeyDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; txtValue.Text = Convert.ToString(item.Value); txtDataTypeId.Text = Convert.ToString(item.DataTypeId); txtDescription.InnerText = item.Description; txtName.Text = item.Name; txtSortOrder.Text = item.SortOrder.ToString(); if (!showId) { txtUserPreferenceKeyId.Text = item.UserPreferenceKeyId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, userPreferenceKeyId, PrimaryEntityKey); } else { txtUserPreferenceKeyId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
public static UserPreferenceKeyDataModel GetDetails(UserPreferenceKeyDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }
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); } } } } }
public static void Update(UserPreferenceKeyDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("UserPreferenceKey.Update", sql, DataStoreKey); }