public ActionResult Create([Bind(Include = "ProductInGameID,ProductID, PriceInGame,GameID,Quantity,CurrencyID,DateInserted,DateUpdated,USR")] ProductInGame productInGame)
{
ProductInGameValidator validator = new ProductInGameValidator();
if (ModelState.IsValid)
{
//Deduct quantity from Product table if stock available
//@Patrick 6) Depletes the product Quantity from the "Available Stock" amount on the Product record.
//Available Stock must not go negative (Validator checks for this)
//Get Product
var product = db.Products.Where(x => x.ProductID == productInGame.ProductID).First();
//Deplete available stock on hand
product.AvailableSOH -= productInGame.Quantity;
//Save
if (product.AvailableSOH >= 0)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
}
else
{
ModelState.AddModelError("QuantityError", "Not enough stock on hand for this product");
ViewBag.CurrencyID = new SelectList(db.Currencies, "CurrencyID", "CurrencyCode", productInGame.CurrencyID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameCode", productInGame.GameID);
ViewBag.ProductID = new SelectList(db.Products, "ProductID", "ProductSKUCode", productInGame.ProductID);
return(View(productInGame));
}
db.ProductInGames.Add(productInGame);
db.SaveChanges();
return(RedirectToAction("Edit", new { id = productInGame.ProductInGameID }));
}
FluentValidation.Results.ValidationResult results = validator.Validate(productInGame);
IList <ValidationFailure> failures = results.Errors;
StringBuilder sb = new StringBuilder();
foreach (var e in results.Errors)
{
ModelState.AddModelError(e.PropertyName + "Error", e.ErrorMessage);
sb.AppendLine(e.ErrorMessage);
}
ViewBag.CurrencyID = new SelectList(db.Currencies, "CurrencyID", "CurrencyCode", productInGame.CurrencyID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameCode", productInGame.GameID);
ViewBag.ProductID = new SelectList(db.Products, "ProductID", "ProductSKUCode", productInGame.ProductID);
return(View(productInGame));
}
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));
}
public ActionResult Edit([Bind(Include = "MemberID,MemberSubscriptionTypeID,FirstName,LastName,IdentityType,EmailAddress,TelephoneHome,TelephoneOffice,TelephoneMobile,CountryID,StateID,Gender,Ethnicity,DateOfBirth,ActiveIndicator,RenewalDate,AddressID,DateInserted,DateUpdated,USR")] Member member)
{
MemberValidator validator = new MemberValidator();
if (ModelState.IsValid && validator.Validate(member).IsValid)
{
db.Entry(member).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ValidationResult results = validator.Validate(member);
IList <ValidationFailure> failures = results.Errors;
StringBuilder sb = new StringBuilder();
foreach (var e in results.Errors)
{
ModelState.AddModelError(e.PropertyName + "Error", e.ErrorMessage);
sb.AppendLine(e.ErrorMessage);
}
ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", member.CountryID);
ViewBag.StateID = new SelectList(db.CountryStates, "StateID", "StateName", member.StateID);
ViewBag.AddressID = new SelectList(db.Addresses, "AddressID", "AddressType", member.AddressID);
ViewBag.MemberSubscriptionTypeID = new SelectList(db.MemberSubscriptionTypes, "MemberSubscriptionTypeID", "MemberSubscriptionTypeCode", member.MemberSubscriptionTypeID);
return(View(member));
}
public ActionResult Edit([Bind(Include = "GameMemberFilterID,GameID,CountryID,StateID,CityID,AgeBandID,GenderID,Territory,MemberSubscriptionTypeID")] GameMemberFilter gamememberfilter)
{
List <SelectListItem> AgeGroups;
List <SelectListItem> Genders;
GetAgesAndGenders(out AgeGroups, out Genders);
if (ModelState.IsValid)
{
db.Entry(gamememberfilter).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AgeBandID = new SelectList(AgeGroups, "Value", "Text");
ViewBag.GenderID = new SelectList(Genders, "Value", "text");
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameCode", gamememberfilter.GameID);
ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", gamememberfilter.CountryID);
ViewBag.StateID = new SelectList(db.CountryStates, "StateID", "StateName", gamememberfilter.StateID);
ViewBag.Territory = new SelectList(db.Territories, "TerritoryID", "TerritoryCode", gamememberfilter.Territory);
ViewBag.MemberSubscriptionTypeID = new SelectList(db.MemberSubscriptionTypes, "MemberSubscriptionTypeID", "MemberSubscriptionTypeCode", gamememberfilter.MemberSubscriptionTypeID);
return(View(gamememberfilter));
}
public ActionResult Edit([Bind(Include = "ContractID,ContractCode,ContractDetail,DateInserted,DateUpdated,USR")] Contract contract)
{
if (ModelState.IsValid)
{
db.Entry(contract).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contract));
}
public ActionResult Edit([Bind(Include = "AddressID,AddressType,AddressLine1,AddressLine2,AddressLine3,Country,StateOrProvince,ZipOrPostalCode,DateInserted,DateUpdated,USR")] Address address)
{
if (ModelState.IsValid)
{
db.Entry(address).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(address));
}
public ActionResult Edit([Bind(Include = "GameTypeID,GameTypeCode,GameTypeName,GameTypeDescription,DateInserted,DateUpdated,USR")] GameType gameType)
{
if (ModelState.IsValid)
{
db.Entry(gameType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(gameType));
}
public ActionResult Edit([Bind(Include = "LanguageID,LanguageName,LanguageTwoLetters,LanguageThreeLetters")] Language language)
{
if (ModelState.IsValid)
{
db.Entry(language).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(language));
}
public ActionResult Edit([Bind(Include = "ProductCategoryID,ProductCategoryCode,ProductCategoryName,ProductCategoryDescription,DateInserted,DateUpdated,USR")] ProductCategory productCategory)
{
if (ModelState.IsValid)
{
db.Entry(productCategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(productCategory));
}
public ActionResult Edit([Bind(Include = "GameTemplateID,GameTemplateCode,GameTypeID,DateInserted,DateUpdated,USR,GameRuleCode,GameRuleDetail,OrderInGame")] GameTemplate gametemplate)
{
if (ModelState.IsValid)
{
db.Entry(gametemplate).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GameTypeID = new SelectList(db.GameTypes, "GameTypeID", "GameTypeCode", gametemplate.GameTypeID);
return(View(gametemplate));
}
public ActionResult Edit([Bind(Include = "OwnerID,OwnerCode,OwnerName,OwnerType,BankingDetailBank,BankingDetailAccountNumber,BankingDetailAccountType,BankingDetailBranchCode,BankingDetailBranchName,BankingDetailDefaultReference,EmailAddress,ContactPerson,TelephoneOffice,TelephoneMobile,AddressID,DateInserted,DateUpdated,USR")] Owner owner)
{
if (ModelState.IsValid)
{
db.Entry(owner).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AddressID = new SelectList(db.Addresses, "AddressID", "AddressType", owner.AddressID);
return(View(owner));
}
public ActionResult Edit([Bind(Include = "CurrencyID,CurrencyCode,CurrencySymbol,CountryID")] Currency currency)
{
if (ModelState.IsValid)
{
db.Entry(currency).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", currency.CountryID);
return(View(currency));
}
public ActionResult Edit([Bind(Include = "VoucherID,VoucherNumber,ProductLocationID,Used,DateInserted,DateUsed")] Voucher voucher)
{
if (ModelState.IsValid)
{
db.Entry(voucher).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductLocationID = new SelectList(db.ProductLocations, "ProductLocationID", "USR", voucher.ProductLocationID);
return(View(voucher));
}
public ActionResult Edit([Bind(Include = "LanguageItemID,LanguageID,LanguageItemKey,LanguageItemValue")] LanguageItem languageitem)
{
if (ModelState.IsValid)
{
db.Entry(languageitem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LanguageID = new SelectList(db.Languages, "LanguageID", "LanguageName", languageitem.LanguageID);
return(View(languageitem));
}
public ActionResult Edit([Bind(Include = "ProductInWatchListID,MemberID,ProductID,DateInserted,DateUpdated,USR")] ProductInWatchList productInWatchList)
{
if (ModelState.IsValid)
{
db.Entry(productInWatchList).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MemberID = new SelectList(db.Members, "MemberID", "IdentityType", productInWatchList.MemberID);
ViewBag.ProductID = new SelectList(db.Products, "ProductID", "ProductSKUCode", productInWatchList.ProductID);
return(View(productInWatchList));
}
public ActionResult Edit([Bind(Include = "TerritoryID,TerritoryCode,OwnerID,ContractID,TerritoryName,TerritoryDescription,DateInserted,DateUpdated,USR")] Territory territory)
{
if (ModelState.IsValid)
{
db.Entry(territory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ContractID = new SelectList(db.Contracts, "ContractID", "ContractCode", territory.ContractID);
ViewBag.OwnerID = new SelectList(db.Owners, "OwnerID", "OwnerCode", territory.OwnerID);
return(View(territory));
}
public ActionResult Edit([Bind(Include = "GameRuleID,GameRuleCode,GameID,FilterCriteria,Schedule,ChainGameRuleID,GameRuleDetail,ExcecuteTime,DateInserted,DateUpdated,USR,GameTemplateID")] GameRule gamerule)
{
if (ModelState.IsValid)
{
db.Entry(gamerule).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameCode", gamerule.GameID);
ViewBag.GameTemplateID = new SelectList(db.GameTemplates, "GameTemplateID", "GameTemplateCode", gamerule.GameTemplateID);
return(View(gamerule));
}
//public ActionResult Edit([Bind(Include = "ProductID,ProductSKUCode,OwnerID,ContractID,ProductName,ProductDescription,DateInserted,DateUpdated,USR")] Product product)
public ActionResult Edit(ProductViewModel productViewModel)
{
var product = productViewModel.Product;
product = (Product)Helpers.TableTracker.TrackEdit(product, "USR");
ProductValidator validator = new ProductValidator();
if (ModelState.IsValid && validator.Validate(product).IsValid)
{
if (productViewModel.Images != null)
{
foreach (var d in productViewModel.Images)
{
if (d.DeleteOnSave)
{
Imagedetail image = db.Imagedetails.Where(x => x.ImageID == d.Image.ImageID).First();
db.Imagedetails.Remove(image);
}
}
}
db.Entry(productViewModel.Product).State = EntityState.Modified;
db.SaveChanges();
int count = 0;
foreach (string fileName in Request.Files)
{
HttpPostedFileBase file = Request.Files[count++];
saveFile(file, productViewModel.Product.ProductID);
}
return(RedirectToAction("Index"));
}
ValidationResult results = validator.Validate(product);
IList <ValidationFailure> failures = results.Errors;
StringBuilder sb = new StringBuilder();
foreach (var e in results.Errors)
{
ModelState.AddModelError(e.PropertyName + "Error", e.ErrorMessage);
sb.AppendLine(e.ErrorMessage);
}
//ViewBag.ValidationErrors = sb.ToString();
ViewBag.ContractIDList = new SelectList(db.Contracts, "ContractID", "ContractCode", productViewModel.Product.ContractID);
ViewBag.OwnerIDList = new SelectList(db.Owners, "OwnerID", "OwnerCode", productViewModel.Product.OwnerID);
return(View(productViewModel));
}
public ActionResult Edit([Bind(Include = "ProductLocationID,ProductInGameID,Address,DeliveryAgentName,DateInserted,DateUpdated,USR")] ProductLocation productLocation)
{
if (ModelState.IsValid)
{
db.Entry(productLocation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductInGameID = new SelectList(db.ProductInGames, "ProductInGameID", "Currency", productLocation.ProductInGameID);
return(View(productLocation));
}
public ActionResult Edit([Bind(Include = "CountryID,StateID,CityID,TerritoryDefinitionID,TerritoryDefinitionCode,TerritoryID,ZipOrPostalCode,IPAddress,PhysicalCoordinates,DateInserted,DateUpdated,USR")] TerritoryDefinition territorydefinition)
{
if (ModelState.IsValid)
{
db.Entry(territorydefinition).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TerritoryID = new SelectList(db.Territories, "TerritoryID", "TerritoryCode", territorydefinition.TerritoryID);
ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", territorydefinition.CountryID);
ViewBag.StateID = new SelectList(db.CountryStates.Where(x => x.CountryID == territorydefinition.CountryID), "StateID", "StateName", territorydefinition.StateID);
ViewBag.CityID = new SelectList(db.CountryCities.Where(x => x.CountryID == territorydefinition.CountryID && x.StateID == territorydefinition.StateID), "CityID", "CityName", territorydefinition.CityID);
return(View(territorydefinition));
}
public ActionResult Edit([Bind(Include = "GameID,GameCode,GameTypeID,GameName,GameDescription,DateInserted,DateUpdated,USR,GameCreationStatus,GameState,NumberOfWinners,NextGameID,MemberSubscriptionType,Global")] Game game)
{
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.NextGames, "NextGameID", "USR", game.GameID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameCode", game.GameID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameCode", game.GameID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameCode", game.GameID);
ViewBag.GameID = new SelectList(db.Games, "GameID", "GameCode", game.GameID);
ViewBag.MemberSubscriptionType = new SelectList(db.MemberSubscriptionTypes, "MemberSubscriptionTypeID", "MemberSubscriptionTypeCode", game.MemberSubscriptionType);
return(View(game));
}
