protected void comboBankCallback() { ProvidentFund fund = this.Fund; if (fund != null) { IList <PartyBankAccount> fbanks = fund.AssociatedBankAccounts; comboBank.ValueField = "ID"; comboBank.TextField = "AccountName"; Session[this.ClientID + "fbanks"] = fbanks; comboBank.DataSource = fbanks; comboBank.DataBind(); } else { ProvidentFund empFund = (ProvidentFund)Session["SessionFund"]; if (empFund != null) { IList <PartyBankAccount> fbanks = empFund.AssociatedBankAccounts; comboBank.ValueField = "ID"; comboBank.TextField = "AccountName"; Session[this.ClientID + "fbanks"] = fbanks; comboBank.DataSource = fbanks; comboBank.DataBind(); } } }
public ActionResult Edit(int id, FormCollection collection) { try { // TODO: Add update logic here var model = ProvidentFund.GetById(id); TryUpdateModel(model); model.SaveOrUpDate(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(FormCollection collection) { try { // TODO: Add insert logic here var model = new ProvidentFund(); TryUpdateModel(model); model.Insert(); return(RedirectToAction("Index")); } catch { return(View()); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ASPxGridView grid = (ASPxGridView)DropDownEdit.FindControl("GridView"); grid.DataBind(); if (Session["SessionFund"] != null) { ProvidentFund fund = ((ProvidentFund)Session["SessionFund"]); DropDownEdit.KeyValue = fund.FundID; DropDownEdit.Text = fund.Code; } else { DropDownEdit.KeyValue = null; DropDownEdit.Text = string.Empty; } } }
public void InitialControl(string currentLanguage) { IList <ProvidentFund> listFunds = null; if (!IsFillterSellingAgent) { listFunds = ProvidentFund.List(iSabayaContext); } else { User user = (User)this.User; } //dic.Clear(); foreach (ProvidentFund fund in listFunds) { ComboFundName.Items.Add(fund.Code, fund.FundID.ToString()); } }
protected String employerNameCallback() { Employer emp = this.Employer; ProvidentFund pFund = this.Fund; String Result; if (emp != null) { Result = emp.Name.ToString(iSabayaContext.CurrentLanguage) + " รหัส: " + emp.EmployerNo.ToString(); } else if (pFund != null) { Result = pFund.Title.ToString(iSabayaContext.CurrentLanguage); } else { Result = "ไม่พบชื่อ!"; } return(Result); }
public void InitializeControls() { ISession session = iSabayaContext.PersistencySession; IList <ProvidentFund> listFunds = null; string type = ""; type = isMasterFund ? "isMasterFund" : ""; type = isNotMasterFund ? "isNotMasterFund" : ""; type = isNotSubFund ? "isNotSubFund" : ""; type = masterFundID != 0 ? "isMasterFundID" : ""; type = IsAvalibleForEmployer ? "IsAvalibleForEmployer" : ""; type = IsAvalibleAndNotMasterFund ? "IsAvalibleAndNotMasterFund" : ""; #region String sqlquery = ""; ISQLQuery query = null; switch (type) { case "isMasterFund": sqlquery = @"select * from fund where IsMasterFund = 1 and FundDiscriminator = 2"; query = session.CreateSQLQuery(sqlquery).AddEntity(typeof(ProvidentFund)); listFunds = query.List <ProvidentFund>(); break; case "isNotMasterFund": sqlquery = @"select * from fund where IsMasterFund = 0 and FundDiscriminator = 2"; query = session.CreateSQLQuery(sqlquery).AddEntity(typeof(ProvidentFund));; listFunds = query.List <ProvidentFund>(); break; case "isNotSubFund": sqlquery = @"select * from Fund f where f.IsMasterFund = 0 and f.FundDiscriminator = 2 Except select f.* from Fund f inner join FundRelation fr on f.FundID = fr.ChildFundID where f.IsMasterFund = 0 and f.FundDiscriminator = 2 union select * from Fund f where f.IsMasterFund = 1 and f.FundDiscriminator = 2"; query = session.CreateSQLQuery(sqlquery).AddEntity(typeof(ProvidentFund));; listFunds = query.List <ProvidentFund>(); break; case "IsAvalibleForEmployer": sqlquery = @"SELECT * FROM Fund f -- fund is not subfund WHERE f.IsMasterFund = 0 AND f.FundDiscriminator = 2 Except SELECT f.* FROM Fund f INNER JOIN FundRelation fr on f.FundID = fr.ChildFundID WHERE f.IsMasterFund = 0 AND f.FundDiscriminator = 2 UNION SELECT * FROM Fund f WHERE f.IsMasterFund = 1 AND f.FundDiscriminator = 2 EXCEPT -- fund is used by Employer (SELECT f.* FROM Employer e INNER JOIN EmployerFund ef ON e.EmployerID = ef.EmployerID INNER JOIN Fund f ON f.FundID = ef.FundID INNER JOIN TreeListNode trn ON trn.NodeID = f.FundCategoryID WHERE (trn.NodeID = 1584 OR trn.NodeID = 1443) AND f.FundDiscriminator = 2 )"; query = session.CreateSQLQuery(sqlquery).AddEntity(typeof(ProvidentFund));; listFunds = query.List <ProvidentFund>(); break; case "IsAvalibleAndNotMasterFund": sqlquery = @"SELECT * FROM Fund f -- fund is not Sub fund and not Master Fund WHERE f.IsMasterFund = 0 AND f.FundDiscriminator = 2 Except SELECT f.* FROM Fund f INNER JOIN FundRelation fr on f.FundID = fr.ChildFundID WHERE f.IsMasterFund = 0 AND f.FundDiscriminator = 2 EXCEPT -- fund is used by Employer (SELECT f.* FROM Employer e INNER JOIN EmployerFund ef ON e.EmployerID = ef.EmployerID INNER JOIN Fund f ON f.FundID = ef.FundID INNER JOIN TreeListNode trn ON trn.NodeID = f.FundCategoryID WHERE f.FundDiscriminator = 2 )"; query = session.CreateSQLQuery(sqlquery).AddEntity(typeof(ProvidentFund));; listFunds = query.List <ProvidentFund>(); break; case "isMasterFundID": ProvidentFund MasterFund = iSabayaContext.PersistencySession.Get <ProvidentFund>(masterFundID); listFunds = new List <ProvidentFund>(); foreach (FundRelation item in MasterFund.ChildrenFundRelations) { listFunds.Add((ProvidentFund)item.ChildFund); } break; default: listFunds = ProvidentFund.List(iSabayaContext); break; } #endregion #region // if (isMasterFund) // { // String sqlquery = @"select * from fund // where IsMasterFund = 1 and FundDiscriminator = 2"; // ISQLQuery query = session.CreateSQLQuery(sqlquery).AddEntity(typeof(ProvidentFund)); ; // listFunds = query.List<ProvidentFund>(); // } // 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 if (isNotSubFund) // { // String sqlquery = @"select * from Fund f // where f.IsMasterFund = 0 and f.FundDiscriminator = 2 // Except // select f.* from Fund f // inner join FundRelation fr on f.FundID = fr.ChildFundID // where f.IsMasterFund = 0 and f.FundDiscriminator = 2 // union // select * from Fund f // where f.IsMasterFund = 1 and f.FundDiscriminator = 2"; // ISQLQuery query = session.CreateSQLQuery(sqlquery).AddEntity(typeof(ProvidentFund)); ; // listFunds = query.List<ProvidentFund>(); // } // else if (masterFundID != 0) // { // ProvidentFund MasterFund = iSabayaContext.PersistencySession.Get<ProvidentFund>(masterFundID); // listFunds = new List<ProvidentFund>(); // foreach (FundRelation item in MasterFund.ChildrenFundRelations) // { // listFunds.Add((ProvidentFund)item.ChildFund); // } // } // else // { // listFunds = ProvidentFund.List(iSabayaContext); // } #endregion #region //List<ProvidentFund> listFundFilters = new List<ProvidentFund>(); //if (!transactionTypeCode.Equals("")) //{ // TreeListNode channel = TreeListNode.FindByCode(iSabayaContext, "WEB"); // TransactionType tranType = TransactionType.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); // } // } //} #endregion dic.Clear(); if (includeAllFundItem) { dic.Add(0, "-All Funds-"); } if (listFunds != null) { foreach (ProvidentFund fund in listFunds) { dic.Add(fund.FundID, fund.Code); } ViewState["listFunds"] = dic; } refreshControl(); //cboFundCode.SelectedIndex = 0; cboFundCode.ClientInstanceName = cboFundCode.ClientID; lblFundName.ClientInstanceName = lblFundName.ClientID; cbLoadFund.ClientInstanceName = cbLoadFund.ClientID; /*Combo change*/ cboFundCode.ClientSideEvents.SelectedIndexChanged = @"function(s, e) { if(" + isShowFundName.ToString().ToLower() + @")" + cbLoadFund.ClientInstanceName + @".SendCallback('');" + AdditionClientScriptEvents.AfterSelectedChanged + @" }"; /*Callback complete*/ cbLoadFund.ClientSideEvents.CallbackComplete = @"function(s, e) {" + lblFundName.ClientInstanceName + @".SetValue(e.result); if(typeof(" + GridOutput + @") != 'undefined') setTimeout('" + GridOutput + @".PerformCallback()', 5000); if(typeof(oncompleteLoadMFFund) != 'undefined') oncompleteLoadMFFund(); }"; }
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(); }
public void ChangeEmployerTradeDate(int EmployerID) { if (EmployerID == 0) { return; } Employer employer = Employer.Find(this.iSabayaContext, EmployerID); if (employer != null) { Session["SessionEmployer"] = employer; IList <ProvidentFund> IsNotMasterFundLists = new List <ProvidentFund>(); foreach (ProvidentFund item in employer.GetFundsOn(DateTime.Today)) { if (item.IsMasterFund != true) { IsNotMasterFundLists.Add(item); } } ProvidentFund EmpMasterFund = employer.GetMainFundOn(DateTime.Today); IList <InstrumentTransactionType> fundTransactionCalendars = new List <InstrumentTransactionType>(); if (EmpMasterFund != null) { fundTransactionCalendars = EmpMasterFund.InstrumentTransactionTypes; } if (fundTransactionCalendars.Count <= 0) { foreach (ProvidentFund item in IsNotMasterFundLists) { if (item.InstrumentTransactionTypes.Count > 0) { fundTransactionCalendars = item.InstrumentTransactionTypes; } } } DateTime tradeDate = TimeInterval.MinDate; DateTime effectiveDate; DateTime settlementDate; //TimeSchedule schedule = fundTransactionCalendars[0].TradeCalendar; for (int i = 0; i < fundTransactionCalendars.Count; i++) { if (fundTransactionCalendars[i].InvestmentTransactionType.Code == PFConstants.PFTTCodeContFileImport) { Session["SessionScheduleId"] = fundTransactionCalendars[i].TradeCalendar; fundTransactionCalendars[i].FindTransactionDates(iSabayaContext, DateTime.Now, out tradeDate, out effectiveDate, out settlementDate); break; } } if (tradeDate == TimeInterval.MinDate) { Session["SessionTradeDate"] = null; Session["SessionScheduleId"] = null; } else { Session["SessionTradeDate"] = tradeDate; } } else { Session["SessionEmployer"] = null; Session["SessionScheduleId"] = null; Session["SessionTradeDate"] = null; } }
// GET: ProvidentFund/Edit/5 public ActionResult Edit(int id) { return(View(ProvidentFund.GetById(id))); }
// GET: ProvidentFund public ActionResult Index() { return(View(ProvidentFund.GetAll())); }
protected void Page_Load(object sender, EventArgs e) { cboEmployer.SetValidation(ValidateGroup); if (!hideBank) { comboBank.SetValidation(ValidateGroup); } if (!hideBank) { cboFundCode.SetValidation(ValidateGroup); } tableContent.SetCssHtmlTable_V(comboBank.CssPostfix); comboBank.ClientInstanceName = this.ClientID + comboBank.ClientID; cboFundCode.ClientInstanceName = this.ClientID + cboFundCode.ClientID; cboEmployer.ClientInstanceName = this.ClientID + cboEmployer.ClientID; cbFundAndBankName.ClientInstanceName = this.ClientID + cbFundAndBankName.ClientID; cbEmployerName.ClientInstanceName = this.ClientID + cboEmployer.ClientID; cboFundCode.ClientSideEvents.SelectedIndexChanged = @"function(s,e) { " + cbEmployerName.ClientInstanceName + @".PerformCallback(); " + comboBank.ClientInstanceName + @".PerformCallback(); }"; comboBank.ClientSideEvents.SelectedIndexChanged = @"function(s,e) { " + cbFundAndBankName.ClientInstanceName + @".PerformCallback(); }"; comboBank.ClientSideEvents.EndCallback = @"function(s,e) { " + cbFundAndBankName.ClientInstanceName + @".PerformCallback(); }"; cboEmployer.ClientSideEvents.SelectedIndexChanged = @"function(s,e) { " + cbEmployerName.ClientInstanceName + @".PerformCallback(); if(typeof(" + comboBank.ClientInstanceName + @") != 'undefined') " + comboBank.ClientInstanceName + @".PerformCallback(); if(typeof(employeeControl_cbChangeEmployer) != 'undefined'){ employeeControl_cbChangeEmployer.SendCallback(s.GetValue()); } }"; cbFundAndBankName.ClientSideEvents.CallbackComplete = @"function(s,e ){ var obj = eval('('+e.result+')'); " + lblFundName.ClientInstanceName + @".SetValue(obj.fundname); " + lblBankName.ClientInstanceName + @".SetValue(obj.bank); }"; cbEmployerName.ClientSideEvents.CallbackComplete = @"function(s,e ){ " + lblEmployerName.ClientInstanceName + @".SetValue(e.result); }" ; if (IsRequestPage) { trFund.Visible = !hideFund; trBank.Visible = !hideBank; //trFundAndBankLabel.Visible = trBank.Visible; if (hideFund) { lblFund.Visible = false; cboFundCode.Visible = false; cboEmployer.Visible = true; } else { IList <ProvidentFund> funds = ProvidentFund.List(iSabayaContext); Session[this.ClientID + "funds"] = funds; cboFundCode.ValueField = "FundID"; cboFundCode.TextField = "Code"; cboFundCode.DataSource = funds; cboFundCode.DataBind(); } if (hideBank) { lblBank.Visible = false; comboBank.Visible = false; lblFundName.Visible = false; lblBankName.Visible = false; } } else { if (Session[this.ClientID + "fbanks"] != null) { IList <PartyBankAccount> fbanks = (IList <PartyBankAccount>)Session[this.ClientID + "fbanks"]; comboBank.DataSource = fbanks; comboBank.ValueField = "ID"; comboBank.TextField = "AccountName"; comboBank.DataBind(); } } if (!Page.IsCallback) { comboBankCallback(); employerNameCallback(); fundAndBankNameCallBack(); } }
public void Refresh() { //Postback Form //ISession session = Config.Session; ISession session = iSabayaContext.PersistencySession; Employer emp = (Employer)Session["SessionEmployer"]; if (emp != null) { ISQLQuery query = session.CreateSQLQuery( @" SELECT Fund.* from dbo.EmployerFund INNER JOIN dbo.Employer ON dbo.EmployerFund.EmployerID = dbo.Employer.EmployerID inner join Fund on EmployerFund.FundID=Fund.FundID where Employer.EmployerID=" + emp.EmployerID).AddEntity(typeof(ProvidentFund)); //Employer.EffectiveFrom >=GETDATE() and Employer.EffectiveTo<=GETDATE() IList <ProvidentFund> funds = query.List <ProvidentFund>(); Session[this.ClientID + "funds"] = funds; cboFundCode.ValueField = "FundID"; cboFundCode.TextField = "Code"; cboFundCode.DataSource = funds; cboFundCode.DataBind(); } else { //if (Session["SessionFundCheck"] != null) //{ // int a = (int)Session["SessionFundCheck"]; // if (a != null) // { // if (a == 1) // { // IList<MutualFund> funds = MutualFund.List(iSabayaContext); // Session[this.ClientID + "funds"] = funds; // cboFundCode.ValueField = "FundID"; // cboFundCode.TextField = "Code"; // cboFundCode.DataSource = funds; // cboFundCode.DataBind(); // } // else // { // IList<ProvidentFund> funds = ProvidentFund.List(iSabayaContext); // Session[this.ClientID + "funds"] = funds; // cboFundCode.ValueField = "FundID"; // cboFundCode.TextField = "Code"; // cboFundCode.DataSource = funds; // cboFundCode.DataBind(); // } // } //} ProvidentFund fund = (ProvidentFund)Session["SessionFund"]; if (fund != null) { ISQLQuery query = session.CreateSQLQuery( @" select em.* from EmployerFund emF inner join Employer em on emF.EmployerID= em.EmployerID where emF.FundID=" + fund.FundID + @" AND (emF.EffectiveFrom <= GETDATE()) AND (emF.EffectiveTo >= GETDATE())" ).AddEntity(typeof(Employer)); IList <Employer> employers = query.List <Employer>(); Session[this.ClientID + "funds"] = fund; cboEmployer.ValueField = "EmployerID"; cboEmployer.TextField = "EmployerNo"; cboEmployer.DataSource = employers; cboEmployer.DataBind(); if (IsPostBack && !Page.IsCallback) { cboEmployer.SelectedIndex = -1; } } } }