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");
}
