public IEnumerable <ProductPlayed> findProductPlayeds(int productInGameID) { string connString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; List <ProductPlayed> prodPlays = new List <ProductPlayed>(); using (SqlConnection con = new SqlConnection(connString)) { con.Open(); using (SqlCommand cmd = new SqlCommand("findProductPlayeds", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@productInGameID", SqlDbType.Int).Value = productInGameID; SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ProductPlayed prodPlay = new ProductPlayed(); prodPlay.ProductPlayedID = reader.GetInt32(0); prodPlay.Winner = reader.GetInt32(1); prodPlays.Add(prodPlay); } } reader.Close(); } con.Close(); } return(prodPlays); }
private void resolve(ICollection <ProductPlayed> gameResults) { IEnumerable <ProductPlayed> winning = gameResults.Where(play => play.Winner == 0).OrderBy(g => g.ClickInterval); //assert highest to lowest for (int i = 0; i < winning.Count(); i++) { ProductPlayed play = winning.ElementAt(i); play.Winner = 1; if (i < numWinnersLeft) { MemberInGame me = db.MemberInGames.Find(play.MemberInGameID); me.WinIndicator = true; play.Winner = 2; play.ProductInGame.Quantity = play.ProductInGame.Quantity - 1; numWinnersLeft--; this.game.NumberOfWinners = (numWinnersLeft); } } db.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { //TODO fix delete images /* var DisplayItems = db.DisplayItems.Where(x => x.ProductID == id).ToList(); * * foreach (var d in DisplayItems) * { * DisplayItem displayItem = db.DisplayItems.Where(s => s.DisplayItemID == d.DisplayItemID).First(); * db.DisplayItems.Remove(displayItem); * db.SaveChanges(); * } */ var ProductInWatchLists = db.ProductInWatchLists.Where(x => x.ProductID == id).ToList(); foreach (var d in ProductInWatchLists) { ProductInWatchList ProductInWatchList = db.ProductInWatchLists.Where(s => s.ProductInWatchListID == d.ProductInWatchListID).First(); db.ProductInWatchLists.Remove(ProductInWatchList); db.SaveChanges(); } var ProductInGames = db.ProductInGames.Where(x => x.ProductID == id).ToList(); foreach (var d in ProductInGames) { var ProductPlayeds = db.ProductPlayeds.Where(x => x.ProductInGameID == d.ProductInGameID).ToList(); foreach (var d1 in ProductPlayeds) { ProductPlayed ProductPlayed = db.ProductPlayeds.Where(s => s.ProductInGameID == d1.ProductInGameID).First(); db.ProductPlayeds.Remove(ProductPlayed); db.SaveChanges(); } var ProductLocations = db.ProductLocations.Where(x => x.ProductInGameID == d.ProductInGameID).ToList(); foreach (var d1 in ProductLocations) { var SerialNumbers = db.SerialNumbers.Where(x => x.ProductLocationID == d1.ProductLocationID).ToList(); foreach (var s1 in SerialNumbers) { SerialNumber SerialNumber = db.SerialNumbers.Where(s => s.ProductLocationID == d1.ProductLocationID).First(); db.SerialNumbers.Remove(SerialNumber); db.SaveChanges(); } var Vouchers = db.Vouchers.Where(x => x.ProductLocationID == d1.ProductLocationID).ToList(); foreach (var s1 in Vouchers) { Voucher Voucher = db.Vouchers.Where(s => s.ProductLocationID == d1.ProductLocationID).First(); db.Vouchers.Remove(Voucher); db.SaveChanges(); } ProductLocation ProductLocation = db.ProductLocations.Where(s => s.ProductInGameID == d1.ProductInGameID).First(); db.ProductLocations.Remove(ProductLocation); db.SaveChanges(); } ProductInGame ProductInGame = db.ProductInGames.Where(s => s.ProductInGameID == d.ProductInGameID).First(); db.ProductInGames.Remove(ProductInGame); db.SaveChanges(); } Product product = db.Products.Find(id); db.Products.Remove(product); db.SaveChanges(); return(RedirectToAction("Index")); }