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