private static void ReadViewTypes(ref RevitSheetData sheetData) { try { sheetData.ViewTypes.Clear(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM ViewTypes"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { RevitViewType viewType = new RevitViewType(); viewType.Id = reader.GetGuid(reader.GetOrdinal("ViewType_Id")); viewType.Name = reader.GetString(reader.GetOrdinal("ViewType_Name")); viewType.ViewType = (ViewTypeEnum)Enum.Parse(typeof(ViewTypeEnum), reader.GetString(reader.GetOrdinal("ViewType_Enum"))); sheetData.ViewTypes.Add(viewType); } } } } catch (Exception ex) { string message = ex.Message; } }
private static bool InsertRevitViewType(RevitViewType vt) { bool inserted = false; try { if (null != connection && null != command) { command.CommandText = @"INSERT INTO ViewTypes(ViewType_Id, ViewType_Name, ViewType_Enum) " + "VALUES ('" + vt.Id.ToString() + "', '" + vt.Name + "', '" + vt.ViewType.ToString() + "')"; if (command.ExecuteNonQuery() > 0) { inserted = true; } } } catch (Exception ex) { string message = ex.Message; } return(inserted); }
private void dataGridView_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e) { try { DataGridRow row = e.Row; if (null != row) { RevitView oldView = row.Item as RevitView; string propertyName = e.Column.Header.ToString(); switch (propertyName) { case "View Name": TextBox textBoxName = e.EditingElement as TextBox; if (null != textBoxName) { bool databaseUpdated = SheetDataWriter.ChangeViewItem(oldView.Id.ToString(), propertyName, textBoxName.Text); } break; case "Sheet Number": ComboBox comboBoxSheet = e.EditingElement as ComboBox; if (null != comboBoxSheet) { RevitSheet selectedSheet = comboBoxSheet.SelectedItem as RevitSheet; if (null != selectedSheet) { bool databaseUpdated = SheetDataWriter.ChangeViewItem(oldView.Id.ToString(), propertyName, selectedSheet.Id.ToString()); } } break; case "View Type": ComboBox comboBoxViewType = e.EditingElement as ComboBox; if (null != comboBoxViewType) { RevitViewType selectedViewType = comboBoxViewType.SelectedItem as RevitViewType; if (null != selectedViewType) { bool databaseUpdated = SheetDataWriter.ChangeViewItem(oldView.Id.ToString(), propertyName, selectedViewType.Id.ToString()); } } break; case "U": TextBox textBoxU = e.EditingElement as TextBox; if (null != textBoxU) { double uValue; if (double.TryParse(textBoxU.Text, out uValue)) { bool databaseUpdated = SheetDataWriter.ChangeViewItem(oldView.Id.ToString(), propertyName, uValue); } } break; case "V": TextBox textBoxV = e.EditingElement as TextBox; if (null != textBoxV) { double vValue; if (double.TryParse(textBoxV.Text, out vValue)) { bool databaseUpdated = SheetDataWriter.ChangeViewItem(oldView.Id.ToString(), propertyName, vValue); } } break; } } } catch (Exception ex) { string message = ex.Message; } }
public static Dictionary <Guid, RevitViewType> GetDefaultViewTypes() { Dictionary <Guid, RevitViewType> viewTypes = new Dictionary <Guid, RevitViewType>(); try { RevitViewType viewType = new RevitViewType(new Guid("a8b93207-dbe5-4636-bf14-78752f499003"), "Undefined", ViewTypeEnum.Undefined); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("f10e767b-f4b8-4ad2-8395-2fabb1a6984e"), "Floor Plan", ViewTypeEnum.FloorPlan); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("15405703-3dda-45e9-98b1-9247f013a9e5"), "Ceiling Plan", ViewTypeEnum.CeilingPlan); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("b3187c7f-5cd2-4761-a191-70874399f114"), "Elevation", ViewTypeEnum.Elevation); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("76b9129a-c4e7-42f6-bc5e-c0a025cdfc29"), "3D", ViewTypeEnum.ThreeD); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("e18fe0ce-94c6-436e-ac8f-78cd027ebc32"), "Schedule", ViewTypeEnum.Schedule); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("46007e84-7433-4df8-98da-0442e79ee7c2"), "Drawing Sheet", ViewTypeEnum.DrawingSheet); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("5c57b817-fc05-42f2-aa13-84e96979cadd"), "Project Browser", ViewTypeEnum.ProjectBrowser); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("4ace6fa0-ce49-401d-a3d8-b4f48f569884"), "Report", ViewTypeEnum.Report); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("0e59bce9-979c-4a63-8fcb-cc8635c789c3"), "Drafting View", ViewTypeEnum.DraftingView); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("0dec12ec-686a-4572-a007-d3f74248cf51"), "Legend", ViewTypeEnum.Legend); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("74de5570-19f2-4323-aab0-08fb84d07f3c"), "System Browser", ViewTypeEnum.SystemBrowser); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("f472ba01-4761-4f8c-9ef1-cc4866add85c"), "Engineering Plan", ViewTypeEnum.EngineeringPlan); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("690251b8-ceac-477c-8371-165390e25973"), "Area Plan", ViewTypeEnum.AreaPlan); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("3eba3749-b108-4061-9139-780a7d21f3d6"), "Section", ViewTypeEnum.Section); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("bc5bf3c2-ca7e-4979-a658-aa3b45670c5b"), "Detail", ViewTypeEnum.Detail); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("7a5148e7-5c94-4f54-a9c3-204110a929d1"), "Cost Report", ViewTypeEnum.CostReport); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("d3df7aaf-3e0a-4b54-aab1-cae9efd6318c"), "Loads Report", ViewTypeEnum.LoadsReport); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("7753d485-7ab6-4980-80ad-fffa1cce63cd"), "Presure Loss Report", ViewTypeEnum.PresureLossReport); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("cb463925-c003-4885-b79d-4848f3c4cc2c"), "Column Schedule", ViewTypeEnum.ColumnSchedule); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("b8360857-5789-44db-ba9d-9c20ff382be9"), "Panel Schedule", ViewTypeEnum.PanelSchedule); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("621ee3cd-1995-48c9-af93-ef69469d2c87"), "Walkthrough", ViewTypeEnum.Walkthrough); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("0c059550-fd7f-4201-9b31-83e41a0b0742"), "Rendering", ViewTypeEnum.Rendering); viewTypes.Add(viewType.Id, viewType); viewType = new RevitViewType(new Guid("fcda21a6-a6ce-4498-bfd0-c5fa0123224c"), "Internal", ViewTypeEnum.Internal); viewTypes.Add(viewType.Id, viewType); } catch (Exception ex) { string message = ex.Message; } return(viewTypes); }
public static FilterViewsByType FilterViewsByType(RevitViewType revitViewType) { return(new FilterViewsByType { RevitViewType = revitViewType }); }