public SQLDatabase(string database) { var dataBase = Filesystem.Combine(Environment.CurrentDirectory, database); sqlConn = new SQLiteConnection(string.Format("Data Source={0};Version=3;", dataBase)); Open(); }
async void _downloadPlayList(string url, string file, string ua, int provider) { var importDir = Path.Combine(Directory.GetCurrentDirectory(), string.Format("Download/playlist/{0}", provider)); var u = Functions.ReplaceAndFixNames(db, url, false); var dl = new HTTPClient(u.Result); dl.UserAgent = ua; dl.GetResponse(url); dl.HTTPClientResponse += (sender, e) => { if (e.Data.Length != 0) { using (var fs = new Filesystem(importDir)) fs.Write(Filesystem.Combine(fs.Root, file), e.Data); Task.Run(() => Console.WriteLine("Downloaded Playlist: {0}...", u.Result)); } }; }
public async void Download(int provider, string response, Dictionary <string, string> parameters, HttpListenerContext context) { var prov = GetProviderNameByID(db, provider); var res = string.Empty; using (var fs = new Filesystem()) { if (parameters.ContainsKey("chanlist")) { var dir = string.Format("Download/channels/{0}", parameters["chanlist"]); Directory.CreateDirectory(dir); Task.Run(() => Console.WriteLine("Downloading Channel List for Provider: {0}", prov.Result)); var lists = db.SQLQuery <uint>(string.Format("SELECT * FROM channel_lists WHERE id='{0}' AND id != '0'", parameters["chanlist"])).Result; if (lists.Count != 0) { for (var i = uint.MinValue; i < lists.Count; i++) { var hc = new HTTPClient(Functions.ReplaceAndFixNames(db, lists[i]["url"], false).Result); hc.HTTPClientError += (sender, e) => Console.WriteLine(e.Message); hc.HTTPClientResponse += (sender, e) => { hc.GetResponse(prov.Result); if (e.Data.Length != 0) { res = e.Data; fs.Write(fs.ResolvePath(Filesystem.Combine(dir, Functions.ReplaceAndFixNames(db, lists[i]["file"]).Result)), res); } }; } } } } Task.Run(() => MakeResponse(provider, res, BackendAction.Download, parameters, context)); }
async Task <Dictionary <string, List <epg_entry> > > ImportFormJson(string input, int list) { var epginfo = new Dictionary <string, List <epg_entry> >(); using (var db = new SQLDatabase("channels.db")) { var url = db.SQLQuery(string.Format("SELECT infourl FROM epg_lists WHERE id='{0}' AND id != '0'", list), "infourl").Result; if (string.IsNullOrEmpty(url)) { return(epginfo); } var json_input = fix_json_input(input); var metadata = JsonConvert.DeserializeObject <Dictionary <string, List <epg_entry> > >(json_input); if (metadata.Count != 0) { foreach (var item in metadata.OrderBy(c => c.Key)) { Task.Run(() => { var dir = string.Format("Download/epg/proginfo/{0}/{1}", list, item.Key); var infolist = new List <epg_entry>(); infolist.Capacity = ushort.MaxValue; Directory.CreateDirectory(dir); for (var i = 0; i < item.Value.Count; i++) { using (var fs = new Filesystem()) { var res = string.Empty; var progid = item.Value[i].ProgID; var f = fs.ResolvePath(Filesystem.Combine(dir, string.Format("{0}.json", progid))); if (!fs.Exists(f) || fs.Length(f) == 0) { var hc = new HTTPClient(url.Replace("[#PROGID#]", progid)); hc.GetResponse(item.Value[i].title); hc.HTTPClientResponse += (sender, e) => { if (e.Data.Length != 0) { res = fix_json_input(e.Data); fs.Write(f, res); } }; } else { res = fs.ReadText(f, Encoding.UTF8).Result; } if (!string.IsNullOrEmpty(res)) { infolist.Add(JsonConvert.DeserializeObject <epg_entry>(res)); } } } epginfo.Add(item.Key, infolist); infolist.Clear(); }); } metadata.Clear(); } } return(epginfo); }