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