public JsonResult InsertDoctor(Doctor doctor)
{
int value = 0;
var temp = doctor.BirthDate;
using (HospitalEntities2 entities = new HospitalEntities2())
{
doctor.BirthDate = doctor.BirthDate.ToString();
/* int temp = doctor.Degree;
* var id = (from c in entities.Expertises
* where c.ExpertiseID == doctor.Degree
* select c.ExpertiseID).FirstOrDefault();
* doctor.Degree = id; */
value = int.Parse(entities.Doctors
.OrderByDescending(p => p.DoctorID)
.Select(r => r.DoctorID)
.First().ToString());
if (doctor.DoctorID == 0)
{
doctor.DoctorID = value + 1;
}
entities.Doctors.Add(doctor);
entities.SaveChanges();
// doctor.Degree = temp;
}
//Doctor newdoctor = db.Doctors.Find(value + 1);
doctor.BirthDate = temp;
return(Json(doctor, JsonRequestBehavior.AllowGet));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
HospitalEntities2 Hos = new HospitalEntities2();
foreach (var role in Hos.Roles)
{
if (role.Username == TxtID.Text && role.Password == TxtPassword.Text && role.Type == "Doctor")
{
Server.Transfer("DoctorPage.aspx");
break;
}
else if (role.Username == TxtID.Text && role.Password == TxtPassword.Text && role.Type == "Nurse")
{
Server.Transfer("Nurse.aspx");
break;
}
else if (role.Username == TxtID.Text && role.Password == TxtPassword.Text && role.Type == "Receptionist")
{
Server.Transfer("Patient Registration.aspx");
break;
}
else if (role.Username == TxtID.Text && role.Password == TxtPassword.Text && role.Type == "Admin")
{
Server.Transfer("Admin.aspx");
break;
}
}
}
public ActionResult DoctorList()
{
HospitalEntities2 entities = new HospitalEntities2();
List <Doctor> doctors = entities.Doctors.ToList();
List <Expertise> expertises = entities.Expertises.ToList();
dynamic mymodel = new ExpandoObject();
/*foreach (var doctor in doctors)
* {
*
* String degree = (from c in entities.Expertises
* where c.ExpertiseID == doctor.Degree
* select c.Speciality).FirstOrDefault();
* if (degree == null) continue;
* // mymodel.Degree = degree;
* }*/
//Add a Dummy Row.
doctors.Insert(0, new Doctor());
mymodel.doctors = doctors;
mymodel.expertises = expertises;
if (User.IsInRole("Admin"))
{
return(View(mymodel));
}
return(View("alt_doctor", mymodel));
//return View(doctors);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HospitalEntities2 Hos = new HospitalEntities2();
string value = DDLWID.SelectedValue.ToString();
string PatId = "";
foreach (var Wear in Hos.wearables)
{
if (Wear.ID.ToString() == value)
{
PatId = Wear.patient_ID.ToString();
}
}
//pa.Patient_State = TxtLastDiag.Text;
foreach (var patient in Hos.Patients)
{
if (patient.ID.ToString() == PatId)
{
var stud = Hos.Patients.FirstOrDefault(c => c.ID == patient.ID);
stud.Patient_State = TxtLastDiag.Text;
Hos.SaveChanges();
TxtLastDiag.ReadOnly = true;
}
}
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
wearable wear = new wearable();
wear.Name = TxtWearableID.Text;
wear.Password = TxtWearablePassword.Text;
HospitalEntities2 Con = new HospitalEntities2();
Con.wearables.Add(wear);
Con.SaveChanges();
if (Con.SaveChanges() == 0)
{
LblWarn.ForeColor = System.Drawing.Color.Green;
LblWarn.Text = "Add Successfull";
TxtWearableID.Text = "";
TxtWearablePassword.Text = "";
}
else
{
LblWarn.ForeColor = System.Drawing.Color.Red;
LblWarn.Text = "Adding Failed";
}
}
protected void BtnConnect_Click(object sender, EventArgs e)
{
HospitalEntities2 Hos = new HospitalEntities2();
wearable wear = new wearable();
foreach (var patient in Hos.Patients)
{
if (patient.National_Id == TxtSearch.Text)
{
foreach (var Wear_patient in Hos.wearables)
{
if (Wear_patient.ID.ToString() == TxtWearableID.Text && Wear_patient.Password == TxtWearablePassword.Text)
{
Wear_patient.patient_ID = patient.ID;
wear.patient_ID = patient.ID;
Hos.SaveChanges();
}
}
}
else
{
LblResult.ForeColor = System.Drawing.Color.Red;
LblResult.Text = "Not Connected";
}
}
}
public ActionResult DeleteExpertise(int expertiseId)
{
using (HospitalEntities2 entities = new HospitalEntities2())
{
Expertise expertise = (from c in entities.Expertises
where c.ExpertiseID == expertiseId
select c).FirstOrDefault();
entities.Expertises.Remove(expertise);
entities.SaveChanges();
}
return(new EmptyResult());
}
// My code starts here
public ActionResult ExpertiseList()
{
HospitalEntities2 entities = new HospitalEntities2();
List <Expertise> expertises = entities.Expertises.ToList();
//Add a Dummy Row.
expertises.Insert(0, new Expertise());
if (User.IsInRole("Admin"))
{
return(View(expertises));
}
return(View("alt_expertise", expertises));
}
public ActionResult DeleteDoctor(int doctorId)
{
using (HospitalEntities2 entities = new HospitalEntities2())
{
Doctor doctor = (from c in entities.Doctors
where c.DoctorID == doctorId
select c).FirstOrDefault();
entities.Doctors.Remove(doctor);
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateExpertise(Expertise expertise)
{
using (HospitalEntities2 entities = new HospitalEntities2())
{
Expertise updatedExpertise = (from c in entities.Expertises
where c.ExpertiseID == expertise.ExpertiseID
select c).FirstOrDefault();
updatedExpertise.Speciality = expertise.Speciality;
entities.SaveChanges();
}
return(new EmptyResult());
}
// My code starts here
public ActionResult newIndex()
{
HospitalEntities2 entities = new HospitalEntities2();
List <Doctor> doctors = entities.Doctors.ToList();
foreach (var doctor in doctors)
{
var a = (from c in entities.Expertises
where c.ExpertiseID == doctor.Degree
select c.Speciality).FirstOrDefault();
}
//Add a Dummy Row.
doctors.Insert(0, new Doctor());
return(View(doctors));
}
public ActionResult viewDetails(int?id, int?altId)
{
HospitalEntities2 entities = new HospitalEntities2();
dynamic mymodel = new ExpandoObject();
mymodel.doctors = entities.Doctors.ToList();
mymodel.change = false;
mymodel.altId = null;
if (id == null || id == 0)
{
if (altId != null)
{
mymodel.change = true;
mymodel.altId = altId;
}
mymodel.select = false;
if (User.IsInRole("Admin"))
{
return(View(mymodel));
}
return(View("detailsList", mymodel));
}
Doctor doctor = db.Doctors.Find(id);
var weekday = entities.Weekdays.ToList();
var workdaysid = (from c in entities.DoctorsWorkingDays
where c.DoctorID == id
select c.WeekID).ToList();
var workdays = new List <String>();
foreach (var i in workdaysid)
{
workdays.Add(weekday[i - 1].Name);
}
mymodel.doctor = doctor;
mymodel.weekdays = weekday;
mymodel.workdays = workdays;
mymodel.select = true;
if (User.IsInRole("Admin"))
{
return(PartialView("_schedule", mymodel));
}
return(View("_alt_schedule", mymodel));
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
HospitalEntities2 Hos = new HospitalEntities2();
foreach (var searchID in Hos.Patients)
{
if (searchID.National_Id == TxtSearch.Text)
{
BtnSearch.Enabled = false;
BtnSearch.Text = "Founded";
TxtName.Text = searchID.Name;
TxtNationalID.Text = searchID.National_Id;
TxtAdress.Text = searchID.Adress;
TxtPhone.Text = searchID.Phone;
TxtEmail.Text = searchID.Email;
TxtAge.Text = searchID.Age.ToString();
if (searchID.Gender == true)
{
foreach (ListItem listed in RBGemder.Items)
{
if (listed.Text == "Male")
{
listed.Enabled = true;
}
}
}
else if (searchID.Gender == false)
{
foreach (ListItem listed in RBGemder.Items)
{
if (listed.Text == "Female")
{
listed.Enabled = false;
}
}
}
break;
}
else
{
LblResult.ForeColor = System.Drawing.Color.Red;
LblResult.Text = "Not Found ";
}
}
}
public ActionResult UpdateDoctor(Doctor doctor)
{
using (HospitalEntities2 entities = new HospitalEntities2())
{
Doctor updatedDoctor = (from c in entities.Doctors
where c.DoctorID == doctor.DoctorID
select c).FirstOrDefault();
updatedDoctor.FirstName = doctor.FirstName.Trim();
updatedDoctor.LastName = doctor.LastName.Trim();
updatedDoctor.BirthDate = doctor.BirthDate.ToString().Trim();
updatedDoctor.Degree = doctor.Degree;
//InsertDoctor(updatedDoctor);
entities.SaveChanges();
}
return(new EmptyResult());
}
public JsonResult InsertExpertise(Expertise expertise)
{
int value = -1;
using (HospitalEntities2 entities = new HospitalEntities2())
{
value = int.Parse(entities.Expertises
.OrderByDescending(p => p.ExpertiseID)
.Select(r => r.ExpertiseID)
.First().ToString());
expertise.ExpertiseID = value + 1;
expertise.Speciality = expertise.Speciality.Trim();
entities.Expertises.Add(expertise);
entities.SaveChanges();
}
return(Json(expertise));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Patient patient = new Patient();
patient.Name = TxtName.Text;
patient.Age = Convert.ToInt16(TxtAge.Text);
patient.Adress = TxtAdress.Text;
patient.Email = TxtEmail.Text;
patient.National_Id = TxtNationalID.Text;
string value = RBGemder.SelectedItem.Value.ToString();
if (value == "Male")
{
patient.Gender = true;
}
else
{
patient.Gender = false;
}
HospitalEntities2 Hos = new HospitalEntities2();
Hos.Patients.Add(patient);
Hos.SaveChanges();
if (Hos.SaveChanges() == 0)
{
LblSuccessful.ForeColor = System.Drawing.Color.Green;
LblSuccessful.Text = "Saved Successfully !";
TxtName.Text = "";
TxtPhone.Text = "";
TxtEmail.Text = "";
TxtNationalID.Text = "";
TxtAdress.Text = "";
TxtAge.Text = "";
}
else
{
LblSuccessful.ForeColor = System.Drawing.Color.Red;
LblSuccessful.Text = "Not saved !";
}
}
protected void BtnWearInformation_Click(object sender, EventArgs e)
{
HospitalEntities2 Hos = new HospitalEntities2();
string value = DDLWID.SelectedValue.ToString();
string PatientID = "";
foreach (var Wear in Hos.wearables)
{
if (Wear.ID.ToString() == value)
{
PatientID = Wear.patient_ID.ToString();
}
}
foreach (var patient in Hos.Patients)
{
if (patient.ID.ToString() == PatientID)
{
TxtPatientName.Text = patient.Name;
TxtAge.Text = patient.Age.ToString();
TxtLastDiag.Text = patient.Patient_State;
}
}
Hos.SaveChanges();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
HospitalEntities2 Hos = new HospitalEntities2();
string value = DDLType.SelectedValue.ToString();
if (value == "Doctor")
{
Role type = new Role();
Doctor Doc = new Doctor();
Doc.Name = TxtName.Text;
Doc.phone = TxtPhone.Text;
Doc.National_id = TxtNationalID.Text;
Doc.Email = TxtEmail.Text;
Doc.Address = TxtAdress.Text;
type.Username = TxtUserName.Text;
type.Password = TxtPassword.Text;
type.Type = value;
if (TxtPassword.Text == TxtConfirmPassword.Text)
{
type.Password = TxtPassword.Text;
}
Hos.Doctors.Add(Doc);
Hos.Roles.Add(type);
Hos.SaveChanges();
LblSuccessful.ForeColor = System.Drawing.Color.Green;
LblSuccessful.Text = "Adding Successfull";
}
else if (value == "Nurse")
{
Role type = new Role();
Nurse nurse = new Nurse();
nurse.Name = TxtName.Text;
nurse.phone = TxtPhone.Text;
nurse.National_id = TxtNationalID.Text;
nurse.Email = TxtEmail.Text;
nurse.Address = TxtAdress.Text;
type.Username = TxtUserName.Text;
if (TxtPassword.Text == TxtConfirmPassword.Text)
{
type.Password = TxtPassword.Text;
}
type.Type = value;
Hos.Nurses.Add(nurse);
Hos.Roles.Add(type);
Hos.SaveChanges();
LblSuccessful.ForeColor = System.Drawing.Color.Green;
LblSuccessful.Text = "Adding Successfull";
}
else if (value == "Receptionist")
{
Role type = new Role();
Receptionist Recep = new Receptionist();
Recep.Name = TxtName.Text;
Recep.phone = TxtPhone.Text;
Recep.National_ID = TxtNationalID.Text;
Recep.Email = TxtEmail.Text;
Recep.Address = TxtAdress.Text;
if (TxtPassword.Text == TxtConfirmPassword.Text)
{
type.Password = TxtPassword.Text;
}
type.Username = TxtUserName.Text;
type.Type = value;
Hos.Receptionists.Add(Recep);
Hos.Roles.Add(type);
Hos.SaveChanges();
LblSuccessful.ForeColor = System.Drawing.Color.Green;
LblSuccessful.Text = "Adding Successfull";
}
else if (value == "Admin")
{
Role type = new Role();
type.Username = TxtUserName.Text;
if (TxtPassword.Text == TxtConfirmPassword.Text)
{
type.Password = TxtPassword.Text;
}
type.Type = value;
Hos.Roles.Add(type);
Hos.SaveChanges();
LblSuccessful.ForeColor = System.Drawing.Color.Green;
LblSuccessful.Text = "Adding Successfull";
}
else
{
LblSuccessful.ForeColor = System.Drawing.Color.Red;
LblSuccessful.Text = "Adding Failed";
}
TxtConfirmPassword.Text = "";
TxtAdress.Text = "";
TxtEmail.Text = "";
TxtName.Text = "";
TxtNationalID.Text = "";
TxtPassword.Text = "";
TxtPhone.Text = "";
TxtUserName.Text = "";
}
public ActionResult updateDates(String days1, String days2, String days3, String days4, String days5, String days6, String days7, String doctorID)
{
HospitalEntities2 entities = new HospitalEntities2();
var days = new List <String>();
days.Add(days1); days.Add(days2); days.Add(days3); days.Add(days4);
days.Add(days5); days.Add(days6); days.Add(days7);
var list = new List <int>();
foreach (var day in days)
{
if (day != null)
{
list.Add((from c in entities.Weekdays
where c.Name == day
select c.WeekId).FirstOrDefault());
}
}
for (var i = 1; i <= 7; i++)
{
if (!list.Contains(i))
{
DoctorsWorkingDay dwd = (from c in entities.DoctorsWorkingDays
where c.DoctorID.ToString() == doctorID &&
c.WeekID == i
select c).FirstOrDefault();
if (dwd == null)
{
continue;
}
entities.DoctorsWorkingDays.Remove(dwd);
entities.SaveChanges();
}
}
foreach (var workday in list)
{
DoctorsWorkingDay dwd = (from c in entities.DoctorsWorkingDays
where c.DoctorID.ToString() == doctorID &&
c.WeekID == workday
select c).FirstOrDefault();
if (dwd == null)
{
int value = int.Parse(entities.DoctorsWorkingDays
.OrderByDescending(p => p.Id)
.Select(r => r.Id)
.First().ToString());
entities.DoctorsWorkingDays.Add(new DoctorsWorkingDay()
{
Id = value + 1, DoctorID = Int32.Parse(doctorID), WeekID = workday
});
entities.SaveChanges();
}
}
//Redirect("viewDetails");
dynamic mymodel = new ExpandoObject();
mymodel.doctors = entities.Doctors.ToList();
mymodel.change = false;
mymodel.altId = null;
mymodel.select = false;
return(View("~/Views/Doctors/viewDetails.cshtml", mymodel));
}
