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