//public DataviewTabProperties(SharedUtils sharedUtils, DataviewProperties dataviewProperties, FormsData[] formsList) public DataviewTabProperties(WebServices webServices, DataviewProperties dataviewProperties) { InitializeComponent(); // Create a SharedUtils object... SharedUtils sharedUtils = new SharedUtils(webServices.Url, webServices.Username, webServices.Password_ClearText, true); // Get the list of dataviews... DataSet _dataviewData = sharedUtils.GetWebServiceData("get_dataview_list", "", 0, 0); // Populate the combobox with the list of available dataviews... if (_dataviewData.Tables.Contains("get_dataview_list")) { _dataviewList = _dataviewData.Tables["get_dataview_list"].Copy(); _dataviewList.Columns.Add("display_member", typeof(string)); _dataviewList.Columns.Add("category_name", typeof(string)); _dataviewList.Columns.Add("database_area", typeof(string)); foreach (DataRow dr in _dataviewList.Rows) { string friendlyName = ""; if (dr.Table.Columns.Contains("title")) friendlyName += dr["title"].ToString().Trim(); dr["display_member"] = friendlyName; if (!string.IsNullOrEmpty(dr["category_code"].ToString())) { dr["category_name"] = sharedUtils.GetLookupDisplayMember("code_value_lookup", dr["category_code"].ToString(), dr.Table.Columns["category_code"].ExtendedProperties["group_name"].ToString(), dr["category_code"].ToString()); } else { dr["category_name"] = ""; } if (!string.IsNullOrEmpty(dr["database_area_code"].ToString())) { dr["database_area"] = sharedUtils.GetLookupDisplayMember("code_value_lookup", dr["database_area_code"].ToString(), dr.Table.Columns["database_area_code"].ExtendedProperties["group_name"].ToString(), dr["database_area_code"].ToString()); } else { dr["database_area"] = ""; } } // Build the distinct list of categories and bind it to the combobox... _category = _dataviewList.DefaultView.ToTable(true, new string[] { "category_name" }); _category.DefaultView.Sort = "category_name asc"; ux_comboboxDataviewCategory.DisplayMember = "category_name"; ux_comboboxDataviewCategory.ValueMember = "category_name"; ux_comboboxDataviewCategory.DataSource = _category; // Bind the list to the dropdown combobox... if (_dataviewList.Columns.Contains("display_member")) _dataviewList.DefaultView.Sort = "display_member asc"; ux_comboboxDataviews.DisplayMember = "display_member"; ux_comboboxDataviews.ValueMember = "dataview_name"; ux_comboboxDataviews.DataSource = _dataviewList; } else { // Did not return the dataview list - bail out now... return; } // Get the dataview record that matches what is in the dataviewProperties.dataviewname property (there should only be one with this name)... DataRow[] currentDataviewRows = _dataviewList.Select("is_enabled='Y' AND dataview_name='" + dataviewProperties.DataviewName + "'"); DataRow currentDataviewRow = null; if (currentDataviewRows.Length > 0) currentDataviewRow = currentDataviewRows[0]; // Build the list of compatible forms and bind it to the combobox... FormsData[] formsDataList = sharedUtils.GetDataviewFormsData(); if (formsDataList != null && formsDataList.Length > 0) { _formsList.Columns.Add("DisplayMember", typeof(string)); _formsList.Columns.Add("ValueMember", typeof(string)); _formsList.Columns.Add("PreferredDataviewName", typeof(string)); //_formsList.PrimaryKey = new DataColumn[] { _formsList.Columns["ValueMember"] }; foreach (FormsData fd in formsDataList) { if (!string.IsNullOrEmpty(fd.PreferredDataviewName)) { string[] preferredDataviews = fd.PreferredDataviewName.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); foreach (string preferredDataview in preferredDataviews) { if (fd.ConstInfo != null && !string.IsNullOrEmpty(fd.StrongFormName)) { DataRow newRow = _formsList.NewRow(); newRow["DisplayMember"] = fd.FormName + " (" + fd.ConstInfo.Module.Name + ")"; newRow["ValueMember"] = fd.StrongFormName; newRow["PreferredDataviewName"] = preferredDataview.Trim().ToLower(); _formsList.Rows.Add(newRow); } } } } } // Set the tab properties to the values passed into the dialog... this.TabProperties = dataviewProperties; // Populate the controls with the currently chosen dataview (if this is not a brand new dataview)... // (order matters here - first choose category, then DB area, and finally dataview) // STEP 1 - Catetory if (currentDataviewRow != null && ux_comboboxDataviewCategory.Items.Count > 0) { ux_comboboxDataviewCategory.SelectedValue = currentDataviewRow["category_name"].ToString(); } // STEP 2 - Database Area if (currentDataviewRow != null && ux_comboboxDataviewCategory.Items.Count > 0) { ux_comboboxDatabaseArea.SelectedValue = currentDataviewRow["database_area"].ToString(); } // STEP 3 - Dataview if (currentDataviewRow != null && ux_comboboxDataviewCategory.Items.Count > 0) { ux_comboboxDataviews.SelectedValue = currentDataviewRow["dataview_name"].ToString(); } // Disable the OK button and the radio buttons for forms viewer (by default)... if (ux_comboboxDataviews.SelectedValue == null) { ux_buttonOK.Enabled = false; ux_radiobuttonFormStyle.Enabled = false; ux_radiobuttonBothStyle.Enabled = false; ux_comboboxForm.Enabled = false; ux_checkboxAlwayOnTop.Enabled = false; ux_checkboxAlwayOnTop.Hide(); } sharedUtils.UpdateControls(this.Controls, this.Name); }
public void ux_tabcontrolShowProperties(TabControl ux_tabcontrolDataview, int indexOfCurrentTab) { DataviewProperties dvp; if (ux_tabcontrolDataview.SelectedTab != null && ux_tabcontrolDataview.SelectedTab.Tag != null && ux_tabcontrolDataview.SelectedTab.Tag.GetType() == typeof(DataviewProperties) && !string.IsNullOrEmpty(((DataviewProperties)ux_tabcontrolDataview.SelectedTab.Tag).TabName)) { dvp = (DataviewProperties)ux_tabcontrolDataview.SelectedTab.Tag; } else { dvp = new DataviewProperties(); dvp.TabName = ux_tabcontrolDataview.SelectedTab.Text; dvp.DataviewName = (string)ux_tabcontrolDataview.SelectedTab.Tag; dvp.StrongFormName = ""; dvp.ViewerStyle = "Spreadsheet"; dvp.AlwaysOnTop = "false"; } DataviewTabProperties dataviewTabPropertiesDialog = new DataviewTabProperties(_webServices, dvp); dataviewTabPropertiesDialog.StartPosition = FormStartPosition.CenterParent; if (dataviewTabPropertiesDialog.ShowDialog() == DialogResult.OK) { ux_tabcontrolDataview.TabPages[indexOfCurrentTab].Tag = dataviewTabPropertiesDialog.TabProperties; ux_tabcontrolDataview.TabPages[indexOfCurrentTab].Text = ((DataviewProperties)ux_tabcontrolDataview.TabPages[indexOfCurrentTab].Tag).TabName; } }
public void buildDataviewTabControl(TabControl ux_tabcontrolDataview, SharedUtils sharedUtils) { int numDataviewTabs = -1; // Clear the dataview tabs... ux_tabcontrolDataview.TabPages.Clear(); // Now add back in the tabpage for adding new tabpages... if (!ux_tabcontrolDataview.TabPages.ContainsKey("ux_tabpageDataviewNewTab")) { ux_tabcontrolDataview.TabPages.Add("ux_tabpageDataviewNewTab", "..."); } // Get the number of tabpages saved in the current user's settings... int.TryParse(sharedUtils.GetUserSetting("", ux_tabcontrolDataview.Name, "TabPages.Count", "-1"), out numDataviewTabs); // Create the user's saved dataview tabs... if (numDataviewTabs > 0) { for (int i = 0; i < numDataviewTabs; i++) { DataviewProperties dp = new DataviewProperties(); dp.TabName = sharedUtils.GetUserSetting("", ux_tabcontrolDataview.Name, "TabPages[" + i.ToString() + "].TabName", ""); dp.DataviewName = sharedUtils.GetUserSetting("", ux_tabcontrolDataview.Name, "TabPages[" + i.ToString() + "].DataviewName", ""); dp.StrongFormName = sharedUtils.GetUserSetting("", ux_tabcontrolDataview.Name, "TabPages[" + i.ToString() + "].FormName", ""); dp.ViewerStyle = sharedUtils.GetUserSetting("", ux_tabcontrolDataview.Name, "TabPages[" + i.ToString() + "].ViewerStyle", ""); dp.AlwaysOnTop = sharedUtils.GetUserSetting("", ux_tabcontrolDataview.Name, "TabPages[" + i.ToString() + "].AlwaysOnTop", ""); ux_tabcontrolAddTab(ux_tabcontrolDataview, dp.TabName, dp, Math.Min(i, ux_tabcontrolDataview.TabPages.IndexOfKey("ux_tabpageDataviewNewTab"))); } } else { // Make the default Accession dataview tab... DataviewProperties dp = new DataviewProperties(); dp.TabName = "Accessions"; dp.DataviewName = "get_accession"; dp.StrongFormName = ""; dp.ViewerStyle = "Spreadsheet"; dp.AlwaysOnTop = "false"; ux_tabcontrolAddTab(ux_tabcontrolDataview, dp.TabName, dp, Math.Min(0, ux_tabcontrolDataview.TabPages.IndexOfKey("ux_tabpageDataviewNewTab"))); // Make the default Inventory dataview tab... dp = new DataviewProperties(); dp.TabName = "Inventory"; dp.DataviewName = "get_inventory"; dp.StrongFormName = ""; dp.ViewerStyle = "Spreadsheet"; dp.AlwaysOnTop = "false"; ux_tabcontrolAddTab(ux_tabcontrolDataview, dp.TabName, dp, Math.Min(1, ux_tabcontrolDataview.TabPages.IndexOfKey("ux_tabpageDataviewNewTab"))); // Make the default Orders dataview tab... dp = new DataviewProperties(); dp.TabName = "Orders"; dp.DataviewName = "get_order_request"; dp.StrongFormName = ""; dp.ViewerStyle = "Spreadsheet"; dp.AlwaysOnTop = "false"; ux_tabcontrolAddTab(ux_tabcontrolDataview, dp.TabName, dp, Math.Min(2, ux_tabcontrolDataview.TabPages.IndexOfKey("ux_tabpageDataviewNewTab"))); // Make the default Cooperators dataview tab... dp = new DataviewProperties(); dp.TabName = "Cooperators"; dp.DataviewName = "get_cooperator"; dp.StrongFormName = ""; dp.ViewerStyle = "Spreadsheet"; dp.AlwaysOnTop = "false"; ux_tabcontrolAddTab(ux_tabcontrolDataview, dp.TabName, dp, Math.Min(3, ux_tabcontrolDataview.TabPages.IndexOfKey("ux_tabpageDataviewNewTab"))); } // Make the first tab active... ux_tabcontrolDataview.SelectedTab = ux_tabcontrolDataview.TabPages[0]; }
public void ux_tabcontrolCreateNewTab(TabControl ux_tabcontrolDataview, int indexOfNewTab) { DataviewProperties dvp = new DataviewProperties(); dvp.TabName = ""; dvp.DataviewName = ""; dvp.StrongFormName = ""; dvp.ViewerStyle = "Spreadsheet"; dvp.AlwaysOnTop = "false"; DataviewTabProperties newTabDialog = new DataviewTabProperties(_webServices, dvp); newTabDialog.StartPosition = FormStartPosition.CenterParent; if (newTabDialog.ShowDialog() == DialogResult.OK) { ux_tabcontrolAddTab(ux_tabcontrolDataview, newTabDialog.TabProperties.TabName, newTabDialog.TabProperties, indexOfNewTab); ux_tabcontrolDataview.SelectedIndex = indexOfNewTab; //SetDGVMainDataviewUserSettings(); } else { ux_tabcontrolDataview.DeselectTab(indexOfNewTab); } }
public void ux_tabcontrolAddTab(TabControl ux_tabcontrolDataview, string text, DataviewProperties tag, int position) { foreach (TabPage tp in ux_tabcontrolDataview.TabPages) { // If this tab page is already in the collection - bail out... if (tp.Text.ToUpper() == text.ToUpper() && ((DataviewProperties)tp.Tag).DataviewName == tag.DataviewName) return; } TabPage newTabPage = new TabPage(); newTabPage.Text = text; newTabPage.Tag = tag; ux_tabcontrolDataview.TabPages.Insert(position, newTabPage); }
public void ux_tabcontrolAddTab(TabControl ux_tabcontrolDataview, string text, DataviewProperties tag, int position) { _userInterfaceUtils.ux_tabcontrolAddTab(ux_tabcontrolDataview, text, tag, position); }
//public DataviewTabProperties(SharedUtils sharedUtils, DataviewProperties dataviewProperties, FormsData[] formsList) public DataviewTabProperties(WebServices webServices, DataviewProperties dataviewProperties) { InitializeComponent(); // Create a SharedUtils object... SharedUtils sharedUtils = new SharedUtils(webServices.Url, webServices.Username, webServices.Password_ClearText, true); // Get the list of dataviews... DataSet _dataviewData = sharedUtils.GetWebServiceData("get_dataview_list", "", 0, 0); // Populate the combobox with the list of available dataviews... if (_dataviewData.Tables.Contains("get_dataview_list")) { _dataviewList = _dataviewData.Tables["get_dataview_list"].Copy(); _dataviewList.Columns.Add("display_member", typeof(string)); _dataviewList.Columns.Add("category_name", typeof(string)); _dataviewList.Columns.Add("database_area", typeof(string)); foreach (DataRow dr in _dataviewList.Rows) { string friendlyName = ""; if (dr.Table.Columns.Contains("title")) { friendlyName += dr["title"].ToString().Trim(); } dr["display_member"] = friendlyName; if (!string.IsNullOrEmpty(dr["category_code"].ToString())) { dr["category_name"] = sharedUtils.GetLookupDisplayMember("code_value_lookup", dr["category_code"].ToString(), dr.Table.Columns["category_code"].ExtendedProperties["group_name"].ToString(), dr["category_code"].ToString()); } else { dr["category_name"] = ""; } if (!string.IsNullOrEmpty(dr["database_area_code"].ToString())) { dr["database_area"] = sharedUtils.GetLookupDisplayMember("code_value_lookup", dr["database_area_code"].ToString(), dr.Table.Columns["database_area_code"].ExtendedProperties["group_name"].ToString(), dr["database_area_code"].ToString()); } else { dr["database_area"] = ""; } } // Build the distinct list of categories and bind it to the combobox... _category = _dataviewList.DefaultView.ToTable(true, new string[] { "category_name" }); _category.DefaultView.Sort = "category_name asc"; ux_comboboxDataviewCategory.DisplayMember = "category_name"; ux_comboboxDataviewCategory.ValueMember = "category_name"; ux_comboboxDataviewCategory.DataSource = _category; // Bind the list to the dropdown combobox... if (_dataviewList.Columns.Contains("display_member")) { _dataviewList.DefaultView.Sort = "display_member asc"; } ux_comboboxDataviews.DisplayMember = "display_member"; ux_comboboxDataviews.ValueMember = "dataview_name"; ux_comboboxDataviews.DataSource = _dataviewList; } else { // Did not return the dataview list - bail out now... return; } // Get the dataview record that matches what is in the dataviewProperties.dataviewname property (there should only be one with this name)... DataRow[] currentDataviewRows = _dataviewList.Select("is_enabled='Y' AND dataview_name='" + dataviewProperties.DataviewName + "'"); DataRow currentDataviewRow = null; if (currentDataviewRows.Length > 0) { currentDataviewRow = currentDataviewRows[0]; } // Build the list of compatible forms and bind it to the combobox... FormsData[] formsDataList = sharedUtils.GetDataviewFormsData(); if (formsDataList != null && formsDataList.Length > 0) { _formsList.Columns.Add("DisplayMember", typeof(string)); _formsList.Columns.Add("ValueMember", typeof(string)); _formsList.Columns.Add("PreferredDataviewName", typeof(string)); //_formsList.PrimaryKey = new DataColumn[] { _formsList.Columns["ValueMember"] }; foreach (FormsData fd in formsDataList) { if (!string.IsNullOrEmpty(fd.PreferredDataviewName)) { string[] preferredDataviews = fd.PreferredDataviewName.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); foreach (string preferredDataview in preferredDataviews) { if (fd.ConstInfo != null && !string.IsNullOrEmpty(fd.StrongFormName)) { DataRow newRow = _formsList.NewRow(); newRow["DisplayMember"] = fd.FormName + " (" + fd.ConstInfo.Module.Name + ")"; newRow["ValueMember"] = fd.StrongFormName; newRow["PreferredDataviewName"] = preferredDataview.Trim().ToLower(); _formsList.Rows.Add(newRow); } } } } } // Set the tab properties to the values passed into the dialog... this.TabProperties = dataviewProperties; // Populate the controls with the currently chosen dataview (if this is not a brand new dataview)... // (order matters here - first choose category, then DB area, and finally dataview) // STEP 1 - Catetory if (currentDataviewRow != null && ux_comboboxDataviewCategory.Items.Count > 0) { ux_comboboxDataviewCategory.SelectedValue = currentDataviewRow["category_name"].ToString(); } // STEP 2 - Database Area if (currentDataviewRow != null && ux_comboboxDataviewCategory.Items.Count > 0) { ux_comboboxDatabaseArea.SelectedValue = currentDataviewRow["database_area"].ToString(); } // STEP 3 - Dataview if (currentDataviewRow != null && ux_comboboxDataviewCategory.Items.Count > 0) { ux_comboboxDataviews.SelectedValue = currentDataviewRow["dataview_name"].ToString(); } // Disable the OK button and the radio buttons for forms viewer (by default)... if (ux_comboboxDataviews.SelectedValue == null) { ux_buttonOK.Enabled = false; ux_radiobuttonFormStyle.Enabled = false; ux_radiobuttonBothStyle.Enabled = false; ux_comboboxForm.Enabled = false; ux_checkboxAlwayOnTop.Enabled = false; ux_checkboxAlwayOnTop.Hide(); } sharedUtils.UpdateControls(this.Controls, this.Name); }