/// <summary>
/// Insert or Update Role-Sub Modules Right
/// </summary>
/// <param name="submoduleActvity"></param>
public static void InsertUpdateRoleSubModuleRight(VaaaN.MLFF.Libraries.CommonLibrary.CBE.RoleSubModuleRightActivityCBE submoduleActvity)
{
string spName = string.Empty;
try
{
if (submoduleActvity.Id == 0)
{
// Insert rec
spName = Constants.oraclePackagePrefix + "ROLESUBMODRIGHT_INSERT";
}
else
{
//update rec
spName = Constants.oraclePackagePrefix + "ROLESUBMODRIGHT_UPDATE";
}
DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_ROLE_ID", DbType.Int32, submoduleActvity.RoleId, ParameterDirection.Input));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_ENTRY_ID", DbType.Int32, submoduleActvity.Id, ParameterDirection.Input));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUBMODULE_ID", DbType.Int32, submoduleActvity.SubModuleId, ParameterDirection.Input));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUB_MODULE_ADD", DbType.Int32, submoduleActvity.SubModuleAdd ? 1 : 0, ParameterDirection.Input, 100));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUB_MODULE_VIEW", DbType.Int32, submoduleActvity.SubModuleView ? 1 : 0, ParameterDirection.Input, 100));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUB_MODULE_EDIT", DbType.Int32, submoduleActvity.SubModuleEdit ? 1 : 0, ParameterDirection.Input, 100));
command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "P_SUB_MODULE_DELETE", DbType.Int32, submoduleActvity.SubModuleDelete ? 1 : 0, ParameterDirection.Input, 100));
VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.ExecuteNonQuery(command);
}
catch (Exception ex)
{
throw ex;
}
}
public static void InsertUpdateRoleSubModuleRight(VaaaN.MLFF.Libraries.CommonLibrary.CBE.RoleSubModuleRightActivityCBE submodule)
{
VaaaN.MLFF.Libraries.CommonLibrary.DAL.RoleSubmoduleRightDAL.InsertUpdateRoleSubModuleRight(submodule);
}
