public DataTable GetDataTardanzas(string procedure, ParametersTardanzas 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("@IDBRANCHOFICCE", SqlDbType.Int).Value = criterios.IdOffice;
cmd.Parameters.Add("@IDTRAINER", SqlDbType.Int).Value = criterios.IdTrainer;
cmd.Parameters.Add("@IDWORKOUT", SqlDbType.Int).Value = criterios.IdWorkout;
cmd.Parameters.Add("@DATESTART", SqlDbType.DateTime).Value = criterios.DateStart;
cmd.Parameters.Add("@DATEEND", SqlDbType.DateTime).Value = criterios.DateEnd;
cmd.Parameters.Add("@DELAY", SqlDbType.Int).Value = criterios.Delay;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
}
}
catch (Exception ex)
{
return(null);
}
return(dt);
}
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)
{
ReportViewerTardanzas.Reset();
ParametersTardanzas pr = new ParametersTardanzas
{
IdOffice = int.Parse(CmbBranchOffice.SelectedValue.ToString()),
IdTrainer = int.Parse(CmbTrainer.SelectedValue.ToString()),
IdWorkout = int.Parse(CmbWorkout.SelectedValue.ToString()),
DateStart = Convert.ToDateTime(DpkDesde.Text),
DateEnd = Convert.ToDateTime(DpkHasta.Text),
Delay = int.Parse(ConfigurationSettings.AppSettings.Get("Delaytime"))
};
DataTable dt = services.GetDataTardanzas("GetTrainerDelay", pr);
ReportDataSource ds = new ReportDataSource("DataSetTardanzas", dt);
ReportViewerTardanzas.LocalReport.DataSources.Add(ds);
ReportViewerTardanzas.LocalReport.ReportEmbeddedResource = "WpfGym.Reports.rptTardanzas.rdlc";
ReportViewerTardanzas.RefreshReport();
}
else
{
MessageBox.Show("Rango de fecha Invalido");
}
}
catch (Exception ex)
{
MessageBox.Show("Error");
}
}
