protected void grid_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        try
        {
            string    strRoomID = grid.Rows[e.RowIndex].Cells[0].Text;
            RoomTypes room      = new RoomTypes();
            room.RoomType_ID = int.Parse(strRoomID);
            room.SelectOne();
            room.Delete();
            // bool retval=new Rooms().Delete(room.Room_ID)

            BindGridView(0);
        }
        catch (Exception ex) { }
    }
    private void DeleteRomType(int roomTypeId)
    {
        RoomTypes room = new RoomTypes();

        room.RoomType_ID = roomTypeId;
        room.SelectOne();
        if (room.Delete())
        {
            BindGridView();
        }
        else
        {
            if (room.ErrorCode == -10)
            {
                lblMsg.Text = "Cannot Delete. This Room Type is associated with Rates";
            }
            else if (room.ErrorCode == -20)
            {
                lblMsg.Text = "Cannot Delete. This Room Type is associated with Rooms";
            }
            lblMsg.ForeColor = Color.Red;
        }
    }