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); }