Means he used 2014 looks like. I know 2014 is version 12 … 2012 is version 11
I have the same problem here… Cannot restore the file (SQL Server 2012).
You need to upgrade to 2014 or convert it to 2012. It worked fine on 2014 I just tested it.
1 Like
Convert it? How do I do that? Is there a tool for that?
Okie dokie… downloading now!
http://www.microsoft.com/en-us/download/details.aspx?id=42299
Which Package you ask?
- I like the one with everything which is
SQLEXPRADV_x64_ENU(1.1 GB) - At the very least I recommend the one with Tools, (Management Studio) which is
SQLEXPRWT_x64_ENU(833.2 MB) - but you can get away with no tools (still multi-user) which is
SQLEXPR_x64_ENU(196.7 MB) - or the LocalDB install (small, single-user) which is
SqlLocalDB(43.1 MB)
I don’t have a 64 bit system, so I’m downloading SQLEXPR_x86_ENU.exe.
Will this work with SQL Server 2012 Management studio, or will I have to download this separately?
It should work with it yes. It wouldn’t hurt to download a newer version though.
1 Like
I use the advanced one with everything I disabled a lot I did not need but I like having it all available.
1 Like
Alternatively you can install SQL Server Local DB 2014 next to your SQL Server install. Local DB is very handy for testing purposes. After installing set connection string as
Data Source=(localdb)\MSSqlLocalDb; Database=SambaPOSWhatever;
… and it will work. After doing that you can restore backup file to test that setup.
Download links:
2 Likes
I just updated to SQL Server 2014, imported @emre’s database into the instance, then changed the connection string to the new instance and database, and I can’t start SambaPOS anymore. It shows:
[General Info]
Application: SambaPOS
Version: 4.1.73
Region: en
DB: SQ
Machine: RUBEN-PC
User: ruben
Date: 11/3/2014
Time: 1:16 AM
User Explanation:
ruben said “”
[Exception Info 1]
Top-level Exception
Type: System.InvalidOperationException
Message: Cannot serialize a generic type 'System.Collections.Generic.List1[Samba.Domain.Models.Accounts.AccountTransaction]'. Source: PresentationFramework Stack Trace: at System.Windows.Markup.Primitives.MarkupWriter.VerifyTypeIsSerializable(Type type) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item, Scope scope) at System.Windows.Markup.Primitives.MarkupWriter.WriteItem(MarkupObject item) at System.Windows.Markup.Primitives.MarkupWriter.SaveAsXml(XmlWriter writer, MarkupObject item) at System.Windows.Markup.Primitives.MarkupWriter.SaveAsXml(XmlWriter writer, Object instance) at System.Windows.Markup.XamlWriter.Save(Object obj, TextWriter writer) at System.Windows.Markup.XamlWriter.Save(Object obj) at MS.Internal.Ink.ClipboardProcessor.CopySelectionInXAML(IDataObject dataObject, StrokeCollection strokes, List1 elements, Matrix transform, Size size)
at MS.Internal.Ink.ClipboardProcessor.CopySelectedData(IDataObject dataObject)
at System.Windows.Controls.InkCanvas.CopyToDataObject()
at System.Windows.Controls.InkCanvas.PrivateCopySelection()
at System.Windows.Controls.InkCanvas._OnCommandExecuted(Object sender, ExecutedRoutedEventArgs args)
at System.Windows.Input.CommandBinding.OnExecuted(Object sender, ExecutedRoutedEventArgs e)
at System.Windows.Input.CommandManager.ExecuteCommandBinding(Object sender, ExecutedRoutedEventArgs e, CommandBinding commandBinding)
at System.Windows.Input.CommandManager.FindCommandBinding(CommandBindingCollection commandBindings, Object sender, RoutedEventArgs e, ICommand command, Boolean execute)
at System.Windows.Input.CommandManager.FindCommandBinding(Object sender, RoutedEventArgs e, ICommand command, Boolean execute)
at System.Windows.Input.CommandManager.OnExecuted(Object sender, ExecutedRoutedEventArgs e)
at System.Windows.UIElement.OnExecutedThunk(Object sender, ExecutedRoutedEventArgs e)
at System.Windows.Input.ExecutedRoutedEventArgs.InvokeEventHandler(Delegate genericHandler, Object target)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.RoutedCommand.ExecuteImpl(Object parameter, IInputElement target, Boolean userInitiated)
at System.Windows.Input.RoutedCommand.ExecuteCore(Object parameter, IInputElement target, Boolean userInitiated)
at System.Windows.Input.CommandManager.TranslateInput(IInputElement targetElement, InputEventArgs inputEventArgs)
at System.Windows.UIElement.OnKeyDownThunk(Object sender, KeyEventArgs e)
at System.Windows.Input.KeyEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndKeyboardInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawKeyboardActions actions, Int32 scanCode, Boolean isExtendedKey, Boolean isSystemKey, Int32 virtualKey)
at System.Windows.Interop.HwndKeyboardInputProvider.ProcessKeyAction(MSG& msg, Boolean& handled)
at System.Windows.Interop.HwndSource.CriticalTranslateAccelerator(MSG& msg, ModifierKeys modifiers)
at System.Windows.Interop.HwndSource.OnPreprocessMessage(Object param)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
at System.Windows.Threading.Dispatcher.Invoke(DispatcherPriority priority, Delegate method, Object arg)
at System.Windows.Interop.HwndSource.OnPreprocessMessageThunk(MSG& msg, Boolean& handled)
at System.Windows.Interop.HwndSource.WeakEventPreprocessMessage.OnPreprocessMessage(MSG& msg, Boolean& handled)
at System.Windows.Interop.ComponentDispatcherThread.RaiseThreadMessage(MSG& msg)
at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
at System.Windows.Threading.Dispatcher.Run()
at System.Windows.Application.RunDispatcher(Object ignore)
at System.Windows.Application.RunInternal(Window window)
at System.Windows.Application.Run(Window window)
at Samba.Presentation.App.Main()
[Assembly Info]
Samba.Services, Version=1.0.0.0
mscorlib, Version=4.0.0.0
System, Version=4.0.0.0
Microsoft.Practices.Prism, Version=4.0.0.0
WindowsBase, Version=4.0.0.0
Samba.Infrastructure, Version=1.0.0.0
Samba.Infrastructure.Data, Version=1.0.0.0
PresentationFramework, Version=4.0.0.0
System.Xaml, Version=4.0.0.0
Samba.Presentation.Services, Version=1.0.0.0
FluentValidation, Version=3.4.0.0
Samba.Domain, Version=1.0.0.0
DevExpress.Xpf.Grid.v14.1, Version=14.1.6.0
DevExpress.Xpf.Grid.v14.1.Core, Version=14.1.6.0
PresentationCore, Version=4.0.0.0
Stateless, Version=1.0.0.0
System.Core, Version=4.0.0.0
System.Drawing, Version=4.0.0.0
System.Windows.Forms, Version=4.0.0.0
System.ComponentModel.Composition, Version=4.0.0.0
Samba.Localization, Version=1.0.0.0
Microsoft.CSharp, Version=4.0.0.0
Microsoft.Practices.ServiceLocation, Version=1.0.0.0
Samba.Persistance, Version=1.0.0.0
Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0
DevExpress.Xpf.Core.v14.1, Version=14.1.6.0
PropertyTools, Version=2012.4.14.1
[System Info]
Operating System
-Microsoft Windows 7 Ultimate
–CodeSet = 1252
–CSDVersion = Service Pack 1
–CurrentTimeZone = 480
–FreePhysicalMemory = 132248
–OSArchitecture = 32-bit
–OSLanguage = 1033
–ServicePackMajorVersion = 1
–ServicePackMinorVersion = 0
–Version = 6.1.7601
Machine
-RUBEN-PC
–Manufacturer = Gigabyte Technology Co., Ltd.
–Model = M52L-S3P
–TotalPhysicalMemory = 2145968128
–UserName = ruben-PC\ruben
That error means his file was made on a newer version than you have installed. I see your using 4.1.73 try installing 4.1.74 then start it. It looks like its off by just 1 version according to number sequence in the error.
Thanks, got it working now…
That works perfectly @emre! Thanks a lot, I’ll implement it in my setup at once…
I added a tutorial in the original post…
2 Likes
Thanks @pipo and everyone else involved in finding this solution, it has helped me greatly too. I found plenty of questions relating to product specific discounts but was struggling to implement the right solution myself. This question came just at the right time and was extremely helpful, thanks again.
2 Likes
On testing this it seems to incorrectly calculate this for portion sizes.
In the discount calculation [=-1*TN('{PRICE}')*(TN('{ITEM TAG:{ENTITY DATA:Customer:Discount}}')/100)] does {PRICE} take into account the portion price?
Thanks to @emre for putting this together, and thanks to you @pipo for posting the step-by-step.
This is a great implementation that a lot of people will use … so much so, it could almost become part of a default install 
2 Likes
@CD1212 you can update discount when portion changes by handling Order Portion Changed event.
3 Likes
I’ve uploaded 4.1.75 and it should work fine without Hard Refresh Ticket action.
2 Likes
It works perfectly as far as applying and calculating discounts via the Order Tags and Product Tags, but I have issue with the State display of both Ticket and Order in that they are not reverted to Inactive when they should be.
Either I set something wrong, or more checking/setting needs to be done to update the States.
Anybody else noticing this, or is it just me?
I believe this is a result of placing an Order (to a Table), closing Ticket, opening Ticket, selecting Customer Entity (States are changed accordingly), closing Ticket, opening Ticket, click Change Customer, remove Customer from Ticket (click the X). So we need a way to trap the removal of a Customer from the Ticket and update the States to InActive…
EDIT: This additional Rule seems to do the trick…
My Customer Entity uses 1,2,3 rather than D1, D2, D3. You may be able to make the Constraint as:
{ENTITY DATA:Customer:Discount} Is Null
Now it updates Order and Ticket States properly…
1 Like