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 = "";
}
