void ws_GetSchoolsCompleted(object sender, GetSchoolsCompletedEventArgs e)
{
if (e.Error != null)
{
System.Windows.Browser.HtmlPage.Window.Alert(e.Error.Message);
}
else if (e.ServiceError != null)
{
System.Windows.Browser.HtmlPage.Window.Alert(e.ServiceError.Message);
}
else
{
_tables = e.Result.Tables;
IEnumerable list = DynamicDataBuilder.GetDataList(e.Result);
if (e.UserState as string == "Lookup")
{
_lookup = list;
}
else
{
//theGrid.Columns.Clear();
//theGrid.ItemsSource = e.Result;
}
}
}
void Update_Click(object sender, RoutedEventArgs e)
{
var ws = WCF.GetService();
ws.UpdateCompleted += new EventHandler <DataSetInDataGrid.Silverlight.MyDataService.UpdateCompletedEventArgs>(ws_UpdateCompleted);
ws.UpdateAsync(DynamicDataBuilder.GetUpdatedDataSet(theGrid.ItemsSource as IEnumerable, _tables));
this.Progress.Start();
}
void ws_GetDataSetDataCompleted(object sender, DataSetInDataGrid.Silverlight.MyDataService.GetDataSetDataCompletedEventArgs e)
{
if (e.Error != null)
{
System.Windows.Browser.HtmlPage.Window.Alert(e.Error.Message);
}
else if (e.ServiceError != null)
{
System.Windows.Browser.HtmlPage.Window.Alert(e.ServiceError.Message);
}
else
{
_tables = e.Result.Tables;
IEnumerable list = DynamicDataBuilder.GetDataList(e.Result);
if (e.UserState as string == "Lookup")
{
_lookup = list;
}
else
{
theGrid.Columns.Clear();
theGrid.ItemsSource = DynamicDataBuilder.GetDataList(e.Result);
if (e.Result.Tables.Count > 0)
{
foreach (DataSetInDataGrid.Silverlight.MyDataService.DataColumnInfo column in e.Result.Tables[0].Columns)
{
if (column.DisplayIndex != -1)
{
DataGridColumn col;
DataTemplate dt;
if (column.DataTypeName == typeof(bool).FullName)
{
DataGridCheckBoxColumn checkBoxColumn = new DataGridCheckBoxColumn();
checkBoxColumn.Binding = new Binding(column.ColumnName);
col = checkBoxColumn;
}
else if (column.DataTypeName == typeof(DateTime).FullName)
{
DataGridTemplateColumn templateColumn = new DataGridTemplateColumn();
string temp = TemplateManager.DataTemplates["DateTimeCellTemplate"];
temp = temp.Replace("@HorizontalAlignment@", HorizontalAlignment.Left.ToString());
temp = temp.Replace("@Text@", column.ColumnName);
temp = temp.Replace("@DateTimeFormat@", "MM/dd/yyyy");
dt = XamlReader.Load(temp) as DataTemplate;
templateColumn.CellTemplate = dt;
DataTemplate t = new DataTemplate();
temp = TemplateManager.DataTemplates["DateTimeCellEditingTemplate"];
temp = temp.Replace("@HorizontalAlignment@", HorizontalAlignment.Left.ToString());
temp = temp.Replace("@SelectedDate@", column.ColumnName);
dt = XamlReader.Load(temp) as DataTemplate;
templateColumn.CellEditingTemplate = dt;
col = templateColumn;
}
else
{
DataGridTextColumn textColumn = new DataGridTextColumn();
textColumn.Binding = new Binding(column.ColumnName);
textColumn.Binding.ValidatesOnExceptions = true;
col = textColumn;
}
col.IsReadOnly = column.IsReadOnly;
//HyperlinkButton b = new HyperlinkButton();
//b.Background = new SolidColorBrush(Colors.Transparent);
//b.Margin = new Thickness(5, 5, 5, 5);
//b.Content = column.ColumnTitle;
//b.HorizontalAlignment = HorizontalAlignment.Center;
//b.IsHitTestVisible = false;
//b.Cursor = Cursors.Hand;
//TextBlock tip = new TextBlock();
//tip.Text = "Click to Sort by " + column.ColumnTitle;
//ToolTipService.SetToolTip(b, tip);
col.Header = column.ColumnTitle;
col.SortMemberPath = column.ColumnName;
theGrid.Columns.Add(col);
}
}
}
theGrid.CanUserReorderColumns = false;
theGrid.FrozenColumnCount = 2;
theGrid.HorizontalContentAlignment = HorizontalAlignment.Center;
}
}
this.Progress.Stop();
}