//gracficas por negocio
public async Task <IEnumerable <ReportVmBusiness> > graph_Year(ReportVmBusiness Item)
{
List <ReportVmBusiness> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Repart_Business_Year",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter pamar1 = cmd.Parameters.AddWithValue("@pk_Business", Item.pk_Business_Parm ?? "");
pamar1.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmBusiness>();
while (await dr.ReadAsync())
{
Item = new ReportVmBusiness();
Item.año = dr["Year"].ToString();
Item.cantidad = Convert.ToInt32(dr["Quantity"]);
Item.pk_Business = dr["Business"].ToString();
Item.name_business = dr["Name_business"].ToString();
mostrar.Add(Item);
}
}
}
}
return(mostrar);
}
public async Task <IEnumerable <ReportVmBusiness> > graph_Day(ReportVmBusiness Item)
{
List <ReportVmBusiness> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_Business_Day",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_Business", (Item != null) ? Item.pk_Business_Day_parm : "");
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@Year", (Item != null) ? Item.Year_Param : "");
param2.Direction = ParameterDirection.Input;
SqlParameter param3 = cmd.Parameters.AddWithValue("@Month", (Item != null) ? Item.Month_para : "");
param3.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmBusiness>();
while (await dr.ReadAsync())
{
Item = new ReportVmBusiness();
Item.dias = Convert.ToDateTime(dr["DateCreated"]).ToShortDateString();
Item.cantidad3 = Convert.ToInt32(dr["Quantity"]);
mostrar.Add(Item);
}
}
}
}
return(mostrar);
}
