private void btnPrint_Click(object sender, EventArgs e)
{
if (txtSearch.Text == "")
{
MessageBox.Show("Please select End-User or Service!");
btnFind.Focus();
}
else if (cboSearchCriteria.Text == "End User")
{
frmReportViewer PreviewDialog = new frmReportViewer("Inventory_Details", "SELECT * FROM view_Inventory_Details where fk_End_User_Id = '" + GlobalClass.GlobalEmployeeId + "' ");
PreviewDialog.ShowDialog();
}
else if (cboSearchCriteria.Text == "Item Description")
{
frmReportViewer PreviewDialog = new frmReportViewer("Inventory_Details", "SELECT * FROM view_Inventory_Details where pk_Id = '" + GlobalClass.GlobalInvItemId + "' ");
PreviewDialog.ShowDialog();
}
else
{
frmReportViewer PreviewDialog = new frmReportViewer("Inventory_Details", "SELECT * FROM view_Inventory_Details where Service_Code = '" + txtSearch.Text + "' ");
PreviewDialog.ShowDialog();
}
}
private void func_Print_Tag_Per_Item()
{
frmReportViewer PreviewDialog = new frmReportViewer("Property_Tag", "SELECT * FROM view_Inventory_Details where pk_Id = '" + GlobalClass.GlobalInvItemId + "' and Tag_Size = 'BIG TAG'");
PreviewDialog.ShowDialog();
frmReportViewer PreviewDialog2 = new frmReportViewer("Property_Tag_Small", "SELECT * FROM view_Inventory_Details where pk_Id = '" + GlobalClass.GlobalInvItemId + "'and Tag_Size = 'SMALL TAG'");
PreviewDialog2.ShowDialog();
}
private void func_Print_Tag_Per_Service()
{
frmReportViewer PreviewDialog = new frmReportViewer("Property_Tag", "SELECT * FROM view_Inventory_Details where Service_Code = '" + txtSearch.Text + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier') and Tag_Size = 'BIG TAG'");
PreviewDialog.ShowDialog();
frmReportViewer PreviewDialog2 = new frmReportViewer("Property_Tag_Small", "SELECT * FROM view_Inventory_Details where Service_Code = '" + txtSearch.Text + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier') and Tag_Size = 'SMALL TAG'");
PreviewDialog2.ShowDialog();
}
private void func_Print_Tag_Per_User()
{
frmReportViewer PreviewDialog = new frmReportViewer("Property_Tag", "SELECT * FROM view_Inventory_Details where fk_End_User_Id = '" + GlobalClass.GlobalEmployeeId + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier') and Tag_Size = 'BIG TAG' ");
PreviewDialog.ShowDialog();
frmReportViewer PreviewDialog2 = new frmReportViewer("Property_Tag_Small", "SELECT * FROM view_Inventory_Details where fk_End_User_Id = '" + GlobalClass.GlobalEmployeeId + "' and (Status != 'Disposed' and Status != 'Cancelled Property No.' and Status != 'Return to Supplier' and Status != 'Replaced by Supplier') and Tag_Size = 'SMALL TAG'");
PreviewDialog2.ShowDialog();
}
private void func_Print_Document()
{
frmReportViewer PreviewDialog = new frmReportViewer("Return_Slip", "SELECT * FROM view_PullOutRecords where RRP_No = '" + Doc_No + "' ");
PreviewDialog.ShowDialog();
cboSearchCriteria.SelectedIndex = 0;
txtSearch.Text = "";
cboSearchCriteria.Focus();
Doc_No = "";
}
private void func_Print_IAR()
{
frmReportViewer PreviewDialog = new frmReportViewer("Receiving_Report", "SELECT * FROM view_Receiving_Report where IAR_No = '" + IAR_No + "' ");
PreviewDialog.ShowDialog();
cboSearchCriteria.SelectedIndex = 0;
txtSearch.Text = "";
cboSearchCriteria.Focus();
IAR_No = "";
}
private void btnPrint_Click(object sender, EventArgs e)
{
if (GlobalClass.GlobalOfficerId == "")
{
MessageBox.Show("Please select accountable officer!");
btnFind.Focus();
}
else
{
frmReportViewer PreviewDialog = new frmReportViewer("Account_Report", "SELECT * FROM view_Inventory_Details where fk_Accountable_Employee_Id = '" + GlobalClass.GlobalOfficerId + "' order by [End User]");
PreviewDialog.ShowDialog();
}
}
private void func_GenerateReport()
{
if (Doc_Type == "PAR")
{
frmReportViewer PreviewDialog = new frmReportViewer("PAR_Report", "SELECT * FROM view_Inventory_Details where Document_No = '" + Document_No + "'");
PreviewDialog.ShowDialog();
}
if (Doc_Type == "ICS")
{
frmReportViewer PreviewDialog = new frmReportViewer("ICS_Report", "SELECT * FROM view_Inventory_Details where Document_No = '" + Document_No + "'");
PreviewDialog.ShowDialog();
}
}
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();
}
