private void RecieptPrint_Load(object sender, EventArgs e)
{
int CBId = new DAO().getLastCBId();
DataTable ds = new DAO().getRecieptReportData(CBId);
foreach (DataRow row in ds.Rows)
{
//crPaymentVoucher1.SetDataSource(lstInvoice);
string InvoiceNo = "";
string To = row[0].ToString();
try
{
InvoiceNo = row[8].ToString();
}
catch (Exception ex)
{
}
DateTime Date = DateTime.Parse(row[2].ToString());
string VoucherNo = row[10].ToString();
//string BrokerAmount = row["BrokeryAmount"].ToString();
//string BrokerName = row["BrokerName"].ToString();
string Cash = " ";
decimal Amount = 0;
string ChequeNo = "";
string BankCode = "";
string Expense = row[13].ToString();
if (Expense == "Purchase")
{
Expense = "";
}
else
{
To = "";
}
string AmountType = row["AmountType"].ToString();
if (AmountType == "Cash")
{
Cash = "\u221A";
}
else
{
ChequeNo = row[11].ToString();
BankCode = row[12].ToString();
}
Amount = decimal.Parse(row[7].ToString());
string SumOf = NumberToWords.ConvertToWords(Amount.ToString());
string Narrative = row[4].ToString();
crPaymentVoucher1.SetParameterValue("To", To);
crPaymentVoucher1.SetParameterValue("InvoiceNo", InvoiceNo);
crPaymentVoucher1.SetParameterValue("Date", Date.Date);
crPaymentVoucher1.SetParameterValue("Cash", Cash);
crPaymentVoucher1.SetParameterValue("Amount", Amount);
crPaymentVoucher1.SetParameterValue("PVNo", VoucherNo);
crPaymentVoucher1.SetParameterValue("SumOf", SumOf);
crPaymentVoucher1.SetParameterValue("Cheque", ChequeNo);
crPaymentVoucher1.SetParameterValue("BankCode", BankCode);
crPaymentVoucher1.SetParameterValue("Narrative", Narrative);
crPaymentVoucher1.SetParameterValue("Expense", Expense);
}
crystalReportViewer1.ReportSource = crPaymentVoucher1;
}
