Exemplo n.º 1
0
        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");
            }
        }
Exemplo n.º 2
0
        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");
        }
Exemplo n.º 3
0
        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");
        }
Exemplo n.º 4
0
        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");
        }