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