private BusesSearchFilter GetCityIDsOfProviders(BusesSearchFilter objBusesSearchFilter, ClientAPIDetails objClientAPIDetails, int sourceId, int destinationId, String dateofjourney) { DataSet dsProviders = new DataSet(); if (objClientAPIDetails.ProviderName != "MORNINGSTAR") { ClsBAL bal = new ClsBAL(); bal.ProviderID = objClientAPIDetails.ProviderID; bal.sourceId = sourceId; bal.destionationId = destinationId; dsProviders = bal.GetAPIID(); //DataTable DtRSources = new DataTable(); //DataSet DsRSources = new DataSet(); //DsRSources.ReadXml(System.Web.HttpContext.Current.Server.MapPath("~/App_Data/" + "SourcesAPI.xml")); //IEnumerable<DataRow> API_Source_ID = from i in DsRSources.Tables[0].AsEnumerable() // where i.Field<string>("Source_ID") == sourceId.ToString() && i.Field<string>("Provider_Id") == objClientAPIDetails.ProviderID.ToString() // select i; //if (API_Source_ID.Count() > 0) //{ // DtRSources = API_Source_ID.CopyToDataTable(); // DataSet ds = new DataSet(); // ds.Tables.Add(DtRSources); //} } else { ClsBAL bal = new ClsBAL(); bal.ProviderID = 102; bal.sourceId = sourceId; bal.destionationId = destinationId; dsProviders = bal.GetAPIID(); } //DataSet dsProviders = ExecuteDataSet("SELECT " + objClientAPIDetails.ProviderName + " FROM dbo.tbl_Sources WHERE Source_ID = '" + sourceId + "' " + // "SELECT " + objClientAPIDetails.ProviderName + " FROM dbo.tbl_Sources WHERE Source_ID = '" + destinationId + "'"); if (dsProviders.Tables[0].Rows.Count > 0 && dsProviders.Tables[1].Rows.Count > 0) { if (objClientAPIDetails.ProviderName == "BITLA") { foreach (DataRow bsdr in dsProviders.Tables[0].Rows) { if (source_ids.ToString() == "") { source_ids = bsdr[0].ToString(); } else { source_ids = source_ids + "," + bsdr[0].ToString(); } } foreach (DataRow bddr in dsProviders.Tables[1].Rows) { if (Destination_Ids.ToString() == "") { Destination_Ids = bddr[0].ToString(); } else { Destination_Ids = Destination_Ids + "," + bddr[0].ToString(); } } } else if (objClientAPIDetails.ProviderName == "TICKETGOOSE") { foreach (DataRow tsdr in dsProviders.Tables[0].Rows) { if (Tsource_ids.ToString() == "") { Tsource_ids = tsdr[0].ToString(); } else { Tsource_ids = Tsource_ids + "," + tsdr[0].ToString(); } } foreach (DataRow tddr in dsProviders.Tables[1].Rows) { if (TDestination_Ids.ToString() == "") { TDestination_Ids = tddr[0].ToString(); } else { TDestination_Ids = TDestination_Ids + "," + tddr[0].ToString(); } } } else if (objClientAPIDetails.ProviderName == "MORNINGSTAR") { foreach (DataRow msdr in dsProviders.Tables[0].Rows) { if (Msource_ids.ToString() == "") { Msource_ids = msdr[0].ToString(); } else { Msource_ids = Msource_ids + "," + msdr[0].ToString(); } } foreach (DataRow mddr in dsProviders.Tables[1].Rows) { if (MDestination_Ids.ToString() == "") { MDestination_Ids = mddr[0].ToString(); } else { MDestination_Ids = MDestination_Ids + "," + mddr[0].ToString(); } } } else if (objClientAPIDetails.ProviderName == "RAJESH") { foreach (DataRow rsdr in dsProviders.Tables[0].Rows) { if (Rsource_ids.ToString() == "") { Rsource_ids = rsdr[0].ToString(); } else { Rsource_ids = Rsource_ids + "," + rsdr[0].ToString(); } } foreach (DataRow rddr in dsProviders.Tables[1].Rows) { if (RDestination_Ids.ToString() == "") { RDestination_Ids = rddr[0].ToString(); } else { RDestination_Ids = RDestination_Ids + "," + rddr[0].ToString(); } } } else if (objClientAPIDetails.ProviderName == "KALLADA") { foreach (DataRow kdsdr in dsProviders.Tables[0].Rows) { if (KDsource_ids.ToString() == "") { KDsource_ids = kdsdr[0].ToString(); } else { KDsource_ids = KDsource_ids + "," + kdsdr[0].ToString(); } } foreach (DataRow kdddr in dsProviders.Tables[1].Rows) { if (KDDestination_Ids.ToString() == "") { KDDestination_Ids = kdddr[0].ToString(); } else { KDDestination_Ids = KDDestination_Ids + "," + kdddr[0].ToString(); } } } else if (objClientAPIDetails.ProviderName == "KAVERI") { foreach (DataRow ksdr in dsProviders.Tables[0].Rows) { if (Ksource_ids.ToString() == "") { Ksource_ids = ksdr[0].ToString(); } else { Ksource_ids = Ksource_ids + "," + ksdr[0].ToString(); } } foreach (DataRow kddr in dsProviders.Tables[1].Rows) { if (KDestination_Ids.ToString() == "") { KDestination_Ids = kddr[0].ToString(); } else { KDestination_Ids = KDestination_Ids + "," + kddr[0].ToString(); } } } else if (objClientAPIDetails.ProviderName == "SAIANJANA") { foreach (DataRow ssdr in dsProviders.Tables[0].Rows) { if (SSsource_ids.ToString() == "") { SSsource_ids = ssdr[0].ToString(); } else { SSsource_ids = SSsource_ids + "," + ssdr[0].ToString(); } } foreach (DataRow ssddr in dsProviders.Tables[1].Rows) { if (SSDestination_Ids.ToString() == "") { SSDestination_Ids = ssddr[0].ToString(); } else { SSDestination_Ids = SSDestination_Ids + "," + ssddr[0].ToString(); } } } else if (objClientAPIDetails.ProviderName == "SVR") { foreach (DataRow sdr in dsProviders.Tables[0].Rows) { if (Ssource_ids.ToString() == "") { Ssource_ids = sdr[0].ToString(); } else { Ssource_ids = Ssource_ids + "," + sdr[0].ToString(); } } foreach (DataRow sddr in dsProviders.Tables[1].Rows) { if (SDestination_Ids.ToString() == "") { SDestination_Ids = sddr[0].ToString(); } else { SDestination_Ids = SDestination_Ids + "," + sddr[0].ToString(); } } } //easybus else if (objClientAPIDetails.ProviderName == "EASYBUS") { foreach (DataRow Edr in dsProviders.Tables[0].Rows) { if (Esource_ids.ToString() == "") { Esource_ids = Edr[0].ToString(); //Esource_ids = "38"; } else { Esource_ids = Esource_ids + "," + Edr[0].ToString(); } } foreach (DataRow Eddr in dsProviders.Tables[1].Rows) { if (EDestination_Ids.ToString() == "") { EDestination_Ids = Eddr[0].ToString(); // EDestination_Ids = "32"; } else { EDestination_Ids = EDestination_Ids + "," + Eddr[0].ToString(); } } //EDestination_Ids=38+","+32; } objBusesSearchFilter.SourceID = 0; // objBusesSearchFilter.DestinationID = int.Parse(dsProviders.Tables[1].Rows[0][0].ToString()); objBusesSearchFilter.DestinationID = 0; objBusesSearchFilter.JourneyDate = dateofjourney; } dsProviders.Dispose(); return objBusesSearchFilter; }
private AvailableTrips GETBITLROUTES(BusesSearchFilter objBusesSearchFilter, ClientAPIDetails objClientAPIDetails, int sourceId, int destinationId, String dateofjourney) { ClsBAL bal = new ClsBAL(); bal.ProviderID = objClientAPIDetails.ProviderID; bal.sourceId = sourceId; bal.destionationId = destinationId; DataSet dsProviders = bal.GetAPIID(); //DataSet dsProviders = ExecuteDataSet("SELECT " + objClientAPIDetails.ProviderName + " FROM dbo.tbl_Sources WHERE Source_ID = '" + sourceId + "' " + // "SELECT " + objClientAPIDetails.ProviderName + " FROM dbo.tbl_Sources WHERE Source_ID = '" + destinationId + "'"); if (dsProviders.Tables[0].Rows.Count > 0 && dsProviders.Tables[1].Rows.Count > 0) { if (objClientAPIDetails.ProviderName == "BITLA") { for (int k = 0; k < dsProviders.Tables.Count; k++) { BSID = dsProviders.Tables[0].Rows[k][0].ToString() == "" ? 0 : int.Parse(dsProviders.Tables[0].Rows[k][0].ToString()); BDID = dsProviders.Tables[1].Rows[k][0].ToString() == "" ? 0 : Convert.ToInt32(dsProviders.Tables[1].Rows[k][0]); if (BSID > 0 && BDID > 0) { BDate = dateofjourney; BURL = objClientAPIDetails.APIURL + "/"; BConsumerKey = objClientAPIDetails.ConsumerKey; BCOnsumerSecretKey = objClientAPIDetails.ConsumerSecret; BPID = objClientAPIDetails.ProviderID; BProviderName = objClientAPIDetails.ProviderName; Tbus = BITLA(BURL, BConsumerKey, BCOnsumerSecretKey, BPID, BProviderName, BSID, BDID, BDate); bus = trips(Tbus); } } } } dsProviders.Dispose(); return bus; }