public IEnumerable <SubjectTask> GetAllTasks()
{
var tasks = new List <SubjectTask>();
using (var databaseConnection = new SqlConnection(_connString))
{
databaseConnection.Open();
using (var command = new SqlCommand(getAllTasks, databaseConnection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var task = new SubjectTask
{
TaskId = (int)reader["TaskId"],
SubjectId = (int)reader["SubjectId"],
TaskPriority = (int)reader["TaskPriority"],
DeadLineDate = (DateTime)reader["DeadLineDate"],
TaskDescription = (string)reader["TaskDescription"]
};
tasks.Add(task);
}
}
}
}
return(tasks);
}
public async Task <IActionResult> PutSubjectTask(int id, SubjectTask subjectTask)
{
if (id != subjectTask.Id)
{
return(BadRequest());
}
_context.Entry(subjectTask).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubjectTaskExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <object> > PostSubjectTask(SubjectTask subjectTask)
{
_context.SubjectTask.Add(subjectTask);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSubjectTask", new { id = subjectTask.Id }, subjectTask));
}
public async Task SaveAsync(SubjectTask entity)
{
try
{
if (entity == null)
{
return;
}
using (var timeLineContext = _contextFactory.GetTimeLineContext())
{
var entityModel = await timeLineContext
.SubjectTasks
.FirstOrDefaultAsync(item => item.Id.Equals(entity.Id));
if (entityModel == null)
{
entityModel = new DA.SubjectTask();
MapForUpdateentity(entity, entityModel);
await timeLineContext.SubjectTasks.AddAsync(entityModel);
}
else
{
MapForUpdateentity(entity, entityModel);
}
timeLineContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ActionResult <IEnumerable <SubjectTask> > > GetByTask(SubjectTask subjectTask)
{
var subjTasks = await _context
.SubjectTask
.Where(entry => entry.TaskId == subjectTask.TaskId)
.ToListAsync();
return(Created("", subjTasks));
}
public async Task <IActionResult> Put([FromBody] SubjectTask value)
{
try
{
var entity = _mapper.Map <BL.SubjectTask>(value);
var id = _service.SaveAsync(entity);
return(Ok(id));
}
catch (Exception)
{
return(BadRequest());
}
}
private void MapForUpdateentity(SubjectTask entity, DA.SubjectTask daEntity)
{
daEntity.Id = entity.Id;
}
