I use Linnworks as our order management software. At the moment no payment method is specified for Amazon and Amazon FBA orders. I can fix this by creating a small piece of C# code which is triggered every 10 minutes. I have some part of the code:
if(([url removed, login to view] =="AMAZON") || ([url removed, login to view] =="AMAZON FBA"))
string query = @" UPDATE [Order]
SET fkBankId = '979A5002-2D4C-48F4-93A2-F480FA188B1A
WHERE [Order].Source = 'AMAZON' OR [Order].Source = 'AMAZON FBA' ";
SqlCommand cmd = new SqlCommand(query, conn);
String Title = [url removed, login to view]().ToString();
but to finish it off they want to charge me a fortune!
I have a full support ticket history on this with other tips that will be sent to the winner. I would prefer you to write the code without access to Linnworks and I can test it, but if not I can give you access.
I need this done ASAP (within a few hours).
15 freelancers are bidding on average $144 for this job
I am actively working for over 2 years with C# and databases, have lots of projects done on .NET 2.0, 2.5 and 4. This can be done few hours after you accept the bid.
Hi. I have experience in both SQL and C#, mostly developing my own projects. I'm a bit uncertain about what exactly you want done. Are you just looking for a trigger because i've already got it?