Ejemplo n.º 1
0
        public HttpResponseMessage AddNewBoardMember(BoardMembersDto boardmember)
        {
            var repository = new BoardMembersRepository();
            var result     = repository.Create(boardmember);

            if (result)
            {
                return(Request.CreateResponse(HttpStatusCode.Created));
            }
            return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Board Member could not be added"));
        }
        public bool Create(BoardMembersDto boardmember)
        {
            using (var db = GetConnection())
            {
                db.Open();

                var records = db.Execute(@"INSERT INTO [dbo].[BoardMember]
                                                     ([Name]
                                                     ,[PropertyId]
                                                     ,[PhoneNumber]
                                                     ,[EmailAddress])
                                                VALUES
                                                     (@Name
                                                     ,@PropertyId
                                                     ,@PhoneNumber
                                                     ,@EmailAddress)", boardmember);
                return(records == 1);
            }
        }