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