private DataTable GetPurchaseRange()
{
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = " SELECT itemName, SUM(Total) AS Expr1 FROM po_report_view WHERE(_date BETWEEN '" + SalesDateStart.SelectedDate.Value.ToString("yyyy-MM-dd") + "' AND '" + SalesDateEnd.SelectedDate.Value.ToString("yyyy-MM-dd") + "') GROUP BY itemName ";
DataSetReportPurchase.PurchaseTableDataTable dSPurchase = new DataSetReportPurchase.PurchaseTableDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSPurchase);
return(dSPurchase);
}
private DataTable GetPurchaseYear()
{
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
string year = ((ComboBoxItem)ComboBoxYearSales.SelectedItem).Content.ToString();//same problem
cmd.CommandText = " SELECT itemName, SUM(Total) AS Expr1 FROM po_report_view WHERE(YEAR(_date) = '" + year + "') GROUP BY itemName ";
DataSetReportPurchase.PurchaseTableDataTable dSPurchase = new DataSetReportPurchase.PurchaseTableDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSPurchase);
return(dSPurchase);
}
private DataTable GetPurchase()
{
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = " SELECT itemName, SUM(Total) AS Expr1 FROM po_report_view GROUP BY itemName ";
DataSetReportPurchase.PurchaseTableDataTable dSPurchase = new DataSetReportPurchase.PurchaseTableDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSPurchase);
return(dSPurchase);
}
private DataTable GetPurchaseMonth()
{
string month = ((ComboBoxItem)ComboBoxMonthSales.SelectedItem).Content.ToString();//same problem
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = " SELECT itemName, SUM(Total) AS Expr1 FROM po_report_view WHERE (MONTHNAME(_date) = '" + month + "') AND (YEAR(_date) = YEAR(CURDATE())) GROUP BY itemName ";
DataSetReportPurchase.PurchaseTableDataTable dSPurchase = new DataSetReportPurchase.PurchaseTableDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSPurchase);
return(dSPurchase);
}