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); }