protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DropDownListRoom.DataSource = getData("spGetRoomType", null);
                DropDownListRoom.DataBind();
                ListItem LIRoomType = new ListItem("---Select---", "-1");
                DropDownListRoom.Items.Insert(0, LIRoomType);



                DropDownListGH.DataSource = getData("spGetGuestHouse", null);
                DropDownListGH.DataBind();
                ListItem LIGuestHouse = new ListItem("---Select---", "-1");
                DropDownListGH.Items.Insert(0, LIGuestHouse);
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            LoginUser user = Session["user"] as LoginUser;

            if (!(user.HasPrimaryRole("admin") || user.HasSecondaryRole("admin")))
            {
                Response.Redirect("logout.aspx");
            }

            if (!IsPostBack)
            {
                DropDownListRoom.DataSource = getData("spGetRoomType", null);
                DropDownListRoom.DataBind();
                ListItem LIRoomType = new ListItem("---Select---", "-1");
                DropDownListRoom.Items.Insert(0, LIRoomType);



                DropDownListGH.DataSource = getData("spGetGuestHouse", null);
                DropDownListGH.DataBind();
                ListItem LIGuestHouse = new ListItem("---Select---", "-1");
                DropDownListGH.Items.Insert(0, LIGuestHouse);
            }
        }