void ValidateUser()
{
SqlCommand cmd = new SqlCommand("getFingerPrintCourse", con.ActiveCon());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@session", session);
cmd.Parameters.AddWithValue("@semester", semesterId);
cmd.Parameters.AddWithValue("@course", courseid);
using (SqlDataReader data = cmd.ExecuteReader())
{
var id = "";
while (data.Read())
{
id = data["MatricNo"].ToString();
byte[] fingerPrint = (byte[])data["fingerprint"];
byte[] Image = (byte[])data["Image"];
verifiedImages.Add(id, Image);
Samples.Add(id, new DPFP.Template(new MemoryStream(fingerPrint)));
}
}
}
void SaveErrotImage()
{
SqlCommand cmd = new SqlCommand("InsertErrorImage", con.ActiveCon());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", txtName.Text);
cmd.Parameters.AddWithValue("@basestring", Image);
cmd.ExecuteNonQuery();
}
public String AddtoDatabase()
{
try
{
Connection con = new Connection();
SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO AUTH VALUES('" + name + "','" + password + "','" + department + "','" + email + "','" + mobile + "','" + nic + "','" + index + "','" + address + "')", con.ActiveCon());
DataTable dt = new DataTable();
sda.Fill(dt);
return("Success");
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
private void loginButton_Click(object sender, EventArgs e)
{
Connection con = new Connection();
MySqlDataAdapter sda = new MySqlDataAdapter("Select * From Profile_Master Where Pro_User_Id='" + usernameTextbox.Text + "' and Pro_Password='******'", con.ActiveCon());
DataTable dt = new DataTable();
sda.Fill(dt);
if (1 == dt.Rows.Count)
{
LMS objLMS = new LMS();
objLMS.Show();
Hide();
}
else
{
MessageBox.Show("Invalid username or password", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}