/// <inheritdoc /> public async Task <Entrant> MergeWithStore(Entrant entrant) { Entrants.Update(entrant); await SaveChangesAsync().ConfigureAwait(false); return(await Entrants.FindAsync(entrant.RowKey).ConfigureAwait(false)); }
private void GetEntrant() { Guid entrant_ID = new Guid(Entrant_ID); Entrants entrant = new Entrants(_connString, entrant_ID); Show_ID = entrant.Show_ID.ToString(); }
private int entrantsEnumToNumber(Entrants entrants) { switch (entrants) { case Entrants._02: return(2); case Entrants._04: return(4); case Entrants._08: return(8); case Entrants._12: return(12); case Entrants._16: return(16); case Entrants._24: return(24); case Entrants._32: return(32); case Entrants._48: return(48); case Entrants._64: return(64); default: return(1); } }
public void AddEntrant(Horse horse) { Entrant entrant = new Entrant(this, horse, Entrants.Count + 1); Entrants.Add(entrant); Entrants = Entrants.OrderBy(x => x.Odds).ToList(); }
public double FractionDone() { var hasNoScoredEntrants = !Entrants.Any(x => x.Rank.HasValue && x.Rank > 0); var hasAllScoredEntrants = Entrants.All(x => (x.Rank.HasValue && x.Rank > 0) || x.Absent); if (!Entrants.Any()) { return(0.0); } else if (hasNoScoredEntrants && Event_Sess.All(s => s.ActualEnd < DateTime.Now)) { return(0.666); } else if (hasNoScoredEntrants && Event_Sess.Any(s => s.ActualStart < DateTime.Now)) { return(0.333); } else if (hasNoScoredEntrants) { return(0.0); } else if (hasAllScoredEntrants) { return(1.0); } else { return(0.9); } }
private bool DogAlreadyEntered() { bool ret = false; if (Is_Dam_Or_Sire) { return(ret); } DogClasses dogClasses = new DogClasses(_connString); List <DogClasses> tblDog_Classes; Guid show_ID = new Guid(Show_ID); Guid dog_ID = new Guid(Dog_ID); tblDog_Classes = dogClasses.GetDog_ClassesByDog_ID(show_ID, dog_ID); if (tblDog_Classes != null && tblDog_Classes.Count > 0) { foreach (DogClasses row in tblDog_Classes) { if (!row.IsEntrant_IDNull && row.Entrant_ID != new Guid()) { if (string.IsNullOrEmpty(Common.Entrant_ID) || Common.Entrant_ID != row.Entrant_ID.ToString()) { Guid entrant_ID = new Guid(row.Entrant_ID.ToString()); Entrants entrant = new Entrants(_connString, entrant_ID); if (Common.Show_ID == entrant.Show_ID.ToString()) { Common.ExistingEntrant_ID = entrant_ID.ToString(); ret = true; } } } } } return(ret); }
public Task <int> GetTotalSubmissions(bool?verified) { if (verified.HasValue) { return(Entrants.Where(x => x.Submission != null && x.Submission.Locked && x.Submission.Verified == verified).CountAsync()); } return(Entrants.Where(x => x.Submission != null && x.Submission.Locked).CountAsync()); }
private Guid CreateEntrant(ExcelDataItem item) { Entrants entrant = new Entrants(Utils.ConnectionString()); entrant.Show_ID = show_ID; entrant.Entry_Date = item.Date_Of_Entry; entrant.Withold_Address = !item.Show_Address_In_Catalogue; return((Guid)entrant.Insert_Entrant(user_ID)); }
private void PopulateEntryGridView() { List <Entrants> tblEntrants; Entrants entrants = new Entrants(_connString); Guid show_ID = new Guid(Show_ID); tblEntrants = entrants.GetEntrantsByShow_ID(show_ID, true); EntryGridView.DataSource = tblEntrants; EntryGridView.DataBind(); }
static int SortInfoByName(Entrants a, Entrants b) { var part1 = a.Name; var part2 = b.Name; var compareResult = part1.CompareTo(part2); if (compareResult == 0) { return(b.GetCompMark().CompareTo(b.GetCompMark())); } return(compareResult); }
static void PrintEntrant(Entrants entrant) { Console.WriteLine($"ID: {entrant.IdNum}"); Console.WriteLine($"Ім'я: {entrant.Name}"); Console.WriteLine($"Бали за підготовчі курси: {entrant.CoursePoints}"); Console.WriteLine($"Бал атестату: {entrant.AvgPoints}"); Console.WriteLine("ЗНО"); foreach (ZNO zno in entrant.ZNOResult) { Console.WriteLine($"{zno.Subject} : {zno.Points}"); } }
static int SortInfoByPoints(Entrants a, Entrants b) { if (a.GetCompMark() > b.GetCompMark()) { return(1); } if (a.GetCompMark() < b.GetCompMark()) { return(-1); } return(0); }
private void LoadMediaEntrants() { Entrants.AddRange(Lottery.Entrants); foreach (var movie in Lottery.Movies) { Entrants.Add( new Entrant { Name = movie.Name, Balls = 1 }); } }
/// <inheritdoc /> public Task <IEnumerable <Entrant> > FetchList(int count, int skip, bool?verified = null) { if (verified.HasValue) { return(Task.Run(() => { return Entrants.Where(x => x.Submission != null && x.Submission.Verified == verified && !x.Submission.Rejected) .Skip(skip).Take(count) .Include(y => y.Submission).AsEnumerable(); })); } return(Task.Run(() => Entrants.Skip(skip).Take(count).AsEnumerable())); }
/// <inheritdoc /> public Task <IEnumerable <Entrant> > FetchSubmissionOrderedList(int count, int skip, bool?verified) { return(Task.Run(() => { var query = Entrants.Where(x => x.Submission != null && x.Submission.Locked && !x.Submission.Rejected); if (verified.HasValue) { query = query.Where(x => x.Submission != null && x.Submission.Verified == verified); } return query.OrderBy(t => t.Submission !.TimeToComplete) .Skip(skip).Take(count) .Include(y => y.Submission).AsEnumerable(); })); }
protected void ShowGridView_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = ShowGridView.SelectedRow; string s_id = ShowGridView.DataKeys[row.RowIndex]["Show_ID"].ToString(); string c_id = ShowGridView.DataKeys[row.RowIndex]["Club_ID"].ToString(); string v_id = ShowGridView.DataKeys[row.RowIndex]["Venue_ID"].ToString(); Show_ID = s_id; Common.Show_ID = Show_ID; Club_ID = c_id; Common.Club_ID = Club_ID; PopulateClub(Club_ID); PopulateShowGridView(Club_ID); PopulateShow(Show_ID); divGetOwner.Visible = true; if (!string.IsNullOrEmpty(Owner_ID) && !string.IsNullOrEmpty(Show_ID)) { Entrants entrant = new Entrants(_connString); List <Entrants> tblEntrants; Guid person_ID = new Guid(Owner_ID); Guid show_ID = new Guid(Show_ID); Guid? entrant_ID = null; tblEntrants = entrant.GetEntrantsByShow_ID(show_ID, false); foreach (Entrants entrantRow in tblEntrants) { if (entrantRow.Show_ID == show_ID) { entrant_ID = entrantRow.Entrant_ID; } } if (entrant_ID != null) { Entrant_ID = entrant_ID.ToString(); Common.Entrant_ID = Entrant_ID; Guid newEntrant_ID = new Guid(Entrant_ID); PopulateEntrant(newEntrant_ID); PopulateDogList(newEntrant_ID); PopulateOwnerList(newEntrant_ID); divDogList.Visible = true; divAddCompetitor.Visible = false; divUpdateCompetitor.Visible = true; PopulateForm(); People person = new People(_connString, person_ID); MessageLabel.Text = string.Format("{0} {1} is already entered in this show", person.Person_Forename, person.Person_Surname); } } }
public Task <IEnumerable <Entrant> > FetchByNameFilterOrdered(string name, int count, int skip, bool?verified) { if (string.IsNullOrWhiteSpace(name)) { return(FetchSubmissionOrderedList(count, skip, verified)); } return(Task.Run(() => { var query = Entrants.Where(x => x.Submission.Locked && !x.Submission.Rejected); if (verified.HasValue) { query = query.Where(x => x.Submission.Verified == verified); } query = query.Where(s => s.Name.Contains(name)); return query.OrderBy(t => t.Submission.TimeToComplete).Skip(skip).Take(count).AsEnumerable(); })); }
private void GetEntrantByShowAndDog() { Entrants entrant = new Entrants(_connString); if (!string.IsNullOrEmpty(Show_ID)) { Guid show_ID = new Guid(Show_ID); Guid dog_ID = Common.MyDogList[0].Dog_ID; List <Entrants> tblEntrants; tblEntrants = entrant.GetEntrantsByShow_IDAndDog_ID(show_ID, dog_ID, true); if (tblEntrants != null && tblEntrants.Count > 0) { Guid entrant_ID = (Guid)tblEntrants[0].Entrant_ID; Entrant_ID = entrant_ID.ToString(); Common.Entrant_ID = Entrant_ID; } } }
public void Start() { int position = 1; foreach (var entrant in Entrants) { entrant.Start(); } Entrants = Entrants.OrderBy(x => x.RaceTime).ToList(); foreach (var entrant in Entrants) { entrant.SetPosition(position); position++; } Entrants = Entrants.OrderBy(x => Guid.NewGuid()).ToList(); }
private void ValidatePartners(List <string> errors) { if (NumberInTeam == 2) { foreach (var e1 in Entrants.Where(x => !x.Absent && x.Rank != 0)) { var e2 = Entrants.FirstOrDefault(x => x.FullName == e1.TeamOrPair); if (e2 == null) { errors.Add(e1.FullName + " does not have a partner"); } else if (e2.TeamOrPair != e1.FullName) { errors.Add(e1.FullName + " and " + e2.FullName + " have mismatched partners"); } else if (e2.Rank != e1.Rank) { errors.Add("Partners " + e1.FullName + " and " + e2.FullName + " should have the same rank"); } } } }
private void PopulateEntrants() { _entrantData.Columns.Clear(); DataColumn dcFullName = new DataColumn("FullName"); DataColumn dcEntrantID = new DataColumn("EntrantID"); _entrantData.Columns.Add(dcFullName); _entrantData.Columns.Add(dcEntrantID); object[] dataRow = new object[2]; string connString = Utils.ConnectionString(); Entrants entrants = new Entrants(connString); List <Entrants> entrantList = entrants.GetEntrantsByShow_ID(_show_ID, true); foreach (Entrants entrant in entrantList) { _prev_Owner_ID = new Guid(); DogClasses dc = new DogClasses(connString); List <DogClasses> dcList = dc.GetDog_ClassesByEntrant_ID((Guid)entrant.Entrant_ID); foreach (DogClasses dogClass in dcList) { DogOwners dogOwners = new DogOwners(connString); List <DogOwners> doList = dogOwners.GetDogOwnersByDog_ID((Guid)dogClass.Dog_ID); foreach (DogOwners owner in doList) { if (owner.Owner_ID != _prev_Owner_ID) { People person = new People(connString, (Guid)owner.Owner_ID); dataRow[0] = person.Person_FullName; dataRow[1] = entrant.Entrant_ID; _entrantData.Rows.Add(dataRow); } _prev_Owner_ID = owner.Owner_ID; } } } selectEntrant.PeopleData = _entrantData; }
public string Status() { var hasNoScoredEntrants = !Entrants.Any(x => x.Rank.HasValue && x.Rank > 0); var hasAllScoredEntrants = Entrants.All(x => (x.Rank.HasValue && x.Rank > 0) || x.Absent); if (!Entrants.Any()) { if (!End.HasValue || DateTime.Now < End.Value) { return("In database, empty"); } else { return("Complete"); // noone entered, and the end is passed } } else if (hasNoScoredEntrants && Event_Sess.All(s => s.ActualEnd < DateTime.Now)) { return("Awaiting results"); } else if (hasNoScoredEntrants && Event_Sess.Any(s => s.ActualStart < DateTime.Now)) { return("In progress"); } else if (hasNoScoredEntrants) { return("Taking entries"); } else if (hasAllScoredEntrants) { return("Complete"); } else { return("Results being entered"); } }
private void PopulateEntrant(Guid entrant_ID) { Entrants entrant = new Entrants(_connString, entrant_ID); if (entrant.Catalogue != null) { Catalogue = (bool)entrant.Catalogue; } if (entrant.Overnight_Camping != null) { Overnight_Camping = (bool)entrant.Overnight_Camping; } Overpayment = entrant.Overpayment.ToString(); Underpayment = entrant.Underpayment.ToString(); if (entrant.Offer_Of_Help != null) { Offer_Of_Help = (bool)entrant.Offer_Of_Help; } Help_Details = entrant.Help_Details; if (entrant.Withold_Address != null) { Withold_Address = (bool)entrant.Withold_Address; } if (entrant.Send_Running_Order != null) { Send_Running_Order = (bool)entrant.Send_Running_Order; } if (entrant.Entry_Date != null) { string format = "yyyy-MM-dd"; Entry_Date = DateTime.Parse(entrant.Entry_Date.ToString()).ToString(format); Common.Entry_Date = Entry_Date; txtEntryDate.Text = Entry_Date; } StoreCommon(); }
public TournamentMenu setNumberOfEntrants(Entrants entrants) { this.entrants = entrants; return(this); }
/// <inheritdoc /> public async Task Create(Entrant entrant) { await Entrants.AddAsync(entrant).ConfigureAwait(false); await SaveChangesAsync(); }
protected void btnAddCompetitor_Click(object sender, EventArgs e) { SaveFormFields(); StoreCommon(); if (ValidEntry()) { MembershipUser userInfo = Membership.GetUser(); Guid user_ID = (Guid)userInfo.ProviderUserKey; Entrants entrant = new Entrants(_connString); Guid show_ID = new Guid(Show_ID); entrant.Show_ID = show_ID; if (Catalogue) { entrant.Catalogue = Catalogue; } if (Overnight_Camping) { entrant.Overnight_Camping = Overnight_Camping; } if (!string.IsNullOrEmpty(Overpayment)) { entrant.Overpayment = decimal.Parse(Overpayment); } if (!string.IsNullOrEmpty(Underpayment)) { entrant.Underpayment = decimal.Parse(Underpayment); } if (Offer_Of_Help) { entrant.Offer_Of_Help = Offer_Of_Help; } if (!string.IsNullOrEmpty(Help_Details)) { entrant.Help_Details = Help_Details; } if (Withold_Address) { entrant.Withold_Address = Withold_Address; } if (Send_Running_Order) { entrant.Send_Running_Order = Send_Running_Order; } if (!string.IsNullOrEmpty(Entry_Date)) { if (entrant.Entry_Date.ToString() != Entry_Date && !string.IsNullOrEmpty(Entry_Date)) { entrant.Entry_Date = DateTime.Parse(Entry_Date); } } Guid?entrant_ID = entrant.Insert_Entrant(user_ID); if (entrant_ID != null) { Entrant_ID = entrant_ID.ToString(); Common.Entrant_ID = Entrant_ID; bool insertFailed = false; for (int i = 0; i < Common.MyDogList.Count; i++) { DogClasses dogClass = new DogClasses(_connString); dogClass.Entrant_ID = entrant_ID; dogClass.Dog_ID = Common.MyDogList[i].Dog_ID; Guid?dog_Class_ID = dogClass.Insert_Dog_Class(user_ID); if (dog_Class_ID == null) { insertFailed = true; } } if (!insertFailed) { string returnChars = Common.AppendReturnChars(Request.QueryString, "coc"); Server.Transfer("~/Competitors/AddDogToClasses.aspx?" + returnChars); } else { MessageLabel.Text = "Dog_Classes Insert Failed!"; } } else { MessageLabel.Text = "Entrants Insert Failed!"; } } }
protected void btnUpdateCompetitor_Click(object sender, EventArgs e) { SaveFormFields(); StoreCommon(); if (ValidEntry()) { MembershipUser userInfo = Membership.GetUser(); Guid user_ID = (Guid)userInfo.ProviderUserKey; Guid entrant_ID = new Guid(Entrant_ID); bool EntrantChanges = false; bool EntrantSuccess = false; bool DogChanges = false; bool DogSuccess = false; if (HasEntrantChanges()) { EntrantChanges = true; Entrants entrant = new Entrants(_connString); Guid show_ID = new Guid(Show_ID); entrant.Show_ID = show_ID; if (Catalogue) { entrant.Catalogue = Catalogue; } if (Overnight_Camping) { entrant.Overnight_Camping = Overnight_Camping; } if (!string.IsNullOrEmpty(Overpayment)) { entrant.Overpayment = decimal.Parse(Overpayment); } if (!string.IsNullOrEmpty(Underpayment)) { entrant.Underpayment = decimal.Parse(Underpayment); } if (Offer_Of_Help) { entrant.Offer_Of_Help = Offer_Of_Help; } if (!string.IsNullOrEmpty(Help_Details)) { entrant.Help_Details = Help_Details; } if (Withold_Address) { entrant.Withold_Address = Withold_Address; } if (Send_Running_Order) { entrant.Send_Running_Order = Send_Running_Order; } if (!string.IsNullOrEmpty(Entry_Date)) { if (entrant.Entry_Date.ToString() != Entry_Date && !string.IsNullOrEmpty(Entry_Date)) { entrant.Entry_Date = DateTime.Parse(Entry_Date); } } EntrantSuccess = entrant.Update_Entrant(entrant_ID, user_ID); } else { EntrantSuccess = true; } List <DogClasses> tblDogClasses; DogClasses dogClasses = new DogClasses(_connString); tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID); bool insertOK = true; bool deleteOK = true; switch (HasDogChanges()) { case Constants.DATA_NO_CHANGE: DogSuccess = true; break; case Constants.DATA_INSERTED: DogChanges = true; insertOK = InsertDogClass(entrant_ID, user_ID); if (insertOK) { DogSuccess = true; } else { MessageLabel.Text = "Insert_Dog_Class Failed"; } break; case Constants.DATA_DELETED: DogChanges = true; deleteOK = DeleteDogClass(entrant_ID, user_ID); if (deleteOK) { DogSuccess = true; } else { MessageLabel.Text = "Delete_Dog_Class Failed"; } break; case Constants.DATA_INSERTED_AND_DELETED: DogChanges = true; insertOK = InsertDogClass(entrant_ID, user_ID); deleteOK = DeleteDogClass(entrant_ID, user_ID); if (insertOK && deleteOK) { DogSuccess = true; } else { MessageLabel.Text = string.Empty; if (!insertOK) { MessageLabel.Text = "Insert_Dog_Class Failed"; } if (!deleteOK) { MessageLabel.Text += "Delete_Dog_Class Failed"; } } break; default: break; } if (EntrantChanges && !EntrantSuccess) { MessageLabel.Text = "Update_Entrant Failed!"; } if (DogChanges && !DogSuccess) { MessageLabel.Text += " Error with Dog Changes!"; } if (!EntrantChanges && !DogChanges) { string returnChars = Common.AppendReturnChars(Request.QueryString, "coc"); Server.Transfer("~/Competitors/AddDogToClasses.aspx?" + returnChars); } if (EntrantSuccess && DogSuccess) { string returnChars = Common.AppendReturnChars(Request.QueryString, "coc"); Server.Transfer("~/Competitors/AddDogToClasses.aspx?" + returnChars); } } }
private bool HasEntrantChanges() { bool Changed = false; if (!string.IsNullOrEmpty(Entrant_ID)) { Guid entrant_ID = new Guid(Entrant_ID); Entrants entrant = new Entrants(_connString, entrant_ID); if (entrant.Show_ID.ToString() != Show_ID) { Changed = true; } if (entrant.Catalogue != Catalogue) { Changed = true; } if (entrant.Overnight_Camping != Overnight_Camping) { Changed = true; } if (entrant.Overpayment.ToString() != Overpayment) { Changed = true; } if (entrant.Underpayment.ToString() != Underpayment) { Changed = true; } if (entrant.Offer_Of_Help != Offer_Of_Help) { Changed = true; } if (entrant.Help_Details != Help_Details) { if (!string.IsNullOrEmpty(entrant.Help_Details) && !string.IsNullOrEmpty(Help_Details)) { Changed = true; } } if (entrant.Withold_Address != Withold_Address) { Changed = true; } if (entrant.Send_Running_Order != Send_Running_Order) { Changed = true; } if (entrant.Entry_Date == null && !string.IsNullOrEmpty(Entry_Date)) { Changed = true; } if (entrant.Entry_Date != null && !string.IsNullOrEmpty(Entry_Date)) { if (entrant.Entry_Date.ToString() != Entry_Date) { Changed = true; } } } return(Changed); }
private void LoadGameEntrants() { Entrants.AddRange(Lottery.Entrants); }
/// <inheritdoc /> public async Task Delete(Entrant entrant) { Entrants.Remove(entrant); await SaveChangesAsync().ConfigureAwait(false); }