private void Export()
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.FileName = currentsnippet._Name; // Default file name
dlg.DefaultExt = ".text"; // Default file extension
dlg.Filter = "Text documents (.txt)|*.txt"; // Filter files by extension
// Show save file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process save file dialog box results
if (result == true)
{
StreamWriter writer = new StreamWriter(dlg.OpenFile());
writer.Write(currentsnippet._Code);
writer.Dispose();
writer.Close();
string filename = dlg.FileName;
}
ControlState.Execute(c, ControlStateVisuals.Background);
}
private void Register_btn_Click(object sender, RoutedEventArgs e)
{
//Get all values from the Controls
RegisterData i = new RegisterData(
PasswordOne.Password.ToString(),
FirstName.Text,
MiddleName.Text,
LastName.Text,
DayOfBirth.Text,
Email.Text,
int.Parse(TelNr.Text),
CustomerRoll.Private,
int.Parse(IBAN.Text),
PostalCode.Text,
Street.Text,
int.Parse(PostalCode.Text),
Place.Text,
Country.Text
);
//Check if all Controlss are filled
if (ControlState.Execute(c, ControlStateVisuals.Colored))
{
//If all controlls are filled
RegisterController.RegisterNewCustomer(i);
}
else
{
//If all controll are not filled
MessageBox.Show("Failed");
}
}
private void DeleteNow()
{
DbSnippets.DeleteSnippet(currentsnippet._ID);
Nav.FilterCodeSnippeds();
ControlState.Execute(c, ControlStateVisuals.Background);
Clear();
}
private void SaveAsNew()
{
if (ControlState.Execute(c, ControlStateVisuals.Colored))
{
TextRange Coderange = new TextRange(Code.Document.ContentStart, Code.Document.ContentEnd);
TextRange Usagerange = new TextRange(Usage.Document.ContentStart, Usage.Document.ContentEnd);
TextRange Descriptionrange = new TextRange(Description.Document.ContentStart, Description.Document.ContentEnd);
SnippetInfo info = new SnippetInfo(
0,
UserInfo.Userinformation.ID,
0,
Name.Text,
Coderange.Text,
DateTime.Now,
Usagerange.Text,
DateTime.Now,
Descriptionrange.Text,
DateTime.Now,
DbCodeLanguage.ToID(Language.SelectedItem.ToString()),
DateTime.Now
);
DbSnippets.AddNewSnippet(info);
if (Nav != null)
{
Nav.FilterCodeSnippeds();
}
ControlState.Execute(c, ControlStateVisuals.Background);
Clear();
}
}
//Key-Handlers
private void Login_btn_Click(object sender, RoutedEventArgs e)
{
Control[] c = { LoginName_txt, Password_txt };
if (ControlState.Execute(c, ControlStateVisuals.Colored))
{
LoginHandler.LoginNow(LoginName_txt.Text, Password_txt.Text, this);
}
}
private void Register_btn_Click(object sender, RoutedEventArgs e)
{
Control[] c = { FirstName_txt, MiddleName_txt, LastName_txt, Email_txt, Password_txt, PasswordSecond_txt };
RegisterInfo info = new RegisterInfo(FirstName_txt.Text, MiddleName_txt.Text, LastName_txt.Text, Email_txt.Text, Password_txt.Text);
if (ControlState.Execute(c, ControlStateVisuals.Colored))
{
RegisterHandler.RegisterNow(info);
}
}
internal static AnimatorState Execute(object control, WaitCallback queueMethod, BaseThreadParam queueMethodParam)
{
if (control == null)
{
return(null);
}
lock (animeControls)
{
ControlState controlState = GetControlState(control, queueMethodParam.queueName);
return(controlState.Execute(queueMethod, queueMethodParam));
}
}
//Write to database
private void RegisterNow()
{
//All Contorls
List <Control_> controls = new List <Control_>
{
new Control_(FirstName_txt, Visuals.Colored),
new Control_(MiddleName_txt, Visuals.Colored),
new Control_(LastName_txt, Visuals.Colored),
new Control_(Email_txt, Visuals.Colored),
new Control_(Password_txt, Visuals.Colored),
new Control_(PasswordSecond_txt, Visuals.Colored)
};
//If all fields are filled in
if (ControlState.Execute(controls, Visuals.Colored))
{
using (MySqlConnection connection = DbInfo.Connection())
{
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText =
"INSERT INTO `users`(`ID`, `Firstname`, `Middlename`, `Lastname`, `Email`, `Password`, `Pin`) " +
"VALUES (@ID,@Firstname,@Middlename,@Lastname,@Email,@Password,@Pin)";
command.Parameters.AddWithValue("@ID", "");
command.Parameters.AddWithValue("@Firstname", FirstName_txt.Text);
command.Parameters.AddWithValue("@Middlename", MiddleName_txt.Text);
command.Parameters.AddWithValue("@Lastname", LastName_txt.Text);
command.Parameters.AddWithValue("@Email", Email_txt.Text);
command.Parameters.AddWithValue("@Password", Password_txt.Text);
command.Parameters.AddWithValue("@Pin", int.Parse("0"));
try
{
//connection.Open();
int recordsAffected = command.ExecuteNonQuery();
MessageBox.Show("person has added");
}
catch (SqlException)
{
throw;
}
finally
{
connection.Close();
}
}
}
}
}
private void Clear()
{
Name.Text = string.Empty;
Language.Items.Clear();
SetUI.CodeLanguageToCombobox(Language);
Language.Items.Remove("All");
Language.SelectedIndex = 0;
Usage.Document.Blocks.Clear();
Description.Document.Blocks.Clear();
Code.Document.Blocks.Clear();
ControlState.Execute(c, ControlStateVisuals.Background);
}
private void Login_btn_Click(object sender, RoutedEventArgs e)
{
//All Contorls
List <Control_> controls = new List <Control_>
{
new Control_(LoginName_txt, Visuals.Colored),
new Control_(Password_txt, Visuals.Colored)
};
//If all fields are filled in
if (ControlState.Execute(controls, Visuals.Colored))
{
LoginHandler.LoginNow(LoginName_txt.Text, Password_txt.Text, this);
this.Close();
}
}
private void SaveNow()
{
currentsnippet._Name = Name.Text;
currentsnippet._LanguageID = DbCodeLanguage.ToID(Language.SelectedItem.ToString());
TextRange range = new TextRange(Usage.Document.ContentStart, Usage.Document.ContentEnd);
currentsnippet._UsageExample = range.Text;
TextRange range1 = new TextRange(Description.Document.ContentStart, Description.Document.ContentEnd);
currentsnippet._UsageExample = range1.Text;
TextRange range2 = new TextRange(Code.Document.ContentStart, Code.Document.ContentEnd);
currentsnippet._UsageExample = range2.Text;
DbSnippets.UpdateSnippet(currentsnippet);
Nav.FilterCodeSnippeds();
ControlState.Execute(c, ControlStateVisuals.Background);
Clear();
}
