public void InitializeControls() { List <MutualFund> listFunds = new List <MutualFund>(); IList <MutualFund> Funds = new List <MutualFund>(); if (isFillterSellingAgent) { foreach (PersonOrgRelation employer in this.User.Person.FindCurrentEmployments(iSabayaContext)) { //if (employer.Organization == iSabayaContext.SystemOwnerOrg) //{ Funds = ComplicatedListFunds(employer.Organization); break; //} //else //{ //Funds = FundSellingAgent.ListFunds(iSabayaContext, employer.Organization); //} } } else { Funds = ComplicatedListFunds(); } if (transactionTypeCode != "") { if (Funds.Count > 0) { foreach (MutualFund item in Funds) { if (item.GetTransactionType(InvestmentTransactionType.FindByCode(iSabayaContext, transactionTypeCode).Code, DateTime.Now) != null) { listFunds.Add(item); } } } } else { if (Funds.Count > 0) { listFunds = new List <MutualFund>(Funds); } } if (listFunds.Count > 0) { listFunds.Sort((x, y) => string.Compare(x.Code, y.Code)); Session[this.ClientID + "FundLists"] = Session[this.ClientID + "tempLists"] = listFunds; } refreshControl(); }
/*ใช้ในหน้าสรุปซื้อขาย เรียกจาก ObjectDatasource*/ public static IList <VOTransactionSelect_GridTransaction> List( imSabayaContext context, int fundId, int accountId, DateTime date, int transactionTypeId, int sellingAgentId, int orgUnitId ) { ICriteria crit = context.PersistencySession.CreateCriteria(typeof(MFTransaction)); crit.Add(Expression.Eq("Fund", (Fund)MutualFund.Find(context, fundId))) //.Add(Expression.Eq("RollbackStatus", (byte)0)) .CreateAlias("CurrentState", "currentState") .CreateAlias("CurrentState.State", "state") .Add(Expression.Eq("state.Code", "Released")); if (accountId != 0) { crit.Add(Expression.Eq("Portfolio", MFAccount.Find(context, accountId))); } if (transactionTypeId != 0) { crit.Add(Expression.Eq("Type", InvestmentTransactionType.Find(context, transactionTypeId))); } if (date != DateTime.MinValue) { DateTime minOfToday = date.Date; DateTime maxOfToday = date.Date.AddDays(1).Date.AddMilliseconds(-1); crit.Add(Expression.Between("TransactionTS", minOfToday, maxOfToday)); } if (sellingAgentId != 0) { crit.Add(Expression.Eq("SellingAgent", Organization.Find(context, sellingAgentId))); } IList <MFTransaction> list = crit.List <MFTransaction>(); IList <VOTransactionSelect_GridTransaction> vos = new List <VOTransactionSelect_GridTransaction>(); foreach (MFTransaction tran in list) { vos.Add(new VOTransactionSelect_GridTransaction(context, tran)); } return(vos); }
private DataTable TransactionTypeLists() { iSystem mySystem; DataTable ds = null; if (CommonConstants.Systems.TryGetValue(int.Parse(System.Configuration.ConfigurationManager.AppSettings["ApplicationID"]), out mySystem)) { IList <InvestmentTransactionType> transtype = InvestmentTransactionType.ListPrincipalTypes(iSabayaContext, mySystem.ApplicationID); ds = new DataTable(); ds.Columns.Add(new DataColumn("title", System.Type.GetType("System.String"))); ds.Columns.Add(new DataColumn("value", System.Type.GetType("System.Int32"))); ds.Rows.Add("ทุกประเภท"); foreach (InvestmentTransactionType item in transtype) { ds.Rows.Add(item.Title.ToString(), item.TransactionTypeID); } Session[this.ClientID + "trantypes"] = ds; } return(ds); }
public void InitialControl() { ISession session = iSabayaContext.PersistencySession; IList <ProvidentFund> listFunds = null; // if (isMasterFund) // { // // do notthing // } // else if (isNotMasterFund) // { // String sqlquery = @"select * from fund // where IsMasterFund = 0 and FundDiscriminator = 2"; // ISQLQuery query = session.CreateSQLQuery(sqlquery).AddEntity(typeof(ProvidentFund)); ; // listFunds = query.List<ProvidentFund>(); // } // else // { // //listFunds = ProvidentFund.List(iSabayaContext); // } listFunds = ProvidentFund.ListSingleFunds(iSabayaContext); List <ProvidentFund> listFundFilters = new List <ProvidentFund>(); if (!transactionTypeCode.Equals("")) { TreeListNode channel = TreeListNode.FindByCode(iSabayaContext, "WEB"); InvestmentTransactionType tranType = InvestmentTransactionType.FindByCode(iSabayaContext, TransactionTypeCode); if (listFunds != null) { foreach (ProvidentFund fund in listFunds) { //bool isHave = InstrumentTransactionType.IsHave(session, fund, channel, tranType); ICriteria crit = iSabayaContext.PersistencySession.CreateCriteria(typeof(InstrumentTransactionType)); crit.Add(Expression.Eq("Fund", fund)); bool isHave = crit.List <InstrumentTransactionType>().Count > 0; if (isHave) { listFundFilters.Add(fund); } } } } else { if (listFunds != null) { foreach (ProvidentFund fund in listFunds) { listFundFilters.Add(fund); } } } dic.Clear(); if (includeAllFundItem) { dic.Add(0, "-All Funds-"); } if (listFunds != null) { foreach (ProvidentFund fund in listFundFilters) { //dic.Add(fund.FundID, "[" + fund.Code + "]" + fund.ShortTitle.ToString()); dic.Add(fund.FundID, fund.Code); } ViewState["listFunds"] = dic; } refreshControl(); }