private void btnPrint_Click(object sender, EventArgs e)
{
if (GlobalClass.GlobalInvItemId == "")
{
MessageBox.Show("Please select item.");
}
else if (txtSearch.Text == "")
{
MessageBox.Show("Please select item.");
}
else
{
frmReportViewer PreviewDialog = new frmReportViewer("Property_Card", "SELECT * FROM view_ItemHistory where fk_Inv_Id = '" + GlobalClass.GlobalInvItemId + "' order by Date");
PreviewDialog.ShowDialog();
}
}
private void func_Print_Document()
{
if (Doc_Type == "PAR")
{
frmReportViewer PreviewDialog = new frmReportViewer("PAR_Report", "SELECT * FROM view_Inventory_Details where Document_No = '" + Doc_No + "'");
PreviewDialog.ShowDialog();
}
if (Doc_Type == "ICS")
{
frmReportViewer PreviewDialog = new frmReportViewer("ICS_Report", "SELECT * FROM view_Inventory_Details where Document_No = '" + Doc_No + "'");
PreviewDialog.ShowDialog();
}
cboSearchCriteria.SelectedIndex = 0;
txtSearch.Text = "";
cboSearchCriteria.Focus();
Doc_No = "";
}
private void btnGenerate_Click(object sender, EventArgs e)
{
if (txtCategory.Text == "")
{
MessageBox.Show("Please select criteria for the report generation");
btnFind.Focus();
}
else if (GlobalClass.GlobalArticleId == "")
{
MessageBox.Show("Please select criteria for the report generation");
btnFind.Focus();
}
else
{
frmReportViewer PreviewDialog = new frmReportViewer("Inventory_Report", "SELECT * FROM view_Inventory_Details where fk_Article_Id = '" + GlobalClass.GlobalArticleId + "' AND (Status != 'FOR DISPOSAL' and Status != 'CANCELLED PROPERTY NO.' and Status != 'RETURN TO SUPPLIER' and Status != 'REPLACED BY SUPPLIER' and Status != 'UNSERVICEABLE' and Status != 'EXPIRED')");
PreviewDialog.ShowDialog();
func_Reset();
}
}
private void func_Print_IRRUP()
{
frmReportViewer PreviewDialog = new frmReportViewer("IRRUP", "SELECT * FROM view_Disposal_Record where Document_No = '" + Doc_No + "'");
PreviewDialog.ShowDialog();
}
private void func_Print_RS()
{
frmReportViewer PreviewDialog = new frmReportViewer("Return_Slip", "SELECT * FROM view_PullOutRecords where RRP_No = '" + DocNo + "' ");
PreviewDialog.ShowDialog();
}
private void func_Print_Tag_Small()
{
frmReportViewer PreviewDialog = new frmReportViewer("Property_Tag_Small", "SELECT * FROM view_Inventory_Details where Document_No = '" + Document_No + "' and Tag_Size = 'SMALL TAG' ");
PreviewDialog.ShowDialog();
}
private void func_Print_PTR()
{
frmReportViewer PreviewDialog = new frmReportViewer("Transfer_Report", "SELECT * FROM view_Disposal_Record where Document_No = '" + DocNo + "'");
PreviewDialog.ShowDialog();
}
private void pIFToolStripMenuItem_Click(object sender, EventArgs e)
{
frmReportViewer PreviewDialog = new frmReportViewer("Inventory_PIF", "SELECT * FROM view_Inventory_Details where Category_Name != 'EXPENSE'AND (Status != 'FOR DISPOSAL' and Status != 'CANCELLED PROPERTY NO.' and Status != 'RETURN TO SUPPLIER' and Status != 'REPLACED BY SUPPLIER' and Status != 'UNSERVICEABLE' and Status != 'EXPIRED')");
PreviewDialog.ShowDialog();
}