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