Implement Upload Functionality
- Durum: Closed
- Ödül: $85
- Alınan Girdiler: 2
- Kazanan: doyz
I am working on a prototype in MVC 5 and I need some work done.
Right now, I am interested in implementing basic upload functionality where my user can upload a csv file to database...
I am looking for some one who is good with MVC - Razor, AJAX, Jquery, Entity Framework, Bootstrap to help me with this work. We will be working on the project in small chunks so that there is no scope creep. If I like your experience and work, we can move to hourly rate if you prefer, but then again, I really need some one who has implemented charts / graphs in MVC....so thats for later talk....
First Functionality I need to implement ---:
I have a table called Departments.
Its table structure is:
DepartmentId is the primary key and CategoryId is the foreign key.
Every time I create a new Customer, it should add a DepartmentCode of 999 and DepartmentName of "No Department" by default. User should not be able to edit this value on the screen. So something like...In CustomerController, HttpPost create action(), you will save the value I said...next, you will edit the corresponding razor view to hide the edit button if the value of the DepartmentCode is 999....
Second, for a customer, on the Department screen, user should be able to upload a text file which has Department Code and Department Name.
During upload, check if Department Code is duplicate. If so, perform only update on the Department Name.
If Department Code does not exist, Create/Insert the new row with the info.
Finally, You will also implement error checking.
- If a row has either Empty/Blank DepartmentCode or DepartmentName - error.
- If the file has more than 2 columns, error.
If the file has either of above issues, and the user tries to upload the file by clicking submit, The error message should say, "There are issues with the file. Confirm that the file is in "csv" format, has only 2 columns, and no blank values.
Thats the requirement.
PM me and I will give you access to the site and then you can give me estimate.
“Great dev. First hired him to develop the initial functionality, now I am working with him for other tasks. Strong command in MVC. If u need MVC work, talk to him atleast. U will not be disappointed!”
bizzcrawl, United States.