117
private void ButtonDeleteReception_Click(object sender, RoutedEventArgs
e)
{
Reception_ reception = ReceptionDataGrid.SelectedItem as
Reception_;
if (reception != null)
{
sqlExpression = "DELETE FROM [Reception] WHERE Id_Reception = " +
reception.Id;
command = new SqlCommand(sqlExpression, connection);
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Командауспешновыполнена.");
ReceptionDataGrid.Items.Remove(reception);
}
else
{
MessageBox.Show("ошибкаудалениязаписи.", "ошибка",
MessageBoxButton.OK, MessageBoxImage.Error);
}
MessageBox.Show("Уведомитьпациентаобудалениизаписи ?", "",
MessageBoxButton.YesNo, MessageBoxImage.Question);
}
else
{
MessageBox.Show("Не выбрана запись для удаления.");
}
118
}
}
}
<Window x:Class="Reception.NewReception"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-
compatibility/2006"
xmlns:local="clr-namespace:Reception"
mc:Ignorable="d"
Title="Записьнаприем" Height="450" Width="800">
<Window.Resources>
<Style TargetType="TextBlock" x:Key="LabelStyle">
<Setter Property="FontSize" Value="16"/>
<Setter Property="FontWeight" Value="Bold"/>
<Setter Property="Margin" Value="0 1 5 0"/>
</Style>
</Window.Resources>
<Grid>
<Grid.RowDefinitions>
<RowDefinition Height="4*"/>
<RowDefinition Height="9*"/>
<RowDefinition Height="1*"/>
</Grid.RowDefinitions>
119
<Grid Grid.Row="0" Margin="25 25 0 0">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="150px"/>
<ColumnDefinition Width="Auto"/>
</Grid.ColumnDefinitions>
<Grid.RowDefinitions>
<RowDefinition Height="Auto"/>
<RowDefinition Height="Auto"/>
<RowDefinition Height="Auto"/>
</Grid.RowDefinitions>
<TextBlock Grid.ColumnSpan="2" Grid.Row="0" x:Name="FIO"
Style="{StaticResource LabelStyle}"/>
<TextBlock Grid.Column="0" Grid.Row="1" Style="{StaticResource
LabelStyle}">цена</TextBlock>
<TextBox Grid.Column="1" Grid.Row="1" Text="{Binding price}"
MinWidth="100" x:Name="TBP"/>
<DatePicker Grid.ColumnSpan="2" Grid.Row="2" x:Name="datepicker"
SelectedDate="{Binding dateTime}"/>
</Grid>
<Grid Grid.Row="1">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="1*"/>
<ColumnDefinition Width="2*"/>
</Grid.ColumnDefinitions>
<!--процедуры-->
<DataGrid IsReadOnly="True" Grid.Column="0"
120
x:Name="ProcedureDataGrid"
SelectionChanged="ProcedureDataGrid_SelectionChanged">
<DataGrid.Columns>
<DataGridTextColumn Header="кодуслуги" Binding="{Binding Id}"/>
<DataGridTextColumn Header="имяуслуги" Binding="{Binding
nameProcedure}"/>
</DataGrid.Columns>
</DataGrid>
<DataGrid IsReadOnly="True" Grid.Column="1"
x:Name="DoctorDataGrid"
SelectionChanged="DoctorDataGrid_SelectionChanged">
<DataGrid.Columns>
<DataGridTextColumn Header="кодврача" Binding="{Binding Id}"/>
<DataGridTextColumn Header="фамилия" Binding="{Binding
surname}"/>
<DataGridTextColumn Header="имя" Binding="{Binding nameDoctor}"/>
<DataGridTextColumn Header="отчество" Binding="{Binding
patronymic}"/>
<DataGridTextColumn Header="должность" Binding="{Binding
positionname}"/>
</DataGrid.Columns>
</DataGrid>
</Grid>
<Button Grid.Row="2" Content="назначить / готово"
Click="ButtonDone_Click"/>
</Grid>
121
</Window>
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
namespace Reception
{
public class Context
{
public int Price { get; set; }
public DateTime dateTime { get; set; }
}
public partial class NewReception : Window
{
SqlConnection connection;
SqlCommand command;
SqlDataReader reader;
string sqlExpression;
122
Patient patient = null;
Procedure procedure = null;
Doctor doctor = null;
Context context = new Context() { dateTime = DateTime.Now };
public NewReception(Patient patient, SqlConnection connection)
{
InitializeComponent();
this.patient = patient;
this.connection = connection;
this.DataContext = context;
FIO.Text = patient.surname + " " + patient.namePatient + " " +
patient.patronymic;
//загрузкапроцедур
sqlExpression = "SELECT [Procedure].[Id_Procedure],
[Procedure].[nameProcedure], [Procedure].[price] FROM [Procedure]";
command = new SqlCommand(sqlExpression, connection);
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Procedure temp = new Procedure();
temp.Id = reader.GetInt32(0);
temp.nameProcedure = reader.GetString(1);
temp.price = reader.GetInt32(2);
123
ProcedureDataGrid.Items.Add(temp);
}
}
}
private void ProcedureDataGrid_SelectionChanged(object sender,
SelectionChangedEventArgs e)
{
Procedure procedure = ProcedureDataGrid.SelectedItem as
Procedure;
if (procedure != null)
{
this.procedure = procedure;
TBP.DataContext = this.procedure;
DoctorDataGrid.Items.Clear();
List<int> temp_position_id= new List<int>();
//получениеайдишникадолжности
sqlExpression = "SELECT [Position_Procedure].[position] FROM
[Position_Procedure] WHERE [Position_Procedure].[procedure] = " +
procedure.Id;
command = new SqlCommand(sqlExpression, connection);
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
124
temp_position_id.Add(reader.GetInt32(0));
}
}
foreach (int tempId in temp_position_id)
{
//загрузкаврачей
sqlExpression = "SELECT [Doctor].[Id_doc],
[Doctor].[nameDoctor], [Doctor].[surname], [Doctor].[patronymic],
[Doctor].[position], [Position].[namePosition] FROM [Doctor] LEFT JOIN
[Position] ON [Doctor].[position] = [Position].[Id_position] WHERE
[Doctor].[position] = " + tempId;
command = new SqlCommand(sqlExpression, connection);
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Doctor temp = new Doctor();
temp.Id = reader.GetInt32(0);
temp.nameDoctor = reader.GetString(1);
temp.surname = reader.GetString(2);
temp.patronymic = reader.GetString(3);
temp.position_id = reader.GetInt32(4);
temp.positionname = reader.GetString(5);
DoctorDataGrid.Items.Add(temp);
}
}
}
125
}
}
private void DoctorDataGrid_SelectionChanged(object sender,
SelectionChangedEventArgs e)
{
Doctor doctor = DoctorDataGrid.SelectedItem as Doctor;
if (doctor != null)
{
this.doctor = doctor;
}
}
private void ButtonDone_Click(object sender, RoutedEventArgs e)
{
try
{
if (patient == null) { throw new Exception("непредвиденнаяошибка!"); }
if (procedure == null) { throw new Exception("Невыбранапроцедура."); }
if (doctor == null) { throw new Exception("Невыбранлечащаейврач."); }
if (procedure.price <= 0) { throw new Exception("Неназначенацена."); }
sqlExpression = string.Format("INSERT INTO [Reception] ([doctor],
[patient], [procedure], [status], [begin_reception], [price]) VALUES ({0}, {1},
{2}, 0, '{3}', {4})", this.doctor.Id, this.patient.Id, this.procedure.Id,
context.dateTime.ToString(), Convert.ToInt32(procedure.price));
command = new SqlCommand(sqlExpression, connection);
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Новаязаписьуспешнодобавлена");
126
}
else
{
throw new Exception("Ошибка добавлнеия новой записи в
базу данных.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "info", MessageBoxButton.OK,
MessageBoxImage.Information);
}
}
}
}
<Window x:Class="Reception.PatientCard"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-
compatibility/2006"
xmlns:local="clr-namespace:Reception"
mc:Ignorable="d"
Title="карточкапациента" Height="450" Width="800">
<Window.Resources>
<Style TargetType="TextBlock" x:Key="LabelStyle">
<Setter Property="FontSize" Value="16"/>
<Setter Property="FontWeight" Value="Bold"/>