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