public static void Delete(CBE.SubmoduleActivityCBE submoduleActivity) { try { string spName = Constants.oraclePackagePrefix + "SUBMODULEACTIVITY_DELETE"; 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, submoduleActivity.EntryId, ParameterDirection.Input)); VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.ExecuteNonQuery(command); } catch (Exception ex) { throw ex; } }
public static void Insert(CBE.SubmoduleActivityCBE submoduleActivity) { try { string spName = Constants.oraclePackagePrefix + "SUBMODULEACTIVITY_INSERT"; 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, GetNextValue(), ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "p_subModule_id", DbType.Int32, submoduleActivity.SubModuleId, ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "p_activity_id", DbType.Int32, submoduleActivity.ActivityId, ParameterDirection.Input)); command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "p_transfer_status", DbType.Int32, (int)VaaaN.MLFF.Libraries.CommonLibrary.Constants.TransferStatus.NotTransferred, ParameterDirection.Input)); VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.ExecuteNonQuery(command); } catch (Exception ex) { throw ex; } }
private static CBE.SubmoduleActivityCollection ConvertDataTableToCollection(DataTable dt) { try { CBE.SubmoduleActivityCollection submoduleActivities = new CBE.SubmoduleActivityCollection(); for (int i = 0; i < dt.Rows.Count; i++) { CBE.SubmoduleActivityCBE submoduleActivity = new CBE.SubmoduleActivityCBE(); if (dt.Rows[i]["ENTRY_ID"] != DBNull.Value) { submoduleActivity.EntryId = Convert.ToInt32(dt.Rows[i]["ENTRY_ID"]); } if (dt.Rows[i]["SUBMODULE_ID"] != DBNull.Value) { submoduleActivity.SubModuleId = Convert.ToInt32(dt.Rows[i]["SUBMODULE_ID"]); } if (dt.Rows[i]["ACTIVITY_ID"] != DBNull.Value) { submoduleActivity.ActivityId = Convert.ToInt32(dt.Rows[i]["ACTIVITY_ID"]); } if (dt.Rows[i]["TRANSFER_STATUS"] != DBNull.Value) { submoduleActivity.TransferStatus = Convert.ToInt32(dt.Rows[i]["TRANSFER_STATUS"]); } submoduleActivities.Add(submoduleActivity); } return(submoduleActivities); } catch (Exception ex) { throw ex; } }