Example #1
0
 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));
     }
 }
Example #2
0
    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);
 }
Example #5
0
 public Model.Lang GetLang(Model.Page _page, [ScopedService] DrMofradDbContext drMofradDbContext)
 {
     return(drMofradDbContext.Langs.FirstOrDefault(lang => lang.Id == _page.LangId));
 }
Example #6
0
        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&lt;T&gt; property instead.
 /// </summary>
 public void AddToPageSet(Page page)
 {
     base.AddObject("PageSet", page);
 }