public List<IssueModel> getAll()
{
List<IssueModel> issues = new List<IssueModel>();
using (KnowledgeBaseContext dc = new KnowledgeBaseContext(connectionString, mapping))
{
IEnumerable<IssueModel> allIssues = from i in dc.GetTable<IssueModel>() select i;
foreach (var issue in allIssues)
{
issues.Add(issue);
}
}
return issues;
}
public bool add(IssueModel issue)
{
Guid id = issue.id;
string title = issue.title;
string symptom = issue.symptom;
string diagnostic = issue.diagnostic;
string fix = issue.fix;
string comments = issue.comments;
bool inserted = false;
using (KnowledgeBaseContext dc = new KnowledgeBaseContext(connectionString, mapping))
{
if (dc.addIssue(id, title, symptom, diagnostic, fix, comments)>0)
{
inserted = true;
}
}
return inserted;
}