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