public static FaceData GetFaceInfoByEntryID(int entryID)
{
FaceData _faceData = new FaceData();
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["FaceDatabaseConnectionString"]))
using (SqlCommand cmd = new SqlCommand("dbo.usp_GetFaceInfoByEntryID", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@entryID", SqlDbType.Int);
cmd.Parameters["@entryID"].Value = entryID;
cmd.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 50)).Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@emailID", SqlDbType.NVarChar, 100)).Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@album", SqlDbType.NVarChar, 50)).Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@albumkey", SqlDbType.NVarChar, 200)).Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery(); // *** since you don't need the returned data - just call ExecuteNonQuery
_faceData.name = cmd.Parameters["@name"].Value.ToString();
_faceData.emailID = cmd.Parameters["@emailID"].Value.ToString();
_faceData.album = cmd.Parameters["@album"].Value.ToString();
_faceData.albumkey = cmd.Parameters["@albumkey"].Value.ToString();
_faceData.entryid = entryID;
con.Close();
}
return(_faceData);
}
public static void InsertUserData(FaceData face)
{
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["FaceDatabaseConnectionString"]))
using (SqlCommand cmd = new SqlCommand("dbo.usp_InsertUserData", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@name", SqlDbType.NVarChar, 50);
cmd.Parameters["@name"].Value = face.name;
cmd.Parameters.Add("@emailID", SqlDbType.NVarChar, 100);
cmd.Parameters["@emailID"].Value = face.emailID;
cmd.Parameters.Add("@album", SqlDbType.NVarChar, 50);
cmd.Parameters["@album"].Value = face.album;
cmd.Parameters.Add("@albumkey", SqlDbType.NVarChar, 200);
cmd.Parameters["@albumkey"].Value = face.albumkey;
con.Open();
cmd.ExecuteNonQuery(); // *** since you don't need the returned data - just call ExecuteNonQuery
con.Close();
}
}
public static void InsertUserData(FaceData face)
{
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["FaceDatabaseConnectionString"]))
using (SqlCommand cmd = new SqlCommand("dbo.usp_InsertUserData", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@name", SqlDbType.NVarChar, 50);
cmd.Parameters["@name"].Value = face.name;
cmd.Parameters.Add("@emailID", SqlDbType.NVarChar, 100);
cmd.Parameters["@emailID"].Value = face.emailID;
cmd.Parameters.Add("@album", SqlDbType.NVarChar, 50);
cmd.Parameters["@album"].Value = face.album;
cmd.Parameters.Add("@albumkey", SqlDbType.NVarChar, 200);
cmd.Parameters["@albumkey"].Value = face.albumkey;
con.Open();
cmd.ExecuteNonQuery(); // *** since you don't need the returned data - just call ExecuteNonQuery
con.Close();
}
}
public static FaceData GetFaceInfoByEntryID(int entryID)
{
FaceData _faceData = new FaceData();
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["FaceDatabaseConnectionString"]))
using (SqlCommand cmd = new SqlCommand("dbo.usp_GetFaceInfoByEntryID", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@entryID", SqlDbType.Int);
cmd.Parameters["@entryID"].Value = entryID;
cmd.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 50)).Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@emailID", SqlDbType.NVarChar, 100)).Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@album", SqlDbType.NVarChar, 50)).Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@albumkey", SqlDbType.NVarChar, 200)).Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery(); // *** since you don't need the returned data - just call ExecuteNonQuery
_faceData.name = cmd.Parameters["@name"].Value.ToString();
_faceData.emailID = cmd.Parameters["@emailID"].Value.ToString();
_faceData.album = cmd.Parameters["@album"].Value.ToString();
_faceData.albumkey = cmd.Parameters["@albumkey"].Value.ToString();
_faceData.entryid = entryID;
con.Close();
}
return _faceData;
}
private void Recognize(string filename)
{
try
{
Cursor = Cursors.WaitCursor;
byte[] data = File.ReadAllBytes(filename);
Stream stream = new MemoryStream(data);
HttpResponse <string> response = Unirest.post("https://lambda-face-recognition.p.mashape.com/recognize")
.header("X-Mashape-Authorization", mashapeAuthKey)
.field("album", album)
.field("albumkey", albumKey)
.field("files", data)
.asJson <string>();
JavaScriptSerializer jss = new JavaScriptSerializer();
var output = jss.Deserialize <dynamic>(response.Body);
string entryID = output["photos"][0]["tags"][0]["uids"][0]["prediction"];
FaceData _facedata = FaceDAO.GetFaceInfoByEntryID(Convert.ToInt32(entryID));
tboutName.Text = _facedata.name;
tboutEmail.Text = _facedata.emailID;
Cursor = Cursors.Default;
}
catch (Exception ex)
{
MessageBox.Show("Face not recognize.");
Cursor = Cursors.Default;
}
}
public static void TrainAlbum(string name, string emailID, byte[] data)
{
try
{
//byte[] data1 = File.ReadAllBytes(ConfigurationSettings.AppSettings["SaveImageLocation"]);
string entryID = FaceDAO.GetEntryIDByName(name).ToString();
HttpResponse <string> response = Unirest.post("https://lambda-face-recognition.p.mashape.com/album_train")
.header("X-Mashape-Authorization", mashapeAuthKey)
.field("album", album)
.field("albumkey", albumKey)
.field("entryid", entryID)
.field("files", data)
.asString();
JavaScriptSerializer jss = new JavaScriptSerializer();
var output = jss.Deserialize <dynamic>(response.Body);
FaceData _facedata = new FaceData();
_facedata.name = name;
_facedata.emailID = emailID;
_facedata.album = album;
_facedata.albumkey = albumKey;
FaceDAO.InsertUserData(_facedata);
MessageBox.Show("Image capture and trained.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void TrainAlbum(string name, string emailID, byte[] data)
{
try
{
//byte[] data1 = File.ReadAllBytes(ConfigurationSettings.AppSettings["SaveImageLocation"]);
string entryID = FaceDAO.GetEntryIDByName(name).ToString();
HttpResponse<string> response = Unirest.post("https://lambda-face-recognition.p.mashape.com/album_train")
.header("X-Mashape-Authorization", mashapeAuthKey)
.field("album", album)
.field("albumkey", albumKey)
.field("entryid", entryID)
.field("files", data)
.asString();
JavaScriptSerializer jss = new JavaScriptSerializer();
var output = jss.Deserialize<dynamic>(response.Body);
FaceData _facedata = new FaceData();
_facedata.name = name;
_facedata.emailID = emailID;
_facedata.album = album;
_facedata.albumkey = albumKey;
FaceDAO.InsertUserData(_facedata);
MessageBox.Show("Image capture and trained.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
