private void button3_Click(object sender, EventArgs e) { foreach (ListViewItem item in listView2.SelectedItems) { LogIn.Insert("insert into item_defect values (" + item.SubItems[0].Text + ",'" + item.SubItems[1].Text + "','" + item.SubItems[2].Text + "');"); } }
private void button1_Click(object sender, EventArgs e) { if (DialogResult.Yes == MessageBox.Show("Is all parameters correct?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk)) { LogIn.Insert("CREATE TABLE `" + queue_no + "` ( `item_no` INT(20) NOT NULL , `item_name` VARCHAR(255) NOT NULL , `quantity` VARCHAR(255) NOT NULL , PRIMARY KEY (`item_no`));"); LogIn.Insert("insert into borrow_list (name, stud_no, subj_sect, room,time,date,faculty,exp_title) values ('" + Borrow_List() + "');"); foreach (ListViewItem item in listView1.Items) { getQuantity(item.SubItems[0].Text); final_quantity = current_quantity - Convert.ToInt32(item.SubItems[2].Text); LogIn.Insert("INSERT INTO `" + queue_no + "` (`item_no`, `item_name`, `quantity`) VALUES ('" + item.SubItems[0].Text.ToString() + "','" + item.SubItems[1].Text.ToString() + "','" + item.SubItems[2].Text.ToString() + "');"); LogIn.Insert("update item_list set quantity = '" + AES.AES_Encryption.EncryptString(final_quantity.ToString(), LogIn.strpass) + "' where item_no = " + item.SubItems[0].Text + ";"); } textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; dateTimePicker1.Value = DateTime.Now; maskedTextBox1.Text = ""; listView1.Items.Clear(); if (MessageBox.Show("Borrow Success! Returning to Login Screen.", "Success", MessageBoxButtons.OK) == DialogResult.OK) { Form login = new LogIn(); login.Show(); } } else { } }
private void button2_Click(object sender, EventArgs e) { if (fileName == "") { LogIn.Insert("update item_list set " + item_req() + "' where item_no = " + item_number + ";"); } else { File.Copy(pickedImage, @"C:\ELS\" + fileName); LogIn.Insert("update item_list set " + item_req() + "' where item_no = " + item_number + ";"); } }
private void button1_Click(object sender, EventArgs e) { foreach (ListViewItem item in listView1.SelectedItems) { foreach (ListViewItem item2 in listView2.Items) { getQuantity(item2.SubItems[0].Text); final_quantity = current_quantity + Convert.ToInt32(item2.SubItems[2].Text); LogIn.Insert("update item_list set quantity = '" + AES.AES_Encryption.EncryptString(final_quantity.ToString(), LogIn.strpass) + "' where item_no = " + item2.SubItems[0].Text + ";"); } LogIn.Insert("update borrow_list set returned = '" + AES.AES_Encryption.EncryptString("yes", LogIn.strpass) + "' where queue = " + item.SubItems[0].Text + ";"); } Populate_ListView(); listView2.Items.Clear(); }
private void button1_Click(object sender, EventArgs e) { if (textBox2.Text == textBox3.Text) { LogIn.Insert("update users set password = '******' where user_no = " + LogIn.user_no + ";"); MessageBox.Show("Change Password Success", "Information", MessageBoxButtons.OK); LogIn login = new LogIn(); login.Show(); Hide(); } else { MessageBox.Show("Passwords do not match", "Error", MessageBoxButtons.OK); textBox2.Text = null; textBox3.Text = null; } }
private void button1_Click(object sender, EventArgs e) { if (item_all_items.Checked) { LogIn.Insert("delete from item_report"); Populate_ListView("Select item_no, item_name, description, quantity from item_list;"); foreach (ListViewItem item in item_listView.Items) { LogIn.Insert("insert into item_report values (" + item.SubItems[0].Text + ", '" + item.SubItems[1].Text + "', '" + item.SubItems[2].Text + "', '" + item.SubItems[3].Text + "');"); } crystalReportViewer1.ReportSource = all_item_report; crystalReportViewer1.RefreshReport(); } else if (item_all_defects.Checked) { crystalReportViewer1.ReportSource = defect_report; crystalReportViewer1.RefreshReport(); } else if (queue_returned.Checked) { Populate_ListView("select queue, name, faculty, room, time from borrow_list where returned != 'Q/H7q5zh6RijRaImEg3zjg==';"); LogIn.Insert("delete from queue_report"); foreach (ListViewItem item in queue_listView.Items) { LogIn.Insert("insert into queue_report values (" + item.SubItems[0].Text + ", '" + item.SubItems[1].Text + "', '" + item.SubItems[2].Text + "', '" + item.SubItems[3].Text + "', '" + item.SubItems[4].Text + "');"); } crystalReportViewer1.ReportSource = defect_report; crystalReportViewer1.RefreshReport(); } else if (queue_not_returned.Checked) { MessageBox.Show("pasok"); Populate_ListView("select queue, name, faculty, room, time from borrow_list where returned = 'Q/H7q5zh6RijRaImEg3zjg==';"); LogIn.Insert("delete from queue_report"); foreach (ListViewItem item in queue_listView.Items) { LogIn.Insert("insert into `queue_report` values (" + item.SubItems[0].Text + ",'" + item.SubItems[1].Text + "','" + item.SubItems[2].Text + "','" + item.SubItems[3].Text + "','" + item.SubItems[4].Text + "');"); } crystalReportViewer1.ReportSource = queue_report; crystalReportViewer1.RefreshReport(); } }
private void button2_Click(object sender, EventArgs e) { if (isdefault) { LogIn.Insert("insert into item_list (item_name,description,quantity) values ('" + item_req() + "');"); item_name.Text = null; item_description.Text = null; item_pic1.BackgroundImage = ELS.Properties.Resources._default; item_quantity.Value = 1; } else { LogIn.Insert("insert into item_list (item_name,description,image,quantity) values ('" + item_req() + "');"); File.Copy(pickedImage, @"C:\ELS\" + fileName); item_name.Text = null; item_description.Text = null; item_pic1.BackgroundImage = ELS.Properties.Resources._default; item_quantity.Value = 1; } isdefault = true; pickedImage = ""; location = @"C:\ELS\"; fileName = ""; }