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