public static List <PageDataModel> GetBlogPages() { List <PageDataModel> pages = new List <PageDataModel>(); MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("GetBlogPages", connection); DataTable results = new DataTable(); adapter.Fill(results); foreach (DataRow item in results.Rows) { PageDataModel page = new PageDataModel(); page.ID = Convert.ToInt32(item["ID"]); page.Name = Convert.ToString(item["Name"]); page.Content = Convert.ToString(item["Content"]); page.FeaturedImage = Convert.ToString(item["FeaturedImage"]); page.MainImage = Convert.ToString(item["MainImage"]); if (item["Blog"].GetType() != typeof(DBNull)) { page.Blog = Convert.ToBoolean(item["Blog"]); } page.Metakeywords = Convert.ToString(item["Metakeywords"]); page.MetaDescription = Convert.ToString(item["MetaDescription"]); pages.Add(page); } return(pages); }
public IActionResult Dynamic() { dataModel = new PageDataModel(); var countryData = Integration.GetDropdownValues(2020); if (countryData.Status) { dataModel.Country = countryData.Result; } else { ViewBag.CountryError = countryData.Message; } var paymenyData = Integration.GetDropdownValues(17055); if (paymenyData.Status) { dataModel.PaymentMethods = paymenyData.Result; } else { ViewBag.CountryError = paymenyData.Message; } return(View(dataModel)); }
public ActionResult MyClubsData(int page, int limit) { List <UserClubModel> datas = new List <UserClubModel>(); foreach (UserClubs uc in db.UserClubs.Where(u => u.User.UserId == User.Identity.Name && u.State < (int)EnumState.已失效).OrderBy(c => c.Id).Skip((page - 1) * limit).Take(limit).ToList()) { UserClubModel data = new UserClubModel() { Id = uc.Id, UserId = uc.User.UserId, User = uc.User.UserName, ClubId = uc.Club.ClubId, Club = uc.Club.Name, Status = Enum.GetName(typeof(UCStatus), uc.Status), CreateDate = uc.CreateDate == null ? "未知" : uc.CreateDate.ToString(), Desc = uc.Desc, Enable = uc.State, state = uc.Club.State ?? 0 }; data.CState = Enum.GetName(typeof(EnumState), uc.Club.State); datas.Add(data); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = db.UserClubs.Where(u => u.User.UserId == User.Identity.Name).Count(), data = datas.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
public ActionResult GetNoticeListData(int page) { int count = 6;//单页显示数量 IQueryable <Notice> notices = db.Notices.OrderByDescending(a => a.Id).Skip((page - 1) * count).Take(count); List <NoticeView> models = new List <NoticeView>(); foreach (Notice n in notices) { NoticeView nv = new NoticeView { Id = n.Id, type = n.type, Title1 = n.Title1, Content = n.Content, CreateDate = n.CreateDate.ToLongDateString(), }; models.Add(nv); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = (int)Math.Ceiling((double)db.Notices.Count() / count), data = models.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
//查询社团调用 public ActionResult GetAllClubData(int page, int limit) { List <ClubListModel> datas = new List <ClubListModel>(); foreach (ClubNumber club in db.ClubNumbers.Where(c => c.State > (int)EnumState.待审批).OrderBy(c => c.ClubId).Skip((page - 1) * limit).Take(limit).ToList()) { ClubListModel data = new ClubListModel() { cid = club.ClubId, name = club.Name ?? "无", Desc = club.Desc ?? "无", CreateDate = club.CreateDate2?.ToString(), CreateUser = club.User?.UserId, CreateUserName = club.User?.UserName }; datas.Add(data); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = db.Users.Count(), data = datas.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
public ActionResult GetActiveListData2(int page, int limit, string cid) { List <ActiveListModel> models = new List <ActiveListModel>(); IQueryable <Activities> actlist; if (string.IsNullOrEmpty(cid)) { actlist = db.Activities.OrderByDescending(a => a.Id).Skip((page - 1) * limit).Take(limit); } else { actlist = db.Activities.Where(a => a.Club.ClubId == cid).OrderByDescending(a => a.Id).Skip((page - 1) * limit).Take(limit); } foreach (Activities act in actlist) { ActiveListModel model = new ActiveListModel() { Id = act.Id, Title1 = act.Title1, Title2 = act.Title2, Time1 = act.Time1.ToString("yyyy/MM/dd hh:mm"), Time2 = act.Time2.ToString("yyyy/MM/dd hh:mm"), CreateDate = act.CreateDate.ToString(), UserID = act.User.UserId, UserName = act.User.UserName, VoteCount = db.Votings.Where(v => v.Active.Id == act.Id).Count().ToString(), State = Enum.GetName(typeof(ActiveState), act.State), Votes0 = string.IsNullOrEmpty(act.Votes0) ? "0" : act.Votes0 }; if (act.State > (int)ActiveState.已取消) { if (act.Time1 > DateTime.Now) { model.State = "未开始"; } else if (act.Time2 > DateTime.Now) { model.State = "进行中"; } else { model.State = "已结束"; } } models.Add(model); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = db.Activities.Count(), data = models.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 分页查询 /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <returns></returns> public ActionResult UserList(int currentPage, int pageSize) { var users = UserManager.Users.Skip(currentPage).Take(pageSize).ToList(); PageDataModel <TUser> dataList = new PageDataModel <TUser>(); dataList.DataList = users; dataList.PageNum = currentPage; dataList.PageSize = pageSize; dataList.RecordCount = UserManager.Users.Count(); return(View(dataList)); }
public static void Create(PageDataModel page) { if (page.fileFeaturedImage != null) { page.FeaturedImage = FileManager.SaveFile(page.fileFeaturedImage); } if (page.fileMainImage != null) { page.MainImage = FileManager.SaveFile(page.fileMainImage); } PageDAL.Create(page); }
public PageDataModel <OrderDataModel> GetOrdersPage(DataFilterBase filter) { var count = _dbContext.Orders.Count(); var orders = _dbContext.Orders .AsNoTracking() .OrderByDescending(o => o.CreatedDateTime) .Skip(filter.Skip) .Take(filter.Take) .ToList(); var result = new PageDataModel <OrderDataModel>(count, orders); return(result); }
public IPageDataModel CreatePageDataModel() { IPageDataModel Data = new PageDataModel(); Schools currentSchools = GetCurrentSchools(); CreateHeader(Data, TitleMessage); StatusMessage = $" Start {CurrentIndex} of {MaxIndex}"; CreateDataContentStrings(Data, currentSchools, currentSchools.schools.Length); return(Data); }
public ActionResult PageData(int page, int limit) { var userdata = db.UserNumbers.OrderBy(u => u.UserId).Skip((page - 1) * limit).Take(limit); PageDataModel model = new PageDataModel() { code = 0, msg = "", count = db.UserNumbers.Count(), data = userdata }; return(Json(model, JsonRequestBehavior.AllowGet)); }
string getKey(int i, string KEY_FIELD_NAME, string DATASOURCE_NAME, PageDataModel pageModel, EntityRecord record) { string key = ""; if (KEY_FIELD_NAME.Contains("$")) { key = pageModel.GetProperty(DATASOURCE_NAME + "[" + i + "]." + KEY_FIELD_NAME).ToString(); } else { key = record[KEY_FIELD_NAME].ToString(); } return(key); }
string getValue(int i, string VALUE_FIELD_NAME, string DATASOURCE_NAME, PageDataModel pageModel, EntityRecord record) { string value = ""; if (VALUE_FIELD_NAME.Contains("$")) { value = pageModel.GetProperty(DATASOURCE_NAME + "[" + i + "]." + VALUE_FIELD_NAME).ToString(); } else { value = record[VALUE_FIELD_NAME].ToString(); } return(value); }
public IPageDataModel CreatePageDataModel(int nextIndex) { IPageDataModel Data = new PageDataModel(); Schools currentSchools = GetCurrentSchools(nextIndex); CreateHeader(Data, TitleMessage); StatusMessage = $" Start {CurrentIndex} of {MaxIndex}"; int count = GetCount(currentSchools, MaxIndexPerPage); CreateDataContentStrings(Data, currentSchools, count); return(Data); }
public static void Update(PageDataModel page) { MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("UpdatePage", connection); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; MySqlParameter paramID = new MySqlParameter("pID", page.ID); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramID); MySqlParameter paramName = new MySqlParameter("pName", page.Name); paramName.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramName); MySqlParameter paramContent = new MySqlParameter("pContent", page.Content); paramContent.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramContent); MySqlParameter paramFeaturedImage = new MySqlParameter("pFeaturedImage", page.FeaturedImage); paramFeaturedImage.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramFeaturedImage); MySqlParameter paramMainImage = new MySqlParameter("pMainImage", page.MainImage); paramMainImage.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramMainImage); MySqlParameter paramBlog = new MySqlParameter("pBlog", page.Blog); paramBlog.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramBlog); MySqlParameter paramMetakeywords = new MySqlParameter("pMetakeywords", page.Metakeywords); paramMetakeywords.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramMetakeywords); MySqlParameter paramMetaDescription = new MySqlParameter("pMetaDescription", page.MetaDescription); paramMetaDescription.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramMetaDescription); DataTable results = new DataTable(); adapter.Fill(results); }
public PageDataModel <CountryDataModel> GetCountriesPage(CountryDataFilter filter) { var filteredCountries = _dbContext.Countries .Include(t => t.CountryImages) .OrderBy(t => t.Category) .ThenBy(t => t.Name) .Where(t => string.IsNullOrWhiteSpace(filter.TourType) || t.Category == filter.TourType); var count = filteredCountries.Count(); var pageCollection = filteredCountries .Skip(filter.Skip) .Take(filter.Take) .AsNoTracking() .ToList(); var result = new PageDataModel <CountryDataModel>(count, pageCollection); return(result); }
public List <PageDataModel> Convert(List <PageData> pageDataList) { List <PageDataModel> list = new List <PageDataModel>(); foreach (var page in pageDataList) { PageDataModel model = new PageDataModel(); model.angle = page.Angle; model.height = page.Height; model.isVisible = page.IsVisible; model.name = page.Name; model.number = page.Number; model.rows = page.Rows; model.width = page.Width; list.Add(model); } return(list); }
// GET: GetData 获取已注册用户,权限控制页面调用 public async Task <ActionResult> UserSimpleData(int page, int limit) { List <UserSimpleModel> datas = new List <UserSimpleModel>(); foreach (AppUser us in db.Users.OrderBy(u => u.Id).Skip((page - 1) * limit).Take(limit).ToList()) { UserSimpleModel data = new UserSimpleModel() { id = us.UserName, name = us.Email, ifup = true, }; if (us.Roles.Count > 0) { foreach (Microsoft.AspNet.Identity.EntityFramework.IdentityUserRole userrole in us.Roles) { var role = await RoleManager.FindByIdAsync(userrole.RoleId); data.roles += role.Name + "/"; if (role.Name == "BAdmin") { data.ifup = false; } } data.roles = data.roles.Substring(0, data.roles.Length - 1); } else { data.roles = "无"; } datas.Add(data); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = db.Users.Count(), data = datas.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
public static void Update(PageDataModel page) { if (page.ID > 0) { if (page.fileFeaturedImage != null) { page.FeaturedImage = FileManager.SaveFile(page.fileFeaturedImage); } if (page.fileMainImage != null) { page.MainImage = FileManager.SaveFile(page.fileMainImage); } PageDAL.Update(page); } else { throw new Exception("Page not found"); } }
public ActionResult GetApplyData(int page, int limit, string state) { List <ApplyAudit> models = new List <ApplyAudit>(); int st = 0; if (!string.IsNullOrEmpty(state) && int.TryParse(state, out st)) { models = db.ApplyAudits.Where(a => a.Type.Id == (int)SQType.创建活动 && a.CheckState == st).OrderBy(a => a.Id).ToList(); } else { models = db.ApplyAudits.Where(a => a.Type.Id == (int)SQType.创建活动).OrderBy(a => a.Id).ToList(); } List <ApplyView> datas = new List <ApplyView>(); foreach (ApplyAudit applys in models) { ApplyView apply = new ApplyView { Id = applys.Id.ToString(), Type = applys.Type.Name, Club = applys.Club?.Name, ApplyUser = applys.ApplyUser.UserName, CheckState = Enum.GetName(typeof(EnumAuditState), applys.CheckState), ApplyDate = applys.ApplyDate.ToString(), AuditDate = applys.AuditDate.ToString(), AuditTimes = applys.AuditTimes ?? 0 }; datas.Add(apply); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = models.Count(), data = datas.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
//获取所有账号池 public ActionResult UserNumberData(int page, int limit) { List <UserNumberModel> datas = new List <UserNumberModel>(); foreach (UserNumber us in db.UserNumbers.OrderBy(u => u.UserId).Skip((page - 1) * limit).Take(limit).ToList()) { UserNumberModel data = new UserNumberModel() { id = us.UserId, relname = us.RelName ?? "无", state = Enum.GetName(typeof(EnumState), us.State) }; datas.Add(data); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = db.UserNumbers.Count(), data = datas.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
public static PageDataModel Get(int id) { PageDataModel page = null; MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("GetPageByID", connection); MySqlParameter paramID = new MySqlParameter("pId", id); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.CommandType = CommandType.StoredProcedure; adapter.SelectCommand.Parameters.Add(paramID); DataTable results = new DataTable(); adapter.Fill(results); if (results.Rows.Count > 0) { DataRow item = results.Rows[0]; page = new PageDataModel(); page.ID = Convert.ToInt32(item["ID"]); page.Name = Convert.ToString(item["Name"]); page.Content = Convert.ToString(item["Content"]); page.FeaturedImage = Convert.ToString(item["FeaturedImage"]); page.MainImage = Convert.ToString(item["MainImage"]); if (item["Blog"].GetType() != typeof(DBNull)) { page.Blog = Convert.ToBoolean(item["Blog"]); } page.Metakeywords = Convert.ToString(item["Metakeywords"]); page.MetaDescription = Convert.ToString(item["MetaDescription"]); } return(page); }
public ActionResult Create(PageDataModel page) { PageBO.Create(page); return(RedirectToAction("Index")); }
public ActionResult ClubsNumberData(int page, int limit) { List <ClubsNumberModel> models = new List <ClubsNumberModel>(); foreach (ClubNumber club in db.ClubNumbers.OrderBy(c => c.ClubId).Skip((page - 1) * limit).Take(limit)) { ClubsNumberModel model = new ClubsNumberModel(); model.ClubId = club.ClubId; switch (club.State) { case ((int)EnumState.未使用): model.State = Enum.GetName(typeof(EnumState), club.State); model.Style = "black"; break; case ((int)EnumState.系统锁定): model.State = Enum.GetName(typeof(EnumState), club.State); model.Style = "gray"; break; case ((int)EnumState.待提交): model.State = Enum.GetName(typeof(EnumState), club.State); model.Style = "red"; break; case ((int)EnumState.正常): model.State = Enum.GetName(typeof(EnumState), club.State); model.Style = "green"; break; case ((int)EnumState.待审批): model.State = Enum.GetName(typeof(EnumState), club.State); model.Style = "orange"; break; case ((int)EnumState.查封): model.State = Enum.GetName(typeof(EnumState), club.State); model.Style = "pink"; break; case ((int)EnumState.冻结): model.State = Enum.GetName(typeof(EnumState), club.State); model.Style = "bule"; break; case ((int)EnumState.制裁): model.State = Enum.GetName(typeof(EnumState), club.State); model.Style = "red"; break; default: model.State = "未知"; model.Style = "yellow"; break; } model.CreateDate = club.CreateDate == null ? "无" : club.CreateDate.ToString(); models.Add(model); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = db.ClubNumbers.Count(), data = models.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
public ActionResult GetActiveListData(int page, string cid) { int count = 6;//单页显示数量 List <ActiveListModel> models = new List <ActiveListModel>(); IQueryable <Activities> actlist; if (string.IsNullOrEmpty(cid)) { actlist = db.Activities.Where(a => a.State > 2).OrderByDescending(a => a.Id).Skip((page - 1) * count).Take(count); } else { actlist = db.Activities.Where(a => a.Club.ClubId == cid).OrderByDescending(a => a.Id).Skip((page - 1) * count).Take(count); } foreach (Activities act in actlist) { ActiveListModel model = new ActiveListModel() { Id = act.Id, Labels = act.Label.Split(',').ToList(), HeadImg = act.Club.HeadImg, Title1 = act.Title1, Title2 = act.Title2, Content = act.Content, MaxUser = act.MaxUser, Area1 = act.Area?.Name, Time1 = act.Time1.ToString("yyyy/MM/dd hh:mm"), Time2 = act.Time2.ToString("yyyy/MM/dd hh:mm"), CreateDate = act.CreateDate.ToString(), UserID = act.User.UserId, UserName = act.User.UserName, ClubID = act.Club.ClubId, ClubName = act.Club.Name, VoteCount = db.Votings.Where(v => v.Active.Id == act.Id).Count().ToString(), // State = Enum.GetName(typeof(ActiveState), act.State), Votes0 = string.IsNullOrEmpty(act.Votes0)?"0":act.Votes0 }; if (act.Time1 > DateTime.Now) { model.State = "未开始"; } else if (act.Time2 > DateTime.Now) { model.State = "进行中"; } else { model.State = "已结束"; } if (act.Area == null) { if (string.IsNullOrEmpty(act.Area0)) { model.Area1 = "未知"; } else { model.Area1 = act.Area0; } } models.Add(model); } PageDataModel dataModel = new PageDataModel() { code = 0, msg = "", count = (int)Math.Ceiling((double)db.Activities.Count() / count), data = models.AsQueryable() }; return(Json(dataModel, JsonRequestBehavior.AllowGet)); }
public override object Execute(Dictionary <string, object> arguments) { var result = new List <SelectOption>(); //if pageModel is not provided, returns empty List<SelectOption>() if (arguments.ContainsKey("PageModel") && arguments.ContainsKey("DataSourceName") && !string.IsNullOrWhiteSpace((string)arguments["DataSourceName"])) { //replace constants with your values string DATASOURCE_NAME = (string)arguments["DataSourceName"]; string KEY_FIELD_NAME = (string)arguments["KeyPropName"]; string VALUE_FIELD_NAME = (string)arguments["ValuePropName"]; string VALUE_FIELD_NAME1 = (string)arguments["Value1PropName"]; string VALUE_FIELD_NAME2 = (string)arguments["Value2PropName"]; string ICON_CLASS_FIELD_NAME = (string)arguments["IconClassPropName"]; string COLOR_FIELD_NAME = (string)arguments["ColorPropName"]; string SORT_ORDER_FIELD_NAME = (string)arguments["SortOrderPropName"]; string SORT_TYPE_NAME = (string)arguments["SortTypePropName"]; PageDataModel pageModel = arguments["PageModel"] as PageDataModel; if (pageModel == null) { return(result); } try { //try read data source by name and get result as specified type object var dataSource = pageModel.GetProperty(DATASOURCE_NAME); //if data source not found or different type, return empty List<SelectOption>() if (dataSource == null) { return(result); } if (dataSource is List <EntityRecord> ) { var recordsList = (List <EntityRecord>)dataSource; if (!String.IsNullOrWhiteSpace(SORT_ORDER_FIELD_NAME) && recordsList.Count > 1 && recordsList[0].Properties.ContainsKey(SORT_ORDER_FIELD_NAME) && recordsList[0][SORT_ORDER_FIELD_NAME] != null) { bool isDecimal = false; if (decimal.TryParse((recordsList[0][SORT_ORDER_FIELD_NAME] ?? "").ToString(), out decimal outDecimal)) { isDecimal = true; } if (SORT_TYPE_NAME.ToLowerInvariant() == "desc") { if (isDecimal) { dataSource = recordsList.OrderByDescending(x => (decimal?)x[SORT_ORDER_FIELD_NAME]).ToList(); } else { dataSource = recordsList.OrderByDescending(x => (string)x[SORT_ORDER_FIELD_NAME]).ToList(); } } else { if (isDecimal) { dataSource = recordsList.OrderBy(x => (decimal?)x[SORT_ORDER_FIELD_NAME]).ToList(); } else { dataSource = recordsList.OrderBy(x => (string)x[SORT_ORDER_FIELD_NAME]).ToList(); } } } int i = 0; foreach (var record in (List <EntityRecord>)dataSource) { if (record.Properties.ContainsKey(ICON_CLASS_FIELD_NAME) && record[ICON_CLASS_FIELD_NAME] != null) { var color = "#999"; if (record.Properties.ContainsKey(COLOR_FIELD_NAME) && record[COLOR_FIELD_NAME] != null) { color = record[COLOR_FIELD_NAME].ToString(); } var key = getKey(i, KEY_FIELD_NAME, DATASOURCE_NAME, pageModel, record); var value = getValue(i, VALUE_FIELD_NAME, DATASOURCE_NAME, pageModel, record); if (VALUE_FIELD_NAME1 == "label1") { result.Add(new SelectOption(key.ToString(), value.ToString(), record[ICON_CLASS_FIELD_NAME].ToString(), color)); } else if (VALUE_FIELD_NAME2 == "label2") { var value1 = getValue(i, VALUE_FIELD_NAME1, DATASOURCE_NAME, pageModel, record); result.Add(new SelectOption(key, "" + value + " - " + Environment.NewLine + "" + value1, record[ICON_CLASS_FIELD_NAME].ToString(), color)); } else { var value1 = getValue(i, VALUE_FIELD_NAME1, DATASOURCE_NAME, pageModel, record); var value2 = getValue(i, VALUE_FIELD_NAME2, DATASOURCE_NAME, pageModel, record); result.Add(new SelectOption(key, "" + value + " - " + Environment.NewLine + "" + value1 + " - " + value2 + "", record[ICON_CLASS_FIELD_NAME].ToString(), color)); } //if (!record.Properties.ContainsKey(VALUE_FIELD_NAME1) || VALUE_FIELD_NAME1 == null) //{ // result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), record[VALUE_FIELD_NAME].ToString(), record[ICON_CLASS_FIELD_NAME].ToString(), color)); //} //else if (VALUE_FIELD_NAME1 == null) //{ // result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), "" + record[VALUE_FIELD_NAME].ToString() + " - " + Environment.NewLine + // "" + record[VALUE_FIELD_NAME1].ToString(), record[ICON_CLASS_FIELD_NAME].ToString(), color)); //} //else //{ // result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), "" + record[VALUE_FIELD_NAME].ToString() + " - " + Environment.NewLine + // "" + record[VALUE_FIELD_NAME1].ToString() + " - " + record[VALUE_FIELD_NAME2].ToString() + "", record[ICON_CLASS_FIELD_NAME].ToString(), color)); //} } else { var key = getKey(i, KEY_FIELD_NAME, DATASOURCE_NAME, pageModel, record); var value = getValue(i, VALUE_FIELD_NAME, DATASOURCE_NAME, pageModel, record); if (VALUE_FIELD_NAME1 == "label1") { result.Add(new SelectOption(key.ToString(), value.ToString())); } else if (VALUE_FIELD_NAME2 == "label2") { var value1 = getValue(i, VALUE_FIELD_NAME1, DATASOURCE_NAME, pageModel, record); result.Add(new SelectOption(key, "" + value + " - " + Environment.NewLine + "" + value1)); } else { var value1 = getValue(i, VALUE_FIELD_NAME1, DATASOURCE_NAME, pageModel, record); var value2 = getValue(i, VALUE_FIELD_NAME2, DATASOURCE_NAME, pageModel, record); result.Add(new SelectOption(key, "" + value + " - " + Environment.NewLine + "" + value1 + " - " + value2 + "")); } } i++; } } else if (dataSource is EntityRecord) { var record = (EntityRecord)dataSource; if (record.Properties.ContainsKey(ICON_CLASS_FIELD_NAME) && record[ICON_CLASS_FIELD_NAME] != null) { var color = "#999"; if (record.Properties.ContainsKey(COLOR_FIELD_NAME) && record[COLOR_FIELD_NAME] != null) { color = record[COLOR_FIELD_NAME].ToString(); } result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), record[VALUE_FIELD_NAME].ToString(), record[ICON_CLASS_FIELD_NAME].ToString(), color)); } else { result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), record[VALUE_FIELD_NAME].ToString())); } } else { throw new Exception("Input Datasource value should be of type List<EntityRecord> or EntityRecord"); } } catch (PropertyDoesNotExistException) { } } return(result); }
public ActionResult Edit(PageDataModel page) { PageBO.Update(page); return(RedirectToAction("Index")); }
public IPageDataModel CreatePageDataModel() { IPageDataModel Data = new PageDataModel(); // First setup field AddField("Performance", 36); AddField("Update", 10); AddField("Read", 8); AddField("Read2", 8); Data.Title = TitleMessage; Data.HasMessage = false; // Make header Data.Header = MakeHeader(); Data.HasHeader = true; Task.Run(async() => { HttpClient http = GetHttplClient(HtmlClientApi); currentPerf = await http.GetFromJsonAsync <PerformanceRecord>("SchoolPerformance"); }).Wait(); if (currentPerf != null) { // Create content Data.HasContent = true; Data.ContentFontSize = 24; Data.Content = new string[11]; List <string> strings = new List <string> { "Initialize Performance", "", currentPerf.InitPerformance.ToString() }; string str = MakeContent(strings); Data.Content[0] = str; strings = new List <string> { "Json Performance", "", currentPerf.JsonPerformance.ToString(), currentPerf.JsonPerformance2.ToString() }; str = MakeContent(strings); Data.Content[1] = str; strings = new List <string> { "Dapper Performance", currentPerf.DapperUpdatePerformance.ToString(), currentPerf.DapperPerformance.ToString(), currentPerf.DapperPerformance2.ToString() }; str = MakeContent(strings); Data.Content[2] = str; strings = new List <string> { "Entity Framework Performance", currentPerf.EFUpdatePerformance.ToString(), currentPerf.EFPerformance.ToString(), currentPerf.EFPerformance2.ToString() }; ; str = MakeContent(strings); Data.Content[3] = str; strings = new List <string> { "Simulated Performance", currentPerf.SimUpdatePerformance.ToString(), currentPerf.SimPerformance.ToString(), currentPerf.SimPerformance2.ToString() }; str = MakeContent(strings); Data.Content[4] = str; strings = new List <string> { "Use Simulated", "", currentPerf.UseSIM.ToString() }; str = MakeContent(strings); Data.Content[5] = str; strings = new List <string> { "Use Entity Framework", "", currentPerf.UseEF.ToString() }; str = MakeContent(strings); Data.Content[6] = str; strings = new List <string> { "Use Dapper Framework", "", currentPerf.UseDapper.ToString() }; str = MakeContent(strings); Data.Content[7] = str; strings = new List <string> { "Allow Entity Framework", "", currentPerf.AllowEF.ToString() }; str = MakeContent(strings); Data.Content[8] = str; strings = new List <string> { "Allow Dapper Framework", "", currentPerf.AllowDapper.ToString() }; str = MakeContent(strings); Data.Content[9] = str; strings = new List <string> { "Max Records", "", currentPerf.MaxPage.ToString(), currentPerf.Records.ToString() }; str = MakeContent(strings); Data.Content[10] = str; } return(Data); }
public override object Execute(Dictionary <string, object> arguments) { var result = new List <SelectOption>(); //if pageModel is not provided, returns empty List<SelectOption>() if (arguments.ContainsKey("PageModel") && arguments.ContainsKey("DataSourceName") && !string.IsNullOrWhiteSpace((string)arguments["DataSourceName"])) { //replace constants with your values string DATASOURCE_NAME = (string)arguments["DataSourceName"]; string KEY_FIELD_NAME = (string)arguments["KeyPropName"]; string VALUE_FIELD_NAME = (string)arguments["ValuePropName"]; string ICON_CLASS_FIELD_NAME = (string)arguments["IconClassPropName"]; string COLOR_FIELD_NAME = (string)arguments["ColorPropName"]; PageDataModel pageModel = arguments["PageModel"] as PageDataModel; if (pageModel == null) { return(result); } try { //try read data source by name and get result as specified type object var dataSource = pageModel.GetProperty(DATASOURCE_NAME); //if data source not found or different type, return empty List<SelectOption>() if (dataSource == null) { return(result); } if (dataSource is List <EntityRecord> ) { foreach (var record in (List <EntityRecord>)dataSource) { if (record.Properties.ContainsKey(ICON_CLASS_FIELD_NAME) && record[ICON_CLASS_FIELD_NAME] != null) { var color = "#999"; if (record.Properties.ContainsKey(COLOR_FIELD_NAME) && record[COLOR_FIELD_NAME] != null) { color = record[COLOR_FIELD_NAME].ToString(); } result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), record[VALUE_FIELD_NAME].ToString(), record[ICON_CLASS_FIELD_NAME].ToString(), color)); } else { result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), record[VALUE_FIELD_NAME].ToString())); } } } else if (dataSource is EntityRecord) { var record = (EntityRecord)dataSource; if (record.Properties.ContainsKey(ICON_CLASS_FIELD_NAME) && record[ICON_CLASS_FIELD_NAME] != null) { var color = "#999"; if (record.Properties.ContainsKey(COLOR_FIELD_NAME) && record[COLOR_FIELD_NAME] != null) { color = record[COLOR_FIELD_NAME].ToString(); } result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), record[VALUE_FIELD_NAME].ToString(), record[ICON_CLASS_FIELD_NAME].ToString(), color)); } else { result.Add(new SelectOption(record[KEY_FIELD_NAME].ToString(), record[VALUE_FIELD_NAME].ToString())); } } else { throw new Exception("Input Datasource value should be of type List<EntityRecord> or EntityRecord"); } } catch (PropertyDoesNotExistException) { } } return(result); }