using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Newdelhibarassocia
{
    public partial class MasterPage : System.Web.UI.MasterPage
    {
        Class1 obj = new Class1();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                LoadNotice();
                LoadCommunication();
            }
        }

        private void LoadNotice()
        {
            string qrajneetiMaxID = "select top 5  pkid,Title,Type,isnull(pdfPath,'Notice.aspx?id='+CONVERT(VARCHAR(max),pkid)) as pdfPath from newdelhibar_NoticeBoard order by pkid Desc";
            DataSet dsrajneetiMaxID = obj.ReturnDataSet(qrajneetiMaxID);
            if (dsrajneetiMaxID != null && dsrajneetiMaxID.Tables[0].Rows.Count > 0)
            {
                //MaxID = Convert.ToInt32(dsrajneetiMaxID.Tables[0].Rows[0][0]);
                Repeater1.DataSource = dsrajneetiMaxID;
                Repeater1.DataBind();
            }
        }

        private void LoadCommunication()
        {
            string qrajneetiMaxID = "select top 5 pkid,Title,Type,isnull(pdfPath,'Communication.aspx?id='+CONVERT(VARCHAR(max),pkid)) as pdfPath from newdelhibar_CommunicationBoard order by pkid Desc";
            DataSet dsrajneetiMaxID = obj.ReturnDataSet(qrajneetiMaxID);
            if (dsrajneetiMaxID != null && dsrajneetiMaxID.Tables[0].Rows.Count > 0)
            {
                //MaxID = Convert.ToInt32(dsrajneetiMaxID.Tables[0].Rows[0][0]);
                Repeater2.DataSource = dsrajneetiMaxID;
                Repeater2.DataBind();
            }
        }
    }
}