public CustomerList GetCustomerDetailByID(int customerId) { RentalService rentalService = new RentalService(); using (var ctx = new ApplicationDbContext()) { var entity = ctx .Users .Single(e => e.UserID == customerId); return (new CustomerList { UserID = entity.UserID, FName = entity.FName, LName = entity.LName, StreetAddress = entity.StreetAddress, City = entity.City, State = entity.State, Zip = entity.Zip, Rentals = rentalService.GetRentalByCustomerID(customerId), EaseRating = entity.EaseRating, CareRating = entity.CareRating, TimelinessAsCustomerRating = entity.TimelinessAsCustomerRating }); } }
public bool DeleteTool(int toolId) { var rentalservice = new RentalService(); // null add th etoolID's for any rentals with this tool ID rentalservice.NullToolIDForRentalByToolID(toolId); // now remove those tool rows using (var ctx = new ApplicationDbContext()) { var entity = ctx.Tools.Single(e => e.ToolID == toolId); ctx.Tools.Remove(entity); return(ctx.SaveChanges() == 1); } }