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