Beispiel #1
0
        public void UpdateMemberBid(MemberBid memberBid)
        {
            string sql = "INSERT INTO MemberToBid (MemberId, ProductId, BidAmount, ActiveFrom) Values (@MemberId, @ProductId, @BidAmount, getdate());";

            try
            {
                using (var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection")))
                {
                    connection.Open();
                    var result = connection.Execute(sql, new
                    {
                        memberBid.MemberId,
                        ProductId = memberBid.ItemId,
                        memberBid.BidAmount
                    });
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }
 public void Post([FromBody] MemberBid memberBid)
 {
     dataLayer.UpdateMemberBid(memberBid);
 }