//jhonatan fernandez
public async Task <IEnumerable <ReportVmAgent> > Agent_LLamad(ReportVmAgent Item)
{
List <ReportVmAgent> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_Agent_Call",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_agente", (Item != null) ? Item.Para_pkagente : "");
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@data", (Item != null) ? Convert.ToDateTime(Item.para_fecha).ToShortDateString() : "");
param2.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmAgent>();
while (await dr.ReadAsync())
{
Item = new ReportVmAgent();
Item.cantidad000 = Convert.ToInt32(dr["Quantity"]);
Item.hora = dr["Hors"].ToString();
mostrar.Add(Item);
}
}
}
}
return(mostrar);
}
//Grafica por Agente
public async Task <IEnumerable <ReportVmAgent> > graph_Year_Agent(ReportVmAgent Item)
{
List <ReportVmAgent> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_Agent_Year",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_Boss", Item.pk_supervisor ?? "");
param1.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmAgent>();
while (await dr.ReadAsync())
{
Item = new ReportVmAgent();
Item.codigo = dr["Agent"].ToString();
Item.cantidad = Convert.ToInt32(dr["Quantity"]);
Item.año = Convert.ToInt32(dr["Year"]);
Item.nombre_agente = dr["Name_Agent"].ToString();
mostrar.Add(Item);
}
}
}
}
return(mostrar);
}
public async Task <IEnumerable <ReportVmAgent> > graph_Day_Agent(ReportVmAgent Item)
{
List <ReportVmAgent> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_Agent_Day",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_Agent", (Item != null) ? Item.pk_Boss_param : "");
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@month", (Item != null) ? Item.Month_param : "");
param2.Direction = ParameterDirection.Input;
SqlParameter param3 = cmd.Parameters.AddWithValue("@Year", (Item != null) ? Item.YearParam : "");
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmAgent>();
while (await dr.ReadAsync())
{
Item = new ReportVmAgent();
Item.dias = Convert.ToDateTime(dr["DateCreated"]).ToShortDateString();
Item.cantidad2 = Convert.ToInt32(dr["Quantity"]);
Item.name_agentt = dr["name_Agent"].ToString();
mostrar.Add(Item);
}
}
}
}
return(mostrar);
}
