public EAP_STATUS createNewStdDatabase(String aDataBaseName) { EAP_STATUS status = EAP_STATUS.OK; status = this.createNewEmptyDatabase(aDataBaseName); if (EAP_STATUS.OK == status) { //status = this.populateStdWPTypesTable(); cEAPWSProjectTypesTable projectTypesTable = new cEAPWSProjectTypesTable(m_DatabaseConnection); status = projectTypesTable.stdPopulateTable(); } if (EAP_STATUS.OK == status) { //status = this.populateStdCompetenceTypesTable(); cEAPWSCompetenceTypesTable competenceTypesTable = new cEAPWSCompetenceTypesTable(m_DatabaseConnection); status = competenceTypesTable.stdPopulateTable(); } if (EAP_STATUS.OK == status) { //status = this.populateStdEndTimeTables(); } return(status); }
public EAP_STATUS createNewEmptyDatabase(String aDataBaseName) { try { string connString = "Server=" + m_server + ";user="******";port=" + m_port + ";password="******"Connecting to MySQL..."); this.m_DatabaseConnection.Open(); //*** Drop database if it already exist MySqlCommand cmd = this.m_DatabaseConnection.CreateCommand(); cmd.CommandText = "DROP DATABASE IF EXISTS " + aDataBaseName; Console.WriteLine("Droping database " + aDataBaseName + "if it exist"); cmd.ExecuteNonQuery(); //*** Create New database if it not exist cmd.CommandText = "CREATE DATABASE IF NOT EXISTS " + aDataBaseName; Console.WriteLine("Creating database " + aDataBaseName + "if it not exist"); cmd.ExecuteNonQuery(); m_database = aDataBaseName; //*** Close connection to server Console.WriteLine("Closinng connection to SQL server"); m_DatabaseConnection.Close(); //*** Connect to the newly created database connString = "Server=" + m_server + ";database=" + m_database + ";user="******";port=" + m_port + ";password="******"Connecting to MySQL Database " + m_database); this.m_DatabaseConnection.Open(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } cEAPWSProjectTypesTable projectTypesTable = new cEAPWSProjectTypesTable(m_DatabaseConnection); projectTypesTable.createTable(); cEAPWSCompetenceTypesTable competenceTypesTable = new cEAPWSCompetenceTypesTable(m_DatabaseConnection); competenceTypesTable.createTable(); cEAPWSWPTable wpTable = new cEAPWSWPTable(m_DatabaseConnection); wpTable.createTable(); cEAPWSEstTimePeriodTable estTimePeriodTable = new cEAPWSEstTimePeriodTable(m_DatabaseConnection); estTimePeriodTable.createTable(); cEAPWSJobsTable jobsTable = new cEAPWSJobsTable(m_DatabaseConnection); jobsTable.createTable(); cEAPWSEstTimesTable estTimesTable = new cEAPWSEstTimesTable(m_DatabaseConnection); estTimesTable.createTable(); cEAPWSCalenderTable calenderTable = new cEAPWSCalenderTable(m_DatabaseConnection); calenderTable.createTable(); cEAPWSCalenderItemTable calenderItemTable = new cEAPWSCalenderItemTable(m_DatabaseConnection); calenderItemTable.createTable(); cEAPWSNewestEstView newestEstView = new cEAPWSNewestEstView(m_DatabaseConnection); newestEstView.createView(); cEAPWSJobEstView jobEstView = new cEAPWSJobEstView(m_DatabaseConnection); jobEstView.createView(); cEAPWSWPJobEstView wpJobEstView = new cEAPWSWPJobEstView(m_DatabaseConnection); wpJobEstView.createView(); cEAPWSNewestWPJobEstView newestWPJobEstView = new cEAPWSNewestWPJobEstView(m_DatabaseConnection); newestWPJobEstView.createView(); cEAPWSCalenderedNewestWPJobEstView caledNewestWPJobEstView = new cEAPWSCalenderedNewestWPJobEstView(m_DatabaseConnection); caledNewestWPJobEstView.createView(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } return(EAP_STATUS.OK); }