public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptBDOListing rpt = new rptBDOListing();
rpt.Site = this.Site;
return(rpt);
}
public void loadBDOReport()
{
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
CrystalDecisions.Shared.TableLogOnInfo li;
//===============================================
// GETTING BANK INFO
//===============================================
adapter = new SqlDataAdapter("SELECT * FROM Bank WHERE Bank_Code ='BDO'", con);
DataTable dt = new DataTable();
adapter.Fill(dt);
//===============================================
// STRING QUERY
//===============================================
int icount = 0;
purpose = "";
foreach (ListViewItem lItem in listView1.Items)
{
if (lItem.Checked == true)
{
icount = icount + 1;
}
}
for (int i = 0; i < listView1.Items.Count; i++)
{
if (listView1.Items[i].Checked == true)
{
purpose += "'" + getBetween(listView1.Items[i].Text, "-") + "'";
if (i != icount - 1)
{
purpose += " , ";
}
}
}
string str = "select distinct account_No,sum(Amount) as Amount,Name FROM ATM where Bank_Code='" + cmbBank.Text + "' and Deposited is null and purpose in (" + purpose + ") GROUP BY Account_No,Name Order by Name ASC";
SqlDataAdapter adapter1 = new SqlDataAdapter(str, con);
DataTable dt1 = new DataTable();
DataSet ds = new DataSet();
string contactPerson = dt.Rows[0].ItemArray[7].ToString();
string bnkName = dt.Rows[0].ItemArray[1].ToString();
string branchName = dt.Rows[0].ItemArray[2].ToString();
ReportsForms.rptBDOListing cr = new ReportsForms.rptBDOListing();
ReportsForms.rptBDO rpt = new ReportsForms.rptBDO();
li = new TableLogOnInfo();
li.ConnectionInfo.IntegratedSecurity = false;
adapter1.Fill(ds, "ATM");
dt = ds.Tables["ATM"];
cr.SetDataSource(ds.Tables["ATM"]);
//cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW");
cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog);
cr.SetParameterValue("maincontactperson", contactPerson);
cr.SetParameterValue("mainbankName", bnkName);
cr.SetParameterValue("mainbranch", branchName);
try
{
string num = txtDepositAmount.Text;
string word;
if (txtDepositAmount.Text == "")
{
txtDepositAmount.Text = "";
}
else
{
number = decimal.Parse(num.ToString());
if (number.ToString() == "0")
{
MessageBox.Show("The number in currency fomat is \nZero Only");
}
else
{
word = Classes.clsSavingsDataEntry.ConvertToWords(number.ToString());
}
}
Console.ReadKey();
}
catch (System.Exception ex)
{
}
string Msg = Classes.clsSavingsDataEntry.ConvertToWords(number.ToString()) + " (P " + txtDepositAmount.Text + ")";
cr.SetParameterValue("mainmsg", Msg);
cr.SetParameterValue("mainaccntNumber", txtAccountNo.Text);
cr.SetParameterValue("mainpurpose", "loans/savings/refund");
string dref = DateTime.Now.ToString("yyyy-MM-dd");
cr.SetParameterValue("mainrefno", "Reference No: BDO" + dref.Replace("-", "") + txtTrans.Text);
//Signature
cr.SetParameterValue("mainsig1Name", sig1name.Text);
cr.SetParameterValue("mainsig1pos", sig1pos.Text);
cr.SetParameterValue("mainsig2name", sig2name.Text);
cr.SetParameterValue("mainsig2pos", sig2pos.Text);
cr.SetParameterValue("mainsig3name", sig3name.Text);
cr.SetParameterValue("mainsig3pos", sig3pos.Text);
rpt.crystalReportViewer1.ReportSource = cr;
rpt.ShowDialog();
}
}