public static CustomList <ItemRequisitionDetail> GetAllItemRequisitionDetail(Int64 RequisitionID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <ItemRequisitionDetail> ItemRequisitionDetailCollection = new CustomList <ItemRequisitionDetail>(); IDataReader reader = null; String sql = "spGetItemRequisitionDetail " + RequisitionID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { ItemRequisitionDetail newItemRequisitionDetail = new ItemRequisitionDetail(); newItemRequisitionDetail.SetData(reader); ItemRequisitionDetailCollection.Add(newItemRequisitionDetail); } return(ItemRequisitionDetailCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
private void AddNewRequisitionRow() { try { String menuName = HttpContext.Current.Request.QueryString["menuName"]; CustomList<ItemRequisitionDetail> RequisitionDetList = (CustomList<ItemRequisitionDetail>)HttpContext.Current.Session[menuName + "_ItemRequisitionDetailList"]; ItemRequisitionDetail newRequisition = new ItemRequisitionDetail(); RequisitionDetList.Add(newRequisition); } catch (Exception ex) { throw ex; } }
public static CustomList<ItemRequisitionDetail> GetAllItemRequisitionDetail(Int64 RequisitionID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<ItemRequisitionDetail> ItemRequisitionDetailCollection = new CustomList<ItemRequisitionDetail>(); IDataReader reader = null; String sql = "spGetItemRequisitionDetail " + RequisitionID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { ItemRequisitionDetail newItemRequisitionDetail = new ItemRequisitionDetail(); newItemRequisitionDetail.SetData(reader); ItemRequisitionDetailCollection.Add(newItemRequisitionDetail); } return ItemRequisitionDetailCollection; } catch(Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }