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