private void Grid_patient_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
this.Close();
int PatientId = Convert.ToInt32(Grid_patient.Rows[e.RowIndex].Cells["PatientID"].FormattedValue);
int RadioButtonValue = Convert.ToInt32(Grid_patient.Rows[e.RowIndex].Cells["Gender"].FormattedValue);
string BirthDate = (Grid_patient.Rows[e.RowIndex].Cells["DOB"].FormattedValue).ToString();
int BloodGroup = Convert.ToInt32(Grid_patient.Rows[e.RowIndex].Cells["BloodGroup"].FormattedValue);
AddNewPatient Patient = new AddNewPatient();
Patient.EditedPatient = PatientId;
HelpClass.VisibleOrNot(false, Patient.Controls["But_AddPatient"]);
HelpClass.VisibleOrNot(true, Patient.Controls["But_EditPatient"]);
Patient.Text = "تعديل بيانات مريض";
Patient.Controls["label8"].Text = "تعديل بيانات مريض";
Patient.Controls["Txt_PatientName"].Text = (Grid_patient.Rows[e.RowIndex].Cells["PatientName"].FormattedValue).ToString();
Patient.Controls["Txt_SoSeNo"].Text = (Grid_patient.Rows[e.RowIndex].Cells["SoSecNo"].FormattedValue).ToString();
Patient.Controls["Txt_Mobile"].Text = (Grid_patient.Rows[e.RowIndex].Cells["PhoneNumber"].FormattedValue).ToString();
Patient.Controls["Txt_Address"].Text = (Grid_patient.Rows[e.RowIndex].Cells["Address"].FormattedValue).ToString();
Patient.SetRadioButton(RadioButtonValue);
Patient.SetBirthDay(BirthDate);
Patient.Show();
Patient.SetBloodCombo(BloodGroup);
Patient.WindowState = FormWindowState.Normal;
Patient.TopMost = true;
}
private void But_Save_Click(object sender, EventArgs e)
{
IdList.Clear();
foreach (var item in AddNewPrescription.Value)
{
var IdX = (from H in Hospital.Drugs
where H.DrugName == item
select new { H.DrugId }.DrugId).ToList();
int Id = IdX[0];
IdList.Add(Id);
}
HelpClass.VisibleOrNot(true, But_send);
But_send.Location = new Point(192, YDrug + 70);
HelpClass.EnabledOrDisabled(false, But_Save);
for (int i = 6; i < Controls.Count; i += 3)
{
if (!string.IsNullOrEmpty(Controls[i].Text) && !string.IsNullOrEmpty(Controls[(i + 1)].Text) && Controls[i].Text != "0")
{
X.Direction = ParameterDirection.ReturnValue;
int ValidQuant;
if (int.TryParse(Controls[i].Text, out ValidQuant))
{
QntyLis.Add(Convert.ToInt32(Controls[i].Text));
DoseList.Add(Controls[i + 1].Text);
}
else
{
But_send.Visible = false;
MessageBox.Show("يرجى إدخال الكمية بشكل صحيح");
But_Save.Enabled = true;
QntyLis.Clear();
DoseList.Clear();
break;
}
}
else
{
But_send.Visible = false;
MessageBox.Show("يرجى استكمال بيانات الروشته مع التأكد بعدم وجود كمية تساوي صفر");
But_Save.Enabled = true;
QntyLis.Clear();
DoseList.Clear();
break;
}
}
}
private void But_CheckOut_MouseHover(object sender, EventArgs e)
{
HelpClass.VisibleOrNot(true, label7, label9, label8, label10);
ConnectionClass.SQLCommandWithoutParameters("select publicSchema.CalculateHostingFees (" + ReservationId + ")", CommandType.Text, ExecuteReaderOrNonQuery.executeScalar);
int HostingamountDue = ConnectionClass.scalarReturn;
decimal SumPrescription;
try
{
SumPrescription = (from H in Hospital.VW_Prescription
where H.ReservationID == ReservationId && H.IsReceived == true
select H.Qnty * H.PricePerUnit).Sum();
}
catch { SumPrescription = 0; }
amountDue = SumPrescription + HostingamountDue;
label8.Text = (amountDue).ToString();
label10.Text = (amountDue - DSum).ToString();
}
private void Com_Room_SelectedIndexChanged(object sender, EventArgs e)
{
var RidItem = Com_Room.SelectedItem;
RId = Convert.ToInt32(RidItem.GetType().GetProperty("RoomId").GetValue(RidItem));
var Pname = RidItem.GetType().GetProperty("PatientName").GetValue(RidItem);
var ActiveDoc = (from R in Hospital.Rooms
join RS in Hospital.Reservations
on R.RoomId equals RS.RoomID
join D in Hospital.DocfollowUps
on RS.ReservationID equals D.ReservationID
join DS in Hospital.Doctors
on D.DoctorID equals DS.DoctorId
where RS.RoomID == RId && RS.IsActive == true
select new { DS.DoctorId, DS.DocName, RS.ReservationID }).ToList();
Com_Doc.DataSource = ActiveDoc;
Com_Doc.ValueMember = "DoctorId";
Com_Doc.DisplayMember = "DocName";
Txt_patient.Text = Pname.ToString();
if (Com_Doc.SelectedItem != null)
{
var x = (Com_Doc.SelectedItem);
DocId = Convert.ToInt32(x.GetType().GetProperty("DoctorId").GetValue(x));
reservationId = Convert.ToInt32(x.GetType().GetProperty("ReservationID").GetValue(x));
HelpClass.EnabledOrDisabled(true, But_Add);
HelpClass.VisibleOrNot(true, Com_Doc);
HelpClass.VisibleOrNot(false, label1);
//PatientId= Convert.ToInt32(x.GetType().GetProperty("PatientID").GetValue(x));
}
else
{
HelpClass.EnabledOrDisabled(false, But_Add);
label1.Text = "لا يوجد طبيب مخصص لهذا المريض";
label1.Location = new Point(160, CHY + 80);
HelpClass.VisibleOrNot(true, label1);
HelpClass.VisibleOrNot(false, Com_Doc);
}
}
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;
}