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