コード例 #1
0
ファイル: Service.cs プロジェクト: harshadura/Virtual-Mart
    public int booking(int room_id, int no_of_room, string room_type, double room_price, double total_price, string date)
    {
        Hotel1DataSet1TableAdapters.bookingTableAdapter hb1 = new Hotel1DataSet1TableAdapters.bookingTableAdapter();
        Hotel1DataSet1TableAdapters.roompriceTableAdapter hb2 = new Hotel1DataSet1TableAdapters.roompriceTableAdapter();
        Hotel1DataSet1TableAdapters.roomTableAdapter hb3 = new Hotel1DataSet1TableAdapters.roomTableAdapter();

        if (room_type == "BB")
        {
            int noA = (int)hb3.getAvailableRoomBB(room_id);
            if (noA >= no_of_room)
            {
                if (room_price >= (double)hb2.getCostPrice("BB") && room_price <= (double)hb2.getMaxPrice("BB"))
                {

                    hb1.Insert(room_id, no_of_room, room_type, room_price, total_price, date);
                    hb3.UpdateRoomBB(noA - no_of_room, room_id);
                    return 1;
                }
                else
                {
                    return 0;
                }

            }

            else
            {
                return 0;
            }
        }

        else if (room_type == "HB")
        {
            int noB = (int)hb3.getAvailableRoomHB(room_id);
            if (noB >= no_of_room)
            {
                if (room_price >= (double)hb2.getCostPrice("HB") && room_price <= (double)hb2.getMaxPrice("HB"))
                {

                    hb1.Insert(room_id, no_of_room, room_type, room_price, total_price, date);
                    hb3.UpdateRoomHB(noB - no_of_room,room_id);
                    return 1;
                }
                else
                {
                    return 0;
                }

            }

            else
            {
                return 0;
            }
        }

        else if (room_type == "FB")
        {

            int noC = (int)hb3.getAvailableRoomFB(room_id);
            if (noC >= no_of_room)
            {
                if (room_price >= (double)hb2.getCostPrice("FB") && room_price <= (double)hb2.getMaxPrice("FB"))
                {

                    hb1.Insert(room_id, no_of_room, room_type, room_price, total_price, date);
                    hb3.UpdateRoomFB(noC - no_of_room,room_id);
                    return 1;
                }
                else
                {
                    return 0;
                }

            }

            else
            {
                return 0;
            }
        }

        else
        {
            return 0;
        }
    }
コード例 #2
0
ファイル: Service.cs プロジェクト: harshadura/Virtual-Mart
    public int cancel(int bookingid)
    {
        Hotel1DataSet1TableAdapters.bookingTableAdapter hb4 = new Hotel1DataSet1TableAdapters.bookingTableAdapter();

        if (hb4.getNoOfRoom(bookingid) != null)
        {

            string room_type =hb4.getRoomType(bookingid);
            int room_id = (int)hb4.getRoomID(bookingid);
            int book_room = (int)hb4.getNoOfRoom(bookingid);

            Hotel1DataSet1TableAdapters.roomTableAdapter hb5 = new Hotel1DataSet1TableAdapters.roomTableAdapter();

            if (room_type == "BB")
            {
                int room = (int)hb5.getAvailableRoomBB(room_id);

                hb5.UpdateRoomBB((room + book_room), room_id);
                hb4.DeleteBooking(bookingid);
               return 1;
            }

            else if (room_type == "HB")
            {
                int room = (int)hb5.getAvailableRoomHB(room_id);

                hb5.UpdateRoomHB((room + book_room), room_id);
                hb4.DeleteBooking(bookingid);
                return 1;
            }

            else if (room_type == "FB")
            {
                int room = (int)hb5.getAvailableRoomFB(room_id);

                hb5.UpdateRoomFB((room + book_room), room_id);
                hb4.DeleteBooking(bookingid);
                return 1;
            }

             else
            {
                return 0;
            }

        }

        else
        {
            return 0;
        }
    }