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