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