コード例 #1
0
        public async Task <bool> Update(int id, PutProperty property)
        {
            try
            {
                using (IDbConnection dbConnection = db)
                {
                    var result       = 0;
                    var updateFields = UpdateStringConstruction(property);

                    dbConnection.Open();

                    foreach (var updateField in updateFields)
                    {
                        string updateQuery = $"UPDATE dbo.Properties " +
                                             $"SET { updateField }" +
                                             $"WHERE PropertyId = { id }";


                        result = await dbConnection.ExecuteAsync(updateQuery, property);
                    }
                    return(result > 0 ? true : false);
                }
            }
            catch
            {
                return(false);
            }
        }
コード例 #2
0
        public async Task <IActionResult> Put(int id, [FromBody] PutProperty property)
        {
            var result = await repository.Update(id, property);

            if (!result)
            {
                return(BadRequest("record not updated"));
            }

            return(Ok());
        }
コード例 #3
0
        private IEnumerable <string> UpdateStringConstruction(PutProperty property)
        {
            List <string> fields = new List <string>();

            if (!string.IsNullOrWhiteSpace(property.Housenumber))
            {
                fields.Add("Forename = @Housenumber ");
            }

            if (!string.IsNullOrWhiteSpace(property.Street))
            {
                fields.Add("Surname = @Street ");
            }

            if (!string.IsNullOrWhiteSpace(property.Town))
            {
                fields.Add("Email = @Town ");
            }

            if (!string.IsNullOrWhiteSpace(property.PostCode))
            {
                fields.Add("PostCode = @PostCode ");
            }

            if (property.AvailableFrom != null)
            {
                fields.Add("AvailableFrom = @AvailableFrom ");
            }

            if (!string.IsNullOrWhiteSpace(property.Status))
            {
                fields.Add("Status = @Status ");
            }

            if (property.LandlordId > 0)
            {
                fields.Add("Phone = @LandlordId ");
            }

            return(fields.ToArray());
        }