public List <VentaMensualViewModel> VentaMensual([FromBody] model_consulta _model) { /*async Task<IEnumerable<sp_venta_diaria>>*/ // IEnumerable<sp_venta_diaria> s= new IEnumerable<sp_venta_diaria>(); List <VentaMensualViewModel> lista = new List <VentaMensualViewModel>(); try { var param = new SqlParameter[] { new SqlParameter() { ParameterName = "@FechaInicio", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = _model.f_inicial }, new SqlParameter() { ParameterName = "@FechaFin", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = _model.f_final } }; SqlConnection sqlConnection = new SqlConnection("data source=DESKTOP-699F64C;initial catalog=db_ventasudemy; user id=sa; Password=cristian261.;persist security info=True;" /* _context.Database.GetDbConnection().ConnectionString*/); var cmm = sqlConnection.CreateCommand(); cmm.CommandType = System.Data.CommandType.StoredProcedure; cmm.CommandText = "sp_venta_mensual"; cmm.Parameters.AddRange(param); cmm.Connection = sqlConnection; sqlConnection.Open(); var reader = cmm.ExecuteReader(); while (reader.Read()) { VentaMensualViewModel modelo = new VentaMensualViewModel(); modelo.anio = Convert.ToString(reader["anio"]); modelo.mes = Convert.ToString(reader["mes"]); modelo.total = Convert.ToDecimal(reader["total"]); modelo.cantidad = Convert.ToInt32(reader["cantidad"]); lista.Add(modelo); } } catch (Exception ex) { return(lista); } return(lista); }
public List <sp_venta_diaria> VentaDiaria([FromBody] model_consulta _model) { List <sp_venta_diaria> lista = new List <sp_venta_diaria>(); try { var param = new SqlParameter[] { new SqlParameter() { ParameterName = "@FechaInicio", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = _model.f_inicial }, new SqlParameter() { ParameterName = "@FechaFin", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = _model.f_final } }; SqlConnection sqlConnection = new SqlConnection("data source=DESKTOP-699F64C;initial catalog=db_ventasudemy; user id=sa; Password=cristian261.;persist security info=True;" /* _context.Database.GetDbConnection().ConnectionString*/); var cmm = sqlConnection.CreateCommand(); cmm.CommandType = System.Data.CommandType.StoredProcedure; cmm.CommandText = "sp_venta_diaria"; cmm.Parameters.AddRange(param); cmm.Connection = sqlConnection; sqlConnection.Open(); var reader = cmm.ExecuteReader(); while (reader.Read()) { sp_venta_diaria modelo = new sp_venta_diaria(); modelo.fecha = Convert.ToDateTime(reader["fecha"]); modelo.total = Convert.ToDecimal(reader["total"]); modelo.cantidad = Convert.ToInt32(reader["cantidad"]); lista.Add(modelo); } } catch (Exception ex) { string s = ex.Message; return(lista); } return(lista); }