protected internal DataTable GetImport(int cid)
{
DBComparison client = DBComparison.Equal(DBField.Field(TalentozTemplate.ClientID.Name), DBConst.Int32(cid));
DBQuery select = DBQuery.SelectAll().From(TalentozTemplate.Table).Where(client).OrderBy(TalentozTemplate.Name.Name, Order.Ascending);
return(db.GetDatatable(select));
}
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));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public DataTable GetTables(string clientid, string serverid)
{
DBQuery select;
DBComparison client = DBComparison.Equal(DBField.Field(TzAccount.ClientServer.ClientID.Name), DBConst.String(clientid));
DBComparison server = DBComparison.Equal(DBField.Field(TzAccount.ClientServer.ServerID.Name), DBConst.String(serverid));
DBConst dbclientid = DBConst.String(clientid);
select = DBQuery.SelectAll(TzAccount.Tables.Table).From(TzAccount.Tables.Table)
.WhereAll(client, server);
return(db.GetDatatable(select));
}
/// <summary>
///
/// </summary>
/// <param name="tableid"></param>
/// <returns></returns>
public DataTable GetFields(string tableid)
{
DBQuery select;
select = DBQuery.SelectAll(TzAccount.Field.Table).From(TzAccount.Field.Table)
.LeftJoin(TzAccount.Field.Table).On(TzAccount.Field.TableID, Compare.Equals, TzAccount.Field.TableID);
return(db.GetDatatable(select));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public DataTable GetServer( )
{
DBDatabase db;
db = base.Database;
DBQuery select;
select = DBQuery.SelectAll(TzAccount.Server.Table).From(TzAccount.Server.Table);
return(db.GetDatatable(select));
}
public DataTable GetSecurityGroup(string clientid, string groupID)
{
DBQuery select;
// DBComparison baseType= DBComparison.Equal(DBField.Field(TzAccount.SecurityGroup.BaseType .Name), DBConst.Int32(pBaseType));
DBComparison client = DBComparison.Equal(DBField.Field(TzAccount.SecurityGroup.ClientID.Name), DBConst.String(clientid));
DBComparison group = DBComparison.Equal(DBField.Field(TzAccount.SecurityGroup.SecurityGroupID.Name), DBConst.String(groupID));
select = DBQuery.SelectAll(TzAccount.SecurityGroup.Table).From(TzAccount.SecurityGroup.Table)
.WhereAll(client, group);
return(db.GetDatatable(select));
}
/// <summary>
///
/// </summary>
/// <param name="serverid"></param>
/// <returns></returns>
public DataTable GetServer(string serverid)
{
DBDatabase db;
db = base.Database;
DBQuery select;
select = DBQuery.SelectAll(TzAccount.Server.Table).From(TzAccount.Server.Table)
.WhereField(TzAccount.Server.Table, TzAccount.Server.ServerID.Name, Compare.Equals, DBConst.String(serverid));
return(db.GetDatatable(select));
}
public System.Data.DataTable GetData(int currentPage, int PageSize, string tb)
{
System.Data.DataTable dt = new DataTable();
DBDatabase db = base.Database;
string dbname = base.Schema;
DBQuery totalRecord = DBQuery.SelectCount().From(dbname, tb);
int trecord = Convert.ToInt32(db.ExecuteScalar(totalRecord));
DBQuery record = DBQuery.SelectAll().From(dbname, tb).TopRange(currentPage * PageSize, PageSize);
var dtRecord = db.GetDatatable(record);
return(dtRecord);
}
/// <summary>
///
/// </summary>
/// <param name="clientid"></param>
/// <param name="groupid"></param>
/// <param name="privilegeid"></param>
/// <returns></returns>
public DataTable GetPrivilege(string clientid, string groupid, string privilegeid)
{
DBQuery select;
DBComparison privilege = DBComparison.Equal(DBField.Field(TzAccount.SecurityPrivilege.PrivilegeID.Name), DBConst.String(privilegeid));
// DBComparison user = DBComparison.Equal(DBField.Field(TzAccount.SecurityPrivilege.UserID.Name), DBConst.String(userid));
DBComparison SecurityGroupID = DBComparison.Equal(DBField.Field(TzAccount.SecurityPrivilege.SecurityGroupID.Name), DBConst.String(groupid));
DBComparison Client = DBComparison.Equal(DBField.Field(TzAccount.SecurityPrivilege.ClientID.Name), DBConst.String(clientid));
select = DBQuery.SelectAll(TzAccount.SecurityGroup.Table).From(TzAccount.SecurityGroup.Table)
.WhereAll(privilege, SecurityGroupID, Client);
return(db.GetDatatable(select));
}
protected internal DataTable GetComponents()
{
DBQuery select = DBQuery.SelectAll().From(TalentozSchema.Table).OrderBy(TalentozSchema.ComponentName.Name, Order.Ascending);
return(db.GetDatatable(select));
}
