public bool Add(SystemRequirements systemRequirements) { using (var connection = GetConnection()) { var parameters = new DynamicParameters(); parameters.Add("@Id", systemRequirements.Id, direction: ParameterDirection.Output); parameters.Add("@GameId", systemRequirements.GameId); parameters.Add("@Processor", systemRequirements.Processor); parameters.Add("@Memory", systemRequirements.Memory); parameters.Add("@Graphics", systemRequirements.Graphics); parameters.Add("@OperationSystem", systemRequirements.OperationSystem); parameters.Add("@DirectX", systemRequirements.DirectX); parameters.Add("@Storage", systemRequirements.Storage); parameters.Add("@Type", systemRequirements.Type); connection.Open(); connection.Execute( "SystemRequirements_Add", parameters, commandType: CommandType.StoredProcedure); systemRequirements.Id = parameters.Get <int>("@Id"); return(systemRequirements.Id != 0); } }
public SystemRequirements GetSystemReqById(int id) { SystemRequirements sysReq = new SystemRequirements(); using (_connection) { _connection.Open(); string selectString = "SELECT * FROM SystemRequirements WHERE SystemRequirementsId = @SystemRequirementsId"; command.CommandText = selectString; command.Parameters.Add("@SystemRequirementsId", id); SqlDataReader reader = command.ExecuteReader(); if (!reader.HasRows) { return(null); } while (reader.Read()) { sysReq.Game = Convert.ToInt32(reader["Game"]); sysReq.OS = reader["OS"].ToString(); sysReq.Processor = reader["Processor"].ToString(); sysReq.Memory = reader["Memory"].ToString() + " GB Ram"; } reader.Close(); _connection.Close(); } return(sysReq); }
public bool Update(SystemRequirements systemRequirements) { try { return(_systemRequirementsDao.Update(systemRequirements)); } catch { throw; } }
public bool Add(SystemRequirements systemRequirements) { try { return(_systemRequirementsDao.Add(systemRequirements)); } catch { throw; } }
public void InsertSysReqGame(SystemRequirements sysReq) { using (_connection) { _connection.Open(); string insertString = @"INSERT INTO SystemRequirements VALUES( @Processor,@Memory,@OS,@Game)"; command.CommandText = insertString; command.Parameters.Add("@Processor", sysReq.Processor); command.Parameters.Add("@Memory", sysReq.Memory); command.Parameters.Add("@OS", sysReq.OS); command.Parameters.Add("@Game", sysReq.Game); command.ExecuteNonQuery(); _connection.Close(); } }
public void UpdateGameById(SystemRequirements sysReq) { using (_connection) { _connection.Open(); string updateString = @"UPDATE SystemRequirements SET Processor = @Processor,Memory = @Memory, OS = @OS,Game = @Game WHERE SystemRequirementsId = @SystemRequirementsId"; command.CommandText = updateString; command.Parameters.Add("@SystemRequirementsId", sysReq.SystemRequirementsId); command.Parameters.Add("@Processor", sysReq.Processor); command.Parameters.Add("@OS", sysReq.OS); command.Parameters.Add("@Game", sysReq.Game); command.ExecuteNonQuery(); _connection.Close(); } }
public bool Update(SystemRequirements systemRequirements) { using (var connection = GetConnection()) { var parameters = new DynamicParameters(); parameters.Add("@Id", systemRequirements.Id); parameters.Add("@Processor", systemRequirements.Processor); parameters.Add("@Memory", systemRequirements.Memory); parameters.Add("@Graphics", systemRequirements.Graphics); parameters.Add("@OperationSystem", systemRequirements.OperationSystem); parameters.Add("@DirectX", systemRequirements.DirectX); parameters.Add("@Storage", systemRequirements.Storage); connection.Open(); return(connection.Execute( "SystemRequirements_Update", parameters, commandType: CommandType.StoredProcedure) > 0); } }
public async Task <IActionResult> Create(GameViewModel model) { if (ModelState.IsValid) { byte[] imageData = null; if (model.Image != null) { using (var binaryReader = new BinaryReader(model.Image.OpenReadStream())) { imageData = binaryReader.ReadBytes((int)model.Image.Length); } } Picture picture = new Picture { Image = imageData }; _context.Pictures.Add(picture); SystemRequirements systemReq = new SystemRequirements { OS = model.OS, CPU = model.CPU, RAM = model.RAM, GPU = model.GPU, Memory = model.Memory }; Game game = new Game { Picture = picture, SystemRequirements = systemReq, Name = model.Name, Price = model.Price, GenreId = model.GenreId, PlaingFieldId = model.PlaingFieldId }; await _context.AddAsync(game); await _context.SystemRequirements.AddAsync(systemReq); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Management))); } ViewData["GenreId"] = new SelectList(_context.Set <Genre>(), "Id", "Name"); ViewData["PlaingFieldId"] = new SelectList(_context.Set <PlaingField>(), "Id", "Name"); ViewData["OSs"] = await _context.SystemRequirements.Select(s => s.OS).Distinct().ToListAsync(); ViewData["CPUs"] = await _context.SystemRequirements.Select(s => s.CPU).Distinct().ToListAsync(); ViewData["GPUs"] = await _context.SystemRequirements.Select(s => s.GPU).Distinct().ToListAsync(); ViewData["RAMs"] = await _context.SystemRequirements.Select(s => s.RAM).Distinct().ToListAsync(); ViewData["Memory"] = await _context.SystemRequirements.Select(s => s.Memory).Distinct().ToListAsync(); return(View(model)); }
public async Task <ResultDTO> AddProduct([FromBody] ProductAddDTO model, [FromForm(Name = "file")] IFormFile uploadedImage) { if (!ModelState.IsValid) { return(new ResultDTO { Status = 500, Message = "Error", Errors = Validation.GetErrorsByModel(ModelState) }); } else { var product = new Product() { Name = model.Name, CompanyName = model.CompanyName, Price = model.Price, Description = model.Description, Image = "", Data = model.Data, }; _context.Products.Add(product); _context.SaveChanges(); int idProduct = (from v in _context.Products orderby v.Id descending select v).FirstOrDefault().Id; var systemrequirements = new SystemRequirements() { OS = model.sysreqProduct.OS, Processor = model.sysreqProduct.Processor, Graphics = model.sysreqProduct.Graphics, Memory = model.sysreqProduct.Memory, Storege = model.sysreqProduct.Storege, ProdctId = idProduct }; _context.SystemRequirementsProduct.Add(systemrequirements); foreach (var item in model.listIdLang) { ProductLanguages temp = new ProductLanguages(); temp.ProdctId = idProduct; temp.LanguageId = item; _context.ProductLanguages.Add(temp); } foreach (var item in model.listIdCateg) { ProductCategories temp = new ProductCategories(); temp.ProdctId = idProduct; temp.CategoryId = item; _context.ProductCategories.Add(temp); } _context.SaveChanges(); return(new ResultDTO { Status = 200 }); } }