public static System.Collections.Generic.List <Invoiceline> GetInvoiceLineList(int InvoiceID)
{
System.Collections.Generic.List <Invoiceline> result = new System.Collections.Generic.List <Invoiceline>();
DBAccess db = new DBAccess();
db.AddInt("InvoiceID", InvoiceID);
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAll)); //CType(db.ExecuteReader(_SQLSelectAllID), SqlDataReader)
if (dr.HasRows)
{
while (dr.Read())
{
result.Add(Invoiceline.GetInvoiceLine(System.Convert.ToInt32(dr.DBtoInt("ID"))));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
