public DataTable JMD_SITE_SELECT(string Site_URL)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_SITE_SELECT,
Site_URL
));
dbSql = null;
return dt;
}
public DataTable JMD_USER_SELECT(string Site_URL, string User_Id)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_USER_SELECT,
Site_URL,
User_Id
));
dbSql = null;
return dt;
}
/*
* version: 0.0.1.2000
* Procedure or Function 'JMD_PAGE_SAVE' expects parameter
* '@Load_Shared_Modules', which was not supplied.
*/
public DataTable JMD_PAGE_SAVE(string Page_Id, string Site_URL, string Page_Name,
string Page_Caption, string Meta_Title, string Meta_Desc,
string Meta_Keywords, string Parent_Page_Name, string Is_Published,
string Is_Root, string Is_Menu_Item,
string View_Roles, string Add_Roles, string Edit_Roles, string Delete_Roles,
string Move_Roles, string Add_Module_Roles, string Is_Internal,
string Load_Shared_Modules, string Page_Sort, string Is_ViewState_Enabled
)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_PAGE_SAVE,
Page_Id,
Site_URL,
Page_Name,
Page_Caption,
Meta_Title,
Meta_Desc,
Meta_Keywords,
Parent_Page_Name,
Is_Published,
Is_Root,
Is_Menu_Item,
View_Roles,
Add_Roles,
Edit_Roles,
Delete_Roles,
Move_Roles,
Add_Module_Roles,
Is_Internal,
Load_Shared_Modules,
Page_Sort,
Is_ViewState_Enabled));
dbSql = null;
return dt;
}
/// <summary>
/// Returns Pages Resultset with filtered criteria.
/// Page_Name parameter can be left blank.
/// </summary>
/// <Work Item="651"></param>
/// <param name="Site_URL"></param>
/// <param name="Page_Name"></param>
/// <param name="Filter"></param>
/// <returns></returns>
public DataTable JMD_PAGE_SELECT(string Site_URL, string Page_Name,
string Filter)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_PAGE_SELECT_FILTER,
Site_URL, Page_Name, Filter
));
dbSql = null;
return dt;
}
public DataTable JMD_PAGE_AUTH(string Site_URL,
string Page_Name)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_PAGE_AUTH,
Site_URL,
Page_Name
));
dbSql = null;
return dt;
}
public DataTable JMD_PAGE_MOD_SELECT_Sp(string PageModId)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_PAGE_MOD_SELECT_Sp,
PageModId
));
dbSql = null;
return dt;
}
public DataTable JMD_OBJ_SELECT(string JMD_OBJ_ID)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_OBJ_SELECT,
JMD_OBJ_ID
));
dbSql = null;
return dt;
}
public DataTable JMD_MOD_HTML_Select(string Page_Mod_Id)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_MOD_HTML_Select, Page_Mod_Id));
dbSql = null;
return dt;
}
public DataTable JMD_MOD_BreadCrumbs(string Site_URL, string Page_Name)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_MOD_BreadCrumbs,
Site_URL,
Page_Name
));
dbSql = null;
return dt;
}
public DataTable JMD_GET_TABLE_NAME(string Site_URL, string Jmd_Obj_Id)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlJMD_GET_TABLE_NAME,
Site_URL,
Jmd_Obj_Id
));
dbSql = null;
return dt;
}
public DataTable DynamicTableSelect(string TableName,
string FieldNames)
{
DataTable dt;
DbSql dbSql = new DbSql(SqlConnectionString);
dt = dbSql.OpenTable(String.Format(SqlDynamicTableSelect,
FieldNames, TableName
));
dbSql = null;
return dt;
}