public NewDepartment()
{
InitializeComponent();
Cbx_DepartmentId.Enabled = false;
hMS = new HospitalMSDataContext();
int result = hMS.tblDeptDetails.OrderByDescending(x => x.DeptId).Select(x => x.DeptId).FirstOrDefault() + 1;
Cbx_DepartmentId.Text = result.ToString();
}
public NewWard()
{
InitializeComponent();
hMS = new HospitalMSDataContext();
int result = hMS.tblWardDetails.OrderByDescending(x => x.WardId).Select(x => x.WardId).FirstOrDefault() + 1;
Cbx_WardID.Text = result.ToString();
Cbx_DepartmentId.Items.AddRange(hMS.tblDeptDetails.Select(x => (object)x.DeptId).ToArray());
Cbx_DepartmentId.SelectedIndex = 0;
}
public VacantBeds()
{
InitializeComponent();
hMS = new HospitalMSDataContext();
updateDept();
//updatePrivateBeds();
//updateSemiPrivateBeds();
//updatePublicBeds();
}
public ViewDepartment(string deptName)
{
InitializeComponent();
hMS = new HospitalMSDataContext();
Cbx_Department.Items.Add(deptName);
Cbx_Department.SelectedIndex = 0;
updateWard();
updateRoom();
updateBed();
}
public ViewWard(string wardName)
{
InitializeComponent();
hMS = new HospitalMSDataContext();
Cbx_Ward.Items.Add(wardName);
Cbx_Ward.SelectedIndex = 0;
updateDept();
updateRoom();
updateBed();
Cbx_Ward.Enabled = false;
}
public ViewRoom(int roomId)
{
InitializeComponent();
hMS = new HospitalMSDataContext();
Cbx_Room.Items.Add(roomId);
Cbx_Room.SelectedIndex = 0;
updateDept();
updateWard();
updateBed();
Cbx_Room.Enabled = false;
}
public ViewBeds(int bedId)
{
InitializeComponent();
hMS = new HospitalMSDataContext();
Cbx_Bed.Items.Add((object)bedId);
Cbx_Bed.SelectedIndex = 0;
updateRoom();
updateWard();
updateDept();
Cbx_Bed.Enabled = false;
}
public NewRoom()
{
InitializeComponent();
hMS = new HospitalMSDataContext();
int result = hMS.tblRoomDetails.OrderByDescending(x => x.RoomId).Select(x => x.RoomId).FirstOrDefault() + 1;
Cbx_RoomId.Text = result.ToString();
Cbx_WardId.Items.AddRange(hMS.tblWardDetails.Select(x => (object)x.WardId).ToArray());
Cbx_WardId.SelectedIndex = 0;
object[] roomTypes = { "Public", "SemiPrivate", "Private" };
Cbx_RoomType.Items.AddRange(roomTypes);
}
public NewRoom(string stuff)
{
InitializeComponent();
hMS = new HospitalMSDataContext();
Cbx_RoomId.Items.AddRange(hMS.tblRoomDetails.Select(x => (object)x.RoomId).ToArray());
Cbx_RoomId.SelectedIndex = 0;
Cbx_RoomId.Enabled = true;
Cbx_WardId.Items.AddRange(hMS.tblRoomDetails.Where(x => x.RoomId == int.Parse(Cbx_RoomId.Text)).Select(x => (object)x.WardId).ToArray());
Cbx_WardId.SelectedIndex = 0;
object[] roomTypes = { "Public", "SemiPrivate", "Private" };
Cbx_RoomType.Items.AddRange(roomTypes);
Cbx_RoomType.Text = hMS.tblRoomDetails.Where(x => x.RoomId == int.Parse(Cbx_RoomId.Text)).Select(x => x.RoomType).FirstOrDefault();
}
public NewWard(string title)
{
InitializeComponent();
//Btn_Save.Hide();
this.Text = "View Department";
hMS = new HospitalMSDataContext();
Cbx_DepartmentId.Enabled = false;
Cbx_WardID.Enabled = true;
Cbx_DepartmentId.Items.AddRange(hMS.tblDeptDetails.Select(x => (object)x.DeptId).ToArray());
Cbx_DepartmentId.SelectedIndex = 0;
Cbx_WardID.Items.AddRange(hMS.tblWardDetails.Where(x => x.DeptId == (int)Cbx_DepartmentId.SelectedItem).Select(x => (object)x.WardId).ToArray());
Cbx_WardID.SelectedIndex = 0;
Txt_WardName.Text
= hMS.tblWardDetails.Where(x => x.WardId == int.Parse(Cbx_WardID.SelectedItem.ToString())).Select(x => x.WardName).First();
}
public HMSBilling()
{
InitializeComponent();
HMSData = new HospitalMSDataContext();
var billTable = HMSData.tblBillingDetails;
var patientTable = HMSData.tblPatientDetails;
TxtName.Text =
patientTable.Select(x => x.PatientForename).First()
+ " " + patientTable.Select(x => x.PatientSurename).First();
//TxtName.Text = patientTable.Select(x => x.PatientForename).Where(x => x.visitId == 999999).First();
int billingId = billTable.Select(x => x.VisitId).First();
TxtId.Text = billingId.ToString();
bill = billingId;
date = billTable.Select(x => x.BillingDate).First();
//DateTime date = billTable.Select(x => x.BillingDate).Where(x => x.visitId == 1234).First();
MthCalendar.SetSelectionRange(date, date);
TxtPatientId.Text =
billTable.Select(x => x.PatientId).First().ToString();
//TxtPatientId.Text = billTable.Select(x => x.PatientId).Where(x => x.visitId == 999999).First();
decimal roomCharge = billTable.Select(x => x.RoomCharge).First();
TxtRoomCharge.Text = roomCharge.ToString("C", culture);
decimal doctorsFee = billTable.Select(x => x.DoctorsFee).First();
TxtDoctorsFee.Text = doctorsFee.ToString("C", culture);
TxtNote.Text =
billTable.Select(x => x.BillingNote).FirstOrDefault();
decimal miscFee = billTable.Select(x => x.MiscBillingFee).First();
TxtMiscFee.Text = miscFee.ToString("C", culture);
decimal totFee = roomCharge + doctorsFee + miscFee;
TxtTotalFee.Text = totFee.ToString("C", culture);
MthCalendar.DateSelected += new System.Windows.Forms.DateRangeEventHandler(this.MthCalendar_DateSelected);
}
public NewBed()
{
InitializeComponent();
hMS = new HospitalMSDataContext();
int result = hMS.tblRoomDetails.OrderByDescending(x => x.RoomId).Select(x => x.RoomId).FirstOrDefault() + 1;
Cbx_BedId.Items.Add((object)result.ToString());
if (Cbx_BedId.Items.Count != 0)
{
Cbx_BedId.SelectedIndex = 0;
}
Cbx_RoomId.Items.AddRange(hMS.tblRoomDetails.Select(x => (object)x.RoomId).ToArray());
if (Cbx_RoomId.Items.Count != 0)
{
Cbx_RoomId.SelectedIndex = 0;
}
}
private void UpdatePatientDetails()
{
int patientID = Int32.Parse(TxtPatientID.Text);
using (HospitalMSDataContext hospitalMS = new HospitalMSDataContext())
{
// "id" is the id in your table (parameter passed)
//Patient patient = hospitalMS.tblPatientDetails.Find(patientID).First(); // Find may be only for Entity Framework. If you can't use it, use the line below
var patient = hospitalMS.tblPatientDetails.Where(x => x.PatientId == patientID).First();
patient.PatientForename = TxtForename.Text;
patient.PatientSurename = TxtSurname.Text;
var patientDOB = Convert.ToDateTime(TxtDOBYear.Text + "-" + TxtDOBMonth.Text + "-" + TxtDOBDay.Text);
patient.PatientDOB = patientDOB;
if (RdoMale.Checked)
{
patient.PatientGender = true;
}
else if (RdoFemale.Checked)
{
patient.PatientGender = false;
}
else
{
Console.WriteLine("Gender Error");
}
patient.PatientPhoneNum = TxtPhoneNum.Text;
patient.PatientAddress = TxtAddress.Text;
NOK nok = new NOK();
nok.NOKName = TxtNOKName.Text;
nok.NOKPhoneNum = TxtNOKPhoneNum.Text;
string JSONresult = JsonConvert.SerializeObject(nok);
patient.PatientNOK = JSONresult;
hospitalMS.SubmitChanges();
FormLoad();
};
}
public FrmPatientDetails()
{
InitializeComponent();
hospitalMS = new HospitalMSDataContext();
FormLoad();
}
public OccupiedBeds()
{
InitializeComponent();
hMS = new HospitalMSDataContext();
updateDept();
}
public ViewBeds()
{
InitializeComponent();
hMS = new HospitalMSDataContext();
updateBoxes();
}
public NewPatientNote(int patientId)
{
InitializeComponent();
hospitalMS = new HospitalMSDataContext();
PopulateForm(patientId);
}
