public static bool UpdateSettings(string version, DateTime lastSync, int interval, string syncTime, bool isStartSync) { dbEcustomEntities _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true)); try { if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open(); var existing = _db.tblSettings.FirstOrDefault(p => p.Version == version); if(existing==null) { tblSetting setting = new tblSetting(); setting.Version = version; setting.LastSync = lastSync; setting.SyncInterval = interval; setting.SyncTime = syncTime; setting.IsStartingSync = isStartSync; _db.AddTotblSettings(setting); return _db.SaveChanges() > 0; } else { //existing.Version = version; existing.LastSync = lastSync; existing.SyncInterval = interval; existing.SyncTime = syncTime; existing.IsStartingSync = isStartSync; return _db.SaveChanges() > 0; } } catch(Exception e) { return false; } finally { _db.Connection.Close(); } return false; }