private void btnSave_Click(object sender, EventArgs e) { var patient = new Patient { HospitalNumber = int.Parse(mtbHospitalId.Text), Title = (Title)Enum.Parse(typeof(Title), cboTitle.Text), LastName = txtLastName.Text, FirstName = txtFirstName.Text, OtherName = txtMname.Text, Gender = (Gender)Enum.Parse(typeof(Gender), cboTitle.Text), BirthDate = dtpBirthDate.Value, Phone = int.Parse(mtbPhone.Text), HomeAddress = txtHomeAdd.Text, MaritalStatus = (MaritalStatus)Enum.Parse(typeof(MaritalStatus), cboMaritalStatus.Text) }; using (ClinicModel model = new ClinicModel()) { model.Patients.Add(patient); } MessageBox.Show("New Patient Registered"); Close(); }
private void btnLogin_Click(object sender, EventArgs e) { List<User> users = new List<User>(); using (ClinicModel context = new ClinicModel()) { users = context.Users .Where(x => x.Username == txtUsername.Text) .ToList(); } if (users.Count == 0) { DialogResult = DialogResult.No; Close(); } else { User user = users.Single(); if (user.Password.Equals(txtPassword.Text)) { DialogResult = DialogResult.OK; Close(); } else { DialogResult = DialogResult.No; Close(); } } }
private void btnSave_Click(object sender, EventArgs e) { Clinic clinic = new Clinic() { Identifier = int.Parse(txtClinicNumber.Text), Title = (Title)Enum.Parse(typeof(Title), cboTitle.Text), LastName = txtLastName.Text, FirstName = txtFirstName.Text, Specialty = txtSpecialty.Text, Department = txtDepartment.Text, Address = txtAddress.Text, Telephone = txtTelephone.Text, Email = txtEmail.Text, CreatedAt = DateTime.Now }; using (ClinicModel context = new ClinicModel()) { context.Clinicians.Add(clinic); context.SaveChanges(); } MessageBox.Show("Clinic Saved"); Close(); }
private void frmClinicsList_Load(object sender, EventArgs e) { using (ClinicModel context = new ClinicModel()) { var clinicians = context.Clinicians.ToList(); dgvClinicians.DataSource = clinicians; } }
private void Load_Users() { using (ClinicModel context = new ClinicModel()) { var users = context.Users.ToList(); dataGridView1.DataSource = users; } }
private void Load_ClinicsRecord() { using (ClinicModel context = new ClinicModel()) { var clinics = context.Clinicians.ToList(); dgridClinics.DataSource = clinics; } }
private void txtPid_Leave(object sender, EventArgs e) { int patientId = int.Parse(txtPid.Text); Patient patient; using (ClinicModel context = new ClinicModel()) { patient = context.Patients .Where(x => x.Identifier == patientId) .Single(); } txtHospNum.Text = patient.HospitalNumber.ToString(); txtPatname.Text = patient.FirstName + " " + patient.LastName; }
private void btnChangePass_Click(object sender, EventArgs e) { int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; User user; using (ClinicModel context = new ClinicModel()) { user = context.Users .Where(x => x.Identifier.Equals(id)) .Single(); } frmChangePass frm = new frmChangePass(user); frm.ShowDialog(); }
private void btnEditC_Click(object sender, EventArgs e) { if (dgvClinicians.SelectedColumns.Count > 0) { object id = dgvClinicians.SelectedRows[0].Cells[0].Value; Clinic clinic; using (ClinicModel context = new ClinicModel()) { clinic = context.Clinicians .Where(x => x.Identifier.Equals(id)) .Single(); } frmEditClinic frm = new frmEditClinic(clinic); frm.ShowDialog(); } }
private void btnSave_Click(object sender, EventArgs e) { User user = new User() { FirstName = txtFName.Text, LastName = txtLName.Text, Username = txtUsername.Text, Password = txtPassword.Text, ModuleAccess = txtProfile.Text }; using (ClinicModel context = new ClinicModel()) { context.Users.Add(user); context.SaveChanges(); } MessageBox.Show("New User Created"); Close(); }
private void button1_Click(object sender, EventArgs e) { List<Patient> patients = new List<Patient>(); using (ClinicModel context = new ClinicModel()) { var patientsQuery = context.Patients.AsQueryable(); if (txtPatientId.Text.Trim().Length > 0) { patientsQuery = patientsQuery.Where(x => x.Identifier == int.Parse(txtPatientId.Text)); } if (txtLastName.Text.Trim().Length > 0) { patientsQuery = patientsQuery.Where(x => x.LastName == txtLastName.Text); } if (txtFirstName.Text.Trim().Length > 0) { patientsQuery = patientsQuery.Where(x => x.FirstName == txtFirstName.Text); } if (txtHospNum.Text.Trim().Length > 0) { patientsQuery = patientsQuery.Where(x => x.HospitalNumber == int.Parse(txtHospNum.Text)); } patients = patientsQuery.ToList(); } if (patients.Count == 0) { MessageBox.Show("No Patient Found"); return; } dgvPatients.DataSource = patients; }
private void btnSave_Click(object sender, EventArgs e) { var ap = new Appointment() { Identifier = int.Parse(txtCNum.Text), ClinicianName = txtPatConsultant.Text, PatientId = int.Parse(txtPid.Text), HospitalNumber = int.Parse(txtHospNum.Text), PatientName = txtPatname.Text, Created = dateTimePicker1.Value, Purpose = txtApptPurpose.Text, CreatedAt = DateTime.Now }; using (ClinicModel context = new ClinicModel()) { context.Appointments.Add(ap); context.SaveChanges(); } MessageBox.Show("Clinic Saved"); }
private void btnSave_Click(object sender, EventArgs e) { if (txtPassConfirm.Text == txtPassword.Text) { _user.Password = txtPassword.Text; using (ClinicModel context = new ClinicModel()) { context.Users.Attach(_user); context.SaveChanges(); } MessageBox.Show("Password changed successfully"); Close(); } else { MessageBox.Show("Please confirm Password and Confirm Pasword fields match"); txtPassword.Text = ""; txtPassConfirm.Text = ""; } }
private void btnUpdate_Click(object sender, EventArgs e) { txtDateAmend.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); var patient = new Patient() { Identifier = int.Parse(txtPid.Text), HospitalNumber = int.Parse(txtHospNum.Text), Title = (Title)Enum.Parse(typeof(Title), cmbtitle.Text), LastName = txtLname.Text, FirstName = txtFname.Text, MiddleName = txtMname.Text, Gender = (Gender)Enum.Parse(typeof(Gender), cmbGender.Text), BirthDate = DateTime.Parse(txtDob.Text), Phone = int.Parse(txtPhone.Text), MobilePhone = int.Parse(txtMPhone.Text), Email = txtEmail.Text, HomeAddress = txtHAddress.Text, City = txtCity.Text, State = txtState.Text, MaritalStatus = (MaritalStatus)Enum.Parse(typeof(MaritalStatus), cmbMStatus.Text), PatientConsultant = txtPatConsultant.Text, Nationality = txtNat.Text, StateOfOrigin = txtSOrigin.Text, Hometown = txtTOrigin.Text, PlaceOfBirth = txtPoB.Text, Religion = txtReligion.Text, Occupation = txtOccupation.Text, OfficeAddress = txtOAddress.Text, NationalIdType = cmbNIDType.Text, NationalIdNumber = txtNidNumber.Text, NextOfKin = txtNok.Text, AddressNextOfKin = txtNoKAddress.Text, PhoneNextOfKin = int.Parse(txtNoKPhone.Text), EmailNextOfKin = txtNoKEmail.Text, NextOfKinRelationship = cmbNokRelationship.Text, NameOfFather = txtFather.Text, NameOfMother = txtMother.Text, HealthInsuranceProvider = txtHealthIns.Text, AddressHealthInsuranceProvider = txtHealthAddr.Text, PhoneHealthInsuranceProvider = int.Parse(txtHealthPhone.Text), EmailHealthInsuranceProvider = txtHealthEmail.Text, DateAmended = txtDateAmend.Text, Photo = GetBytesFromImage() }; using (ClinicModel context = new ClinicModel()) { context.Patients.Add(patient); context.SaveChanges(); } GetBytesFromImage(); MessageBox.Show("Patient Record Updated"); }
private void Load_ClinicsRecord() { List<Clinic> clinics = new List<Clinic>(); using (ClinicModel context = new ClinicModel()) { clinics = context.Clinicians.ToList(); } dgridClinics.DataSource = clinics; }
private void record_delete() { using (ClinicModel context = new ClinicModel()) { context.Patients.Remove(new Patient() { Identifier = int.Parse(txtPid.Text) }); } MessageBox.Show("Patient Record Deleted"); }