public void Set_DataSource(lsttbl_DashboardSource ds) { try { this.Reset_Info(); if (ds == null) return; if (ds.SettingCat == GlobalVar.SettingCat_DS) { var obj = ds.JsonObjMDX; var dsUnion = obj.Fields.Union(obj.Summaries.Select(p => p.Field)).Distinct(); Helpers.SetDataSource(this.cboField, dsUnion, "ColName", "ColAliasVI", this.cboField.Value); this.txtVisibleIndex.Text = (GlobalSsn.WidgetGrid_SsnModel.Columns.Count + 1).ToString(); } else if (ds.SettingCat == GlobalVar.SettingCat_KPI) { var obj = ds.JsonObjKPI; var dsX = obj.Dimensions.Select(p => new COMCodeNameObj(p.FieldName, p.DisplayName)).ToList(); var dsY = obj.Get_SummaryFields(); var dsUnion = dsX.Union(dsY); Helpers.SetDataSource(this.cboField, dsUnion, "Code", "Name", this.cboField.Value); this.txtVisibleIndex.Text = (GlobalSsn.WidgetGrid_SsnModel.Columns.Count + 1).ToString(); } } catch { } }
public void Save_DashboardSource(lsttbl_DashboardSource info) { var db = GlobalVar.DbBI; try { var objFound = db.lsttbl_DashboardSources.FirstOrDefault(p => p.Code == info.Code); if (objFound == null) db.lsttbl_DashboardSources.InsertOnSubmit(info); else objFound.UpdateOnSubmit(info); db.SubmitChanges(); } catch { } }
partial void Deletelsttbl_DashboardSource(lsttbl_DashboardSource instance);
partial void Updatelsttbl_DashboardSource(lsttbl_DashboardSource instance);
partial void Insertlsttbl_DashboardSource(lsttbl_DashboardSource instance);
protected void cbp_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e) { var cbp = sender as ASPxCallbackPanel; if (cbp == null) return; var inq = this.Get_DefineSource(); if (cbp.ID == this.cbpPreViewSQL.ID) { this.Set_PreViewMDX(inq.ToMDX(true)); } else if (cbp.ID == this.cbpSavingMsg.ID) { var actionName = string.IsNullOrEmpty(MySession.DSDefine_CurEditing) ? "Add new " : "Update "; try { // Gọi hàm save var objDs = new lsttbl_DashboardSource() { Code = Lib.IfNOE(MySession.DSDefine_CurEditing, "ds_" + DateTime.Now.ToString("yyyyMMddHHmmss")), NameVI = this.txtDisplayNameDS.Text, NameEN = this.txtDisplayNameDS.Text, JsonStr = inq.ToJsonStr(), WHCode = Lib.NTE(this.cboDataDW.Value), SettingCat = GlobalVar.SettingCat_DS }; MyBI.Me.Save_DashboardSource(objDs); MySession.DSDefine_CurEditing = objDs.Code; } catch { this.Set_SaveMsgText(string.Format("{0} failed!", actionName), true); } // Gửi trạng thái về client; this.Set_SaveMsgText(string.Format("{0} success!", actionName), false); } else if (cbp.ID == this.cbp_Header.ID) { if (!string.IsNullOrEmpty(MySession.DSDefine_CurEditing)) { var ds = MyBI.Me.Get_DashboardSource(this.WHCode, GlobalVar.SettingCat_DS).ToList(); Helpers.SetDataSource(this.cboDatasource, ds, "Code", "NameVI", MySession.DSDefine_CurEditing); } } }
protected void cbp_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e) { try { var cbp = sender as ASPxCallbackPanel; if (cbp == null) return; if (cbp.ID == this.cbpPreViewSQL.ID || cbp.ID == this.cbpSavingMsg.ID) { var objSett = this.Get_DefineInfo(); if (objSett == null) return; if (cbp.ID == this.cbpPreViewSQL.ID) { var inqObj = objSett.ReFilter_InqMDX(); this.Set_PreViewMDX(inqObj.ToMDX(true)); } else if (cbp.ID == this.cbpSavingMsg.ID) { var actionName = Lib.IsNOE(MySession.KPIDefine_CurEditing) ? "Add new " : "Update "; try { // Gọi hàm save var obj = new lsttbl_DashboardSource() { Code = Lib.IfNOE(MySession.KPIDefine_CurEditing, "kpi_" + DateTime.Now.ToString("yyyyMMddHHmmss")), ParentCode = objSett.DatasourceID, JsonStr = objSett.ToJsonStr(), NameVI = this.txtKPIDisplayName.Text, NameEN = this.txtKPIDisplayName.Text, WHCode = this.WHCode, SettingCat = GlobalVar.SettingCat_KPI }; MyBI.Me.Save_DashboardSource(obj); MySession.KPIDefine_CurEditing = obj.Code; } catch { this.Set_SaveMsgText(string.Format("{0} failed!", actionName), true); } // Gửi trạng thái về client; this.Set_SaveMsgText(string.Format("{0} success!", actionName), false); } } else if (cbp.ID == this.cbp_Header.ID) { if (!string.IsNullOrEmpty(MySession.KPIDefine_CurEditing)) { var kpis = MyBI.Me.Get_DashboardKPI_ByWH(this.WHCode).ToList(); Helpers.SetDataSource(this.cboKPI, kpis, "Code", "NameVI", MySession.KPIDefine_CurEditing); this.cboKPI.Enabled = true; this.TrDataSource.Visible = false; } } } catch { } }
protected void btnSave_Click(object sender, EventArgs e) { var ret = new InqDefineSourceMDX(SelectedFields, SelectedMetrics, SelectedFilters) { PreffixDimTable = "AR", OlapCubeName = Helpers.GetCubeName(GlobalVar.DbOLAP_ConnectionStr_Tiny) }; lsttbl_DashboardSource objDs = new lsttbl_DashboardSource() { Code = Lib.IfNOE(MySession.DSDefine_CurEditing, "ds_" + DateTime.Now.ToString("yyyyMMddHHmmss")), NameVI = txtDataSourceName.Text, NameEN = txtDataSourceName.Text, JsonStr = ret.ToJsonStr(), WHCode = Lib.NTE(cbDataWarehouse.Value), SettingCat = GlobalVar.SettingCat_DS }; MyBI.Me.Save_DashboardSource(objDs); if (objDs.Code == MySession.DSDefine_CurEditing) { cbDataSource.Text = txtDataSourceName.Text; } else { MySession.DSDefine_CurEditing = objDs.Code; // Reload Data Source m_WHCode = cbDataWarehouse.Value.ToString(); var dsItems = MyBI.Me.Get_DashboardSource(m_WHCode, GlobalVar.SettingCat_DS); Helpers.SetDataSource(cbDataSource, dsItems, "Code", "NameEN"); cbDataSource.Value = MySession.DSDefine_CurEditing; } }