//*****************************RemoveElement()*****************************
public void RemoveElement(Document doc, Dictionary <string, Element> dictionary, List <IsoObj> List_ExcelIsolators)
{
// iterate through the dictionary.
foreach (KeyValuePair <string, Element> entry in dictionary)
{
string key = entry.Key;
Element e = entry.Value;
//search for element id parameter
IsoObj elementFound = List_ExcelIsolators.Find(x => x.ID == key);
// if the element id isn't found it will delete element.
if (elementFound == null)
{
try
{
using (Transaction t = new Transaction(doc))
{
t.Start("Remove Element");
doc.Delete(e.Id);
t.Commit();
}
}
catch (Exception ex)
{
string ErrMessage = ex.Message;
}
}
}
}
//*****************************Create_BaseIsolator()*****************************
public void Create_BaseIsolator(UIDocument uidoc, Document doc, string fsFamilyName,
string fsFamilyType, string levelName, IsoObj Isolator)
{
// XY
string xCoord = Isolator.X;
string yCoord = Isolator.Y;
// Rotation
string rotation = Isolator.R;
double x = double.Parse(xCoord) / 12;
double y = double.Parse(yCoord) / 12;
// Identification
string id = Isolator.ID;
// LINQ to find the FamilySymbol by its type name.
FamilySymbol familySymbol = (from fs in new FilteredElementCollector(doc).
OfClass(typeof(FamilySymbol)).
Cast <FamilySymbol>()
where (fs.Family.Name == fsFamilyName && fs.Name == fsFamilyType)
select fs).First();
// Get Level
Level level = GetLevel(doc, levelName);
// Convert coordinates to double and create XYZ point.
double r = double.Parse(rotation);
XYZ xyz = new XYZ(x, y, level.Elevation);
XYZ xyz_A = new XYZ(x, y, level.Elevation + 2);
Line axis = Line.CreateBound(xyz, xyz_A);
// Create Isolator.
using (Transaction t = new Transaction(doc, "Create Base Isolator"))
{
t.Start();
if (!familySymbol.IsActive)
{
// Ensure the family symbol is activated.
familySymbol.Activate();
doc.Regenerate();
}
// Create Base Isolator.
FamilyInstance IsolatorInstance = doc.Create.NewFamilyInstance(xyz, familySymbol, level, StructuralType.Footing);
//FamilyInstance IsolatorInstance = doc.Create.NewFamilyInstance(xyz, familySymbol, hostedElement, level, StructuralType.Footing);
// Rotate family elmement
IsolatorInstance.Location.Rotate(axis, r);
// Parameter ID for tracking (MUST ADD PARAMETER TO PROJECT)
Parameter SOMIDParam = IsolatorInstance.LookupParameter("SOM ID");
SOMIDParam.Set(id).ToString();
t.Commit();
}
}
//*****************************MoveInstance()*****************************
public void MoveInstance(Document doc, Element element, IsoObj Isolator, string levelName)
{
// get the column current location
LocationPoint InstanceLocation = element.Location as LocationPoint;
LibraryConvertUnits lib = new LibraryConvertUnits();
XYZ oldPlace = InstanceLocation.Point;
double Old_Rotation = InstanceLocation.Rotation;
//Get Level
Level level = GetLevel(doc, levelName);
// XY
string xCoord = Isolator.X;
string yCoord = Isolator.Y;
// Rotation
string rotation = Isolator.R;
double New_x = double.Parse(xCoord) / 12;
double New_y = double.Parse(yCoord) / 12;
double New_Rotation = double.Parse(rotation);
XYZ New_xyz = new XYZ(New_x, New_y, level.Elevation);
XYZ New_xyz_A = new XYZ(New_x, New_y, level.Elevation + 2);
Line New_Axis = Line.CreateBound(New_xyz, New_xyz_A);
double Move_X = New_x - oldPlace.X;
double Move_Y = New_y - oldPlace.Y;
double Rotate = 0;
if (New_Rotation != null)
{
Rotate = New_Rotation - Old_Rotation;
}
// Move the element to new location.
XYZ new_xyz = new XYZ(Move_X, Move_Y, level.Elevation);
//Start move using a transaction.
Transaction t = new Transaction(doc);
t.Start("Move Element");
ElementTransformUtils.MoveElement(doc, element.Id, new_xyz);
ElementTransformUtils.RotateElement(doc, element.Id, New_Axis, Rotate);
t.Commit();
}
//*****************************Get_ExcelFileToList()*****************************
public List <IsoObj> Get_ExcelFileToList(string Etabsfile_path)
{
List <IsoObj> List_Isolators = new List <IsoObj>();
try
{
// Gets Excel file using a file path
var package = new ExcelPackage(new FileInfo(Etabsfile_path));
// Count the number of Worksheets are in the file.
int num = package.Workbook.Worksheets.Count;
// get first workshet
ExcelWorksheet WorkSheets = package.Workbook.Worksheets[1];
//check name
string name = WorkSheets.Name;
var End_WorkSheets = WorkSheets.Dimension.End;
// Starts on the second row avoiding header.
for (int row = 2; row <= End_WorkSheets.Row; row++)
{
IsoObj objIsolator = new IsoObj();
for (int col = 1; col <= End_WorkSheets.Column; col++)
{
if (col == 2)
{
objIsolator.X = WorkSheets.Cells[row, col].Text;
}
if (col == 3)
{
objIsolator.Y = WorkSheets.Cells[row, col].Text;
}
if (col == 4)
{
objIsolator.R = WorkSheets.Cells[row, col].Text;
}
if (col == 5)
{
objIsolator.ID = WorkSheets.Cells[row, col].Text;
}
}
List_Isolators.Add(objIsolator);
}
}
catch (Exception e)
{
string x = e.Message;
}
return(List_Isolators);
}
//*****************************porgramIsolator()*****************************
public string porgramIsolator(UIApplication uiApp, Document doc, UIDocument uiDocument,
IsoObj Isolator, string SelectedLevel, Dictionary <string, Element> dictionary)
{
// Family name and type being used.
string fsFamilyName = "BASE ISOLATOR - (I SF)";
string fsFamilyType = "TYPE 1";
// Selected level
string levelName = SelectedLevel;
// Identification
string id = Isolator.ID;
try
{
//Test to see if the dictionary contains the Element
if (dictionary.ContainsKey(id))
{
// look up Key in dictionary to get Element.
Element element = dictionary[id];
MoveInstance(doc, element, Isolator, SelectedLevel);
}
// If dictioary doesn't contian element it will create a new one.
else
{
// Method to create family.
Create_BaseIsolator(uiDocument, doc, fsFamilyName,
fsFamilyType, levelName, Isolator);
}
}
catch (Exception e)
{
string message = e.Message;
return(Result.Failed.ToString());
}
return(Result.Succeeded.ToString());
}
