public Edit(Output output)
{
InitializeComponent();
foreach (string fileNameReplacement in AttributeHelper.GetAttributeReplacements())
{
MenuItem item = new MenuItem();
item.Header = new TextBlock()
{
Text = fileNameReplacement
};
item.Tag = fileNameReplacement;
item.Click += FileNameReplacementItem_Click;
FileNameReplacementList.Items.Add(item);
}
NameTextBox.Text = output.Name;
FileNameTextBox.Text = output.FileName;
FileFormatComboBox.ItemsSource = FileHelper.GetFileFormats();
FileFormatComboBox.SelectedValue = output.FileFormatID;
EditFileNameCheckBox.IsChecked = output.EditFileName;
NameTextBox.TextChanged += ValidateData;
FileFormatComboBox.SelectionChanged += ValidateData;
ValidateData(null, null);
FileNameTextBox.Focus();
}
private void FileNameReplacementItem_Click(object sender, RoutedEventArgs e)
{
MenuItem item = (MenuItem)sender;
int selectionStart = FileNameTextBox.SelectionStart;
FileNameTextBox.Text = FileNameTextBox.Text.Substring(0, FileNameTextBox.SelectionStart) + item.Tag.ToString() + FileNameTextBox.Text.Substring(FileNameTextBox.SelectionStart, FileNameTextBox.Text.Length - FileNameTextBox.SelectionStart);
FileNameTextBox.SelectionStart = selectionStart + item.Tag.ToString().Length;
FileNameTextBox.Focus();
}
} // архивация бекапа БД
private void FileArhiveBtn_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(FileNameTextBox.Text))
{
MessageBox.Show("Выберете Файл!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);
FileNameTextBox.Focus();
return;
}
String sourcePath = FileNameTextBox.Text;
using (ZipFile zip = ZipFile.Read(sourcePath))
{
zip.ExtractAll(@"C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup", ExtractExistingFileAction.DoNotOverwrite);
}
Server srv = new Server("DESKTOP-EPNEITS");
Database db = default(Database);
db = srv.Databases["Rating"];
int recoverymod;
recoverymod = (int)db.DatabaseOptions.RecoveryModel;
BackupDeviceItem bdi = default(BackupDeviceItem);
bdi = new BackupDeviceItem("Rating " + DateTime.Now.ToString("yyyy-MM-dd") + " Backup", DeviceType.File);
Restore rs = new Restore();
rs.NoRecovery = true;
rs.Devices.Add(bdi);
rs.Database = "Rating";
// rs.SqlRestore(srv);
db = srv.Databases["Rating"];
rs.Devices.Remove(bdi);
rs.NoRecovery = false;
db.RecoveryModel = (RecoveryModel)recoverymod;
db.Alter();
MessageBox.Show("Восстановление данных прошло успешно!");
}
catch
{
MessageBox.Show("Данный файл не является архивом, либо не относиться к текущей базе данных!");
}
} // Восстановление архива
public Send(string fileName)
{
InitializeComponent();
FileNameTextBox.Text = fileName;
FileNameTextBox.TextChanged += ValidateData;
ValidateData(null, null);
FileNameTextBox.SelectAll();
FileNameTextBox.Focus();
}
private void LoadAndHashFile(string path)
{
try
{
_fileContents = System.IO.File.ReadAllBytes(path);
}
catch (Exception ex)
{
string msg = "The file cannot be read.\nSystem Message:\n " + ex.Message;
MessageBox.Show(msg, "File Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
FileNameTextBox.Focus();
return;
}
_fileHash = new SHA1CryptoServiceProvider().ComputeHash(_fileContents);
}
private void StopRecording(object obj)
{
_pendingSave = _recorder.Stop();
var defaultFileName = DateTime.Now.ToString("yyyy-MM-dd hh-mm-ss");
Dispatcher.BeginInvoke(delegate()
{
FileNameTextBox.Text = defaultFileName;
FileNameTextBox.Focus();
FileNameTextBox.SelectAll();
ToggleVisibility();
RecordButton.Content = "Start Recording";
});
}
/// <summary>
/// Displays the FIT file.
/// </summary>
private void DisplayFitFile()
{
ClearDisplay();
if (fitFile != null)
{
// display the file name
FileNameTextBox.Text = fitFile.FileName;
FileNameTextBox.Focus();
FileNameTextBox.Select(FileNameTextBox.Text.Length, 0);
// display the record summary
NumRecordsLabel.Content = fitFile.Records.Count.ToString();
NumLengthsLabel.Content = fitFile.Lengths.Count.ToString();
NumLapsLabel.Content = fitFile.Laps.Count.ToString();
NumSessionsLabel.Content = fitFile.Sessions.Count.ToString();
FitRecord last = fitFile.Records[fitFile.Records.Count - 1];
TimeLabel.Content = (last.Timestamp - fitFile.Records[0].Timestamp).ToString();
DistanceLabel.Content = (last.Distance ?? 0).ToString("0.#");
FitRecordSummary summary = fitFile.Records.Summary;
AverageCadenceLabel.Content = summary.AveCadence.ToString("0");
AverageHeartRateLabel.Content = summary.AveHeartRate.ToString("0");
AveragePowerLabel.Content = summary.AvePower.ToString("0");
AverageSpeedLabel.Content = summary.AveSpeed.ToString("0.#");
MaxCadenceLabel.Content = summary.MaxCadence.ToString();
MaxHeartRateLabel.Content = summary.MaxHeartRate.ToString();
MaxPowerLabel.Content = summary.MaxPower.ToString();
MaxSpeedLabel.Content = summary.MaxSpeed.ToString("0.#");
// display the data grids
FileIDDataGrid.ItemsSource = GetNonNullPropertiesValues(typeof(FitFileID), fitFile.FileID);
DeviceInfoDataGrid.ItemsSource = fitFile.DeviceInfos;
UserProfileDataGrid.ItemsSource = GetNonNullPropertiesValues(typeof(FitUserProfile), fitFile.UserProfile);
ActivityDataGrid.ItemsSource = GetNonNullPropertiesValues(typeof(FitActivity), fitFile.Activity);
SessionsDataGrid.ItemsSource = fitFile.Sessions;
LapsDataGrid.ItemsSource = fitFile.Laps;
LengthsDataGrid.ItemsSource = fitFile.Lengths;
RecordsDataGrid.ItemsSource = fitFile.Records;
MessagesDataGrid.ItemsSource = fitFile.Messages;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//Application.Current.MainWindow = this;
FileNameTextBox.Focus();
}