public LokaleBookinger GetLokaleBookingerFromId(int lokaleBookingerId)
{
using (SqlConnection connection = new SqlConnection(DBaddress))
{
var quertstring = $"SELECT * FROM LokaleBookinger WHERE LBId = {lokaleBookingerId}";
SqlCommand command = new SqlCommand(quertstring, connection);
connection.Open();
LokaleBookinger nyLokaleBookinger = new LokaleBookinger();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
int id2 = reader.GetInt32(1);
int id3 = reader.GetInt32(2);
nyLokaleBookinger.LBId = id;
nyLokaleBookinger.BookingId = id2;
nyLokaleBookinger.LokaleId = id3;
}
connection.Close();
return(nyLokaleBookinger);
}
}
public List <LokaleBookinger> GetAllLokaleBookinger()
{
using (SqlConnection connection = new SqlConnection(DBaddress))
{
var quertstring = "SELECT * FROM LokaleBookinger";
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);
LokaleBookinger addLokaleBooking = new LokaleBookinger()
{
LBId = id, BookingId = id2, LokaleId = id3
};
LokaleBookingerList.Add(addLokaleBooking);
}
connection.Close();
return(LokaleBookingerList);
}
}
public bool UpdateLokaleBookinger(LokaleBookinger lokaleBookinger, int lokaleBookingerId)
{
using (SqlConnection connection = new SqlConnection(DBaddress))
{
var check = GetAllLokaleBookinger().Contains(lokaleBookinger);
if (!check)
{
var querystring = $"UPDATE LokaleBookinger SET BookingId = {lokaleBookinger.BookingId}, LokaleId = {lokaleBookinger.LokaleId} WHERE LBId = {lokaleBookingerId}";
SqlCommand command = new SqlCommand(querystring, connection);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return(check);
}
}
public bool CreateLokaleBookinger(LokaleBookinger lokaleBookinger)
{
using (SqlConnection connection = new SqlConnection(DBaddress))
{
var check = GetAllLokaleBookinger().Contains(lokaleBookinger);
if (!check)
{
var querystring =
$"INSERT INTO LokaleBookinger VALUES ({lokaleBookinger.LBId},{lokaleBookinger.BookingId},{lokaleBookinger.LokaleId})";
SqlCommand command = new SqlCommand(querystring, connection);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return(check);
}
}
// PUT: api/LokaleBookinger/5
public void Put(int id, [FromBody] LokaleBookinger value)
{
new ManageLokaleBookinger().UpdateLokaleBookinger(value, id);
}
// POST: api/LokaleBookinger
public void Post([FromBody] LokaleBookinger value)
{
new ManageLokaleBookinger().CreateLokaleBookinger(value);
}
