Exemple #1
0
        public bool Post(Bemanding bemanding)
        {
            bool status;

            SqlConnection connection = new SqlConnection(ConnectionString);

            connection.Open();

            SqlCommand command = new SqlCommand(Insert, connection);

            command.Parameters.AddWithValue("@Process_Order_Nr", bemanding.ProcessOrdre_Nr);
            command.Parameters.AddWithValue("@Tidspunkt_Start", bemanding.Tidspunkt_Start);
            command.Parameters.AddWithValue("@Tidspunkt_Slut", bemanding.Tidspunkt_Slut);
            command.Parameters.AddWithValue("@Antal_Bemanding", bemanding.Antal_Bemanding);
            command.Parameters.AddWithValue("@Signatur", bemanding.Signatur);
            command.Parameters.AddWithValue("@Pauser", bemanding.Pauser);

            int rowsAffected = command.ExecuteNonQuery();

            if (rowsAffected == 1)
            {
                status = true;
            }
            else
            {
                status = false;
            }

            connection.Close();

            return(status);
        }
 public void TestInitialize()
 {
     _manager        = new BemandingManager();
     _trialBemanding = new Bemanding(1, new DateTime(2019, 09, 05, 20, 50, 00, DateTimeKind.Local), new DateTime(2019, 09, 06, 20, 50, 00, DateTimeKind.Local), 10, "AB", 0);
 }
 // POST: api/Bemandings
 public bool Post([FromBody] Bemanding bemandingToPost)
 {
     return(_manager.Post(bemandingToPost));
 }