System modulation

4

I'm developing a C # system with WinForms of Livestock Control for a farm, and will communicate with a scale to improve the weighing process.

Some of the features are (Invoice entry, vaccination, casualties, transfers, purchases, stock).

I have some doubts regarding the structure, because in the farms does not have internet. And the manager will be able to access the data through the office. So I do not know how to do it, because I would have a local system and a web system?

I figured I could have a separate module to do the weighing, using a local bank (SQL CE, SQLite), as I believe it is not worth installing a SQLServer database on the "pawn" machine, and then going synchronize in cloud with the management system, after getting connection to internet.

And functionality regarding purchases, downgrades, etc ... Would you stick with this offline module?

My thinking is correct, and which database should I use for each situation?

    
asked by anonymous 26.10.2016 / 16:09

2 answers

4

It is very complicated a system that works in isolation and at the same time needs to be integrated. It is not easy to make this work properly and only with very detailed information would you give to inform something. Even though I think the question would be considered too broad, it would be practically a complete consultancy.

This would be a case of extreme ease because you would have disconnected systems doing concurrent operations.

26.10.2016 / 18:05
1

A question about the business itself. Is the balance integrated into your system, or is the weighing release manual?

If the balance is integrated, I would strongly recommend the use of the internet, although by satellite, as suggested in another answer.

If the balance is not integrated, I believe you could think of a mobile strategy, using a cell phone, or tablet with Sqlite database that communicates with a WebApi. The other features of the system I would recommend doing with Web, because it would serve a possible headquarters of the farm, with internet, and could also be at the disposal of the owner in any location.

    
27.10.2016 / 14:50