public void Delete(lib.Customer customer) { var entity = _dbContext.Customer.First(c => c.FirstName.Equals(customer.FirstName) && c.LastName.Equals(customer.LastName)); _dbContext.Customer.Remove(entity); _dbContext.SaveChanges(); }
public void Add(string t) { Tag tag = new Tag { term = t.ToLower() }; _context.Tags.Add(tag); _context.SaveChanges(); }
public void Update(lib.Location location) { var entity = _dbContext.Location .First(s => s.LocationId == location.Id); foreach (var item in location.Inventory.Keys) { entity.Inventory.First(i => i.ProductId == item.ProductId).Amount = location.Inventory[item]; } _dbContext.SaveChanges(); }
public int Add(d.Review newReview) { var entity = new Review { DoctorId = newReview.DoctorId, UserId = newReview.UserId, Rating = newReview.Rating, Review1 = newReview.Content }; _context.Reviews.Add(entity); _context.SaveChanges(); return(entity.ReviewId); }
public int Add(d.Booking newBooking) { var entity = new Booking { Date = newBooking.Date, DoctorId = newBooking.DoctorId, PatientId = newBooking.UserId, Description = newBooking.Description }; _context.Bookings.Add(entity); _context.SaveChanges(); return(entity.BookingId); }
public int Add(d.User newUser) { var entity = new User { Username = newUser.UserName, Pass = newUser.PassWord, FirstName = newUser.FirstName, LastName = newUser.LastName, Email = newUser.Email, City = newUser.City.ToLower(), State = newUser.State, Phone = newUser.Phone }; _context.Users.Add(entity); _context.SaveChanges(); return(entity.UserId); }
public int Add(d.Doctor newDoctor) { var entity = new Doctor { Username = newDoctor.UserName, Pass = newDoctor.PassWord, FirstName = newDoctor.FirstName, LastName = newDoctor.LastName, Email = newDoctor.Email, City = newDoctor.City.ToLower(), State = newDoctor.State, Bio = newDoctor.Bio, ExpYears = newDoctor.Exp, Fee = newDoctor.Fee, Phone = newDoctor.Phone, Rating = 0, Consultations = 0, DoctorType = newDoctor.DoctorType }; _context.Doctors.Add(entity); _context.SaveChanges(); var doc = _context.Doctors.First(d => d.Username == entity.Username); var cityTag = _context.Tags.First(t => t.term == doc.City.ToLower()); var city = new DoctorTag { doctorId = doc.DoctorId, tagId = cityTag.tagId }; var stateTag = _context.Tags.First(t => t.term == doc.State.ToLower()); var state = new DoctorTag { doctorId = doc.DoctorId, tagId = stateTag.tagId }; var typeTag = _context.Tags.First(t => t.term == doc.DoctorType.ToLower()); var type = new DoctorTag { doctorId = doc.DoctorId, tagId = typeTag.tagId }; _context.DoctorTags.Add(city); _context.SaveChanges(); _context.DoctorTags.Add(type); _context.SaveChanges(); _context.DoctorTags.Add(state); _context.SaveChanges(); return(entity.DoctorId); }
public void Save() { _dbContext.SaveChanges(); }