// GET: Games/Edit/5
public ActionResult EditMakeGame(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Game game = db.Games.Include(x => x.ProductInGames).Include(x => x.GameRules).Where(x => x.GameID == id).First();
game = (Game)TableTracker.TrackEdit(game, "USR");
ViewBag.GameTypeID = new SelectList(db.GameTypes, "GameTypeID", "GameTypeCode", game.GameTypeID);
ViewBag.GameTypeIDList = new SelectList(db.GameTypes, "GameTypeID", "GameTypeCode", game.GameTypeID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameName", game.GameID);
ViewBag.NextGameID = new SelectList(db.Games, "GameID", "GameName", game.NextGameID);
ViewBag.CurrencyIDList = new SelectList(db.Currencies, "CurrencyID", "CurrencyCode");
ViewBag.MemberSubscriptionType = new SelectList(db.MemberSubscriptionTypes, "MemberSubscriptionTypeID", "MemberSubscriptionTypeDescription", game.MemberSubscriptionType);
ViewBag.Products = db.Products;
ViewBag.Source = "EditMakeGame";
var gameRules = db.GameRules.Include(x => x.GameTemplate).Where(x => x.GameID == id).OrderBy(x => x.GameTemplate.OrderInGame).ToList();
GameViewModel gameVM = new GameViewModel {
Game = game, ProductInGames = game.ProductInGames, GameRules = gameRules
};
ViewBag.Hours = new SelectList(getHours(), "Value", "text");
ViewBag.Minutes = new SelectList(getMinutes(), "Value", "text");
ViewBag.Seconds = new SelectList(getSeconds(), "Value", "text");
return(View(gameVM));
}
public ActionResult Edit([Bind(Include = "MemberSubscriptionType,GameID,GameCode,GameTypeID,GameName,GameDescription,DateInserted,DateUpdated,USR")] Game game)
{
game = (Game)TableTracker.TrackEdit(game, "USR");
if (ModelState.IsValid)
{
db.Entry(game).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GameTypeID = new SelectList(db.GameTypes, "GameTypeID", "GameTypeCode", game.GameTypeID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameName", game.GameID);
ViewBag.NextGameID = new SelectList(db.Games, "GameID", "GameName", game.NextGameID);
ViewBag.MemberSubscriptionType = new SelectList(db.MemberSubscriptionTypes, "MemberSubscriptionTypeID", "MemberSubscriptionTypeDescription", game.MemberSubscriptionType);
return(View(game));
}
// GET: Games/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Game model = db.Games.Find(id);
model = (Game)Helpers.TableTracker.TrackEdit(model, "USR");
if (model == null)
{
return(HttpNotFound());
}
ViewBag.GameTypeID = new SelectList(db.GameTypes, "GameTypeID", "GameTypeCode", model.GameTypeID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameName", model.GameID);
model = (Game)TableTracker.TrackEdit(model, "USR");
return(View(model));
}
public static System.Data.DataTable Select(string rowConstraints = "")
{
using (TableTracker leavePeriodsTracker = new TableTracker(server, database, tableName)) {
return(leavePeriodsTracker.Select(rowConstraints));
}
}
public static void Delete(string rowConstraints = "")
{
using (TableTracker entitlementsTracker = new TableTracker(server, database, tableName)) {
entitlementsTracker.Delete(rowConstraints);
}
}
public static void Update(string changes, string rowConstraints = "")
{
using (TableTracker entitlementsTracker = new TableTracker(server, database, tableName)) {
entitlementsTracker.Update(changes, rowConstraints);
}
}
public static void Insert(string values, string columnConstraints = "")
{
using (TableTracker entitlementsTracker = new TableTracker(server, database, tableName)) {
entitlementsTracker.Insert(values, columnConstraints);
}
}
