private void issuanceRecordsToolStripMenuItem_Click(object sender, EventArgs e) { if (mIssue == null) { mIssue = new ManageIssue(); mIssue.MdiParent = this; mIssue.FormClosed += MIssue_FormClosed; mIssue.WindowState = FormWindowState.Maximized; mIssue.Show(); } else { mIssue.Activate(); } }
//manage book issuance private void button4_Click(object sender, EventArgs e) { if (mIssue == null) { mIssue = new ManageIssue(); mIssue.MdiParent = this.MdiParent; mIssue.WindowState = FormWindowState.Maximized; mIssue.FormClosed += MIssue_FormClosed; mIssue.Show(); //advanceBookSearchToolStripMenuItem.Enabled = true; //idShortcut = mbooks.delBookID; } else { mIssue.Activate(); } }
private void MIssue_FormClosed(object sender, FormClosedEventArgs e) { mIssue = null; //throw new NotImplementedException(); }
//search button private void button1_Click(object sender, EventArgs e) { try { string query; if (comboBox1.SelectedIndex == 0)//issueId { query = "SELECT tblissued.issuedid AS ID, tblissued.issueddaate AS IssueDate, tblissued.returndate AS ReturnDate, tblissued.qty AS Quantity, tblbook.city AS CAN, tblbook.Name AS BookName, tblbook.Edition AS Edition, tblemp.name AS Employee, lbldept.deptname AS Department, tblissued.status AS Status, tblcatagory.Desc AS Category, tblbook.oldaccessionno AS AccNo, tblbook.bookid AS BookID FROM lbldept INNER JOIN ((tblemp INNER JOIN (tblbook INNER JOIN tblissued ON tblbook.bookid=tblissued.bookid) ON tblemp.empid=tblissued.empid) INNER JOIN tblcatagory ON tblbook.catagoryid=tblcatagory.catagoryid) ON lbldept.deptid=tblemp.deptid WHERE tblissued.issuedid "; } else if (comboBox1.SelectedIndex == 1)//bookName { query = "SELECT tblissued.issuedid AS ID, tblissued.issueddaate AS IssueDate, tblissued.returndate AS ReturnDate, tblissued.qty AS Quantity, tblbook.city AS CAN, tblbook.Name AS BookName, tblbook.Edition AS Edition, tblemp.name AS Employee, lbldept.deptname AS Department, tblissued.status AS Status, tblcatagory.Desc AS Category, tblbook.oldaccessionno AS AccNo, tblbook.bookid AS BookID FROM lbldept INNER JOIN ((tblemp INNER JOIN (tblbook INNER JOIN tblissued ON tblbook.bookid=tblissued.bookid) ON tblemp.empid=tblissued.empid) INNER JOIN tblcatagory ON tblbook.catagoryid=tblcatagory.catagoryid) ON lbldept.deptid=tblemp.deptid WHERE tblbook.Name "; } else if (comboBox1.SelectedIndex == 2)//accNo { query = "SELECT tblissued.issuedid AS ID, tblissued.issueddaate AS IssueDate, tblissued.returndate AS ReturnDate, tblissued.qty AS Quantity, tblbook.city AS CAN, tblbook.Name AS BookName, tblbook.Edition AS Edition, tblemp.name AS Employee, lbldept.deptname AS Department, tblissued.status AS Status, tblcatagory.Desc AS Category, tblbook.oldaccessionno AS AccNo, tblbook.bookid AS BookID FROM lbldept INNER JOIN ((tblemp INNER JOIN (tblbook INNER JOIN tblissued ON tblbook.bookid=tblissued.bookid) ON tblemp.empid=tblissued.empid) INNER JOIN tblcatagory ON tblbook.catagoryid=tblcatagory.catagoryid) ON lbldept.deptid=tblemp.deptid WHERE tblbook.oldaccessionno "; } else if (comboBox1.SelectedIndex == 3)//can { query = "SELECT tblissued.issuedid AS ID, tblissued.issueddaate AS IssueDate, tblissued.returndate AS ReturnDate, tblissued.qty AS Quantity, tblbook.city AS CAN, tblbook.Name AS BookName, tblbook.Edition AS Edition, tblemp.name AS Employee, lbldept.deptname AS Department, tblissued.status AS Status, tblcatagory.Desc AS Category, tblbook.oldaccessionno AS AccNo, tblbook.bookid AS BookID FROM lbldept INNER JOIN ((tblemp INNER JOIN (tblbook INNER JOIN tblissued ON tblbook.bookid=tblissued.bookid) ON tblemp.empid=tblissued.empid) INNER JOIN tblcatagory ON tblbook.catagoryid=tblcatagory.catagoryid) ON lbldept.deptid=tblemp.deptid WHERE tblbook.city "; } else if (comboBox1.SelectedIndex == 4)//employeeName { query = "SELECT tblissued.issuedid AS ID, tblissued.issueddaate AS IssueDate, tblissued.returndate AS ReturnDate, tblissued.qty AS Quantity, tblbook.city AS CAN, tblbook.Name AS BookName, tblbook.Edition AS Edition, tblemp.name AS Employee, lbldept.deptname AS Department, tblissued.status AS Status, tblcatagory.Desc AS Category, tblbook.oldaccessionno AS AccNo, tblbook.bookid AS BookID FROM lbldept INNER JOIN ((tblemp INNER JOIN (tblbook INNER JOIN tblissued ON tblbook.bookid=tblissued.bookid) ON tblemp.empid=tblissued.empid) INNER JOIN tblcatagory ON tblbook.catagoryid=tblcatagory.catagoryid) ON lbldept.deptid=tblemp.deptid WHERE tblemp.name "; } else //for 5 status { query = "SELECT tblissued.issuedid AS ID, tblissued.issueddaate AS IssueDate, tblissued.returndate AS ReturnDate, tblissued.qty AS Quantity, tblbook.city AS CAN, tblbook.Name AS BookName, tblbook.Edition AS Edition, tblemp.name AS Employee, lbldept.deptname AS Department, tblissued.status AS Status, tblcatagory.Desc AS Category, tblbook.oldaccessionno AS AccNo, tblbook.bookid AS BookID FROM lbldept INNER JOIN ((tblemp INNER JOIN (tblbook INNER JOIN tblissued ON tblbook.bookid=tblissued.bookid) ON tblemp.empid=tblissued.empid) INNER JOIN tblcatagory ON tblbook.catagoryid=tblcatagory.catagoryid) ON lbldept.deptid=tblemp.deptid WHERE tblissued.status "; } string filterString; switch (comboBox2.SelectedIndex) { case 0: //contains filterString = "like('%" + textBox1.Text + "%')"; break; case 1: //is equal to filterString = "= '" + textBox1.Text + "'"; break; case 2: //not equal to filterString = "<> '" + textBox1.Text + "'"; break; case 3: //is greater than filterString = "> '" + textBox1.Text + "'"; break; case 4: //is greater than or equal to filterString = ">= '" + textBox1.Text + "'"; break; case 5: //is less than filterString = "< '" + textBox1.Text + "'"; break; default: // 6 //is less than or equal to filterString = "<= '" + textBox1.Text + "'"; break; } ManageIssue missue = (ManageIssue)Application.OpenForms["ManageIssue"]; query = query + filterString; SQLiteCommand myCommand = new SQLiteCommand(query, db.myConnection); db.OpenConnection(); var result = myCommand.ExecuteNonQuery(); //mbooks.dataGridView1.DataSource = null; // mbooks.dataGridView1.Rows.Clear(); DataTable dt = new DataTable(); SQLiteDataAdapter da = new SQLiteDataAdapter(myCommand); da.Fill(dt); if (dt.Rows.Count > 0) { missue.dataGridView1.DataSource = dt; missue.recordText.Text = ""; this.Close(); } else { MessageBox.Show("No Records Found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } db.CloseConnection(); // MessageBox.Show(Convert.ToString(result)); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }