protected void Page_Load(object sender, EventArgs e)
{
new AppointmentDAO().adjust();
if (!IsPostBack)
{
DataSet d = new AppointmentDAO().appList();
if (d != null)
{
if (d.Tables[0].Rows.Count != 0)
{
AppList.DataSource = d;
AppList.DataBind();
}
else
{
AppList.DataSource = null;
AppList.DataBind();
}
}
}
}
private void Appointments(DateTime Day)
{
AppTitle.Text = SimpleG.rm.GetString("WAPtxt6") + " " + Day.ToShortDateString();
Agenda calwap = new Agenda();
Clearpanels();
AppPanel.Visible = true;
Bback.Visible = true;
AppList.Fields.Clear();
DataTable CalendarDataTable = calwap.FillDayWap(Day, UC);
foreach (DataRow d in CalendarDataTable.Rows)
{
d["StartDate"] = Convert.ToDateTime(d["StartDate"]).AddHours(UC.HTimeZone);
}
AppList.DataSource = CalendarDataTable;
ObjectListField ListField1 = new ObjectListField();
ListField1.DataField = "Contact";
ListField1.Visible = false;
ListField1.Title = SimpleG.rm.GetString("WAPtxt3").ToUpper();
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "Company";
ListField1.Title = SimpleG.rm.GetString("WAPtxt4").ToUpper();
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "StartDate";
ListField1.Title = SimpleG.rm.GetString("WAPtxt5").ToUpper();
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "Note";
ListField1.Title = "Note";
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "Phone";
ListField1.Title = "Phone";
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "Room";
ListField1.Title = SimpleG.rm.GetString("Evnttxt11").ToUpper();
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "Address";
ListField1.Title = SimpleG.rm.GetString("Evnttxt12").ToUpper();
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "City";
ListField1.Title = SimpleG.rm.GetString("Evnttxt13").ToUpper();
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "Province";
ListField1.Title = SimpleG.rm.GetString("Evnttxt14").ToUpper();
AppList.Fields.Add(ListField1);
ListField1 = new ObjectListField();
ListField1.DataField = "Cap";
ListField1.Title = SimpleG.rm.GetString("Evnttxt15").ToUpper();
AppList.Fields.Add(ListField1);
AppList.AutoGenerateFields = false;
AppList.ItemsPerPage = 5;
AppList.DataBind();
AppList.Visible = true;
}
