public FaerdigvareKontrolViewModel()
{
_nyFaerdigvareKontrol = new FaerdigvareKontrol();
FaerdigvareKontrolHandler = new FaerdigvareKontrolHandler(this);
FaerdigvareKontrolHandler.LoadFKontrol();
//LoadFKCommand = new RelayCommand(FaerdigvareKontrolHandler.LoadFKontrol);
}
public async void LoadFKontrol()
{
int processOrdreNr = Model.SelectedPOSingleton.GetInstance().ActiveProcessOrdre.ProcessOrdreNr;
FaerdigvareKontrol loadedFK = await PersistencyFaerdigvareKontrol.GetFaerdigvareKontrol(processOrdreNr);
FaerdigvareKontrolViewModel.NyFaerdigvareKontrol = loadedFK;
}
public static FaerdigvareKontrol GetOne(int id)
{
FaerdigvareKontrol faerdigvareKontrol = new FaerdigvareKontrol();
using (HttpClient client = new HttpClient())
{
Task <string> resTask = client.GetStringAsync(URI + $"/{id}");
string jsonStr = resTask.Result;
faerdigvareKontrol = JsonConvert.DeserializeObject <FaerdigvareKontrol>(jsonStr);
}
return(faerdigvareKontrol);
}
public async static Task <FaerdigvareKontrol> GetFaerdigvareKontrol(int ponid)
{
FaerdigvareKontrol faerdigvareKontrol = new FaerdigvareKontrol();
using (HttpClient client = new HttpClient())
{
Task <string> resTask = client.GetStringAsync(URI + "/" + ponid);
await resTask;
String jsonStr = resTask.Result;
faerdigvareKontrol = JsonConvert.DeserializeObject <FaerdigvareKontrol>(jsonStr);
}
return(faerdigvareKontrol);
}
private FaerdigvareKontrol ReadFaerdigvareKontrol(SqlDataReader reader)
{
FaerdigvareKontrol tempFaerdigvareKontrol = new FaerdigvareKontrol();
tempFaerdigvareKontrol.ProcessOrdreNr = reader.GetInt32(0);
tempFaerdigvareKontrol.FaerdigvareNr = reader.GetInt32(1);
tempFaerdigvareKontrol.FaerdigvareNavn = reader.GetString(2);
tempFaerdigvareKontrol.LaagNr = reader.GetInt32(3);
tempFaerdigvareKontrol.DaaseNr = reader.GetInt32(4);
tempFaerdigvareKontrol.MultipackNr = reader.GetInt32(5);
tempFaerdigvareKontrol.KartonNr = reader.GetInt32(6);
tempFaerdigvareKontrol.PalleNr = reader.GetInt32(7);
return(tempFaerdigvareKontrol);
}
//GETALL: api/FaerdigvareKontrolManager
public IEnumerable <FaerdigvareKontrol> Get()
{
List <FaerdigvareKontrol> liste = new List <FaerdigvareKontrol>();
SqlConnection conn = new SqlConnection(ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand(GETALL, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
FaerdigvareKontrol faerdigvareKontrol = ReadFaerdigvareKontrol(reader);
liste.Add(faerdigvareKontrol);
}
conn.Close();
return(liste);
}
// GET: api/FaerdigvareKontrolManager/5
public FaerdigvareKontrol Get(int idNr)
{
FaerdigvareKontrol faerdigvareKontrol = null;
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
SqlCommand cmd = new SqlCommand(GETONE, connection);
cmd.Parameters.AddWithValue("@POID", idNr);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
faerdigvareKontrol = ReadFaerdigvareKontrol(reader);
}
connection.Close();
return(faerdigvareKontrol);
}
