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