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."); } }