/// <summary>
/// This method checks if database exists, and if not creates database and tables.
/// </summary>
/// <returns>Returns true if database was created or if database exists. Else false if not created</returns>
private bool CheckDatabase()
{
/*****************************************************************************
* CHECKDATABASE()
*****************************************************************************/
Crud db = new Crud("FamilyTree");
Crud dbMaster = new Crud("Master");
if (!dbMaster.DoesDataBaseExist(dbMaster))
{
if (dbMaster.CreateDatabase("FamilyTree"))
{
db.CreateTable(
"Persons",
"id INT PRIMARY KEY IDENTITY (1,1), " +
"firstName NVARCHAR(50), " +
"lastName NVARCHAR(50)," +
"birthDate DATE," +
"deathDate DATE," +
"birthPlace NVARCHAR(25)," +
"deathPlace NVARCHAR(25)," +
"motherId INT," +
"fatherId INT");
Console.WriteLine("\t\tDatabas skapades, Välkommen till första användningen av Family Tree");
Thread.Sleep(2500);
MockData mock = new MockData();
mock.ReadMockdataAndAddToDatabase();
return(true);
}
else
{
Console.WriteLine("\t\tNågot gick snett när databasen skapades.");
Thread.Sleep(1500);
return(false);
}
}
else
{
Console.WriteLine("\t\tVälkommen tillbaka");
Thread.Sleep(1500);
return(true);
}
}