public JsonResultEntity Create([FromBody] EventOrganizerEntity eventorganizerEntity)
{
EventOrganizerBL eventorganizerBL = new EventOrganizerBL();
JsonResultEntity response = new JsonResultEntity();
try
{
var result = eventorganizerBL.Create(eventorganizerEntity);
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 EventOrganizerEntity Create(EventOrganizerEntity eventorganizerEntity)
{
var query = @"INSERT INTO ""EventOrganizer""(""Name"",""Description"",""Phone1"",""Phone2"",""Logo"",""ShortName"",""LongDescription"",""LogoChecksum"") VALUES(@Name,@Description,@Phone1,@Phone2,@Logo,@ShortName,@LongDescription,@LogoChecksum) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, eventorganizerEntity).Single();
eventorganizerEntity.ID = id;
return(eventorganizerEntity);
}
public ResultEntity <EventOrganizerEntity> Create(EventOrganizerEntity eventorganizerEntity)
{
var validationResult = new ResultEntity <EventOrganizerEntity>();
using (var eventorganizerDA = new EventOrganizerDA())
{
validationResult.Value = eventorganizerDA.Create(eventorganizerEntity);
}
return(validationResult);
}
public int Update(EventOrganizerEntity eventorganizerEntity)
{
int affectedRows = 0;
if (IsHaveId <EventOrganizerEntity>(eventorganizerEntity) == false)
{
var query = @"UPDATE ""EventOrganizer"" SET ""Name""=@Name,""Description""=@Description,""Phone1""=@Phone1,""Phone2""=@Phone2,""Logo""=@Logo,""ShortName""=@ShortName,""LongDescription""=@LongDescription,""ModifiedDate""=@ModifiedDate,""LogoChecksum""=@LogoChecksum WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, eventorganizerEntity);
}
return(affectedRows);
}
public ResultEntity <EventOrganizerEntity> Update(EventOrganizerEntity eventorganizerEntity)
{
var validationResult = new ResultEntity <EventOrganizerEntity>();
eventorganizerEntity.ModifiedDate = DateTime.Now;
using (var eventorganizerDA = new EventOrganizerDA())
{
var resultUpdate = eventorganizerDA.Update(eventorganizerEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating EventOrganizer!");
return(validationResult);
}
validationResult.Value = eventorganizerEntity;
}
return(validationResult);
}
