public List <Periodico> getAllDocs(Periodico Item)
{
List <Periodico> oPeriodico = null;
SqlConnection cn = new SqlConnection(connection);
cn.Open();
SqlCommand cmd = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
CommandText = "uspGetByDateInclude",
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@dateInicio", Item.dateInicio ?? "" ?? null);
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@dateFin", Item.dateFin ?? "" ?? null);
param2.Direction = ParameterDirection.Input;
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleResult))
{
if (dr != null)
{
oPeriodico = new List <Periodico>();
while (dr.Read())
{
oPeriodico.Add(new Periodico()
{
Pk_Doc = Convert.ToInt32(dr["Pk_Doc"]),
Fk_Cat = Convert.ToInt32(dr["FK_cat"]),
Categoria = dr["Cat"].ToString(),
dateInclude = Convert.ToDateTime(Convert.ToDateTime(dr["dateInclude"]).ToString("dd/MM/yyyy")),
//dateInicio = Convert.ToDateTime(dr["dateStart"]),
//dateFin = Convert.ToDateTime(dr["dateEnd"])
dateInicio = dr["dateStart"].ToString(),
dateFin = dr["dateEnd"].ToString()
});
}
}
}
return(oPeriodico);
}
public List <Periodico> getAllDocs(Periodico Item)
{
return(pDao.getAllDocs(Item));
}
