public IHttpActionResult PutSeverityTask(int id, SeverityTask severityTask)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != severityTask.TaskId)
{
return(BadRequest());
}
db.Entry(severityTask).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!db.SeverityTaskExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task Post(string Title, string Description, int Severity)
{
SeverityTask st = new SeverityTask();
st.Title = Title;
st.Description = Description;
st.Severity = Severity;
await this.severityTaskProvider.AddTask(st);
}
public IHttpActionResult GetSeverityTask(int id)
{
SeverityTask severityTask = db.SeverityTasks.Find(id);
if (severityTask == null)
{
return(NotFound());
}
return(Ok(severityTask));
}
public async Task Put(int id, string Title, string Description, int Severity)
{
SeverityTask st = new SeverityTask();
st.Id = id;
st.Title = Title;
st.Description = Description;
st.Severity = Severity;
await this.severityTaskProvider.UpdateTask(st);
}
public IHttpActionResult PostSeverityTask(Task task, SeverityTask severityTask)
{
if (!ModelState.IsValid || task.Id != severityTask.TaskId || db.TaskExists(task.Id))
{
return(BadRequest(ModelState));
}
db.Tasks.Add(task);
db.SeverityTasks.Add(severityTask);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = severityTask.TaskId }, severityTask));
}
public async Task AddTask(SeverityTask task)
{
using (var sqlConnection = new SqlConnection(connectionString))
{
await sqlConnection.OpenAsync();
var dp = new DynamicParameters();
dp.Add("@Title", task.Title);
dp.Add("@Description", task.Description);
dp.Add("@Severity", task.Severity);
await sqlConnection.ExecuteAsync(
"spAddSeverityTask",
dp,
commandType : CommandType.StoredProcedure);
}
}
public bool UpdateSeverityTask(SeverityTask severityTask)
{
_db.SeverityTask.Update(severityTask);
return(Save());
}
public bool DeleteSeverityTask(SeverityTask severityTask)
{
_db.SeverityTask.Remove(severityTask);
return(Save());
}
public bool CreatSeverityTask(SeverityTask severityTask)
{
_db.SeverityTask.Add(severityTask);
return(Save());
}
