this is the code to generate the wsdl: using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Data.SqlClient; using System.Data; using System.Xml;
[WebService(Namespace = "http://localhost/bookingsystem";)] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class Service : System.Web.Services.WebService { public Service () { //SqlConnection myConnection1 = new SqlConnection ("server=localhost;database=booking;user id=booking; password=booking"); } [WebMethod(Description = "Login")] public DataSet logon(string uname, string upassword) { int userId; SqlConnection myConnection = new SqlConnection ("server=localhost;database=booking;user id=booking; password=booking"); SqlDataAdapter myCommand1 = new SqlDataAdapter("SELECT * FROM UserDetails WHERE User_Name='" + uname + "' AND User_Password = '"+upassword+"'", myConnection); DataSet ds = new DataSet(); myCommand1.Fill(ds, "login"); if (ds.Tables[0].Rows.Count > 0) { userId = int.Parse(ds.Tables[0].Rows[0] ["user_id"].ToString()); DataSet detailSet = this.userDetails(userId); //userDetails(userId); ds.Merge(detailSet, true); } else { SqlDataAdapter myCommand13 = new SqlDataAdapter("SELECT * FROM INVALID", myConnection); ds.Tables.Clear(); myCommand13.Fill(ds, "INVALID"); } return ds; } [WebMethod(Description = "LoginXML")] public XmlDocument logonXML(string uname, string upassword) { int userId; SqlConnection myConnection = new SqlConnection ("server=localhost;database=booking;user id=booking; password=booking"); SqlDataAdapter myCommand1 = new SqlDataAdapter("SELECT * FROM UserDetails WHERE User_Name='" + uname + "' AND User_Password = '" + upassword + "'", myConnection); DataSet ds = new DataSet(); myCommand1.Fill(ds, "login"); if (ds.Tables[0].Rows.Count > 0) { userId = int.Parse(ds.Tables[0].Rows[0] ["user_id"].ToString()); DataSet detailSet = this.userDetails(userId); //userDetails(userId); ds.Merge(detailSet, true); } else { SqlDataAdapter myCommand13 = new SqlDataAdapter("SELECT * FROM INVALID", myConnection); ds.Tables.Clear(); myCommand13.Fill(ds, "INVALID"); } XmlDataDocument dataDoc = new XmlDataDocument(ds); return dataDoc; //return ds; } private DataSet userDetails(int userID) { SqlConnection myConnection = new SqlConnection ("server=localhost;database=booking;user id=booking; password=booking"); SqlDataAdapter myCommand1 = new SqlDataAdapter("SELECT dbo.Friends.Friends_ID, dbo.Friends.Friends_Email FROM dbo.Friends WHERE dbo.Friends.User_ID = '" + userID + "'", myConnection); SqlDataAdapter myCommand3 = new SqlDataAdapter("SELECT Meet_GUID, Meet_Pin, Meeting_Date, Meeting_Len, Meet_Start, Meet_DAteAdded, Meet_ID, Meet_User FROM dbo.Meetings WHERE (Meet_User = '1')", myConnection); DataSet ds = new DataSet(); myCommand1.Fill(ds, "Friends"); myCommand3.Fill(ds, "MyMeetings"); return ds; } [WebMethod(Description = "Meeting Attendees")] public DataSet meetingAttendees(string MeetGuid) { SqlConnection myConnection = new SqlConnection ("server=localhost;database=booking;user id=booking; password=booking"); SqlDataAdapter myCommand1 = new SqlDataAdapter("SELECT Attend_Email, Attend_Meet FROM dbo.Attendees WHERE (Attend_Meet = '"+MeetGuid+"')", myConnection); DataSet ds = new DataSet(); myCommand1.Fill(ds, "Attendees"); return ds; } [WebMethod(Description = "Logon2")] public XmlDocument logonXML1(string uname, string upassword) { //int userId; SqlConnection myConnection = new SqlConnection ("server=localhost;database=booking;user id=booking; password=booking"); SqlDataAdapter myCommand1 = new SqlDataAdapter("SELECT * FROM UserDetails WHERE User_Name='" + uname + "' AND User_Password = '" + upassword + "'", myConnection); DataSet ds = new DataSet(); myCommand1.Fill(ds, "login"); if (ds.Tables[0].Rows.Count > 0) { // XmlDataDocument dataDoc = new XmlDataDocument(ds); //return true; } else { SqlDataAdapter myCommand13 = new SqlDataAdapter("SELECT * FROM INVALID", myConnection); ds.Tables.Clear(); myCommand13.Fill(ds, "INVALID"); } XmlDataDocument dataDoc = new XmlDataDocument(ds); return dataDoc; } } ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/nhFolB/TM --------------------------------------------------------------------~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
