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