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