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