public void DeleteMember(string username, string password)
{
using (var db = new NSCContext())
{
var selectedMemberBookings =
from b in db.Bookings
join m in db.Members on b.MemberId equals m.MemberId
where m.Username == username && m.Passwrd == password
select b;
db.Bookings.RemoveRange(selectedMemberBookings);
db.SaveChanges();
var selectedMember =
from m in db.Members
where m.Username == username && m.Passwrd == password
select m;
db.Members.RemoveRange(selectedMember);
db.SaveChanges();
}
}
public void TearDown()
{
using (var db = new NSCContext())
{
var selectedMember =
from m in db.Members
where m.Username == "stephfoxton"
select m;
db.Members.RemoveRange(selectedMember);
db.SaveChanges();
}
}
public void TearDown()
{
using (var db = new NSCContext())
{
var selectedBookings =
from b in db.Bookings
where b.MemberId == 1 && b.RoomId == 2
select b;
db.Bookings.RemoveRange(selectedBookings);
db.SaveChanges();
}
}
public void DeleteBooking(int bookingId)
{
using (var db = new NSCContext())
{
var selectedBooking =
from b in db.Bookings
where b.BookingId == bookingId
select b;
db.Bookings.RemoveRange(selectedBooking);
db.SaveChanges();
}
}
public void CreateMember(string username, string password)
{
using (var db = new NSCContext())
{
var newMember = new Member
{
Username = username.Trim(),
Passwrd = password.Trim()
};
db.Members.Add(newMember);
db.SaveChanges();
}
}
public void UpdateBooking(int bookingid, int roomId, int sportId, DateTime datePicked, TimeSpan timePicked)
{
using (var db = new NSCContext())
{
SelectBooking = db.Bookings.Where(c => c.BookingId == bookingid).FirstOrDefault();
//setSelectedRider(email);
SelectBooking.RoomId = roomId;
SelectBooking.SportId = sportId;
SelectBooking.DateNeeded = datePicked;
SelectBooking.TimeSlot = timePicked;
db.SaveChanges();
}
}
public void CreateBooking(int memberId, int roomId, int sportId, DateTime datePicked, TimeSpan timePicked)
{
using (var db = new NSCContext())
{
var newBooking = new Booking
{
MemberId = memberId,
RoomId = roomId,
SportId = sportId,
DateNeeded = datePicked,
TimeSlot = timePicked
};
db.Bookings.Add(newBooking);
db.SaveChanges();
}
}
public void DELETEMember_NumberDecreasesBy1()
{
using (var db = new NSCContext())
{
var newMember = new Member
{
Username = "******",
Passwrd = "Password"
};
db.Members.Add(newMember);
db.SaveChanges();
var numberBefore = db.Members.ToList().Count();
_crudMembers.DeleteMember("stephfoxton", "Password");
var numberAfter = db.Members.ToList().Count();
Assert.AreEqual(numberBefore, numberAfter + 1);
}
}
