protected void Page_Load(object sender, EventArgs e) { string PID = Request.QueryString.Get("PID"); if (!Page.IsPostBack) { if (!User.IsInRole("Administrator") && !User.IsInRole("Hospital Superuser") && !User.IsInRole("Hospital Management") && !User.IsInRole("Nurse")) { Response.Redirect("~/Account/Login.aspx"); } else { using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities()) { hid = (from r in myEntities.Hospital__Staff where r.Staff_ID == Profile.UserName select r.H_ID).SingleOrDefault(); if (hid == null) { hid = Profile.UserName; } } } if (PID != null) { using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities()) { var p = (from r in myEntities.Patient__Profile where r.Registration_ID == PID select r).SingleOrDefault(); if (p != null && p.H_ID == hid) { RegID.Text = PID; PName.Text = p.PatientName; PBed.Text = p.CurrentBedNo; var dates = (from r in myEntities.Clinical_Monitoring__Intake_Output where r.P_ID == PID select r.LogDate).Distinct(); var orderedDates = from r in dates orderby r descending select r; List <String> datelist = new List <String>(); foreach (var d in orderedDates) { datelist.Add(d.ToShortDateString()); } DateFilter.DataSource = datelist; DateFilter.DataBind(); MultiView1.ActiveViewIndex = 0; } else { MultiView1.ActiveViewIndex = 1; } } } else { MultiView1.ActiveViewIndex = -1; } } }