public BookingSmartboard GetBookingSmartboardFromId(int bookingSmartboardId) { using (SqlConnection connection = new SqlConnection(DBaddress)) { var quertstring = $"SELECT * FROM BookingSmartboard WHERE BSId = {bookingSmartboardId}"; SqlCommand command = new SqlCommand(quertstring, connection); connection.Open(); BookingSmartboard nyBookingSmartboard = new BookingSmartboard(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); int id2 = reader.GetInt32(1); int id3 = reader.GetInt32(2); int id4 = reader.GetInt32(3); nyBookingSmartboard.BSId = id; nyBookingSmartboard.BookingId = id2; nyBookingSmartboard.LokaleId = id3; nyBookingSmartboard.TidId = id4; } connection.Close(); return(nyBookingSmartboard); } }
public List <BookingSmartboard> GetAllBookingSmartboard() { using (SqlConnection connection = new SqlConnection(DBaddress)) { var quertstring = "SELECT * FROM BookingSmartboard"; SqlCommand command = new SqlCommand(quertstring, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); int id2 = reader.GetInt32(1); int id3 = reader.GetInt32(2); int id4 = reader.GetInt32(3); BookingSmartboard addBookingSmartboard = new BookingSmartboard() { BSId = id, BookingId = id2, LokaleId = id3, TidId = id4 }; BookingSmartboardList.Add(addBookingSmartboard); } connection.Close(); return(BookingSmartboardList); } }
public bool UpdateBookingSmartboard(BookingSmartboard bookingSmartboard, int bookingSmartboardId) { using (SqlConnection connection = new SqlConnection(DBaddress)) { var check = GetAllBookingSmartboard().Contains(bookingSmartboard); if (!check) { var querystring = $"UPDATE BookingSmartboard SET BookingId = {bookingSmartboard.BookingId}, LokaleId = {bookingSmartboard.LokaleId}, TidId = {bookingSmartboard.TidId} WHERE BSId = {bookingSmartboardId}"; SqlCommand command = new SqlCommand(querystring, connection); connection.Open(); command.ExecuteNonQuery(); connection.Close(); } return(check); } }
public bool CreateBookingSmartboard(BookingSmartboard bookingSmartboard) { using (SqlConnection connection = new SqlConnection(DBaddress)) { var check = GetAllBookingSmartboard().Contains(bookingSmartboard); if (!check) { var querystring = $"INSERT INTO BookingSmartboard VALUES ({bookingSmartboard.BookingId},{bookingSmartboard.LokaleId},{bookingSmartboard.TidId})"; SqlCommand command = new SqlCommand(querystring, connection); connection.Open(); command.ExecuteNonQuery(); connection.Close(); } return(check); } }
// PUT: api/BookingSmartboard/5 public void Put(int id, [FromBody] BookingSmartboard value) { new ManageBookingSmartboard().UpdateBookingSmartboard(value, id); }
// POST: api/BookingSmartboard public void Post([FromBody] BookingSmartboard value) { new ManageBookingSmartboard().CreateBookingSmartboard(value); }