private bool SiteLevelCustomAuthenticationMethod(string userName, string password, out int doctorId)
{
bool boolReturnValue = false;
doctorId = 0;
using (MyDataClassesDataContext myDb = new MyDataClassesDataContext())
{
var webLoginPass = from w in myDb.Users_Doctors
where 1 == 1 &&
w.UserName == userName &&
w.Password == password &&
w.IsActive == true
select w;
foreach (var d in webLoginPass)
{
doctorId = Convert.ToInt32(d.DoctorId);
}
if (webLoginPass.Count() == 1)
{
boolReturnValue = true;
}
else
{
boolReturnValue = false;
}
}
return boolReturnValue;
}
private void InsertIntoUnitRegister(string ipAddress, string serialNumber,
string name, string emailAddress, string phoneNumber, out string errorMessage)
{
errorMessage = string.Empty;
using (MyDataClassesDataContext myDb = new MyDataClassesDataContext())
{
UnitRegister n = new UnitRegister();
n.IPAddress = ipAddress;
n.SerialNumber = serialNumber;
n.Name = name;
n.EmailAddress = emailAddress;
n.PhoneNumber = phoneNumber;
try
{
myDb.UnitRegisters.InsertOnSubmit(n);
myDb.SubmitChanges();
}
catch (Exception ex)
{
errorMessage = String.Format("Exception caught in SendEmail(): {0}",
ex.ToString());
}
}
}
private string LoadDocusignForm()
{
String docuSignUrl = string.Empty;
using (MyDataClassesDataContext myDb = new MyDataClassesDataContext())
{
// query
var docData = from d in myDb.Users_Doctors
where d.DoctorId == Convert.ToInt32(this.Session["DoctorId"])
select d;
// return data
foreach (var d in docData)
{
docuSignUrl = string.Format("https://na2.docusign.net/Member/PowerFormSigning.aspx?PowerFormId={0}", docuSignPowerformId);
docuSignUrl += string.Format("&Doctor_UserName={0}", d.DoctorName);
docuSignUrl += string.Format("&Doctor_Email={0}", d.EmailAddress);
docuSignUrl += string.Format("&PhysicianName={0}", d.DoctorName);
docuSignUrl += string.Format("&PhysicianNPI={0}", d.NPINumber);
docuSignUrl += string.Format("&PhysicianAddress1={0}", d.Address1);
docuSignUrl += string.Format("&PhysicianAddress2={0}", d.Address2);
docuSignUrl += string.Format("&PhysicianCity={0}", d.City);
docuSignUrl += string.Format("&PhysicianState={0}", d.State);
docuSignUrl += string.Format("&PhysicianZipCode={0}", d.ZipCode);
docuSignUrl += string.Format("&PhysicianPhone={0}", d.PhoneNumber);
}
}
return docuSignUrl;
}
private void InsertLogFile(int loginId, string ipAddress, string type, string log)
{
using (MyDataClassesDataContext myDb = new MyDataClassesDataContext())
{
LogFile newLog = new LogFile();
newLog.UserId = loginId;
newLog.IPAddress = ipAddress;
newLog.Type = type;
newLog.Log = log;
newLog.DateTime = DateTime.Now.AddHours(-4);
myDb.LogFiles.InsertOnSubmit(newLog);
myDb.SubmitChanges();
}
}
protected void RemoveEmailAddress_Click(object sender, EventArgs e)
{
// remove email address
// add to RemoveEmailAddress Database
using (MyDataClassesDataContext myDb = new MyDataClassesDataContext())
{
EmailAddressOptOut optOut = new EmailAddressOptOut();
optOut.EmailAddress = this.EmailAddressLabel.Text;
myDb.EmailAddressOptOuts.InsertOnSubmit(optOut);
myDb.SubmitChanges();
}
// on success, goto Thank You Page
Response.Redirect("/EmailOptOutThankYou.aspx");
}
private string Return_DoctorsName()
{
int loginDoctorId = Convert.ToInt32(this.Session["DoctorId"]);
using (MyDataClassesDataContext myDB = new MyDataClassesDataContext())
{
var name = (from d in myDB.Users_Doctors
where d.DoctorId == loginDoctorId
select d.DoctorName).First();
if (name.ToString() != null)
{
return name.ToString();
}
else
{
return "";
}
}
}
private string Return_DoctorsEMailAddress()
{
int loginDoctorId = Convert.ToInt32(this.Session["DoctorId"]);
using (MyDataClassesDataContext myDB = new MyDataClassesDataContext())
{
var emailAddress = (from d in myDB.Users_Doctors
where d.DoctorId == loginDoctorId
select d.EmailAddress).First();
if (emailAddress.ToString() != null)
{
return emailAddress.ToString();
}
else
{
return "";
}
}
}
// send email
private void SendEmail()
{
String mailFromDisplay = string.Empty;
String mailFrom = string.Empty;
String userName = string.Empty;
String password = string.Empty;
String smtp = string.Empty;
int smtpPort = 0;
bool enableSsl = false;
using (MyDataClassesDataContext myDb = new MyDataClassesDataContext())
{
var emailInfo = from ei in myDb.EmailSettings
select ei;
foreach (var data in emailInfo)
{
mailFromDisplay = "Website - Contact Us";
mailFrom = data.EmailAddress;
userName = data.UserName;
password = data.Password;
smtp = data.SMTP;
smtpPort = Convert.ToInt32(data.SMTP_Port);
enableSsl = Convert.ToBoolean(data.EnableSSL);
}
}
MailMessage mail = new MailMessage();
SmtpClient smtpServer = new SmtpClient(smtp);
mail.From = new MailAddress(mailFrom, mailFromDisplay);
// authenticate
smtpServer.Port = smtpPort;
smtpServer.Credentials = new System.Net.NetworkCredential(userName, password);
smtpServer.EnableSsl = enableSsl;
// send to ....
if (GlobalVar.DebugMode == false)
{
mail.To.Add("*****@*****.**");
mail.To.Add("*****@*****.**");
}
else
{
mail.To.Add("*****@*****.**");
}
// build email
mail.Subject = this.EmailSubject();
mail.IsBodyHtml = true;
mail.Body = this.EmailMessage();
try
{
smtpServer.Send(mail);
this.SendButton.Text = "Email Sent";
this.SendLabel.Text = "";
}
catch (Exception ex)
{
this.SendLabel.Text = String.Format("Exception caught in SendEmail(): {0}",
ex.ToString());
}
}
