private void btnShow_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection(Community.DBLayer.con_String);
conn.Open();
SqlCommand cmd = new SqlCommand("usp_DailyTransactions_Report", conn);
DataTable dt = new DataTable();
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter para = cmd.Parameters.Add("@Date", SqlDbType.DateTime);
SqlParameter paraToDate = cmd.Parameters.Add("@ToDate", SqlDbType.DateTime);
para.Value = Convert.ToDateTime(dateTimePicker1.Text);
paraToDate.Value = Convert.ToDateTime(dtpToDate.Text);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
MCKJ.ComDataSet.tblDailyTransactionsDataTable dtDaily = new ComDataSet.tblDailyTransactionsDataTable();
MCKJ.ComDataSet ds = new ComDataSet();
for (int i = 0; i < dt.Rows.Count; i++)
{
ds.tblDailyTransactions.Rows.Add();
for (int x = 0; x < dt.Columns.Count; x++)
{
ds.tblDailyTransactions.Rows[i][x] = dt.Rows[i][x];
}
}
MCKJ.Reports.Accounts.DailyCashBook.frmViewer frm = new MCKJ.Reports.Accounts.DailyCashBook.frmViewer();
MCKJ.Reports.Accounts.DailyCashBook.rptCashBook rpt = new MCKJ.Reports.Accounts.DailyCashBook.rptCashBook();
frm.crystalReportViewer1.ReportSource = rpt;
rpt.SetDataSource(ds);
rpt.SetParameterValue("Date", Convert.ToDateTime(dateTimePicker1.Text));
rpt.SetParameterValue("ToDate", Convert.ToDateTime(dtpToDate.Text));
frm.Show();
//frm.Text = "Daily Transactions";
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("An unknown error occured:\n\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
StringBuilder query = new StringBuilder();
StringBuilder filter = new StringBuilder();
query.Append(@"SELECT tblHelp.ID, tblHelp.FCardNo, tblHelp.HeadofFamily, tblHelp.FName, tblHelp.Orakh, tblHelp.ReceiveDate, tblHelp.Status, tblHelp.Amount,
tblHelp.CompleteDate, tblHelp.SerialNo, tblHelp.Remarks, tblAids.Aid, tblFamilyMember.MemberName, tblHelp.AidFrom
FROM tblHelp INNER JOIN
tblAids ON tblHelp.HelpType = tblAids.ID INNER JOIN
tblFamilyMember ON tblHelp.Name = tblFamilyMember.FamilyMemberID ");
bool isWhereIncluded = false;
if (chkByAidType.Checked)
{
query.Append("where HelpType =" + cmbAidType.SelectedValue);
isWhereIncluded = true;
filter.Append("Aid Type=" + cmbAidType.Text + ",");
}
if (chkByFamilyCard.Checked)
{
if (!isWhereIncluded)
{
query.Append(" where "); isWhereIncluded = true;
}
else
{
query.Append(" AND ");
}
query.Append(" tblHelp.FCardNo='" + txtFamilyCardNo.Text.PadLeft(5, '0') + "'");
filter.Append("Family Card=" + txtFamilyCardNo.Text.PadLeft(5, '0') + ",");
}
if (chkByOrakh.Checked)
{
if (!isWhereIncluded)
{
query.Append(" where "); isWhereIncluded = true;
}
else
{
query.Append(" AND ");
}
query.Append(" tblHelp.Orakh='" + cmbOrakh.Text + "'");
filter.Append("Orakh=" + cmbOrakh.Text + ",");
}
if (chkByStatus.Checked)
{
if (!isWhereIncluded)
{
query.Append(" where "); isWhereIncluded = true;
}
else
{
query.Append(" AND ");
}
query.Append(" tblHelp.Status='" + cmbStatus.Text + "'");
filter.Append("Status=" + cmbStatus.Text + ",");
}
if (chkAidFrom.Checked)
{
query.Append("where AidFrom ='" + cmbAidFrom.Text + "'");
isWhereIncluded = true;
filter.Append("Aid From=" + cmbAidFrom.Text + ",");
}
query.Append(" ORDER BY tblHelp.FCardNo Asc");
Community.DBLayer DBLayer = new Community.DBLayer();
DataTable dt = DBLayer.GetDataByQuery(query.ToString());
MCKJ.ComDataSet dsCom = new ComDataSet();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dsCom.tblHelp.NewRow();
int index = dsCom.tblHelp.Rows.Count - 1;
for (int j = 0; j < dsCom.tblHelp.Columns.Count; j++)
{
dr[dsCom.tblHelp.Columns[j].ColumnName] = dt.Rows[i][dsCom.tblHelp.Columns[j].ColumnName];
}
dsCom.tblHelp.Rows.Add(dr);
}
MCKJ.Reports.FamilyAid.rptFamilyAid rptAidRpt = new rptFamilyAid();
MCKJ.Reports.FamilyAid.frmViewer frmViewer = new frmViewer();
rptAidRpt.SetDataSource(dsCom);
frmViewer.crystalReportViewer1.ReportSource = rptAidRpt;
string filterSettings = filter.ToString();
rptAidRpt.SetParameterValue("Filter", "");
if (filterSettings.Length > 0)
{
rptAidRpt.SetParameterValue("Filter", filterSettings.Substring(0, filterSettings.Length - 1));
}
frmViewer.Show();
//if (chkByAidType.Checked == false && chkByFamilyCard.Checked == false && chkByOrakh.Checked == false && chkByStatus.Checked == false)
//{
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
