public PaymentCollection GetAllPaymentCollection()
{
IDBManager dbm = new DBManager();
PaymentCollection cols = new PaymentCollection();
try
{
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPaymentsAll");
while (reader.Read())
{
Payment PAY = new Payment();
PAY.PaymentID = Int32.Parse(reader["PaymentID"].ToString());
PAY.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString());
PAY.PaymentType = reader["PaymentType"].ToString();
PAY.PaymentDate = DateTime.Parse(reader["PaymentDate"].ToString());
PAY.Amount = decimal.Parse(reader["Amount"].ToString());
PAY.Comments = reader["Comments "].ToString();
PAY.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
PAY.CheckNumber = reader["CheckNumber"].ToString();
cols.Add(PAY);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "PaymentCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
public PaymentCollection GetAllPaymentDynamicCollection(string whereExpression, string orderBy)
{
IDBManager dbm = new DBManager();
PaymentCollection cols = new PaymentCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereExpression);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPaymentsDynamic");
while (reader.Read())
{
Payment PAY = new Payment();
PAY.PaymentID = Int32.Parse(reader["PaymentID"].ToString());
PAY.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString());
PAY.PaymentType = reader["PaymentType"].ToString();
PAY.PaymentDate = DateTime.Parse(reader["PaymentDate"].ToString());
PAY.Amount = decimal.Parse(reader["Amount"].ToString());
PAY.Comments = reader["Comments "].ToString();
PAY.CheckNumber = reader["CheckNumber"].ToString();
PAY.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(PAY);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllPaymentDynamicCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
