public int Insert(EmployeeTSI info)
{
OracleConnection conn = new OracleConnection(ConStr);
try
{
int EmpId=0;
OracleCommand command = new OracleCommand("EmpTSI_update", conn);
command.CommandType = CommandType.StoredProcedure;
var _params = command.Parameters;
conn.Open();
SetParameterValue(_params, "p_empl_id_no", info.Empl_Id_No, OracleDbType.Int32);
SetParameterValue(_params, "p_tsi", info.TSI, OracleDbType.Varchar2);
SetParameterValue(_params, "p_user_id", this.UserId, OracleDbType.Varchar2);
SetParameterValue(_params, "p_img", info.IMG, OracleDbType.Blob);
SetParameterValue(_params, "p_rtf", info.RTF, OracleDbType.Blob);
SetParameterValue(_params, "p_rif", info.RIF, OracleDbType.Blob);
SetParameterValue(_params, "p_rmf", info.RMF, OracleDbType.Blob);
SetParameterValue(_params, "p_rrf", info.RRF, OracleDbType.Blob);
SetParameterValue(_params, "p_rsf", info.RSF, OracleDbType.Blob);
SetParameterValue(_params, "p_ltf", info.LTF, OracleDbType.Blob);
SetParameterValue(_params, "p_lif", info.LIF, OracleDbType.Blob);
SetParameterValue(_params, "p_lmf", info.LMF, OracleDbType.Blob);
SetParameterValue(_params, "p_lrf", info.LRF, OracleDbType.Blob);
SetParameterValue(_params, "p_lsf", info.LSF, OracleDbType.Blob);
command.ExecuteNonQuery();
conn.Close();
return EmpId;
}
catch (Exception ex)
{
throw ex;
}
}
private void UploadFingerTemplates()
{
try
{
FingersBiometrics f = this.FingerBiometrics;
EmployeeTSI info = new EmployeeTSI();
info.Empl_Id_No = 1;
info.TSI = f.TSI;
info.IMG = this.LoadImgFile(this.ImageLocation + @"\" + this.FileName);
info.RTF = f.ByteTemplate.RTF;
info.RIF = f.ByteTemplate.RIF;
info.RMF = f.ByteTemplate.RMF;
info.RRF = f.ByteTemplate.RRF;
info.RSF = f.ByteTemplate.RSF;
info.LTF = f.ByteTemplate.LTF;
info.LIF = f.ByteTemplate.LIF;
info.LMF = f.ByteTemplate.LMF;
info.LRF = f.ByteTemplate.LRF;
info.LSF = f.ByteTemplate.LSF;
dcEmployeeTSI dc = new dcEmployeeTSI();
int EmployeeId =dc.Insert(info);
dc.UpdateEmployeeMatches(EmployeeId, f);
ClearFingerBiometrics();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally {
MessageBox.Show("Data has been saved.");
}
}
