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