private void radButton2_Click(object sender, EventArgs e)
{
//int id = int.Parse(txtID.Text.ToString());
string fullName = txtFullName.Text.ToString();
string nameInitials = txtNameInitials.Text.ToString();
int titleId = int.Parse(ddlTitle.SelectedItem.Value.ToString());
// DataSet dsTitleId = DB_Connect.ExecuteQuery("SELECT title_id FROM title_tab WHERE title_name = '"+ titleName +"'");
//int titleId = int.Parse(dsTitleId.Tables[0].Rows[0][0].ToString());
string nationality = txtNationality.Text.ToString();
DateTime dob = dtpDOB.Value;
string nic = txtNIC.Text.ToString();
string addr_l1 = txtAddrL1.Text.ToString();
string addr_l2 = txtAddrL2.Text.ToString();
string addr_l3 = txtAddrL3.Text.ToString();
string telNo = txtTelNo.Text.ToString();
string email = txtEmail.Text.ToString();
string img = file;
char gender;
bool isChecked = rbFemale.IsChecked;
if (isChecked)
gender = 'F';
else
gender = 'M';
Candidate c = new Candidate(fullName, nameInitials, titleId, nationality, nic, dob, gender, addr_l1, addr_l2, addr_l3, telNo, email, img);
try
{
c.insertCandidate(c);
MessageBox.Show("Success");
resetFields();
}
catch
{
MessageBox.Show("Error");
}
}
public void insertCandidate(Candidate c)
{
DB_Connect.InsertQuery("INSERT INTO candidate_tab(candidate_full_name,candidate_name_initials,candidate_title,candidate_nationality_id,candidate_nic,candidate_dob,candidate_gender,candidate_addr_l1,candidate_addr_l2, candidate_addr_l3, candidate_telno,candidate_email) VALUES('" + c.fullName + "', '" + c.nameInitials + "', '" + c.title + "', '" + c.nationality + "', '" + c.nic + "', '" + c.dob + "','" + c.gender + "','" + c.addr_l1 + " ','" + c.addr_l2 + " ','" + c.addr_l3 + " ', '" + c.telNo + "', '" + c.email + "');");
}
public void updateCandidate(Candidate c)
{
DB_Connect.ExecuteQuery("UPDATE candidate_tab SET candidate_full_name = '" + c.fullName + "',candidate_name_initials = '" + c.nameInitials + "',candidate_title = '" + c.title + "',candidate_nationality_id = '" + c.nationality + "',candidate_nic = '" + c.nic + "',candidate_dob = '" + c.dob + "',candidate_gender = '" + c.gender + "',candidate_address = '" + c.addr_l1 + "',candidate_address = '" + c.addr_l2 + "',candidate_address = '" + c.addr_l3 + "',candidate_telno = '" + c.telNo + "',candidate_email = '" + c.email + "',candidate_img = '" + c.img + "' WHERE candidate_id = " + c.id + ";");
}
public Candidate getCandidate(int id)
{
//int c_id = 2;
DataSet ds = DB_Connect.ExecuteQuery("SELECT * FROM candidate_tab WHERE candidate_id = " + id + ";");
int cid = int.Parse(ds.Tables[0].Rows[0][0].ToString());
string cfullName = ds.Tables[0].Rows[0][1].ToString();
string cnameInitials = ds.Tables[0].Rows[0][2].ToString();
int ctitleId = int.Parse(ds.Tables[0].Rows[0][3].ToString());
string cnationality = ds.Tables[0].Rows[0][4].ToString();
string cnic = ds.Tables[0].Rows[0][5].ToString();
DateTime cdob = (DateTime)ds.Tables[0].Rows[0][6];
char cgender = Convert.ToChar(ds.Tables[0].Rows[0][7].ToString());
string caddr_l1 = ds.Tables[0].Rows[0][8].ToString();
string caddr_l2 = ds.Tables[0].Rows[0][9].ToString();
string caddr_l3 = ds.Tables[0].Rows[0][10].ToString();
string ctelNo = ds.Tables[0].Rows[0][11].ToString();
string cemail = ds.Tables[0].Rows[0][12].ToString();
string cimg = ds.Tables[0].Rows[0][13].ToString();
Candidate c = new Candidate(cfullName, cnameInitials, ctitleId, cnationality, cnic, cdob, cgender, caddr_l1, caddr_l2, caddr_l3, ctelNo, cemail, cimg);
return c;
}
private void lblCandidateID_TextChanged(object sender, EventArgs e)
{
resetButtons();
lblAuthanticity.Text = "";
string candi_ID = "";
int seatNo = 0;
Candidate candi = new Candidate();
//populate candidate information
try
{
canyInformation = candi.getCandidateInfo(Convert.ToInt32(lblCandidateID.Text));
}
catch (Exception ex)
{
}
try
{
foreach (DataRow rowCan in canyInformation.Tables[0].Rows)
{
//get candidate Id
candi_ID = rowCan[0].ToString();
lblFullName.Text = rowCan[0].ToString();
lblInitName.Text = rowCan[1].ToString();
lbltitle.Text = rowCan[2].ToString();
}
}
catch (Exception ex)
{
}
//show seat allocation
foreach (DataRow row in nameList.Tables[0].Rows)
{
//get candidate Id
candi_ID = row[0].ToString();
if (lblCandidateID.Text == candi_ID)
{
seatNo = Convert.ToInt32(row[1]);
}
}
switch (seatNo)
{
case 0:
break;
case 1:
HighlightChair(chair01);
break;
case 2:
HighlightChair(chair02);
break;
case 3:
HighlightChair(chair03);
break;
case 4:
HighlightChair(chair04);
break;
}
if (lblCandidateID.Text == "" || lblCandidateID.Text == "unknown")
{
lblAuthanticity.ForeColor = Color.Red;
lblAuthanticity.Text = "Unauthorized";
}
else
{
lblAuthanticity.ForeColor = Color.Green;
lblAuthanticity.Text = "Authorized";
}
}
public void populateLists()
{
labels.Clear();
trainingImages.Clear();
//unknown detection
for (int a = 1; a < 5; a++)
{
//fill lables list 4 times with id
labels.Add("unknown");
string LoadFaces = "face_" + "unknown" + "_" + a + ".bmp";
try
{
trainingImages.Add(new Image<Gray, byte>(Application.StartupPath + "/TrainedFaces/" + LoadFaces));
}
catch (Exception ex)
{
MessageBox.Show("Images not exist");
}
}
string studentID;
//get list of candidates on examination
Candidate candi = new Candidate();
string sub = cmbExam.SelectedValue.ToString();
//Get Student Details
nameList = candi.getCandidateList(Convert.ToInt32(sub));
try
{
canyInformation = candi.getCandidateInfo(Convert.ToInt32(lblCandidateID));
}
catch (Exception e)
{
}
///---------------------------Face Detection--------------------------------------
//number of students
string stCount = nameList.Tables[0].Rows.Count.ToString();
//run iteration for each candidate
foreach (DataRow row in nameList.Tables[0].Rows)
{
//get candidate Id
studentID = row[0].ToString();
//fill trainedImages list from disk on id
for (int a = 1; a < 5; a++)
{
//fill lables list 4 times with id
labels.Add(studentID);
string LoadFaces = "face_"+studentID+"_"+ a + ".bmp";
try
{
trainingImages.Add(new Image<Gray, byte>(Application.StartupPath + "/TrainedFaces/" + LoadFaces));
}
catch (Exception ex)
{
MessageBox.Show("Images not exist");
break;
}
}
}
MessageBox.Show("Found : " + stCount+" students for "+cmbExam.SelectedText.ToString()+" examination","Data Population is Completed");
}
public void populateLists()
{
labels.Clear();
trainingImages.Clear();
//unknown detection
for (int a = 1; a < 5; a++)
{
//fill lables list 4 times with id
labels.Add("unknown");
string LoadFaces = "face_" + "unknown" + "_" + a + ".bmp";
try
{
trainingImages.Add(new Image <Gray, byte>(Application.StartupPath + "/TrainedFaces/" + LoadFaces));
}
catch (Exception ex)
{
MessageBox.Show("Images not exist");
}
}
string studentID;
//get list of candidates on examination
Candidate candi = new Candidate();
string sub = cmbExam.SelectedValue.ToString();
//Get Student Details
nameList = candi.getCandidateList(Convert.ToInt32(sub));
try
{
canyInformation = candi.getCandidateInfo(Convert.ToInt32(lblCandidateID));
}
catch (Exception e)
{
}
///---------------------------Face Detection--------------------------------------
//number of students
string stCount = nameList.Tables[0].Rows.Count.ToString();
//run iteration for each candidate
foreach (DataRow row in nameList.Tables[0].Rows)
{
//get candidate Id
studentID = row[0].ToString();
//fill trainedImages list from disk on id
for (int a = 1; a < 5; a++)
{
//fill lables list 4 times with id
labels.Add(studentID);
string LoadFaces = "face_" + studentID + "_" + a + ".bmp";
try
{
trainingImages.Add(new Image <Gray, byte>(Application.StartupPath + "/TrainedFaces/" + LoadFaces));
}
catch (Exception ex)
{
MessageBox.Show("Images not exist");
break;
}
}
}
MessageBox.Show("Found : " + stCount + " students for " + cmbExam.SelectedText.ToString() + " examination", "Data Population is Completed");
}
private void lblCandidateID_TextChanged(object sender, EventArgs e)
{
resetButtons();
lblAuthanticity.Text = "";
string candi_ID = "";
int seatNo = 0;
Candidate candi = new Candidate();
//populate candidate information
try
{
canyInformation = candi.getCandidateInfo(Convert.ToInt32(lblCandidateID.Text));
}
catch (Exception ex)
{
}
try
{
foreach (DataRow rowCan in canyInformation.Tables[0].Rows)
{
//get candidate Id
candi_ID = rowCan[0].ToString();
lblFullName.Text = rowCan[0].ToString();
lblInitName.Text = rowCan[1].ToString();
lbltitle.Text = rowCan[2].ToString();
}
}
catch (Exception ex)
{
}
//show seat allocation
foreach (DataRow row in nameList.Tables[0].Rows)
{
//get candidate Id
candi_ID = row[0].ToString();
if (lblCandidateID.Text == candi_ID)
{
seatNo = Convert.ToInt32(row[1]);
}
}
switch (seatNo)
{
case 0:
break;
case 1:
HighlightChair(chair01);
break;
case 2:
HighlightChair(chair02);
break;
case 3:
HighlightChair(chair03);
break;
case 4:
HighlightChair(chair04);
break;
}
if (lblCandidateID.Text == "" || lblCandidateID.Text == "unknown")
{
lblAuthanticity.ForeColor = Color.Red;
lblAuthanticity.Text = "Unauthorized";
}
else
{
lblAuthanticity.ForeColor = Color.Green;
lblAuthanticity.Text = "Authorized";
}
}
