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