/// <summary> /// Insert or update Module rights by user Id and Module Id /// </summary> /// <param name="module"></param> public static void InsertUpdateUserModuleActivityRight(VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserModuleActivityRightCBE module) { try { string spName = Constants.oraclePackagePrefix + "USERMODULE_ACT_UPDATE"; DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_ENTRY_ID", DbType.Int32, module.Id, ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_USER_ID", DbType.Int32, module.UserId, ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_MODULE_ID", DbType.Int32, module.ModuleId, ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_MODULE_ADD", DbType.Int32, module.ModuleAdd ? 1 : 0, ParameterDirection.Input, 100)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_MODULE_VIEW", DbType.Int32, module.ModuleView ? 1 : 0, ParameterDirection.Input, 100)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_MODULE_EDIT", DbType.Int32, module.ModuleEdit ? 1 : 0, ParameterDirection.Input, 100)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_MODULE_DELETE", DbType.Int32, module.ModuleDelete ? 1 : 0, ParameterDirection.Input, 100)); VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.ExecuteNonQuery(command); } catch (Exception ex) { throw ex; } }
public static VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserModuleActivityRightCBE GetModuleRightById(Int32 Id) { IEnumerable <VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserModuleActivityRightCBE> modules; VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserModuleActivityRightCBE module = null; try { string spName = Constants.oraclePackagePrefix + "USERMOD_ACT_GETBYENTRYID"; DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_ENTRY_ID", DbType.Int32, Id, ParameterDirection.Input)); modules = ConvertTableToIEnurable(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName).Tables[tableName]); if (modules.Count() > 0) { module = modules.First(); } } catch (Exception ex) { throw ex; } return(module); }
/// <summary> /// Insert or update Module rights by user Id and Module Id /// </summary> /// <param name="module"></param> public static void InsertUpdateUserModuleActivityRight(VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserModuleActivityRightCBE module) { VaaaN.MLFF.Libraries.CommonLibrary.DAL.UserModuleActivityRightDAL.InsertUpdateUserModuleActivityRight(module); }