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