public static void updateJobBoard(JobBoardInfo info) { string sql = "update job_boards set boardname=?boardname,boardURL=?boardURL,notes=?notes,username=?username,password=?password where job_boardid=?boardid"; DAO.ExecuteNonQuery(sql, new MySqlParameter("boardid", info.JobBoardId), new MySqlParameter("boardname", info.BoardName), new MySqlParameter("boardURL", info.BoardURL), new MySqlParameter("notes", info.Notes), new MySqlParameter("username", info.Username), new MySqlParameter("password", info.Password)); deleteJobBoardIndustry(info.JobBoardId); foreach (JobBoardIndustry industry in info.Industry) { insertJobboardIndustry(info.JobBoardId, industry.ISICRev4Id); } deleteJobBoardLocation(info.JobBoardId); foreach (JobBoardLocation location in info.Locations) { insertJobBoardLocation(info.JobBoardId, location.LocationId, location.LocationType); } }
public static int insertJobBoard(JobBoardInfo info) { int boardId = 0; string sql = "insert into job_boards (boardname,boardURL,notes,userid,createddate,username,password) values (?boardname,?boardURL,?notes,?userid,?createddate,?username,?password); select last_insert_id()"; boardId = Convert.ToInt32(DAO.ExecuteScalar(sql, new MySqlParameter("boardname", info.BoardName), new MySqlParameter("boardURL", info.BoardURL), new MySqlParameter("notes", info.Notes), new MySqlParameter("userid", GPSession.UserId), new MySqlParameter("createddate", DateTime.UtcNow), new MySqlParameter("username", info.Username), new MySqlParameter("password", info.Password))); foreach (JobBoardIndustry industry in info.Industry) { insertJobboardIndustry(boardId, industry.ISICRev4Id); } foreach (JobBoardLocation location in info.Locations) { insertJobBoardLocation(boardId, location.LocationId, location.LocationType); } return boardId; }