public void assignAssistant()
{
using (var context = new HospitalManagementContext())
{
Console.WriteLine("Enter Patient Name:");
string pname = Console.ReadLine();
var appoint = context.Appointments.Single(b => b.PatientName == pname);
int appointid = appoint.AppointmentId;
Console.WriteLine("Enter AssistantName:");
string assist = Console.ReadLine();
var assistant = context.HealthAssistants.Single(b => b.AssistantName == assist);
int assistid = assistant.AssistantId;
var assignAssistants = new AssignAssistants()
{
AssistantId = assistid,
AppointmentId = appointid,
};
context.AssignAssistants.Add(assignAssistants);
context.SaveChanges();
}
}
public void AssignAssistant()
{
using (var HospitalMgmt = new HospitalManagementDbContext())
{
int assistantid, appoinmentId;
Console.WriteLine("Enter assistantid you want to assign");
assistantid = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter AppointmentId in which you assign assistant");
appoinmentId = Convert.ToInt32(Console.ReadLine());
var assignassistant = new AssignAssistants
{
AssistantId = assistantid,
AppointmentId = appoinmentId
};
HospitalMgmt.AssignAssistants.Add(assignassistant);
HospitalMgmt.SaveChanges();
Console.WriteLine(" Successfully Assigned HealthCare Assistant");
}
}