?using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
    public Service () {

        //如果使用設計的組件，請取消注釋以下行 
        //InitializeComponent(); 
    }

    [WebMethod]
    public string HelloWorld() 
    {
        return "Hello World";
    }
    [WebMethod]
    public bool InsertBookRoom(string bookUser,string bookDate,string bookRoom,string bookRoomCount)
    {
        SqlConnection con = null;
        try
        {
            string sqlConn = "workstation id=HZ_IT_ZHONGJ;packet size=4096;integrated security=SSPI;data source=.;persist security info=False;initial catalog=hotel";
            // string sqlConn = "server=.;database=hotel;uid=sa;pwd=;Max Pool Size=20000;";
            con = new SqlConnection(sqlConn);
            string sqlStr = "INSERT INTO BookRoom VALUES('" + bookUser + "','" + bookDate + "','" + bookRoom + "','" + bookRoomCount + "')";
            SqlCommand cmd = new SqlCommand(sqlStr, con);
            con.Open();
            cmd.ExecuteNonQuery();
            return true;
            
        }
        catch
        {
            return false;
        }
        finally
        {
            con.Close();
        }
        
    
    }

    
}