windows service,file wather,msmq

nicemanish
nicemanish used Ask the Experts™
on
Requirement,

Client will put the file in shared folder for order creation,the file will be as xml file which contains
multiple order(100 + order).everyday we will get the multiple files for order.

we have to read the xml file ,fetch the order and according to order send mail to user.
i am trying to do it with windows service,to read the xml file and send mail to user.

issue :1. like in middle file reading and sending mail,if error comes than
 how we could know that how many successful record we have send via mail?suppose that
 i am having 100 records in 1 order file after reading 50 record errro comes
then could we know that from which record we need to send email to user(how do i excecute file again).

2.after completion of successful read moved that file to Archive folder.I am ok with that i can do it.

some solution which i know as below.
1.take one database,insert data to it from flat file than process record from database with some successful flag,but client is not providing
a database.
2.some one told that use file watcher and msmq,i dont know how to use both things in windows service to implement it.i have not worked on msmq.


overall requirement

xmlfile---->read data from windows service will execute in 5 min ----send mail to user

problem: if error comes in middle of that how we take the latest record from xml file?

could you please provide the better approaches for this requirement?code/Article ?it will help to
to make some small poc before execution
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Technical Architect
Commented:
Once the file watcher tries, open the xml file and start reading one order at a time and try to process it. If it is success send a success mail or failure email and continue reading the order. Why you need msmq or db for this ?

Author

Commented:
good

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial