private void Pre_2_4_0() { if (this.DataAccess.ExecuteSelect("pragma table_info(IWads);").Tables[0].Select("name = 'GameFileID'").Count <DataRow>() == 0) { this.DataAccess.ExecuteNonQuery("alter table IWads add column 'GameFileID' int;"); IEnumerable <IGameFileDataSource> gameFiles = this.m_adapter.GetGameFiles(); using (IEnumerator <IIWadDataSource> enumerator = this.m_adapter.GetIWads().GetEnumerator()) { while (enumerator.MoveNext()) { IIWadDataSource iwad = enumerator.Current; IGameFileDataSource source = (from x in gameFiles where x.FileName.ToLower() == iwad.FileName.ToLower().Replace(".wad", ".zip") select x).FirstOrDefault <IGameFileDataSource>(); if (source != null) { iwad.GameFileID = source.GameFileID; this.m_adapter.UpdateIWad(iwad); } } } } if (this.DataAccess.ExecuteSelect("pragma table_info(SourcePorts);").Tables[0].Select("name = 'SettingsFiles'").Count <DataRow>() == 0) { this.DataAccess.ExecuteNonQuery("alter table SourcePorts add column 'SettingsFiles' TEXT;"); } this.DataAccess.ExecuteNonQuery("update GameFiles set MapCount = null where Map is null or length(Map) = 0"); }
public void InsertIWad(IIWadDataSource ds) { List <DbParameter> list; string[] exclude = new string[] { "IWadID" }; string sql = this.InsertStatement("IWads", ds, exclude, out list); this.DataAccess.ExecuteNonQuery(sql, list); }
private IGameFileDataSource GetSelectedIWad() { IIWadDataSource selectedItem = this.cmbIwad.SelectedItem as IIWadDataSource; if (selectedItem != null) { GameFileGetOptions options = new GameFileGetOptions(new GameFileSearchField(GameFileFieldType.GameFileID, selectedItem.GameFileID.ToString())); return(this.DataSourceAdapter.GetGameFiles(options).FirstOrDefault <IGameFileDataSource>()); } return(null); }
public void UpdateIWad(IIWadDataSource ds) { string sql = string.Format("update IWads set FileName = @FileName, Name = @Name, GameFileID = @GameFileID where IWadID = @IWadID", new object[0]); List <DbParameter> parameters = new List <DbParameter> { this.DataAccess.DbAdapter.CreateParameter("IWadID", ds.IWadID), this.DataAccess.DbAdapter.CreateParameter("FileName", ds.FileName), this.DataAccess.DbAdapter.CreateParameter("Name", ds.Name), this.DataAccess.DbAdapter.CreateParameter("GameFileID", ds.GameFileID.HasValue ? ((object)ds.GameFileID) : ((object)DBNull.Value)) }; this.DataAccess.ExecuteNonQuery(sql, parameters); }
private int?GetIWad(string iwad) { iwad = iwad.ToLower(); IIWadDataSource source = (from item in this.m_iwads where item.FileName.ToLower().Contains(iwad) select item).FirstOrDefault <IIWadDataSource>(); if (source == null) { this.m_errors.Add($"Could not find IWAD - {iwad}"); } if (source != null) { return(new int?(source.IWadID)); } return(null); }
public void DeleteIWad(IIWadDataSource ds) { throw new NotImplementedException(); }
public void InsertIWad(IIWadDataSource ds) { throw new NotImplementedException(); }
public void DeleteIWad(IIWadDataSource ds) { this.DataAccess.ExecuteNonQuery($"delete from IWads where IWadID = {ds.IWadID}"); }
public void DeleteIWad(IIWadDataSource ds) { throw new NotSupportedException(); }
public void InsertIWad(IIWadDataSource ds) { throw new NotSupportedException(); }
public override bool Equals(object obj) { IIWadDataSource source = obj as IIWadDataSource; return((source != null) && (source.FileName == this.FileName)); }