private static GUTag ReadGUTagFromR(SQLiteDataReader r) { GUTag tag = new GUTag(); //0. ID tag.Id = r.GetGuid(0); //1. Title tag.AddAlias(r.GetString(1)); //2. Alias string alias = r.GetString(2); string[] aliasList = alias.Split(new char[] { '\n' }, StringSplitOptions.RemoveEmptyEntries); foreach (string a in aliasList) { tag.AddAlias(a); } //3. PID tag.PId = r.GetGuid(3); //4. Children string chilrend = r.GetString(4); string[] childList = chilrend.Split(new char[] { '\n' }, StringSplitOptions.RemoveEmptyEntries); foreach (string c in childList) { tag.AddChild(Guid.Parse(c)); } return(tag); }
public LinkedSheet GetLinkedSheet(string uniqueId, Guid projectGuid) { LinkedSheet lSheet = null; try { if (null != connection && null != command) { using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM LinkedSheets WHERE LinkedSheet_Element_Id= '" + uniqueId + "' AND LinkedSheet_Project_Id = '" + projectGuid.ToString() + "'"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { lSheet = new LinkedSheet(); lSheet.Id = reader.GetGuid(reader.GetOrdinal("LinkedSheet_Id")); lSheet.SheetId = reader.GetGuid(reader.GetOrdinal("LinkedSheet_Sheet_Id")); Guid projectId = reader.GetGuid(reader.GetOrdinal("LinkedSheet_Project_Id")); lSheet.LinkProject = new LinkedProject(projectGuid); lSheet.LinkedElementId = reader.GetString(reader.GetOrdinal("LinkedSheet_Element_Id")); lSheet.IsSource = reader.GetBoolean(reader.GetOrdinal("LinkedSheet_IsSource")); break; } } } } } catch (Exception ex) { string message = ex.Message; } return(lSheet); }
private static void ReadViews(ref RevitSheetData sheetData) { try { sheetData.Views.Clear(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM Views"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { RevitView view = new RevitView(); view.Id = reader.GetGuid(reader.GetOrdinal("View_Id")); view.Name = reader.GetString(reader.GetOrdinal("View_Name")); Guid sheetId = reader.GetGuid(reader.GetOrdinal("View_Sheet_Id")); if (sheetId != Guid.Empty) { var sheetFound = from sheet in sheetData.Sheets where sheet.Id == sheetId select sheet; if (sheetFound.Count() > 0) { view.Sheet = sheetFound.First(); } } Guid viewTypeId = reader.GetGuid(reader.GetOrdinal("View_ViewType_Id")); if (viewTypeId != Guid.Empty) { var viewTypeFound = from viewType in sheetData.ViewTypes where viewType.Id == viewTypeId select viewType; if (viewTypeFound.Count() > 0) { view.ViewType = viewTypeFound.First(); } } view.LocationU = reader.GetDouble(reader.GetOrdinal("View_LocationX")); view.LocationV = reader.GetDouble(reader.GetOrdinal("View_LocationY")); sheetData.Views.Add(view); } } } } catch (Exception ex) { string message = ex.Message; } }
public List <SheetParameter> GetSheetParameters() { List <SheetParameter> parameters = new List <SheetParameter>(); try { if (null != connection && null != command) { using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM SheetParameters"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { SheetParameter parameter = new SheetParameter(); parameter.ParameterId = reader.GetGuid(reader.GetOrdinal("Parameter_Id")); parameter.ParameterName = reader.GetString(reader.GetOrdinal("Parameter_Name")); parameter.ParameterType = reader.GetString(reader.GetOrdinal("Parameter_Type")); parameters.Add(parameter); } } } } } catch (Exception ex) { string message = ex.Message; } return(parameters); }
private static void ReadDiscipline(ref RevitSheetData sheetData) { try { sheetData.Disciplines.Clear(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM Discipline"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Discipline discipline = new Discipline(); discipline.Id = reader.GetGuid(reader.GetOrdinal("Discipline_Id")); discipline.Name = reader.GetString(reader.GetOrdinal("Discipline_Name")); sheetData.Disciplines.Add(discipline); } } } sheetData.Disciplines = new ObservableCollection <Discipline>(sheetData.Disciplines.OrderBy(o => o.Name)); } catch (Exception ex) { string message = ex.Message; } }
public static void ReadReplaceItems(ref RevitSheetData sheetData) { try { sheetData.ItemMaps.Clear(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM ReplaceItems"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { RevitItemMapper item = new RevitItemMapper(); item.ItemId = reader.GetGuid(reader.GetOrdinal("ReplaceItem_Id")); item.ItemType = (MappingType)Enum.Parse(typeof(MappingType), reader.GetString(reader.GetOrdinal("ReplaceItem_Type"))); item.ParameterName = reader.GetString(reader.GetOrdinal("ReplaceItem_Parameter")); item.SourceValue = reader.GetString(reader.GetOrdinal("ReplaceItem_Source_Value")); item.TargetValue = reader.GetString(reader.GetOrdinal("ReplaceItem_Target_Value")); sheetData.ItemMaps.Add(item); } } } } catch (Exception ex) { string message = ex.Message; } }
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; } }
public List <Guid> GetSheetIds() { List <Guid> sheetIds = new List <Guid>(); try { if (null != connection && null != command) { using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT Sheet_Id FROM Sheets"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Guid sheetId = reader.GetGuid(reader.GetOrdinal("Sheet_Id")); sheetIds.Add(sheetId); } } } } } catch (Exception ex) { string message = ex.Message; } return(sheetIds); }
private static void ReadSheetParameters(ref RevitSheetData sheetData) { try { sheetData.SheetParameters.Clear(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM SheetParameters"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { SheetParameter parameter = new SheetParameter(); parameter.ParameterId = reader.GetGuid(reader.GetOrdinal("Parameter_Id")); parameter.ParameterName = reader.GetString(reader.GetOrdinal("Parameter_Name")); parameter.ParameterType = reader.GetString(reader.GetOrdinal("Parameter_Type")); sheetData.SheetParameters.Add(parameter); } } } } catch (Exception ex) { string message = ex.Message; } }
public List <PluginSettings> GetHTMLPositions(string computerID) { List <PluginSettings> positions = new List <PluginSettings>(); string connectionString = string.Format("Data Source={0};Version=3;", ConfigurationManager.AppSettings["DatabasePath"]); try { using (SQLiteConnection dbConnection = new SQLiteConnection(connectionString)) { dbConnection.Open(); SQLiteCommand cmd = new SQLiteCommand(@"SELECT PluginUID, Position_html_top, Position_html_left FROM PluginSettings WHERE ComputerID = @ComputerID", dbConnection); cmd.Parameters.AddWithValue("@ComputerID", computerID); SQLiteDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { PluginSettings plugSet = new PluginSettings(); plugSet.ComputerID = computerID; plugSet.PluginUID = reader.GetGuid(0); plugSet.HTMLPosition = new HTMLPosition(reader.GetInt32(1), reader.GetInt32(2)); positions.Add(plugSet); } } } catch (Exception ex) { throw ex; } return(positions); }
public void Load() { mDB.Open(); mLog.Debug("DB file opened successfully "); using (SQLiteCommand load = new SQLiteCommand(@"SELECT CharacterId,CharacterName,AccessToken,Expires,RefreshToken,UnreadCount,Permissions,LastMailId,FolderExpanded FROM Accounts ORDER BY CharacterName", mDB)) { using (SQLiteDataReader reader = (SQLiteDataReader)load.ExecuteReader()) { while (reader.Read()) { mAccounts.Add(new Account(this, reader)); } } } using (SQLiteCommand load = new SQLiteCommand(@"SELECT Drafts.DraftId,Drafts.CharacterId,Drafts.IsReply,Drafts.LastModified,Drafts.Subject,Drafts.Body,DraftRecipients.RecipientType,DraftRecipients.RecipientId FROM Drafts LEFT JOIN DraftRecipients ON(Drafts.DraftId = DraftRecipients.DraftId)", mDB)) { using (SQLiteDataReader reader = load.ExecuteReader()) { DraftMessage msg = null; while (reader.Read()) { Guid id = reader.GetGuid(0); if (msg == null || msg.DraftId != id) { msg = new DraftMessage(id) { DB = this }; mDrafts.Add(msg); msg.AccountId = reader.GetInt64(1); msg.IsReply = reader.GetBoolean(2); msg.LastModified = reader.GetDateTime(3); msg.Subject = reader.GetString(4); msg.Body = reader.GetString(5); } if (!reader.IsDBNull(6) && !reader.IsDBNull(7)) { msg.Recipients.Add(new UserCache.EntityInfo() { EntityType = (Common.EntityType)reader.GetInt32(6), EntityID = reader.GetInt64(7) }); } } } } }
private static ProfileText CreatePatientProfile(SQLiteDataReader reader) { var patient = new ProfileText { Pkey = reader.GetGuid(0), PatientId = reader.IsDBNull(1) ? string.Empty : reader.GetString(1), FamilyName = reader.IsDBNull(2) ? string.Empty : reader.GetString(2), MiddleName = reader.IsDBNull(3) ? string.Empty : reader.GetString(3), FirstName = reader.IsDBNull(4) ? string.Empty : reader.GetString(4) }; return(patient); }
public LinkedRevision GetLinkedRevision(string uniqueId, Guid projectGuid) { LinkedRevision lRevision = null; try { if (null != connection && null != command) { using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM LinkedRevisions WHERE LinkedRevision_Element_Id= '" + uniqueId + "' AND LinkedRevision_Project_Id = '" + projectGuid.ToString() + "'"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { lRevision = new LinkedRevision(); lRevision.Id = reader.GetGuid(reader.GetOrdinal("LinkedRevision_Id")); lRevision.RevisionId = reader.GetGuid(reader.GetOrdinal("LinkedRevision_Revision_Id")); lRevision.Sequence = reader.GetInt32(reader.GetOrdinal("LinkedRevision_Sequence")); lRevision.Number = reader.GetString(reader.GetOrdinal("LinkedRevision_Number")); lRevision.NumberType = (NumberType)Enum.Parse(typeof(NumberType), reader.GetString(reader.GetOrdinal("LinkedRevision_NumberType"))); Guid projectId = reader.GetGuid(reader.GetOrdinal("LinkedRevision_Project_Id")); lRevision.LinkProject = new LinkedProject(projectId); lRevision.LinkedElementId = reader.GetString(reader.GetOrdinal("LinkedRevision_Element_Id")); lRevision.IsSource = reader.GetBoolean(reader.GetOrdinal("LinkedRevision_IsSource")); break; } } } } } catch (Exception ex) { string message = ex.Message; } return(lRevision); }
public SheetParameterValue GetSheetParameterValue(Guid paramId, Guid sheetId) { SheetParameterValue paramValue = null; try { if (null != connection && null != command) { using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM SheetParameterValues WHERE ParameterValue_Parameter_Id= '" + paramId.ToString() + "' AND ParameterValue_Sheet_Id = '" + sheetId.ToString() + "'"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { paramValue = new SheetParameterValue(); paramValue.ParameterValueId = reader.GetGuid(reader.GetOrdinal("ParameterValue_Id")); paramValue.SheetId = reader.GetGuid(reader.GetOrdinal("ParameterValue_Sheet_Id")); Guid parameterId = reader.GetGuid(reader.GetOrdinal("ParameterValue_Parameter_Id")); paramValue.Parameter = new SheetParameter() { ParameterId = parameterId }; paramValue.ParameterValue = reader.GetString(reader.GetOrdinal("ParameterValue_Parameter_Value")); break; } } } } } catch (Exception ex) { string message = ex.Message; } return(paramValue); }
private CrashReport MakeCrashReport(SQLiteDataReader reader) { Guid g = reader.GetGuid(0); //Guid.Parse(reader.GetString(0))); long l = reader.GetInt64(1); string s1 = reader.GetString(2); string s2 = reader.GetString(3); string s3 = reader.GetString(4); string s4 = reader.GetString(5); Version v = Version.Parse(reader.GetString(6)); string s6 = reader.GetValue(7) as string; //Not GetString as GetString throws an invalidCast string s7 = reader.GetValue(8) as string; //(or another exception, cannot rmbr) string userstory = reader.GetValue(9) as string; //If the value is null, and this and following fields string trace = reader.GetValue(10) as string; //can be null as they aren't set before zip is downloaded return(new CrashReport(innerApi, g, l, s1, s2, s3, s4, v, s6, s7, trace, userstory)); }
public List <PluginSettings> GetAllPluginSettings() { List <PluginSettings> pluginSettingsList = new List <PluginSettings>(); string connectionString = string.Format("Data Source={0};Version=3;", ConfigurationManager.AppSettings["DatabasePath"]); try { using (SQLiteConnection dbConnection = new SQLiteConnection(connectionString)) { dbConnection.Open(); SQLiteCommand cmd = new SQLiteCommand(@"SELECT ps.PluginUID, p.Name, ps.ComputerID, m.ComputerName, m.[Group], p.Type, ShowPlugin, RefreshInterval, Position_html_top, Position_html_left, CriticalValueLimit, WarningValueLimit FROM PluginSettings ps JOIN Machines m on ps.ComputerID = m.ComputerID JOIN Plugins p on ps.PluginUID = p.PluginUID ORDER BY m.[Group], ps.ComputerID, ps.PluginUID", dbConnection); SQLiteDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { PluginSettings pluginSettings = new PluginSettings(); pluginSettings.PluginUID = reader.GetGuid(0); pluginSettings.PluginName = reader.GetString(1); pluginSettings.ComputerID = reader.GetString(2); pluginSettings.ComputerName = reader.GetString(3); pluginSettings.GroupName = reader.GetString(4); pluginSettings.PluginType = (PluginType)reader.GetInt32(5); pluginSettings.Show = (reader.GetValue(6) == DBNull.Value) ? true : reader.GetBoolean(6); pluginSettings.RefreshInterval = (reader.GetValue(7) == DBNull.Value) ? 5 : reader.GetInt32(7); //TODO: default value for refreshInterval pluginSettings.HTMLPosition = new HTMLPosition(reader.GetInt32(8), reader.GetInt32(9)); pluginSettings.CriticalValueLimit = (reader.GetValue(10) == DBNull.Value) ? Double.MaxValue : reader.GetDouble(10); pluginSettings.WarningValueLimit = (reader.GetValue(11) == DBNull.Value) ? Double.MaxValue : reader.GetDouble(11); pluginSettingsList.Add(pluginSettings); } } } catch (Exception ex) { throw ex; } return(pluginSettingsList); }
public Guid QuerySqlDB(Guid id) { if (queryCmd == null) { queryCmd = new SQLiteCommand(@"SELECT * FROM Opts where (ID=@ID)", Conn); queryCmd.Parameters.AddRange(new[] { new SQLiteParameter("@ID", DbType.Guid), }); } queryCmd.Parameters[0].Value = id; using (SQLiteDataReader r = queryCmd.ExecuteReader()) { if (r.Read()) { Guid ret = r.GetGuid(0); return(ret); } else { return(Guid.Empty); } } }
public T ReadFromDbReader <T>(SQLiteDataReader reader, string prefix = "") where T : new() { if (reader == null) { throw new ArgumentNullException("reader"); } if (prefix == null) { prefix = ""; } var type = typeof(T); if (!storedTypes.ContainsKey(type)) { LoadInfo(type); } var cont = storedTypes[type]; cont.LoadedCount++; var r = Activator.CreateInstance <T>(); if (r is IDbLoader) { ((IDbLoader)r).Load(reader, prefix); return(r); } int[] cols = new int[cont.NameTable.Length]; for (int i = 0; i < cols.Length; ++i) { cols[i] = reader.GetOrdinal(prefix + cont.NameTable[i]); } for (int i = 0; i < cols.Length; ++i) { var name = cont.NameTable[i]; var prop = cont.Properties[name]; var attr = cont.PropAttributes[name]; var ind = cols[i]; switch (cont.PropertyType[name]) { case "bo?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (bool?)reader.GetBoolean(ind)); break; case "sh?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (short?)reader.GetInt16(ind)); break; case "in?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (int?)reader.GetInt32(ind)); break; case "lo?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (long?)reader.GetInt64(ind)); break; case "fl?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (float?)reader.GetFloat(ind)); break; case "do?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (double?)reader.GetDouble(ind)); break; case "ch?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (char?)reader.GetChar(ind)); break; case "Da?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (DateTime?)reader.GetDateTime(ind)); break; case "Gu?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (Guid?)reader.GetGuid(ind)); break; case "str": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => reader.GetString(ind)); break; case "boo": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, false, () => reader.GetBoolean(ind)); break; case "sho": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetInt16(ind)); break; case "int": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetInt32(ind)); break; case "lon": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetInt64(ind)); break; case "flo": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetFloat(ind)); break; case "dou": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetDouble(ind)); break; case "cha": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetChar(ind)); break; case "Dat": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, new DateTime(), () => reader.GetDateTime(ind)); break; case "Gui": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, new Guid(), () => reader.GetGuid(ind)); break; case "en?": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => (int?)reader.GetInt32(ind)); break; case "enu": FillKnowProp(cont, name, r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetInt32(ind)); break; default: { if (!MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (bool?)reader.GetBoolean(ind)) & !MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (short?)reader.GetInt16(ind)) & !MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (int?)reader.GetInt32(ind)) & !MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (long?)reader.GetInt64(ind)) & !MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (float?)reader.GetFloat(ind)) & !MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (double?)reader.GetDouble(ind)) & !MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (char?)reader.GetChar(ind)) & !MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (DateTime?)reader.GetDateTime(ind)) & !MatchTransfer(r, prop, () => reader.IsDBNull(ind) ? null : (Guid?)reader.GetGuid(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, null, () => reader.GetString(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, false, () => reader.GetBoolean(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetInt16(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetInt32(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetInt64(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetFloat(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetDouble(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, 0, () => reader.GetChar(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, DateTime.Now, () => reader.GetDateTime(ind)) & !MatchTransfer(r, prop, reader.IsDBNull(ind), attr.NullValue, new Guid(), () => reader.GetGuid(ind))) { throw new ArgumentException("cannot found matching local type for " + prefix + name); } } break; } } return(r); }
private static void ReadRevitSheets(ref RevitSheetData sheetData) { try { ObservableCollection <LinkedSheet> linkedSheets = new ObservableCollection <LinkedSheet>(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM LinkedSheets"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { LinkedSheet lSheet = new LinkedSheet(); lSheet.Id = reader.GetGuid(reader.GetOrdinal("LinkedSheet_Id")); lSheet.SheetId = reader.GetGuid(reader.GetOrdinal("LinkedSheet_Sheet_Id")); Guid projectId = reader.GetGuid(reader.GetOrdinal("LinkedSheet_Project_Id")); var projectFound = from project in sheetData.LinkedProjects where project.Id == projectId select project; if (projectFound.Count() > 0) { lSheet.LinkProject = projectFound.First(); } lSheet.LinkedElementId = reader.GetString(reader.GetOrdinal("LinkedSheet_Element_Id")); lSheet.IsSource = reader.GetBoolean(reader.GetOrdinal("LinkedSheet_IsSource")); linkedSheets.Add(lSheet); } } } ObservableCollection <SheetParameterValue> sheetParameterValues = new ObservableCollection <SheetParameterValue>(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM SheetParameterValues"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { SheetParameterValue paramValue = new SheetParameterValue(); paramValue.ParameterValueId = reader.GetGuid(reader.GetOrdinal("ParameterValue_Id")); paramValue.SheetId = reader.GetGuid(reader.GetOrdinal("ParameterValue_Sheet_Id")); Guid parameterId = reader.GetGuid(reader.GetOrdinal("ParameterValue_Parameter_Id")); var paramFound = from param in sheetData.SheetParameters where param.ParameterId == parameterId select param; if (paramFound.Count() > 0) { paramValue.Parameter = paramFound.First(); } paramValue.ParameterValue = reader.GetString(reader.GetOrdinal("ParameterValue_Parameter_Value")); sheetParameterValues.Add(paramValue); } } } ObservableCollection <RevisionOnSheet> revisionOnSheets = new ObservableCollection <RevisionOnSheet>(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM RevisionsOnSheet"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { RevisionOnSheet ros = new RevisionOnSheet(); ros.MapId = reader.GetGuid(reader.GetOrdinal("RevisionsOnSheet_Id")); ros.SheetId = reader.GetGuid(reader.GetOrdinal("RevisionsOnSheet_Sheet_Id")); Guid revisionId = reader.GetGuid(reader.GetOrdinal("RevisionsOnSheet_Revision_Id")); var revisionFound = from rev in sheetData.Revisions where rev.Id == revisionId select rev; if (revisionFound.Count() > 0) { ros.RvtRevision = revisionFound.First(); } ros.Include = reader.GetBoolean(reader.GetOrdinal("RevisionsOnSheet_Include")); revisionOnSheets.Add(ros); } } } sheetData.Sheets.Clear(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM Sheets"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { RevitSheet sheet = new RevitSheet(); sheet.Id = reader.GetGuid(reader.GetOrdinal("Sheet_Id")); sheet.Number = reader.GetString(reader.GetOrdinal("Sheet_Number")); sheet.Name = reader.GetString(reader.GetOrdinal("Sheet_Name")); Guid disciplineId = reader.GetGuid(reader.GetOrdinal("Sheet_Discipline_Id")); var disciplineFound = from discipline in sheetData.Disciplines where discipline.Id == disciplineId select discipline; if (disciplineFound.Count() > 0) { sheet.DisciplineObj = disciplineFound.First(); } var linkedSheetFound = from linkedSheet in linkedSheets where linkedSheet.SheetId == sheet.Id select linkedSheet; if (linkedSheetFound.Count() > 0) { sheet.LinkedSheets = new ObservableCollection <LinkedSheet>(linkedSheetFound.ToList()); } foreach (SheetParameter param in sheetData.SheetParameters) { var parameterValueFound = from paramValue in sheetParameterValues where paramValue.SheetId == sheet.Id && paramValue.Parameter.ParameterId == param.ParameterId select paramValue; if (parameterValueFound.Count() > 0) { SheetParameterValue value = parameterValueFound.First(); sheet.SheetParameters.Add(param.ParameterId, value); } } var revisionOnSheetFound = from ros in revisionOnSheets where ros.SheetId == sheet.Id select ros; if (revisionOnSheetFound.Count() > 0) { foreach (RevisionOnSheet ros in revisionOnSheetFound) { if (!sheet.SheetRevisions.ContainsKey(ros.RvtRevision.Id)) { sheet.SheetRevisions.Add(ros.RvtRevision.Id, ros); } } } sheetData.Sheets.Add(sheet); } } } sheetData.Sheets = new ObservableCollection <RevitSheet>(sheetData.Sheets.OrderBy(o => o.Number)); } catch (Exception ex) { string message = ex.Message; } }
public static bool SaveQuestion(SQLiteDataReader rs, Guid SubjectID, Guid classid) { string Campo; int i; QuestionTemp q = new QuestionTemp(); for (i = 0; i < rs.FieldCount; i++) { Campo = rs.GetName(i); var valor = rs.GetValue(i); switch (Campo) { case "QuestionID": q.QuestionID = rs.GetGuid(i); break; case "SubjectID": q.SubjectID = SubjectID; break; case "ClassID": q.ClassID = classid; break; case "MentalityTypeID": break; case "OSubjectID": break; case "QuestionNbr": q.QuestionNbr = rs.GetString(i); break; case "Content": q.Content = (Byte[])rs.GetValue(i); // != DBNull.Value ? (Byte[])rs.GetValue(i) : null; break; case "Question": q.Question = (Byte[])rs.GetValue(i); // != DBNull.Value ? (Byte[])rs.GetValue(i) : null; // q.PicQuestion = imageToByteArray(byteArrayToImage((byte[])rs.GetValue(i))); //q.PicQuestion = System.IO.File.ReadAllBytes(((byte[])rs.GetValue(i)); break; case "Answer1": q.Answer1 = (Byte[])rs.GetValue(i); // != DBNull.Value ? (Byte[])rs.GetValue(i) : null; // q.PicAnswer1 = imageToByteArray(byteArrayToImage((byte[])rs.GetValue(i))); break; case "Answer2": //q.Answer2 = ReadMsWordHavePic((Byte[])rs.GetValue(i)); q.Answer2 = (Byte[])rs.GetValue(i); // != DBNull.Value ? (Byte[])rs.GetValue(i) : null; // q.PicAnswer2 = imageToByteArray(byteArrayToImage((byte[])rs.GetValue(i))); break; case "Answer3": //q.Answer3 = ReadMsWordHavePic((Byte[])rs.GetValue(i)); q.Answer3 = (Byte[])rs.GetValue(i); // != DBNull.Value ? (Byte[])rs.GetValue(i) : null; // q.PicAnswer3 = imageToByteArray(byteArrayToImage((byte[])rs.GetValue(i))); break; case "Answer4": //q.Answer4 = ReadMsWordHavePic((Byte[])rs.GetValue(i)); q.Answer4 = (Byte[])rs.GetValue(i); // != DBNull.Value ? (Byte[])rs.GetValue(i) : null; // q.PicAnswer4 = imageToByteArray(byteArrayToImage((byte[])rs.GetValue(i))); break; case "NoOfAnswers": q.NoOfAnswers = rs.GetInt32(i); // (int)rs.GetValue(i); break; case "TheAnswer": q.TheAnswer = rs.GetInt32(i); break; default: q.Answer1SwapYN = true; q.Answer2SwapYN = true; q.Answer3SwapYN = true; q.Answer4SwapYN = true; break; } } q.Used = 0; q.Active = true; q.QID = (int)i; int maxlength = 0; int[] a; a = new int[4]; a[0] = q.Answer1.Length; a[1] = q.Answer2.Length; a[2] = q.Answer3.Length; a[3] = q.Answer4.Length; for (int j = 0; j < a.Length; j++) { if (maxlength < a[j]) { maxlength = a[j]; } } q.MaxAnswerLen = maxlength; if (!new QuestionDAO().AddQuestionTemp(q)) { return(false); } return(true); }
private void AddFromRecordSet(SQLiteDataReader rs) { try { if (!rs.IsDBNull(0)) { _backup_lsn = rs.GetDecimal(0); } if (!rs.IsDBNull(1)) { _create_lsn = rs.GetDecimal(1); } if (!rs.IsDBNull(2)) { _data_space_id = rs.GetInt32(2); } if (!rs.IsDBNull(3)) { _database_id = rs.GetInt32(3); } if (!rs.IsDBNull(4)) { _differential_base_guid = rs.GetGuid(4); } if (!rs.IsDBNull(5)) { _differential_base_lsn = rs.GetDecimal(5); } if (!rs.IsDBNull(6)) { _differential_base_time = rs.GetDateTime(6); } if (!rs.IsDBNull(7)) { _drop_lsn = rs.GetDecimal(7); } if (!rs.IsDBNull(8)) { _file_guid = rs.GetGuid(8); } if (!rs.IsDBNull(9)) { _file_id = rs.GetInt32(9); } if (!rs.IsDBNull(10)) { _growth = rs.GetInt32(10); } if (!rs.IsDBNull(11)) { _is_media_read_only = rs.GetBoolean(11); } if (!rs.IsDBNull(12)) { _is_name_reserved = rs.GetBoolean(12); } if (!rs.IsDBNull(13)) { _is_percent_growth = rs.GetBoolean(13); } if (!rs.IsDBNull(14)) { _is_read_only = rs.GetBoolean(14); } if (!rs.IsDBNull(15)) { _is_sparse = rs.GetBoolean(15); } if (!rs.IsDBNull(16)) { _max_size = rs.GetInt32(16); } if (!rs.IsDBNull(17)) { _name = rs.GetString(17); } if (!rs.IsDBNull(18)) { _physical_name = rs.GetString(18); } if (!rs.IsDBNull(19)) { _read_only_lsn = rs.GetDecimal(19); } if (!rs.IsDBNull(20)) { _read_write_lsn = rs.GetDecimal(20); } if (!rs.IsDBNull(21)) { _redo_start_fork_guid = rs.GetGuid(21); } if (!rs.IsDBNull(22)) { _redo_start_lsn = rs.GetDecimal(22); } if (!rs.IsDBNull(23)) { _redo_target_fork_guid = rs.GetGuid(23); } if (!rs.IsDBNull(24)) { _redo_target_lsn = rs.GetDecimal(24); } if (!rs.IsDBNull(25)) { _size = rs.GetInt32(25); } if (!rs.IsDBNull(26)) { _state = (FileState)rs.GetByte(26); } if (!rs.IsDBNull(27)) { _state_desc = rs.GetString(27); } if (!rs.IsDBNull(28)) { _type = (File_Type)rs.GetByte(28); } if (!rs.IsDBNull(29)) { _type_desc = rs.GetString(29); } } catch (Exception) { throw; } }
private static void ReadRevisions(ref RevitSheetData sheetData) { try { ObservableCollection <LinkedRevision> linkedRevisions = new ObservableCollection <LinkedRevision>(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM LinkedRevisions"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { LinkedRevision lRevision = new LinkedRevision(); lRevision.Id = reader.GetGuid(reader.GetOrdinal("LinkedRevision_Id")); lRevision.RevisionId = reader.GetGuid(reader.GetOrdinal("LinkedRevision_Revision_Id")); lRevision.Sequence = reader.GetInt32(reader.GetOrdinal("LinkedRevision_Sequence")); lRevision.Number = reader.GetString(reader.GetOrdinal("LinkedRevision_Number")); lRevision.NumberType = (NumberType)Enum.Parse(typeof(NumberType), reader.GetString(reader.GetOrdinal("LinkedRevision_NumberType"))); Guid projectId = reader.GetGuid(reader.GetOrdinal("LinkedRevision_Project_Id")); var projectFound = from project in sheetData.LinkedProjects where project.Id == projectId select project; if (projectFound.Count() > 0) { LinkedProject project = projectFound.First(); lRevision.LinkProject = project; } lRevision.LinkedElementId = reader.GetString(reader.GetOrdinal("LinkedRevision_Element_Id")); lRevision.IsSource = reader.GetBoolean(reader.GetOrdinal("LinkedRevision_IsSource")); linkedRevisions.Add(lRevision); } } } ObservableCollection <RevisionDocument> revisionDocuments = new ObservableCollection <RevisionDocument>(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM RevisionDocuments"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { RevisionDocument document = new RevisionDocument(); document.Id = reader.GetGuid(reader.GetOrdinal("Document_Id")); document.Title = reader.GetString(reader.GetOrdinal("Document_Title")); document.Path = reader.GetString(reader.GetOrdinal("Document_Path")); if (reader["Document_Contents"] != System.DBNull.Value) { document.Contents = (byte[])reader["Document_Contents"]; } revisionDocuments.Add(document); } } } sheetData.Revisions.Clear(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM Revisions"; using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { RevitRevision revision = new RevitRevision(); revision.Id = reader.GetGuid(reader.GetOrdinal("Revision_Id")); revision.Description = reader.GetString(reader.GetOrdinal("Revision_Description")); revision.IssuedBy = reader.GetString(reader.GetOrdinal("Revision_IssuedBy")); revision.IssuedTo = reader.GetString(reader.GetOrdinal("Revision_IssuedTo")); revision.Date = reader.GetString(reader.GetOrdinal("Revision_Date")); Guid documentId = reader.GetGuid(reader.GetOrdinal("Revision_Document_Id")); var documentFound = from document in revisionDocuments where document.Id == documentId select document; if (documentFound.Count() > 0) { revision.Document = documentFound.First(); } var linkedRevisionFound = from link in linkedRevisions where link.RevisionId == revision.Id select link; if (linkedRevisionFound.Count() > 0) { revision.LinkedRevisions = new ObservableCollection <LinkedRevision>(linkedRevisionFound.ToList()); } sheetData.Revisions.Add(revision); } } } } catch (Exception ex) { string message = ex.Message; } }