public List <SupplierPaymentReport> GetSupplierPaymentReportBetweenDate(DateTime fromdate, DateTime todate)
{
List <SupplierPaymentReport> aPaymentReports = new List <SupplierPaymentReport>();
try
{
this.OpenConnection();
string sqlComm = String.Format(SqlQueries.GetQuery(Query.GetSupplierPaymentReportBetweenDate), fromdate, todate);
IDataReader aReader = this.ExecuteReader(sqlComm);
if (aReader != null)
{
while (aReader.Read())
{
SupplierPaymentReport aReport = new SupplierPaymentReport();
aReport = ReaderToReadSupplierPaymentReport(aReader);
aPaymentReports.Add(aReport);
}
}
}
catch (Exception ex)
{
throw new Exception("GetSupplierPaymentReportBetweenDate()", ex);
}
finally
{
CloseConnection();
}
return(aPaymentReports);
}
//"select a.supplier_payment_id, a.total_amount, a.paid_amount, a.paid_type,
//a.date, a.user_name ,b.supplier_name from supplier_payment_report a,
//supplier b where a.supplier_id=b.supplier_id and a.date>='{0}' and a.date<='{1}'";
private SupplierPaymentReport ReaderToReadSupplierPaymentReport(IDataReader aReader)
{
SupplierPaymentReport aReport = new SupplierPaymentReport();
try
{
aReport.SupplierPaymentReportId = Convert.ToInt32(aReader["supplier_payment_id"]);
}
catch
{
}
try
{
aReport.TotalAmount = Convert.ToDouble(aReader["total_amount"]);
}
catch
{
}
try
{
aReport.PaidAmount = Convert.ToDouble(aReader["paid_amount"]);
}
catch
{
}
try
{
aReport.PaymentType = (aReader["paid_type"]).ToString();
}
catch
{
}
try
{
aReport.UserName = (aReader["user_name"]).ToString();
}
catch
{
}
try
{
aReport.SupplierName = (aReader["supplier_name"]).ToString();
}
catch
{
}
try
{
aReport.PaymentDate = Convert.ToDateTime(aReader["date"]);
}
catch
{
}
return(aReport);
}
