public async Task <IEnumerable <ReportsVm> > chart_google02(ReportsVm Item)
{
List <ReportsVm> mostrar = null;
mostrar = new List <ReportsVm>();
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
string proc = "Rsp_Report_Enterprise_Month";
using (SqlCommand cmd = new SqlCommand(proc, cn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parm1 = cmd.Parameters.AddWithValue("@Enterpresi", Item.codigoEmpre1 ?? "");
parm1.Direction = ParameterDirection.Input;
SqlParameter parm2 = cmd.Parameters.AddWithValue("@año", Item.añoPa1 ?? "");
parm2.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync())
{
if (dr != null)
{
mostrar = new List <ReportsVm>();
while (await dr.ReadAsync())
{
Item = new ReportsVm();
Item.fecha = dr["month"].ToString();
Item.cantidad1 = Convert.ToInt32(dr["Quantity"]);
Item.name = dr["name_Enterprise"].ToString();
Item.pk_enterprise = dr["Enterprise"].ToString();
mostrar.Add(Item);
}
}
}
}
}
return(mostrar);
}
public async Task <IEnumerable <ReportsVm> > Grafica_03(ReportsVm Item)
{
List <ReportsVm> Mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_Enterprise_Day",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@Entrepresi", Item.codigoEmpre2 ?? "");
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@Month", Item.ParaMes ?? "");
param2.Direction = ParameterDirection.Input;
SqlParameter param3 = cmd.Parameters.AddWithValue("@Year", Item.añoPa2 ?? "");
param3.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
Mostrar = new List <ReportsVm>();
while (await dr.ReadAsync())
{
Item = new ReportsVm();
Item.dias = Convert.ToDateTime(dr["DateCreated"]).ToShortDateString();
Item.cantidad2 = Convert.ToInt32(dr["Quantity"]);
Mostrar.Add(Item);
}
}
}
return(Mostrar);
}
}
//graficas por empresa
public async Task <IEnumerable <ReportsVm> > ejemplo(ReportsVm Item)
{
List <ReportsVm> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_Enterprise_Year",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter parm1 = cmd.Parameters.AddWithValue("@Enterpresi", Item.codigoEmpre ?? "");
parm1.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportsVm>();
while (await dr.ReadAsync())
{
Item = new ReportsVm();
Item.año = dr["Year"].ToString();
Item.cantidad = Convert.ToInt32(dr["Quantity"]);
Item.name_enterprise = dr["name_Enterprise"].ToString();
Item.id_enterprise = dr["Enterprise"].ToString();
mostrar.Add(Item);
}
}
}
return(mostrar);
}
}
