private void buttonDelete_Click(object sender, EventArgs e)
{
try
{
TrainingSetDbGateWay.LocalDataTable.Rows[TrainingSetDbGateWay.RowNumber].Delete();
SqlCommandBuilder commandBuilder1 = new SqlCommandBuilder(TrainingSetDbGateWay.DataAdater);
MessageBox.Show("Image Record Successfully Deleted!!");
TrainingSetDbGateWay.DataAdater.Update(TrainingSetDbGateWay.LocalDataTable);
TrainingSetDbGateWay.refreshDBconnection();
TrainingSetDbGateWay.RowNumber--;
pictureBox1.Image = TrainingSetDbGateWay.ReadImageFromDB();
importedFaceNametextBox.Text = TrainingSetDbGateWay.LocalDataTable.Rows[TrainingSetDbGateWay.RowNumber]["PersonName"].ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void goToLastImageButton_Click(object sender, EventArgs e)
{
int totalRows = TrainingSetDbGateWay.LocalDataTable.Rows.Count;
TrainingSetDbGateWay.refreshDBconnection();
TrainingSetDbGateWay.RowNumber = totalRows - 1;
pictureBox1.Image = TrainingSetDbGateWay.ReadImageFromDB();
importedFaceNametextBox.Text = TrainingSetDbGateWay.LocalDataTable.Rows[TrainingSetDbGateWay.RowNumber]["PersonName"].ToString();
PersonNamelabel.Text = (TrainingSetDbGateWay.RowNumber + 1).ToString();
MessageBox.Show("You Have Reached The First Image In List!!!");
}
private void buttonPre_Click(object sender, EventArgs e)
{
if (TrainingSetDbGateWay.RowNumber == 0)
{
MessageBox.Show("This Is The First Image");
}
else
{
TrainingSetDbGateWay.RowNumber--;
pictureBox1.Image = TrainingSetDbGateWay.ReadImageFromDB();
importedFaceNametextBox.Text = TrainingSetDbGateWay.LocalDataTable.Rows[TrainingSetDbGateWay.RowNumber]["PersonName"].ToString();
PersonNamelabel.Text = (TrainingSetDbGateWay.RowNumber + 1).ToString();
}
}
private void buttonNext_Click(object sender, EventArgs e)
{
if (TrainingSetDbGateWay.RowNumber == TrainingSetDbGateWay.LocalDataTable.Rows.Count - 1)
{
MessageBox.Show("You Have Reached The Last Image!!");
}
else
{
TrainingSetDbGateWay.RowNumber++;
pictureBox1.Image = TrainingSetDbGateWay.ReadImageFromDB();
importedFaceNametextBox.Text = TrainingSetDbGateWay.LocalDataTable.Rows[TrainingSetDbGateWay.RowNumber]["PersonName"].ToString();
PersonNamelabel.Text = (TrainingSetDbGateWay.RowNumber + 1).ToString();
}
}
private void updateFaceNameButton_Click(object sender, EventArgs e)
{
try {
PersonNamelabel.Text = (TrainingSetDbGateWay.RowNumber + 1).ToString();
TrainingSetDbGateWay.LocalDataTable.Rows[TrainingSetDbGateWay.RowNumber]["PersonName"] = importedFaceNametextBox.Text;
SqlCommandBuilder commandBuilder2 = new SqlCommandBuilder(TrainingSetDbGateWay.DataAdater);
MessageBox.Show("Successfully Updated!!!");
TrainingSetDbGateWay.DataAdater.Update(TrainingSetDbGateWay.LocalDataTable);
TrainingSetDbGateWay.refreshDBconnection();
}
catch (Exception ex) {
MessageBox.Show(ex.ToString());
}
}
public void ImageDB_Load(object sender, EventArgs e)
{
haarCascade1 = new HaarCascade("haarcascade_frontalface_alt_tree.xml");
TrainingSetDbGateWay.ConnectToDatabase();
}
