Add Additional functionality to existing website to process orders
$250-750 USD
Pagado a la entrega
User
• On [login to view URL] and /create if user puts in Company link, the details are recorded to tbl_CompanyCash. I want to associate a randomly assigned Campaign ID (tbl_CompanyCampaign) to an email address on a 24hr basis. Example. email address for test user at email. Dot comwill get CampaignID 5337412356 until 11:59:59 PM for Oct 29th (Pacific Time). On 12AM Oct 30th Pacific, if a suer puts in their email in a new Company link, he will get new, randomized Campaign ID.
• Although the campaign assigned is randomized per day, the same campaign ID should never be selected twice in one day.
• The campaign ID assigned to user will be written to CompanyRefCode in tbl_CompanyCash per link generated.
Reports
• You will process Excel file similar to the one attached, and write to tbl_CompanyEarnings. You must ensure there are no duplicate records when writing to the database as I may download the report with the same day more than once. Example. If were to upload the excel file twice, I should expect only 21 rows created (not 42).
• I also want to be able to export a report that let's me choose a date and it exports the following in to an excel file. Every record from tbl_CompanyCash where Date = "Date Selected" and Every record from tbl_CompanyEarnings where Date = "Date Selected" See attached "[login to view URL]" for a similar report I have for Company3.
I also need to be able to update the Excel file, upload, and update tbl_CompanyCash table. The items I need to update specifically are Paid,PaidReason,PaidDate,PaidReasonID. Look at the code at [login to view URL] for code that updates for Company3 paid out items. (see [login to view URL]) for what the upload file will be like. Your code will look for ID field on Excel file, then update values accordingly.
Nº del proyecto: #5077520
Sobre el proyecto
Adjudicado a:
8 freelancers están ofertando un promedio de $511 por este trabajo
Hi, How are you? User part is fine. I need to understand the report part, can you send the excel file, I don't see any file attached here. Regards Arshad
I'm interested..................................................................................................
Very Flexible to working hours and very comfortable to work in MVC,ASP,C# will do my best to complete the assigned work in time Thanks, GnyanaP