private void _loading() { RingVisibility = Visibility.Visible; Task.Factory.StartNew(() => { DatabaseHelper.Open(); SystemHelper.Open(); var reader = DatabaseHelper.Select <ChapterItem>("Id,Name,Url", $"WHERE BookId = {_book.Id}"); while (reader.Read()) { if (reader.HasRows) { var item = new ChapterItem(reader); Application.Current.Dispatcher.Invoke(() => { ChaptersList.Add(item); }); } } reader.Close(); _setConent(); DatabaseHelper.Close(); RingVisibility = Visibility.Collapsed; }); }
private void DisplayChapters() { string novelId = Page.RouteData.Values["ID"].ToString(); string sql = String.Format("SELECT * FROM Chapters WHERE NovelID = {0}", novelId); DataSet data = connector.query(sql); ChaptersList.DataSource = data; ChaptersList.DataBind(); }
private void StartUp() { if (chaptersList == null) { chaptersList = ((GameObject)GameObject.Instantiate(Resources.Load<GameObject> ("Code Structures/ChaptersList"))).GetComponent<ChaptersList>(); chaptersList.name = "ChaptersList"; GameObject.DontDestroyOnLoad(chaptersList.gameObject); } if (!PlayerPrefs.HasKey("CHAPTER_LIST_ON_PREFS")) SaveOnPlayerPrefs(); else LoadFromPlayerPrefs(); }
public ActionResult ListOfChapter(int tutorialid) { List <ChaptersList> chapters = new List <ChaptersList>(); string constring = ConfigurationManager.ConnectionStrings["TutorialsContext"].ConnectionString; using (SqlConnection con = new SqlConnection(constring)) { SqlCommand command = new SqlCommand(); command.CommandText = "select ChapterID,ChapterName from Chapters Where TutorialID=@TutorialID"; command.Parameters.AddWithValue("@TutorialID", tutorialid); command.Connection = con; con.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader == null) { if (command != null) { command.Dispose(); } if (command != null) { con.Dispose(); } return(Json("null", JsonRequestBehavior.AllowGet)); } while (reader.Read()) { ChaptersList c = new ChaptersList() { ChapterID = (int)reader["ChapterID"], ChapterName = (string)reader["ChapterName"], }; chapters.Add(c); } if (command != null) { command.Dispose(); } if (command != null) { con.Dispose(); } return(Json(chapters, JsonRequestBehavior.AllowGet)); } }
public override string ToString() { return (ChaptersList.ToString()); }