public List <LoadPoCatagory> LoadPoByRequest(int RequestID)
{
List <LoadPoCatagory> poCatagories = new List <LoadPoCatagory>();
try
{
accessManager.SqlConnectionOpen(DataBase.DataEntryTracker);
List <SqlParameter> aParameters = new List <SqlParameter>();
aParameters.Add(new SqlParameter("@RequestId", RequestID));
SqlDataReader dr = accessManager.GetSqlDataReader("sp_LoadPOBYRequestId", aParameters);
while (dr.Read())
{
LoadPoCatagory poCatagory = new LoadPoCatagory();
poCatagory.PoCatagoryId = (int)dr["RequestPOTableId"];
poCatagory.PoCatagoryName = dr["PONumber"].ToString();
poCatagories.Add(poCatagory);
}
return(poCatagories);
}
catch (Exception e)
{
accessManager.SqlConnectionClose(true);
throw e;
}
finally
{
accessManager.SqlConnectionClose();
}
}
public List <LoadPoCatagory> LoadPoFromDataBase(int userId)
{
List <LoadPoCatagory> poCatagories = new List <LoadPoCatagory>();
try
{
accessManager.SqlConnectionOpen(DataBase.DataEntryTracker);
List <SqlParameter> aParameters = new List <SqlParameter>();
aParameters.Add(new SqlParameter("@userId", userId));
SqlDataReader dr = accessManager.GetSqlDataReader("sp_LoadPOCatagory", aParameters);
while (dr.Read())
{
LoadPoCatagory poCatagory = new LoadPoCatagory();
poCatagory.PoCatagoryId = (int)dr["PoCatagoryId"];
poCatagory.PoCatagoryName = dr["PoCatagoryName"].ToString();
poCatagories.Add(poCatagory);
}
return(poCatagories);
}
catch (Exception e)
{
accessManager.SqlConnectionClose(true);
throw e;
}
finally
{
accessManager.SqlConnectionClose();
}
}
