Export product data from the database to an excel file Synchronize data between the local database and the database that will be uploaded to the hosting
Budget: $750 – $1,500 USD
the first requirement
Restore the backup from this link
https://drive.google.com/file/d/12Mm9JcUTAVqy3-_D47RIAukUr0TYiMOT/view?usp=sharing
And it is restored using MS Sql management studio
And then a system is created that exports the data in the database to an Excel file in a specific format, and all the data in it is exported to 2 Excel files in a specific format
the first
A products Name
F products Number
L unit price
N barcode Number
P box price
Q Number of unit in box
the second excel file is in this format
A expired date
B product number
C barcode
D number of unit in store
E cost of the unit
F number of box in store
G cost of the box
J products name
the following technologies are used
1. C#
2. layered pattern
3.Entity framework core
4.asynchronous programming
5.unit of work and repository pattern
6.MVVM Design pattern
7. WPF
the second requirement
this is also for 2 databases for other systems, in the same manner as for the first requirement
the third requirement
https://drive.google.com/file/d/1-twFp7tC6vz4pao8CpRgCLHAWJuTnSaT/view?usp=sharing
A backup is for a system that was created using technologies
1. C#
2. layered pattern
3.Entity framework core
4.asynchronous programming
5.unit of work and repository pattern
6.MVVM Design pattern
7. WPF
It is required to link the local database with the database that will be uploaded to the hosting and they will be linked through A P I and the new data will be synchronized from the local database to the database on the hosting
And in order to be able to know the tables that have been changed and need to be synchronized, this is done by creating addition tables (that is, a copy of all the tables and the comparison is done constantly between the main table and the copy of it. If it is 1 (meaning a difference between the table and the other) then it is Automatically sync to hosting
If there is no difference between the two schedules, it is not necessary to synchronize it
And automatically if new tables are found, they are also created in the database in the hosting
It is required that the settings for linking the local database and the database on the hosting be in simple steps
Restore the backup from this link
https://drive.google.com/file/d/12Mm9JcUTAVqy3-_D47RIAukUr0TYiMOT/view?usp=sharing
And it is restored using MS Sql management studio
And then a system is created that exports the data in the database to an Excel file in a specific format, and all the data in it is exported to 2 Excel files in a specific format
the first
A products Name
F products Number
L unit price
N barcode Number
P box price
Q Number of unit in box
the second excel file is in this format
A expired date
B product number
C barcode
D number of unit in store
E cost of the unit
F number of box in store
G cost of the box
J products name
the following technologies are used
1. C#
2. layered pattern
3.Entity framework core
4.asynchronous programming
5.unit of work and repository pattern
6.MVVM Design pattern
7. WPF
the second requirement
this is also for 2 databases for other systems, in the same manner as for the first requirement
the third requirement
https://drive.google.com/file/d/1-twFp7tC6vz4pao8CpRgCLHAWJuTnSaT/view?usp=sharing
A backup is for a system that was created using technologies
1. C#
2. layered pattern
3.Entity framework core
4.asynchronous programming
5.unit of work and repository pattern
6.MVVM Design pattern
7. WPF
It is required to link the local database with the database that will be uploaded to the hosting and they will be linked through A P I and the new data will be synchronized from the local database to the database on the hosting
And in order to be able to know the tables that have been changed and need to be synchronized, this is done by creating addition tables (that is, a copy of all the tables and the comparison is done constantly between the main table and the copy of it. If it is 1 (meaning a difference between the table and the other) then it is Automatically sync to hosting
If there is no difference between the two schedules, it is not necessary to synchronize it
And automatically if new tables are found, they are also created in the database in the hosting
It is required that the settings for linking the local database and the database on the hosting be in simple steps