private void RevenueReport(object sender, EventArgs e) { string _askYear = ""; using (AskYearForm ff = new AskYearForm()) { ff.ShowDialog(); _askYear = AskYearForm.ReturnValue; } if (_askYear is null) { _ = MessageBox.Show( "Invalid input!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, 0); } else { sqlExpression = $"SELECT FORMAT([Date], 'MMMM') AS [Month], SUM([Cost]) AS [Revenue] " + $"FROM Applications " + $"INNER JOIN [Services] ON Applications.ServiceID = [Services].ID " + $"WHERE YEAR([Date]) = { _askYear } " + $"AND [MasterID] = { masterSelectBox.SelectedValue } " + $"GROUP BY FORMAT([Applications].[Date], 'MMMM');"; ChartFormShow(xAxis: "Month", title: $"Revenue report by { masterSelectBox.Text } at { _askYear }"); } }
private void TotalCostThisYearReport(object sender, EventArgs e) { string _askYear = ""; using (AskYearForm ff = new AskYearForm()) { ff.ShowDialog(); _askYear = AskYearForm.ReturnValue; } if (_askYear is null) { _ = MessageBox.Show( "Invalid input!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, 0); } else { sqlExpression = $"SELECT FORMAT([Applications].[Date], 'MMMM') " + $"AS [Month of this year], SUM([Services].[Cost]) " + $"AS [Total sold by service] FROM Applications " + $"INNER JOIN Services " + $"ON [Applications].[ServiceID] = [Services].[ID] " + $"WHERE (YEAR([Applications].[Date]) = { _askYear } ) " + $"GROUP BY FORMAT(Applications.Date, 'MMMM') "; ChartFormShow(xAxis: "Month of this year", title: $"Total monthly revenue on { _askYear } year"); } }