public bool load(int mode)
{
long port = new SettingsHelper(core, plugin_id).getInt("/settings/WEB/server", "port", 1234);
log.info("Webserver port is: " + port);
new RegistryHelper(core, plugin_id).registerCommand("check_dotnet", "This is a sample command written in C#");
return true;
}
public SettingsViewModel(IEventAggregator eventAggregator, SettingsHelper settingsHelper)
{
_eventAggregator = eventAggregator;
_settingsHelper = settingsHelper;
_alwaysAskDownloadLocation = settingsHelper.GetSetting<bool>(SettingType.AlwaysAskDownloadLocation);
_orderByQueue = settingsHelper.GetSetting<bool>(SettingType.OrderByQueue);
_showForceStart = settingsHelper.GetSetting<bool>(SettingType.ShowForceStart);
}
public MainPageViewModel(INavigationService navigationService, IEventAggregator eventAggregator,
SettingsHelper settingsHelper, SettingsViewModel settingsViewModel,
SettingsPaneViewModel settingsPaneViewModel, FilterListViewModel filterListViewModel,
ListFilterViewModel listFilterViewModel, TorrentWindowViewModel torrentWindowViewModel,
ErrorTracker errorTracker)
{
_errorTracker = errorTracker;
_uriQueue = new List<string>();
_torrentsQueue = new List<TorrentFileData>();
_settingsHelper = settingsHelper;
_eventAggregator = eventAggregator;
_navigationService = navigationService;
FilterList = filterListViewModel;
ListFilter = listFilterViewModel;
SettingsPane = settingsPaneViewModel;
Settings = settingsViewModel;
TorrentWindow = torrentWindowViewModel;
backingTorrents = new ObservableCollection<TorrentViewModel>();
Torrents = new ListCollectionView(backingTorrents);
SelectedItems = new ObservableCollection<TorrentViewModel>();
ChangeOrder(settingsHelper.GetSetting<bool>(SettingType.OrderByQueue));
Torrents.Filter = ListFilter.GetFilter(Filter.All);
ClearCommand = new DelegateCommand(() => ClearSelection());
SelectAllCommand = new DelegateCommand(() => SelectAll());
ForceStartCommand = new DelegateCommand(() => ChangeTorrentState(StateType.ForceStart));
PauseCommand = new DelegateCommand(() => ChangeTorrentState(StateType.Stop));
StartCommand = new DelegateCommand(() => ChangeTorrentState(StateType.Start));
VerifyCommand = new DelegateCommand(() => ChangeTorrentState(StateType.Verify));
ShowAddTorrentCommand = new DelegateCommand(() => TorrentWindow.Open(Purpose.Add, Server.DefaultDownloadLocation));
ShowMoveTorrentsCommand = new DelegateCommand(() => TorrentWindow.Open(Purpose.Move, Server.DefaultDownloadLocation, SelectedItems));
ShowConfirmDeleteCommand = new DelegateCommand(() => TorrentWindow.Open(Purpose.Delete, Server.DefaultDownloadLocation, SelectedItems));
_eventAggregator.GetEvent<AddTorrent>().Subscribe(AddTorrents);
_eventAggregator.GetEvent<DeleteTorrents>().Subscribe(Delete);
_eventAggregator.GetEvent<MoveTorrents>().Subscribe(MoveTorrents);
_eventAggregator.GetEvent<SearchChanged>().Subscribe(query => Torrents.Refresh());
_eventAggregator.GetEvent<SearchCleared>().Subscribe(_ => Torrents.Refresh());
_eventAggregator.GetEvent<PriorityChanged>().Subscribe(PriorityChanged);
_eventAggregator.GetEvent<WantedChanged>().Subscribe(WantedChanged);
_eventAggregator.GetEvent<FilterChanged>().Subscribe(FilterChanged);
_eventAggregator.GetEvent<OrderByQueueSettingChanged>().Subscribe(orderByQueue => ChangeOrder(orderByQueue));
_eventAggregator.GetEvent<FileActivated>().Subscribe(FileActivated);
_eventAggregator.GetEvent<URIActivated>().Subscribe(URIActivated);
_eventAggregator.GetEvent<ServerLoaded>().Subscribe(ProcessQueues);
SelectedItems.CollectionChanged += (s, e) =>
{
SelectionChange();
};
}
private async Task<bool> SendMessage(string title, string body) {
var setting = new SettingsHelper();
var pairedBands = await BandClientManager.Instance.GetBandsAsync();
using (var bandClient = await BandClientManager.Instance.ConnectAsync(pairedBands[0])) {
await bandClient.NotificationManager.ShowDialogAsync(setting.GetSetting<Guid>(SETTINGS.TILE_ID), title, body);
}
return true;
}
public worklistCommand()
{
SettingsHelper settingHelper = new SettingsHelper();
log.Info("load settings");
settingHelper.LoadSettings(ref pipettingSetting, ref labwareSettings);
string errMsg = "";
bool bok = settingHelper.IsValidSetting(labwareSettings, pipettingSetting, ref errMsg);
if (!bok)
{
throw new Exception("Invalid setting:" + errMsg);
}
}
public TorrentWindowViewModel(IEventAggregator eventAggregator, SettingsHelper settingsHelper)
{
_settingsHelper = settingsHelper;
_eventAggregator = eventAggregator;
SubmitCommand = new DelegateCommand(Submit);
CancelCommand = new DelegateCommand(Clear);
BrowseCommand = new DelegateCommand(BrowseForFiles);
AddByURLCommand = new DelegateCommand(AddByURL);
ToggleFavouriteLocationsCommand = new DelegateCommand(() => ShowFavouriteLocations = !ShowFavouriteLocations);
Torrents = new ObservableCollection<TorrentSimpleViewModel>();
_torrentCache = new Dictionary<string, string>();
FavouriteLocations = new ObservableCollection<string>();
Torrents.CollectionChanged += (s, e) => OnPropertyChanged(nameof(TorrentsQueued));
eventAggregator.GetEvent<UseDefaultDownloadSettingChanged>().Subscribe(x => UseDefaultLocation = x);
}
public TestModule()
{
Get["/Test"] = _ =>
{
return(View["Test"]);
};
Post["/Test"] = _ =>
{
//- Get Data
RequestHead head = new RequestHead();
head.Command = Request.Form["command"];
head.Version = Request.Form["version"];
head.System = Request.Form["system"];
head.Channel = Request.Form["channel"];
head.UserId = Request.Form["userid"];
head.UseCache = Request.Form["usecache"];
head.SerialNumber = Guid.NewGuid().ToString();
head.RequestHost = "127.0.0.1";
head.RequestTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string headData = JsonConvert.SerializeObject(head);
headData = EncodingHelper.Base64UrlEncode(Encoding.UTF8.GetBytes(headData));
string bodyData = Request.Form["body"];
bodyData = EncodingHelper.Base64UrlEncode(Encoding.UTF8.GetBytes(bodyData));
string encryptBody = EncryptHelper.DESEncrypt(bodyData, SettingsHelper.GetDesKey(head.Channel));
string url = Request.Url.SiteBase + "/Api";
//- Post
RestClient client = new RestClient(url);
client.Proxy = null;
client.Timeout = 60000;
RestRequest request = new RestRequest(Method.POST);
request.AddHeader("head", headData);
request.AddParameter("body", encryptBody);
string result = client.Execute(request).Content;
return(result);
};
}
private void StorageTextBox_LostFocus(object sender, RoutedEventArgs e)
{
var thisTexBox = sender as TextBox;
string Path = thisTexBox.Text;
if (Path == null)
{
thisTexBox.Text = Data.SettingsData.StoragePath;
return;
}
if (!PathCheck(Path))
{
if (!(FileHelper.CreateFolder(Path)))
{
thisTexBox.Text = Data.SettingsData.StoragePath;
MainWindow.Snackbar.MessageQueue.Enqueue(LocalizedHelper.GetLocalizedString("Failed_To_Create_New_Folder", "SettingsStr"));
return;
}
MainWindow.Snackbar.MessageQueue.Enqueue(LocalizedHelper.GetLocalizedString("Folder_Created", "SettingsStr"));
}
try
{
FileHelper.MV_Folder(Data.SettingsData.StoragePath + Data.ID.Dir_Storage, Path + Data.ID.Dir_Storage);
}
catch
{
StoragePath.Text = Data.SettingsData.StoragePath;
Failed();
return;
}
if (!SettingsHelper.ModifySettings(thisTexBox.Name, thisTexBox.Text))
{
thisTexBox.Text = Data.SettingsData.StoragePath;
Failed();
return;
}
Succeed();
}
public static async void SetThemeColor(string albumartPath)
{
await BreadDispatcher.InvokeAsync(async() =>
{
if (SharedLogic.SettingsVm.ChangeAccentByAlbumArt == false || albumartPath == null)
{
ChangeColor(GetAccentColor());
return;
}
if (SettingsHelper.GetLocalSetting <string>("SelectedTheme", "Light") == "Light" && SharedLogic.SettingsVm.ChangeAccentByAlbumArt)
{
try
{
Color color;
if (!string.IsNullOrEmpty(albumartPath) && albumartPath != "default")
{
color = await SharedLogic.GetDominantColor(await StorageFile.GetFileFromPathAsync(albumartPath));
}
else if (albumartPath == "default" && SharedLogic.Player.CurrentlyPlayingFile != null)
{
color = await SharedLogic.GetDominantColor(await StorageFile.GetFileFromPathAsync(SharedLogic.Player.CurrentlyPlayingFile.AttachedPicture));
}
else
{
color = GetAccentColor();
}
ChangeColor(color);
}
catch (Exception ex)
{
BLogger.Logger.Error("Failed to update accent.", ex);
await SharedLogic.NotificationManager.ShowMessageAsync(ex.Message);
}
//ThemeChanged?.Invoke(null, new Events.ThemeChangedEventArgs(oldColor, color));
}
else
{
ChangeColor(GetAccentColor());
}
});
}
private void UpdateSettings()
{
SettingsHelper.SetSetting("MacAddress", macAddress.Text);
var devices = CaptureDeviceList.Instance;
devices[adapters.SelectedIndex].Open();
SettingsHelper.SetSetting("NetworkDevice", devices[adapters.SelectedIndex].MacAddress.ToString());
devices[adapters.SelectedIndex].Close();
var macAddr = SettingsHelper.GetSetting("MacAddress");
var networkDevice = SettingsHelper.GetSetting("NetworkDevice");
var pcapService = Locator.Current.GetService <IPcapService>();
pcapService.Stop();
pcapService.Start(macAddr, networkDevice);
Hide();
}
private void settingsDialogAction_Execute(object sender, EventArgs e)
{
var old = KeyboardHook.Enabled;
KeyboardHook.Enabled = false;
try
{
if (!SettingsHelper.ShowSettingsDialog(this, onlineManager.settings))
{
return;
}
ApplySettingsImmediately();
onlineManager.settings.SaveToFile();
}
finally
{
KeyboardHook.Enabled = old;
}
}
public void Run(IBackgroundTaskInstance taskInstance)
{
BackgroundTaskDeferral deferral = taskInstance.GetDeferral();
Template10.Services.SettingsService.ISettingsHelper _helper = new SettingsHelper();
var details = taskInstance.TriggerDetails as ToastNotificationActionTriggerDetail;
var arguments = details?.Argument;
if (arguments != null)
{
var args = JsonConvert.DeserializeObject <ToastNotificationArgs>(arguments);
if (args.Type == ToastType.Sleep)
{
_helper.Write("ToastNotifications", false);
}
}
deferral.Complete();
}
public void SetSettings(XmlNode node)
{
var element = (XmlElement)node;
TextColor = SettingsHelper.ParseColor(element["TextColor"]);
OverrideTextColor = SettingsHelper.ParseBool(element["OverrideTextColor"]);
TimeColor = SettingsHelper.ParseColor(element["TimeColor"]);
OverrideTimeColor = SettingsHelper.ParseBool(element["OverrideTimeColor"]);
BackgroundColor = SettingsHelper.ParseColor(element["BackgroundColor"]);
BackgroundColor2 = SettingsHelper.ParseColor(element["BackgroundColor2"]);
GradientString = SettingsHelper.ParseString(element["BackgroundGradient"]);
Text1 = SettingsHelper.ParseString(element["Text1"]);
GoalTime = TimeSpanParser.Parse(SettingsHelper.ParseString(element["GoalTime"]));
ShowBest = SettingsHelper.ParseBool(element["ShowBest"]);
Font1 = SettingsHelper.GetFontFromElement(element["Font1"]);
Font2 = SettingsHelper.GetFontFromElement(element["Font2"]);
OverrideFont1 = SettingsHelper.ParseBool(element["OverrideFont1"]);
OverrideFont2 = SettingsHelper.ParseBool(element["OverrideFont2"]);
Display2Rows = SettingsHelper.ParseBool(element["Display2Rows"], false);
}
public XmlNode GetSettings(XmlDocument document)
{
var parent = document.CreateElement("Settings");
SettingsHelper.CreateSetting(document, parent, "useAchievementColor", useAchievementColor);
SettingsHelper.CreateSetting(document, parent, "doColorValues", doColorValues);
SettingsHelper.CreateSetting(document, parent, "doColorLabels", doColorLabels);
SettingsHelper.CreateSetting(document, parent, "inProgressColor", inProgressColor);
SettingsHelper.CreateSetting(document, parent, "failedColor", failedColor);
SettingsHelper.CreateSetting(document, parent, "completedColor", completedColor);
SettingsHelper.CreateSetting(document, parent, "valueColorOverride", valueColorOverride);
SettingsHelper.CreateSetting(document, parent, "valueOutlineColor", valueOutlineColor);
SettingsHelper.CreateSetting(document, parent, "valueShadowColor", valueShadowColor);
SettingsHelper.CreateSetting(document, parent, "valueTextColor", valueTextColor);
SettingsHelper.CreateSetting(document, parent, "labelColorOverride", labelColorOverride);
SettingsHelper.CreateSetting(document, parent, "labelOutlineColor", labelOutlineColor);
SettingsHelper.CreateSetting(document, parent, "labelShadowColor", labelShadowColor);
SettingsHelper.CreateSetting(document, parent, "labelTextColor", labelTextColor);
return(parent);
}
private void DrawLeftExpandedSettingsColumn(Rect canvas, [NotNull] TableItem <EventItem> ev)
{
(Rect capLabel, Rect capField) = new Rect(0f, 0f, canvas.width, RowLineHeight).Split(0.6f);
UiHelper.Label(capLabel, _eventCapText);
int capProxy = ev.Data.EventCap;
var capBuffer = capProxy.ToString();
if (SettingsHelper.DrawNumberField(capField, ref capProxy, ref capBuffer, out int newCap, 1f, 200f))
{
ev.Data.EventCap = newCap;
}
(Rect karmaLabel, Rect karmaField) = new Rect(0f, RowLineHeight, canvas.width, RowLineHeight).Split(0.6f);
UiHelper.Label(karmaLabel, _karmaTypeText);
if (Widgets.ButtonText(karmaField, ev.Data.KarmaType.ToString()))
{
Find.WindowStack.Add(new FloatMenu(ToolkitUtils.Data.KarmaTypes.Values.Select(i => new FloatMenuOption(i.ToString(), () => ev.Data.KarmaType = i)).ToList()));
}
}
public void SetSettings(XmlNode node)
{
var element = (XmlElement)node;
TextColor = SettingsHelper.ParseColor(element["TextColor"]);
OverrideTextColor = SettingsHelper.ParseBool(element["OverrideTextColor"]);
TimeColor = SettingsHelper.ParseColor(element["TimeColor"]);
OverrideTimeColor = SettingsHelper.ParseBool(element["OverrideTimeColor"]);
BackgroundColor = SettingsHelper.ParseColor(element["BackgroundColor"]);
BackgroundColor2 = SettingsHelper.ParseColor(element["BackgroundColor2"]);
GradientString = SettingsHelper.ParseString(element["BackgroundGradient"]);
Text1 = SettingsHelper.ParseString(element["Text1"]);
Text2 = SettingsHelper.ParseString(element["Text2"]);
fileLocation = SettingsHelper.ParseString(element["fileLocation"]);
Font1 = SettingsHelper.GetFontFromElement(element["Font1"]);
Font2 = SettingsHelper.GetFontFromElement(element["Font2"]);
OverrideFont1 = SettingsHelper.ParseBool(element["OverrideFont1"]);
OverrideFont2 = SettingsHelper.ParseBool(element["OverrideFont2"]);
Display2Rows = SettingsHelper.ParseBool(element["Display2Rows"], false);
}
/// <summary>
/// Runs the server.
/// </summary>
public void RunServer()
{
MailListener listener = null;
do
{
System.Reflection.Assembly assembly = System.Reflection.Assembly.GetExecutingAssembly();
Version version = assembly.GetName().Version;
Console.Title = assembly.GetName().Name + " v" + version.ToString(3);
Console.WriteLine("New MailListener started");
listener = new MailListener(this, IPAddress.Loopback, SettingsHelper.GetIntOrDefault("ServerPort", 25));
listener.OutputToFile = true;
listener.Start();
while (listener.IsThreadAlive)
{
Thread.Sleep(500);
}
} while (listener != null);
}
private bool SetupDevice(JObject settings)
{
var devices = SettingsHelper.Read(SettingsType.Devices);
var serializer = JsonSerializer.Create(new JsonSerializerSettings()
{
ContractResolver = new DefaultContractResolver()
});
var dirty = false;
if (!settings.TryGetValue <string>("SelectedDevice", serializer, out var selectedDevice) || selectedDevice == null)
{
selectedDevice = devices.Properties().First().Name;
settings["SelectedDevice"] = selectedDevice;
dirty = true;
}
DeviceAxis.LoadSettings(devices[selectedDevice] as JObject, serializer);
return(dirty);
}
public static void AddDevices()
{
if (SettingsHelper.SettingsFileExists(GenericDeviceCollection.equipmentSettingsFileName))
{
Pumps.ReadAllGadgetsFromFile();
Lighting.ReadAllGadgetsFromFile();
Heater.ReadAllGadgetsFromFile();
}
else
{
Logger.Add("Device settings file did not exist, created new device settings");
var jo = new JObject();
jo.Add(new JProperty(Pumps.gadgetSettingsArrayName, new JArray()));
jo.Add(new JProperty(Lighting.gadgetSettingsArrayName, new JArray()));
jo.Add(new JProperty(Heater.gadgetSettingsArrayName, new JArray()));
SettingsHelper.WriteSettingsFile(GenericDeviceCollection.equipmentSettingsFileName, jo);
}
}
private string ProcessSegment(RouteValueDictionary routeValues, string path, string key)
{
SeoUrlKeywordTypes type;
if (routeValues.ContainsKey(key) &&
routeValues[key] as string != null && Enum.TryParse(key, true, out type))
{
var value = routeValues[key].ToString();
var lang = routeValues.ContainsKey(Routing.Constants.Language) ? routeValues[Routing.Constants.Language] as string : null;
var valueEncoded = SettingsHelper.SeoEncode(value, type, lang).ToLowerInvariant();
//If encoded and used value does not match (keyword exist) and requested path contains not encoded value replace with encoded
if (!value.Equals(valueEncoded, StringComparison.InvariantCultureIgnoreCase) && path.ToLowerInvariant().Contains(value.ToLowerInvariant()))
{
path = path.Replace(value, valueEncoded);
}
}
return(path);
}
/// <summary>
/// Process the form closing
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmGenerator_FormClosing(object sender, FormClosingEventArgs e)
{
// Saves the current settings
SettingsHelper settings = new SettingsHelper();
settings.SiteURL = tbURL.Text;
settings.SourceType = getSourceType();
settings.UTMSource = tbUTMSource.Text;
settings.UTMMedium = tbUTMMedium.Text;
settings.UTMCampaign = tbUTMCampaign.Text;
settings.UTMContent = tbUTMContent.Text;
settings.UTMTerm = tbUTMTerm.Text;
settings.UTMAdditional = tbUTMAdditional.Text;
settings.Transliteration = cbTransliteration.Checked;
settings.SlashPlace = cbSlashPlace.Checked;
settings.SaveSettings();
}
public MainPage()
{
this.InitializeComponent();
Current = this;
baseListRing.IsActive = true;
PrepareFrame.Navigate(typeof(PreparePage));
var isDarkOrNot = (bool?)SettingsHelper.ReadSettingsValue(SettingsConstants.IsDarkThemeOrNot) ?? true;
RequestedTheme = isDarkOrNot ? ElementTheme.Dark : ElementTheme.Light;
NavigateManager.BackRequested += OnBackRequested;
MainContentFrame = this.ContentFrame;
BaseListRing = this.baseListRing;
NavigateTitlePath = this.navigateTitlePath;
ChangeTitlePath(NaviPathTitle.RoutePath);
StatusBarInit.InitInnerDesktopStatusBar(true);
Window.Current.SetTitleBar(BasePartBorder);
IfNeedAdapteVitualNavigationBar();
InitSlideRecState();
GetResources();
}
protected override async Task <SyntaxNode> FixAllInDocumentAsync(FixAllContext fixAllContext, Document document, ImmutableArray <Diagnostic> diagnostics)
{
if (diagnostics.IsEmpty)
{
return(null);
}
SyntaxNode syntaxRoot = await document.GetSyntaxRootAsync().ConfigureAwait(false);
var tokens = diagnostics
.Select(diagnostic => syntaxRoot.FindToken(diagnostic.Location.SourceSpan.Start))
.OrderBy(token => token.SpanStart)
.ToImmutableArray();
var settings = SettingsHelper.GetStyleCopSettings(document.Project.AnalyzerOptions, fixAllContext.CancellationToken);
var tokenReplacements = GenerateBraceFixes(settings.Indentation, tokens);
return(syntaxRoot.ReplaceTokens(tokenReplacements.Keys, (originalToken, rewrittenToken) => tokenReplacements[originalToken]));
}
/// <summary>
/// Creates the job from the queue by index
/// </summary>
/// <param name="id">Index of the jobinfo in the queue</param>
/// <returns>The corresponding ComJob</returns>
private PrintJob JobById(int id)
{
try
{
IJobInfo currentJobInfo = _comJobInfoQueue.JobInfos[id];
var jobTranslations = new JobTranslations();
jobTranslations.EmailSignature = MailSignatureHelper.ComposeMailSignature();
IJob currentJob = new GhostscriptJob(currentJobInfo, SettingsHelper.GetDefaultProfile(), JobInfoQueue.Instance, jobTranslations);
COMLogger.Trace("COM: Creating the ComJob from the queue determined by the index.");
var indexedJob = new PrintJob(currentJob, _comJobInfoQueue);
return(indexedJob);
}
catch (ArgumentOutOfRangeException)
{
throw new COMException("Invalid index. Please check the index parameter.");
}
}
public UnicornControlPanelViewModel(Dispatcher dispatcher)
{
_dispatcher = dispatcher;
_configurations = new ObservableCollection <string>(new[] { DefaultConfiguration });
LoadConnections();
_statusReports = new ObservableCollection <StatusReport>();
StatusReports = CollectionViewSource.GetDefaultView(_statusReports);
StatusReports.Filter = FilterReports;
CreateNewConnection = new Command(ExecuteCreateNewConnection);
RemoveSelectedConnection = new Command(ExecuteRemoveSelectedConnection);
EditSelectedConnection = new Command <string>(ExecuteEditSelectedConnection);
ShowSettings = new Command(ExecuteShowSettings);
CancelCurrentJob = new Command(ExecuteCancelCurrentJob);
Synchronize = new Command(ExecuteSynchronize);
Reserialize = new Command(ExecuteReserialize);
ClearSearch = new Command(ExecuteClearSearch);
SelectedConnectionIndex = 0;
CheckForConfigurationHealth = SettingsHelper.GetSettings().CheckForConfigurationHealth;
}
private static async Task <Document> GetTransformedDocumentAsync(Document document, Diagnostic diagnostic, CancellationToken cancellationToken)
{
var syntaxRoot = await document.GetSyntaxRootAsync(cancellationToken).ConfigureAwait(false);
var settings = SettingsHelper.GetStyleCopSettings(document.Project.AnalyzerOptions, syntaxRoot.SyntaxTree, cancellationToken);
if (!(syntaxRoot.FindNode(diagnostic.Location.SourceSpan, getInnermostNodeForTie: true) is StatementSyntax statement))
{
return(document);
}
var tokenReplaceMap = new Dictionary <SyntaxToken, SyntaxToken>();
ReformatStatementAndSurroundings(statement, settings.Indentation, tokenReplaceMap);
var newSyntaxRoot = syntaxRoot.ReplaceTokens(tokenReplaceMap.Keys, (original, rewritten) => tokenReplaceMap[original]);
var newDocument = document.WithSyntaxRoot(newSyntaxRoot.WithoutFormatting());
return(newDocument);
}
public void VerifySettingsDefaults()
{
var styleCopSettings = SettingsHelper.GetStyleCopSettings(default(SyntaxTreeAnalysisContext), CancellationToken.None);
Assert.Equal("PlaceholderCompany", styleCopSettings.DocumentationRules.CompanyName);
Assert.Equal("Copyright (c) PlaceholderCompany. All rights reserved.", styleCopSettings.DocumentationRules.GetCopyrightText("unused"));
Assert.True(styleCopSettings.NamingRules.AllowCommonHungarianPrefixes);
Assert.Empty(styleCopSettings.NamingRules.AllowedHungarianPrefixes);
Assert.NotNull(styleCopSettings.OrderingRules);
Assert.Equal(UsingDirectivesPlacement.InsideNamespace, styleCopSettings.OrderingRules.UsingDirectivesPlacement);
Assert.Equal(OptionSetting.Allow, styleCopSettings.OrderingRules.BlankLinesBetweenUsingGroups);
Assert.NotNull(styleCopSettings.LayoutRules);
Assert.Equal(OptionSetting.Allow, styleCopSettings.LayoutRules.NewlineAtEndOfFile);
Assert.NotNull(styleCopSettings.SpacingRules);
Assert.NotNull(styleCopSettings.ReadabilityRules);
Assert.NotNull(styleCopSettings.MaintainabilityRules);
}
private void Init()
{
Settings settings = SettingsHelper.GetSettings();
weather = new Weather(
ApplicationConstants.WEATHER_API_KEY,
ApplicationConstants.DEFAULT_COUNTRY,
ApplicationConstants.DEFAULT_CITY,
UnitsType.METRIC);
WeatherControl = new WeatherControl(weather, settings.WeatherRefreshRate);
this.Controls.Add(WeatherControl);
pnlTop.BackColor = WeatherControl.BackColor;
this.Size = new Size(WeatherControl.Width, WeatherControl.Height);
SetLocation(settings.WeatherStartScreen, settings.WeatherLocation);
this.StartPosition = FormStartPosition.Manual;
this.TopMost = settings.IsWeatherAlwaysTop;
}
public void SaveSettings(string folder, RecordingFileFormat format)
{
try
{
var setting_container = SimpleIOCContainer.Instance.Resolve <IGenericSettingsRepository <ProgramSettings> >();
var settings = setting_container.GetSettings();
settings.RecordingPath = folder;
settings.RecordingFileFormat = format;
SettingsHelper.SaveOptions(settings);
if (!Directory.Exists(settings.RecordingPath))
{
Directory.CreateDirectory(settings.RecordingPath);
}
}
catch (Exception ex)
{
view.ShowError(ex);
}
}
public static bool Prefix(Clan clan, ref KingdomDecision?__result, KingdomDecisionProposalBehavior __instance) //Bool prefixes compete with each other and skip others, as well as original, if return false
{
try
{
bool SubSystemEnabled = SettingsHelper.SubSystemEnabled(SubSystemType.ElectionCooldowns, clan);
bool SystemDebugEnabled = SettingsHelper.SystemDebugEnabled(AOSystems.PoliticsRebalance, DebugType.General, clan);
if (!SubSystemEnabled && !SystemDebugEnabled)
{
return(true);
}
Kingdom kingdom = clan.Kingdom;
__result = null;
if (kingdom.UnresolvedDecisions.FirstOrDefault(x => x is MakePeaceKingdomDecision) == null)
{
Kingdom randomElement = Kingdom.All.Where(x => x.IsAtWarWith(kingdom) &&
x != Clan.PlayerClan.Kingdom &&
!(SubSystemEnabled && AOCooldownManager.HasDecisionCooldown(new MakePeaceKingdomDecision(clan, x, applyResults: false)))
).ToArray().GetRandomElement();
if (randomElement != null && deConsiderPeace !(__instance, clan, randomElement.RulingClan, kingdom, randomElement, out MakePeaceKingdomDecision decision))
{
__result = decision;
}
if (SystemDebugEnabled)
{
PoliticsDebugHelper.PrepareConsiderationDebugMessage(ConsiderationType.MakingPeace, clan, randomElement, __result, out TextObject debugLogMessage);
MessageHelper.SimpleMessage(debugLogMessage);
}
}
return(false);
}
catch (Exception ex)
{
MethodInfo?methodInfo = MethodBase.GetCurrentMethod() as MethodInfo;
DebugHelper.HandleException(ex, methodInfo, "Harmony patch for KingdomDecisionProposalBehavior. GetRandomPeaceDecision");
return(true);
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
string theme = SettingsHelper.GetTheme(this);
if (theme == "dark")
{
SetTheme(Resource.Style.Dark_Theme);
}
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.invoice_activity);
btnClose = FindViewById <Button>(Resource.Id.btnClose);
tvName = FindViewById <TextView>(Resource.Id.tvName);
tvService = FindViewById <TextView>(Resource.Id.tvService);
tvDurationArrival = FindViewById <TextView>(Resource.Id.tvDurationArrival);
tvDurationService = FindViewById <TextView>(Resource.Id.tvDurationService);
tvDate = FindViewById <TextView>(Resource.Id.tvDate);
tvAmount = FindViewById <TextView>(Resource.Id.tvAmount);
RequestVM request = JsonConvert.DeserializeObject <RequestVM>(Intent.GetStringExtra("request"));
tvName.Text = request.CustomerName;
tvDate.Text = DateTime.Today.ToString("dd MMM, yyyy");
tvService.Text = request.HealthServiceName;
tvAmount.Text = request.Price.ToString("#,###");
TimeSpan?arrivalDuration = request.StartedTime - request.AssignedTime;
TimeSpan?treatmentDuration = request.CompletedTime - request.StartedTime;
tvDurationArrival.Text = $"{arrivalDuration.Value.Hours.ToString("00")}:{arrivalDuration.Value.Minutes.ToString("00")}:{arrivalDuration.Value.Seconds.ToString("00")}";
tvDurationService.Text = $"{treatmentDuration.Value.Hours.ToString("00")}:{treatmentDuration.Value.Minutes.ToString("00")}:{treatmentDuration.Value.Seconds.ToString("00")}";
btnClose.Click += ((sender, e) =>
{
Intent intent = new Intent(this, typeof(MainActivity));
intent.AddFlags(ActivityFlags.ClearTop);
StartActivity(intent);
});
}
protected override bool IsMatch(HttpContextBase httpContext, Route route, string parameterName, RouteValueDictionary values, RouteDirection routeDirection)
{
if (routeDirection == RouteDirection.UrlGeneration)
{
return(true);
}
if (!base.IsMatch(httpContext, route, parameterName, values, routeDirection))
{
return(false);
}
var encoded = values[parameterName].ToString();
var decoded = SettingsHelper.SeoDecode(encoded, SeoUrlKeywordTypes.Store, values.ContainsKey(Constants.Language) ? values[Constants.Language] as string : null);
var dbStore = StoreClient.GetStoreById(decoded);
if (dbStore == null)
{
return(false);
}
if (values.ContainsKey(Constants.Language))
{
try
{
var culture = values[Constants.Language].ToString().ToSpecificLangCode();
if (!dbStore.Languages.Any(l => l.LanguageCode.ToSpecificLangCode().Equals(culture, StringComparison.InvariantCultureIgnoreCase)))
{
//Store does not support this language
return(false);
}
}
catch
{
//Language is not valid
return(false);
}
}
return(true);
}
/// <summary>
/// 获取请求信息
/// </summary>
private CustomRouteData GetRequestData(Request request)
{
//- Head
var head = request.Headers["head"].FirstOrDefault();
if (head == null)
{
throw new Exception("请求报文头数据不存在或格式不正确");
}
head = Encoding.UTF8.GetString(EncodingHelper.Base64UrlDecode(head));
HeadData = JsonConvert.DeserializeObject <RequestHead>(head);
if (HeadData == null)
{
throw new Exception("请求报文头数据不存在");
}
if (string.IsNullOrEmpty(HeadData.Command))
{
throw new Exception("请求报文头指令名称不能为空");
}
//- Body
var bodyForm = request.Form["body"];
if (!string.IsNullOrWhiteSpace(bodyForm))
{
string key = SettingsHelper.GetDesKey(HeadData.Channel);
bodyForm = EncryptHelper.DESDecrypt(bodyForm, key);
string bodyStr = Encoding.UTF8.GetString(EncodingHelper.Base64UrlDecode(bodyForm));
BodyData = JsonConvert.DeserializeObject <Dictionary <string, object> >(bodyStr);
}
//- Route
CustomRouteData route = RouteHelper.GetOptimalRoute(HeadData.Command, HeadData.Version, HeadData.System);
if (route == null)
{
throw new Exception("请求路由不存在");
}
route = RouteHelper.RoutingLoadBalance(route);
return(route);
}
/// <summary>
/// Set connection string into web.config.
/// </summary>
private void SetConnectionString()
{
if (!SystemContext.IsRunningOnAzure)
{
if (!SettingsHelper.RemoveConnectionString(DatabaseSeparationHelper.ConnStringSeparateName))
{
separationFinished.ErrorLabel.Visible = true;
string resultStringDisplay = " <br/><br/><strong><add name=\"" + DatabaseSeparationHelper.ConnStringSeparateName + "\" connectionString=\"" + DatabaseSeparationHelper.ConnStringSeparate + "\"/></strong><br/><br/>";
separationFinished.ErrorLabel.Text = GetString("separationDB.removeConnectionStringError") + resultStringDisplay;
}
}
else
{
string connString = "<add name=\"" + DatabaseSeparationHelper.ConnStringSeparateName + "\" connectionString=\"" + DatabaseSeparationHelper.ConnStringSeparate + "\"/>";
string appSetting = "<Setting name=\"" + DatabaseSeparationHelper.ConnStringSeparateName + "\" value=\"" + DatabaseSeparationHelper.ConnStringSeparate + "\"/>";
separationFinished.AzureErrorLabel.Visible = true;
separationFinished.AzureErrorLabel.Text = String.Format(ResHelper.GetString("separationDB.removeConnectionStringErrorAzure"), connString, appSetting);
}
bool dbEngineSupportsOpenqueryCommand = !DatabaseSeparationHelper.IsUsingAzureDatabase;
if (!dbEngineSupportsOpenqueryCommand)
{
separationFinished.AzureErrorLabel.Visible = true;
separationFinished.AzureErrorLabel.Text += GetManualCopyText();
}
if (PersistentStorageHelper.GetValueFromFile("SeparateDBSites") == null)
{
if (!separationFinished.ErrorLabel.Visible)
{
separationFinished.ErrorLabel.Text += "<br />";
}
else
{
separationFinished.ErrorLabel.Visible = true;
}
separationFinished.ErrorLabel.Text += ResHelper.GetFileString("separationdb.startsites");
}
}
private DataTable GetData(Guid _portletID)
{
var mapper = new NHSimpleQuerySettingsMapper();
var settings = mapper.GetSettings(_portletID).ToList();
var _helper = new SettingsHelper(settings, _portletID, mapper);
var portlet = ObjectFactoryWrapper.GetInstance <IPortletFacade>().FindByGuid(_portletID);
OdbcConnectionClass3.OdbcConnectionClass3 odbcConn;
if (_helper.GetSetting("ConfigFile").Value.EndsWith(".config"))
{
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3("~/ClientConfig/" + _helper.GetSetting("ConfigFile").Value);
}
else
{
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3(_helper.GetSetting("ConfigFile").Value);
}
odbcConn.ConnectionTest();
Exception ex = null;
DataTable dt;
var literalStringReplacer = ObjectFactoryWrapper.GetInstance <ILiteralStringReplacer>();
var queryString = literalStringReplacer.Process(_helper.GetSetting("QueryText").Value, portlet);
if (Convert.ToInt16(_helper.GetSetting("QueryTimeout", 0).Value) > 0)
{
dt = odbcConn.ConnectToERP(queryString, ref ex, Convert.ToInt16(_helper.GetSetting("QueryTimeout").Value));
}
else
{
dt = odbcConn.ConnectToERP(queryString, ref ex);
}
if (ex != null)
{
throw ex;
}
return(dt);
}
/// <summary>
/// Elimina los archivos temporales y cierra las ventanas abiertas
/// </summary>
/// <history>
/// [emoguel] 05/09/2016 Created
/// </history>
private void DeleteReports(bool btnClear = false)
{
try
{
List <string> lstName = ObjReportQueues.Where(x => !string.IsNullOrWhiteSpace(x.ReportName)).ToList().Select(x => x.FileName).ToList(); //Buscamos el nombre de los reportes
CloseWindows(lstName); //Cerramos las ventanas de reportes abiertos
//Borrar archivos con fecha diferente a la de hoy
DirectoryInfo directoryInfo = new DirectoryInfo(SettingsHelper.GetReportsPath());
List <FileInfo> lstFiles = directoryInfo.Parent.GetFiles().Where(f => f.CreationTime.Date < DateTime.Now.Date.AddDays(-1)).ToList();
lstFiles.ForEach(fi => fi.Delete());//Eliminamos los archivos
if (btnClear)
{
//Borrar archivos con el mismo nombre
ObjReportQueues.Where(x => !string.IsNullOrWhiteSpace(x.ReportName)).ToList()
.ForEach(x =>
{
if (x.Exists)
{
ObjReportQueues.Remove(x);
lstFiles = directoryInfo.GetFiles($"{x.FileName}*").ToList();
lstFiles.ForEach(f => f.Delete());
}
});
}
else
{
ObjReportQueues.Where(x => !string.IsNullOrWhiteSpace(x.ReportName)).ToList()
.ForEach(x =>
{
lstFiles = directoryInfo.GetFiles($"{x.FileName}*").ToList();
lstFiles.ForEach(f => f.Delete());
});
}
}
catch (Exception ex)
{
UIHelper.ShowMessage(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
_portletId = this.ParentPortlet.PortletDisplay.Portlet.ID.AsGuid;
_mapper = new NHSimpleQuerySettingsMapper();
_settings = _mapper.GetSettings(_portletId).ToList();
_helper = new SettingsHelper(_settings, _portletId, _mapper);
_jicsOutputTypes = new[] { rbJICSOutputCSV, rbJICSOutputDataTables, rbJICSOutputGrid, rbJICSOutputXML, rbJICSOutputLiteral };
_goOutputTypes = new[] { rbGOOutputXML, rbGOOutputNone, rbGOOutputMasterDetail, rbGOOutputGrid, rbGOOutputCSV, rbGOOutputLiteral };
// Don't show the Go settings unless it is version 1.2 or greater.
if (new InstalledApplicationService().IsApplicationAtLeastThisVersion("JICS Go", "1.2"))
{
pnlGoSettings.Visible = true;
}
if (IsFirstLoad)
{
SetDdlConfigFiles();
ShowCurrentValues();
}
}
public App()
{
#if DEBUG
ErrorTracker = new StubErrorTracker();
#else
// Comment this line out if you want to test in release
ErrorTracker = new BoswellErrorTracker(RELEASE_URL, RELEASE_API_KEY);
#endif
InitializeComponent();
_settingsHelper = new SettingsHelper();
_eventAggregator = new EventAggregator();
ViewModelLocationProvider.SetDefaultViewTypeToViewModelTypeResolver((viewType) =>
{
var viewName = viewType.Name;
var viewAssemblyName = viewType.GetTypeInfo().Assembly.FullName;
var viewModelName = string.Format(CultureInfo.InvariantCulture, "Surge.Windows8.ViewModels.{0}.{0}ViewModel, {1}", viewName, viewAssemblyName);
return Type.GetType(viewModelName);
});
}
void Task_AfterDataCommit(object sender, System.Data.LightDatamodel.DataActions action)
{
if (action != System.Data.LightDatamodel.DataActions.Fetch)
{
m_backendSettings = null;
m_extensionSettings = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
_portletId = this.ParentPortlet.PortletDisplay.Portlet.ID.AsGuid;
_mapper = new NHSimpleQuerySettingsMapper();
_settings = _mapper.GetSettings(_portletId).ToList();
_helper = new SettingsHelper(_settings, _portletId, _mapper);
pnlResults.Visible = false;
pnlLinkDescription.Visible = false;
pnlDataTableResults.Visible = false;
pnlQueryTitle.Visible = false;
String strQueryTitle = String.Empty;
if (_settings.Count == 0 || _settings.Find(x => x.Name == "QueryText") == null || _settings.Find(x => x.Name == "QueryText").Value == String.Empty)
{
this.ParentPortlet.ShowFeedback(FeedbackType.Message, "This portlet is not yet configured. Contact portal administrator.");
return;
}
if (_helper.GetSetting("JICSAllowExports", false).BoolValue)
{
if (_helper.GetSetting("ExportXls", false).BoolValue)
{
pnlExport.Visible = true;
lnkSQExportExcel.Visible = true;
lnkSQExportExcel.NavigateUrl = "Export_Data.aspx?format=xls&sqkey=" + this.ParentPortlet.Portlet.ID.AsGuid;
}
if (_helper.GetSetting("ExportCsv", false).BoolValue)
{
pnlExport.Visible = true;
lnkSQExportCsv.Visible = true;
lnkSQExportCsv.NavigateUrl = "Export_Data.aspx?format=csv&sqkey=" + this.ParentPortlet.Portlet.ID.AsGuid;
}
if (_helper.GetSetting("ExportXml", false).BoolValue)
{
pnlExport.Visible = true;
lnkSQExportXml.Visible = true;
lnkSQExportXml.NavigateUrl = "Export_Data.aspx?format=xml&sqkey=" + this.ParentPortlet.Portlet.ID.AsGuid;
}
if (_helper.GetSetting("ExportLiteral", false).BoolValue)
{
pnlExport.Visible = true;
lnkSQExportLiteral.Visible = true;
lnkSQExportLiteral.NavigateUrl = "Export_Data.aspx?format=literal&sqkey=" + this.ParentPortlet.Portlet.ID.AsGuid;
}
}
if (_helper.GetSetting("QueryTitle").Value.Trim().Length > 0)
{
lblQueryTitle.Text = _helper.GetSetting("QueryTitle").Value;
pnlQueryTitle.Visible = true;
}
if (_helper.GetSetting("JICSOutput", "grid").Value != "datatables")
{
if (_helper.GetSetting("JICSAsync", false).BoolValue)
{
if (ShouldRenderOutput())
{
hdnUseAJAX.Value = "Y";
lnbGetData.Visible = true;
}
}
else
{
if (ShouldRenderOutput())
{
RenderOutput();
}
}
}else
{
if(ShouldRenderOutput())
pnlDataTableResults.Visible = true;
}
}
public ServerConfigurationPageViewModel(SettingsHelper settingsHelper, INavigationService navigationService)
{
_settingsHelper = settingsHelper;
_navigationService = navigationService;
InitialiseCommands();
}
private SettingsService() { _helper = new SettingsHelper(); }
public object RunQueryHTML(Guid _portletID)
{
Portlet portlet = ObjectFactoryWrapper.GetInstance<IPortletFacade>().FindByGuid(_portletID);
if (portlet.ParentPage.CanView(PortalUser.Current))
{
try
{
var mapper = new NHSimpleQuerySettingsMapper();
var settings = mapper.GetSettings(_portletID).ToList();
var _helper = new SettingsHelper(settings, _portletID, mapper);
try
{
Exception ex = null;
DataTable dt = GetData(_portletID);
String html = string.Empty;
if (dt != null && dt.Rows.Count > 0)
{
if (_helper.GetSetting("JICSAllowExports").BoolValue)
HttpContext.Current.Session["sqhtml+" + PortalUser.Current.ID.AsGuid + _portletID] = dt;
if (Convert.ToInt32(_helper.GetSetting("RowLimit", 0).Value) > 0)
dt = dt.AsEnumerable().Take(Convert.ToInt32(_helper.GetSetting("RowLimit", 0).Value)).CopyToDataTable();
switch (_helper.GetSetting("JICSOutput", "grid").Value)
{
case "grid":
var dgResults = OutputHelper.CreateDataGrid();
OutputHelper.ConfigureDataGrid(ref dgResults,
dt,
_helper.GetSetting("JICSGridShowColumnHeadings", false).BoolValue,
_helper.GetSetting("JICSGridAltRowColors", false).BoolValue,
_helper.GetSetting("JICSGridShowGridlines", false).BoolValue,
Convert.ToInt16(_helper.GetSetting("JICSGridCellPadding", 5).Value),
_helper.GetSetting("ColumnLabels").Value);
dgResults.DataSource = dt;
dgResults.DataBind();
var stringWrite = new StringWriter();
var htmlWrite = new HtmlTextWriter(stringWrite);
dgResults.RenderControl(htmlWrite);
htmlWrite.Flush();
html = stringWrite.ToString().Replace("\n", "").Replace("\r", "").Replace(" ", "");
break;
case "xml":
html = "<pre>" + HttpUtility.HtmlEncode(OutputHelper.RenderXml(dt)) + "</pre>";
break;
case "csv":
html = "<pre>" + OutputHelper.RenderCsv(dt,
_helper.GetSetting("JICSGridShowColumnHeadings", false).BoolValue,
_helper.GetSetting("ColumnLabels").Value) + "</pre>";
break;
case "literal":
html = OutputHelper.RenderLiteral(dt, _helper.GetSetting("ExportLiteralPattern", "{0}").Value);
break;
}
return new
{
success = true,
resultFormat = _helper.GetSetting("JICSOutput", "grid").Value,
html
};
}
return new
{
success = true,
resultFormat = _helper.GetSetting("JICSOutput", "grid").Value,
html,
query =
(PortalUser.Current.IsSiteAdmin
? _helper.GetSetting("QueryText").Value
: "")
};
}
catch (Exception ex)
{
return new
{
success = false,
message = "Query Failed. " + (PortalUser.Current.IsSiteAdmin ? ": " + ex.StackTrace : "")
};
}
}
catch (Exception ex)
{
return new
{
success = false,
message = "Connection failed before query was executed." + (PortalUser.Current.IsSiteAdmin ? ": " + ex.StackTrace : "")
};
}
}
return new
{
success = false,
message = "You do not have permissions to view this portlet"
};
}
public object RunQuery(Guid _portletID)
{
CUS.OdbcConnectionClass3.OdbcConnectionClass3 odbcConn;
Portlet portlet = Jenzabar.Common.ObjectFactoryWrapper.GetInstance<IPortletFacade>().FindByGuid(_portletID);
if (portlet.ParentPage.CanView(PortalUser.Current))
{
try
{
var mapper = new NHSimpleQuerySettingsMapper();
var settings = mapper.GetSettings(_portletID).ToList();
var helper = new SettingsHelper(settings, _portletID, mapper);
try
{
DataTable dt = GetData(_portletID);
if (dt == null)
{
return new
{
success = false,
message = "No results returned."
};
}
if (helper.GetSetting("JICSAllowExports").BoolValue)
HttpContext.Current.Session["sqhtml+" + PortalUser.Current.ID.AsGuid + _portletID] = dt;
if (Convert.ToInt32(helper.GetSetting("RowLimit", 0).Value) > 0)
dt = dt.AsEnumerable().Take(Convert.ToInt32(helper.GetSetting("RowLimit", 0).Value)).CopyToDataTable();
var jsdtc = new JSDataTableConverter(dt, helper.GetSetting("JICSDataTablesExpandedColumns").Value.Split(','), helper.GetSetting("ColumnLabels").Value.Split(','));
var data = jsdtc.GetJsDataTable();
return new
{
success = true,
data.data,
data.columns
};
}
catch (Exception ex)
{
return new
{
success = false,
message = "Query results handling failed. " + (PortalUser.Current.IsSiteAdmin ? ": " + ex.Message + " " + ex.StackTrace : "")
};
}
}
catch (Exception ex)
{
return new
{
success = false,
message = "Connection failed before query was executed. " + (PortalUser.Current.IsSiteAdmin ? ": " + ex.Message + " " + ex.StackTrace : "")
};
}
}
else
{
return new
{
success = false,
message = "You do not have permissions to view this portlet"
};
}
}
private DataTable GetData( Guid _portletID)
{
var mapper = new NHSimpleQuerySettingsMapper();
var settings = mapper.GetSettings(_portletID).ToList();
var _helper = new SettingsHelper(settings, _portletID, mapper);
OdbcConnectionClass3.OdbcConnectionClass3 odbcConn;
if (_helper.GetSetting("ConfigFile").Value.EndsWith(".config"))
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3("~/ClientConfig/" + _helper.GetSetting("ConfigFile").Value);
else
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3(_helper.GetSetting("ConfigFile").Value);
odbcConn.ConnectionTest();
Exception ex = null;
DataTable dt;
var queryStringFiller = new FillQueryString(_helper.GetSetting("QueryText").Value);
if (Convert.ToInt16(_helper.GetSetting("QueryTimeout", 0).Value) > 0)
dt = odbcConn.ConnectToERP(queryStringFiller.FilledQueryString(), ref ex, Convert.ToInt16(_helper.GetSetting("QueryTimeout").Value));
else
dt = odbcConn.ConnectToERP(queryStringFiller.FilledQueryString(), ref ex);
if (ex != null)
{
throw ex;
}
return dt;
}
private List<SimpleQueryDataRow> GetMasterDetailData(SettingsHelper helper, string username)
{
var ret = new List<SimpleQueryDataRow>();
var dt = GetData(helper, username);
if (Convert.ToInt32(helper.GetSetting("RowLimit", 0).Value) > 0)
dt = dt.AsEnumerable().Take(Convert.ToInt32(helper.GetSetting("RowLimit", 0).Value)).CopyToDataTable();
var detailColumns = helper.GetSetting("GOMasterDetailDisplayColumns").Value.Split(',');
var columnLabels = helper.GetSetting("ColumnLabels").Value.Split(',');
for (var r = 0; r < dt.Rows.Count; r++)
{
var row = new SimpleQueryDataRow {Master = dt.Rows[r][0].ToString()};
foreach (var col in dt.Columns.Cast<DataColumn>())
{
string columnName;
try
{
columnName = columnLabels[col.Ordinal];
}
catch
{
columnName = col.ColumnName;
}
if (detailColumns.Contains(columnName))
row.Details.Add(new SimpleQueryDataColumn
{Value = dt.Rows[r][col.Ordinal].ToString(), Name = columnName});
}
ret.Add(row);
}
return ret;
}
private void SetupSettingsPane()
{
_settingsHelper = new SettingsHelper();
_settingsHelper.AddCommand<SettingsUserControl>("Preferences");
SettingsPane.GetForCurrentView().CommandsRequested += OnCommandsRequested;
}
private DataTable GetData(SettingsHelper helper, string username)
{
//Try and connect
CUS.OdbcConnectionClass3.OdbcConnectionClass3 odbcConn;
if (helper.GetSetting("ConfigFile").Value.EndsWith(".config"))
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3("~/ClientConfig/" + helper.GetSetting("ConfigFile").Value);
else
odbcConn = new CUS.OdbcConnectionClass3.OdbcConnectionClass3(helper.GetSetting("ConfigFile").Value);
odbcConn.ConnectionTest();
var ex = new Exception();
var queryStringFiller = new Helpers.FillQueryString(helper.GetSetting("QueryText").Value,
_userFacade.FindByUsername(username));
DataTable dt;
if (Convert.ToInt16(helper.GetSetting("QueryTimeout", 0).Value) > 0)
dt = odbcConn.ConnectToERP(queryStringFiller.FilledQueryString(), ref ex, Convert.ToInt16(helper.GetSetting("QueryTimeout").Value));
else
dt = odbcConn.ConnectToERP(queryStringFiller.FilledQueryString(), ref ex);
if (ex != null)
{
throw ex;
}
return dt;
}
private static List<String> AllowedExports(SettingsHelper helper)
{
var exports = new List<String>();
if (helper.GetSetting("ExportXls", false).BoolValue)
{
//exports.Add("Xls"); //Disabled for the time being. The method currently employed to produce "excel" files is fundamentally flawed and really needs to be revisted.
}
if (helper.GetSetting("ExportCsv", false).BoolValue)
{
exports.Add("Csv");
}
if (helper.GetSetting("ExportXml", false).BoolValue)
{
exports.Add("Xml");
}
if (helper.GetSetting("ExportLiteral", false).BoolValue)
{
exports.Add("Literal");
}
return exports;
}
private void Page_Load(object sender, System.EventArgs e)
{
var strContentType = "text/plain"; // these defaults will be overwritten if we're successful
var strFilename = "ErrorOutput.txt";
var mstream = new MemoryStream();
var sw = new StreamWriter(mstream);
if (Request.QueryString["sqkey"] != null
&& IsGuidFormat(Request.QueryString["sqkey"].ToString()))
{
var strKey = PortalUser.Current.ID.AsGuid + Request.QueryString["sqkey"];
var strFormat = Request.QueryString["format"];
if (HttpContext.Current.Session["sqhtml+" + strKey] != null && strFormat != null)
{
try
{
DataTable dt = (DataTable) HttpContext.Current.Session["sqhtml+" + strKey];
var mapper = new NHSimpleQuerySettingsMapper();
var settings = mapper.GetSettings(new Guid(Request.QueryString["sqkey"])).ToList();
var _helper = new SettingsHelper(settings, new Guid(Request.QueryString["sqkey"]), mapper);
string fileName;
if (_helper.GetSetting("QueryTitle").Value.Trim().Length > 0)
fileName = Regex.Replace(_helper.GetSetting("QueryTitle").Value.Trim(), @"\W", "");//remove non-alphanumeric characters from filename
else
fileName = "ExportedData";
switch (strFormat)
{
case "xls":
var dgResults = OutputHelper.CreateDataGrid();
OutputHelper.ConfigureDataGrid(ref dgResults,
dt,
_helper.GetSetting("JICSGridShowColumnHeadings", false).BoolValue,
_helper.GetSetting("JICSGridAltRowColors", false).BoolValue,
_helper.GetSetting("JICSGridShowGridlines", false).BoolValue,
Convert.ToInt16(_helper.GetSetting("JICSGridCellPadding", 5).Value),
_helper.GetSetting("ColumnLabels").Value);
dgResults.DataSource = dt;
dgResults.DataBind();
var stringWrite = new StringWriter();
var htmlWrite = new HtmlTextWriter(stringWrite);
dgResults.RenderControl(htmlWrite);
htmlWrite.Flush();
sw.WriteLine(stringWrite.ToString().Replace("\n", "").Replace("\r", "").Replace(" ", ""));
strContentType = "application/vnd.ms-excel";
strFilename = fileName + ".xls";
break;
case "xml":
sw.WriteLine(OutputHelper.RenderXml(dt));
strContentType = "text/xml";
strFilename = fileName + ".xml";
break;
case "csv":
sw.WriteLine(OutputHelper.RenderCsv(dt,
_helper.GetSetting("JICSGridShowColumnHeadings", false).BoolValue,
_helper.GetSetting("ColumnLabels").Value));
strContentType = "text/csv";
strFilename = fileName + ".csv";
break;
case "literal":
sw.WriteLine(OutputHelper.RenderLiteral(dt, _helper.GetSetting("ExportLiteralPattern", "{0}").Value));
strContentType = "text/plain";
strFilename = fileName + ".txt";
break;
}
}
catch (Exception ex)
{
sw.WriteLine("Export failed. Please contact site adminstrator. (cache corrupted)" + (PortalUser.Current.IsSiteAdmin ? ex.ToString() : "") );
}
}
else
{
sw.WriteLine("Export failed. Please contact site adminstrator. (cache empty)");
}
}
else
{
sw.WriteLine("Export failed. Please contact site adminstrator. (bad key)");
}
sw.Flush();
sw.Close();
byte[] byteArray = mstream.ToArray();
mstream.Flush();
mstream.Close();
Response.Clear();
Response.AddHeader("Content-Type", strContentType);
Response.AddHeader("Content-Disposition", "attachment; filename=" + strFilename);
Response.AddHeader("Content-Length", byteArray.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.BinaryWrite(byteArray);
Response.End();
}
public ApplicationSettings(IDataFetcher dataparent)
{
m_appset = new SettingsHelper<ApplicationSetting, string, string>(dataparent, new List<ApplicationSetting>(dataparent.GetObjects<ApplicationSetting>()), "Name", "Value");
}
public void ExistingSelected()
{
// update Remove button logic
CanRemove = (CurrentUploader != null);
RemoveCommand.RaiseCanExecuteChanged();
if (CurrentUploader == null)
return;
var helper = new SettingsHelper();
var control = helper.GetSettingsControl(CurrentUploader);
if (control != null)
{
control.Load(CurrentUploader);
SettingsControl = control;
}
else
SettingsControl = new NoSettingsDefined();
}
