private void take_attendance_Click(object sender, EventArgs e) { imageBoxFrameGrabber.Visible = false; panel1.Visible = false; panel2.Visible = false; imageBoxFrameGrabber.Visible = true; panel1.Visible = true; Boolean a = false; string connectionString = "Data Source = localhost; User ID = root; Password = toor123; Database=attendance; pooling = false; port = 3306; Allow User Variables = true; SslMode = none"; MySqlConnection Conn = new MySqlConnection(connectionString); Conn.Open(); if (Conn.State == ConnectionState.Open) { //MessageBox.Show("Connection is Active."); //konek.Close(); } MySqlCommand command = Conn.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "SELECT COLUMN_NAME FROM Information_Schema.columns WHERE TABLE_SCHEMA='attendance';"; DateTime date = DateTime.Now; MySqlDataReader Reader2; Reader2 = command.ExecuteReader(); while (Reader2.Read()) { string b = Convert.ToString(Reader2[0]); if (b == date.ToString("M/d/yy")) { a = false; break; } else { a = true; } } Reader2.Close(); Reader2.Dispose(); if (a == true) { string add_column = "ALTER TABLE `students` ADD `" + date.ToString("M/d/yy") + "` VARCHAR(10) NOT NULL AFTER `Name`;"; MySqlCommand cmd = Conn.CreateCommand(); cmd.CommandText = add_column; Reader2 = cmd.ExecuteReader(); Reader2.Close(); Reader2.Dispose(); } Conn.Close(); }
void FrameGrabber(object sender, EventArgs e) { label3.Text = "0"; //label4.Text = ""; NamePersons.Add(""); //Get the current frame form capture device currentFrame = grabber.QueryFrame().Resize(320, 240, Emgu.CV.CvEnum.INTER.CV_INTER_CUBIC); //Convert it to Grayscale gray = currentFrame.Convert <Gray, Byte>(); //Face Detector MCvAvgComp[][] facesDetected = gray.DetectHaarCascade( face, 1.2, 10, Emgu.CV.CvEnum.HAAR_DETECTION_TYPE.DO_CANNY_PRUNING, new Size(20, 20)); //Action for each element detected foreach (MCvAvgComp f in facesDetected[0]) { t = t + 1; result = currentFrame.Copy(f.rect).Convert <Gray, byte>().Resize(100, 100, Emgu.CV.CvEnum.INTER.CV_INTER_CUBIC); //draw the face detected in the 0th (gray) channel with blue color currentFrame.Draw(f.rect, new Bgr(Color.Red), 2); if (trainingImages.ToArray().Length != 0) { MCvTermCriteria termCrit = new MCvTermCriteria(ContTrain, 0.001); EigenObjectRecognizer recognizer = new EigenObjectRecognizer( trainingImages.ToArray(), labels.ToArray(), 3000, ref termCrit); name = recognizer.Recognize(result); currentFrame.Draw(name, ref font, new Point(f.rect.X - 2, f.rect.Y - 2), new Bgr(Color.LightGreen)); } NamePersons[t - 1] = name; NamePersons.Add(""); label3.Text = facesDetected[0].Length.ToString(); } t = 0; for (int nnn = 0; nnn < facesDetected[0].Length; nnn++) { names = names + NamePersons[nnn] + ", "; if (panel2.Visible == false) { string connectionString = "Data Source = localhost; User ID = root; Password = toor123; Database=attendance; pooling = false; port = 3306; Allow User Variables = true; SslMode = none"; MySqlConnection Conn = new MySqlConnection(connectionString); Conn.Open(); if (Conn.State == ConnectionState.Open) { MySqlDataReader Reader2; //konek.Close(); DateTime date = DateTime.Now; string mark_attendance = "UPDATE `students` SET `" + date.ToString("M/d/yy") + "` = 'P' WHERE `students`.`Name` = '" + NamePersons[nnn] + "';"; MySqlCommand cmd2 = Conn.CreateCommand(); cmd2.CommandText = mark_attendance; Reader2 = cmd2.ExecuteReader(); Reader2.Close(); Reader2.Dispose(); } Conn.Close(); } } imageBoxFrameGrabber.Image = currentFrame; label4.Text = names; names = ""; NamePersons.Clear(); }
public Form3() { InitializeComponent(); string myConnnection = "datasource=localhost; port=3306;username=root;password=Sercan.123; "; MySqlConnection myConn = new MySqlConnection(myConnnection); myConn.Open(); MySqlCommand command = new MySqlCommand(); command = myConn.CreateCommand(); command.CommandText = "SELECT schema_name FROM information_schema.schemata where schema_name not like '%_schema' and schema_name not like 'mysql';"; MySqlDataReader Reader1; Reader1 = command.ExecuteReader(); while (Reader1.Read()) { string row = ""; for (int i = 0; i < Reader1.FieldCount; i++) { row += Reader1.GetValue(i).ToString(); } trV1.Nodes.Add(row); } for (int i = 0; i < trV1.Nodes.Count; i++) { trV1.Nodes[i].Nodes.Add("Tables"); trV1.Nodes[i].Nodes.Add("Views"); trV1.Nodes[i].Nodes.Add("Stored Procedure"); trV1.Nodes[i].Nodes.Add("Functions "); } Reader1.Close(); Reader1.Dispose(); myConn.Close(); myConn.Open(); MySqlCommand command_table = new MySqlCommand(); command_table = myConn.CreateCommand(); for (int i = 0; i < trV1.Nodes.Count; i++) { command_table.CommandText = "SELECT table_name FROM information_schema.tables WHERE table_schema ='" + trV1.Nodes[i].Text + "' "; MySqlDataReader Reader2; Reader2 = command_table.ExecuteReader(); while (Reader2.Read()) { string table = ""; for (int j = 0; j < Reader2.FieldCount; j++) { table += Reader2.GetValue(j).ToString(); } trV1.Nodes[i].Nodes[0].Nodes.Add(table); } Reader2.Close(); Reader2.Dispose(); } myConn.Close(); myConn.Open(); MySqlCommand command_view = new MySqlCommand(); command_view = myConn.CreateCommand(); for (int i = 0; i < trV1.Nodes.Count; i++) { command_view.CommandText = "SELECT table_name FROM information_schema.tables WHERE table_type='VIEW' AND table_schema ='" + trV1.Nodes[i].Text + "' "; MySqlDataReader Reader3; Reader3 = command_view.ExecuteReader(); while (Reader3.Read()) { string view = ""; for (int j = 0; j < Reader3.FieldCount; j++) { view += Reader3.GetValue(j).ToString(); } trV1.Nodes[i].Nodes[1].Nodes.Add(view); } Reader3.Close(); Reader3.Dispose(); } myConn.Close(); myConn.Open(); MySqlCommand command_procedure = new MySqlCommand(); command_procedure = myConn.CreateCommand(); for (int i = 0; i < trV1.Nodes.Count; i++) { command_procedure.CommandText = "SHOW PROCEDURE STATUS WHERE Db ='" + trV1.Nodes[i].Text + "' "; MySqlDataReader Reader4; Reader4 = command_procedure.ExecuteReader(); while (Reader4.Read()) { string procedure = ""; for (int j = 0; j < Reader4.FieldCount; j++) { procedure += Reader4.GetValue(j).ToString(); } trV1.Nodes[i].Nodes[2].Nodes.Add(procedure); } Reader4.Close(); Reader4.Dispose(); } myConn.Close(); myConn.Open(); MySqlCommand command_function = new MySqlCommand(); command_function = myConn.CreateCommand(); for (int i = 0; i < trV1.Nodes.Count; i++) { command_function.CommandText = "SHOW FUNCTION STATUS WHERE Db ='" + trV1.Nodes[i].Text + "' "; MySqlDataReader Reader5; Reader5 = command_function.ExecuteReader(); while (Reader5.Read()) { string function = ""; for (int j = 0; j < Reader5.FieldCount; j++) { function += Reader5.GetValue(j).ToString(); } trV1.Nodes[i].Nodes[3].Nodes.Add(function); } Reader5.Close(); Reader5.Dispose(); } ContextMenuStrip docMenu = new ContextMenuStrip(); ToolStripMenuItem SelectRows = new ToolStripMenuItem(); SelectRows.Text = "Select Rows"; ToolStripMenuItem AlterTable = new ToolStripMenuItem(); AlterTable.Text = "Alter Table"; ToolStripMenuItem DropTable = new ToolStripMenuItem(); DropTable.Text = "Drop Table"; docMenu.Items.AddRange(new ToolStripMenuItem[] { SelectRows, AlterTable, DropTable }); for (int i = 0; i < trV1.Nodes.Count; i++) { for (int j = 0; j < trV1.Nodes[i].Nodes[0].Nodes.Count; j++) { trV1.Nodes[i].Nodes[0].Nodes[j].ContextMenuStrip = docMenu; } } SelectRows.Click += SelectRows_Click; void SelectRows_Click(object sender, System.EventArgs e) { MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;username=root;password=Sercan.123"); connection.Open(); try { MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM " + trV1.SelectedNode.Parent.Parent.Text + "." + trV1.SelectedNode.Text + " ", connection); DataSet ds = new DataSet(); adapter.Fill(ds, trV1.SelectedNode.Text); dataGridView1.DataSource = ds.Tables[trV1.SelectedNode.Text]; string a = ds.Tables[0].Columns.ToString(); //MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM blm437.ogrenci ", connection); //DataSet ds = new DataSet(); //adapter.Fill(ds, "ogrenci"); //dataGridView1.DataSource = ds.Tables["ogrenci"]; } catch (Exception ex) { MessageBox.Show(ex.Message); } } }