public static IOrderedEnumerable <FinanceCategory> ListFinanceByType(FinanceCategory financeCategoryVO) { DBEntities db = SingletonObjectContext.Instance.Context; return(db.FinanceCategories.Include("collFinanceCategorySub").Include("collFinanceCategorySub.collFinance").Where(x => x.Status > 0 && x.Type.Equals(financeCategoryVO.Type)).ToList().OrderBy(x => x.Name)); }
public static IOrderedEnumerable <PaymentForm> ListAll() { DBEntities db = SingletonObjectContext.Instance.Context; return(db.PaymentForms.Where(x => x.Status > 0).ToList().OrderBy(x => x.Name)); }
public static IOrderedEnumerable <FinanceCategory> ListAll() { DBEntities db = SingletonObjectContext.Instance.Context; return(db.FinanceCategories.Where(x => x.Status > 0).ToList().OrderBy(x => x.Name)); }