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));
}
