public static List <BO_UnpaidCreditCustomer> GetUnPaidCreditCustomerList()
        {
            using (AprosysAccountingEntities db_aa = new AprosysAccountingEntities())
            {
                var lst = db_aa.Credit_GetUnPaidCustomers();
                List <BO_UnpaidCreditCustomer> lst_cust = new List <BO_UnpaidCreditCustomer>();
                BO_UnpaidCreditCustomer        obj;
                foreach (var _creditCustomer in lst.ToList())
                {
                    if (GetUnPaidCreditCustomerInvoices(_creditCustomer.Id).Count > 0)
                    {
                        obj      = new BO_UnpaidCreditCustomer();
                        obj.Id   = _creditCustomer.Id;
                        obj.Name = _creditCustomer.CustomerName;
                        lst_cust.Add(obj);
                    }
                }


                return(lst_cust.OrderBy(x => x.Name).ToList());
            }
        }