C# (CSharp) Excel_Interface EVENT_INFO_Table_DAOManager Examples

Example #1

        public static ObservableCollection <EventViewModel> dbLoad(string itemCode)
        {
            ObservableCollection <EventViewModel> eventVMList = new ObservableCollection <EventViewModel>();

            EVENT_INFO_Table_DAOManager daoManager = new EVENT_INFO_Table_DAOManager();

            daoManager.KeyColumn_ = itemCode;

            daoManager.select(DataBaseConnectManager.ConnectionFactory("myDB"));

            foreach (var item in daoManager.DAOList_)
            {
                EventViewModel evm = new SettlementEventViewModel();

                evm.setFromDAO(item);

                eventVMList.Add(evm);
            }

            return(eventVMList);
        }

Example #2

        public void dbLoad()
        {
            this.eventVMList_ = new ObservableCollection <EventViewModel>();

            EVENT_INFO_Table_DAOManager daoManager = new EVENT_INFO_Table_DAOManager();

            daoManager.KeyColumn_ = this.itemCode_;

            daoManager.select(DataBaseConnectManager.ConnectionFactory("myDB"));

            foreach (var item in daoManager.DAOList_)
            {
                EventViewModel evm = new SettlementEventViewModel();

                evm.setFromDAO(item);

                this.eventVMList_.Add(evm);
            }

            //((EventManagerView)this.view_).refereshDataContext();
        }

Example #3

File: OTCApplicationEventViewModel.cs Project: minikie/OTCDerivativesCalculatorModule

        // d : position 기준일
        public static void loadWholeEvent(DateTime d)
        {
            OTCApplicationEventViewModel.WholeEventViewModel_.Clear();
            OTCApplicationEventViewModel._eventViewModelMap_.Clear();

            EVENT_INFO_Table_DAOManager daoManager = new EVENT_INFO_Table_DAOManager();

            //daoManager.KeyColumn_ = d.ToString("yyyyMMdd");

            daoManager.selectAll(DataBaseConnectManager.ConnectionFactory("myDB"));

            foreach (var item in daoManager.DAOList_)
            {
                EventViewModel e_vm = new EventViewModel();

                e_vm.setFromDAO(item);

                OTCApplicationEventViewModel.WholeEventViewModel_.Add(e_vm);
                //OTCApplicationEventViewModel._eventViewModelMap_.Add(
                //    e_vm.Event_date_.ToString(StringFormat.DbDateFormat_), e_vm);
            }
        }

Example #4

File: OTCApplicationEventViewModel.cs Project: minikie/OTCDerivativesCalculatorModule

        // d : position 기준일
        public static void loadWholeEvent(DateTime d)
        {
            OTCApplicationEventViewModel.WholeEventViewModel_.Clear();
            OTCApplicationEventViewModel._eventViewModelMap_.Clear();

            EVENT_INFO_Table_DAOManager daoManager = new EVENT_INFO_Table_DAOManager();

            //daoManager.KeyColumn_ = d.ToString("yyyyMMdd");

            daoManager.selectAll(DataBaseConnectManager.ConnectionFactory("myDB"));

            foreach (var item in daoManager.DAOList_)
            {
                EventViewModel e_vm = new EventViewModel();

                e_vm.setFromDAO(item);

                OTCApplicationEventViewModel.WholeEventViewModel_.Add(e_vm);
                //OTCApplicationEventViewModel._eventViewModelMap_.Add(
                //    e_vm.Event_date_.ToString(StringFormat.DbDateFormat_), e_vm);

            }
        }

Example #5

File: EventManagerViewModel.cs Project: minikie/OTCDerivativesCalculatorModule

        public static ObservableCollection<EventViewModel> dbLoad(string itemCode)
        {
            ObservableCollection<EventViewModel> eventVMList = new ObservableCollection<EventViewModel>();

            EVENT_INFO_Table_DAOManager daoManager = new EVENT_INFO_Table_DAOManager();

            daoManager.KeyColumn_ = itemCode;

            daoManager.select(DataBaseConnectManager.ConnectionFactory("myDB"));

            foreach (var item in daoManager.DAOList_)
	        {
                EventViewModel evm = new SettlementEventViewModel();

                evm.setFromDAO(item);

                eventVMList.Add(evm);
	        }

            return eventVMList;
            
            
        }

Example #6

File: EventManagerViewModel.cs Project: minikie/OTCDerivativesCalculatorModule

        public void dbLoad()
        {
            this.eventVMList_ = new ObservableCollection<EventViewModel>();

            EVENT_INFO_Table_DAOManager daoManager = new EVENT_INFO_Table_DAOManager();

            daoManager.KeyColumn_ = this.itemCode_;

            daoManager.select(DataBaseConnectManager.ConnectionFactory("myDB"));

            foreach (var item in daoManager.DAOList_)
            {
                EventViewModel evm = new SettlementEventViewModel();

                evm.setFromDAO(item);

                this.eventVMList_.Add(evm);
            }

            //((EventManagerView)this.view_).refereshDataContext();

        }