public JsonResultEntity Create([FromBody] FeedsEntity feedsEntity)
{
FeedsBL feedsBL = new FeedsBL();
JsonResultEntity response = new JsonResultEntity();
try
{
var result = feedsBL.Create(feedsEntity);
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 async Task DeleteFeed(int feedId)
{
ValidateUserAsAdmin();
await DbContext.FeedsRepo.DeleteAsync(feedId);
FeedsEntity entity = await DbContext.FeedsRepo.GetSingleOrDefaultAsync(feedId);
}
public FeedsEntity Create(FeedsEntity feedsEntity)
{
var query = @"INSERT INTO ""Feeds""(""FeedChannel"",""Content"",""ImgUrl"",""TargetTags"",""CreatedDate"",""PushDate"",""PriorityWeight"",""PlanPushDate"",""TrackingID"") VALUES(@FeedChannel,@Content,@ImgUrl,@TargetTags,@CreatedDate,@PushDate,@PriorityWeight,@PlanPushDate,@TrackingID) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, feedsEntity).Single();
feedsEntity.ID = id;
return(feedsEntity);
}
public int Update(FeedsEntity feedsEntity)
{
int affectedRows = 0;
if (IsHaveId <FeedsEntity>(feedsEntity) == false)
{
var query = @"UPDATE ""Feeds"" SET ""FeedChannel""=@FeedChannel,""Content""=@Content,""ImgUrl""=@ImgUrl,""TargetTags""=@TargetTags,""PushDate""=@PushDate,""PriorityWeight""=@PriorityWeight,""PlanPushDate""=@PlanPushDate,""TrackingID""=@TrackingID WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, feedsEntity);
}
return(affectedRows);
}
public ResultEntity <FeedsEntity> Create(FeedsEntity feedsEntity)
{
var validationResult = new ResultEntity <FeedsEntity>();
feedsEntity.CreatedDate = DateTime.Now;
using (var feedsDA = new FeedsDA())
{
validationResult.Value = feedsDA.Create(feedsEntity);
}
return(validationResult);
}
public ResultEntity <FeedsEntity> Update(FeedsEntity feedsEntity)
{
var validationResult = new ResultEntity <FeedsEntity>();
using (var feedsDA = new FeedsDA())
{
var resultUpdate = feedsDA.Update(feedsEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating Feeds!");
return(validationResult);
}
validationResult.Value = feedsEntity;
}
return(validationResult);
}
