private void btnPreview_Click(object sender, EventArgs e)
{
if (!GlobalFunctions.checkRights("tsmSalesReport", "Preview"))
{
return;
}
try
{
loStockCardRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockCardRpt.Database.Tables[1].SetDataSource(ldtReports);
loStockCardRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockCardRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockCardRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockCardRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockCardRpt.SetParameterValue("Title", "Stock Card");
loStockCardRpt.SetParameterValue("SubTitle", "Stock Card");
loStockCardRpt.SetParameterValue("ItemDescription", dgvStockList.CurrentRow.Cells[1].Value.ToString());
loStockCardRpt.SetParameterValue("Unit", dgvStockList.CurrentRow.Cells[4].Value.ToString());
loStockCardRpt.SetParameterValue("QtyOnHand",string.Format("{0:n}", decimal.Parse(dgvStockList.CurrentRow.Cells[5].Value.ToString())));
loReportViewer.crystalReportViewer.ReportSource = loStockCardRpt;
loReportViewer.ShowDialog();
}
catch { }
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (!GlobalFunctions.checkRights("tsmStockCard", "Preview"))
{
return;
}
decimal _qtyTotalIn = 0;
decimal _qtyTotalOut = 0;
decimal _qtyBegBal = 0;
foreach (DataRow _dr in loStock.getStockCardBegBal(dtpFromDate.Value, dgvStockList.CurrentRow.Cells[0].Value.ToString(), cboLocation.SelectedValue.ToString()).Rows)
{
_qtyTotalIn += decimal.Parse(_dr[0].ToString());
_qtyTotalOut += decimal.Parse(_dr[1].ToString());
_qtyBegBal += decimal.Parse(_dr[2].ToString());
}
loStockCardRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockCardRpt.Database.Tables[1].SetDataSource(ldtList);
loStockCardRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockCardRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockCardRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockCardRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockCardRpt.SetParameterValue("Title", "Stock Card");
loStockCardRpt.SetParameterValue("SubTitle", "Stock Card");
loStockCardRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value));
loStockCardRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value));
loStockCardRpt.SetParameterValue("Stock", dgvStockList.CurrentRow.Cells[1].Value.ToString());
loStockCardRpt.SetParameterValue("Location", cboLocation.Text);
loStockCardRpt.SetParameterValue("QtyTotalIn", string.Format("{0:n}", _qtyTotalIn));
loStockCardRpt.SetParameterValue("QtyTotalOut", string.Format("{0:n}", _qtyTotalOut));
loStockCardRpt.SetParameterValue("QtyBegBal", string.Format("{0:n}", _qtyBegBal));
loReportViewer.crystalReportViewer.ReportSource = loStockCardRpt;
loReportViewer.ShowDialog();
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPreview_Click");
em.ShowDialog();
return;
}
}