public static CustomList <PODetail> GetAllPODetail() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <PODetail> PODetailCollection = new CustomList <PODetail>(); IDataReader reader = null; const String sql = "select *from PODetail"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { PODetail newPODetail = new PODetail(); newPODetail.SetData(reader); PODetailCollection.Add(newPODetail); } return(PODetailCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
private void GetRefTransDetail() { try { String test = String.Empty; RequisitionManager manager = new RequisitionManager(); Int64 RefID = Convert.ToInt64(HttpContext.Current.Request.QueryString["RefID"]); String POTest = HttpContext.Current.Request.QueryString["POTest"]; String refTypeID = HttpContext.Current.Request.QueryString["refTypeID"]; String refTypeTest = HttpContext.Current.Request.QueryString["refTypeTest"]; String refNo = HttpContext.Current.Request.QueryString["refNo"]; CustomList<ItemRequisitionDetail> ItemRequisitionDetailList = manager.GetAllItemRequisitionDetail(RefID); CustomList<PODetail> ExistingPODetailList = (CustomList<PODetail>)HttpContext.Current.Session["PO_PODetailList"]; foreach (ItemRequisitionDetail IR in ItemRequisitionDetailList) { PODetail obj = new PODetail(); obj.ItemGroupID = IR.ItemGroupID; obj.ItemSubGroupID = IR.ItemSubGroupID; obj.ItemCode = IR.ItemCode; obj.UOMID = IR.UOMID; obj.ItemQty = IR.ItemQty; obj.UnitPrice = IR.UnitPrice; if (refTypeID.IsNotNullOrEmpty()) obj.SourceReferenceTypeID = refTypeID.ToInt(); obj.SourceReferenceType = refTypeTest; obj.SourceReference = POTest; obj.SourceReferenceID = RefID; obj.SourceReferenceNo = refNo; ExistingPODetailList.Add(obj); } HttpContext.Current.Session["PO_PODetailList"] = ExistingPODetailList; HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ContentType = "text/plain"; HttpContext.Current.Response.Write(test); HttpContext.Current.Response.Flush(); } catch (Exception ex) { throw (ex); } }
public static CustomList<PODetail> GetAllPODetail() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<PODetail> PODetailCollection = new CustomList<PODetail>(); IDataReader reader = null; const String sql = "select *from PODetail"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { PODetail newPODetail = new PODetail(); newPODetail.SetData(reader); PODetailCollection.Add(newPODetail); } return PODetailCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }