public ActionResult ComprobanteEmpleadoEncabezado(int ID = 1, int anio = 2019)
{
Session["HistorialDePago"] = new ComprobantePagoSessionViewModel {
Id = ID, Anio = anio
};
var V_Plani_EncabezadoHistorialPlanilla = db.V_Plani_EncabezadoHistorialPlanilla.Where(x => x.cpla_IdPlanilla == ID && (x.hipa_FechaPago.Value).Year == anio);
foreach (var item in V_Plani_EncabezadoHistorialPlanilla)
{
var value = item;
}
return(View(V_Plani_EncabezadoHistorialPlanilla));
}
public ActionResult ReporteDeHistorialDeIngresos(int id)
{
//Obtener de la sesion el id de la planilla y el año para hacer la filtracion
ComprobantePagoSessionViewModel sessionComprobantePago = Session["HistorialDePago"] as ComprobantePagoSessionViewModel;
#region Configuracion de Reportes
ReportViewer HistorialIngresos = new ReportViewer()
{
ProcessingMode = ProcessingMode.Local,
SizeToReportContent = false,
Width = Unit.Pixel(1050),
Height = Unit.Pixel(500),
BackColor = System.Drawing.Color.White
};
var connectionString = ConfigurationManager.ConnectionStrings["ERP_GMEDINAConnectionString"].ConnectionString;
SqlConnection conx = new SqlConnection(connectionString);
#endregion
if (sessionComprobantePago != null)
{
int anio = sessionComprobantePago.Anio;
int planilla = sessionComprobantePago.Id;
#region Historial de Ingresos
//comando para el Historial de ingresos
SqlCommand commandHistorialIngresos = new SqlCommand();
commandHistorialIngresos.CommandText = "SELECT * FROM [Plani].[V_Plani_HistorialIngreso] WHERE emp_Id = @id AND cpla_IdPlanilla = @planilla AND YEAR(hipa_FechaPago) = @anio";
commandHistorialIngresos.Parameters.AddWithValue("@id", SqlDbType.Int).Value = id;
commandHistorialIngresos.Parameters.AddWithValue("@planilla", SqlDbType.Int).Value = planilla;
commandHistorialIngresos.Parameters.AddWithValue("@anio", SqlDbType.Int).Value = anio;
commandHistorialIngresos.Connection = conx;
SqlDataAdapter adp = new SqlDataAdapter(commandHistorialIngresos);
adp.Fill(ds, "V_Plani_HistorialIngreso");
HistorialIngresos.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"ReportesPlanilla\HistorialIngresos.rdlc";
HistorialIngresos.LocalReport.DataSources.Add(new ReportDataSource("DataSetHistorialIngresos", ds.Tables["V_Plani_HistorialIngreso"]));
ViewBag.ReportViewerIgresos = HistorialIngresos;
#endregion
conx.Close();
}
return(View());
}
public ActionResult ReporteDeHistorialDeDeducciones(int id)
{
ComprobantePagoSessionViewModel sessionComprobantePago = Session["HistorialDePago"] as ComprobantePagoSessionViewModel;
var connectionString = ConfigurationManager.ConnectionStrings["ERP_GMEDINAConnectionString"].ConnectionString;
SqlConnection conx = new SqlConnection(connectionString);
if (sessionComprobantePago != null)
{
int anio = sessionComprobantePago.Anio;
int planilla = sessionComprobantePago.Id;
ReportViewer HistorialDeducciones = new ReportViewer
{
ProcessingMode = ProcessingMode.Local,
SizeToReportContent = false,
Width = Unit.Pixel(1050),
Height = Unit.Pixel(500),
BackColor = System.Drawing.Color.White
};
#region Historial de Deducciones
//historial deducciones
SqlCommand commandHistoriaDeducciones = new SqlCommand();
commandHistoriaDeducciones.CommandText = "SELECT * FROM [Plani].[V_Plani_HistorialDeducciones] WHERE emp_Id = @id AND cpla_IdPlanilla = @planilla AND YEAR(hipa_FechaPago) = @anio";
commandHistoriaDeducciones.Parameters.AddWithValue("@id", SqlDbType.Int).Value = id;
commandHistoriaDeducciones.Parameters.AddWithValue("@planilla", SqlDbType.Int).Value = planilla;
commandHistoriaDeducciones.Parameters.AddWithValue("@anio", SqlDbType.Int).Value = anio;
commandHistoriaDeducciones.Connection = conx;
SqlDataAdapter adp2 = new SqlDataAdapter(commandHistoriaDeducciones);
adp2.Fill(ds, "V_Plani_HistorialDeducciones");
HistorialDeducciones.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"ReportesPlanilla\HistorialDeduccionesRPT.rdlc";
HistorialDeducciones.LocalReport.DataSources.Add(new ReportDataSource("DataSetHistorialDeducciones", ds.Tables["V_Plani_HistorialDeducciones"]));
ViewBag.ReportViewerDeducciones = HistorialDeducciones;
}
#endregion
return(View());
}
