public bool SaveRecord(IdpRecord record, out string id)
{
MySqlCommand insertCommand = new MySqlCommand();
insertCommand.Connection = mySqlConnection;
if (record.ID != null)
{
id = record.ID;
}
else
{
string serverID = "LS1";//TODO: this shud not be here
id = "IDPP-" + serverID + "-" + DateTime.Now.ToString();
id = id.Replace(' ', '-').Replace('/', '-').Replace(':', '-').Replace("AM", "A").Replace("AM", "B");
}
insertCommand.CommandText =
"INSERT INTO idp VALUES(@id, @date_registered, @dob, @first_name, @gender, @last_name, @lga, @marital_status, @other_names, @photo, @state, @yob, @finger_1, @finger_2, @finger_3, @finger_4, @finger_5, @finger_6, @finger_7, @finger_8, @finger_9, @finger_10)";
insertCommand.Parameters.Add("id", MySqlDbType.VarChar).Value = id;
insertCommand.Parameters.Add("date_registered", MySqlDbType.VarChar).Value = DateTime.Now.ToString("dd/MM/yyyy");
insertCommand.Parameters.Add("dob", MySqlDbType.VarChar).Value = record.DoB;
insertCommand.Parameters.Add("first_name", MySqlDbType.VarChar).Value = record.FirstName;
insertCommand.Parameters.Add("gender", MySqlDbType.VarChar).Value = record.Gender;
insertCommand.Parameters.Add("last_name", MySqlDbType.VarChar).Value = record.LastName;
insertCommand.Parameters.Add("lga", MySqlDbType.VarChar).Value = record.LGA;
insertCommand.Parameters.Add("marital_status", MySqlDbType.VarChar).Value = record.MaritalStatus;
insertCommand.Parameters.Add("other_names", MySqlDbType.VarChar).Value = record.OtherNames;
insertCommand.Parameters.Add("photo", MySqlDbType.VarChar).Value = record.Photo;
insertCommand.Parameters.Add("state", MySqlDbType.VarChar).Value = record.State;
insertCommand.Parameters.Add("yob", MySqlDbType.VarChar).Value = record.YoB;
for (int index = 0; index < record.Fingers.Length; index++)
{
int realIndex = index + 1;
insertCommand.Parameters.Add("finger_" + realIndex, MySqlDbType.VarChar).Value = record.Fingers[index];
}
bool noErrorOccured = true;
try
{
this.Open();
insertCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
noErrorOccured = false;
}
finally
{
mySqlConnection.Close();
}
return(noErrorOccured);
}
static void Enroll(string data)
{
data = data.Trim();
IdpRecord record = new IdpRecord();
string[] dataParts = data.Split(';');
dataParts.Where(part => part.Contains('=')).ToList().ForEach(part =>
{
var key = part.Substring(0, part.IndexOf('=')).Trim();
var value = part.Substring(part.IndexOf('=') + 1).Trim();
if (key.ToLower() == "id")
{
record.ID = value;
}
else if (key.ToLower() == "first_name")
{
record.FirstName = value;
}
else if (key.ToLower() == "last_name")
{
record.LastName = value;
}
else if (key.ToLower() == "other_names")
{
record.OtherNames = value;
}
else if (key.ToLower() == "dob")
{
record.DoB = value;
}
else if (key.ToLower() == "yob")
{
record.YoB = value;
}
else if (key.ToLower() == "gender")
{
record.Gender = value;
}
else if (key.ToLower() == "marital_status")
{
record.MaritalStatus = value;
}
else if (key.ToLower() == "state")
{
record.State = value;
}
else if (key.ToLower() == "lga")
{
record.LGA = value;
}
else if (key.ToLower() == "photo")
{
record.Photo = value;
}
else if (key.ToLower().StartsWith("finger_"))
{
int position = int.Parse(key.Substring(7));
record.Fingers[position - 1] = value;
}
});
string id;
if (db.SaveRecord(record, out id))
{
Console.WriteLine("SourceAFISHelper.exe/enroll/success:" + id);
}
else
{
Console.WriteLine("SourceAFISHelper.exe/enroll/failure:Could not save record to the database");
}
//Console.Read();
}