public bool GetCommand(List <DbJob> obj, int stream_id) { ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); InsertJob insJob = new InsertJob(); try { cn.Open(); IDbTransaction tran = cn.BeginTransaction(); IDbCommand cmd = new OleDbCommand("sp_del_job", (OleDbConnection)cn); cmd.Transaction = tran; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new OleDbParameter("@jobId", obj[0].JobId)); int affectedRows = cmd.ExecuteNonQuery(); tran.Commit(); return(true); } catch (Exception e) { Console.WriteLine(e.Message); } finally { cn.Close(); } return(false); }
public bool GetCommand(List <DbJob> job, List <string> deletedSkills) { ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); InsertJob insJob = new InsertJob(); try { cn.Open(); IDbTransaction tran = cn.BeginTransaction(); IDbCommand cmd = new OleDbCommand("sp_del_jobskill", (OleDbConnection)cn); cmd.Transaction = tran; cmd.CommandType = CommandType.StoredProcedure; for (int j = 0; j < deletedSkills.Count(); j++) { string formattedSkill = insJob.FormatSkill(deletedSkills[j]); GetSkillId id = new GetSkillId(); int delskillid = int.Parse(id.Read(formattedSkill)); cmd.Parameters.Add(new OleDbParameter("@jobId", job[0].JobId)); cmd.Parameters.Add(new OleDbParameter("@delSkillId", delskillid)); int affectedRows = cmd.ExecuteNonQuery(); } tran.Commit(); return(true); } catch (Exception e) { Console.WriteLine(e.Message); } finally { cn.Close(); } return(false); }
public bool addNewSkills(int job_id, List <string> newlyAddedSkills) { ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); IDbCommand cmd = new OleDbCommand("sp_update_jobskill", (OleDbConnection)cn); cmd.CommandType = CommandType.StoredProcedure; InsertJob insJob = new InsertJob(); for (int i = 0; i < newlyAddedSkills.Count(); i++) { string formattednewSkill = insJob.FormatSkill(newlyAddedSkills[i]); GetSkillId newId = new GetSkillId(); int addedskillid = int.Parse(newId.Read(formattednewSkill)); try { cn.Open(); IDbTransaction tran = cn.BeginTransaction(); cmd.Transaction = tran; cmd.Parameters.Add(new OleDbParameter("@jobId", job_id)); cmd.Parameters.Add(new OleDbParameter("@addedSkillId", addedskillid)); int affectedRows = cmd.ExecuteNonQuery(); if (affectedRows > 0) { // // Add jobskills // for (int i = 0; i < skills.Count(); i++) // { // IDbCommand cmd2 = new OleDbCommand("sp_add_jobSkill", (OleDbConnection)cn); // cmd2.Transaction = tran; // cmd2.CommandType = CommandType.StoredProcedure; // string formattedSkill = FormatSkill(skills[i]); // GetSkillId id = new GetSkillId(); // int skillid = int.Parse(id.Read(formattedSkill)); // cmd2.Parameters.Add(new OleDbParameter("@skill_id", int.Parse(skillid.ToString()))); // affectedRows = affectedRows + cmd2.ExecuteNonQuery(); // } tran.Commit(); return(true); } else { tran.Rollback(); } } catch (Exception e) { Console.WriteLine(e.Message); } finally { cn.Close(); } } return(false); }
public bool InsertJob(DbJob job, List <string> skills, Guid sessionid) { InsertJob insJob = new InsertJob(); return(insJob.GetCommand(job, skills, sessionid)); }
public bool InsertJob(DbJob job, List<string> skills, Guid sessionid) { InsertJob insJob = new InsertJob(); return insJob.GetCommand(job, skills, sessionid); }