private void Button_Buscar(object sender, RoutedEventArgs e) { try { DateTime d1, d2; d1 = Convert.ToDateTime(DpkDesde.Text); d2 = Convert.ToDateTime(DpkHasta.Text); if (d1 <= d2) { ReportViewerSustitucionesa.Reset(); ParametersSustituciones pr = new ParametersSustituciones { IdOffice = int.Parse(CmbBranchOffice.SelectedValue.ToString()), IdWorkout = int.Parse(CmbWorkout.SelectedValue.ToString()), DateStart = Convert.ToDateTime(DpkDesde.Text), DateEnd = Convert.ToDateTime(DpkHasta.Text), }; DataTable dt = services.GetDataSustitutos("GetSustitute", pr); ReportDataSource ds = new ReportDataSource("DataSetSustitutos", dt); ReportViewerSustitucionesa.LocalReport.DataSources.Add(ds); ReportViewerSustitucionesa.LocalReport.ReportEmbeddedResource = "WpfGym.Reports.rptSustituciones.rdlc"; ReportViewerSustitucionesa.RefreshReport(); } else { MessageBox.Show("Rango de fecha Invalido"); } } catch (Exception ex) { MessageBox.Show("Error"); } }
public DataTable GetDataSustitutos(string procedure, ParametersSustituciones criterios) { DataTable dt = new DataTable(); try { string ConnectionString = ConfigurationManager.AppSettings["ReportDataSource"]; using (SqlConnection cn = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand(procedure, cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IDOFFICE", SqlDbType.Int).Value = criterios.IdOffice; cmd.Parameters.Add("@IDWORKOUT", SqlDbType.Int).Value = criterios.IdWorkout; cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = criterios.DateStart; cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = criterios.DateEnd; SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dt); } } catch (Exception ex) { return(null); } return(dt); }