public void DeleteDoctor() { HospitaldatabaseContext hp = new HospitaldatabaseContext(); Console.WriteLine("Enter Doctor Name You Want To Delete"); string doctor = Console.ReadLine(); var deleteddata = hp.Doctors.Single(s => s.DoctorName == doctor); hp.Remove(deleteddata); hp.SaveChanges(); Console.WriteLine("Successfully Deleted"); }
public void listofDrug() { HospitaldatabaseContext hp = new HospitaldatabaseContext(); Console.WriteLine("Enter patient name To Find the Drug"); string name = Console.ReadLine(); var druglist = hp.PatientDrugTables.Include(s => s.Patient).Include(s => s.Drug).Where(s => s.Patient.PatientName == name); Console.WriteLine("============List Of drug ======================="); foreach (var item in druglist) { Console.WriteLine($"Drug List :- {item.Drug.DrugName} "); } }
public void reportofpatient() { HospitaldatabaseContext hp = new HospitaldatabaseContext(); var data = hp.PatientDetails.Include(p => p.Doctor); foreach (var item in data) { Console.WriteLine("================Report====================="); Console.WriteLine($"Patient Id :- {item.PatientId}"); Console.WriteLine($"Patinent name :- {item.PatientName}"); Console.WriteLine($"Patient Condition :- {item.Patentcondition}"); Console.WriteLine("Dieses Name :- " + item.DiseaseName); Console.WriteLine($"Doctor Name :- {item.Doctor.DoctorName}"); Console.WriteLine($"Docor Exprience :- {item.Doctor.Experience}"); // Console.WriteLine($"Department :- {item.Doctor.Department.DepartmentName}"); } }
public void patientDetails() { HospitaldatabaseContext hp = new HospitaldatabaseContext(); Console.WriteLine("Enter Doctor Name :-"); string docName = Console.ReadLine(); var patientdata = hp.PatientDetails.Include(s => s.Doctor).Where(s => s.Doctor.DoctorName == docName); foreach (var item in patientdata) { Console.WriteLine($"Assind Doctor Name :- {item.Doctor.DoctorName}"); Console.WriteLine($"PatientId :- {item.PatientId}"); Console.WriteLine($"PatientName :- {item.PatientName}"); Console.WriteLine($"Patient Condition :- {item.Patentcondition}"); Console.WriteLine($"Dieses Name :- {item.DiseaseName}"); } }
public void insertDoctor() { HospitaldatabaseContext hp = new HospitaldatabaseContext(); Console.WriteLine("Enter Doctor Id"); int id = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Doctor Name"); string dname = Console.ReadLine(); Console.WriteLine("Enter salary"); int sal = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Eprience"); int exp = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Department"); string dep = Console.ReadLine(); var depid = hp.Departments.Single(s => s.DepartmentName == dep); List <Doctor> doc = new List <Doctor>() { new Doctor() { DoctorName = dname, Experience = exp, DoctorId = id, Salary = sal, DepartmentId = depid.DepartmentId } }; foreach (var item in doc) { hp.Add(item); } hp.SaveChanges(); Console.WriteLine("Register New Doctor"); }
public void UpdateDoctor() { HospitaldatabaseContext hp = new HospitaldatabaseContext(); Console.WriteLine("Enter Doctor You Want To Update"); string dname = Console.ReadLine(); var updoc = hp.Doctors.Single(s => s.DoctorName == dname); Console.WriteLine("Enter new Doctor name"); updoc.DoctorName = Console.ReadLine(); Console.WriteLine("Enter new Doctor salary"); updoc.Salary = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter New Experience"); updoc.Salary = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter new Department"); var dep = Console.ReadLine(); var department = hp.Departments.Single(s => s.DepartmentName == dep); updoc.DepartmentId = department.DepartmentId; hp.SaveChanges(); Console.WriteLine("Successfully Updated"); }
public CrudOperationRepository(HospitaldatabaseContext ctx) { context = ctx; }
public ViewInfoRepository(HospitaldatabaseContext ctx) { context = ctx; }