public void addFileStat(fileStatistics file) { int foundPackageID = getPackageId(file.getPackageName()); int foundClassID = getClassId(file.getClassName()); if (foundPackageID > 0 && foundClassID > 0) { String sql = String.Format(insertFileStatPrefix, statsTable, packageID, classID, uniqueKeywords, uniqueUDIs, uniqueConstants, uniqueSpecialChars, totalKeywords, totalUDIs, totalConstants, totalSpecialChars, totalChars, totalWhiteSpace, totalComments, percentWhitespace, percentComments, filePath, foundPackageID, foundClassID, file.getUniqueKeywords(), file.getUniqueUdis(), file.getUniqueConstants(), file.getUniqueSpecialChars(), file.getTotalKeywords(), file.getTotalUdis(), file.getTotalConstants(), file.getTotalSpecialChars(), file.getTotalChars(), file.getTotalWhiteSpace(), file.getTotalCommentChars(), file.getPercentWhitespace(), file.getPercentCommentsChars(), file.getFilepath()); Console.WriteLine("Sql String: " + sql); executeSqlNonQuery(sql); } else { Console.WriteLine("ERROR in addFileStat: Package or Class ID are invalid."); } }
public void replaceFileStat(fileStatistics file) { int foundPackageID = getPackageId(file.getPackageName()); int foundClassID = getClassId(file.getClassName()); String sql = String.Format(updateFileStatPrefix, statsTable, uniqueKeywords, file.getUniqueKeywords(), uniqueUDIs, file.getUniqueUdis(), uniqueConstants, file.getUniqueConstants(), uniqueSpecialChars, file.getUniqueSpecialChars(), totalKeywords, file.getTotalKeywords(), totalUDIs, file.getTotalUdis(), totalConstants, file.getTotalConstants(), totalSpecialChars, file.getTotalSpecialChars(), totalChars, file.getTotalChars(), totalWhiteSpace, file.getTotalWhiteSpace(), totalComments, file.getTotalCommentChars(), percentWhitespace, file.getTotalWhiteSpace(), percentComments, file.getPercentCommentsChars(), filePath, file.getFilepath(), packageID, foundPackageID, classID, foundClassID); Console.WriteLine("Sql String: " + sql); executeSqlNonQuery(sql); }
public void addRowToViewTable(fileStatistics file) { this.statsViewTable.Rows.Add( file.getPackageName(), file.getClassName(), file.getUniqueKeywords(), file.getUniqueUdis(), file.getUniqueConstants(), file.getUniqueSpecialChars(), file.getTotalKeywords(), file.getTotalUdis(), file.getTotalConstants(), file.getTotalSpecialChars(), file.getTotalChars(), file.getTotalWhiteSpace(), file.getTotalCommentChars(), file.getPercentWhitespace(), file.getPercentCommentsChars(), file.getFilepath()); }
public void updateRowInViewTable(fileStatistics file) { removeRowFromViewTable(file.getPackageName(), file.getClassName()); addRowToViewTable(file); }
public void addFileStat(fileStatistics file) { if (db.doesPackageExist(file.getPackageName()) == false && db.doesClassExist(file.getClassName()) == false) { //entry does not exists b/c its class and package don't exist. db.addPackage(file.getPackageName()); db.addClass(file.getClassName()); db.addFileStat(file); gui.setPackageDDSelection(file.getPackageName()); gui.setClassDDSelection(file.getClassName()); gui.populatePackageDD(file.getClassName()); gui.populateClassDD(file.getPackageName()); gui.rePopulateTable(file); } else if (db.doesPackageExist(file.getPackageName()) == true && db.doesClassExist(file.getClassName()) == false) { db.addClass(file.getClassName()); db.addFileStat(file); gui.setPackageDDSelection(file.getPackageName()); gui.setClassDDSelection(file.getClassName()); gui.populatePackageDD(file.getClassName()); gui.populateClassDD(file.getPackageName()); gui.rePopulateTable(file); } else if (db.doesPackageExist(file.getPackageName()) == false && db.doesClassExist(file.getClassName()) == true) { db.addPackage(file.getPackageName()); db.addFileStat(file); gui.setPackageDDSelection(file.getPackageName()); gui.setClassDDSelection(file.getClassName()); gui.populatePackageDD(file.getClassName()); gui.populateClassDD(file.getPackageName()); gui.rePopulateTable(file); } else //both package and class exist, duplicate DB entry { Boolean askUser = gui.askUserAboutDuplicate(); if (askUser == true) { db.replaceFileStat(file); gui.setPackageDDSelection(file.getPackageName()); gui.setClassDDSelection(file.getClassName()); gui.populatePackageDD(file.getClassName()); gui.populateClassDD(file.getPackageName()); gui.rePopulateTable(file); } } }