public async Task <int> AddGameAsync(GameAddModel game) { throw new NotImplementedException(); //var validator = DataValidatorHelper.Validate(game); //if(validator.IsValid) //{ // var gameDB = await GetGameByTitleAsync(game.Title); // if (gameDB == null) // { // Console.WriteLine($"{game.Title} has been added to database"); // return await _gamedbAccess.AddGameAsync(game); // } // return gameDB.GameID; //} //Console.WriteLine($"Invalid Data from {nameof(GameAddModel)}"); //validator.Errors.ForEach(e => Console.WriteLine(e)); //throw new Exception("Some data are invalid"); }
public async Task <int> AddGameAsync(GameAddModel gameAddModel) { // need to fix string query = $@"INSERT INTO game (Title, Type, About, Website, Thumbnail, Description, HeaderImage, Background,SteamAppId, ReleaseDateId) OUTPUT Inserted.GameId VALUES(@Title, @Type,@About, @Website,@Thumbnail, @Description, @HeaderImage, @Background)"; return(await SaveDataAsync(query, gameAddModel)); }
public string AddGame(GameAddModel game) { Game newGame = new Game(); newGame.GameName = game.GameName; newGame.GameNumber = game.GameNumber; newGame.OrganizationId = game.OrganizationId; uow.GameRepository.Create(newGame); return("Game is created"); }
public ActionResult Index(string button, GameAddModel model, HttpPostedFileBase image) { var connectionString = GetDatabaseConnection(ConnectionName); AuthorizationData data = new AuthorizationData(); using (var conn = new SqlConnection(connectionString)) switch (button) { case "Add User": using (var command = new SqlCommand("InsertUser", conn) { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@UserName", model.UserName); command.Parameters.AddWithValue("@Email", model.UserEmail); command.Parameters.AddWithValue("@Password", model.UserPassword); var returnParameter = command.Parameters.Add("@ReturnVal", SqlDbType.Int); returnParameter.Direction = ParameterDirection.ReturnValue; conn.Open(); command.ExecuteNonQuery(); var result = Convert.ToBoolean(returnParameter.Value); conn.Close(); if (result == false) { data.Status = false; } else { data.Status = true; } } if (data.Status == true) { ModelState.AddModelError("", "The user with this email already exist."); return(View(model)); } break; case "Add Game": string path = @"C:\1\IMZ\trunk\InetMagaz\InetMagaz\Content\Images\"; if (image != null) { image.SaveAs(path + image.FileName); } string saveToBaseUrl = "./Content/Images/"; using (var command = new SqlCommand("InsertGame", conn) { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@Name", model.GameName); command.Parameters.AddWithValue("@Description", model.GameDescription); command.Parameters.AddWithValue("@ImageUrl", (saveToBaseUrl + image.FileName)); command.Parameters.AddWithValue("@Price", Convert.ToInt32(model.GamePrice)); conn.Open(); command.ExecuteNonQuery(); conn.Close(); } break; } return(View()); }