public static CustomList <ItemRequisitionMaster> GetAllItemRequisitionMaster() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <ItemRequisitionMaster> ItemRequisitionMasterCollection = new CustomList <ItemRequisitionMaster>(); IDataReader reader = null; const String sql = "select *from ItemRequisitionMaster"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { ItemRequisitionMaster newItemRequisitionMaster = new ItemRequisitionMaster(); newItemRequisitionMaster.SetData(reader); ItemRequisitionMasterCollection.Add(newItemRequisitionMaster); } return(ItemRequisitionMasterCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList<ItemRequisitionMaster> GetAllItemRequisitionMaster() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<ItemRequisitionMaster> ItemRequisitionMasterCollection = new CustomList<ItemRequisitionMaster>(); IDataReader reader = null; const String sql = "select *from ItemRequisitionMaster"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { ItemRequisitionMaster newItemRequisitionMaster = new ItemRequisitionMaster(); newItemRequisitionMaster.SetData(reader); ItemRequisitionMasterCollection.Add(newItemRequisitionMaster); } return ItemRequisitionMasterCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }