public HttpResponseMessage Put(WorkflowCategory workflowCategory)
{
if (_repository.EditWorkflowCategory(workflowCategory))
{
DataSourceResult result = new DataSourceResult
{
Data = new[] { workflowCategory },
Total = 1
};
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, result);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = workflowCategory.WorkflowCategoryID }));
return response;
}
else
return Request.CreateResponse(HttpStatusCode.BadRequest, ModelState);
}
public bool EditWorkflowCategory(WorkflowCategory toUpdate)
{
int rowAffected = 0;
using (var connection = new SqlConnection(PrescienceRxConnectionString))
{
connection.Open();
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = @"UPDATE dbo.WorkflowCategory SET CategoryName = @CategoryName WHERE WorkflowCategoryID = @WorkflowCategoryID";
command.Parameters.AddWithValue("@WorkflowCategoryID", toUpdate.WorkflowCategoryID);
command.Parameters.AddWithValue("@CategoryName", toUpdate.CategoryName);
rowAffected = command.ExecuteNonQuery();
}
connection.Dispose();
}
return rowAffected == 1 ? true : false;
}
public int AddWorkflowCategory(WorkflowCategory toInsert)
{
int rowAffected = 0;
using (var connection = new SqlConnection(PrescienceRxConnectionString))
{
connection.Open();
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = @"INSERT INTO dbo.WorkflowCategory VALUES (@CategoryName, @CompanyId); SELECT CAST(SCOPE_IDENTITY() AS INT);";
command.Parameters.AddWithValue("@CategoryName", toInsert.CategoryName);
command.Parameters.AddWithValue("@CompanyId", toInsert.CompanyId);
rowAffected = (int)command.ExecuteScalar();
}
connection.Dispose();
}
return rowAffected;
}