/// <summary> /// Updates cargo's grid view. /// </summary> private void UpdateCargoGridView() { CargoList.Clear(); foreach (var item in _cargoService.GetAll().Result) { CargoList.Add(item); } }
public static CargoList Get() { CargoList res = new CargoList(); SqlCommand cmd = null; SqlDataReader dr = null; string query = "SELECT * FROM Cargo"; try { cmd = Methods.CreateBasicCommand(query); dr = Methods.ExecuteDataReaderCommand(cmd); while (dr.Read()) { res.Add(new Cargo() { IdCargo = dr.GetInt32(0), Nombre = dr.GetString(1), }); } } catch (SqlException ex) { //Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace); throw ex; } catch (Exception ex) { //Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace); throw ex; } finally { cmd.Connection.Close(); } return(res); }