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