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;
}
}
