private void stockReportToolStripMenuItem_Click(object sender, EventArgs e) { StockReportForm stockReport = new StockReportForm(); stockReport.Show(); }
private void btnReport_Click(object sender, EventArgs e) { String query = "SELECT B.BK_TITLE,P.PUB_NAME,A.AUT_NAME,C.CAT_NAME,S.BOOK_QTY FROM STOCK S INNER JOIN BOOK B ON S.BOOK_ID = B.BOOK_ID INNER JOIN PUBLISHER P ON B.PUB_ID = P.PUB_ID INNER JOIN CATEGORY C ON C.CAT_ID = B.CAT_ID INNER JOIN AUTHOR A ON B.AUT_ID = A.AUT_ID"; String file = "StockReport.rpt"; if (checkView.Checked && ckbxdate.Checked) { switch (cbViewBy.Text) { case "Publisher": query = "SELECT B.BK_TITLE,P.PUB_NAME,A.AUT_NAME,C.CAT_NAME,S.BOOK_QTY FROM STOCK S INNER JOIN BOOK B ON S.BOOK_ID = B.BOOK_ID INNER JOIN PUBLISHER P ON B.PUB_ID = P.PUB_ID INNER JOIN CATEGORY C ON C.CAT_ID = B.CAT_ID INNER JOIN AUTHOR A ON B.AUT_ID = A.AUT_ID WHERE P.PUB_NAME = N'" + cbView.Text + "' AND S.CREATED_DTAE BETWEEN '" + dtpStartDate.Text + "' AND '" + dtpEndDate.Text + "'"; break; case "Category": query = "SELECT B.BK_TITLE,P.PUB_NAME,A.AUT_NAME,C.CAT_NAME,S.BOOK_QTY FROM STOCK S INNER JOIN BOOK B ON S.BOOK_ID = B.BOOK_ID INNER JOIN PUBLISHER P ON B.PUB_ID = P.PUB_ID INNER JOIN CATEGORY C ON C.CAT_ID = B.CAT_ID INNER JOIN AUTHOR A ON B.AUT_ID = A.AUT_ID WHERE C.CAT_NAME = N'" + cbView.Text + "' AND S.CREATED_DTAE BETWEEN '" + dtpStartDate.Text + "' AND '" + dtpEndDate.Text + "'"; break; case "Author": query = "SELECT B.BK_TITLE,P.PUB_NAME,A.AUT_NAME,C.CAT_NAME,S.BOOK_QTY FROM STOCK S INNER JOIN BOOK B ON S.BOOK_ID = B.BOOK_ID INNER JOIN PUBLISHER P ON B.PUB_ID = P.PUB_ID INNER JOIN CATEGORY C ON C.CAT_ID = B.CAT_ID INNER JOIN AUTHOR A ON B.AUT_ID = A.AUT_ID WHERE A.AUT_NAME = N'" + cbView.Text + "' AND S.CREATED_DTAE BETWEEN '" + dtpStartDate.Text + "' AND '" + dtpEndDate.Text + "'"; break; } } else if (checkView.Checked) { switch (cbViewBy.Text) { case "Publisher": query = "SELECT B.BK_TITLE,P.PUB_NAME,A.AUT_NAME,C.CAT_NAME,S.BOOK_QTY FROM STOCK S INNER JOIN BOOK B ON S.BOOK_ID = B.BOOK_ID INNER JOIN PUBLISHER P ON B.PUB_ID = P.PUB_ID INNER JOIN CATEGORY C ON C.CAT_ID = B.CAT_ID INNER JOIN AUTHOR A ON B.AUT_ID = A.AUT_ID WHERE P.PUB_NAME = N'" + cbView.Text + "'"; break; case "Category": query = "SELECT B.BK_TITLE,P.PUB_NAME,A.AUT_NAME,C.CAT_NAME,S.BOOK_QTY FROM STOCK S INNER JOIN BOOK B ON S.BOOK_ID = B.BOOK_ID INNER JOIN PUBLISHER P ON B.PUB_ID = P.PUB_ID INNER JOIN CATEGORY C ON C.CAT_ID = B.CAT_ID INNER JOIN AUTHOR A ON B.AUT_ID = A.AUT_ID WHERE C.CAT_NAME = N'" + cbView.Text + "'"; break; case "Author": query = "SELECT B.BK_TITLE,P.PUB_NAME,A.AUT_NAME,C.CAT_NAME,S.BOOK_QTY FROM STOCK S INNER JOIN BOOK B ON S.BOOK_ID = B.BOOK_ID INNER JOIN PUBLISHER P ON B.PUB_ID = P.PUB_ID INNER JOIN CATEGORY C ON C.CAT_ID = B.CAT_ID INNER JOIN AUTHOR A ON B.AUT_ID = A.AUT_ID WHERE A.AUT_NAME = N'" + cbView.Text + "'"; break; } } else if (ckbxdate.Checked) { query = "SELECT B.BK_TITLE,P.PUB_NAME,A.AUT_NAME,C.CAT_NAME,S.BOOK_QTY FROM STOCK S INNER JOIN BOOK B ON S.BOOK_ID = B.BOOK_ID INNER JOIN PUBLISHER P ON B.PUB_ID = P.PUB_ID INNER JOIN CATEGORY C ON C.CAT_ID = B.CAT_ID INNER JOIN AUTHOR A ON B.AUT_ID = A.AUT_ID WHERE S.CREATED_DTAE BETWEEN '" + dtpStartDate.Text + "' AND '" + dtpEndDate.Text + "'"; } switch (cbViewBy.Text) { case "Publisher": file = "StockPublisherReport.rpt"; break; case "Category": file = "StockCategoryReport.rpt"; break; case "Author": file = "StockAuthorReport.rpt"; break; } StockReportForm bkreport = new StockReportForm(query, file); bkreport.Show(); }