// Updating the database public bool Update(Cooler ClassCooler) { var isSuccess = false; var connection = new SqlConnection(connectionString); try { // Query to update the data var query = "UPDATE Cooler SET Manufacturer=@Manufacturer, Name=@Name, " + "FanRPM=@FanRPM, NoiseLevelDb=@NoiseLevelDb, Price=@Price WHERE CoolerId=@CoolerId"; var cmd = new SqlCommand(query, connection); cmd.Parameters.AddWithValue("@CoolerId", ClassCooler.Id); cmd.Parameters.AddWithValue("@Manufacturer", ClassCooler.Manufacturer); cmd.Parameters.AddWithValue("@Name", ClassCooler.Name); cmd.Parameters.AddWithValue("@FanRPM", ClassCooler.FanRPM); cmd.Parameters.AddWithValue("@NoiseLevelDb", ClassCooler.NoiseLevelDb); cmd.Parameters.AddWithValue("@Price", ClassCooler.Price); connection.Open(); int rows = cmd.ExecuteNonQuery(); isSuccess = rows > 0 ? true : false; } finally { connection.Close(); } return(isSuccess); }
public bool Delete(Cooler ClassCooler) { var isSuccess = false; var connection = new SqlConnection(connectionString); try { // Query to delete the data var query = "DELETE FROM Cooler WHERE CoolerId=@CoolerId"; var cmd = new SqlCommand(query, connection); cmd.Parameters.AddWithValue("@CoolerId", ClassCooler.Id); connection.Open(); int rows = cmd.ExecuteNonQuery(); isSuccess = rows > 0 ? true : false; } finally { connection.Close(); } return(isSuccess); }
// Adding to database public bool Insert(Cooler ClassCooler) { var isSuccess = false; var connection = new SqlConnection(connectionString); try { // SQL Query to Insert the data var query = "INSERT INTO Cooler (CoolerId, Manufacturer, Name, FanRPM, NoiseLevelDb, Price) " + "VALUES(@CoolerId, @Manufacturer, @Name, @FanRPM, @NoiseLevelDb, @Price)"; var cmd = new SqlCommand(query, connection); cmd.Parameters.AddWithValue("@CoolerId", ClassCooler.Id); cmd.Parameters.AddWithValue("@Manufacturer", ClassCooler.Manufacturer); cmd.Parameters.AddWithValue("@Name", ClassCooler.Name); cmd.Parameters.AddWithValue("@FanRPM", ClassCooler.FanRPM); cmd.Parameters.AddWithValue("@NoiseLevelDb", ClassCooler.NoiseLevelDb); cmd.Parameters.AddWithValue("@Price", ClassCooler.Price); connection.Open(); int rows = cmd.ExecuteNonQuery(); isSuccess = rows > 0 ? true : false; } finally { connection.Close(); } return(isSuccess); }