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