public AccountTypeDB GetAccountTypeByHostType(HostType hostType)
 {
     DBManager db = new DBManager();
     string accountTypeName = AccountTypeDB.FromTypeCodeToString(hostType);
     var accountType = db.GetAccountTypeByName(accountTypeName);
     return accountType;
 }

 public int DeleteAccountList(List<int> IdList)
 {
     DBManager db = new DBManager();
     foreach(int id in IdList)
     {
         db.DeleteAccountById(id);
     }
     return 1;
 }

        // Account

        public AccountD GetOrAddAccountByAccountText(string accountText, HostType hostType)
        {
            DBManager db = new DBManager();
            string accountTypeName = AccountTypeDB.FromTypeCodeToString(hostType);
            AccountD account = db.GetAccountByUserNameAndAccountTypeName(accountText, accountTypeName);

            if(account == null) // add new
            {
                AccountType type = db.GetAccountTypeByName(accountTypeName);
                int accountID = db.AddNewAccount(accountText, "", type.Id);

                account = db.GetAccountById(accountID);             
            }
            account.HostType = hostType;
            return account;
        }

        public void SaveDatabaseParameters(int contactLimit, int groupLimit)
        {
            DBManager db = new DBManager();

            string saveData = "{";
            saveData += "'contact_limit':" + contactLimit + ",";
            saveData += "'group_limit':" + groupLimit;
            saveData += "}";
            SecurityManager secMng = new SecurityManager();
            saveData = secMng.EncryptText(saveData);

            db.SaveDatabaseParameters(saveData);


            ContactDB.MAX_CONTACT = contactLimit;
            GroupDB.MAX_GROUP = groupLimit;
        }

        // Account

        public AccountDB GetOrAddAccountByAccountText(string accountText)
        {
            DBManager db = new DBManager();
            HostType hostType = MyUtils.GetHostTypeFromAccount(accountText);
            string accountTypeName = AccountTypeDB.FromTypeCodeToString(hostType);
            AccountDB account = db.GetAccountByUserNameAndAccountTypeName(accountText, accountTypeName);

            if(account.Id <= 0) // add new
            {
                AccountTypeDB type = db.GetAccountTypeByName(accountTypeName);
                int accountID = db.AddNewAccount(accountText, "", type.Id);

                account = db.GetAccountById(accountID);
                account.HostType = hostType;
            }
            account.AccountTypeName = accountTypeName;
            return account;
        }

        public void LoadDatabaseParameters()
        {
            DBManager db = new DBManager();
            string text = db.LoadDatabaseParameters();
            if (!String.IsNullOrEmpty(text))
            {
                SecurityManager secMng = new SecurityManager();
                string json = secMng.DecryptText(text);

                if (!String.IsNullOrEmpty(json))
                {
                    JToken token = null;
                    try
                    {
                        token = JObject.Parse(json);
                    }
                    catch (Exception e)
                    {
                        return;
                    }
                    JToken temp = token.SelectToken("contact_limit");
                    string contact_limit = temp != null ? temp.ToString() : "";
                    temp = token.SelectToken("group_limit");
                    string group_limit = temp != null ? temp.ToString() : "";

                    int limitContact = 500;
                    Int32.TryParse(contact_limit, out limitContact);
                    limitContact = limitContact == 0 ? 500 : limitContact;

                    int limitGroup = 20;
                    Int32.TryParse(group_limit, out limitGroup);
                    limitGroup = limitGroup == 0 ? 20 : limitGroup;

                    ContactDB.MAX_CONTACT = limitContact;
                    GroupDB.MAX_GROUP = limitGroup;
                }
            }
        }

 public int AddNewAccount(string username, string password, int accountTypeId)
 {
     DBManager db = new DBManager();
     return db.AddNewAccount(username, password, accountTypeId);
 }

 public List<Account> GetAllAccounts()
 {
     DBManager db = new DBManager();
     return db.GetAllDisplayAccounts();
 }

 public List<string> GetAllUserNameOfAccounts()
 {
     DBManager db = new DBManager();
     return db.GetAllUserNameOfAccounts();
 }

 public bool SetPreferredHostNameOrder(HostContactNameOrder hostContactNameOrder)
 {
     DBManager db = new DBManager();
     return db.SetPreferredHostNameOrder(hostContactNameOrder);
 }

 public bool SetDefaultHostNameOrder(HostContactNameOrder hostContactNameOrder)
 {
     DBManager db = new DBManager();
     return db.SetDefaultHostNameOrder(hostContactNameOrder);
 }

        public void ImportContactsFromListContactDB(List<CMData.Contact> list)
        {
            // save/update database
            DBManager db = new DBManager();
            int res = db.AddOrUpdateContactsFromAccount(list, MultiDownloadController.Instance.accountTypeName, MultiDownloadController.Instance.mode);

            // notify UI
            if (res > 0)
            {
                NotifyDownloadStatus(DownloadStatus.DONE, string.Format(resourceLoader.GetString("import_num_contacts"), res));
            }
            else
            {
                NotifyDownloadStatus(DownloadStatus.DONE, resourceLoader.GetString("no_contact_import"));
            }
        }

 public bool SetPreferredListEmailType(EmailType emailType)
 {
     DBManager db = new DBManager();
     return db.SetPreferredListEmailType(emailType);
 }

 public void DownloadContacts(int account_type_id, string username, string password, AccountDownloadListener notify)
 {
     DBManager db = new DBManager();
     Account account = db.AddOrUpdateAccountByUserPassAccTypeId(username, password, account_type_id);
     if (account.Id > 0)
     {
         //DownloadContacts(account, notify);
     }
     else
     {
         notify.NotifyStatusByAccountId(-1, DownloadStatus.DATABASE_ERROR, ResourceStringLoader.GetString("database_error"));
     }
 }

        private bool IsMaximumContactExeed(List<ContactDB> list)
        {
            int moreContactCount = list.Count();
            DBManager db = new DBManager();
            currentContactNumber = db.GetTotalContactCount();

            if (currentContactNumber + moreContactCount > ContactDB.MAX_CONTACT)
            {
                DownloadControllerAndData controllerAndData = new DownloadControllerAndData
                {
                    Controller = this,
                    ListData = list
                };
                NotifyDownloadStatus(DownloadStatus.MAXIMUM_CONTACT_EXEED, controllerAndData);
                return true;
            }
            return false;
        }

 public List<FaxType> GetAllFaxTypeByAccountTypeName()
 {
     DBManager db = new DBManager();
     return db.GetAllFaxTypeByAccountTypeName();
 }

 public bool SetPreferredListFaxType(FaxType faxType)
 {
     DBManager db = new DBManager();
     return db.SetPreferredListFaxType(faxType);
 }

 // fax type
 public List<FaxTypeDB> GetAllFaxType()
 {
     DBManager db = new DBManager();
     return db.GetAllFaxType();
 }

 // fax
 public List<Fax> GetAllFaxByContactId(int contactId)
 {
     DBManager db = new DBManager();
     return db.GetAllFaxByContactId(contactId);
 }

 public bool SetAccountDefaultListEmailType(EmailType emailType)
 {
     DBManager db = new DBManager();
     return db.SetAccountDefaultListEmailType(emailType);
 }