//Grafica por supervisor
public async Task <IEnumerable <ReportVmBoss> > graph_Year_Boos(ReportVmBoss Item)
{
List <ReportVmBoss> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_Boss_Year",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_business", Item.pk_business ?? "");
param1.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmBoss>();
while (await dr.ReadAsync())
{
Item = new ReportVmBoss();
Item.pk_Boss = dr["Boss"].ToString();
Item.año = Convert.ToInt32(dr["Year"]);
Item.cantidad = Convert.ToInt32(dr["Quantity"]);
Item.name_Boss = dr["Name_Boss"].ToString();
mostrar.Add(Item);
}
}
}
}
return(mostrar);
}
public async Task <IEnumerable <ReportVmBoss> > graph_Day_Boss(ReportVmBoss Item)
{
List <ReportVmBoss> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_Boss_Day",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_Boss", (Item != null) ? Item.pk_Boss_Parm1 : "");
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@Month", (Item != null) ? Item.month_Pam : "");
param2.Direction = ParameterDirection.Input;
SqlParameter param3 = cmd.Parameters.AddWithValue("@Year", (Item != null) ? Item.Year_Parm1 : "");
param3.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmBoss>();
while (await dr.ReadAsync())
{
Item = new ReportVmBoss();
Item.dia = Convert.ToDateTime(dr["DateCreated"]).ToShortDateString();
Item.cantidad2 = Convert.ToInt32(dr["Quantity"]);
mostrar.Add(Item);
}
}
}
}
return(mostrar);
}
