public static void GenerateUpdateCommand(SqlCommand c, ItemTemplate e)
{
c.CommandText = @"UPDATE [ItemTemplate] SET [Id] = @Id, [Name] = @Name, [Description] = @Description, [Type] = @Type, [EquipType] = @EquipType, [WeaponType] = @WeaponType, [Limit] = @Limit, [Fixed] = @Fixed, [NotDroppable] = @NotDroppable, [DestroyOnDeath] = @DestroyOnDeath, [NotRobable] = @NotRobable, [Cost] = @Cost, [Level] = @Level, [Stats] = @Stats, [Requirements] = @Requirements, [Attributes] = @Attributes WHERE [Id] = @Id";
AddSqlParameters(c, e);
}
public static void GenerateInsertCommand(SqlCommand c, ItemTemplate e)
{
c.CommandText = @"INSERT INTO [ItemTemplate]([Id], [Name], [Description], [Type], [EquipType], [WeaponType], [Limit], [Fixed], [NotDroppable], [DestroyOnDeath], [NotRobable], [Cost], [Level], [Stats], [Requirements], [Attributes])
VALUES (@Id, @Name, @Description, @Type, @EquipType, @WeaponType, @Limit, @Fixed, @NotDroppable, @DestroyOnDeath, @NotRobable, @Cost, @Level, @Stats, @Requirements, @Attributes)";
AddSqlParameters(c, e);
}
