public JsonResultEntity Create([FromBody] UserInterestEntity userinterestEntity) { UserInterestBL userinterestBL = new UserInterestBL(); JsonResultEntity response = new JsonResultEntity(); try { var result = userinterestBL.Create(userinterestEntity); if (result.HasWarning()) { response.Message = String.Join(",", result.Warning); return(response); } response.Success = true; response.Data = result.Value; } catch (Exception ex) { response.Message = ex.Message; LoggerHelper.Error(ex); } return(response); }
public UserInterestEntity Create(UserInterestEntity userinterestEntity) { var query = @"INSERT INTO ""UserInterest""(""ContentType"",""ReferenceID"",""UserProfileID"") VALUES(@ContentType,@ReferenceID,@UserProfileID) RETURNING ""ID"";"; int id = DbConnection.Query <int>(query, userinterestEntity).Single(); userinterestEntity.ID = id; return(userinterestEntity); }
public ResultEntity <UserInterestEntity> Create(UserInterestEntity userinterestEntity) { var validationResult = new ResultEntity <UserInterestEntity>(); using (var userinterestDA = new UserInterestDA()) { validationResult.Value = userinterestDA.Create(userinterestEntity); } return(validationResult); }
public int Update(UserInterestEntity userinterestEntity) { int affectedRows = 0; if (IsHaveId <UserInterestEntity>(userinterestEntity) == false) { var query = @"UPDATE ""UserInterest"" SET ""ContentType""=@ContentType,""ReferenceID""=@ReferenceID,""UserProfileID""=@UserProfileID WHERE ""ID""=@ID"; affectedRows = DbConnection.Execute(query, userinterestEntity); } return(affectedRows); }
public ResultEntity <UserInterestEntity> Update(UserInterestEntity userinterestEntity) { var validationResult = new ResultEntity <UserInterestEntity>(); using (var userinterestDA = new UserInterestDA()) { var resultUpdate = userinterestDA.Update(userinterestEntity); if (resultUpdate <= 0) { validationResult.Warning.Add("Failed Updating UserInterest!"); return(validationResult); } validationResult.Value = userinterestEntity; } return(validationResult); }