protected void lnkRemove_Click(object sender, EventArgs e) { _DataTableColumn dtc = DQManager.db._DataTableColumns.SingleOrDefault(d => d.ID.ToString() == ((LinkButton)sender).CommandArgument); if (dtc != null) { DQManager.db._DataTableColumns.DeleteOnSubmit(dtc); DQManager.db.SubmitChanges(); } LoadView(); }
public _DataTableColumn AddColumn(string field, int AdminID, string friendlyField) { _DataTableColumn col = new _DataTableColumn() { _DataFieldName = field, _DataTableID = GetDataTable().ID, AdminID = AdminID, _DataFieldFriendly = friendlyField }; GetDataTable()._DataTableColumns.Add(col); db.SubmitChanges(); return(col); }
protected void ddlFields_SelectedIndexChanged(object sender, EventArgs e) { if (ddlFields.SelectedValue != "") { _DataTableColumn col = DQManager.AddColumn(ddlFields.SelectedValue, ((AdminPage)Page).AdminUser.ID, ddlFields.SelectedItem.Text); DQManager.GetDataTable()._DataTableColumns.Add(col); DQManager.db.SubmitChanges(); Ordering.MoveToBottom(DQManager.GetSchema(), (_DataTableColumn)col); DQManager.db.SubmitChanges(); DQManager.Initialize(Type, ViewID); } LoadView(); }
private void reorderHeader(ImageButton button, bool increase) { int admin = 1; if (ViewID == -1) { admin = new AuthAdmin(db).Authorise().ID; } var entities = DQManager.GetDataTable()._DataTableColumns.Where(d => d.AdminID == admin); _DataTableColumn record = DQManager.GetDataTable()._DataTableColumns.SingleOrDefault(a => a.ID == Int32.Parse(button.CommandArgument)); Ordering.ChangeOrder(entities, record, increase); DQManager.db.SubmitChanges(); LoadView(); }
public List <_DataTableColumn> GetSchema() { if (GetDataTable() == null) { _DataTable datatable = new _DataTable(); datatable.TableReference = Type.Name; datatable.FriendlyName = Type.Name; datatable.IsAllowCustom = false; db._DataTables.InsertOnSubmit(datatable); db.SubmitChanges(); } int viewID = ViewID; if (viewID == -1) { AuthAdmin auth = new AuthAdmin(db); viewID = auth.Authorise().ID; } List <_DataTableColumn> dtc = (from p in GetDataTable()._DataTableColumns where p.AdminID == viewID orderby p.OrderNo select p).ToList(); if (IncludeDataReference) { var fields = GetAllFields(); _DataTableColumn tempDTC = new _DataTableColumn(); tempDTC.AdminID = 0; tempDTC._DataTableID = 0; tempDTC._DataFieldName = "Reference"; tempDTC._DataFieldFriendly = "Reference"; tempDTC.OrderNo = 999; dtc.Add(tempDTC); } return(dtc); }