public static List <Model.Fingerprint> getImages(string userId)
{
List <Model.Fingerprint> images = new List <Model.Fingerprint>();
using (MySqlConnection myconnection = new MySqlConnection(myconn))
{
string commandText = "select * from fingerprint where userId=@userId";
MySqlCommand command = new MySqlCommand(commandText, myconnection);
command.Parameters.AddWithValue("@userId", userId);
myconnection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Model.Fingerprint fp = new Model.Fingerprint();
fp.fpID = reader.GetString(0);
fp.fpName = reader.GetString(1);
fp.sampleNumber = reader.GetInt32(2);
fp.userID = reader.GetString(3);
fp.fpPath = reader.GetString(4);
images.Add(fp);
}
}
}
return(images);
}
public static List<Model.Fingerprint> getImages(string userId)
{
List<Model.Fingerprint> images = new List<Model.Fingerprint>();
using (MySqlConnection myconnection = new MySqlConnection(myconn))
{
string commandText = "select * from fingerprint where userId=@userId";
MySqlCommand command = new MySqlCommand(commandText, myconnection);
command.Parameters.AddWithValue("@userId", userId);
myconnection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Model.Fingerprint fp = new Model.Fingerprint();
fp.fpID = reader.GetString(0);
fp.fpName = reader.GetString(1);
fp.sampleNumber = reader.GetInt32(2);
fp.userID = reader.GetString(3);
fp.fpPath = reader.GetString(4);
images.Add(fp);
}
}
}
return images;
}
