protected void Page_Load(object sender, EventArgs e) { pid = Request.QueryString.Get("PID"); if (!Page.IsPostBack && pid != null) { using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities()) { // Select patient based on registration id var p = (from r in myEntities.Patient__Profile where r.Registration_ID == pid select r).SingleOrDefault(); string hid = (from r in myEntities.Hospital__Staff where r.Staff_ID == Profile.UserName select r.H_ID).SingleOrDefault(); if (p != null && p.H_ID == hid) { RegID.Text = pid; PName.Text = p.PatientName; PBed.Text = (p.CurrentBedNo == null) ? "Unoccupied" : p.CurrentBedNo; MultiView1.ActiveViewIndex = 0; // Select department ids having selected patient's hospital id var dids = from r in myEntities.Hospital__Department where r.H_ID == p.H_ID select r.D_ID; // Select department names corresponding to selected department ids Department.DataSource = from d in myEntities.Module__Department join i in dids on d.Department_ID equals i orderby d.Name ascending select d.Name; Department.DataBind(); // Selext beds correspinding to selected patient's hospital id var beds = (from r in myEntities.Hospital__Bed where (r.H_ID == hid && (r.Occupied == false || r.BedNo == p.CurrentBedNo)) orderby r.BedNo ascending select r.BedNo).ToList(); beds.Add("Unoccupied"); Bed.DataSource = beds; Bed.DataBind(); // Initialize form from database Department.SelectedValue = p.Department; Bed.SelectedValue = (p.CurrentBedNo == null) ? "Unoccupied" : p.CurrentBedNo; Name.Text = p.PatientName; SetPicture.Visible = String.IsNullOrEmpty(p.PhotoURL); DeletePicture.Visible = !String.IsNullOrEmpty(p.PhotoURL); Photo.ImageUrl = p.PhotoURL; Sex.SelectedValue = p.Sex; AgeValue.Text = p.Age.ToString(); AgeUnit.SelectedValue = p.AgeUnit; Weight.Text = p.BodyWeight.ToString(); Height.Text = p.Height.ToString(); MaritalStatus.SelectedValue = p.MaritalStatus; Co.Text = p.C_o; CoRelation.SelectedValue = p.C_o_Relation; MotherName.Text = p.MothersName; MLC.Text = p.MLC_No; RName.Text = p.ReferredBy; RContact.Text = p.RefContactNo; PrevTreated.Checked = (p.IfPreviouslyTreated == true); PrevID.Text = p.LastTreatedRegistration_ID; Occupation.Text = p.Occupation; Financing.Text = p.Financing; LAddress.Text = p.LocalAddress; LState.Text = p.LState; LCountry.Text = p.LCountry; LPincode.Text = p.LPincode; LContact1.Text = p.LContactNo1; LContact2.Text = p.LContactNo2; LEmail.Text = p.Email; PAddress.Text = p.PermanentAddress; PState.Text = p.PState; PCountry.Text = p.PCountry; PPincode.Text = p.PPincode; PContact1.Text = p.PContactNo1; PContact2.Text = p.PContactNo2; CName.Text = p.EmergencyContactPerson; CRelation.Text = p.CPRelationship; CAddress.Text = p.CPAddress; CContact1.Text = p.CPContactNo1; CContact2.Text = p.CPContactNo2; CEmail.Text = p.CPEmail; AName.Text = p.AdmittingPerson; ARelation.Text = p.APRelationship; AAddress.Text = p.APAddress; AContact1.Text = p.APContactNo1; AContact2.Text = p.APContactNo2; } else { MultiView1.ActiveViewIndex = 1; } } } }