public void Create(Component value) { var command = new SqlCommand("INSERT INTO Component VALUES (" + "@name," + "@price," + "@perfomance," + "@TypePart," + "@TypeFormat," + "@TypeMemory," + "@Socket," + "@HasIntegratedVideo," + "@Channels," + "@VideoLevel," + "@FanLevel," + "@NeedHighFrecuency," + "@Capacity," + "@FanSize," + "@MaxFrecuency," + "@Stock," + "@Watts," + "@Stock_Limit)"); PopulateComponent.Command(value, command); connection.Execute(command); }
public void Update(Component value) { var command = new SqlCommand("UPDATE Component SET " + "Name = @name, " + "Price = @price, " + "perfomance = @perfomance, " + "TypePart = @TypePart, " + "TypeFormat = @TypeFormat, " + "TypeMemory = @TypeMemory, " + "Socket = @Socket, " + "HasIntegratedVideo = @HasIntegratedVideo, " + "Channels = @Channels, " + "VideoLevel = @VideoLevel, " + "FanLevel = @FanLevel," + "NeedHighFrecuency = @NeedHighFrecuency," + "Capacity = @Capacity," + "FanSize = @FanSize," + "MaxFrecuency = @MaxFrecuency," + "Stock = @Stock," + "Watts = @Watts," + "Stock_Limit = @Stock_Limit WHERE ID = @id"); PopulateComponent.Command(value, command); connection.Execute(command); }