private DataTable GetServiceMonth()
{
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT sq.sqNoChar, si.invoiceNo, s.serviceName, s.servicedesc ,ss.dateStarted, ss.dateEnded, ss.serviceStatus FROM service_sched_t ss INNER JOIN services_availed_t sa ON ss.serviceAvailedID = sa.id INNER JOIN services_t s ON s.serviceID = sa.serviceID INNER JOIN sales_quote_t sq ON sq.sqNoChar = sa.sqNoChar INNER JOIN sales_invoice_t si ON sq.sqNoChar = si.sqNoChar INNER JOIN cust_supp_t cs ON cs.CompanyID = sq.custId WHERE(MONTHNAME(sq.dateOfIssue) = '" + ((ComboBoxItem)ComboBoxSerMonth.SelectedItem).Content.ToString() + "') AND(YEAR(sq.dateOfIssue) = YEAR(CURDATE())) ";
DataSetReportService.ServiceTableDataTable dSServices = new DataSetReportService.ServiceTableDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSServices);
return(dSServices);
}
private DataTable GetService()
{
var dbCon = DBConnection.Instance();
dbCon.IsConnect();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT sq.sqNoChar, si.invoiceNo, s.serviceName, s.servicedesc ,ss.dateStarted, ss.dateEnded, ss.serviceStatus FROM service_sched_t ss INNER JOIN services_availed_t sa ON ss.serviceAvailedID = sa.id INNER JOIN services_t s ON s.serviceID = sa.serviceID INNER JOIN sales_quote_t sq ON sq.sqNoChar = sa.sqNoChar INNER JOIN sales_invoice_t si ON sq.sqNoChar = si.sqNoChar INNER JOIN cust_supp_t cs ON cs.CompanyID = sq.custId";
DataSetReportService.ServiceTableDataTable dSServices = new DataSetReportService.ServiceTableDataTable();
MySqlDataAdapter mySqlDa = new MySqlDataAdapter(cmd);
mySqlDa.Fill(dSServices);
return(dSServices);
}
