public decimal GetAdvanceAmount(int CustomerID) { decimal AdvanceAmt = 0; var query = Context1.SP_GetAdvanceAmountOfCustomer(CustomerID); foreach (var item in query) { AdvanceAmt = Convert.ToDecimal(item); } return(AdvanceAmt); }