public void List() { var db = new HospitalDbEntities(); var doctorList = db.Doctors; try { Console.WriteLine("Name \t Gender Degree \t Mobile Number"); foreach (var doctor in doctorList) { Console.WriteLine(doctor.DoctorName + " " + doctor.DoctorGender + " " + doctor.DoctorQualification + " " + doctor.DoctorPhoneNumber); } } catch (Exception e) { Console.WriteLine("There are no patients"); } }
public void List() { var db = new HospitalDbEntities(); var patientList = db.Patients; try { Console.WriteLine("Name \t Age \t Gender Mobile Number"); foreach (var patient in patientList) { Console.WriteLine(patient.PatientName + " " + patient.PatientAge + " " + patient.PatientGender + " " + patient.PatientPhoneNumber); } } catch (Exception e) { Console.WriteLine("There are no patients"); } }
static void Main(string[] args) { int choice = 0; var dbContext = new HospitalDbEntities(); Console.WriteLine("Welcome To Hospital Management System"); Console.WriteLine("1. Add Patient"); Console.WriteLine("2. Add Doctor"); Console.WriteLine("3. Add Healthcare Assistant"); Console.WriteLine("4. Add Department"); Console.WriteLine("5. Add Drugs"); Console.WriteLine("6. Make Appointment"); Console.WriteLine("7. View Patients"); Console.WriteLine("8. View Doctors"); Console.WriteLine("9. Prescribe"); Console.WriteLine("0. Exit Application"); Console.Write("Enter Your Choice : "); choice = Convert.ToInt32(Console.ReadLine()); do { switch (choice) { case 1: Patients p = new Patients(); p.GetData(); dbContext.Patients.Add(p); dbContext.SaveChanges(); break; case 2: Doctors d = new Doctors(); d.GetData(); dbContext.Doctors.Add(d); dbContext.SaveChanges(); break; case 3: HealthcareAssistants ha = new HealthcareAssistants(); ha.GetData(); dbContext.HealthcareAssistants.Add(ha); dbContext.SaveChanges(); break; case 4: Departments departments = new Departments(); departments.GetData(); dbContext.Departments.Add(departments); dbContext.SaveChanges(); break; case 5: Drugs drugs = new Drugs(); drugs.GetData(); dbContext.Drugs.Add(drugs); dbContext.SaveChanges(); break; case 6: Diagnosises diagnosis = new Diagnosises(); diagnosis.GetData(); dbContext.Diagnosises.Add(diagnosis); dbContext.SaveChanges(); break; case 7: Patients patients = new Patients(); patients.List(); break; case 8: Doctors doctors = new Doctors(); doctors.List(); break; case 9: Prescribes prescribes = new Prescribes(); prescribes.GetData(); dbContext.Prescribes.Add(prescribes); dbContext.SaveChanges(); break; } Console.WriteLine("Enter Your Choice"); choice = Convert.ToInt32(Console.ReadLine()); } while (choice != 0); }
static void Main(string[] args) { bool flag = true; int choice; var dbContext = new HospitalDbEntities(); while (flag) { Console.WriteLine("1. Add Patient Details"); Console.WriteLine("2. Show Patient"); Console.WriteLine("3. Add Doctor Details"); Console.WriteLine("4. Show Doctor"); Console.WriteLine("5. Add Assistant"); Console.WriteLine("6. Add Drug"); Console.WriteLine("7. Add Appointment"); Console.WriteLine("8. Add Precsription"); Console.WriteLine("9. Exit"); Console.WriteLine("Enter your Choice: "); choice = Convert.ToInt32(Console.ReadLine()); switch (choice) { case 1: AddPatient(); break; case 2: PatientList(); break; case 3: AddDoctor(); break; case 4: DoctorList(); break; case 5: AddAssistant(); break; case 6: AddDrug(); break; case 7: AddAppointment(); break; case 8: AddPrescription(); break; case 9: flag = false; break; default: break; } } void AddPatient() { using (dbContext) { var patient = new Patient(); Console.WriteLine("Enter Patient Name: "); patient.Name = Console.ReadLine(); Console.WriteLine("Enter Patient Address: "); patient.Address = Console.ReadLine(); Console.WriteLine("Enter Patient Age: "); patient.Age = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Patient Gender: "); patient.Gender = Console.ReadLine(); Console.WriteLine("Enter Patient Contact Number: "); patient.ContactNo = Convert.ToInt64(Console.ReadLine()); //var check = dbContext.Patients.Where(t => t.Name == patient.name); var check = dbContext.Patients.SingleOrDefault(t => t.Name == patient.Name); if (check == null) { try { dbContext.Patients.Add(patient); dbContext.SaveChanges(); Console.WriteLine("Patient added to the list"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Patient is already in the list"); } } } //void RemovePatient() //{ // using (dbContext) // { // Console.WriteLine("Enter Patient name to delete : "); // string del = Console.ReadLine(); // var delPatient = dbContext.Patients.Where(t => t.Name == del); // if (delPatient.Count() == 1) // { // try // { // dbContext.Patients.Remove(dbContext.Patients.Single(t => t.Name == del)); // dbContext.SaveChanges(); // Console.WriteLine("Patient is removed !!"); // } // catch (Exception e) // { // Console.WriteLine(e); // } // } // else // { // Console.WriteLine("Patient is not available in the list"); // } // } //} void AddDoctor() { using (dbContext) { var doctor = new Doctor(); Console.WriteLine("Enter Doctor Name: "); doctor.Name = Console.ReadLine(); Console.WriteLine("Enter Doctor Address: "); doctor.Address = Console.ReadLine(); Console.WriteLine("Enter Doctor Gender: "); doctor.Gender = Console.ReadLine(); Console.WriteLine("Enter Doctor Contact Number: "); doctor.ContactNo = Convert.ToInt64(Console.ReadLine()); Console.WriteLine("Enter Doctor Designation: "); doctor.Designation = Console.ReadLine(); var check = dbContext.Doctors.SingleOrDefault(t => t.Name == doctor.Name); if (check == null) { try { dbContext.Doctors.Add(doctor); dbContext.SaveChanges(); Console.WriteLine("Doctor added to the list"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Doctor is already in the list"); } } } void AddDrug() { using (var dbContext1 = new HospitalDbEntities()) { var drug = new Drug(); Console.WriteLine("Enter Drug Name: "); drug.Name = Console.ReadLine(); var check = dbContext1.Drugs.SingleOrDefault(t => t.Name == drug.Name); if (check == null) { try { dbContext1.Drugs.Add(drug); dbContext1.SaveChanges(); Console.WriteLine("Drug added to the list"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Drug is already in the list"); } } } //void RemoveDoctor() //{ // using (dbContext) // { // Console.WriteLine("Enter Doctor name to delete : "); // string del = Console.ReadLine(); // var delDoctor = dbContext.Doctors.Where(t => t.Name == del); // if (delDoctor.Count() == 1) // { // try // { // dbContext.Doctors.Remove(dbContext.Doctors.Single(t => t.Name == del)); // dbContext.SaveChanges(); // Console.WriteLine("Doctor is removed !!"); // } // catch (Exception e) // { // Console.WriteLine(e); // } // } // else // { // Console.WriteLine("Doctor is not available in the list"); // } // } //} void AddAssistant() { using (dbContext) { var assistant = new Assistant(); Console.WriteLine("Enter Name: "); assistant.Name = Console.ReadLine(); Console.WriteLine("Enter Address: "); assistant.Address = Console.ReadLine(); Console.WriteLine("Enter Age: "); assistant.Age = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Gender: "); assistant.Gender = Console.ReadLine(); Console.WriteLine("Enter Contact Number: "); assistant.ContactNo = Convert.ToInt64(Console.ReadLine()); var check = dbContext.Assistants.SingleOrDefault(t => t.Name == assistant.Name); if (check == null) { try { dbContext.Assistants.Add(assistant); dbContext.SaveChanges(); Console.WriteLine("Assistant added to the list"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Assistant is already in the list"); } } } void AddAppointment() { using (dbContext) { var appointment = new Appointment(); Console.WriteLine("Patients: "); PatientList(); Console.WriteLine("Enter Patient Id : "); appointment.PatientId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Doctors : "); DoctorList(); Console.WriteLine("Enter Doctor Id: "); appointment.DoctorId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Appointment Time: "); appointment.AppointmentTime = Convert.ToDateTime(Console.ReadLine()); var check = dbContext.Appointments.SingleOrDefault(t => t.PatientId == appointment.PatientId); if (check == null) { try { dbContext.Appointments.Add(appointment); dbContext.SaveChanges(); Console.WriteLine("Appointment booked !!"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Appointment is already booked !!"); } } } void AddPrescription() { using (dbContext) { var pm = new Prescription(); Console.WriteLine("Patients: "); PatientList(); Console.WriteLine("Enter Patient Id : "); pm.PatientId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Assistants : "); AssistantList(); Console.WriteLine("Enter Assistant Id: "); pm.AssistantId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Timing"); pm.Time = Console.ReadLine(); Console.WriteLine("Drug list: "); DrugList(); Console.WriteLine("Enter Drug Id : "); pm.DrugId = Convert.ToInt32(Console.ReadLine()); var check = dbContext.Prescriptions.SingleOrDefault(t => t.PatientId == pm.PatientId); if (check == null) { try { dbContext.Prescriptions.Add(pm); dbContext.SaveChanges(); Console.WriteLine("Prescription added !!"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Prescriptions are already in the list !!"); } } } void PatientList() { var db = new HospitalDbEntities(); var patientList = db.Patients; try { foreach (var p in patientList) { Console.WriteLine("Id: " + p.PatientId + "Name : " + p.Name); } } catch (Exception e) { Console.WriteLine(e); } } void DoctorList() { var db = new HospitalDbEntities(); var doctorList = db.Doctors; try { foreach (var d in doctorList) { Console.WriteLine("Id : " + d.DoctorId + "Name : " + d.Name); } } catch (Exception e) { Console.WriteLine(e); } } void AssistantList() { var db = new HospitalDbEntities(); var assistantList = db.Assistants; try { foreach (var a in assistantList) { Console.WriteLine("Id: " + a.AssistantId + "Name : " + a.Name); } } catch (Exception e) { Console.WriteLine(e); } } void DrugList() { var db = new HospitalDbEntities(); var d = db.Drugs; try { foreach (var a in d) { Console.WriteLine("Id: " + a.DrugId + "Name : " + a.Name); } } catch (Exception e) { Console.WriteLine(e); } } }