// Url:localhost:5024/api/Values/GetCruiseOpendates?AgentId=248 public DataTable GetCruiseOpendates(int AgentId) { DataTable dt12 = new DataTable(); HttpContext httpContext = HttpContext.Current; string authHeader = httpContext.Request.Headers["Authorization"]; if (authHeader != null && authHeader.StartsWith("Basic")) { string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim(); blsrch.action = "GetOpenDatesCruiseApi"; blsrch.StartDate = System.DateTime.Now; blsrch.EndDate = Convert.ToDateTime("1900-01-01"); blsrch.AgentId = AgentId; //{ // //blsrch.AgentId = 247; //} AgentMaster oAgentMaster = new AgentMaster(); // int AgentId = blsrch.AgentId; AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(AgentId); string TokenNo = oAgentData[0].TokenNo.ToString(); if (TokenNo != "" && TokenNo == encodedUsernamePassword) { dtres = dlsrch.GetCruiseOpenDatesPackage(blsrch); DataTable dt = dlsrch.fetchall(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { blsrch.PackageId = dt.Rows[i]["PackageId"].ToString(); dtres = dlsrch.GetCruiseOpenDatesPackage(blsrch); dt12.Merge(dtres); dt12.AcceptChanges(); } } DataSet ds = new DataSet(); ds.Tables.Add(dt12); string value = ds.GetXml(); } return(dt12); } else { return(dt12); } }
// GET api/<controller> //public IEnumerable<Student> Get() //{ // return stud; //} // GET api/<controller>/5 //localhost:5024/api/Values/7 night 8 day MV Mahabaahu Upstream Cruise/2018-01-14/248 public string Get(string pakackagename, DateTime departure, int AgentId) { string value = ""; HttpContext httpContext = HttpContext.Current; string authHeader = httpContext.Request.Headers["Authorization"]; if (authHeader != null && authHeader.StartsWith("Basic")) { string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim(); AgentMaster oAgentMaster = new AgentMaster(); AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(AgentId); string TokenNo = oAgentData[0].TokenNo.ToString(); if (TokenNo != "" && TokenNo == encodedUsernamePassword) { var dateAndTime = DateTime.Now; var date = dateAndTime.Date; //DateTime d = DateTime.Now.Year; DataTable dt1 = dlsr.getpackaageid(pakackagename, departure); if (dt1 != null && dt1.Rows.Count > 0) { pakackageid = dt1.Rows[0]["PackageId"].ToString(); departureId = Convert.ToInt32(dt1.Rows[0]["Id"].ToString()); } DataTable dt = cab.bindroomddl(pakackageid, departureId); dv = new DataView(); dv = new DataView(dt, "BookedStatus='" + "Available" + "'", "BookedStatus", DataViewRowState.CurrentRows); DataTable dt2 = dv.ToTable(); DataSet ds = new DataSet(); ds.Tables.Add(dt2); value = ds.GetXml(); return(value); } else { return(value); } } else { return(value); } }
//localhost:5024/api/Values/203,109,108/7/2/248 call MultiplelockRoom public string GetLockRoom(string roomno, int accomid, int roomcatid, int AgentId) { string value = ""; HttpContext httpContext = HttpContext.Current; string authHeader = httpContext.Request.Headers["Authorization"]; if (authHeader != null && authHeader.StartsWith("Basic")) { string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim(); //var values = Request.GetQueryNameValuePairs() // .Where(kvp => kvp.Key == "roomno") // .Select(kvp => int.Parse(kvp.Value)) // .ToArray(); AgentMaster oAgentMaster = new AgentMaster(); // int AgentId = blsrch.AgentId; AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(AgentId); string TokenNo = oAgentData[0].TokenNo.ToString(); if (TokenNo != "" && TokenNo == encodedUsernamePassword) { string[] values = roomno.Split(','); foreach (var lockRoom in values) { roomno = lockRoom.ToString(); cab.LockTheBooking(roomno, accomid, roomcatid); } value = "Room is Locked"; return(value); } return(value); } else { value = "Please set Header Authentication"; return(value); } }
///api/Values/5 nights 6 days MV Mahabaahu Upstream Cruise/2018-10-16/2018-10-21/4/rabiul/102,208/7/2/online/248 public string Get1(string pakackagename, DateTime chekindate, DateTime checkoutdate, int total, string refrence, string roomno, int accomid, int roomcatid, string paymentmethod, int agentid) { string value = ""; DataSet ds = new DataSet(); HttpContext httpContext = HttpContext.Current; string authHeader = httpContext.Request.Headers["Authorization"]; if (authHeader != null && authHeader.StartsWith("Basic")) { string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim(); AgentMaster oAgentMaster = new AgentMaster(); AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(agentid); string TokenNo = oAgentData[0].TokenNo.ToString(); if (TokenNo != "" && TokenNo == encodedUsernamePassword) { DataTable dt1 = dlsr.getpackaageid(pakackagename, chekindate); if (dt1 != null && dt1.Rows.Count > 0) { pakackageid = dt1.Rows[0]["PackageId"].ToString(); departureId = Convert.ToInt32(dt1.Rows[0]["Id"].ToString()); } DataTable dt = cab.bindroomddl(pakackageid, departureId); dv = new DataView(); string[] strArray = roomno.Split(','); //foreach (object obj in strArray) //{ // roomno = obj.ToString(); //} //var values = Request.GetQueryNameValuePairs() // .Where(kvp => kvp.Key == "roomno") // .Select(kvp => int.Parse(kvp.Value)) // .ToArray(); int n = cab.InsertParentTableData(pakackageid, chekindate, checkoutdate, total, refrence, agentid); foreach (var lockRoom in strArray) { roomno = lockRoom.ToString(); dv = new DataView(dt, "RoomNo='" + roomno + "'", "RoomNo", DataViewRowState.CurrentRows); DataTable dtcheck = dv.ToTable(); dv = new DataView(dtcheck, "BookedStatus='" + "Available" + "'", "BookedStatus", DataViewRowState.CurrentRows); if (dv.Count > 0) { //var values = Request.GetQueryNameValuePairs() // .Where(kvp => kvp.Key == "roomno") // .Select(kvp => int.Parse(kvp.Value)) // .ToArray(); //foreach (var lockRoom in strArray) //{ //roomno = lockRoom.ToString(); cab.InsertChildTableData(n, total, roomno, paymentmethod, chekindate, pakackageid, total, roomcatid); cab.LockTheBooking(roomno, accomid, roomcatid); blsr.action = "fetchbybookingId"; blsr._iBookingId = n; DataTable dtfetch = dlsr.fetchbybookingid(blsr); DataTable dtvalue = cab.loadbookingDetails(pakackagename, n, total, roomno, paymentmethod, chekindate, checkoutdate, pakackageid, total, roomcatid, Convert.ToInt32(dtfetch.Rows[0]["NoOFNights"].ToString())); //DataSet ds = new DataSet(); ds.Tables.Add(dtvalue); //value = ds.GetXml(); //// } //return value; } //else //{ // return "Room is already booked"; //} } } value = ds.GetXml(); // } if (value != "<NewDataSet />") { return(value); } else { return("Room is already booked"); } } else { return(value); } }