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