示例#1
0
        public async void CreateVaegtKontrol()
        {
            //skal oprettes async
            int processOrdreNr = Model.SelectedPOSingleton.GetInstance().ActiveProcessOrdre.ProcessOrdreNr;
            int maxKontrol     = await PersistencyVaegtKontrol.GetMax(processOrdreNr);

            int                     kontrolNr     = ++maxKontrol;
            DateTime                datoTid       = DateTime.Now;
            VaegtKontrol            aVaegtKontrol = new VaegtKontrol(processOrdreNr, kontrolNr, datoTid);
            PersistencyVaegtKontrol pVaegtKontrol = new PersistencyVaegtKontrol();
            bool                    success       = pVaegtKontrol.Post(aVaegtKontrol);

            if (success)
            {
                //feedback på succes.
                MessageDialog messageDialog = new MessageDialog($"Den nye VægtKontrol med nummer:{maxKontrol} blev oprettet", "Succes");
                await messageDialog.ShowAsync();
            }
            else
            {
                //feedback på fejl. message dialog
                MessageDialog messageDialog = new MessageDialog("Vægtkontrollen blev ikke oprettet", "Fejl");
                await messageDialog.ShowAsync();
            }
        }
示例#2
0
        public void TestMethod1()
        {
            //Arrange


            VaegtKontrolManager vaegtKontrolManager = new VaegtKontrolManager();
            VaegtKontrol        vK = new VaegtKontrol(1598290, 99, DateTime.Now);


            //Act


            int  kontrollerFoer  = vaegtKontrolManager.Get().Count();
            bool result          = vaegtKontrolManager.Post(vK);
            int  kontrollerEfter = vaegtKontrolManager.Get().Count();

            vaegtKontrolManager.Delete(vK.KontrolNr);


            //Assert


            Assert.IsTrue(result);
            Assert.AreEqual(kontrollerFoer + 1, kontrollerEfter);
        }
        private VaegtKontrol ReadVaegts(SqlDataReader reader)
        {
            VaegtKontrol vaegtKontrol = new VaegtKontrol
            {
                ProcessOrdreNr = reader.GetInt32(0), KontrolNr = reader.GetInt32(1), DatoTid = reader.GetDateTime(2)
            };


            return(vaegtKontrol);
        }
        private VaegtKontrol ReadVaegtKontrol(SqlDataReader reader)
        {
            VaegtKontrol tempVaegtKontrol = new VaegtKontrol();

            tempVaegtKontrol.ProcessOrdreNr = reader.GetInt32(0);
            tempVaegtKontrol.KontrolNr      = reader.GetInt32(1);
            tempVaegtKontrol.DatoTid        = reader.GetDateTime(2);

            return(tempVaegtKontrol);
        }
示例#5
0
        public static VaegtKontrol GetOne(int id)
        {
            VaegtKontrol vaegtKontrol = new VaegtKontrol();

            using (HttpClient client = new HttpClient())
            {
                Task <string> resTask = client.GetStringAsync(URI + $"/{id}");
                string        jsonStr = resTask.Result;
                vaegtKontrol = JsonConvert.DeserializeObject <VaegtKontrol>(jsonStr);
            }

            return(vaegtKontrol);
        }
        //GETALL: api/VaegtKontrolManager
        public IEnumerable <VaegtKontrol> Get()
        {
            List <VaegtKontrol> liste = new List <VaegtKontrol>();

            SqlConnection conn = new SqlConnection(ConnectionString);

            conn.Open();
            SqlCommand    cmd    = new SqlCommand(GETALL, conn);
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                VaegtKontrol vaegtKontrol = ReadVaegtKontrol(reader);
                liste.Add(vaegtKontrol);
            }
            conn.Close();
            return(liste);
        }
        public IEnumerable <VaegtKontrol> GetVaegtKontrols(int ProcessOrderNr)
        {
            List <VaegtKontrol> liste = new List <VaegtKontrol>();

            SqlConnection conn = new SqlConnection(ConnString);

            conn.Open();
            SqlCommand cmd = new SqlCommand(GetVaegts, conn);

            cmd.Parameters.AddWithValue("@PONR", ProcessOrderNr);
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                VaegtKontrol vaegtKontrol = ReadVaegts(reader);
                liste.Add(vaegtKontrol);
            }
            conn.Close();
            return(liste);
        }
        // GET: api/VaegtKontrolManager/5
        public VaegtKontrol Get(int idNr)
        {
            VaegtKontrol vaegtKontrol = null;

            SqlConnection connection = new SqlConnection(ConnectionString);

            connection.Open();
            SqlCommand cmd = new SqlCommand(GETONE, connection);

            cmd.Parameters.AddWithValue("@ID", idNr);

            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                vaegtKontrol = ReadVaegtKontrol(reader);
            }
            connection.Close();
            return(vaegtKontrol);
        }
        // POST: api/VaegtKontrolManager
        public bool Post(VaegtKontrol vaegtKontrol)
        {
            bool retValue = false;

            SqlConnection conn = new SqlConnection(ConnectionString);

            conn.Open();

            SqlCommand cmd = new SqlCommand(INSERT, conn);

            cmd.Parameters.AddWithValue("@Process_Ordre_Nr", vaegtKontrol.ProcessOrdreNr);
            cmd.Parameters.AddWithValue("@Kontrol_Nr", vaegtKontrol.KontrolNr);
            cmd.Parameters.AddWithValue("@Dato_Tid", vaegtKontrol.DatoTid);

            int rowsAffected = cmd.ExecuteNonQuery();

            retValue = rowsAffected == 1 ? true : false;
            conn.Close();

            return(retValue);
        }
示例#10
0
        public bool Post(VaegtKontrol vaegtKontrol)
        {
            bool ok = true;

            using (HttpClient client = new HttpClient())
            {
                String        jsonStr = JsonConvert.SerializeObject(vaegtKontrol);
                StringContent content = new StringContent(jsonStr, Encoding.ASCII, "application/json");

                Task <HttpResponseMessage> postAsync = client.PostAsync(URI, content);

                HttpResponseMessage resp = postAsync.Result;
                if (resp.IsSuccessStatusCode)
                {
                    String jsonResStr = resp.Content.ReadAsStringAsync().Result;
                    ok = JsonConvert.DeserializeObject <bool>(jsonResStr);
                }
                else
                {
                    ok = false;
                }
            }
            return(ok);
        }
示例#11
0
 public UdviddetVaegtKontrol(VaegtKontrol vaegtKontrol)
 {
     VaegtKontrol = vaegtKontrol;
     Update();
 }
示例#12
0
 // POST: api/VaegtKontrol
 public bool Post([FromBody] VaegtKontrol value)
 {
     return(manager.Post(value));
 }