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