Find Jobs
Hire Freelancers

Changes to an Intranet ASP website(repost)

$30-5000 USD

已取消
已发布超过 12 年前

$30-5000 USD

货到付款
Hello, I have an intranet site that connects to an MS SQL database. The database contains names of patients with email and surgery dates. This website generates letters in pdf based on the surgery date and also emails if email is available. there are four types of patients. Case 1- Surgery date within the last five years with email Case 2- Surgery date over five years with email Case 3- Surgery date within the last five years without email Case 4- Surgery date over five years without email The current system works, however the generate document options are too many and very confusing. This new scheme will do all that needs to be done in one click. ## Deliverables Hello, I have an intranet site that connects to an MS SQL database. The database contains names of patients with email and surgery dates. This website generates letters in pdf based on the surgery date and also emails if email is available. there are four types of patients. Case 1- Surgery date within the last five years with email Case 2- Surgery date over five years with email Case 3- Surgery date within the last five years without email Case 4- Surgery date over five years without email The current system works, however the generate document options are too many and very confusing. This new scheme will do all that needs to be done in one click. I want the generate document button to only have one option that will do the following: Case 1: Patient is marked active and has an email address on file: a. And is under 5 years old: b. Create the pdf using the regular template, add _Emailed to the filename and save it to C:\DATA\13_Monthly_Lab_Letters. For example [login to view URL] c. Email the pdf to the patient d. Leave the patient active Case 2: Patient is marked active and has an email address on file: a. And is under 5 years old: b. Create the pdf using the Last template, add _Emailed and _Last to the filename and save it to C:\DATA\13_Monthly_Lab_Letters. For example [login to view URL] c. Email the pdf to the patient d. Mark the patient inactive Case 3: If it is marked active and does not have an email address on file: a. And is under 5 years old: b. Create the pdf using the regular template, add _Mailed to the filename and save it to C:\DATA\13_Monthly_Lab_Letters. For example [login to view URL] c. Leave the patient active Case 4: If it is marked active and does not have an email address on file: a. And is over 5 years old: b. Create the pdf using the Last template, add _Emailed and _Last to the filename and save it to C:\DATA\13_Monthly_Lab_Letters. For example [login to view URL] c. Mark the patient inactive One other issue is that the documents are not being emails. It used to work. All the code is there, and it needs to be rearranged I guess. All the variables are stored in the [login to view URL] file: <appSettings> <add key="DocPath" value="C:\DATA\13_Monthly_Lab_Letters"/> <add key="TemplatePath" value="C:\DATA\Intranet\Annual_Lab\templates"/> <add key="TemplateVDir" value="~/Templates"/> <add key="EmailServer" value="server1"/> <add key="SenderEmailAddress" value="1@[login to view URL]> <add key="SenderDisplayName" value="John Doe"/> <add key="LogPath" value="c:\"/> <add key ="LastAge" value="5"/> <add key="MainTemplate" value="[login to view URL]"/> <add key="LastTemplate" value="[login to view URL]"/> </appSettings> <connectionStrings> <add name="AKMDConnectionString" connectionString="Data Source=server1\sqlexpress;Initial Catalog=AKMD;Persist Security Info=True;user=sa; password=12345" providerName="[login to view URL]"/> </connectionStrings> Thank You.
项目 ID: 3477353

关于此项目

远程项目
活跃13 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作

关于客户

UNITED STATES的国旗
Glendale, United States
5.0
64
付款方式已验证
会员自5月 12, 2003起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。