private void Com_RoomNo_SelectedValueChanged(object sender, EventArgs e) { HelpClass.VisibleOrNot(false, label7, label9, label8, label10); if (fromAnotherForm == 0) { object S = new object(); S = Com_RoomNo.SelectedItem; x = Convert.ToInt32(S.GetType().GetProperty("RoomId").GetValue(S)); } var PatientName = (from R in Hospital.Reservations join p in Hospital.Patients on R.patientId equals p.PatientID where R.IsActive == true && R.RoomID == x select new { p.PatientName, R.ReservationID, R.ArriveDate, R.RoomID }).ToList(); PName = PatientName[0].PatientName.ToString(); ReservationId = Convert.ToInt32(PatientName[0].ReservationID); D = Convert.ToDateTime(PatientName[0].ArriveDate); RoomId = Convert.ToInt32(PatientName[0].RoomID); try { var sum = (from P in Hospital.Payments where P.ReservationId == ReservationId select P.Amount).Sum(); Txt_TotalPaid.Text = sum.ToString(); DSum = sum; } catch { Txt_TotalPaid.Text = "0"; DSum = 0; } Txt_Arrival.Text = D.ToString("ddd, dd- MMM- yyyy"); Txt_PatientName.Text = PName; }