private void CreateClient()
{
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
var client = new LIFENAV_Client();
client.FirstName = txtFirstName.Text;
client.LastName = txtLastName.Text;
client.Address1 = txtAddress1.Text;
client.Address2 = txtAddress2.Text;
client.City = txtCity.Text;
client.StateCode = ddlState.SelectedValue;
client.ZipCode = txtZipCode.Text;
client.Email = txtEmail.Text;
client.Password = txtPassword.Text;
client.HomePhone = txtHomePhone.Text;
client.WorkPhone = txtWorkPhone.Text;
db.LIFENAV_Clients.InsertOnSubmit(client);
db.SubmitChanges();
// update cookie with Client.Id
clientId = client.Id;
MyCookie.ClientId = clientId.ToString();
MyCookie.EmailAddress = txtEmail.Text;
}
}
public bool IsEmailAvailable()
{
bool result = false;
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
result = (db.LIFENAV_Clients.Count(c => c.Email.Equals(txtEmail.Text)) == 0);
}
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
if (MyCookie.HasClientId && MyCookie.EmailAddress.Equals("*****@*****.**")) {
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
var data = db.LIFENAV_Clients.ToList<LIFENAV_Client>();
rptClients.DataSource = data;
rptClients.DataBind();
}
} else {
Response.Redirect("/Login.aspx", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
int serviceId = 0;
string timeStr = "";
LIFENAV_Client client = null;
int clientId = int.Parse(MyCookie.ClientId);
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
client = (from c in db.LIFENAV_Clients where c.Id.Equals(clientId) select c).SingleOrDefault();
}
switch (MyCookie.AppointmentType.ToUpper()) {
case "INDIVIDUAL" :
serviceId = 1;
break;
case "COUPLE" :
serviceId = 2;
break;
case "FAMILY" :
serviceId = 3;
break;
case "GROUP" :
switch (MyCookie.GroupSize) {
case "8" :
serviceId = 4;
break;
case "9" :
serviceId = 5;
break;
case "10" :
serviceId = 6;
break;
case "11" :
serviceId = 7;
break;
case "12" :
serviceId = 8;
break;
}
break;
}
switch (MyCookie.AppointmentTime.ToUpper()) {
case "9AM" :
timeStr = " 09:00:00 AM";
break;
case "10AM" :
timeStr = " 10:00:00 AM";
break;
case "11AM" :
timeStr = " 11:00:00 AM";
break;
case "1PM" :
timeStr = " 01:00:00 PM";
break;
case "2PM" :
timeStr = " 02:00:00 PM";
break;
case "3PM" :
timeStr = " 03:00:00 PM";
break;
case "4PM" :
timeStr = " 04:00:00 PM";
break;
}
string dt = MyCookie.AppointmentDate;
DateTime reservedDateTime = DateTime.Parse(dt + timeStr);
// create our datacontext and wrap it in a using statement
using (AppointmentDataContext db = new AppointmentDataContext(Config.LIFENAVConnectionString))
{
var appointment = new LIFENAV_Client_Appointment();
appointment.ClientId = clientId;
appointment.ServiceId = serviceId;
appointment.ReservedDateTime = reservedDateTime;
db.LIFENAV_Client_Appointments.InsertOnSubmit(appointment);
db.SubmitChanges();
}
// send appointment email
MailUtil.SendAppointmentEmail(clientId, client.Email);
Response.Redirect("/Schedule.aspx", true);
}
private static XElement _getMembershipXML(int clientId)
{
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
var data = db.LIFENAV_GetMembershipXML(clientId);
var result = data.FirstOrDefault<LIFENAV_GetMembershipXMLResult>();
return (result == null ? null : result.Column1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Config.IsTestMode) {
if (Config.SSLEnabled) {
if (!Request.IsSecureConnection) {
Response.Redirect("https://www.yourlifenavigator.com/Login.aspx", true);
}
}
}
// Google CDN supports SSL, but doesn't combine files
string YUILib = String.Format("{0}://ajax.googleapis.com/ajax/libs/yui/2.7.0/build", (Request.IsSecureConnection ? "https" : "http"));
StringBuilder sbJS = new StringBuilder(1024);
sbJS.AppendFormat("<script type=\"text/javascript\" src=\"{0}/connection/connection-min.js\"></script>", YUILib);
sbJS.AppendFormat("<script type=\"text/javascript\" src=\"{0}/json/json-min.js\"></script>", YUILib);
litExternalJS.Text = sbJS.ToString();
if (IsPostBack) {
string clientId = String.Empty;
bool isEmailMissing = String.IsNullOrEmpty(txtEmail.Text);
bool isPasswordMissing = String.IsNullOrEmpty(txtPassword.Text);
if (isEmailMissing && isPasswordMissing) {
lblError.Text = "please enter your email address and password";
} else if (isEmailMissing) {
lblError.Text = "please enter your email address";
} else if (isPasswordMissing) {
lblError.Text = "please enter your password";
} else {
bool isEmailValid = Regex.IsMatch(txtEmail.Text, @"^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$");
bool isPasswordValid = Regex.IsMatch(txtPassword.Text, "^.{4,10}$");
if (!isEmailValid && !isPasswordValid) {
lblError.Text = "your email address and password are not valid";
} else if (!isEmailValid) {
lblError.Text = "your email address is not valid";
} else if (!isPasswordValid) {
lblError.Text = "your password is not valid";
} else {
bool isAuthenticated = false;
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
var data = from client in db.LIFENAV_Clients where client.Email.Equals(txtEmail.Text) where client.Password.Equals(txtPassword.Text) select client;
var myClient = data.FirstOrDefault<LIFENAV_Client>();
if (myClient != null) {
isAuthenticated = true;
clientId = myClient.Id.ToString();
}
}
if (isAuthenticated) {
MyCookie.ClientId = clientId;
MyCookie.EmailAddress = txtEmail.Text;
Response.Redirect("/Account.aspx", true);
} else {
lblError.Text = "sorry, we could not find that account";
}
}
}
} else {
if (MyCookie.HasClientId) {
Response.Redirect("/Account.aspx", true);
} else {
MyCookie.ClearCookie();
}
}
}
