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();
}
