public void GetMusei()
{
MuseoDataController datacontroller = new MuseoDataController();
DateTime data = new DateTime(2020, 4, 20);
RequestMuseoFilter request = new RequestMuseoFilter()
{
IdMacroArea = 1,
DataDa = data,
DataAl = data.AddHours(23).AddMinutes(59).AddSeconds(59)
};
var musei = datacontroller.GetListMusei(request);
}
/// <summary>
/// Gestone del filtro dei musei
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public PartialViewResult FiltroMusei(MuseoFilter filter)
{
MuseiVM model = new MuseiVM();
RequestMuseoFilter request = new RequestMuseoFilter()
{
IdMacroArea = filter.IdMacroArea,
DataDa = filter.DataDa,
DataAl = filter.DataAl.AddHours(23).AddMinutes(59).AddSeconds(59)
};
model.ListaMusei = this._museoDataControllers.GetListMusei(request);
return(PartialView("Museo/_adminMusei", model));
}
/// <summary>
///
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public List <Museo> GetListMusei(RequestMuseoFilter request)
{
List <Museo> list = new List <Museo>();
try
{
using (SqlConnection con = new SqlConnection(UtilitiesDB.GetConnectionStringSQL()))
{
using (SqlCommand cmd = new SqlCommand("GetListMusei", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = 0;
cmd.Parameters.Add("@IdMacroArea", SqlDbType.Int).Value = request.IdMacroArea;
cmd.Parameters.Add("@DataDa", SqlDbType.VarChar, 50).Value = request.DataDa.Value.ToString("yyyyMMdd");
cmd.Parameters.Add("@DataAl", SqlDbType.VarChar, 50).Value = request.DataAl.Value.ToString("yyyyMMdd");
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
list.Add(PopulateMuseo(reader));
}
}
con.Close();
}
}
}
catch (Exception ex)
{
throw new Exception("Si è verificato un errore nel GetListMusei: " + ex.Message);
}
finally
{
}
return(list);
}
