public void DBWrite()
{
Program.db.Begin();
RvFileWrite();
RvRomFileMatchup.MatchFiletoRoms(this);
Program.db.Commit();
}
public void DBWrite()
{
DBSqlite.db.Begin();
RvFileWrite();
RvRomFileMatchup.MatchFiletoRoms(this);
DBSqlite.db.Commit();
}
public void DBWrite()
{
if (_commandRvRomWrite == null)
{
_commandRvRomWrite = new SQLiteCommand(@"
INSERT INTO ROM ( GameId, name, type, size, crc, sha1, md5, merge, status, putinzip, FileId)
VALUES (@GameId,@Name,@Type,@Size,@CRC,@SHA1,@MD5,@Merge,@Status,@PutInZip,@FileId);
SELECT last_insert_rowid();", Program.db.Connection);
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("GameId"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("Name"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("Type"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("Size"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("CRC"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("SHA1"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("MD5"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("Merge"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("Status"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("PutInZip"));
_commandRvRomWrite.Parameters.Add(new SQLiteParameter("FileId"));
}
FileId = DatUpdate.NoFilesInDb ? null : RvRomFileMatchup.FindAFile(this);
_commandRvRomWrite.Parameters["GameId"].Value = GameId;
_commandRvRomWrite.Parameters["name"].Value = Name;
_commandRvRomWrite.Parameters["type"].Value = (int)AltType;
_commandRvRomWrite.Parameters["size"].Value = Size;
_commandRvRomWrite.Parameters["crc"].Value = VarFix.ToDBString(CRC);
_commandRvRomWrite.Parameters["sha1"].Value = VarFix.ToDBString(SHA1);
_commandRvRomWrite.Parameters["md5"].Value = VarFix.ToDBString(MD5);
_commandRvRomWrite.Parameters["merge"].Value = Merge;
_commandRvRomWrite.Parameters["status"].Value = Status;
_commandRvRomWrite.Parameters["putinzip"].Value = PutInZip;
_commandRvRomWrite.Parameters["FileID"].Value = FileId;
_commandRvRomWrite.ExecuteNonQuery();
}
