private void btnRemoveDocTemplate_Click(object sender, EventArgs e)
{
if (cbDocTemplate.SelectedIndex > -1)
{
if (MsgBoxHelper.Confirm("Remove this template?") == DialogResult.OK)
{
try
{
// delete tempalte file
var selectedFile = Path.Combine(_configContent.DocTemplateLocation, cbDocTemplate.SelectedItem.ToString());
File.Delete(selectedFile);
// remove file name in list
cbDocTemplate.Items.RemoveAt(cbDocTemplate.SelectedIndex);
cbDocTemplate.Text = string.Empty;
}
catch (Exception ex)
{
MsgBoxHelper.Error("Failure: " + ex.Message);
}
}
}
else
{
MsgBoxHelper.Warning("Please choose a template!");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
// update values
_configContent.Connections = cbConnection.Items.Cast <Connection>().ToList();
_configContent.CurrentConnectionName = cbConnection.SelectedIndex > -1 ? cbConnection.SelectedItem.ToString() : "";
_configContent.CurrentDocTemplateName = cbDocTemplate.SelectedIndex > -1 ? cbDocTemplate.SelectedItem.ToString() : "";
var msg = new StringWriter();
if (_configContent.IsValid(ref msg))
{
// decide need to refresh tables in main form or not
IsCurrentConnectionChanged =
!string.Equals(_configContent.CurrentConnection.Str, Config.GetInstance().Content.CurrentConnection.Str);
try
{
// save to config
Config.GetInstance().Content = _configContent;
Config.GetInstance().SaveConfig();
// close
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
MsgBoxHelper.Error("Failure: " + ex.Message);
}
}
else
{
MsgBoxHelper.Warning(msg.ToString());
}
}
private void btnRememberCheckedTables_Click(object sender, EventArgs e)
{
var checkedTables = GetCheckedTableNames();
if (checkedTables.Count > 0)
{
try
{
// save to config
var connName = Config.GetInstance().Content.CurrentConnectionName;
Config.GetInstance().Content.DocTablePackages[connName] = checkedTables;
Config.GetInstance().SaveConfig();
MsgBoxHelper.Done();
}
catch (Exception ex)
{
MsgBoxHelper.Error("Failure: " + ex.Message);
}
}
else
{
MsgBoxHelper.Warning("Please select table!");
}
}
private void btnGenerate_Click(object sender, EventArgs e)
{
var checkedTableNames = GetCheckedTableNames();
if (checkedTableNames.Count > 0)
{
try
{
// generate db document
string templatePath = Config.GetInstance().Content.CurrentDocTemplatePath;
string outputPath = Config.GetInstance().Content.OutputDocLocation + Guid.NewGuid().ToString() + ".xlsx";
_dbManager.GenerateDocument(checkedTableNames, templatePath, outputPath);
// open it
Process.Start(outputPath);
}
catch (Exception ex)
{
MsgBoxHelper.Error("Failure: " + ex.Message);
}
}
else
{
MsgBoxHelper.Warning("Please select table!");
}
}
// Event Handler
private void btnCreate_Click(object sender, EventArgs e)
{
if (this.NewConnection.IsValid())
{
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MsgBoxHelper.Warning("Please fill all info!");
}
}
private void btnConnTest_Click(object sender, EventArgs e)
{
try
{
using (var connection = new SqlConnection(NewConnection.Str))
{
connection.Open();
MsgBoxHelper.Done("SQL Connection successful.");
}
}
catch (Exception ex)
{
MsgBoxHelper.Warning("Failure: " + ex.Message);
}
}
private void btnRemoveConnection_Click(object sender, EventArgs e)
{
if (cbConnection.SelectedIndex > -1)
{
if (MsgBoxHelper.Confirm("Remove this connection?") == DialogResult.OK)
{
cbConnection.Items.RemoveAt(cbConnection.SelectedIndex);
cbConnection.Text = string.Empty;
txtConnStr.Text = string.Empty;
}
}
else
{
MsgBoxHelper.Warning("Please choose a connection!");
}
}
private void btnExportDocTemplate_Click(object sender, EventArgs e)
{
if (cbDocTemplate.SelectedIndex > -1)
{
using (var dialog = new SaveFileDialog())
{
dialog.Filter = "Excel File|*.xlsx";
dialog.Title = "Export Doc Tempalte File";
dialog.ShowDialog();
if (!string.IsNullOrWhiteSpace(dialog.FileName))
{
var selectedFile = Path.Combine(_configContent.DocTemplateLocation, cbDocTemplate.SelectedItem.ToString());
File.Copy(selectedFile, dialog.FileName, true);
MsgBoxHelper.Done();
}
}
}
else
{
MsgBoxHelper.Warning("Please choose a template!");
}
}
private void LogInSystem(object sender, RoutedEventArgs e)
{
if (capch.CapchText == CapchText.Text)
{
var user = Help.Auth(Login.Text, Pass.Text);
if (user != null)
{
if (SaveMe.IsChecked.Value)
{
Help.AuthCreateFile(Login.Text, Pass.Text);
}
LockHelper.DeleteLock(Login.Text);
SaveUserLog.SaveUser(user.Login);
Main.Main main = new Main.Main(user);
main.Show();
MainWindow mainWindow = (MainWindow)Window.GetWindow(this);
mainWindow.Close();
}
else
{
if (LockHelper.IsUserLock(Login.Text))
{
this.IsEnabled = false;
timerLock.Start();
}
else
{
LockHelper.IncrementLockUser(Login.Text);
}
MsgBoxHelper.Warning("Такого пользователя нет");
}
}
else
{
MsgBoxHelper.Warning("Капча введена не верно");
}
}
private void RegUser(object sender, RoutedEventArgs e)
{
Helpers.Authhelper authhelper = new Helpers.Authhelper();
if (Helpers.Validation.ValidationUser(
Pass.Text,
email.Text,
date.SelectedDate.Value,
FirstName.Text,
LastName.Text))
{
if (context.user.Where(i => i.Login == email.Text).Count() < 1)
{
context.user.Add(
new Model.user
{
Login = email.Text,
Password = Helpers.Encrypt.EncryptData(Pass.Text),
FistName = FirstName.Text,
LastName = LastName.Text,
MiddleName = MiddleName.Text,
DateOfBirth = date.SelectedDate
});
context.SaveChanges();
MsgBoxHelper.Info("Пользователь добавлен");
NavigationService.GoBack();
}
else
{
MsgBoxHelper.Error("Пользователь уже существует");
}
}
else
{
MsgBoxHelper.Warning("Не все поля заполнены");
}
}
