private void saveButton_Click(object sender, EventArgs e) { SQLQuery mSQLQuery = new SQLQuery(); if (childName.Text.Length >= 2) { ImageOperation OP = new ImageOperation(); Program.parentSignUpForm.ChildOfParent(childName.Text, DOBpicker.Value, Gender, OP.ImageToBinary(image)); MessageBox.Show("Requset has been sent", "Request sent", MessageBoxButtons.OK, MessageBoxIcon.None); this.Hide(); } else { MessageBox.Show("Please Enter atleast 2 letter", "Invaild Child Name", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void viewGride() { DataTable pennding = new DataTable(); DataTable pennding2 = new DataTable(); SQLQuery MyQuery = new SQLQuery(); // staff pennding list veiw load pennding = MyQuery.getPendingStaff(); foreach (DataRow row in pennding.Rows) { ListViewItem item = new ListViewItem(row[1].ToString()); for (int i = 2; i <= 4; i++) { item.SubItems.Add(row[i].ToString()); } staffListView.Items.Add(item); } staffListView.View = View.Details; staffListView.FullRowSelect = true; // parents pennding list veiw laod pennding = MyQuery.getPendingParent(); foreach (DataRow row in pennding.Rows) { ListViewItem item = new ListViewItem(row[1].ToString()); item.SubItems.Add(row[2].ToString()); item.SubItems.Add(row[4].ToString()); item.SubItems.Add(row[6].ToString()); parentsListView.Items.Add(item); } parentsListView.View = View.Details; parentsListView.FullRowSelect = true; // Child Pending listview laod pennding = MyQuery.getPendingChild(); foreach (DataRow row in pennding.Rows) { ListViewItem item = new ListViewItem(row[0].ToString()); item.SubItems.Add(row[1].ToString()); Int64 x = Int64.Parse(row[2].ToString()); pennding2 = MyQuery.getParentByID(x); string parentName = ""; foreach (DataRow row2 in pennding2.Rows) { parentName = row[1].ToString(); } item.SubItems.Add(parentName); ImageOperation OP = new ImageOperation(); byte[] location = (byte[])(row[7]); Image img = OP.BinaryToImage(location); childImageList.Images.Add(row[0].ToString(), img); childImage.Image = img; childListView.Items.Add(item); } childListView.View = View.Details; childListView.FullRowSelect = true; }