public async Task <IEnumerable <ReportVmSubOffice> > grafica0001_Organizational(ReportVmSubOffice Item)
{
List <ReportVmSubOffice> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
string proc = "Rsp_Report_SubOffice_Year_Organizational";
using (SqlCommand cmd = new SqlCommand(proc, cn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param1 = cmd.Parameters.AddWithValue("@office", Item.parm_Pk_office ?? "");
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@Year", (Item != null) ? Item.añoParametros : "");
param2.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmSubOffice>();
while (await dr.ReadAsync())
{
Item = new ReportVmSubOffice();
Item.año = dr["Year"].ToString();
Item.cantidad = Convert.ToInt32(dr["Quantity"]);
Item.pk_subOffice = dr["SubOffice"].ToString();
Item.name_suboffice = dr["Name_suboffice"].ToString();
mostrar.Add(Item);
}
}
}
}
}
return(mostrar);
}
public async Task <IEnumerable <ReportVmSubOffice> > grafica0003(ReportVmSubOffice Item)
{
List <ReportVmSubOffice> mostrar = null;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Rsp_Report_SubOffice_Day",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_subOffice", Item.pk_subOfficeDay ?? "");
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@Year", Item.añoDay ?? "");
param2.Direction = ParameterDirection.Input;
SqlParameter param3 = cmd.Parameters.AddWithValue("@Month", Item.mesDay ?? "");
param3.Direction = ParameterDirection.Input;
using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
if (dr != null)
{
mostrar = new List <ReportVmSubOffice>();
while (await dr.ReadAsync())
{
Item = new ReportVmSubOffice();
Item.dias = Convert.ToDateTime(dr["DateCreated"]).ToShortDateString();
Item.cantidadDay = Convert.ToInt32(dr["Quantity"]);
mostrar.Add(Item);
}
}
}
return(mostrar);
}
}
