private void linkLabel5_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
frmInventoryReport frm = new frmInventoryReport();
frm.SoldItems("SELECT c.pcode,p.pdesc, c.price, sum(c.qty) AS tot_qty,sum(c.disc) as tot_disc, sum(c.total) as total from tblcart as c INNER JOIN tblproduct as p on c.pcode = p.pcode where status like 'Sold' and cast(sdate as date) BETWEEN CAST('" + datePicker1.Value.ToString("yyyy-MM-dd") + "' AS DATE) and CAST('" + datePicker2.Value.ToString("yyyy-MM-dd") + "' AS DATE) GROUP BY c.pcode, p.pdesc, c.price", " From : " + datePicker1.Value.ToString("yyyy-MM-dd") + " To : " + datePicker2.Value.ToString("yyyy-MM-dd"));
frm.ShowDialog();
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
frmInventoryReport frm = new frmInventoryReport();
frm.LoadReport();
frm.ShowDialog();
}
private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
frmInventoryReport f = new frmInventoryReport();
string param = "Date Covered: " + dateTimePicker1.Value.ToString("yyyy-MM-dd") + " - " + dateTimePicker2.Value.ToString("yyyy-MM-dd");
f.LoadCancelledOrderReport("select * from VWCancelledOrder where cast(sdate as date) BETWEEN CAST('" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' AS DATE) and CAST('" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "' AS DATE)", param);
f.ShowDialog();
}
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
frmInventoryReport frm = new frmInventoryReport();
string param = "Date Convered: " + DateP1.Value.ToString("yyyy-MM-dd") + " - " + DateP2.Value.ToString("yyyy-MM-dd");
frm.LoadStockInReport("select * from vwstock where cast(sdate as date) BETWEEN CAST('" + DateP1.Value.ToString("yyyy-MM-dd") + "' AS DATE) and CAST('" + DateP2.Value.ToString("yyyy-MM-dd") + "' AS DATE) and status like 'Done'", param);
frm.ShowDialog();
}
private void linkLabel6_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
frmInventoryReport frm = new frmInventoryReport();
if (cboTopSelect.Text == "SORT BY QTY")
{
//cmd = new MySqlCommand("select pcode, pdesc,ifnull(sum(qty),0) as qty, ifnull(sum(total),0) as total from vwSoldItems where cast(sdate as date) BETWEEN CAST('" + date1.Value.ToString("yyyy-MM-dd") + "' AS DATE) and CAST('" + date2.Value.ToString("yyyy-MM-dd") + "' AS DATE) and status like 'Sold' group by pcode,pdesc order by qty desc", con);
frm.LoadTopSelling("select pcode, pdesc,sum(qty) as qty, ifnull(sum(total),0) as total from vwSoldItems where cast(sdate as date) BETWEEN CAST('" + date1.Value.ToString("yyyy-MM-dd") + "' AS DATE) and CAST('" + date2.Value.ToString("yyyy-MM-dd") + "' AS DATE) and status like 'Sold' group by pcode,pdesc order by qty desc", " From : " + date1.Value.ToString("yyyy-MM-dd") + " To : " + date2.Value.ToString("yyyy-MM-dd"), "TOP SELLING ITEMS SORTED BY QTY");
}
else if (cboTopSelect.Text == "SORT BY TOTAL AMOUNT")
{
frm.LoadTopSelling("select pcode, pdesc,ifnull(sum(qty),0) as qty, ifnull(sum(total),0) as total from vwSoldItems where cast(sdate as date) BETWEEN CAST('" + date1.Value.ToString("yyyy-MM-dd") + "' AS DATE) and CAST('" + date2.Value.ToString("yyyy-MM-dd") + "' AS DATE) and status like 'Sold' group by pcode,pdesc order by total desc", " From : " + date1.Value.ToString("yyyy-MM-dd") + " To : " + date2.Value.ToString("yyyy-MM-dd"), "TOP SELLING ITEMS SORTED BY TOTAL AMOUNT");
}
frm.ShowDialog();
}
