public JsonResultEntity Create([FromBody] PromoImageEntity promoimageEntity)
{
PromoImageBL promoimageBL = new PromoImageBL();
JsonResultEntity response = new JsonResultEntity();
try
{
var result = promoimageBL.Create(promoimageEntity);
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 PromoImageEntity Create(PromoImageEntity promoimageEntity)
{
var query = @"INSERT INTO ""PromoImage""(""IsMain"",""PromoID"",""Content"",""ModifiedDate"",""Checksum"") VALUES(@IsMain,@PromoID,@Content,@ModifiedDate,@Checksum) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, promoimageEntity).Single();
promoimageEntity.ID = id;
return(promoimageEntity);
}
public ResultEntity <PromoImageEntity> Create(PromoImageEntity promoimageEntity)
{
var validationResult = new ResultEntity <PromoImageEntity>();
using (var promoimageDA = new PromoImageDA())
{
validationResult.Value = promoimageDA.Create(promoimageEntity);
}
return(validationResult);
}
public int Update(PromoImageEntity promoimageEntity)
{
int affectedRows = 0;
if (IsHaveId <PromoImageEntity>(promoimageEntity) == false)
{
var query = @"UPDATE ""PromoImage"" SET ""IsMain""=@IsMain,""PromoID""=@PromoID,""Content""=@Content,""ModifiedDate""=@ModifiedDate,""Checksum""=@Checksum WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, promoimageEntity);
}
return(affectedRows);
}
public ResultEntity <PromoImageEntity> Update(PromoImageEntity promoimageEntity)
{
var validationResult = new ResultEntity <PromoImageEntity>();
using (var promoimageDA = new PromoImageDA())
{
var resultUpdate = promoimageDA.Update(promoimageEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating PromoImage!");
return(validationResult);
}
validationResult.Value = promoimageEntity;
}
return(validationResult);
}
