public string UnbookTime(string date, string time, string user, int inmateSSN)
{
KrimmDBEntities2 db = new KrimmDBEntities2();
int booking = db.Bookings.Where(s => s.Date == date).Where(s => s.Time == time).Select(s => s.BookingId).FirstOrDefault();
Bookings book = db.Bookings.Single(s => s.BookingId == booking);
book.Iduser = null;
book.PersonOfInterest = null;
return("Din tid är avbokad");
}
public bool SaveAvailableTimeToDB(string date, string time)
{
KrimmDBEntities2 db = new KrimmDBEntities2();
if (date == null || time == null)
{
return(false);
}
else
{
Bookings createBooking = new Bookings();
createBooking.Date = date;
createBooking.Time = time;
db.Bookings.Add(createBooking);
db.SaveChanges();
}
return(true);
}
public string BookTime(string date, string time, string user, int inmateSSN)
{
KrimmDBEntities2 db = new KrimmDBEntities2();
int booking = db.Bookings.Where(s => s.Date == date).Where(s => s.Time == time).Select(s => s.BookingId).FirstOrDefault();
var tempUser = db.Bookings.Where(s => s.BookingId == booking).Select(s => s.Iduser).FirstOrDefault();
if (tempUser == null)
{
int userId = db.Users.Where(s => s.Username == user).Select(s => s.UserId).FirstOrDefault();
Bookings book = db.Bookings.Single(s => s.BookingId == booking);
book.Iduser = userId;
book.PersonOfInterest = inmateSSN;
db.SaveChanges();
return("Din bokning har genomförts den " + date + " klockan " + time);
}
else
{
return("Tiden var redan upptagen");
}
}