public Chart()
{
InitializeComponent();
_chartByCountry.ChartType = ChartType.Line;
_chartByProduct.ChartType = ChartType.Line;
dataServiceClient = new DataServiceRef.NORTHWNDEntities(new Uri("http://localhost:50297/NorthWindDataService.svc/"));
nwndQuery = dataServiceClient.Invoices;
#region DataForCountry-Sales Chart
var cntryslschrtdt = GetSalesByCountry(nwndQuery.ToArray().ToList());
DataSeries amtsers = new DataSeries();
amtsers.ValuesSource = cntryslschrtdt.ConvertAll(e => e.Amount).ToArray();
_chartByCountry.Data.Children.Add(amtsers);
var xvals = cntryslschrtdt.ConvertAll(e => e.Item).Distinct().ToArray();
_chartByCountry.Data.ItemNames = xvals;
_chartByCountry.View.AxisX.Title = CreateTextBlock("Countries");
_chartByCountry.View.AxisX.AnnoAngle = 45;
_chartByCountry.View.AxisY.Title = CreateTextBlock("Sales");
#endregion
#region DataForProduct-Sales Chart
var pdctslchrtdt = GetSalesByProduct(nwndQuery.ToArray().ToList());
DataSeries amtserspd = new DataSeries();
amtserspd.ValuesSource = pdctslchrtdt.ConvertAll(e => e.Amount).ToArray();
_chartByProduct.Data.Children.Add(amtserspd);
var xvalspd = pdctslchrtdt.ConvertAll(e => e.Item).Distinct().ToArray();
_chartByProduct.Data.ItemNames = xvalspd;
_chartByProduct.View.AxisX.Title = CreateTextBlock("Product");
_chartByProduct.View.AxisX.AnnoAngle = 45;
_chartByProduct.View.AxisY.Title = CreateTextBlock("Sales");
#endregion
}
public Chart()
{
InitializeComponent();
_chartByCountry.ChartType = ChartType.Line;
_chartByProduct.ChartType = ChartType.Line;
dataServiceClient = new DataServiceRef.NORTHWNDEntities(new Uri("http://localhost:50297/NorthWindDataService.svc/"));
nwndQuery = dataServiceClient.Invoices;
#region DataForCountry-Sales Chart
var cntryslschrtdt = GetSalesByCountry(nwndQuery.ToArray().ToList());
DataSeries amtsers = new DataSeries();
amtsers.ValuesSource = cntryslschrtdt.ConvertAll(e => e.Amount).ToArray();
_chartByCountry.Data.Children.Add(amtsers);
var xvals = cntryslschrtdt.ConvertAll(e => e.Item).Distinct().ToArray();
_chartByCountry.Data.ItemNames = xvals;
_chartByCountry.View.AxisX.Title = CreateTextBlock("Countries");
_chartByCountry.View.AxisX.AnnoAngle = 45;
_chartByCountry.View.AxisY.Title = CreateTextBlock("Sales");
#endregion
#region DataForProduct-Sales Chart
var pdctslchrtdt = GetSalesByProduct(nwndQuery.ToArray().ToList());
DataSeries amtserspd = new DataSeries();
amtserspd.ValuesSource = pdctslchrtdt.ConvertAll(e => e.Amount).ToArray();
_chartByProduct.Data.Children.Add(amtserspd);
var xvalspd = pdctslchrtdt.ConvertAll(e => e.Item).Distinct().ToArray();
_chartByProduct.Data.ItemNames = xvalspd;
_chartByProduct.View.AxisX.Title = CreateTextBlock("Product");
_chartByProduct.View.AxisX.AnnoAngle = 45;
_chartByProduct.View.AxisY.Title = CreateTextBlock("Sales");
#endregion
}
public Invoice()
{
InitializeComponent();
dataServiceClient = new DataServiceRef.NORTHWNDEntities(new Uri("http://localhost:50297/NorthWindDataService.svc/"));
nwndQuery = dataServiceClient.Invoices;
_flex.ItemsSource = nwndQuery;
}
public Invoice()
{
InitializeComponent();
dataServiceClient = new DataServiceRef.NORTHWNDEntities(new Uri("http://localhost:50297/NorthWindDataService.svc/"));
nwndQuery = dataServiceClient.Invoices;
_flex.ItemsSource = nwndQuery;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
// TODO: Modify the port number in the following URI as required.
dataServiceClient = new AdventureWorksService.AdventureWorksLTEntities(
new Uri("http://localhost:45899/AdventureWorksService.svc"));
salesQuery = dataServiceClient.SalesOrderHeaders;
ordersViewSource = ((CollectionViewSource)(this.FindResource("salesOrderHeadersViewSource")));
ordersViewSource.Source = salesQuery.Execute();
ordersViewSource.View.MoveCurrentToFirst();
}
public Version GetBaseUriVersion(System.Data.Services.Client.DataServiceQuery <biz.dfch.CS.Appclusive.Core.OdataServices.Diagnostics.Endpoint> endpoint)
{
Contract.Requires(null != endpoint);
Contract.Ensures(null != Contract.Result <Version>());
var baseUri = endpoint.FirstOrDefault(e => e.Id == 1);
Contract.Assert(null != baseUri, "Retrieving version information FAILED.");
var result = new Version(baseUri.Version);
return(result);
}
//bing 번역기로부터 번역문 얻기
private static Translation TranslateString(TranslatorContainer tc, string inputString, string transCode, string resultCode)
{
System.Data.Services.Client.DataServiceQuery <MORT.TransFormOver.Translation> translationQuery = tc.Translate(inputString, resultCode, transCode);
// Call the query and get the results as a List
System.Collections.Generic.List <MORT.TransFormOver.Translation> translationResults = translationQuery.Execute().ToList();
// Verify there was a result
if (translationResults.Count() <= 0)
{
return(null);
}
// In case there were multiple results, pick the first one
Translation translationResult = translationResults.First();
return(translationResult);
}