private void Button_Click_1(object sender, RoutedEventArgs e)
{
Textbox1.Clear();
Textbox2.Clear();
Textbox3.Clear();
radioButton1.IsChecked = false;
radioButton2.IsChecked = false;
}
private void LoginsEditForm_Load(object sender, EventArgs e)
{
UserTbox.Text = Textbox1;
PasswordTbox.Text = Textbox2;
//PrivComboBox.Text = Textbox3;
string Priv = Textbox3.Trim();
PrivComboBox.Items.Add("Edit");
PrivComboBox.Items.Add("View");
if (Priv == "Edit")
{
PrivComboBox.SelectedIndex = PrivComboBox.FindStringExact("Edit");
}
if (Priv == "View")
{
PrivComboBox.SelectedIndex = PrivComboBox.FindStringExact("View");
}
}
private void Textbox3_TextChanged(object sender, TextChangedEventArgs e)
{
string texto = "";
for (int i = 0; i < Textbox3.Text.Length; i++)
{
if (Textbox3.Text[i] != 'a' &&
Textbox3.Text[i] != 'e' &&
Textbox3.Text[i] != 'i' &&
Textbox3.Text[i] != 'o' &&
Textbox3.Text[i] != 'o' &&
Textbox3.Text[i] != 'u' &&
Textbox3.Text[i] != 'A' &&
Textbox3.Text[i] != 'E' &&
Textbox3.Text[i] != 'I' &&
Textbox3.Text[i] != 'O' &&
Textbox3.Text[i] != 'U')
{
texto += Textbox3.Text[i].ToString();
}
}
Textbox3.Select(texto.Length, 0);
Textbox3.Text = texto;
}
private void button1_Click(object sender, EventArgs e)
{
String connection = "Provider=OraOLEDB.Oracle;Data Source=localhost;Workspace=Malcolm;User Id=MALCOLM;Password=madeira;OLEDB.NET=True";
OleDbConnection obj1 = new OleDbConnection(connection);
string S3 = ComboBox1.SelectedItem.ToString(); //sex
string S1 = ComboBox2.SelectedItem.ToString();
string S2 = Textbox5.Text + 8; //For ID
if (ComboBox2.SelectedItem.ToString() == "Employee")
{
if (Textbox6.Text == Textbox7.Text)
{
String q2 = "insert into Login values ('" + Textbox5.Text + "','" + Textbox6.Text + "','" + S1 + "')";
obj1.Open();
try
{
OleDbCommand cm2 = new OleDbCommand(q2, obj1);
cm2.ExecuteNonQuery();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
else
{
MessageBox.Show("**********Password Don't Match\nPlease Re-ENTER*********");
}
//Employee details
String q3 = "insert into EMPLOYEE values ('" + S2 + "','" + Textbox5.Text + "','" + Textbox2.Text + "','" + Textbox1.Text + "','" + Textbox3.Text + "','" + S3 + "')";
try
{
OleDbCommand cm2 = new OleDbCommand(q3, obj1);
cm2.ExecuteNonQuery();
MessageBox.Show("************Record Insert Successfully*********");
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
if (ComboBox2.SelectedItem.ToString() == "Customer")
{
if (Textbox6.Text == Textbox7.Text)
{
String q4 = "insert into Login values ('" + Textbox5.Text + "','" + Textbox6.Text + "','" + ComboBox2.SelectedItem.ToString() + "')";
obj1.Open();
try
{
OleDbCommand cm2 = new OleDbCommand(q4, obj1);
cm2.ExecuteNonQuery();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
else
{
MessageBox.Show("**********Password Don't Match\nPlease Re-ENTER*********");
}
//Customer details
String q3 = "insert into CUSTOMER values ('" + Textbox5.Text + "','" + S2 + "','" + Textbox2.Text + "','" + Textbox1.Text + "','" + Textbox3.Text + "','" + S3 + "')";
try
{
OleDbCommand cm2 = new OleDbCommand(q3, obj1);
cm2.ExecuteNonQuery();
MessageBox.Show("************Record Insert Successfully*********");
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
Textbox5.Clear();
Textbox6.Clear();
Textbox7.Clear();
Textbox1.Clear();
Textbox2.Clear();
Textbox3.Clear();
}
private void button2_Click(object sender, EventArgs e)
{
Textbox1.Clear();
Textbox2.Clear();
Textbox3.Clear();
}
private void SubmitButton_Click(object sender, RoutedEventArgs e)
{
string nombre, apellidos, dni, fechanac;
int peso = 0, altura = 0;
nombre = Textbox1.Text;
apellidos = Textbox2.Text;
dni = Textbox3.Text;
fechanac = date.Text;
if (!String.IsNullOrEmpty(Textbox5.Text))
{
peso = Convert.ToInt32(Textbox5.Text);
}
if (!String.IsNullOrEmpty(Textbox6.Text))
{
altura = Convert.ToInt32(Textbox6.Text);
}
Persona persona = new Persona(nombre, apellidos, dni, fechanac, peso, altura);
int nope = 0;
for (int i = 0; i < Personas.GetPersonas().Count; i++)
{
if (Personas.GetPersonas()[i].Dni == persona.Dni)
{
nope = 1;
SoundPlayer My_JukeBox = new SoundPlayer(@"Sounds/nope.wav");
try
{
My_JukeBox.Play();
}
catch (FileNotFoundException ex)
{
Console.WriteLine(ex);
}
MessageBox.Show("Ya hay una persona con el mismo DNI");
}
}
if (nope == 0)
{
SoundPlayer My_JukeBox2 = new SoundPlayer(@"Sounds/item.wav");
try
{
My_JukeBox2.Play();
}
catch (FileNotFoundException ex)
{
// Write error.
Console.WriteLine(ex);
}
Personas.addPersona(persona);
Task.Delay(700).Wait();
this.Close();
}
else
{
Textbox1.Clear();
Textbox2.Clear();
Textbox3.Clear();
Textbox6.Clear();
Textbox5.Clear();
date.ClearValue(DatePicker.SelectedDateProperty);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
var std = new Zam();
if (Textbox1.Text == "")
{
throw new Exception("Проверьте ввода Краткое название");
}
else
{
std.Kratkoe_nazvaniye = Textbox1.Text;
}
if (Textbox2.Text == "")
{
throw new Exception("Проверьте ввода Катигория");
}
else
{
std.Katigoria = Textbox2.Text;
}
if (Textbox3.Text == "")
{
throw new Exception("Проверьте ввода Полное описание");
}
else
{
std.Polnoe_opisanie = Textbox3.Text;
}
std.datetime = DateTime.Now;
std.Status = false;
switch (radioButton1.IsChecked)
{
case true when radioButton2.IsChecked == false:
std.Preoritet = "Первый";
break;
case false when radioButton2.IsChecked == true:
std.Preoritet = "Второй";
break;
case false when radioButton2.IsChecked == false:
throw new Exception("Необходимо выбрать преоритет");
}
std_list.Add(std);
MessageBox.Show("Задача сохранена");
Textbox1.Clear();
Textbox2.Clear();
Textbox3.Clear();
Textbox4.Clear();
Textbox4.Text = Convert.ToString(std.datetime);
radioButton1.IsChecked = false;
radioButton2.IsChecked = false;
if (std_list.Count != 0)
{
DataContractJsonSerializer jsonFormatter2 = new DataContractJsonSerializer(typeof(List <Zam>));
using (FileStream fs = new FileStream("D:\\фит\\ООП\\2 семестр лабы\\7_8\\doowr.json", FileMode.OpenOrCreate))
{
if (fs.Length != 0)
{
std_list3 = (List <Zam>)jsonFormatter2.ReadObject(fs);
}
}
// создаем объект Json
DataContractJsonSerializer jsonFormatter = new DataContractJsonSerializer(typeof(List <Zam>));
// получаем поток, куда будем записывать сериализованный объект
for (int i = 0; i < std_list3.Count; i++)
{
std_list.Add(std_list3[i]);
}
using (FileStream fs = new FileStream("D:\\фит\\ООП\\2 семестр лабы\\7_8\\doowr.json", FileMode.Create))
{
jsonFormatter.WriteObject(fs, std_list);
}
std_list.Clear();
}
else
{
throw new Exception("Список пуст");
}
}
catch (Exception ex)
{
MessageBox.Show("Ошибка: " + ex.Message, "Предупреждение!");
}
}
