// 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);
}
}
