private void Button_Click_1(object sender, RoutedEventArgs e)
{
Textbox1.Clear();
Textbox2.Clear();
Textbox3.Clear();
radioButton1.IsChecked = false;
radioButton2.IsChecked = false;
}
private void Delete2_Click(object sender, EventArgs e)
{
int counter = 0;
counter = SQLiteConnect.counterID("genre", beforeListview2ID);
if (counter != 0)
{
MessageBox.Show("データが" + counter + "件存在するため、削除できません。", "警告", MessageBoxButtons.OK);
return;
}
string deletequery;
DialogResult res = MessageBox.Show(beforeListview2Title + "を削除しますか？", "削除確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
deletequery = "delete from t_genre where genre_id =" + beforeListview2ID;
SQLiteConnect.Excute(deletequery);
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select genre_ID,genre_title from t_genre", "genre_ID", "genre_title");
Textbox2.Clear(); //リフレッシュ処理
}
}
private void Delete2_Click(object sender, EventArgs e)//要素削除 本棚の場所
{
string deletequery;
int counter = 0;
counter = SQLiteConnect.counterID2("place", beforeListView1ID, "bookShelf", beforeListview2ID);
if (counter != 0)
{
MessageBox.Show("データが" + counter + "件存在するため、削除できません。", "警告", MessageBoxButtons.OK);
return;
}
DialogResult res = MessageBox.Show(beforeListview2Title + "を削除しますか？", "削除確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
deletequery = "delete from t_house_shelf where place_ID =" + beforeListView1ID
+ " and bookShelf_ID = " + beforeListview2ID;
SQLiteConnect.Excute(deletequery);
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select bookShelf_ID,shelf_name from t_house_shelf where place_ID = " + beforeListView1ID, "bookShelf_ID", "shelf_name");
Textbox2.Clear();
}
}
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, "Предупреждение!");
}
}
