Esempio n. 1
0
 public override IEnumerable <EntityProductData> GetAll()
 {
     Log.Info("Accessing EntityProductRepo GetAll function");
     using (entity_context)
     {
         return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_entity_product_all")));
     }
 }
Esempio n. 2
0
 public override IEnumerable <AttributeData> GetAll()
 {
     Log.Info("Accessing AttributeRepo GetAll function");
     using (entity_context)
     {
         return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_attribute_all")));
     }
 }
Esempio n. 3
0
 public override IEnumerable <ChartOfAccountsData> GetAll()
 {
     Log.Info("Accessing ChartOfAccountsRepo GetAll function");
     using (entity_context)
     {
         return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_chart_of_accounts_all")));
     }
 }
Esempio n. 4
0
 public override IEnumerable <OrderItemData> GetAll()
 {
     Log.Info("Accessing OrderItemRepo GetAll function");
     using (entity_context)
     {
         return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_order_item_all")));
     }
 }
 public override IEnumerable <AddressPostalData> GetAll()
 {
     Log.Info("Accessing AddressPostalRepo GetAll function");
     using (entity_context)
     {
         return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_address_postal_all")));
     }
 }
Esempio n. 6
0
 public override IEnumerable <UserSessionData> GetAll()
 {
     Log.Info("Accessing UserSessionRepo GetAll function");
     using (entity_context)
     {
         return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_user_session_all")));
     }
 }
 public override IEnumerable <InvoiceStatusData> GetAll()
 {
     Log.Info("Accessing InvoiceStatusRepo GetAll function");
     using (entity_context)
     {
         return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_invoice_status_all")));
     }
 }
        public IEnumerable <LedgerTxnData> GetAll(LedgerData gl_data)
        {
            Log.Info("Accessing LedgerTxnRepo GetAll function");
            var pcol = new List <SqlParameter>()
            {
                Mapper.BuildParam("@ledger_key", gl_data.LedgerKey)
            };

            using (entity_context)
            {
                return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_ledger_txn_all")));
            }
        }
        public IEnumerable <LedgerData> GetAll(int company_key)
        {
            Log.Info("Accessing LedgerRepo GetAll function");
            var pcol = new List <SqlParameter>()
            {
                Mapper.BuildParam("@company_key", company_key)
            };

            using (entity_context)
            {
                return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_ledger_all")));
            }
        }