private ClassSelectResult <T> ExecuteSelect <T>(ClassSelect <T> select) { if (!string.IsNullOrEmpty(this.OrderBy)) { select.OrderBy(this.OrderByDirection, this.OrderBy); } select.Page(this.PageSize, this.PageOrdinal); ClassFilterExpression filter = null; foreach (BootstrapQueryHelperColumn col in this.columns) { if (!string.IsNullOrEmpty(col.Filter)) { filter = filter == null ? new ClassFilterExpression(select.Aspect, col.Name, FilterComparison.Like, "%" + col.Filter.Replace(" ", "%") + "%") : filter.And(col.Name, FilterComparison.Like, "%" + col.Filter.Replace(" ", "%") + "%"); } } if (filter != null) { select.And(filter); } ClassSelectResult <T> result = select.ToResult(); this.RecordCount = result.RecordCount; return(result); }
protected void TermSelect_SelectedIndexChanged(object sender, EventArgs e) { ClassSelect.Enabled = true; using (WebhostEntities db = new WebhostEntities()) { int tid = Convert.ToInt32(TermSelect.SelectedValue); int sid = this.user.ID; Student student = db.Students.Where(s => s.ID == sid).Single(); List <int> sectionIds = new List <int>(); foreach (StudentComment comment in student.StudentComments.ToList()) { if (comment.CommentHeader.TermIndex == tid) { sectionIds.Add(comment.CommentHeader.SectionIndex); } } ClassSelect.DataSource = SectionListItem.GetDataSource(sectionIds); ClassSelect.DataTextField = "Text"; ClassSelect.DataValueField = "ID"; ClassSelect.DataBind(); ReadonlyCommentViewer1.Visible = false; } }
public ActionResult ChartClass() { SQLManager manager = new SQLManager(); var classlist = manager.GetClass(); List <Models.DataBaseModels.Major> majors = new List <Models.DataBaseModels.Major>(); List <int> yeras = new List <int>(); List <int> classnumer = new List <int>(); foreach (var item in classlist) { Models.DataBaseModels.Major major = new Models.DataBaseModels.Major { MajorId = item.MajorId, MajorName = item.MajorName }; majors.Add(major); yeras.Add(item.Year); classnumer.Add(item.ClassNumber); } ClassSelect select = new ClassSelect { Years = yeras.Distinct().ToArray(), Number = classnumer.Distinct().ToArray() }; select.Majors = majors.Distinct(new Models.DataBaseModels.MajorComparer()).ToArray(); return(View(select)); }
public void TestManageSelect() { ClassSelect s = myClass.ManageSelect("SELECT edad,curso FROM universidad WHERE edad>18;"); string[] columns = s.GetColumns(); Assert.AreEqual("universidad", s.GetTable()); Assert.AreEqual("edad", s.GetColumns()[0]); Assert.AreEqual("curso", s.GetColumns()[1]); Assert.AreEqual("edad>18", s.GetCondition()); }
private void SyncClasses() { GameInfo.LoadClasses(); ClassSelect.Items.Clear(); foreach (var cls in GameInfo.Classes) { ClassSelect.Items.Add(cls); } ClassSelect.Invalidate(); Invalidate(); }
public ClassSelect ManageSelect(string pQuery) { ClassSelect query; Match matchselect2 = Regex.Match(pQuery, Constants.regExSelect); if (matchselect2.Success) { string columns = matchselect2.Groups[1].Value; string table = matchselect2.Groups[2].Value; string condition = matchselect2.Groups[3].Value; string[] columnssplit = columns.Split(','); query = new ClassSelect(columnssplit, table, condition); return(query); } return(null); }
public BootstrapClassSelectResult(ClassStorage <T> storage, string formName, NameValueCollection form, ClassFilter filter) { this.FormName = formName; PopulateDefaultParameterKeys(); this._SearchFilter = GetValueFromCollection <string>(form, this.DefaultParameterKeys["Filter"], null); this._PageOrdinal = GetValueFromCollection <int>(form, this.DefaultParameterKeys["PageOrdinal"], 0); this._PageSize = GetValueFromCollection <int>(form, this.DefaultParameterKeys["PageSize"], 20); this._OrderBy = GetValueFromCollection <int>(form, this.DefaultParameterKeys["OrderBy"], -1); this._SortDirection = GetValueFromCollection <SortDirection>(form, this.DefaultParameterKeys["SortDirection"], EixoX.Data.SortDirection.Ascending); ClassSelect <T> select = null; if (string.IsNullOrEmpty(_SearchFilter.Value)) { select = storage.Select(); if (filter != null) { select.Where(filter); } } else { select = storage.Search(_SearchFilter.Value); if (filter != null) { select.And(filter); } } if (_OrderBy.Value >= 0) { select.OrderBy(_OrderBy.Value, _SortDirection.Value); } else { select.OrderBy(0, EixoX.Data.SortDirection.Descending); } select.Page(_PageSize.Value, _PageOrdinal.Value); this.Result = new ClassSelectResult <T>(select); }
public HtmlComposite Execute <T>(ClassSelect <T> select, NameValueCollection parameters) { ClassSelectResult <T> result = ExecuteSelect <T>(select); HtmlComposite form = new HtmlComposite( "form", new HtmlAttribute("method", "get")); form.AppendStandalone("input", new HtmlAttribute("type", "hidden"), new HtmlAttribute("name", "orderBy"), new HtmlAttribute("value", this.OrderBy)); form.AppendStandalone("input", new HtmlAttribute("type", "hidden"), new HtmlAttribute("name", "orderByDirection"), new HtmlAttribute("value", this.OrderByDirection)); form.AppendStandalone("input", new HtmlAttribute("type", "hidden"), new HtmlAttribute("name", "page"), new HtmlAttribute("value", "0")); if (parameters != null) { AppendUnrelatedFilters(form, select.Aspect, parameters); } HtmlComposite table = form.AppendComposite( "table", new HtmlAttribute("class", "table table-condensed table-striped table-bordered table-hover") ); table.Children.AddLast(BuildTableHeader <T>()); table.Children.AddLast(BuildTableBody <T>(result)); table.Children.AddLast(BuildTableFooter <T>(result)); return(form); }
public HtmlComposite Execute <T>(ClassSelect <T> select) { return(Execute(select, null)); }