public void Create_oil(OilDetail test)
{
try
{
_context.OilDetail.Add(test);
_context.SaveChanges();
}
catch (Exception e)
{
throw new Exception();
}
}
public void Createoil()
{
try
{
HttpWebRequest request = (WebRequest.Create(@"https://quality.data.gov.tw/dq_download_json.php?nid=6339&md5_url=a03335ba6b0bead4ec405a69605db65c")) as HttpWebRequest;
HttpWebResponse response = request.GetResponse() as HttpWebResponse;
//string root = Encoding.UTF8.GetString(request.ToString());
StreamReader sr = new StreamReader(response.GetResponseStream());
string RtvStr = sr.ReadToEnd();
byte[] encodeBytes = Encoding.UTF8.GetBytes(RtvStr);
byte[] bConvert = System.Text.UnicodeEncoding.Convert(System.Text.Encoding.UTF8, System.Text.Encoding.Unicode, encodeBytes);
string sText = System.Text.Encoding.Unicode.GetString(bConvert);
//string root = Encoding.UTF8.GetString(RtvStr.ToArray());
List <oilinResult> roots = JsonConvert.DeserializeObject <List <oilinResult> >(sText);
List <OilDetail> root = new List <OilDetail>();
foreach (var i in roots)
{
root.Add(new OilDetail()
{
Category = i.型別名稱,
Oilnumber = i.產品編號,
Oilname = i.產品名稱,
Package = i.包裝,
Sellto = i.銷售對象,
Tradelocate = i.交貨地點,
Salesunit = i.計價單位,
ReferencePrice = i.參考牌價,
BusinessTax = i.營業稅,
GoodTax = i.貨物稅,
DateTimeOffset = i.牌價生效時間,
Remarks = i.備註,
});
}
foreach (OilDetail oil in root)
{
Guid g;
g = Guid.NewGuid();
OilDetail oilDetail = new OilDetail()
{
OilId = g,
Category = oil.Category,
Oilname = oil.Oilname,
Oilnumber = oil.Oilnumber,
Package = oil.Package,
Sellto = oil.Sellto,
Salesunit = oil.Salesunit,
Remarks = oil.Remarks,
ReferencePrice = oil.ReferencePrice,
BusinessTax = oil.BusinessTax,
GoodTax = oil.GoodTax,
DateTimeOffset = oil.DateTimeOffset,
Tradelocate = oil.Tradelocate,
UpdataTime = DateTime.UtcNow
};
ioilDAO.Create_oil(oilDetail);
}
}
catch
{
throw new Exception();
}
}
