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(); } } }