public static void UpdateOutfit(Outfit outfit) { DBOutfit dbOutfit = new DBOutfit(outfit); using (SQLiteConnection connection = new SQLiteConnection()) { connection.ConnectionString = LoadConnectionString(); connection.Open(); using (SQLiteCommand command = new SQLiteCommand(connection)) { command.CommandText = "update Outfit set TitleName = :titleName, TitleImage = :titleImage, Head = :head, Chest = :chest, Pants = :pants, Necklace = :necklace, Earrings = :earrings, Rings = :rings, Earrings = :earrings, Shoes = :shoes, Earrings = :earrings, Wrist = :wrist where Id=:id"; command.Parameters.Add("titleName", DbType.String).Value = dbOutfit.TitleName; command.Parameters.Add("titleImage", DbType.Binary).Value = dbOutfit.TitleImage; command.Parameters.Add("head", DbType.Binary).Value = dbOutfit.Head; command.Parameters.Add("chest", DbType.Binary).Value = dbOutfit.Chest; command.Parameters.Add("pants", DbType.Binary).Value = dbOutfit.Pants; command.Parameters.Add("necklace", DbType.Binary).Value = dbOutfit.Necklace; command.Parameters.Add("earrings", DbType.Binary).Value = dbOutfit.Earrings; command.Parameters.Add("rings", DbType.Binary).Value = dbOutfit.Rings; command.Parameters.Add("shoes", DbType.Binary).Value = dbOutfit.Shoes; command.Parameters.Add("wrist", DbType.Binary).Value = dbOutfit.Wrist; command.Parameters.Add("id", DbType.Int32).Value = dbOutfit.Id; command.ExecuteNonQuery(); } connection.Close(); } }
public static int SaveOutfit(Outfit outfit) { Int64 rowID = 0; DBOutfit dbOutfit = new DBOutfit(outfit); using (SQLiteConnection connection = new SQLiteConnection()) { connection.ConnectionString = LoadConnectionString(); connection.Open(); using (SQLiteCommand command = new SQLiteCommand(connection)) { command.CommandText = "insert into Outfit(TitleName, TitleImage, Chest, Pants, Necklace, Earrings, Rings, Shoes, Head, Wrist) values(@TitleName, @TitleImage, @Chest, @Pants, @Necklace, @Earrings, @Rings, @Shoes, @Head, @Wrist)"; command.Parameters.Add("titleName", DbType.String).Value = dbOutfit.TitleName; command.Parameters.Add("titleImage", DbType.Binary).Value = dbOutfit.TitleImage; command.Parameters.Add("head", DbType.Binary).Value = dbOutfit.Head; command.Parameters.Add("chest", DbType.Binary).Value = dbOutfit.Chest; command.Parameters.Add("pants", DbType.Binary).Value = dbOutfit.Pants; command.Parameters.Add("necklace", DbType.Binary).Value = dbOutfit.Necklace; command.Parameters.Add("earrings", DbType.Binary).Value = dbOutfit.Earrings; command.Parameters.Add("rings", DbType.Binary).Value = dbOutfit.Rings; command.Parameters.Add("shoes", DbType.Binary).Value = dbOutfit.Shoes; command.Parameters.Add("wrist", DbType.Binary).Value = dbOutfit.Wrist; command.ExecuteNonQuery(); command.CommandText = "select last_insert_rowid()"; rowID = (Int64)command.ExecuteScalar(); } connection.Close(); } return((int)rowID); }