| <Window x:Class="WPF_LinQ.Forms.Glavno" |
| xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" |
| xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" |
| Title="Glavno" Height="800" Width="600" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation" |
| xmlns:System="clr-namespace:System;assembly=mscorlib" |
| > |
| <Grid> |
| <telerik:RadGridView Margin="5" Name="radGridView1" AutoGenerateColumns="False" CanUserReorderColumns="False" ColumnsWidthMode="Fill"> |
| <telerik:RadGridView.Columns> |
| <telerik:GridViewDataColumn HeaderText="Code" UniqueName="ID" /> |
| <telerik:GridViewDataColumn HeaderText="City" UniqueName="Name" /> |
| <telerik:GridViewComboBoxColumn |
| ItemsSource="{Binding}" |
| DataMemberBinding="{Binding Path=CountryID}" |
| DisplayMemberPath="Name" |
| SelectedValueMemberPath="ID" |
| HeaderText="Country" |
| UniqueName="CountryID" /> |
| </telerik:RadGridView.Columns> |
| </telerik:RadGridView> |
| </Grid> |
| </Window> |
| public partial class Glavno : Window |
| { |
| private DB.TMSDataContext m_DC; |
| public Glavno() |
| { |
| InitializeComponent(); |
| Init(); |
| } |
| public void Init() |
| { |
| m_DC = new DB.TMSDataContext(); |
| radGridView1.Columns[2].DataContext = m_DC.Countries; |
| radGridView1.ItemsSource = m_DC.PostalCodes.OrderBy(e=>e.Name); |
| //radGridView1.Columns[3].DataContext = m_DC.PostalCodes.OrderBy(p => p.Name).ToArray(); |
| //radGridView1.Columns[2].DataContext = GetCountries(); |
| } |
| } |
public MainWindow() { StyleManager.ApplicationTheme = new Expression_DarkTheme(); InitializeComponent(); } void SetGlobalTheme(Theme theme)
{
StyleManager.ApplicationTheme = theme;
StyleManager.SetTheme(radRibbonView1, theme);
}
private void RadRibbonRadioButton_Click(object sender, RoutedEventArgs e)
{
RadRibbonRadioButton radioButton = (RadRibbonRadioButton)sender;
Theme currentTheme = ConvertToTheme(radioButton.Text);//Button's content is theme name, like Office_Silver
SetThemeToAllViews(currentTheme);
}
| <GroupBox Name="gbAccountManagment" Margin="2,2,2,2" MaxHeight="580" Height="480" VerticalAlignment="Top" > |
| <GroupBox.Header> |
| <Grid> |
| <Grid.ColumnDefinitions> |
| <ColumnDefinition></ColumnDefinition> |
| <ColumnDefinition></ColumnDefinition> |
| </Grid.ColumnDefinitions> |
| <Button Grid.Column="0" Name="btnAccountManagmentPlus" Visibility="Hidden" Width="20" Click="btnAccountManagmentPlus_Click">+</Button> |
| <Button Grid.Column="0" Name="btnAccountManagmentMinus" Width="20" Click="btnAccountManagmentMinus_Click">-</Button> |
| <Label Grid.Column="1">ניהול חשבונות</Label> |
| </Grid> |
| </GroupBox.Header> |
| <StackPanel> |
| <StackPanel Orientation="Horizontal"> |
| <TextBlock Margin="100,5,5,5" FontWeight="Bold" Width="60">סוג תקציב</TextBlock> |
| <ComboBox Name="cmbBudgetType" DisplayMemberPath="Name" Margin="5,5,5,5" Width="120" SelectionChanged="cmbBudgetType_SelectionChanged"></ComboBox> |
| <TextBlock Margin="100,5,5,5" FontWeight="Bold" Width="60">סוג פעילות</TextBlock> |
| <ComboBox Name="cmbActivityType" DisplayMemberPath="Name" Margin="5,5,5,5" Width="120" SelectionChanged="cmbActivityType_SelectionChanged"></ComboBox> |
| <Button Name="btnFilter" Margin="30,5,5,5" Click="btnFilter_Click">הצג</Button> |
| <Button Visibility="Hidden" Name="btnTry" Margin="30,5,5,5" Click="btnTry_Click">Try</Button> |
| </StackPanel> |
| <telerik:RadGridView Name="gvAccount" Margin="5,5,5,5" AutoGenerateColumns="False" |
| CanUserResizeColumns="False" CanUserReorderColumns="False" |
| CanUserFreezeColumns="False" ShowGroupPanel="False" CanUserSortColumns="False" |
| FlowDirection="RightToLeft" IsFilteringAllowed="False" ShowColumnHeaders="True" CanUserInsertRows="False"> |
| <telerik:RadGridView.Resources> |
| <Style x:Key="ToolTipColumnStyle" TargetType="telerik:GridViewCell"> |
| <Setter Property="ToolTip" Value="{Binding Content,RelativeSource={RelativeSource Self}}" /> |
| </Style> |
| </telerik:RadGridView.Resources> |
| <telerik:RadGridView.Columns> |
| <telerik:GridViewDataColumn IsReadOnly="True" UniqueName="BudgetTypeName" Header="תקציב" Width="60"/> |
| <telerik:GridViewDataColumn IsReadOnly="True" UniqueName="Name" Header="שם חשבון/ סעיף/תת סעיף" Width="160" CellStyle="{StaticResource ToolTipColumnStyle}"/> |
| <telerik:GridViewDataColumn IsReadOnly="True" UniqueName="DisplayNum" Header="מס' חשבון/ סעיף/תת סעיף" Width="110" /> |
| <telerik:GridViewDataColumn IsReadOnly="True" DataFormatString="{}{0:#,##0.00}" UniqueName="TotalBudget" Header="הקצבה כוללת (אש''ח)" Width="75"/> |
| <telerik:GridViewDataColumn IsReadOnly="True" DataFormatString="{}{0:#,##0.00₪}" UniqueName="BalanceBudgetAllocation" Header="יתרה לתקצוב (אש''ח)" Width="75" /> |
| <telerik:GridViewDataColumn IsReadOnly="True" DataFormatString="{}{0:#,##0.00₪}" UniqueName="SumBudgetRequest" Header="שריון לפעילויות (אש''ח)" Width="75"/> |
| <telerik:GridViewDataColumn IsReadOnly="True" DataFormatString="{}{0:#,##0.00₪}" UniqueName="SumOrderAllocation" Header="התחייבות לפעילויות (אש''ח)" Width="75" /> |
| <telerik:GridViewDataColumn IsReadOnly="True" DataFormatString="{}{0:#,##0.00₪}" UniqueName="SumOrderPaid" Header="שולם בפועל (אש''ח)" Width="75"/> |
| <telerik:GridViewDataColumn IsReadOnly="True" DataFormatString="{}{0:#,##0.00₪}" UniqueName="BalanceToPay" Header="יתרה לתשלום (אש''ח)" Width="75"/> |
| <telerik:GridViewDataColumn IsReadOnly="True" DataFormatString="{}{0:#,##0.00₪}" UniqueName="ActivityTypeName" Header="סוג פעילות" Width="120"/> |
| </telerik:RadGridView.Columns> |
protected override void OnAppointmentCreated(IAppointment appointment)
{
CustomAppointment addedAppointment = appointment as CustomAppointment;
if (addedAppointment != null)
{
OleDbConnection cnInsertAppointment = new OleDbConnection(Properties.Resources.cnDBPhito);
cnInsertAppointment.Open();
OleDbCommand cmdInsertAppointment = new OleDbCommand();
cmdInsertAppointment.Connection = cnInsertAppointment;
cmdInsertAppointment.CommandType = CommandType.Text;
cmdInsertAppointment.CommandText = "insert into Appointments(AppointmentID, Subject, Body, Start, End, IsAllDayEvent, Location, Url, TimeMarker, Importance, Category, RecurrencePattern, IsReturn, MedicalOrder, HealthClubID, PatientID) values(@AppointmentID, @Subject, @Body, @Start, @End, @IsAllDayEvent, @Location, @Url, @TimeMarker, @Importance, @Category, @RecurrencePattern, @IsReturn, @MedicalOrder, @HealthClubID, @PatientID)";
cmdInsertAppointment.Parameters.Add("@AppointmentID", OleDbType.VarChar, 36).Value = addedAppointment.UniqueId;
cmdInsertAppointment.Parameters.Add("@Subject", OleDbType.VarChar, 100).Value = addedAppointment.Subject;
cmdInsertAppointment.Parameters.Add("@Body", OleDbType.VarChar, 400).Value = addedAppointment.Body;
DateTime dtStart = new DateTime(addedAppointment.Start.Year, addedAppointment.Start.Month, addedAppointment.Start.Day, addedAppointment.Start.Hour, addedAppointment.Start.Minute, addedAppointment.Start.Second);
cmdInsertAppointment.Parameters.Add("@Start", OleDbType.DBTimeStamp).Value = dtStart;
DateTime dtEnd = new DateTime(addedAppointment.End.Year, addedAppointment.End.Month, addedAppointment.End.Day, addedAppointment.End.Hour, addedAppointment.End.Minute, addedAppointment.End.Second);
cmdInsertAppointment.Parameters.Add("@End", OleDbType.DBTimeStamp).Value = dtEnd;
cmdInsertAppointment.Parameters.Add("@IsAllDayEvent", OleDbType.Boolean).Value = addedAppointment.IsAllDayEvent;
cmdInsertAppointment.Parameters.Add("@Location", OleDbType.VarChar, 200).Value = addedAppointment.Location;
cmdInsertAppointment.Parameters.Add("@Url", OleDbType.VarChar, 200).Value = addedAppointment.Url;
cmdInsertAppointment.Parameters.Add("@TimerMarker", OleDbType.VarChar, 50).Value = addedAppointment.TimeMarker == null ? String.Empty : addedAppointment.TimeMarker.TimeMarkerName;
cmdInsertAppointment.Parameters.Add("@Importance", OleDbType.VarChar, 50).Value = addedAppointment.Importance == null ? String.Empty : addedAppointment.Importance.ToString();
cmdInsertAppointment.Parameters.Add("@Category", OleDbType.VarChar, 50).Value = addedAppointment.Category == null ? String.Empty : addedAppointment.Category.CategoryName;
if (addedAppointment.RecurrenceRule != null)
{
cmdInsertAppointment.Parameters.Add("@RecurrencePattern", OleDbType.VarChar, 100).Value = RecurrencePatternHelper.RecurrencePatternToString(appointment.RecurrenceRule.Pattern);
}
cmdInsertAppointment.Parameters.Add("@IsReturn", OleDbType.Boolean).Value = addedAppointment.IsReturn;
cmdInsertAppointment.Parameters.Add("@MedicalOrder", OleDbType.Boolean).Value = addedAppointment.MedicalOrder;
cmdInsertAppointment.Parameters.Add("@HealthClubID", OleDbType.Integer).Value = addedAppointment.HealthClubID;
cmdInsertAppointment.Parameters.Add("@PatientID", OleDbType.Integer).Value = addedAppointment.PatientID;
try
{
cmdInsertAppointment.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
cmdInsertAppointment.Dispose();
cnInsertAppointment.Close();
cnInsertAppointment.Dispose();
}
}