public bool GetCommand(string skill) { //IWriteCommand cmd = new WriteCommand(); //string qry = "INSERT INTO Skill (skill_id, skilltext) VALUES (skill_id_seq.nextval, '" + skill + "')"; //if (cmd.Execute(qry) == true) //{ // return true; //} //return false; string formattedSkill = FormatSkill(skill); // if exists do nothing if (DetermineIfExists(formattedSkill)) { Console.WriteLine(formattedSkill); return(true); } // else add the skill to the database else { ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); try { cn.Open(); IDbTransaction tran = cn.BeginTransaction(); // Add skill int affectedRows = 0; IDbCommand cmd = new OleDbCommand("sp_add_skill", (OleDbConnection)cn); cmd.Transaction = tran; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new OleDbParameter("@skilltxt", formattedSkill)); affectedRows = cmd.ExecuteNonQuery(); if (affectedRows > 0) { tran.Commit(); return(true); } else { tran.Rollback(); return(false); } } catch (Exception e) { Console.WriteLine(e.Message); } finally { cn.Close(); } return(false); } }