public DataTable GetView(string viewID) { DBComparison dbView = DBComparison.Compare(DBField.Field(TalentozViewSchema.ViewID.Name), Compare.Equals, DBConst.String(viewID)); DBQuery se = DBQuery.SelectAll().From(TalentozView.Table).Where(dbView); return(db.GetDatatable(se)); }
public bool RemoveView(string ViewID) { DBComparison dbView = DBComparison.Compare(DBField.Field(TalentozView.ViewID.Name), Compare.Equals, DBConst.String(ViewID)); DBQuery deleteView = DBQuery.DeleteFrom(TalentozView.Table).Where(dbView); db.ExecuteNonQuery(deleteView); return(true); }
public DataTable GetViewSchema(string viewid) { DBComparison dbView = DBComparison.Compare(DBField.Field(TalentozViewSchema.Table, TalentozViewSchema.ViewID.Name), Compare.Equals, DBConst.String(viewid)); DBQuery se = DBQuery.Select() .Field(TalentozViewSchema.Table, TalentozViewSchema.ViewID.Name) .Field(TalentozViewSchema.Table, TalentozViewSchema.ComponentID.Name) .Field(TalentozViewSchema.Table, TalentozViewSchema.ChildComponentID.Name) .Field(TalentozViewSchemaRelation.Table, TalentozViewSchemaRelation.ViewSchemaRelation.Name) .Field(TalentozViewSchemaRelation.Table, TalentozViewSchemaRelation.ParentField.Name) .Field(TalentozViewSchemaRelation.Table, TalentozViewSchemaRelation.RelatedField.Name) .Field(TalentozViewSchemaRelation.Table, TalentozViewSchemaRelation.Parent.Name) .Field(TalentozViewSchemaRelation.Table, TalentozViewSchemaRelation.Child.Name) .From(TalentozViewSchema.Table).InnerJoin(TalentozViewSchemaRelation.Table) .On(TalentozViewSchema.Table, TalentozViewSchema.ComponentID.Name, Compare.Equals, TalentozViewSchemaRelation.Table, TalentozViewSchemaRelation.Parent.Name) .And(TalentozViewSchema.Table, TalentozViewSchema.ChildComponentID.Name, Compare.Equals, TalentozViewSchemaRelation.Table, TalentozViewSchemaRelation.Child.Name) .And(TalentozViewSchema.Table, TalentozViewSchema.ViewID.Name, Compare.Equals, TalentozViewSchemaRelation.Table, TalentozViewSchemaRelation.ViewID.Name) .Where(dbView); return(db.GetDatatable(se)); }