private void Backup_Click(object sender, RoutedEventArgs e) { try { SqlConnection con = new SqlConnection(DbSettingHelper.RawBuildConnectionString()); string database = con.Database.ToString(); string cmd = "BACKUP DATABASE [" + database + "] TO DISK= '" + txtPath.Text + "\\" + "Database" + "-" + DateTime.Now.ToString("yyyy-MM-dd--HH-mm-ss") + ".bak'"; using (SqlCommand command = new SqlCommand(cmd, con)) { if (con.State != ConnectionState.Open) { con.Open(); } command.ExecuteNonQuery(); con.Close(); } status.Text = $"ডাটাবেস ব্যাক আপ সংরক্ষণ করা হয়েছে।"; Dialog.IsOpen = true; backup.Visibility = Visibility.Hidden; } catch (Exception ex) { status.Text = $"প্রোগ্রাম সম্পর্কিত সমস্যা: {ex.Message}"; Dialog.IsOpen = true; _unitOfWork.Log.Add(new Log { Date = DateTime.Now, Exception = ex.Message, Level = "Test", Logger = "Test", Thread = "Test", Message = ex.Message }); _unitOfWork.Complete(); } }
private void BtnReport_Click(object sender, RoutedEventArgs e) { try { SqlParameter from, to, id; DataTable dt = null; from = new SqlParameter { ParameterName = "@fromDate", Value = txtFromDate.SelectedDate }; to = new SqlParameter { ParameterName = "@toDate", Value = txtToDate.SelectedDate }; id = new SqlParameter { ParameterName = "@sourceId", Value = cmbSourceName.SelectedValue }; String Path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location); if (txtFromDate.SelectedDate == null && txtToDate.SelectedDate == null) { from = new SqlParameter { ParameterName = "@fromDate", Value = DBNull.Value }; to = new SqlParameter { ParameterName = "@toDate", Value = DBNull.Value }; } //income if (cmbreportType.SelectedIndex == 0 && GroupBy.IsChecked == false) { var list = new TruckDbContext(DbSettingHelper.BuildConnectionString()).Database.SqlQuery <SpGetIncomeModel>("exec dbo.SpGetIncome @sourceId,@fromDate,@toDate", id, from, to).ToList <SpGetIncomeModel>(); dt = ApplicationState.ToDataTable(list); IncomeReport incomeReport = new IncomeReport(); // Path = System.IO.Path.Combine(Path, @"Reports\IncomeReport.rpt"); var fi = System.AppDomain.CurrentDomain.BaseDirectory; incomeReport.Load("~/Reports/IncomeReport.rpt"); incomeReport.SetDataSource(dt); incomeReport.Refresh(); reportViewer.ViewerCore.ReportSource = incomeReport; } //income Group By if (cmbreportType.SelectedIndex == 0 && GroupBy.IsChecked == true) { var list = new TruckDbContext(DbSettingHelper.BuildConnectionString()).Database.SqlQuery <SpGetIncomeModel>("exec dbo.SpGetIncome @sourceId,@fromDate,@toDate", id, from, to).ToList <SpGetIncomeModel>(); dt = ApplicationState.ToDataTable(list); IncomeReportByGroup incomeReport = new IncomeReportByGroup(); Path = System.IO.Path.Combine(Path, @"Reports\IncomeReportByGroup.rpt"); incomeReport.Load(Path); incomeReport.SetDataSource(dt); incomeReport.Refresh(); reportViewer.ViewerCore.ReportSource = incomeReport; } //spend Group By if (cmbreportType.SelectedIndex == 1 && GroupBy.IsChecked == true) { var list = new TruckDbContext(DbSettingHelper.BuildConnectionString()).Database.SqlQuery <SpGetSpendModel>("exec SpGetSpend @sourceId,@fromDate,@toDate", id, from, to).ToList <SpGetSpendModel>(); dt = ApplicationState.ToDataTable(list); SpendReportByGroup spendReport = new SpendReportByGroup(); Path = System.IO.Path.Combine(Path, @"Reports\SpendReportByGroup.rpt"); spendReport.Load(Path); spendReport.SetDataSource(dt); spendReport.Refresh(); reportViewer.ViewerCore.ReportSource = spendReport; } //spend if (cmbreportType.SelectedIndex == 1 && GroupBy.IsChecked == false) { var list = new TruckDbContext(DbSettingHelper.BuildConnectionString()).Database.SqlQuery <SpGetSpendModel>("exec SpGetSpend @sourceId,@fromDate,@toDate", id, from, to).ToList <SpGetSpendModel>(); dt = ApplicationState.ToDataTable(list); SpendReport spendReport = new SpendReport(); Path = System.IO.Path.Combine(Path, @"Reports\SpendReport.rpt"); spendReport.Load(Path); spendReport.SetDataSource(dt); spendReport.Refresh(); reportViewer.ViewerCore.ReportSource = spendReport; } } catch (Exception ex) { status.Text = $"প্রোগ্রাম সম্পর্কিত সমস্যা: {ex.Message}"; Dialog.IsOpen = true; _unitOfWork.Log.Add(new Log { Date = DateTime.Now, Exception = ex.Message, Level = "Test", Logger = "Test", Thread = "Test", Message = ex.Message }); _unitOfWork.Complete(); } }