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