public JsonResultEntity Create([FromBody] PlaceUserImageEntity placeuserimageEntity)
{
PlaceUserImageBL placeuserimageBL = new PlaceUserImageBL();
JsonResultEntity response = new JsonResultEntity();
try
{
var result = placeuserimageBL.Create(placeuserimageEntity);
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 PlaceUserImageEntity Create(PlaceUserImageEntity placeuserimageEntity)
{
var query = @"INSERT INTO ""PlaceUserImage""(""Content"",""IsMain"",""PlaceID"",""CreatedDate"",""Checksum"",""Caption"",""UserContent"",""ContentType"",""Approved"",""Rating"",""UserID"",""Point"") VALUES(@Content,@IsMain,@PlaceID,@CreatedDate,@Checksum,@Caption,@UserContent,@ContentType,@Approved,@Rating,@UserID,@Point) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, placeuserimageEntity).Single();
placeuserimageEntity.ID = id;
return(placeuserimageEntity);
}
public ResultEntity <PlaceUserImageEntity> Create(PlaceUserImageEntity placeuserimageEntity)
{
var validationResult = new ResultEntity <PlaceUserImageEntity>();
using (var placeuserimageDA = new PlaceUserImageDA())
{
validationResult.Value = placeuserimageDA.Create(placeuserimageEntity);
}
return(validationResult);
}
public int Update(PlaceUserImageEntity placeuserimageEntity)
{
int affectedRows = 0;
if (IsHaveId <PlaceUserImageEntity>(placeuserimageEntity) == false)
{
var query = @"UPDATE ""PlaceUserImage"" SET ""Content""=@Content,""IsMain""=@IsMain,""PlaceID""=@PlaceID,""CreatedDate""=@CreatedDate,""Checksum""=@Checksum,""Caption""=@Caption,""UserContent""=@UserContent,""ContentType""=@ContentType,""Approved""=@Approved,""Rating""=@Rating,""UserID""=@UserID,""Point""=@Point WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, placeuserimageEntity);
}
return(affectedRows);
}
public ResultEntity <PlaceUserImageEntity> Update(PlaceUserImageEntity placeuserimageEntity)
{
var validationResult = new ResultEntity <PlaceUserImageEntity>();
using (var placeuserimageDA = new PlaceUserImageDA())
{
var resultUpdate = placeuserimageDA.Update(placeuserimageEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating PlaceUserImage!");
return(validationResult);
}
validationResult.Value = placeuserimageEntity;
}
return(validationResult);
}
