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