public static bool TestCompanyConnection( ) { try { String strTestQuery = "Select COUNT(*) From INFORMATION_SCHEMA.KEY_COLUMN_USAGE "; if (IsCompanySQLConnection == false) { strTestQuery = "Select COUNT(*) From sqlite_master "; } DbCommand cmd = CompanyDatabase.GetSqlStringCommand(strTestQuery); CompanyDatabase.ExecuteDataSet(cmd); return(true); } catch (Exception) { return(false); } }
public void InitializeDB() { using (CompanyDatabase languageContext = new CompanyDatabase()) { languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "EN", DESCRIPTION = "English", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "AR", DESCRIPTION = "Arabic", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "FR", DESCRIPTION = "French", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "DE", DESCRIPTION = "German", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "EL", DESCRIPTION = "Greek", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "HI", DESCRIPTION = "Hindi", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "IT", DESCRIPTION = "Italian", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "JA", DESCRIPTION = "Japanese", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "KO", DESCRIPTION = "Korean", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "ZH", DESCRIPTION = "Mandarin", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "PL", DESCRIPTION = "Polish", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "PT", DESCRIPTION = "Portuguese", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "RO", DESCRIPTION = "Romanian", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "RU", DESCRIPTION = "Russian", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "ES", DESCRIPTION = "Spanish", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "TR", DESCRIPTION = "Turkish", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.LANGUAGES.Add(new LANGUAGE() { LANGUAGEKEYID = "VI", DESCRIPTION = "Vietnamese", CREATEDBY = "Anoop", MODIFIEDBY = "Anoop", DateCreated = DateTime.Now, MODIFIEDON = DateTime.Now }); languageContext.SaveChanges(); } }