public static void updateJobBoardJob(JobBoardJobInfo info)
{
string sql = "update jobboard_export set Adtitle=?adtitle,adText=?adtext, classification=?classification,saletype=?saletype,countryid=?countryid,locationid=?locationid,minsalary=?minsalary,maxsalary=?maxsalary,contactno=?contactno,email=?email," +
" longitude=?longitude,latitude=?latitude,expirydate=?expirydate where job_boardid=?job_boardid and jobdetailid=?jobdetailid";
DAO.ExecuteNonQuery(sql, new MySqlParameter("job_boardid", info.JobBoardId), new MySqlParameter("jobdetailid", info.JobId), new MySqlParameter("adtitle", info.AdTitle), new MySqlParameter("Adtext", info.AdText),
new MySqlParameter("classification", info.ClassificationId), new MySqlParameter("saletype", info.SaleType), new MySqlParameter("countryid", info.CountryId), new MySqlParameter("locationid", info.LocationId),
new MySqlParameter("minsalary", info.MinSalary), new MySqlParameter("maxsalary", info.MaxSalary), new MySqlParameter("contactno", info.ContactNo), new MySqlParameter("email", info.Email),
new MySqlParameter("longitude", info.Longitude), new MySqlParameter("latitude", info.Latitude), new MySqlParameter("expirydate", info.ExpiryDate));
}
public static void insertJobBoardJob(JobBoardJobInfo info)
{
string sql = "insert into jobboard_export (job_boardid,jobdetailid,Adtitle,adText,classification,saletype,countryid,locationid,minsalary,maxsalary,contactno,email,longitude,latitude,expirydate) values ( " +
"?job_boardid,?jobdetailid,?Adtitle,?adText,?classification,?saletype,?countryid,?locationid,?minsalary,?maxsalary,?contactno,?email,?longitude,?latitude,?expirydate)";
DAO.ExecuteNonQuery(sql, new MySqlParameter("job_boardid", info.JobBoardId), new MySqlParameter("jobdetailid", info.JobId), new MySqlParameter("Adtitle", info.AdTitle), new MySqlParameter("Adtext", info.AdText),
new MySqlParameter("classification", info.ClassificationId), new MySqlParameter("saletype", info.SaleType), new MySqlParameter("countryid", info.CountryId), new MySqlParameter("locationid", info.LocationId),
new MySqlParameter("minsalary", info.MinSalary), new MySqlParameter("maxsalary", info.MaxSalary), new MySqlParameter("contactno", info.ContactNo), new MySqlParameter("email", info.Email),
new MySqlParameter("longitude", info.LocationId), new MySqlParameter("latitude", info.Latitude), new MySqlParameter("expirydate", info.ExpiryDate));
}