/// <summary> /// Save Settings /// </summary> /// <param name="settings"></param> /// <returns></returns> public static bool SaveSettings(Settings settings) { bool iSuccess = false; try { if (settings != null) { //Persist Data into Database //connectionString = GetAppPath(@"\Zoiperdb.sdf"); //GetPath(@"..\..\SqlData\Zoiperdb.sdf"); dbContext = new ZoiperdbContext(AuthenticateConnectionToDB()); ApplicationLog.WriteEventToLog("Path to ZoiperDB from SaveSettings: " + AuthenticateConnectionToDB()); TblZoiperSetting zoiperSetting = new TblZoiperSetting() { Domain = settings.Domain, Username = settings.Username, CallerId = settings.CallerId, ServiceDuration = settings.ServiceDuration, IsRestart = Convert.ToInt32(settings.Restart), Password = SharedFunctions.Hash(settings.Password) }; ApplicationLog.WriteEventToLog(string.Format("Domain: {0}, Username: {1}, CallerId: {2}, Duration: {3}, Restart: {4}, Password: {5}", zoiperSetting.Domain, zoiperSetting.Username, zoiperSetting.CallerId, zoiperSetting.ServiceDuration, zoiperSetting.IsRestart, zoiperSetting.Password)); dbContext.TblZoiperSetting.InsertOnSubmit(zoiperSetting); dbContext.SubmitChanges(); iSuccess = true; ApplicationLog.WriteEventToLog("Settings saved into ZoiperDB"); } } catch (Exception ex) { ApplicationLog.WriteErrorToLog(ex.ToString()); } return(iSuccess); }
/// <summary> /// /// </summary> private static string AuthenticateConnectionToDB() { connectionString = GetAppPath(@"\Zoiperdb.sdf"); ApplicationLog.WriteEventToLog("Path to Zoiper.sdf: " + connectionString); return(connectionString); // dbContext = new ZoiperdbContext(connectionString); }
/// <summary> /// Get contact by phone /// </summary> /// <param name="phoneNumber"></param> /// <returns>DbContact</returns> public static DbContact GetContactByPhone(string phoneNumber) { dbContext = new ZoiperdbContext(AuthenticateConnectionToDB()); ApplicationLog.WriteEventToLog("Path to ZoiperDB from GetContactByPhone: " + AuthenticateConnectionToDB()); DbContact contact = new DbContact(); try { TblPhoneContact tblContact = dbContext.TblPhoneContact.Where(x => x.Telephone == phoneNumber).FirstOrDefault(); contact = new DbContact(tblContact.ContactName, tblContact.Telephone, tblContact.Organization, tblContact.Url); //return contact; ApplicationLog.WriteEventToLog(string.Format("Name: {0}, Phone: {1}, Organization: {2}, Url: {3}", contact.FullName, contact.Phone, contact.Company, contact.Url)); } catch (Exception ex) { ApplicationLog.WriteEventToLog(ex.ToString()); //LibraryLog.WriteErrorLog(ex.Message); //return contact; } return(contact); }