///------------------------------------------------------------------------------------------------- /// \fn private async void BtnShowMonthlySummary_Click(object sender, RoutedEventArgs e) /// /// \brief Event handler. Called by BtnShowMonthlySummary for click events /// /// \author Arie /// \date 2019-04-20 /// /// \param sender Source of the event. /// \param e Routed event information. ///------------------------------------------------------------------------------------------------- private async void BtnShowMonthlySummary_Click(object sender, RoutedEventArgs e) { // Get the month and year Nullable <DateTime> selectedDate = SelectDate.SelectedDate(); if (selectedDate != null) { DateTime date = (DateTime)selectedDate; DataTable dt = await Task.Run(() => MainWindow.billing.MonthlyBillSummaryTable(date)); try { txtResults.Clear(); ToggleTable(true); dgData.DataContext = dt.DefaultView; } catch (Exception expt) { Logging.Write(expt.Message); System.Windows.MessageBox.Show("Exception : " + expt.Message); } } else { txbFeedBack.Text = "Failed to generate billing summary. Have you reconciled the MOH file?"; SetTimer(); } }
///------------------------------------------------------------------------------------------------- /// \fn private async void BtnCreateMonthlySummary_Click(object sender, RoutedEventArgs e) /// /// \brief Event handler. Called by BtnCreateMonthlySummary for click events /// /// \author Arie /// \date 2019-04-20 /// /// \param sender Source of the event. /// \param e Routed event information. ///------------------------------------------------------------------------------------------------- private async void BtnCreateMonthlySummary_Click(object sender, RoutedEventArgs e) { // Get the month and year Nullable <DateTime> selectedDate = SelectDate.SelectedDate(); if (selectedDate != null) { DateTime date = (DateTime)selectedDate; // Create the file if (await Task.Run(() => MainWindow.billing.MonthlyBillSummary(date))) { // Display results var firstDayOfMonth = new DateTime(date.Year, date.Month, 1); var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); //string query = "SELECT attendee_hcn, code, gender, date, DollarAmount " + // "FROM BillReport('" + // date.Year + "-" + date.Month + "-" + "01 00:00:00', '" + // date.Year + "-" + date.Month + "-" + lastDayOfMonth.Day + " 00:00:00')" // ; //LookupTable(query); txbFeedBack.Text = "Successfully created billing summary"; } } else { txbFeedBack.Text = "Failed to generate billing summary"; } SetTimer(); }
///------------------------------------------------------------------------------------------------- /// \fn public static Nullable<DateTime> SelectedDate() /// /// \brief Selected date /// /// \author Arie /// \date 2019-04-20 /// /// \returns A Nullable<DateTime> ///------------------------------------------------------------------------------------------------- public static Nullable <DateTime> SelectedDate() { SelectDate createBillFile = new SelectDate(); createBillFile.ShowDialog(); return(selectedDate); }
///------------------------------------------------------------------------------------------------- /// \fn private async void CreateBillingFile_Click(object sender, RoutedEventArgs e) /// /// \brief Event handler. Called by CreateBillingFile for click events /// /// \author Arie /// \date 2019-04-20 /// /// \param sender Source of the event. /// \param e Routed event information. ///------------------------------------------------------------------------------------------------- private async void CreateBillingFile_Click(object sender, RoutedEventArgs e) { // Get the month and year Nullable <DateTime> selectedDate = SelectDate.SelectedDate(); if (selectedDate != null) { DateTime date = (DateTime)selectedDate; string fileName = null; // Ask where to save the file. Microsoft.Win32.SaveFileDialog saveFileDialog = new Microsoft.Win32.SaveFileDialog(); saveFileDialog.FileName = Constants.monthlyBill + date.ToString("yyyyMM"); // The default name of the file saveFileDialog.DefaultExt = Constants.fileExt; // The default extension saveFileDialog.Filter = "Text documents (.txt)|*.txt"; // Filter files by extension if (saveFileDialog.ShowDialog() == true) { fileName = saveFileDialog.FileName; } else { // If user cancels, use default file name. fileName = Constants.dbDirectory + @"\" + Constants.monthlyBill + date.ToString("yyyyMM") + Constants.fileExt; } // Create the file if (await Task.Run(() => MainWindow.billing.GenMonthlyBill(date, fileName))) { // Display results var firstDayOfMonth = new DateTime(date.Year, date.Month, 1); var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); string query = "SELECT attendee_hcn, code, gender, date, DollarAmount " + "FROM BillReport('" + firstDayOfMonth + "', '" + lastDayOfMonth + "')" //date.Year + "-" + date.Month + "-" + "01 00:00:00', '" + //date.Year + "-" + date.Month + "-" + lastDayOfMonth.Day + " 00:00:00')" ; LookupTable(query); txbFeedBack.Text = "Successfully created billing file"; } } else { txbFeedBack.Text = "Failed to generate billing file"; } SetTimer(); }
///------------------------------------------------------------------------------------------------- /// \fn private void ViewResponse_Click(object sender, RoutedEventArgs e) /// /// \brief Event handler. Called by ViewResponse for click events /// /// \author Arie /// \date 2019-04-21 /// /// \param sender Source of the event. /// \param e Routed event information. ///------------------------------------------------------------------------------------------------- private void ViewResponse_Click(object sender, RoutedEventArgs e) { // Get the month and year Nullable <DateTime> selectedDate = SelectDate.SelectedDate(); if (selectedDate != null) { DateTime date = (DateTime)selectedDate; var firstDayOfMonth = new DateTime(date.Year, date.Month, 1); var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); string query = "SELECT appointmentDate, HCN, gender, Code, fee, encounterState " + "FROM ResponseRecord " + "WHERE appointmentDate >= '" + firstDayOfMonth + "' " + "AND appointmentDate <= '" + lastDayOfMonth + "'"; LookupTable(query); } }