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