/// <summary>
/// Retrieves list of InvoiceNote objects from SqlCommand, after database query
/// number of rows retrieved and returned depends upon the rows field value
/// </summary>
/// <param name="cmd">The command object to use for query</param>
/// <param name="rows">Number of rows to process</param>
/// <returns>A list of InvoiceNote objects</returns>
private InvoiceNoteList GetList(SqlCommand cmd, long rows)
{
// Select multiple records
SqlDataReader reader;
long result = SelectRecords(cmd, out reader);
//InvoiceNote list
InvoiceNoteList list = new InvoiceNoteList();
using ( reader )
{
// Read rows until end of result or number of rows specified is reached
while (reader.Read() && rows-- != 0)
{
InvoiceNote invoiceNoteObject = new InvoiceNote();
FillObject(invoiceNoteObject, reader);
list.Add(invoiceNoteObject);
}
// Close the reader in order to receive output parameters
// Output parameters are not available until reader is closed.
reader.Close();
}
return(list);
}
/// <summary>
/// Retrieves all InvoiceNote objects by PageRequest
/// </summary>
/// <returns>A list of InvoiceNote objects</returns>
public InvoiceNoteList GetPaged(PagedRequest request)
{
using (SqlCommand cmd = GetSPCommand(GETPAGEDINVOICENOTE))
{
AddParameter(cmd, pInt32Out("TotalRows"));
AddParameter(cmd, pInt32("PageIndex", request.PageIndex));
AddParameter(cmd, pInt32("RowPerPage", request.RowPerPage));
AddParameter(cmd, pNVarChar("WhereClause", 4000, request.WhereClause));
AddParameter(cmd, pNVarChar("SortColumn", 128, request.SortColumn));
AddParameter(cmd, pNVarChar("SortOrder", 4, request.SortOrder));
InvoiceNoteList _InvoiceNoteList = GetList(cmd, ALL_AVAILABLE_RECORDS);
request.TotalRows = Convert.ToInt32(GetOutParameter(cmd, "TotalRows"));
return(_InvoiceNoteList);
}
}
/// <summary>
/// Retrieve list of InvoiceNote.
/// </summary>
/// <param name="fillChild"></param>
/// <returns>List of InvoiceNote</returns>
public InvoiceNoteList GetAll(bool fillChild)
{
InvoiceNoteList invoiceNoteList = new InvoiceNoteList();
using (InvoiceNoteDataAccess data = new InvoiceNoteDataAccess(ClientContext))
{
invoiceNoteList = data.GetAll();
}
if (fillChild)
{
foreach (InvoiceNote invoiceNoteObject in invoiceNoteList)
{
FillInvoiceNoteWithChilds(invoiceNoteObject, fillChild);
}
}
return(invoiceNoteList);
}
