The Source Code - Multilevel Security for Relational Databases - page 192

{
if (SQLSTR.ToUpper().Contains(“WHERE”))
{
DML = SQLSTR.Substring(SQLSTR.
ToUpper().IndexOf(“WHERE”) + 5);
}
else
{
DML = “”;
}
}
return DML;
}
public static string PredicateSTR(String SQLSTR)
{
string DML = “”;
if (SQLSTR.ToUpper().Contains(“WHERE”))
{
DML = SQLSTR.Substring(SQLSTR.
ToUpper().IndexOf(“WHERE”) + 5);
}
else
{
DML = “”;
}
return DML;
}
public static int GetUserLabelID()
{
int UserLabel = 0;
string SqlStr = “select [dbo].
GetLabelID([dbo].[GetUserLabel]()) “;
UserLabel = int.Parse(DBOperations.
GetData(SqlStr).Tables 0].Rows[0][0].
ToString());
return UserLabel;
}
public static string GetUserLabel()
{
string UserLabel = “”;
string SqlStr = “select [dbo].[GetUserLabel]() “;
UserLabel = DBOperations.GetData(SqlStr).
Tables 0].Rows[0][0].ToString();
return UserLabel;
}