public void GetProfilesItems(ObservableCollection <ProfileItem> listViewData, Profiles selectedProfile)
{
if (DBConnection == null)
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"DBConnection == null");
#endif
return;
}
listViewData.Clear();
if (selectedProfile == null)
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"selectedProfile == null");
#endif
return;
}
SQLiteCommand sqlcmd = DBConnection.CreateCommand();
sqlcmd.CommandText = "SELECT v.valuef, v.valuet, n.pname, n.punit, n.descryption FROM TVALUES v INNER"
+ $" JOIN TNAMES n ON v.nameid = n.id WHERE v.profileid={selectedProfile.id.ToString()};";
try
{
SQLiteDataReader dataReader = sqlcmd.ExecuteReader();
while (dataReader.Read())
{
String value = "";
int idcol = dataReader.GetOrdinal("valuef");
if (!dataReader.IsDBNull(idcol))
{
value = dataReader.GetString(idcol);
}
idcol = dataReader.GetOrdinal("valuet");
if (!dataReader.IsDBNull(idcol))
{
value = dataReader.GetString(idcol);
}
listViewData.Add(new ProfileItem(dataReader["pname"].ToString(), value, dataReader["punit"].ToString(),
dataReader["descryption"].ToString()));
}
}
catch (SQLiteException e)
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
$"SQL Error: {e.Message.ToString()} \nSQL: {sqlcmd.CommandText}");
#endif
listViewData.Clear();
}
}
/// <summary>
/// Load profiles data from DB in to Controller.listViewData
/// </summary>
public void LoadProfilesData(Profiles selectedProfile)
{
DB.GetProfilesItems(listViewData, selectedProfile);
}
/// <summary>
/// Open DXF File
/// </summary>
public void OpenDXFFile(Profiles selectedProfile, bool frontViewP,
bool topViewP, bool sideViewP)
{
#if DEBUG
Log.Notice(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name);
#endif
if (selectedProfile == null)
{
#if DEBUG
Log.Warning(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"selectedProfile == null");
#endif
return;
}
ProfilesFamily profileFamily = null;
foreach (ProfilesFamily family in familyList)
{
if (family.id == selectedProfile.profileFamilyId)
{
profileFamily = family;
}
}
if (profileFamily == null)
{
#if DEBUG
Log.Warning(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"profileFamily == null");
#endif
return;
}
if (!D3D.IsFamilyHasDxfDrawer(profileFamily))
{
#if DEBUG
Log.Warning(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"!D3D.IsFamilyHasDxfDrawer(profileFamily)");
#endif
return;
}
String tempPath = Path.GetTempPath() + selectedProfile.profileName + "_" + GKCommon.GetUniqueKey(4).ToLower() +
"_" + Controller.DXFFileExt;
if (!D3D.SaveDxfToFile(tempPath, profileFamily, new List <ProfileItem>(listViewData.ToList()),
new ViewOptions()
{
topView = topViewP, frontView = frontViewP, sideView = sideViewP
}))
{
#if DEBUG
Log.Warning(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"!D3D.SaveDxfToFile");
#endif
return;
}
try
{
System.Diagnostics.Process.Start(tempPath);
}
catch (ObjectDisposedException e)
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"ObjectDisposedException : " + e.Message.ToString());
#endif
}
catch (FileNotFoundException e)
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"FileNotFoundException : " + e.Message.ToString());
#endif
}
catch (System.ComponentModel.Win32Exception e)
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"System.ComponentModel.Win32Exception : " + e.Message.ToString());
#endif
}
}
/// <summary>
/// Save DXF File
/// </summary>
public void SaveDXFFile(Profiles selectedProfile, bool frontViewP,
bool topViewP, bool sideViewP)
{
#if DEBUG
Log.Notice(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name);
#endif
if (selectedProfile == null)
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"selectedProfile == null");
#endif
return;
}
ProfilesFamily profileFamily = null;
foreach (ProfilesFamily family in familyList)
{
if (family.id == selectedProfile.profileFamilyId)
{
profileFamily = family;
}
}
if (profileFamily == null)
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"profileFamily == null");
#endif
return;
}
if (!D3D.IsFamilyHasDxfDrawer(profileFamily))
{
#if DEBUG
Log.Error(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"!D3D.IsFamilyHasDxfDrawer(profileFamily)");
#endif
return;
}
SaveFileDialog savefile = new SaveFileDialog
{
FileName = selectedProfile.profileName + Controller.DXFFileExt,
Filter = "DXF Files|*" + Controller.DXFFileExt
};
if (savefile.ShowDialog() == false)
{
#if DEBUG
Log.Notice(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"User canceled save dialog");
#endif
return;
}
if (!D3D.SaveDxfToFile(savefile.FileName, profileFamily, new List <ProfileItem>(listViewData.ToList()),
new ViewOptions()
{
topView = topViewP, frontView = frontViewP, sideView = sideViewP
}))
{
#if DEBUG
Log.Warning(this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
"!D3D.SaveDxfToFile");
#endif
return;
}
}
