private void previewInventoryDetail(string pInventoryId)
{
try
{
foreach (DataRow _dr in loInventory.getAllData("Stock Adjustment", "", pInventoryId, "").Rows)
{
loStockAdjustmentDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockAdjustmentDetailRpt.Database.Tables[1].SetDataSource(loInventoryDetail.getInventoryDetails("ViewAll", pInventoryId));
loStockAdjustmentDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockAdjustmentDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockAdjustmentDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockAdjustmentDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockAdjustmentDetailRpt.SetParameterValue("Title", "Stock Adjustment (" + _dr["Type"].ToString() + ")");
loStockAdjustmentDetailRpt.SetParameterValue("SubTitle", "Stock Adjustment (" + _dr["Type"].ToString() + ")");
loStockAdjustmentDetailRpt.SetParameterValue("SAId", _dr["Id"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Date", _dr["Date"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("PreparedBy", _dr["Prepared By"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Supplier", _dr["Supplier"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Customer", _dr["Customer"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("FinalizedBy", _dr["Finalized By"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loStockAdjustmentDetailRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void previewDetails(string pHeaderId)
{
try
{
foreach (DataRow _dr in loInventoryHeader.getAllData("", pHeaderId, "", "").Rows)
{
DataTable _dt = loInventoryDetail.getAllData(_dr[0].ToString());
loStockAdjustmentDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockAdjustmentDetailRpt.Database.Tables[1].SetDataSource(_dt);
loStockAdjustmentDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockAdjustmentDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockAdjustmentDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockAdjustmentDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockAdjustmentDetailRpt.SetParameterValue("Title", "Stock Adjustment Slip");
loStockAdjustmentDetailRpt.SetParameterValue("SubTitle", "Stock Adjustment Slip");
loStockAdjustmentDetailRpt.SetParameterValue("Id", _dr["Id"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Date", string.Format("{0:MM-dd-yyyy}", DateTime.Parse(_dr["Date"].ToString())));
foreach (DataRow _dr1 in _dt.Rows)
{
loStockAdjustmentDetailRpt.SetParameterValue("Location", _dr1["Location"].ToString());
}
loStockAdjustmentDetailRpt.SetParameterValue("Type", _dr["Type"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Supplier", _dr["Supplier"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Customer", _dr["Customer"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("AdjustedBy", _dr["Username"].ToString());
loStockAdjustmentDetailRpt.SetParameterValue("Remarks", _dr["Remarks"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loStockAdjustmentDetailRpt;
loReportViewer.ShowDialog();
}
}
catch { }
}