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