public JsonResult GenerarReporte(Reporte_EL R) { string postdata = JsonConvert.SerializeObject(R); var Lis = JsonConvert.DeserializeObject <List <Reporte_EL> >(Utilitario.Accion.Conect_WEBAPI("Reporte/ListarReporte", "POST", postdata)); return(Json(new { listrm = Lis, }, JsonRequestBehavior.AllowGet)); }
public List <Reporte_EL> GetReporteGeneral(Reporte_EL r) { using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena)) { con.Open(); using (SqlCommand com = new SqlCommand("ReporteGeneral", con)) { com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@fechainicial", SqlDbType.Date).Value = r.fechainicial; com.Parameters.AddWithValue("@fechafinal", SqlDbType.Date).Value = r.fechafinal; List <Reporte_EL> list = new List <Reporte_EL>(); using (IDataReader dataReader = com.ExecuteReader()) { while (dataReader.Read()) { Reporte_EL obj = new Reporte_EL(); if (dataReader["indice"] != DBNull.Value) { obj.indice = (decimal)dataReader["indice"]; } if (dataReader["estado"] != DBNull.Value) { obj.estado = Convert.ToInt16(dataReader["estado"]); } if (dataReader["descripcion"] != DBNull.Value) { obj.descripcion = (string)dataReader["descripcion"]; } if (dataReader["fecha"] != DBNull.Value) { obj.fecha = (DateTime)dataReader["fecha"]; } list.Add(obj); } } return(list); } } }
public IEnumerable <Reporte_EL> ListarReporte(Reporte_EL value) { return(Reporte_DA.Accion.GetReporteGeneral(value)); }