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 _getAppointmentXML(int clientId)
{
using (AppointmentDataContext db = new AppointmentDataContext(Config.LIFENAVConnectionString))
{
var data = db.LIFENAV_GetAppointmentXML(clientId);
var result = data.FirstOrDefault<LIFENAV_GetAppointmentXMLResult>();
return (result == null ? null : result.Column1);
}
}
