private DataTable GetItemMonth()
{
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT itemName, SUM(TOTAL_DISCOUNTED_ITEM) AS Expr1 FROM sales_report_item_view WHERE(MONTHNAME(_date) = '" + ((ComboBoxItem)ComboBoxMonth.SelectedItem).Content.ToString() + "') GROUP BY itemName ";
DatasetReportSales.SalesItemDataTable dSItem = new DatasetReportSales.SalesItemDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSItem);
return(dSItem);
}
private DataTable GetItem()
{
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT itemName, SUM(TOTAL_DISCOUNTED_ITEM) AS Expr1 FROM sales_report_item_view GROUP BY itemName";
DatasetReportSales.SalesItemDataTable dSItem = new DatasetReportSales.SalesItemDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSItem);
return(dSItem);
}
private DataTable GetItemRange()
{
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT itemName, SUM(TOTAL_DISCOUNTED_ITEM) AS Expr1 FROM sales_report_item_view WHERE(_date BETWEEN '" + DateStart.SelectedDate.Value.ToString("yyyy-MM-dd") + "' AND '" + DateEnd.SelectedDate.Value.ToString("yyyy-MM-dd") + "') GROUP BY itemName ";
DatasetReportSales.SalesItemDataTable dSItem = new DatasetReportSales.SalesItemDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSItem);
return(dSItem);
}
