public List <JobRequest> PostScrapedJobs() { List <JobRequest> jobs = new ZipScraper().Scrape(); using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); for (int i = 0; i < jobs.Count; i++) { JobRequest job = jobs[i]; try { //Post new job into the database SqlCommand cmd = new SqlWrapper().Wrapper("ZipApplier_insert", con); cmd.Parameters.AddWithValue("@job_id", job.JobId); cmd.Parameters.AddWithValue("@title", job.Title); cmd.Parameters.AddWithValue("@url", job.Url); cmd.Parameters.AddWithValue("@company", job.Company); cmd.Parameters.AddWithValue("@description", job.Description); cmd.Parameters.AddWithValue("@location", job.Location); cmd.Parameters.AddWithValue("@quick_apply", job.QuickApply); cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); } catch (SqlException exp) when(exp.Number == 2601) { //if job posting already exists in the database, ignore and continue. continue; } } return(jobs); } }
/// <summary> /// 保存支付订单信息 /// </summary> /// <param name="order"></param> /// <returns></returns> public static bool SaveAliPayOrder(Order order) { HotelHotel.Utility.Sql.UpdateScript script = new HotelHotel.Utility.Sql.UpdateScript(tableName); if (!string.IsNullOrEmpty(order.TradeStatus)) { script.AddParams("tradeStatus", order.TradeStatus); } if (!string.IsNullOrEmpty(order.TradeNo)) { script.AddParams("tradeNo", order.TradeNo); } if (order.TradeAlipayAmount > 0) { script.AddParams("aliPayAmount", order.TradeAlipayAmount); } script.AddParams("aliPayTime", order.AlipayTime) .AddParams("state", order.State) .AddParams("Remark", order.Remark) .AddCriteria("id", order.Id); int row = SqlWrapper.ExecuteNonQuery(GlobalConfig.ConnStr, script.Execute()); if (row > 0) { return(true); } return(false); }
public void Delete(int id) { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = new SqlWrapper().Wrapper("Jobs_delete", con); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); } }
public void Update(JobUpdateRequest req) { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = new SqlWrapper().Wrapper("Jobs_update", con); cmd.Parameters.AddWithValue("@id", req.Id); cmd.Parameters.AddWithValue("@job_id", req.JobId); cmd.Parameters.AddWithValue("@title", req.Title); cmd.Parameters.AddWithValue("@url", req.Url); cmd.Parameters.AddWithValue("@company", req.Company); cmd.Parameters.AddWithValue("@description", req.Description); cmd.Parameters.AddWithValue("@location", req.Location); cmd.Parameters.AddWithValue("@date_applied", req.DateApplied); cmd.Parameters.AddWithValue("@archived", req.Archived); cmd.Parameters.AddWithValue("@quick_apply", req.QuickApply); cmd.ExecuteNonQuery(); } }