private void btnSearch_Click(object sender, EventArgs e)
{
ExpenseReport objrep = new ExpenseReport();
rptViewer objView = new rptViewer();
objrep.SetParameterValue("@mindate", txtMinDate.Value);
objrep.SetParameterValue("@maxdate", txtmaxdate.Value);
ExpenseBL objBL = new ExpenseBL()
{
mindate = Convert.ToDateTime(txtMinDate.Text),
maxdate = Convert.ToDateTime(txtmaxdate.Text)
};
var dt = objBL.SelectByDateDiff();
if (dt != null)
{
objrep.SetDataSource(dt);
objView.crptViewer.ReportSource = objrep;
objView.WindowState = FormWindowState.Maximized;
objView.ShowDialog();
}
else
{
MessageBox.Show("No Record Found");
}
//crptViewerExpense.ReportSource = objrep;
}
private ExpenseReport GetReport(ExpenseModel data)
{
var report = new ExpenseReport();
var dataTable = GetDataTable();
var dataSet = new System.Data.DataSet();
dataSet.Tables.Add(dataTable);
for (int i = 0; i < data.ExpenseItems.Count; i++)
{
DataRow row = dataSet.Tables["ExpenseItem"].NewRow();
row["No"] = i + 1;
row["Name"] = data.ExpenseItems[i].Name;
row["Income"] = data.ExpenseItems[i].Type == 0 ? data.ExpenseItems[i].Money : 0;
row["Expense"] = data.ExpenseItems[i].Type == 1 ? data.ExpenseItems[i].Money : 0;
dataSet.Tables["ExpenseItem"].Rows.Add(row);
}
report.SetDataSource(dataSet);
report.SetParameterValue("FullName", data.FullName);
report.SetParameterValue("Date", data.Date);
return(report);
}
