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);
}
