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();
}
}
