public void CheckDisbursementVoucher(int id)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
List <DisbursementVoucherModel> DVList = new List <DisbursementVoucherModel>();
db = new ImusCityHallEntities();
DVList = new List <DisbursementVoucherModel>();
var disburse = db.GetDisbursementVoucher(id).ToList();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
foreach (var x in disburse)
{
DisbursementVoucherModel dvl = new DisbursementVoucherModel();
dvl.Amount = x.Amount.HasValue ? x.Amount.Value : 0;
dvl.Certification = x.Certification;
dvl.CompanyAddress = x.CompanyAddress;
dvl.CompanyName = x.CompanyName;
dvl.DateCreated = x.DateCreated.Value;
dvl.DepartmentCode = x.DepartmentCode;
dvl.Description = x.Explanation;
dvl.DocumentCompleted = x.DocumentCompleted;
dvl.Obligated = x.Obligated;
dvl.ObligationRequestNo = x.ObligationRequestNo;
dvl.TIN_EmpNo = x.TIN_EmpNo;
dvl.Unit_Project = x.Unit_Project;
dvl.VoucherNo = x.VoucherNo;
dvl.PaymentName = x.PaymentType;
dvl.Name = x.FundName;
dvl.Signatory = SystemClass.GetSignatory(signatories.CityAccountant);
dvl.Signatory2 = SystemClass.GetSignatory(signatories.CityTreasurer);
dvl.Signatory3 = SystemClass.GetSignatory(signatories.CityMayor);
DVList.Add(dvl);
}
ReportDocument report;
report = new DisbursementVoucherReport();
report.SetDataSource(DVList);
report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID));
report.SetParameterValue("actingmayor", signatories.UseActingMayor);
reportviewer.ViewerCore.ReportSource = report;
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
public void CheckReport(int id)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
CDSSignatory signatories = db.CDSSignatories.FirstOrDefault();
CheckModel check = new CheckModel();
ImusCityGovernmentSystem.Model.Check checklist = db.Checks.Find(id);
check.CheckNo = checklist.CheckNo;
check.CheckDate = checklist.DateCreated.Value;
check.CompanyName = checklist.Disbursement.Payee == null ? checklist.Disbursement.PayeeName : checklist.Disbursement.Payee.CompanyName;
CurrencyToWords convert = new CurrencyToWords();
double amount = Convert.ToDouble(checklist.Amount.Value);
check.AmountInWords = convert.NumberToWords(amount).ToUpper();
check.CheckDescription = checklist.CheckDescription;
check.VoucherNo = checklist.Disbursement.VoucherNo;
check.Amount = checklist.Amount.Value;
check.Signatory1 = SystemClass.GetSignatory(signatories.CityMayor);
check.Signatory2 = SystemClass.GetSignatory(signatories.CityTreasurer);
ReportDocument report;
switch (bankName)
{
case "LB":
report = new LBCheckReport();
report.SetDataSource(new[] { check });
reportviewer.ViewerCore.ReportSource = report;
break;
case "UCPB":
report = new UCPBCheckReport();
report.SetDataSource(new[] { check });
reportviewer.ViewerCore.ReportSource = report;
break;
case "DBP":
report = new DBPCheckReport();
report.SetDataSource(new[] { check });
reportviewer.ViewerCore.ReportSource = report;
break;
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}