private void lo_Loaded(object sender, RoutedEventArgs e)
{
// ButtonRemove
{
Grid newGrid = new Grid()
{
Margin = new Thickness(5)
};
buttonRemove.Content = newGrid;
newGrid.RowDefinitions.Add(new RowDefinition()
{
Height = new GridLength(1, GridUnitType.Star)
});
Image newImage = new Image()
{
};
newGrid.Children.Add(newImage);
newImage.Source = new BitmapImage(new Uri("bin/Resource/Delete.ico", UriKind.Relative))
{
CreateOptions = BitmapCreateOptions.IgnoreImageCache
};
Grid.SetRow(newImage, 0);
}
// ButtonAdd
{
Grid newGrid = new Grid()
{
Margin = new Thickness(5)
};
buttonAdd.Content = newGrid;
newGrid.RowDefinitions.Add(new RowDefinition()
{
Height = new GridLength(1, GridUnitType.Star)
});
Image newImage = new Image()
{
};
newGrid.Children.Add(newImage);
newImage.Source = new BitmapImage(new Uri("bin/Resource/Add.ico", UriKind.Relative))
{
CreateOptions = BitmapCreateOptions.IgnoreImageCache
};
Grid.SetRow(newImage, 0);
}
// ButtonDetail
{
Grid newGrid = new Grid()
{
Margin = new Thickness(5)
};
buttonChange.Content = newGrid;
newGrid.RowDefinitions.Add(new RowDefinition()
{
Height = new GridLength(1, GridUnitType.Star)
});
Image newImage = new Image()
{
};
newGrid.Children.Add(newImage);
newImage.Source = new BitmapImage(new Uri("bin/Resource/Change.png", UriKind.Relative))
{
CreateOptions = BitmapCreateOptions.IgnoreImageCache
};
Grid.SetRow(newImage, 0);
}
switch (Type_)
{
case TypeForm.Admin:
{
#region
label.Visibility = Visibility.Hidden;
textBox.Visibility = Visibility.Hidden;
buttonChange.ToolTip = "Змінити дані адміністратора";
buttonAdd.ToolTip = "Додати адміністратора";
buttonRemove.ToolTip = "Видалити адміністратора";
GridView myGrid = new GridView();
myGrid.AllowsColumnReorder = true;
GridViewColumn colum1 = new GridViewColumn();
colum1.DisplayMemberBinding = new Binding("Login");
colum1.Header = "Логін";
colum1.Width = 120;
myGrid.Columns.Add(colum1);
GridViewColumn colum2 = new GridViewColumn();
colum2.DisplayMemberBinding = new Binding("Password");
colum2.Header = "Пароль";
colum2.Width = 120;
myGrid.Columns.Add(colum2);
GridViewColumn colum3 = new GridViewColumn();
colum3.DisplayMemberBinding = new Binding("Owner");
colum3.Header = "Хто створив";
colum3.Width = 120;
myGrid.Columns.Add(colum3);
GridViewColumn colum4 = new GridViewColumn();
colum4.DisplayMemberBinding = new Binding("Date");
colum4.Header = "Коли";
colum4.Width = 85;
myGrid.Columns.Add(colum4);
listView.View = myGrid;
listView.FontSize = 16;
UpdateListView();
break;
#endregion
}
case TypeForm.Users:
{
#region
buttonAdd.Visibility = Visibility.Hidden;
buttonRemove.Visibility = Visibility.Hidden;
textBox.Text = "Пошук";
buttonChange.ToolTip = "Детальніше про користувача";
GridView myGrid = new GridView();
myGrid.AllowsColumnReorder = true;
GridViewColumn colum2 = new GridViewColumn();
colum2.DisplayMemberBinding = new Binding("Lname");
colum2.Header = "Прізвище";
colum2.Width = 90;
myGrid.Columns.Add(colum2);
GridViewColumn colum1 = new GridViewColumn();
colum1.DisplayMemberBinding = new Binding("Fname");
colum1.Header = "Им'я";
colum1.Width = 90;
myGrid.Columns.Add(colum1);
GridViewColumn colum3 = new GridViewColumn();
colum3.DisplayMemberBinding = new Binding("Count");
colum3.Header = "Спроби";
colum3.Width = 65;
myGrid.Columns.Add(colum3);
GridViewColumn colum4 = new GridViewColumn();
colum4.DisplayMemberBinding = new Binding("Online");
colum4.Header = "Онлайн";
colum4.Width = 70;
myGrid.Columns.Add(colum4);
GridViewColumn colum5 = new GridViewColumn();
colum5.DisplayMemberBinding = new Binding("Offline");
colum5.Header = "Оффлайн";
colum5.Width = 80;
myGrid.Columns.Add(colum5);
GridViewColumn colum6 = new GridViewColumn();
colum6.DisplayMemberBinding = new Binding("Passed");
colum6.Header = "Успішно";
colum6.Width = 70;
myGrid.Columns.Add(colum6);
listView.View = myGrid;
listView.FontSize = 16;
UpdateListView();
break;
#endregion
}
case TypeForm.User:
{
#region
buttonAdd.Visibility = Visibility.Hidden;
buttonRemove.Visibility = Visibility.Hidden;
using (DBWokrSql db = new DBWokrSql(Connection))
{
textBox.Text = db.GetUser(Id_user).Fname + " " + db.GetUser(Id_user).Lname;
}
textBox.FontSize = 18;
textBox.IsReadOnly = true;
buttonChange.ToolTip = "Детальніше про білет користувача";
GridView myGrid = new GridView();
myGrid.AllowsColumnReorder = true;
GridViewColumn colum1 = new GridViewColumn();
colum1.DisplayMemberBinding = new Binding("ID");
colum1.Header = "Білет №";
colum1.Width = 70;
myGrid.Columns.Add(colum1);
GridViewColumn colum2 = new GridViewColumn();
colum2.DisplayMemberBinding = new Binding("level");
colum2.Header = "Рівень";
colum2.Width = 120;
myGrid.Columns.Add(colum2);
GridViewColumn colum3 = new GridViewColumn();
colum3.DisplayMemberBinding = new Binding("date");
colum3.Header = "Дата";
colum3.Width = 85;
myGrid.Columns.Add(colum3);
GridViewColumn colum4 = new GridViewColumn();
colum4.DisplayMemberBinding = new Binding("IsOffline");
colum4.Header = "Онлайн";
colum4.Width = 80;
myGrid.Columns.Add(colum4);
GridViewColumn colum5 = new GridViewColumn();
colum5.DisplayMemberBinding = new Binding("IsPassed");
colum5.Header = "Здав";
colum5.Width = 80;
myGrid.Columns.Add(colum5);
listView.View = myGrid;
listView.FontSize = 16;
UpdateListView();
break;
#endregion
}
}
}
private void BackgroundWorker_DoWork(object sender, DoWorkEventArgs e)
{
if (!IsShow)
{
try
{
using (DBWokrSql db = new DBWokrSql(ConnectString))
{
var Ticket = db.CreateTicket(Id_level);
var user = db.GetUser(Id_user);
bool IsOnline = string.IsNullOrWhiteSpace(TicketStore);
if (user.ID != 13)
{
Id_ticket = db.AddTicket(Ticket, Id_user, !IsOnline);
}
else
{
IsTEST = true;
}
if (!IsOnline)
{
TicketStore = Path.ChangeExtension(Path.Combine(Path.GetDirectoryName(TicketStore), Path.GetFileNameWithoutExtension(TicketStore) + Id_ticket), "docx");
//Write to file
if (db.WriteTicketToWord(Ticket, user, Id_ticket, TicketStore))
{
System.Diagnostics.Process.Start("WINWORD.EXE", "\"" + TicketStore + "\"");
}
else
{
MessageBox.Show("Увага!! Помилка при створені файлу");
}
}
else
{
e.Result = new OutputParams()
{
id_Ticket = Id_ticket, Ticket_ = Ticket
};
}
}
}
catch (Exception ex)
{
e.Cancel = false;
e.Result = "Не має зв`язку з базою: " + ex.Message;
throw new Exception(ex.Message);
}
}
else
{
using (DBWokrSql db = new DBWokrSql(ConnectString))
{
e.Result = new OutputParams()
{
id_Ticket = Id_ticket, Ticket_ = db.GetTicketRezults(Id_ticket)
};
}
}
}