Esempio n. 1
0
 public TrasactionResult AddRole(MCRoles _role)
 {
     try {
         InitServices();
         BaseDataSql_ = new BaseDataSQL()
         {
             Cmd     = "AddRole",
             CmdType = BaseDataSQL.AllCmdType.SP,
             Param   = new List <BaseParamSQL>()
             {
                 GetBaseParamSQL("Name", _role.Name, BaseParamSQL.AllType.VarChar)
             }
         };
         return(new TrasactionResult()
         {
             Data = DataTableToModel_.GetModel(DataTableToModel.Table.ModelsById, Sql_.GetSQL(BaseDataSql_))
         });
     } catch (Exception _ex) {
         Msg_ = _ex.Message;
         if (!_ex.Message.Contains("@MC_Objects"))
         {
             Msg_ = _ex.Message + " @MC_Objects into class: SQL, BaseDataSQL, DataTableToModel, TrasactionResult";
         }
         throw new Exception(Msg_);
     } finally {
         Sql_              = null;
         BaseDataSql_      = null;
         DataTableToModel_ = null;
         Msg_              = null;
     }
 }
Esempio n. 2
0
 public TrasactionResult GetAllRoles()
 {
     try {
         InitServices();
         BaseDataSql_ = new BaseDataSQL()
         {
             Cmd     = "GetAllAdminModels",
             CmdType = BaseDataSQL.AllCmdType.SP,
             Param   = new List <BaseParamSQL>()
             {
                 GetBaseParamSQL("Type", 0, BaseParamSQL.AllType.Int)
             }
         };
         return(new TrasactionResult()
         {
             Data = DataTableToModel_.GetModel(DataTableToModel.Table.ListMCRoles, Sql_.GetSQL(BaseDataSql_))
         });
     } catch (Exception _ex) {
         Msg_ = _ex.Message;
         if (!_ex.Message.Contains("@MC_Objects"))
         {
             Msg_ = _ex.Message + " @MC_Objects into class: SQL, BaseDataSQL, DataTableToModel, TrasactionResult";
         }
         throw new Exception(Msg_);
     } finally {
         Sql_              = null;
         BaseDataSql_      = null;
         DataTableToModel_ = null;
         Msg_              = null;
     }
 }