private void LoadReportPanel()
{
// load table
_reportProxy.LoadHeader();
FI.Common.Data.FIDataTable rptTable = new FI.Common.Data.FIDataTable();
rptTable.Columns.Add("name", typeof(string));
rptTable.Columns.Add("description", typeof(string));
rptTable.Rows.Add(new object[] { _reportProxy.Name, _reportProxy.Description });
//loading grid control
_rptGr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_rptGr.ID = "RptGrid";
_rptGr.InMemory = true;
_rptGr.DataSource = rptTable;
_rptGr.ColumnNameArray = new string[] { "name", "description" };
_rptGr.ColumnCaptionArray = new string[] { "Report Name", "Description" };
_rptGr.ColumnWidthArray = new int[] { 200, 400 };
_rptGr.EnableSort = false;
_rptGr.EnableFilter = false;
_rptGr.EnableCheckBoxes = false;
_rptGr.EnablePages = false;
ReportPanel.Controls.Add(_rptGr);
//load values into text fields
string name = ((string)rptTable.Rows[0]["name"]).Trim();
name = (name.Length > 42?name.Substring(0, 42):name);
txtName.Text = "Copy of " + name;
txtDescription.Text = ((string)rptTable.Rows[0]["description"]).Trim();
}
private void LoadGrid()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID = "ProductsGrid";
_gr.DefaultPageSize = 15;
_gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetReportPage);
//_gr.PrimaryKeyColumnArray=new string[] {"prodsern"};
_gr.ColumnNameArray = new string[] { "SALMNAME", "CCHNAME", "CHNNAME", "COMNAME", "COMCITY", "COMPCODE", "COMADDR", "DELDATE" };
_gr.ColumnCaptionArray = new string[] { "Salesman", "Centr. Chain", "Chain", "Store", "City", "Post. Code", "Address", "Last Transact." };
_gr.ColumnWidthArray = new int[] { 150, 150, 150, 150, 100, 75, 150, 75 };
_gr.EnableCheckBoxes = false;
_gr.EnablePages = true;
_gr.FilterChanged += new EventHandler(_gr_FilterChanged);
// assign report filter
foreach (string colName in _gr.ColumnNameArray)
{
string val = _report.GetFilterItem(colName);
if (val != null)
{
_gr.Filter[colName] = val;
}
else
{
_gr.Filter.Remove(colName);
}
}
this.cellContents.Controls.Add(_gr);
}
private void LoadControls()
{
// _ddlUniqueName
_ddlUniqueName = new Controls.FIDropDownControl();
_ddlUniqueName.CssClass = "tbl1_edit";
this.pnlSourceMember.Controls.Add(_ddlUniqueName);
// listFormat
foreach (string format in Enum.GetNames(typeof(FI.BusinessObjects.Olap.CalculatedMember.FormatEnum)))
{
this.listFormat.Items.Add(format);
}
// formatted members grid
_gridFormattedMembers = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gridFormattedMembers.ID = "gridFormattedMembers";
_gridFormattedMembers.EnablePages = true;
_gridFormattedMembers.DefaultPageSize = 15;
_gridFormattedMembers.EnableUpdatePager = false;
_gridFormattedMembers.InMemory = true;
_gridFormattedMembers.PrimaryKeyColumnArray = new string[] { "uniquename" };
_gridFormattedMembers.ColumnNameArray = new string[] { "hierarchy", "default_name", "name", "format" };
_gridFormattedMembers.ColumnCaptionArray = new string[] { "Hierarchy", "Default Name", "Name", "Format" };
_gridFormattedMembers.ColumnWidthArray = new int[] { 150, 200, 200, 80 };
_gridFormattedMembers.EnableMultipleSelection = true;
this.pnlFormattedMembers.Controls.Add(_gridFormattedMembers);
}
private void LoadDistributionLogPanel()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.DefaultPageSize = 20;
_gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionLogPage);
_gr.PrimaryKeyColumnArray = new string[] { "log_id" };
_gr.ColumnNameArray = new string[] { "timestamp", "status", "duration", "isfromcache", "message", "contact_name", "contact_email" };
_gr.ColumnCaptionArray = new string[] { "Timestamp", "Status", "Duration(sec)", "FromCache", "Message", "Contact Name", "Contact Email" };
_gr.ColumnWidthArray = new int[] { 150, 150, 80, 80, 150, 150, 150 };
_gr.EnableCheckBoxes = false;
_gr.EnablePages = true;
DistributionLogPanel.Controls.Add(_gr);
}
private void LoadDistributionLogPanel()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.DefaultPageSize=20;
_gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionLogPage);
_gr.PrimaryKeyColumnArray=new string[] {"log_id"};
_gr.ColumnNameArray=new string[] {"timestamp", "status" , "duration", "isfromcache", "message" , "contact_name" , "contact_email"};
_gr.ColumnCaptionArray=new string[] {"Timestamp", "Status" , "Duration(sec)", "FromCache", "Message" , "Contact Name" , "Contact Email"};
_gr.ColumnWidthArray=new int[] {150, 150 , 80, 80, 150 , 150 , 150};
_gr.EnableCheckBoxes=false;
_gr.EnablePages=true;
DistributionLogPanel.Controls.Add(_gr);
}
private void LoadProductsGrid()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID = "ProductsGrid";
_gr.DefaultPageSize = 15;
_gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetSppProductsPage);
_gr.PrimaryKeyColumnArray = new string[] { "prodsern" };
_gr.ColumnNameArray = new string[] { "prodname", "prodsname", "prodcode", "proddunc", "prodeanc", "prodprice", "prodcps", "prodcpu", "prodsize", "prodpallet" };
_gr.ColumnCaptionArray = new string[] { "Name", "Short Name", "Code", "DUN Code", "EAN Code", "Price", "Cons Pkg Size", "Units", "Case Size", "Pallet Size" };
_gr.ColumnWidthArray = new int[] { 200, 100, 100, 100, 100, 75, 75, 75, 75, 75 };
_gr.EnableMultipleSelection = true;
_gr.EnablePages = true;
this.cellContents.Controls.Add(_gr);
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID = "DLogGr";
_gr.ColumnNameArray = new string[] { "timestamp", "status", "duration", "message", "rpt_type", "rpt_name", "rpt_description", "contact_name", "contact_email" };
_gr.ColumnCaptionArray = new string[] { "Timestamp", "Status", "Duration(sec)", "Message", "Report Type", "Report Name", "Report Descr.", "Contact Name", "Contact Email" };
_gr.ColumnWidthArray = new int[] { 100, 50, 80, 200, 100, 150, 150, 150, 150 };
_gr.EnableSort = true;
_gr.EnableCheckBoxes = false;
_gr.EnablePages = true;
_gr.DefaultPageSize = 25;
_gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionLogPage);
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID = "ContactsGrid";
_gr.PrimaryKeyColumnArray = new string[] { "id" };
_gr.ColumnNameArray = new string[] { "name", "email", "distr_format" };
_gr.ColumnCaptionArray = new string[] { "Name", "EMail", "Distribution Format" };
_gr.ColumnWidthArray = new int[] { 200, 300, 200 };
_gr.EnableSort = true;
_gr.EnableMultipleSelection = true;
_gr.EnablePages = true;
_gr.DefaultPageSize = 20;
_gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(_user.ContactSystem.GetContactsPage);
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadReportPanel()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.DefaultPageSize = 20;
_gr.InMemory = true;
_gr.DataSource = _user.ReportSystem.GetReportHeaders(typeof(FI.BusinessObjects.OlapReport));
_gr.EnableMultipleSelection = false;
_gr.PrimaryKeyColumnArray = new string[] { "id" };
_gr.ColumnNameArray = new string[] { "name", "description", "owner_name", "timestamp" };
_gr.ColumnCaptionArray = new string[] { "Name", "Description", "Owner", "Timestamp" };
_gr.ColumnWidthArray = new int[] { 150, 350, 100, 85 };
_gr.EnableCheckBoxes = true;
_gr.EnablePages = true;
ReportPanel.Controls.Add(_gr);
}
private void CreateGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID = "DQueueGr";
_gr.PrimaryKeyColumnArray = new string[] { "Id", "UserId", "ReportId", "ReportTypeCode" };
_gr.ColumnNameArray =
new string[] {
"LastTimestamp", "CheckStatus", "LastStatus", "LastMessage", "IsQueued",
"ScheduleType", "ScheduleValue",
"Domain", "UserName",
"ReportType", "ReportName", "ReportDescr",
"Contact", "ContactEmail",
"OkCount", "OkLastDuration", "OkAvgDuration",
"CancelCount", "CancelAvgDuration",
"ErrorCount"
};
_gr.ColumnCaptionArray = _gr.ColumnNameArray;
_gr.ColumnWidthArray =
new int[] {
100, 100, 80, 200, 80,
80, 80,
80, 80,
80, 100, 200,
80, 80,
80, 100, 100,
80, 100,
80
};
_gr.EnableCheckBoxes = true;
_gr.EnableMultipleSelection = true;
_gr.EnablePages = true;
_gr.DefaultPageSize = 100;
_gr.EnableSort = true;
_gr.InMemory = true;
if (_gr.Sort.Count == 0)
{
//_gr.Sort.Add("CheckStatus", "DESC");
_gr.Sort.Add("LastTimestamp", "DESC");
_gr.Sort.Add("IsQueued", "DESC");
}
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID = "ContactsGrid";
_gr.PrimaryKeyColumnArray = new string[] { "Id" };
_gr.ColumnNameArray = new string[] { "Logon", "Name", "Email", "IsAdmin" };
_gr.ColumnCaptionArray = new string[] { "Logon", "Name", "Email", "IsAdmin" };
_gr.ColumnWidthArray = new int[] { 200, 200, 200, 50 };
_gr.EnableSort = true;
_gr.EnableMultipleSelection = true;
_gr.EnablePages = true;
_gr.DefaultPageSize = 20;
_gr.InMemory = true;
_gr.DataSource = _user.GetSystemUsers();
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID = "DQueueGr";
_gr.PrimaryKeyColumnArray = new string[] { "log_id", "distribution_id" };
_gr.ColumnNameArray = new string[] { "distribution_id", "company_name", "user_name", "timestamp", "status", "duration", "message", "rpt_type", "rpt_name", "rpt_description", "contact_name", "contact_email" };
_gr.ColumnCaptionArray = new string[] { "Id", "Domain", "User", "Timestamp", "Status", "Duration(sec)", "Message", "Report Type", "Report Name", "Report Descr.", "Contact Name", "Contact Email" };
_gr.ColumnWidthArray = new int[] { 30, 100, 100, 100, 50, 80, 200, 100, 150, 150, 150, 150 };
_gr.EnableCheckBoxes = true;
_gr.EnableMultipleSelection = true;
_gr.EnablePages = true;
_gr.DefaultPageSize = 25;
_gr.EnableSort = true;
_gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetMasterDistributionQueuePage);
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadSharingPanel()
{
SharingPanel.Controls.Clear();
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID = "SharingGrid";
_gr.DefaultPageSize = 15;
_gr.InMemory = true;
_gr.DataSource = GetUsersWithChildReports();
_gr.PrimaryKeyColumnArray = new string[] { "user_id", "report_id" };
_gr.ColumnNameArray = new string[] { "name", "sharing_string" };
_gr.ColumnCaptionArray = new string[] { "User Name", "Sharing" };
_gr.ColumnWidthArray = new int[] { 200, 150 };
_gr.EnableMultipleSelection = true;
_gr.EnablePages = true;
SharingPanel.Controls.Add(_gr);
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID="ProcInfoGr";
_gr.PrimaryKeyColumnArray=new string[] {"TcpPort"};
_gr.ColumnNameArray=new string[] {"Server", "Database", "State", "AllocatedSpan" , "TaskId", "TaskTag"};
_gr.ColumnCaptionArray=new string[] {"Server", "Database", "State", "AllocatedSpan" , "TaskId", "TaskTag"};
_gr.ColumnWidthArray=new int[] {100, 100, 100, 100 , 150 , 250};
_gr.EnableCheckBoxes=false;
_gr.EnableMultipleSelection=false;
_gr.EnablePages=false;
//_gr.DefaultPageSize=50;
_gr.EnableSort=true;
_gr.EnableFilter=false;
_gr.InMemory=true;
_gr.DataSource=FI.BusinessObjects.BusinessFacade.Instance.GetOlapProcessorInfo();
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID = "ProcInfoGr";
_gr.PrimaryKeyColumnArray = new string[] { "TcpPort" };
_gr.ColumnNameArray = new string[] { "Server", "Database", "State", "AllocatedSpan", "TaskId", "TaskDescription" };
_gr.ColumnCaptionArray = new string[] { "Server", "Database", "State", "AllocatedSpan", "TaskId", "TaskDescription" };
_gr.ColumnWidthArray = new int[] { 100, 100, 100, 100, 150, 250 };
_gr.EnableCheckBoxes = false;
_gr.EnableMultipleSelection = false;
_gr.EnablePages = false;
//_gr.DefaultPageSize=50;
_gr.EnableSort = true;
_gr.EnableFilter = false;
_gr.InMemory = true;
_gr.DataSource = FI.BusinessObjects.BusinessFacade.Instance.GetOlapProcessorInfo();
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadDistributionPanel()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID = "DistrGrid";
_gr.DefaultPageSize = 15;
_gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionsWithContactsPage);
_gr.PrimaryKeyColumnArray = new string[] { "contact_id", "distribution_id" };
_gr.ColumnNameArray = new string[] { "name", "email", "format", "distr_format", "freq_type", "freq_value" };
_gr.ColumnCaptionArray = new string[] { "Contact Name", "Contact EMail", "Format", "EMail View", "Frequency Type", "Frequency Value" };
_gr.ColumnWidthArray = new int[] { 150, 200, 75, 125, 100, 250 };
_gr.EnableMultipleSelection = true;
DistributionPanel.Controls.Add(_gr);
// load export types
this.ddlFormat.Items.Clear();
string[] names = Enum.GetNames(typeof(Report.ExportFormat));
foreach (string name in names)
{
this.ddlFormat.Items.Add(name);
}
}
private void LoadReportPanel()
{
// load table
_reportProxy.LoadHeader();
FI.Common.Data.FIDataTable rptTable = new FI.Common.Data.FIDataTable();
rptTable.Columns.Add("name", typeof(string));
rptTable.Columns.Add("description", typeof(string));
rptTable.Rows.Add(new object[] { _reportProxy.Name, _reportProxy.Description });
//loading grid control
_rptGr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_rptGr.InMemory = true;
_rptGr.DataSource = rptTable;
_rptGr.ColumnNameArray = new string[] { "name", "description" };
_rptGr.ColumnCaptionArray = new string[] { "Report Name", "Description" };
_rptGr.ColumnWidthArray = new int[] { 200, 400 };
_rptGr.EnableSort = false;
_rptGr.EnableFilter = false;
_rptGr.EnableCheckBoxes = false;
_rptGr.EnablePages = false;
ReportPanel.Controls.Add(_rptGr);
}
private void LoadReportPanel()
{
// load table
_reportProxy.LoadHeader();
FI.Common.Data.FIDataTable rptTable=new FI.Common.Data.FIDataTable();
rptTable.Columns.Add("name" , typeof(string));
rptTable.Columns.Add("description" , typeof(string));
rptTable.Rows.Add(new object[] {_reportProxy.Name , _reportProxy.Description});
//loading grid control
_rptGr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_rptGr.ID="RptGrid";
_rptGr.InMemory=true;
_rptGr.DataSource=rptTable;
_rptGr.ColumnNameArray=new string[] {"name" , "description" };
_rptGr.ColumnCaptionArray=new string[] {"Report Name" , "Description"};
_rptGr.ColumnWidthArray=new int[] {200 , 400};
_rptGr.EnableSort=false;
_rptGr.EnableFilter=false;
_rptGr.EnableCheckBoxes=false;
_rptGr.EnablePages=false;
ReportPanel.Controls.Add(_rptGr);
}
private void LoadDistributionPanel()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID="DistrGrid";
_gr.DefaultPageSize=15;
_gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionsWithContactsPage);
_gr.PrimaryKeyColumnArray=new string[] {"contact_id" , "distribution_id"};
_gr.ColumnNameArray=new string[] {"name" , "email" , "format", "distr_format" , "freq_type" , "freq_value"};
_gr.ColumnCaptionArray=new string[] {"Contact Name" , "Contact EMail" , "Format", "EMail View" , "Frequency Type" , "Frequency Value" };
_gr.ColumnWidthArray=new int[] {150 , 200 , 75, 125 , 100 , 250};
_gr.EnableMultipleSelection=true;
DistributionPanel.Controls.Add(_gr);
// load export types
this.ddlFormat.Items.Clear();
string[] names=Enum.GetNames(typeof(Report.ExportFormat));
foreach(string name in names)
this.ddlFormat.Items.Add(name);
}
private void LoadReportPanel()
{
// load table
_report.LoadHeader();
FI.Common.Data.FIDataTable rptTable=new FI.Common.Data.FIDataTable();
rptTable.Columns.Add("name" , typeof(string));
rptTable.Columns.Add("description" , typeof(string));
rptTable.Rows.Add(new object[] {_report.Name , _report.Description});
//loading grid control
_rptGr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_rptGr.ID="RptGrid";
_rptGr.InMemory=true;
_rptGr.DataSource=rptTable;
_rptGr.ColumnNameArray=new string[] {"name" , "description" };
_rptGr.ColumnCaptionArray=new string[] {"Report Name" , "Description"};
_rptGr.ColumnWidthArray=new int[] {200 , 400};
_rptGr.EnableSort=false;
_rptGr.EnableFilter=false;
_rptGr.EnableCheckBoxes=false;
_rptGr.EnablePages=false;
ReportPanel.Controls.Add(_rptGr);
// if shared report , saving is disabled
if(_report.SharingStatus==Report.SharingEnum.InheriteSubscriber || _report.SharingStatus==Report.SharingEnum.SnapshotSubscriber)
this.radioSave.Enabled=false;
//load values into text fields
string name=((string)rptTable.Rows[0]["name"]).Trim();
name=(name.Length>42?name.Substring(0,42):name);
txtName.Text="Copy of " + name;
txtDescription.Text=((string)rptTable.Rows[0]["description"]).Trim();
}
private void CreateGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID="DQueueGr";
_gr.PrimaryKeyColumnArray=new string[] {"Id", "UserId", "ReportId", "ReportTypeCode"};
_gr.ColumnNameArray=
new string[] {
"LastTimestamp", "CheckStatus", "LastStatus", "LastMessage", "IsQueued",
"ScheduleType", "ScheduleValue",
"Domain", "UserName",
"ReportType", "ReportName" , "ReportDescr",
"Contact" , "ContactEmail" ,
"OkCount", "OkLastDuration", "OkAvgDuration",
"CancelCount", "CancelAvgDuration",
"ErrorCount"
};
_gr.ColumnCaptionArray=_gr.ColumnNameArray;
_gr.ColumnWidthArray=
new int[] {
100, 100, 80 , 200, 80 ,
80, 80,
80 , 80 ,
80, 100 , 200 ,
80, 80 ,
80, 100 , 100,
80, 100 ,
80
};
_gr.EnableCheckBoxes=true;
_gr.EnableMultipleSelection=true;
_gr.EnablePages=true;
_gr.DefaultPageSize=100;
_gr.EnableSort=true;
_gr.InMemory=true;
if(_gr.Sort.Count==0)
{
//_gr.Sort.Add("CheckStatus", "DESC");
_gr.Sort.Add("LastTimestamp", "DESC");
_gr.Sort.Add("IsQueued", "DESC");
}
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadControls()
{
// _ddlUniqueName
_ddlUniqueName=new Controls.FIDropDownControl();
_ddlUniqueName.CssClass="tbl1_edit";
this.pnlSourceMember.Controls.Add(_ddlUniqueName);
// listFormat
foreach(string format in Enum.GetNames(typeof(FI.BusinessObjects.Olap.CalculatedMember.FormatEnum)))
this.listFormat.Items.Add(format);
// formatted members grid
_gridFormattedMembers = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gridFormattedMembers.ID="gridFormattedMembers";
_gridFormattedMembers.EnablePages=true;
_gridFormattedMembers.DefaultPageSize=15;
_gridFormattedMembers.EnableUpdatePager=false;
_gridFormattedMembers.InMemory=true;
_gridFormattedMembers.PrimaryKeyColumnArray=new string[] {"uniquename"};
_gridFormattedMembers.ColumnNameArray=new string[] {"hierarchy", "default_name", "name", "format"};
_gridFormattedMembers.ColumnCaptionArray=new string[] {"Hierarchy" , "Default Name", "Name", "Format" };
_gridFormattedMembers.ColumnWidthArray=new int[] {150 , 200, 200, 80};
_gridFormattedMembers.EnableMultipleSelection=true;
this.pnlFormattedMembers.Controls.Add(_gridFormattedMembers);
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID="ContactsGrid";
_gr.PrimaryKeyColumnArray=new string[] {"id"};
_gr.ColumnNameArray=new string[] {"name" , "email" , "distr_format"};
_gr.ColumnCaptionArray=new string[] {"Name" , "EMail" , "Distribution Format" };
_gr.ColumnWidthArray=new int[] {200 , 300 , 200};
_gr.EnableSort=true;
_gr.EnableMultipleSelection=true;
_gr.EnablePages=true;
_gr.DefaultPageSize=20;
_gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(_user.ContactSystem.GetContactsPage);
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadReportPanel()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.DefaultPageSize=20;
_gr.InMemory=true;
_gr.DataSource=_user.ReportSystem.GetReportHeaders(typeof(FI.BusinessObjects.OlapReport));
_gr.EnableMultipleSelection=false;
_gr.PrimaryKeyColumnArray=new string[] {"id"};
_gr.ColumnNameArray=new string[] {"name" , "description" , "owner_name" , "timestamp"};
_gr.ColumnCaptionArray=new string[] {"Name" , "Description" , "Owner", "Timestamp" };
_gr.ColumnWidthArray=new int[] {150 , 350 , 100, 85};
_gr.EnableCheckBoxes=true;
_gr.EnablePages=true;
ReportPanel.Controls.Add(_gr);
}
private void LoadGrid()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID="ProductsGrid";
_gr.DefaultPageSize=15;
_gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetReportPage);
//_gr.PrimaryKeyColumnArray=new string[] {"prodsern"};
_gr.ColumnNameArray=new string[] {"SALMNAME", "CCHNAME" , "CHNNAME" , "COMNAME" , "COMCITY" , "COMPCODE" , "COMADDR" , "DELDATE"};
_gr.ColumnCaptionArray=new string[] {"Salesman" , "Centr. Chain" , "Chain" , "Store" , "City", "Post. Code" , "Address" , "Last Transact."};
_gr.ColumnWidthArray=new int[] {150 , 150 , 150 , 150 , 100 , 75 , 150 , 75 };
_gr.EnableCheckBoxes=false;
_gr.EnablePages=true;
_gr.FilterChanged+=new EventHandler(_gr_FilterChanged);
// assign report filter
foreach(string colName in _gr.ColumnNameArray)
{
string val=_report.GetFilterItem(colName);
if(val!=null)
_gr.Filter[colName]=val;
else
_gr.Filter.Remove(colName);
}
this.cellContents.Controls.Add(_gr);
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID="DQueueGr";
_gr.PrimaryKeyColumnArray=new string[] {"log_id", "distribution_id"};
_gr.ColumnNameArray=new string[] {"distribution_id", "timestamp" , "status" , "duration", "message" , "rpt_type" , "rpt_name" , "rpt_description", "contact_name" , "contact_email"};
_gr.ColumnCaptionArray=new string[] {"Id", "Timestamp" , "Status", "Duration(sec)", "Message" , "Report Type", "Report Name" , "Report Descr.", "Contact Name" , "Contact Email"};
_gr.ColumnWidthArray=new int[] {30, 100 , 50 , 80, 200 , 100 , 150 , 150 , 150 , 150 };
_gr.EnableSort=true;
_gr.EnableCheckBoxes=true;
_gr.EnableMultipleSelection=true;
_gr.EnablePages=true;
_gr.DefaultPageSize=25;
_gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionQueuePage);
ControlPanel.Controls.Add(_gr);
//end loading grid control
}
private void LoadProductsGrid()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
_gr.ID="ProductsGrid";
_gr.DefaultPageSize=15;
_gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetSppProductsPage);
_gr.PrimaryKeyColumnArray=new string[] {"prodsern"};
_gr.ColumnNameArray=new string[] {"prodname" , "prodsname" , "prodcode" , "proddunc", "prodeanc" , "prodprice", "prodcps", "prodcpu" , "prodsize" , "prodpallet"};
_gr.ColumnCaptionArray=new string[] {"Name" , "Short Name" , "Code" , "DUN Code" , "EAN Code", "Price" , "Cons Pkg Size" , "Units", "Case Size" , "Pallet Size"};
_gr.ColumnWidthArray=new int[] {200 , 100 , 100 , 100 , 100 , 75 , 75 , 75 , 75 , 75};
_gr.EnableMultipleSelection=true;
_gr.EnablePages=true;
this.cellContents.Controls.Add(_gr);
}
private void LoadSharingPanel()
{
SharingPanel.Controls.Clear();
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID="SharingGrid";
_gr.DefaultPageSize=15;
_gr.InMemory=true;
_gr.DataSource=GetUsersWithChildReports();
_gr.PrimaryKeyColumnArray=new string[] {"user_id" , "report_id"};
_gr.ColumnNameArray=new string[] {"name" , "sharing_string"};
_gr.ColumnCaptionArray=new string[] {"User Name" , "Sharing" };
_gr.ColumnWidthArray=new int[] {200 , 150};
_gr.EnableMultipleSelection=true;
_gr.EnablePages=true;
SharingPanel.Controls.Add(_gr);
}
private void LoadGridControl()
{
//loading grid control
_gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
_gr.ID="ContactsGrid";
_gr.PrimaryKeyColumnArray=new string[] {"Id"};
_gr.ColumnNameArray=new string[] {"Logon" , "Name" , "Email" , "IsAdmin"};
_gr.ColumnCaptionArray=new string[] {"Logon" , "Name" , "Email" , "IsAdmin" };
_gr.ColumnWidthArray=new int[] {200 , 200 , 200, 50};
_gr.EnableSort=true;
_gr.EnableMultipleSelection=true;
_gr.EnablePages=true;
_gr.DefaultPageSize=20;
_gr.InMemory=true;
_gr.DataSource=_user.GetSystemUsers();
ControlPanel.Controls.Add(_gr);
//end loading grid control
}