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