public static CBE.ModuleActivityCollection GetAll() { try { //Stored procedure must have cur_out parameter. //There is no need to add ref cursor for oracle in code. CBE.ModuleActivityCollection moduleActivities = new CBE.ModuleActivityCollection(); string spName = Constants.oraclePackagePrefix + "Module_Activity_GetAll"; DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName); DataSet ds = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName); DataTable dt = ds.Tables[tableName]; moduleActivities = ConvertDataTableToCollection(dt); return(moduleActivities); } catch (Exception ex) { throw ex; } }
private static CBE.ModuleActivityCollection ConvertDataTableToCollection(DataTable dt) { try { CBE.ModuleActivityCollection moduleActivities = new CBE.ModuleActivityCollection(); for (int i = 0; i < dt.Rows.Count; i++) { CBE.ModuleActivityCBE moduleActivity = new CBE.ModuleActivityCBE(); if (dt.Rows[i]["ENTRY_ID"] != DBNull.Value) { moduleActivity.EntryId = Convert.ToInt32(dt.Rows[i]["ENTRY_ID"]); } if (dt.Rows[i]["MODULE_ID"] != DBNull.Value) { moduleActivity.ModuleId = Convert.ToInt32(dt.Rows[i]["MODULE_ID"]); } if (dt.Rows[i]["ACTIVITY_ID"] != DBNull.Value) { moduleActivity.ActivityId = Convert.ToInt32(dt.Rows[i]["ACTIVITY_ID"]); } if (dt.Rows[i]["TRANSFER_STATUS"] != DBNull.Value) { moduleActivity.TransferStatus = Convert.ToInt32(dt.Rows[i]["TRANSFER_STATUS"]); } moduleActivities.Add(moduleActivity); } return(moduleActivities); } catch (Exception ex) { throw ex; } }