public string PostComputerModel(ComputerModel computerModel)
{
if (!GetComputerModelExists(computerModel.name))
{
try
{
int result = DatabaseConnection.Execute
(
"INSERT INTO Computer(modelName, manufacturer, modelType, price, quantity, modifiedDate, operatingSystem, processorFamily, graphicsFamily, storage, memory, powerSupply, towerForm, screenSize, batteryLife, webcamera, fullsizeKeyboard) VALUES(@modelName, @manufacturer, @modelType, @price, @quantity, DATETIME('now'), @operatingSystem, @processorFamily, @graphicsFamily, @storage, @memory, @powerSupply, @towerForm, @screenSize, @batteryLife, @webcamera, @fullsizeKeyboard);",
computerModel.toParameterList()
);
if (result == 1)
{
return("SUCCESS");
}
else
{
return("COUNT ERROR");
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
else
{
return("KEY ERROR");
}
}
public string PutComputerModel(ComputerModel computerModel)
{
try
{
int result = DatabaseConnection.Execute
(
"UPDATE Computer SET price = @price, quantity = @quantity, modifiedDate = DATETIME('now'), operatingSystem = @operatingSystem, processorFamily = @processorFamily, graphicsFamily = @graphicsFamily, storage = @storage, memory = @memory, powerSupply = @powerSupply, towerForm = @towerForm, screenSize = @screenSize, batteryLife = @batteryLife, webcamera = @webCamera, fullsizeKeyboard = @fullsizeKeyboard WHERE Computer.modelName = @modelName;",
computerModel.toParameterList()
);
if (result == 1)
{
return("SUCCESS");
}
else
{
return("COUNT ERROR");
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}