Completed

Create email notification in C#.net

We have a script which runs each day to send out notifications and we want to add a new email to this. This will be a fairly complicated notification, the email will be sent out only on specific days depending on user settings and will need to include attachments based on user settings.

Details:

- use /emailalerts.cshtml. This is where our other notifications currently are.

- Your script should start by cycling through all of the available loans (these are in the database table 'loans'). Use loans where:

Status = 1 AND Deleted = 0

- The email is sent to the Originator assigned to the loan. In the database loans > OriginatorId (UserId in table UserProfile). If this is 0 or null no email is sent

- The email is sent out only on specific days based on the loan settings. Settings are in the database table 'loans'. The fields are AlertOptOut, AlertMon, AlertTues, AlertWed, AlertThurs, AlertFri. If a field = 1 send the email. If it= 0 don't send. If AlertOptOut = 1 then no emails should be sent for any days.

ie. If a AlertMon = 1 and AlertThurs = 1, then the emails are sent on Mondays and Thursdays.

- Sometimes a loan will not be setup yet and the fields will be null. If the fields are null check the table 'UserProfile' for the same settings. To know which user to check use the loanID to check for the assigned Originator. SQL for that is:

SELECT * FROM UserProfile WHERE UserId = @0", [url removed, login to view]

- The email subject should be: Your ALEX Notification for {LoanName}

- The body of the email is:

This email contains the outstanding documents for:

Loan Name: {LoanName}

Loan Number: {LoanNumber}

Loan Percent Completion: {[url removed, login to view](loanid_int_percent);}

Brokers/Borrowers: {list of borrowers assigned to this loan}

SQL is like: select [url removed, login to view], [url removed, login to view], [url removed, login to view] from loan_user_access lua inner join UserProfile u on [url removed, login to view] = [url removed, login to view] where [url removed, login to view] = @0

{Borrower Name #1 : Borrower Email #1}

{Borrower Name #2 : Borrower Email #2}

{etc.}

Outstanding Documents: {table of all outstanding documents, these are in the table 'documents' WHERE doc_deleted = 0 AND doc_active = 1 AND doc_approval != 'Approved' AND doc_type != 'Screening' AND doc_type != 'Legal' AND doc_type != 'Loan App'}

{Doc #1 Name} {Doc #1 Borrower Name(doc_userid field in db)} {Doc #1 Status} {Doc #1 Rejection Reason (doc_rejection)}

{Doc #2 Name} {Doc #2 Borrower Name(doc_userid field in db)} {Doc #2 Status} {Doc #2 Rejection Reason (doc_rejection)}

{etc.}

{Sort the table my Borrower name, then doc_type}

- There is another setting in the database called 'AlertExcludePDF' if this = 0 then the email will need to have attachments. For any outstanding documents we want to attached a blank PDF form. These are in the table documents > doc_pdf_download

- Most documents don't have a PDF and won't need the attachment.

- The attachments should be renamed to include the name of the borrower + the document name, ie. {borrower name}+{doc_name}.pdf. Some document names may have illegal characters like spaces or backslashes. Replace any illegal characters with underscore (_) before attaching.

- There should be one other attachment called {LoanName}-Summary.pdf. This will be a generated PDF which shows all of the outstanding documents (same as the table in the body of the email). There is a very similar script which you can use to build this PDF at /administrator/tasks/convertpdf-report.cshtml. That report is almost the same, except it only includes 1 borrower, the new script will need to include all borrowers assigned to the loan. This generated PDF should be deleted from the server after the email is sent, we don't want a folder full of unused PDF files.

There is already an email alert very similar to this one already build in /emailalerts.cshtml. You can reuse a lot of code from that.

Please let me know if you have any questions.

Kemahiran: .NET, ASP, Pengaturcaraan C#, jQuery / Prototaip

Lihat lagi: t sql programming, sql pdf files, programming tasks in c++, html, asp.net, pdf, programming questions in c#.net, programming lua, programming in lua pdf, programming in lua, programming in c pdf, net programming questions, lua programming pdf, alex don, limesurvey email create user, curl email create account, email create software, email create account, html email create unsubscribe link, mysql email create

Tentang Majikan:
( 366 ulasan ) Columbus, United States

ID Projek: #10097849

Dianugerahkan kepada:

sureshdevi

I can create this new email notification in C#.net with attachments. I will complete this work in 3 days. Looking for your reply to start this work immediately.

$106 USD dalam 3 hari
(122 Ulasan)
6.4

12 pekerja bebas membida secara purata $168 untuk pekerjaan ini

akhila27

Hello, Before you select a part time developer from here, take a look at fugacode.com. If you like what you see, contact us. That's all. "Why hire freelancers? when you can hire professional developers for the sa Lagi

$147 USD dalam 3 hari
(14 Ulasan)
6.2
AwaisChaudhry

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I would call myself a master of what I do, I do work smart and do not rest until I get the job done. Please feel free to pin Lagi

$123 USD dalam 3 hari
(14 Ulasan)
5.4
GhaziOualha

A proposal has not yet been provided

$111 USD dalam 3 hari
(16 Ulasan)
5.2
weonlydo

Hello, my name is Richard and I am from New Zealand. It's April Fools already here, but this is not a joke bid! I will most likely duplicate the [login to view URL] module and modify it to suit the new alert. I have 17 Lagi

$263 USD dalam 5 hari
(24 Ulasan)
4.9
mrkrunaldoshi

A proposal has not yet been provided

$250 USD dalam 5 hari
(13 Ulasan)
5.0
huypq5

As description in your requirement. I'm sure to complete this tool for you. inbox me if you have any question about my skill or this project. Thank for your attention HuyPQ.

$100 USD dalam 5 hari
(17 Ulasan)
4.2
adicoman

Hi , l am very intrested to work on your project. I have more than 11 years of experience in Web Development with arround 1000 projects finished with success Please send me all details for this project to agree an fin Lagi

$358 USD dalam 10 hari
(6 Ulasan)
3.5
johnosullivan

hey - I've a lot of experience with this type of work. I've been in the industry for 15+ years and I'm Microsoft certified - you have given detailed requirements in the spec and I understand what you need . I can turn Lagi

$250 USD dalam 3 hari
(6 Ulasan)
3.3
$222 USD dalam 3 hari
(1 Ulasan)
2.6
mahmoudgamal008

A .NET Developer and database freak at heart. I'm interested mostly in .NET, database (design and SQL). I'm an MCPD .NET 3.5 Windows Developer, MCTS SQL Server. I have more than 4 years of professional and practical ex Lagi

$100 USD dalam 5 hari
(3 Ulasan)
2.7
urjasoft

Hi I am Subodh Kant from urjasoft team. I am working as .net Developer for an MNC from past 3 years. Recently I joined with UrjaSoft Team so that we can start our own business. As per the project info I underst Lagi

$100 USD dalam 5 hari
(0 Ulasan)
0.0
aghajanyanhovik

Hi, its easy , I can do it in 3 days

$100 USD dalam 3 hari
(0 Ulasan)
0.0
shubhajagtap88

I have experience in writing code to send email. I have written code to sent the email on specific days and on specific times.

$155 USD dalam 3 hari
(0 Ulasan)
0.0