public List <AvailableBalanceModel> GetAvailableBalance() { var agents = ent.Agents.OrderBy(x => x.AgentName); List <AvailableBalanceModel> Listmodel = new List <AvailableBalanceModel>(); foreach (var agentinfo in agents) { var data = ent.Air_GetAvailableBalance(agentinfo.AgentId).ToList(); var otherData = data.FirstOrDefault(); AvailableBalanceModel model = new AvailableBalanceModel(); model.CreditLimit = otherData.CreditLimit.Value; model.RemainingBalance = otherData.Amount.Value; model.AgentName = otherData.AgentName; foreach (var currency in data) { CurrencyDetail detail = new CurrencyDetail(); detail.Amount = currency.Amount.ToString(); detail.CreditLimit = currency.CreditLimit.ToString(); detail.CurrenyCode = currency.CurrencyCode.ToString(); detail.LedgerAmount = currency.LedgerAmount.ToString(); model.CurrencyList.Add(detail); // model.Currency = item.CurrencyCode; } Listmodel.Add(model); } return(Listmodel); }
public AvailableBalanceViewModel AvilableBalance(int AgentId) { var AvailableBalanceResult = _ent.Air_GetAvailableBalance(AgentId).ToList(); var Balanceviewmodel = new AvailableBalanceViewModel(); /// For NPR balance /// //Currency Balanceviewmodel.CurrencyNPR = AvailableBalanceResult.ElementAtOrDefault(0).CurrencyCode; Balanceviewmodel.CreditLimitNPR = AvailableBalanceResult.ElementAtOrDefault(0).CreditLimit; Balanceviewmodel.CurrentBalanceNPR = AvailableBalanceResult.ElementAtOrDefault(0).Amount; /// For USD balance Balanceviewmodel.CurrencyUSD = AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode == "USD" ? AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode : ""; Balanceviewmodel.CreditLimitUSD = AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode == "USD" ? AvailableBalanceResult.ElementAtOrDefault(1).CreditLimit : double.Parse(""); Balanceviewmodel.CurrentBalanceUSD = AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode == "USD" ? AvailableBalanceResult.ElementAtOrDefault(1).Amount : double.Parse(""); /// For INR balance Balanceviewmodel.CurrencyINR = AvailableBalanceResult.ElementAtOrDefault(2).CurrencyCode == "INR" ? AvailableBalanceResult.ElementAtOrDefault(2).CurrencyCode : ""; Balanceviewmodel.CreditLimitINR = AvailableBalanceResult.ElementAtOrDefault(2).CurrencyCode == "INR" ? AvailableBalanceResult.ElementAtOrDefault(2).CreditLimit : double.Parse(""); Balanceviewmodel.CurrentBalanceINR = AvailableBalanceResult.ElementAtOrDefault(2).CurrencyCode == "INR" ? AvailableBalanceResult.ElementAtOrDefault(2).Amount : double.Parse(""); if (Balanceviewmodel.CurrentBalanceNPR == null) { Balanceviewmodel.CurrentBalanceNPR = 0; } double minBalance = Balanceviewmodel.CreditLimitNPR.Value * 10 * 0.01; //10 % of Credit limit if (Balanceviewmodel.CurrentBalanceNPR <= minBalance) //|| Balanceviewmodel.Amount==0) { Balanceviewmodel.isLowBalanceNPR = true; } else { Balanceviewmodel.isLowBalanceNPR = false; } double minBalanceUSD = Balanceviewmodel.CreditLimitUSD.Value * 10 * 0.01; //10 % of Credit limit if (Balanceviewmodel.CurrentBalanceUSD <= minBalance) //|| Balanceviewmodel.Amount==0) { Balanceviewmodel.isLowBalanceUSD = true; } else { Balanceviewmodel.isLowBalanceUSD = false; } double minBalanceINR = Balanceviewmodel.CreditLimitINR.Value * 10 * 0.01; //10 % of Credit limit if (Balanceviewmodel.CurrentBalanceINR <= minBalanceINR) //|| Balanceviewmodel.Amount==0) { Balanceviewmodel.isLowBalanceINR = true; } else { Balanceviewmodel.isLowBalanceINR = false; } return(Balanceviewmodel); }