public IEnumerable <Model.UserInfoNo> GetPage(Model.Page page) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "with a as(select userinfo.*, row_number() over(order by username) as num from userinfo) for "; sql += "select * from a where num between(@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize;"; return(cn.Query <Model.UserInfoNo>(sql, page)); } }
protected void Page_Load(object sender, EventArgs e) { ClientScriptManager cs = Page.ClientScript; ModelContainer1 mc = new ModelContainer1(); var contentForAllPages = (from x in mc.AllPagesSet select x).First(); PageLogo = contentForAllPages.Logo; cs.RegisterStartupScript(this.GetType(), "changecColor", "changeColor(" + contentForAllPages.ColorR + "," + contentForAllPages.ColorG + "," + contentForAllPages.ColorB + ");", true); var defaultPage = (from x in mc.PageSet orderby x.Id ascending select x).First(); PagesCollection = ""; var pageCollection = (from x in mc.PageSet orderby x.Id ascending select x); foreach (Model.Page p in pageCollection) { PagesCollection += "<li><a class='hovGradient' id='pageId" + p.Id + "' href='?pageId=" + p.Id + "'>" + p.Name + "</a></li>"; } string pageId = Request.QueryString["pageId"]; if (pageId != null) { int id = int.Parse(pageId); Model.Page page = null; try { page = (from x in mc.PageSet where x.Id == id select x).First(); } catch (Exception) { } if (page == null) { page = (Model.Page)defaultPage; Response.Redirect("Default.aspx?pageId=" + page.Id); } PageId = id; PageContent = page.Content; } else { PageId = defaultPage.Id; PageContent = defaultPage.Content; } }
private void DrawPage(IntPtr pdfDocument, Page page, Image image) { IntPtr pdfPage = LibPdfium.CreatePage(pdfDocument, page.Size); int transformationIndex = page.ImageTransformationIndex; if (image.RawFormat.Equals(System.Drawing.Imaging.ImageFormat.Jpeg)) { LibPdfium.AddJpegToPage(pdfDocument, pdfPage, image, page.ImageBoundsInches, transformationIndex); } else if (image.RawFormat.Equals(System.Drawing.Imaging.ImageFormat.Bmp)) { LibPdfium.AddBitmapToPage(pdfDocument, pdfPage, image, page.ImageBoundsInches, transformationIndex); } else if(image.RawFormat.Equals(System.Drawing.Imaging.ImageFormat.Png)) { // Keep PNG because: // -It seems PNG and BMP are both stored the same way. // -Converting to BMP loses the Alpha component of ARGB LibPdfium.AddBitmapToPage(pdfDocument, pdfPage, image, page.ImageBoundsInches, transformationIndex); } else { // All other types convery to PNG because: // It seems PNG and BMP are both stored the same way. Image storedImage = Utils.Imaging.ConvertImage(image, System.Drawing.Imaging.ImageFormat.Png, 0); LibPdfium.AddBitmapToPage(pdfDocument, pdfPage, storedImage, page.ImageBoundsInches, transformationIndex); } }
public void AddPage(Page newPage) { int index = fPages.Count; fPages.Insert(index, newPage); RaisePageAdded(index); }
public Model.Lang GetLang(Model.Page _page, [ScopedService] DrMofradDbContext drMofradDbContext) { return(drMofradDbContext.Langs.FirstOrDefault(lang => lang.Id == _page.LangId)); }
private void SetupPartitions() { if (s_quran_metadata == null) { LoadQuranMetadata(); } if (s_quran_metadata != null) { // setup Chapters for (int i = 0; i < s_quran_metadata.Chapters.Length; i++) { int number = s_quran_metadata.Chapters[i].Number; int verse_count = s_quran_metadata.Chapters[i].Verses; int first_verse = s_quran_metadata.Chapters[i].FirstVerse; int last_verse = first_verse + verse_count; string name = s_quran_metadata.Chapters[i].Name; string transliterated_name = s_quran_metadata.Chapters[i].TransliteratedName; string english_name = s_quran_metadata.Chapters[i].EnglishName; int revelation_order = s_quran_metadata.Chapters[i].RevelationOrder; RevelationPlace revelation_place = s_quran_metadata.Chapters[i].RevelationPlace; int bowing_count = s_quran_metadata.Chapters[i].Bowings; List<Verse> verses = new List<Verse>(); if (this.verses != null) { for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Chapter chapter = new Chapter(number, name, transliterated_name, english_name, revelation_order, revelation_place, bowing_count, verses); this.chapters.Add(chapter); } } // setup Bowings for (int i = 0; i < s_quran_metadata.Bowings.Length; i++) { int number = s_quran_metadata.Bowings[i].Number; int start_chapter = s_quran_metadata.Bowings[i].StartChapter; int start_chapter_verse = s_quran_metadata.Bowings[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_bowing_first_verse = 0; if (i < s_quran_metadata.Bowings.Length - 1) { int next_bowing_start_chapter = s_quran_metadata.Bowings[i + 1].StartChapter; int next_bowing_start_chapter_verse = s_quran_metadata.Bowings[i + 1].StartChapterVerse; for (int j = 0; j < next_bowing_start_chapter - 1; j++) { next_bowing_first_verse += this.chapters[j].Verses.Count; } next_bowing_first_verse += next_bowing_start_chapter_verse; } else { next_bowing_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_bowing_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Bowing bowing = new Bowing(number, verses); this.bowings.Add(bowing); } // setup Group for (int i = 0; i < s_quran_metadata.Groups.Length; i++) { int number = s_quran_metadata.Groups[i].Number; int start_chapter = s_quran_metadata.Groups[i].StartChapter; int start_chapter_verse = s_quran_metadata.Groups[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_group_first_verse = 0; if (i < s_quran_metadata.Groups.Length - 1) { int next_group_start_chapter = s_quran_metadata.Groups[i + 1].StartChapter; int next_group_start_chapter_verse = s_quran_metadata.Groups[i + 1].StartChapterVerse; for (int j = 0; j < next_group_start_chapter - 1; j++) { next_group_first_verse += this.chapters[j].Verses.Count; } next_group_first_verse += next_group_start_chapter_verse; } else { next_group_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_group_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Model.Group group = new Model.Group(number, verses); this.groups.Add(group); } // setup Quarters for (int i = 0; i < s_quran_metadata.Quarters.Length; i++) { int number = s_quran_metadata.Quarters[i].Number; int start_chapter = s_quran_metadata.Quarters[i].StartChapter; int start_chapter_verse = s_quran_metadata.Quarters[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_group_quarter_first_verse = 0; if (i < s_quran_metadata.Quarters.Length - 1) { int next_group_quarter_start_chapter = s_quran_metadata.Quarters[i + 1].StartChapter; int next_group_quarter_start_chapter_verse = s_quran_metadata.Quarters[i + 1].StartChapterVerse; for (int j = 0; j < next_group_quarter_start_chapter - 1; j++) { next_group_quarter_first_verse += this.chapters[j].Verses.Count; } next_group_quarter_first_verse += next_group_quarter_start_chapter_verse; } else { next_group_quarter_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_group_quarter_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Quarter group_quarter = new Quarter(number, verses); this.quarters.Add(group_quarter); } // setup Pages for (int i = 0; i < s_quran_metadata.Pages.Length; i++) { int number = s_quran_metadata.Pages[i].Number; int start_chapter = s_quran_metadata.Pages[i].StartChapter; int start_chapter_verse = s_quran_metadata.Pages[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_page_first_verse = 0; if (i < s_quran_metadata.Pages.Length - 1) { int next_page_start_chapter = s_quran_metadata.Pages[i + 1].StartChapter; int next_page_start_chapter_verse = s_quran_metadata.Pages[i + 1].StartChapterVerse; for (int j = 0; j < next_page_start_chapter - 1; j++) { next_page_first_verse += this.chapters[j].Verses.Count; } next_page_first_verse += next_page_start_chapter_verse; } else { next_page_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_page_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Page page = new Page(number, verses); this.pages.Add(page); } // setup Parts for (int i = 0; i < s_quran_metadata.Parts.Length; i++) { int number = s_quran_metadata.Parts[i].Number; int start_chapter = s_quran_metadata.Parts[i].StartChapter; int start_chapter_verse = s_quran_metadata.Parts[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_part_first_verse = 0; if (i < s_quran_metadata.Parts.Length - 1) { int next_part_start_chapter = s_quran_metadata.Parts[i + 1].StartChapter; int next_part_start_chapter_verse = s_quran_metadata.Parts[i + 1].StartChapterVerse; for (int j = 0; j < next_part_start_chapter - 1; j++) { next_part_first_verse += this.chapters[j].Verses.Count; } next_part_first_verse += next_part_start_chapter_verse; } else { next_part_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_part_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Part part = new Part(number, verses); this.parts.Add(part); } // setup Stations for (int i = 0; i < s_quran_metadata.Stations.Length; i++) { int number = s_quran_metadata.Stations[i].Number; int start_chapter = s_quran_metadata.Stations[i].StartChapter; int start_chapter_verse = s_quran_metadata.Stations[i].StartChapterVerse; int first_verse = 0; for (int j = 0; j < start_chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += start_chapter_verse; int next_station_first_verse = 0; if (i < s_quran_metadata.Stations.Length - 1) { int next_station_start_chapter = s_quran_metadata.Stations[i + 1].StartChapter; int next_station_start_chapter_verse = s_quran_metadata.Stations[i + 1].StartChapterVerse; for (int j = 0; j < next_station_start_chapter - 1; j++) { next_station_first_verse += this.chapters[j].Verses.Count; } next_station_first_verse += next_station_start_chapter_verse; } else { next_station_first_verse = Verse.MAX_NUMBER + 1; } int last_verse = next_station_first_verse; List<Verse> verses = new List<Verse>(); for (int j = first_verse; j < last_verse; j++) { int index = j - 1; if ((index >= 0) && (index < this.verses.Count)) { Verse verse = this.verses[index]; verses.Add(verse); } else { break; } } Station station = new Station(number, verses); this.stations.Add(station); } // setup Prostration for (int i = 0; i < s_quran_metadata.Prostrations.Length; i++) { int number = s_quran_metadata.Prostrations[i].Number; int chapter = s_quran_metadata.Prostrations[i].Chapter; int chapter_verse = s_quran_metadata.Prostrations[i].ChapterVerse; ProstrationType type = s_quran_metadata.Prostrations[i].Type; int first_verse = 0; for (int j = 0; j < chapter - 1; j++) { first_verse += this.chapters[j].Verses.Count; } first_verse += chapter_verse; if (this.verses.Count > first_verse - 1) { Verse verse = this.verses[first_verse - 1]; Prostration prostration = new Prostration(number, type, verse); this.prostrations.Add(prostration); } else { break; } } // update verse/word/letter numbers AND // update distances to previous same verse/word/letter UpdateNumbersAndDistances(SelectionScope.Book); } }
/// <summary> /// Create a new Page object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="name">Initial value of the Name property.</param> /// <param name="content">Initial value of the Content property.</param> public static Page CreatePage(global::System.Int32 id, global::System.String name, global::System.String content) { Page page = new Page(); page.Id = id; page.Name = name; page.Content = content; return page; }
/// <summary> /// Deprecated Method for adding a new object to the PageSet EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToPageSet(Page page) { base.AddObject("PageSet", page); }