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