public bool Create(BasketResultEntity entity)
{
string sql = "INSERT INTO Basket (BasketId, CustomerId, ProductId, Quantity) Values (@BasketId, @CustomerId, @ProductId, @Quantity);";
using (var connection = new SqlConnection(config.GetValue <string>("Conn")))
{
var affectedRows = connection.Execute(sql, entity);
}
return(true);
}
public bool Update(BasketResultEntity entity)
{
string sql = "UPDATE[Basket] SET[BasketId] = @BasketId ,[CustomerId] = @CustomerId , [ProductId] = @ProductId , [Quantity] = @Quantity WHERE BasketId = " + entity.BasketId;
using (var connection = new SqlConnection(config.GetValue <string>("Conn")))
{
var affectedRows = connection.Execute(sql, entity);
}
return(true);
}