//crUd public bool UpdateVenue(VenueEdit model) { using (var ctx = new ApplicationDbContext()) { //Add e.OwnerID == _userID so only venue user or admin can delete after adding user roles var entity = ctx.Venues.Single(e => e.VenueID == model.VenueID); entity.VenueName = model.VenueName; entity.VenueType = model.VenueType; entity.Location = model.Location; return(ctx.SaveChanges() == 1); } }
//Get: Edit public ActionResult Edit(int id) { var service = NewVenueService(); var detail = service.GetVenueByID(id); var model = new VenueEdit { VenueID = detail.VenueID, VenueName = detail.VenueName, VenueType = detail.VenueType, Location = detail.Location, ListOfShows = detail.ListOfShows }; return(View(model)); }
public IHttpActionResult Put(VenueEdit venue) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var service = CreateVenueService(); if (!service.UpdateVenue(venue)) { return(InternalServerError()); } return(Ok()); }
public ActionResult Edit(int id) { var service = CreateVenueService(); var detail = service.GetVenueByID(id); var model = new VenueEdit { VenueID = detail.VenueID, VenueName = detail.VenueName, Location = detail.Location, YearOpened = detail.YearOpened, Capacity = detail.Capacity, IsActive = detail.IsActive }; return(View(model)); }
public ActionResult Edit(int id) { var service = CreateVenueService(); var detail = service.GetVenueById(id); var model = new VenueEdit { VenueId = detail.VenueId, VenueName = detail.VenueName, StreetNumber = detail.StreetNumber, City = detail.City, State = detail.State, ZipCode = detail.ZipCode, Seats = detail.Seats, Image = detail.Image }; return(View(model)); }
public bool UpdateVenue(VenueEdit model) { using (var ctx = new ApplicationDbContext()) { var entity = ctx .Venues .Single(e => e.VenueID == model.VenueID); entity.VenueID = model.VenueID; entity.VenueName = model.VenueName; entity.Location = model.Location; entity.YearOpened = model.YearOpened; entity.Capacity = model.Capacity; entity.IsActive = model.IsActive; return(ctx.SaveChanges() == 1); } }
//Edit Venue public bool UpdateVenue(VenueEdit model) { using (var ctx = new ApplicationDbContext()) { var entity = ctx .Venue .Single(e => e.VenueId == model.VenueId /*&& e.OwnerId == _userId*/); entity.VenueId = model.VenueId; entity.VenueName = model.VenueName; entity.StreetAddress = model.StreetAddress; entity.City = model.City; entity.State = model.State; entity.Capacity = model.Capacity; entity.NumberOfSeats = model.NumberOfSeats; return(ctx.SaveChanges() == 1); } }
private void buttonSeedVerifications_Click(object sender, EventArgs e) { if (MessageBox.Show(this, "Use is in debug mode only! Verify the code!!! Continue?", "Byb", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question) != System.Windows.Forms.DialogResult.Yes) { return; } var db = new ApplicationDbContext(); var verifyingAthlete = db.Athletes.Where(i => i.AthleteID == 21).Single(); var venuesToVerify = db.Venues.Where(i => i.Country == "GBR").ToList(); int countSkipped = 0; int countAddedVerifications = 0; foreach (var venue in venuesToVerify) { if (venue.VenueEdits.Count() > 0) { countSkipped++; continue; } VenueEditTypeEnum type = VenueEditTypeEnum.ConfirmOnly; VenueEdit edit = new VenueEdit() { AthleteID = verifyingAthlete.AthleteID, VenueID = venue.VenueID, Time = DateTime.UtcNow, Type = (int)type, Backup = "" }; db.VenueEdits.Add(edit); countAddedVerifications++; } db.SaveChanges(); MessageBox.Show(this, "Done. Skipped:" + countSkipped + ", Added verification:" + countAddedVerifications, "Byb", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public ActionResult Edit(int id, VenueEdit model) { if (!ModelState.IsValid) { return(View(model)); } if (model.VenueID != id) { ModelState.AddModelError("", "Id Mismatch"); return(View(model)); } var service = NewVenueService(); if (service.UpdateVenue(model)) { TempData["SaveResult"] = "Your note was updated."; return(RedirectToAction("Index")); } ModelState.AddModelError("", "Your note could not be updated."); return(View()); }
public bool UpdateVenue(VenueEdit model) { using (var ctx = new ApplicationDbContext()) { var entity = ctx .Venues .Single(e => e.VenueId == model.VenueId && e.OwnerId == _userId); entity.VenueId = model.VenueId; entity.VenueName = model.VenueName; entity.StreetNumber = model.StreetNumber; entity.City = model.City; entity.State = model.State; entity.ZipCode = model.ZipCode; entity.Seats = model.Seats; entity.Image = model.Image; return(ctx.SaveChanges() == 1); } }
public bool UpdateVenue(VenueEdit model) { using (var ctx = new ApplicationDbContext()) { //var adminRoleId = ctx.Roles.FirstOrDefault(u => u.Name.Equals("Admin")).Id; //var list = ctx.Users.Where(u => u.Roles.Any(r => r.RoleId == adminRoleId)).ToList(); //var admins = ctx.Roles.FirstOrDefault(u => u.Name.Equals("Admin")).Users; //bool isAdmin = admins.Where(a => a.UserId == _userID.ToString()).Count() != 0; var entity = ctx .Venues .Single(e => e.VenueID == model.VenueID); entity.VenueName = model.VenueName; entity.VenueDescription = model.VenueDescription; entity.VenueAvailability = model.VenueAvailability; entity.VenueCapacity = model.VenueCapacity; entity.VenueCost = model.VenueCost; entity.VenueLocation = model.VenueLocation; return(ctx.SaveChanges() == 1); } }
public bool VerifyOrEditVenue(VenueEditWebModel venueEdit) { var athlete = new UserProfileLogic(db).GetAthleteForUserName(User.Identity.Name); var venue = db.Venues.Single(i => i.VenueID == venueEdit.VenueID); string backup = string.Format("{0}|||||{1}|||||{2}|||||{3}|||||{4}|||||{5}|||||{6}", venue.PhoneNumber ?? "", venue.Website ?? "", venue.Address ?? "", venue.PoiID ?? "", venue.NumberOf10fSnookerTables ?? -1, venue.NumberOf12fSnookerTables ?? -1, venue.IsInvalid); bool isEdited = false; if (venueEdit.NumberOf10fSnookerTables != null && venue.NumberOf10fSnookerTables != venueEdit.NumberOf10fSnookerTables) { isEdited = true; venue.NumberOf10fSnookerTables = venueEdit.NumberOf10fSnookerTables; } if (venueEdit.NumberOf12fSnookerTables != null && venue.NumberOf12fSnookerTables != venueEdit.NumberOf12fSnookerTables) { isEdited = true; venue.NumberOf12fSnookerTables = venueEdit.NumberOf12fSnookerTables; } if (venueEdit.HasAddress != venue.HasAddress) { isEdited = true; venue.Address = venueEdit.Address; } if (venueEdit.HasWebsite != venue.HasWebsite) { isEdited = true; venue.Website = venueEdit.Website; } if (venueEdit.HasPhoneNumber != venue.HasPhoneNumber) { isEdited = true; venue.PhoneNumber = venueEdit.PhoneNumber; } if (venueEdit.HasPoiID != venue.HasPOIid) { isEdited = true; venue.PoiID = venueEdit.PoiID; } if (venueEdit.IsInvalid != venue.IsInvalid) { isEdited = true; venue.IsInvalid = venueEdit.IsInvalid; } VenueEditTypeEnum type = VenueEditTypeEnum.ConfirmOnly; if (isEdited) { type = VenueEditTypeEnum.EditedMeta; } VenueEdit edit = new VenueEdit() { AthleteID = athlete.AthleteID, VenueID = venue.VenueID, Time = DateTime.UtcNow, Type = (int)type, Backup = backup }; db.VenueEdits.Add(edit); db.SaveChanges(); return(true); }