protected void Page_Load(object sender, EventArgs e)
{
if (MyCookie.HasClientId) {
int clientId = int.Parse(MyCookie.ClientId);
using (ScheduleDataContext db = new ScheduleDataContext(Config.LIFENAVConnectionString))
{
var data = db.LIFENAV_GetDailyAppointments(DateTime.Today, null, clientId);
Repeater1.DataSource = data;
Repeater1.DataBind();
}
} else {
Response.Redirect("/Login.aspx", true);
}
}
public string GetDailyAppointments(int year, int month, int day)
{
using (ScheduleDataContext db = new ScheduleDataContext(Config.LIFENAVConnectionString))
{
List<DailyAppointment> appointments = new List<DailyAppointment>();
DateTime startDate = new DateTime(year, month, day);
var query = db.LIFENAV_GetDailyAppointments(startDate, 1, null);
foreach (LIFENAV_GetDailyAppointmentsResult data in query) {
appointments.Add(new DailyAppointment(data.ClientId, data.ShortName, data.ReservedDateTime));
}
string JSONAppointments = JavaScriptConvert.SerializeObject(appointments);
return JSONAppointments;
}
}
public string GetDailyAppointments(int year, int month, int day)
{
using (ScheduleDataContext db = new ScheduleDataContext(Config.LIFENAVConnectionString))
{
List <DailyAppointment> appointments = new List <DailyAppointment>();
DateTime startDate = new DateTime(year, month, day);
var query = db.LIFENAV_GetDailyAppointments(startDate, 1, null);
foreach (LIFENAV_GetDailyAppointmentsResult data in query)
{
appointments.Add(new DailyAppointment(data.ClientId, data.ShortName, data.ReservedDateTime));
}
string JSONAppointments = JavaScriptConvert.SerializeObject(appointments);
return(JSONAppointments);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (MyCookie.HasClientId)
{
int clientId = int.Parse(MyCookie.ClientId);
using (ScheduleDataContext db = new ScheduleDataContext(Config.LIFENAVConnectionString))
{
var data = db.LIFENAV_GetDailyAppointments(DateTime.Today, null, clientId);
Repeater1.DataSource = data;
Repeater1.DataBind();
}
}
else
{
Response.Redirect("/Login.aspx", true);
}
}
