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;
}
