public void JMD_USER_INSERT(string User_Id, string Site_URL,
string User_Name, string User_Display_Name,
string Password_Hash, string Salt, string Email)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_USER_INSERT,
User_Id,
Site_URL,
User_Name,
User_Display_Name,
Password_Hash,
Salt,
Email
));
dbSql = null;
}
public void JMD_USER_ROLE_SAVE(string User_Id,
string User_Roles)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_USER_ROLE_SAVE,
User_Id,
User_Roles
));
dbSql = null;
}
public void JMD_ROLE_SAVE(string Role_Id,
string Site_URL, string Role_Name)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_ROLE_SAVE,
Role_Id,
Site_URL,
Role_Name
));
dbSql = null;
}
public void JMD_USER_DELETE(string Site_URL, string User_Id)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_USER_DELETE,
Site_URL,
User_Id
));
dbSql = null;
}
public void JMD_PAGE_MOD_SAVE(string Page_Mod_Id, string Site_URL,
string Page_Name, string Mod_Id, string Mod_Title, string Div_Id,
string Is_Published, string Show_On_All_Pages, string View_Role,
string Edit_Role, string Delete_Role, string Move_Role,
string Edit_Contents_Role, string Mod_Sort)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_PAGE_MOD_SAVE,
Page_Mod_Id, Site_URL, Page_Name, Mod_Id, Mod_Title, Div_Id,
Is_Published, Show_On_All_Pages, View_Role, Edit_Role, Delete_Role,
Move_Role, Edit_Contents_Role, Mod_Sort));
dbSql = null;
}
public void JMD_ROLE_DELETE(string Site_URL, string Role_Id)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_ROLE_DELETE,
Site_URL,
Role_Id
));
dbSql = null;
}
public void JMD_PAGE_DELETE(string Site_URL, string Page_Name)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_PAGE_DELETE,
Site_URL, Page_Name
));
dbSql = null;
}
public void JMD_PAGE_MOD_DELETE(string Page_Mod_Id, string Action)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_PAGE_MOD_DELETE,
Page_Mod_Id, Action
));
dbSql = null;
}
public void JMD_OBJ_SAVE(string JMD_OBJ_ID, string SITE_URL,
string OBJ_NAME, string OBJ_TYPE, string OBJ_DESC,
string PARENT_OBJ_ID, string IS_INTERNAL)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_OBJ_SAVE,
JMD_OBJ_ID, SITE_URL, OBJ_NAME, OBJ_TYPE, OBJ_DESC,
PARENT_OBJ_ID, IS_INTERNAL));
dbSql = null;
}
public void JMD_MOD_HTML_SAVE(string Page_Mod_Id, string Title, string Html_Text)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_MOD_HTML_SAVE,
Page_Mod_Id, Title, Html_Text));
dbSql = null;
}
public void JMD_MOD_CJ_CATEGORY_SAVE(string Category_Id,
string Category)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_MOD_CJ_Category_Save,
Category_Id,
Category
));
dbSql = null;
}
public void JMD_COL_SAVE(string JMD_COL_ID, string JMD_OBJ_ID, string JMD_COL_NAME,
string JMD_COL_CAPTION, string JMD_COL_DESC, string JMD_COL_TYPE_ID, string COL_EXT_DATA)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlJMD_COL_SAVE,
JMD_COL_ID,
JMD_OBJ_ID,
JMD_COL_NAME,
JMD_COL_CAPTION,
JMD_COL_DESC,
JMD_COL_TYPE_ID,
COL_EXT_DATA));
dbSql = null;
}
public void ExecuteSql(string SQL)
{
DbSql dbSql = new DbSql(SqlConnectionString);
dbSql.Execute(String.Format(SqlExecuteSql,
SQL));
dbSql = null;
}