public string DeleteDoctor(int Id) { var data = context.Doctors.SingleOrDefault(s => s.DoctorId == Id); if (data != null) { context.Doctors.Remove(data); context.SaveChanges(); return("Data is succssfully deleted"); } else { return("Please check your Detalis"); } }
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 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"); }