// // GET: /Opd/ public ActionResult Opd() { HospitalAppEntities2 db = new HospitalAppEntities2(); List<Patient_Basic_Info> PBI = db.Patient_Basic_Info.ToList(); return View(PBI); }
//Detail VIew for Rescipt called from OPD View just Searches on non PK public ActionResult Basic_Rescipt_Detail(int id) { HospitalAppEntities2 db = new HospitalAppEntities2(); Rescipt_info user = db.Rescipt_info.FirstOrDefault(o => o.patient_id == id); if (user == null) { return RedirectToAction("Empty", "Opd", new { id = id}); } else return View(user); }
public ActionResult User_Create(appUser AU) { HospitalAppEntities2 db = new HospitalAppEntities2(); if(ModelState.IsValid) { db.appUsers.Add(AU); db.SaveChanges(); return RedirectToAction("adminView"); } return View(); }
public ActionResult Edit(Patient_Basic_Info PBI) { if(ModelState.IsValid) { HospitalAppEntities2 db = new HospitalAppEntities2(); db.Entry(PBI).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("OpdView", "Opd"); } return View(PBI); }
//Detail View for Rescipt if called from anywhere in the project searches through PK public ActionResult Patient_Rescipt_Detail(int id) { HospitalAppEntities2 db = new HospitalAppEntities2(); Rescipt_info RI = db.Rescipt_info.Find(id); return View(RI); }
public ActionResult Edit(int id) { HospitalAppEntities2 db = new HospitalAppEntities2(); Patient_Basic_Info PBI = db.Patient_Basic_Info.Find(id); return View(PBI); }
public ActionResult ResidentialView() { HospitalAppEntities2 db = new HospitalAppEntities2(); List<Residential_info> RI = db.Residential_info.ToList(); return View(RI); }
public ActionResult Patient_Basic_Create(Patient_Basic_Info PBI) { if(ModelState.IsValid) { HospitalAppEntities2 db = new HospitalAppEntities2(); db.Patient_Basic_Info.Add(PBI); db.SaveChanges(); // Patient_Basic_Info = PBI; //MIP.patientBasicInfo = PBI; return RedirectToAction("Patient_Resident_Create", "Opd"); } return View(); }
public bool LoginMe(string userName,string password) { HospitalAppEntities2 db = new HospitalAppEntities2(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = "data source=.;initial catalog=HospitalApp;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework""; conn.Open(); SqlCommand command = new SqlCommand(String.Format("SELECT Name, userPassword,roleID FROM appUser WHERE Name ='{0}'", userName, conn)); command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { if (reader.GetValue(0).ToString() == userName && reader.GetValue(1).ToString() == password) { Role=Convert.ToInt32(reader.GetValue(2)); return true; } } else { conn.Close(); return false; } } return false; }
public ActionResult Patient_Resident_Create(Residential_info RI) { HospitalAppEntities2 db = new HospitalAppEntities2(); if (ModelState.IsValid) { //MIP.residentInfo = RI; db.Residential_info.Add(RI); db.SaveChanges(); return RedirectToAction("Patient_Rescipt_Create", "Opd"); } return View(); }
public ActionResult User_Edit(appUser AU) { if (ModelState.IsValid) { HospitalAppEntities2 db = new HospitalAppEntities2(); db.Entry(AU).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("adminView", "Account"); } return View(); }
public ActionResult User_Edit(int id) { HospitalAppEntities2 db = new HospitalAppEntities2(); appUser AU = db.appUsers.Find(id); return View(AU); }
public ActionResult role() { HospitalAppEntities2 db = new HospitalAppEntities2(); List<Role> role = db.Roles.ToList(); return View(role); }
public ActionResult adminView() { HospitalAppEntities2 db = new HospitalAppEntities2(); List<appUser> users = db.appUsers.ToList(); return View(users); }
//Detail view for resident id called from anywhere in project searches from PK public ActionResult Patient_Resident_Edit(int id) { HospitalAppEntities2 db = new HospitalAppEntities2(); Residential_info RI = db.Residential_info.Find(id); return View(RI); }
public ActionResult Patient_Rescipt_Create(Rescipt_info RI) { if(ModelState.IsValid) { HospitalAppEntities2 db = new HospitalAppEntities2(); db.Rescipt_info.Add(RI); db.SaveChanges(); //Rescipt_info = RI; //MIP.resciptInfo = RI; //MIP.DatabasePunching(); return RedirectToAction("OpdView", "Opd"); } return View(); }
public ActionResult Patient_Resident_Edit(Residential_info RI) { if(ModelState.IsValid) { HospitalAppEntities2 db = new HospitalAppEntities2(); db.Entry(RI).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("OpdView", "Opd"); } return View(); }
public ActionResult User_Delete(appUser AU) { if(ModelState.IsValid) { HospitalAppEntities2 db = new HospitalAppEntities2(); appUser AUanother = db.appUsers.Find(AU.userID); db.appUsers.Remove(AUanother); db.SaveChanges(); return RedirectToAction("adminView", "Account"); } return View(); }