public ActionResult Create([Bind(Include = "pid,PatientId,pname,SurName,Gender,Appointment,AppointmentTime,ContactNumber,DOB,Religion,EthnicOrigin,Maritalstatus,NextOfKin,MedicalCard,Occupation,Address,Gpname,Status,cid")] SecClass1 secClass1)
{
try
{
int PatientId = db.SecClass1s.Max(u => u.PatientId);
//int PatientId = 100;
ViewBag.pid = PatientId + 1;
if (ModelState.IsValid)
{
db.SecClass1s.Add(secClass1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.cid = new SelectList(db.Consultants, "cid", "cname", secClass1.cid);
}
catch (Exception e1)
{
ViewBag.err1 = "User Already Exists"; ViewBag.err2 = e1.Message.ToString();
//int PatientId = db.SecClass1s.Max(u => u.PatientId);
int PatientId = 100;
ViewBag.pid = PatientId + 1;
if (ModelState.IsValid)
{
db.SecClass1s.Add(secClass1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.cid = new SelectList(db.Consultants, "cid", "cname", secClass1.cid);
}
return(View(secClass1));
}
public ActionResult DeleteConfirmed(int id)
{
SecClass1 secClass1 = db.SecClass1s.Find(id);
db.SecClass1s.Remove(secClass1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "pid,PatientId,pname,SurName,Gender,Appointment,AppointmentTime,ContactNumber,DOB,Religion,EthnicOrigin,Maritalstatus,NextOfKin,MedicalCard,Occupation,Address,Gpname,Status,cid")] SecClass1 secClass1)
{
try
{
if (ModelState.IsValid)
{
object o17 = secClass1.Status; string oo17 = o17.ToString();
if (oo17 == "Enquiry")
{
db.Entry(secClass1).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
object o8 = secClass1.cid;
string oo8 = o8.ToString();
int ooo8 = Convert.ToInt32(oo8);
string sc = (from s in db1.Consultants where s.cid == ooo8 select s.cname).First().ToString();
NurseClass1 nc1 = new NurseClass1();
//nc1.npid = secClass1.pid;
nc1.PatientId = secClass1.PatientId;
nc1.pname = secClass1.pname;
nc1.Appointment = Convert.ToString(secClass1.Appointment);
nc1.AppointmentTime = Convert.ToString(secClass1.AppointmentTime.ToString("hh:mm"));
nc1.DOB = secClass1.DOB.ToString();
nc1.Gender = Convert.ToString(secClass1.Gender);
nc1.PastMedicalHistory = "Nil";
nc1.cname = sc;
db2.NurseClass1s.Add(nc1); //nurse save
db2.SaveChanges(); //nurse save
db.Entry(secClass1).State = EntityState.Modified; //sec save
db.SaveChanges(); //sec save
return(RedirectToAction("Index"));
}
}
ViewBag.cid = new SelectList(db.Consultants, "cid", "cname", secClass1.cid);
}
catch (Exception e1) { ViewBag.err1 = "Error"; ViewBag.err2 = e1.Message.ToString(); }
return(View(secClass1));
}
// GET: SecClass1/Details/5
public ActionResult Details(int?id)
{
ViewBag.user = Session["uns"];
ViewBag.role = Session["rol"];
if ((Session["uns"] == null) || (Session["rol"].ToString() == "Admin") || (Session["rol"].ToString() == "Nurse") || (Session["rol"].ToString() == "Consultant"))
{
return(RedirectToAction("LoginPage", "LogClass1"));
}
else
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SecClass1 secClass1 = db.SecClass1s.Find(id);
if (secClass1 == null)
{
return(HttpNotFound());
}
return(View(secClass1));
}
}
public ActionResult Edit([Bind(Include = "fid,PatientId,pname,Appointment,AppointmentTime,DOB,Gender,Status,cname")] FollowClass1 followClass1)
{
// try
// {
object o17 = followClass1.Status; string oo17 = o17.ToString();
if (ModelState.IsValid)
{
if (oo17 == "Followup_Inbox")
{
db.Entry(followClass1).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
SecClass1 sc1 = new SecClass1();
//int PatientIdx = db2.SecClass1s.Max(u => u.PatientId);
sc1.PatientId = followClass1.PatientId;
sc1.pname = followClass1.pname;
sc1.Appointment = followClass1.Appointment;
sc1.AppointmentTime = Convert.ToDateTime(followClass1.AppointmentTime);
sc1.DOB = followClass1.DOB;
if (followClass1.Gender == "Male")
{
sc1.Gender = Gender.Male;
}
if (followClass1.Gender == "Female")
{
sc1.Gender = Gender.Female;
}
object o8 = followClass1.cname;
string oo8 = o8.ToString();
string sc = (from s in db1.Consultants where s.cname == oo8 select s.cid).First().ToString();
sc1.cid = Convert.ToInt32(sc);
string surname = (from s1 in db2.SecClass1s where s1.PatientId == followClass1.PatientId select s1.SurName).First().ToString();
sc1.SurName = surname.ToString();
string religion = (from s1 in db2.SecClass1s where s1.PatientId == followClass1.PatientId select s1.Religion).First().ToString();
if (religion == "Christian")
{
sc1.Religion = Religion.Christian;
}
if (religion == "Hindu")
{
sc1.Religion = Religion.Hindu;
}
if (religion == "Muslim")
{
sc1.Religion = Religion.Muslim;
}
string ethinic = (from s1 in db2.SecClass1s where s1.PatientId == followClass1.PatientId select s1.EthnicOrigin).First().ToString();
if (ethinic == "African")
{
sc1.EthnicOrigin = EthiniOrigin.African;
}
if (ethinic == "Asian")
{
sc1.EthnicOrigin = EthiniOrigin.Asian;
}
if (ethinic == "European")
{
sc1.EthnicOrigin = EthiniOrigin.European;
}
if (ethinic == "Indian")
{
sc1.EthnicOrigin = EthiniOrigin.Indian;
}
string marital = (from s1 in db2.SecClass1s where s1.PatientId == followClass1.PatientId select s1.Maritalstatus).First().ToString();
if (marital == "Divorce")
{
sc1.Maritalstatus = Marital.Divorce;
}
if (marital == "Married")
{
sc1.Maritalstatus = Marital.Married;
}
if (marital == "Single")
{
sc1.Maritalstatus = Marital.Single;
}
if (marital == "Widow")
{
sc1.Maritalstatus = Marital.Widow;
}
string mobile = (from s1 in db2.SecClass1s where s1.PatientId == followClass1.PatientId select s1.ContactNumber).First().ToString();
sc1.ContactNumber = mobile.ToString();
db2.SecClass1s.Add(sc1);
db2.SaveChanges(); //data send to secretary
db.Entry(followClass1).State = EntityState.Modified;
db.SaveChanges(); // update to followup
return(RedirectToAction("Index"));
}
}
//}
//catch (Exception e1) { ViewBag.err2 = e1.Message.ToString(); }
return(View(followClass1));
//if (ModelState.IsValid)
//{
// db.Entry(followClass1).State = EntityState.Modified;
// db.SaveChanges();
// return RedirectToAction("Index");
//}
//return View(followClass1);
}
