public IHttpActionResult GetListEligibleTownBuses(string sign) { var inputParams = new { sign = sign }; var response = new ListEligibleTownBusesResponse(); try { if (!VerifyAPICaller(sign, response)) { return(Ok(response)); } response = _walletApiLogic.GetListEligibleTownBuses(); VerifyResponse(MethodBase.GetCurrentMethod(), response, inputParams); } catch (Exception ex) { Fail(MethodBase.GetCurrentMethod(), response, ex, inputParams, "Error : Failed to query GetListEligibleTownBuses"); } return(Ok(response)); }
public ListEligibleTownBusesResponse GetListEligibleTownBuses() { var EligibleTownBuseslst = new ListEligibleTownBusesResponse(); try { var transactionOptions = new System.Transactions.TransactionOptions(); transactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted; using (var transactionScope = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required, transactionOptions)) { var townBuses_supportArea = new WalletTownBus_SupportedAreaQueryBuilder(new TownBusEntities()) .GetTownBus_SupportedAreaByStatus().ToList(); foreach (var item_1 in townBuses_supportArea.GroupBy(x => x.Area_Name)) { Areas areaItem = new Areas(); areaItem.Area_Name = item_1.Key; foreach (var item_2 in townBuses_supportArea.Where(x => x.Area_Name == item_1.Key)) { TownBusSupportedArea townbusSA = new TownBusSupportedArea(); townbusSA.TownBusType_Bus_No = item_2.TownBusType_Bus_No; townbusSA.TownBusType_Bus_ID = item_2.TownBusType_Bus_ID.Value; areaItem.TownBuslst.Add(townbusSA); } EligibleTownBuseslst.ListEligibleTownBuses.Add(areaItem); } } } catch (Exception ex) { var logWallet = new LogWallet(); logWallet.Log(MethodBase.GetCurrentMethod(), "", ex, ""); return(null); } return(EligibleTownBuseslst); }