public JsonResultEntity Create([FromBody] SchedulerSessionEntity schedulersessionEntity)
{
SchedulerSessionBL schedulersessionBL = new SchedulerSessionBL();
JsonResultEntity response = new JsonResultEntity();
try
{
var result = schedulersessionBL.Create(schedulersessionEntity);
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 SchedulerSessionEntity Create(SchedulerSessionEntity schedulersessionEntity)
{
var query = @"INSERT INTO ""SchedulerSession""(""SessionID"",""Params"",""CreatedDate"") VALUES(@SessionID,@Params,@CreatedDate) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, schedulersessionEntity).Single();
schedulersessionEntity.ID = id;
return(schedulersessionEntity);
}
public ResultEntity <SchedulerSessionEntity> Create(SchedulerSessionEntity schedulersessionEntity)
{
var validationResult = new ResultEntity <SchedulerSessionEntity>();
using (var schedulersessionDA = new SchedulerSessionDA())
{
validationResult.Value = schedulersessionDA.Create(schedulersessionEntity);
}
return(validationResult);
}
public int Update(SchedulerSessionEntity schedulersessionEntity)
{
int affectedRows = 0;
if (IsHaveId <SchedulerSessionEntity>(schedulersessionEntity) == false)
{
var query = @"UPDATE ""SchedulerSession"" SET ""SessionID""=@SessionID,""Params""=@Params,""CreatedDate""=@CreatedDate WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, schedulersessionEntity);
}
return(affectedRows);
}
public ResultEntity <SchedulerSessionEntity> Update(SchedulerSessionEntity schedulersessionEntity)
{
var validationResult = new ResultEntity <SchedulerSessionEntity>();
using (var schedulersessionDA = new SchedulerSessionDA())
{
var resultUpdate = schedulersessionDA.Update(schedulersessionEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating SchedulerSession!");
return(validationResult);
}
validationResult.Value = schedulersessionEntity;
}
return(validationResult);
}
