private void UpdateChangeRequestInDB(ChangeRequest changeRequest)
{
new SQLiteCommand(SQLFixedQueries.UpdateChangeRequest(changeRequest.ID,
changeRequest.VersionImplemented,
changeRequest.DetailedDescription,
changeRequest.Justification),
conn).ExecuteNonQuery();
}
private void InsertChangeRequestInDB(ChangeRequest changeRequest, int issueID)
{
new SQLiteCommand(SQLFixedQueries.InsertChangeRequest(issueID,
changeRequest.VersionImplemented,
changeRequest.DetailedDescription,
changeRequest.Justification),
conn).ExecuteNonQuery();
}
private void UpdateBugInDB(Bug bug)
{
new SQLiteCommand(SQLFixedQueries.UpdateBug(bug.ID,
bug.VersionFound,
bug.VersionFixed,
bug.DetailedDescription,
bug.StepsToReproduce,
bug.Workaround,
bug.Fix),
conn).ExecuteNonQuery();
}
private void InsertBugInDB(Bug bug, int issueID)
{
new SQLiteCommand(SQLFixedQueries.InsertBug(issueID,
bug.VersionFound,
bug.VersionFixed,
bug.DetailedDescription,
bug.StepsToReproduce,
bug.Workaround,
bug.Fix),
conn).ExecuteNonQuery();
}
private void UpdateIssueInDB(Issue issue, int userID)
{
new SQLiteCommand(SQLFixedQueries.UpdateIssue(issue.IssueID,
issue.Description,
userID,
issue.DateClosed.ToString(),
issue.PlantContact,
issue.IssueState,
issue.IssueResolution,
issue.Priority,
issue.Severity),
conn).ExecuteNonQuery();
}
private void CreateDatabase()
{
SQLiteConnection.CreateFile(Settings.Default.DBLocation);
using (conn = new SQLiteConnection(connectionString))
{
conn.Open();
new SQLiteCommand(SQLFixedQueries.CreateTables(), conn).ExecuteNonQuery();
new SQLiteCommand(SQLFixedQueries.CreateViews(), conn).ExecuteNonQuery();
new SQLiteCommand(SQLFixedQueries.CreateDefaultData(), conn).ExecuteNonQuery();
new SQLiteCommand(SQLFixedQueries.InsertTestData(), conn).ExecuteNonQuery(); //TODO remove this when releasing
}
}
private int InsertIssueInDBAndGetID(Issue issue, int userID)
{
new SQLiteCommand(SQLFixedQueries.InsertIssue(issue.Description,
userID,
issue.DateCreated.ToString(),
issue.PlantContact,
issue.IssueType,
issue.IssueState,
issue.IssueResolution,
issue.Priority,
issue.Severity),
conn).ExecuteNonQuery();
return(Convert.ToInt32(new SQLiteCommand(SQLFixedQueries.GetRowID(), conn)
.ExecuteScalar()));
}
private int GetUserID(string user)
{
object userID = new SQLiteCommand(SQLFixedQueries.GetUserIDFromName(user), conn)
.ExecuteScalar();
if (userID != null)
{
return(Convert.ToInt32(userID));
}
else
{
new SQLiteCommand(SQLFixedQueries.InsertUsername(user), conn)
.ExecuteNonQuery();
return(Convert.ToInt32(new SQLiteCommand(SQLFixedQueries.GetRowID(), conn)
.ExecuteScalar()));
}
}
Bug IDataAccess.GetBug(int id)
{
using (conn = new SQLiteConnection(connectionString))
{
conn.Open();
var bug = new Bug();
var reader = new SQLiteCommand(SQLFixedQueries.SelectBug(id), conn)
.ExecuteReader();
while (reader.Read())
{
bug = ReadBugFromSQL(reader);
}
return(bug);
}
}
IssueViewModel IDataAccess.GetIssue(int id)
{
using (conn = new SQLiteConnection(connectionString))
{
conn.Open();
var issue = new IssueViewModel();
var reader = new SQLiteCommand(SQLFixedQueries.SelectIssue(id), conn)
.ExecuteReader();
while (reader.Read())
{
issue = ReadIssueFromSQL(reader);
}
return(issue);
}
}
ChangeRequest IDataAccess.GetChangeRequest(int id)
{
using (conn = new SQLiteConnection(connectionString))
{
conn.Open();
var changeRequest = new ChangeRequest();
var reader = new SQLiteCommand(SQLFixedQueries.SelectChangeRequest(id), conn)
.ExecuteReader();
while (reader.Read())
{
changeRequest = ReadChangeRequestFromSQL(reader);
}
return(changeRequest);
}
}
private bool IssueExists(int issueID)
{
return(Convert.ToInt32(new SQLiteCommand(SQLFixedQueries.DoesIssueExist(issueID), conn)
.ExecuteScalar()) > 0);
}
