public SoaReport(ReportViewer rv, string report, Student student, User user, List <PaymentDetail> soadetail) : base(rv, report)
{
Registration Reg = new Registration().GetRegistration(student.Id);
Assessment Assess = new Assessment().GetAssessment(Reg.Id);
DataTable table = new DataTable();
table = new Payment().GetAllPaymentPerAssessment(student.Id, Assess.Id);
List <Payment> Payments = new List <Payment>();
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Payment payment = new Payment();
payment.ORNumber = row["OR NUMBER"].ToString();
payment.Amount = Convert.ToDouble(row["AMOUNT"].ToString());
payment.PaymentDate = Convert.ToDateTime(row["PAYMENT DATE"]).ToShortDateString();
Payments.Add(payment);
}
}
else
{
Payments.Add(new Payment());
}
List <Student> studList = new List <Student>();
studList.Add(student);
List <Assessment> assList = new List <Assessment>();
assList.Add(Assess);
List <Registration> regList = new List <Registration>();
regList.Add(Reg);
List <User> userList = new List <User>();
userList.Add(user);
ReportDataSource dsStud = new ReportDataSource();
dsStud.Name = "dsStudent";
dsStud.Value = studList;
RViewer.LocalReport.DataSources.Add(dsStud);
ReportDataSource dsAssess = new ReportDataSource();
dsAssess.Name = "dsAssess";
dsAssess.Value = assList;
RViewer.LocalReport.DataSources.Add(dsAssess);
ReportDataSource dsReg = new ReportDataSource();
dsReg.Name = "dsRegistration";
dsReg.Value = regList;
RViewer.LocalReport.DataSources.Add(dsReg);
ReportDataSource dsPay = new ReportDataSource();
dsPay.Name = "dsPayment";
dsPay.Value = Payments;
RViewer.LocalReport.DataSources.Add(dsPay);
ReportDataSource dsUser = new ReportDataSource();
dsUser.Name = "dsUser";
dsUser.Value = userList;
RViewer.LocalReport.DataSources.Add(dsUser);
ReportDataSource dsPayDet = new ReportDataSource();
dsPayDet.Name = "dsPayDetail";
dsPayDet.Value = soadetail;
RViewer.LocalReport.DataSources.Add(dsPayDet);
}
public LedgerReport(ReportViewer rv, string report, Student student) : base(rv, report)
{
Registration Reg = new Registration().GetRegistration(student.Id);
Assessment Assess = new Assessment().GetAssessment(Reg.Id);
DataTable payments = new Ledger().GetAllPaymentPerAccount(Assess.Id);
DataTable payDetail = new DataTable();
List <LedgerItem> ledger = new List <LedgerItem>();
foreach (DataRow prow in payments.Rows)
{
long id = Convert.ToInt64(prow["ID"]);
payDetail = new Ledger().GetPaymentDetailById(id);
List <PaymentDetail> paylist = new List <PaymentDetail>();
foreach (DataRow plist in payDetail.Rows)
{
PaymentDetail pd = new PaymentDetail();
pd.Code = plist["CODE"].ToString();
pd.Amount = Convert.ToDouble(plist["AMOUNT"]);
paylist.Add(pd);
}
foreach (DataRow row in Assess.AssessmentDetail.Rows)
{
LedgerItem ledgerItem = new LedgerItem();
ledgerItem.FeeCode = row["CODE"].ToString();
ledgerItem.FeeName = row["FEE"].ToString();
ledgerItem.OrNumber = prow["OR"].ToString();
ledgerItem.PaymentDate = Convert.ToDateTime(prow["PAYMENT DATE"]);
ledgerItem.AssessmentAmount = Convert.ToDouble(row["AMOUNT"]);
ledgerItem.AssessmentTotal = Assess.Total;
foreach (PaymentDetail det in paylist)
{
if (ledgerItem.FeeCode.Equals(det.Code))
{
ledgerItem.PaidAmount = det.Amount;
break;
}
else
{
ledgerItem.PaidAmount = 0;
}
}
ledger.Add(ledgerItem);
}
}
List <PaymentDetail> assList = new List <PaymentDetail>();
foreach (DataRow row in Assess.AssessmentDetail.Rows)
{
PaymentDetail pd = new PaymentDetail();
pd.Code = row["CODE"].ToString();
pd.Name = row["FEE"].ToString();
pd.Amount = Convert.ToDouble(row["AMOUNT"]);
assList.Add(pd);
}
List <Student> studList = new List <Student>();
studList.Add(student);
ReportDataSource dsStud = new ReportDataSource();
dsStud.Name = "dsStudent";
dsStud.Value = studList;
RViewer.LocalReport.DataSources.Add(dsStud);
ReportDataSource dsLedger = new ReportDataSource();
dsLedger.Name = "dsPayment";
dsLedger.Value = ledger;
RViewer.LocalReport.DataSources.Add(dsLedger);
}
public PTAReceipt(ReportViewer rv, string report, Student student, string or_number) : base(rv, report, student, or_number)
{
}
