public PatientMaster GetPatientById(string userName) { AspNetUser user = _dbContext.AspNetUsers.SingleOrDefault(x => x.UserName == userName); PatientMaster patientMaster = _dbContext.PatientMasters.SingleOrDefault(x => x.UserLoginDetailsId == user.Id); return(patientMaster); }
public string CheckPatient(string PtCode) { try { GBCCon con = new GBCCon(); PatientMaster obj_C = con.db_patient.SingleOrDefault(p => p.PtCode == PtCode); if (obj_C == null) { return("0"); } else { ServiceReg obj = con.db_SerReg.SingleOrDefault(p => p.Pcode == obj_C.PCODE); if (obj == null) { return(obj_C.ServicePath + "|" + "" + "|" + "" + "|" + obj_C.PtName + "|" + obj_C.PtCode + "|" + obj_C.PhNo + "|" + obj_C.Email + "|" + obj_C.Address + "|" + obj_C.DeviceId + "|" + obj_C.StCode + "|" + obj_C.CtCode + "|" + obj_C.Area + "|" + obj_C.FDocName + "|" + obj_C.FDocCode); } else { return(obj_C.ServicePath + "|" + obj.Name + "|" + obj.Pcode + "|" + obj_C.PtName + "|" + obj_C.PtCode + "|" + obj_C.PhNo + "|" + obj_C.Email + "|" + obj_C.Address + "|" + obj_C.DeviceId + "|" + obj_C.StCode + "|" + obj_C.CtCode + "|" + obj_C.Area + "|" + obj_C.FDocName + "|" + obj_C.FDocCode); } } } catch (Exception ex) { return("$" + ex.Message); } }
public ActionResult Save(PatientMaster patient) { if (!ModelState.IsValid) { var viewModel = new PatientFormViewModel { Patient = patient, MembershipTypes = _context.MembershipTypes.ToList() }; return(View("PatientForm", viewModel)); } if (patient.Id == 0) { _context.Patients.Add(patient); } else { var patientInDb = _context.Patients.Single(c => c.Id == patient.Id); patientInDb.Name = patient.Name; patientInDb.Birthdate = patient.Birthdate; patientInDb.MembershipTypeId = patient.MembershipTypeId; patientInDb.IsSubscribedToNewsletter = patient.IsSubscribedToNewsletter; } _context.SaveChanges(); return(RedirectToAction("Index", "Patients")); }
public void AddPatient(UsersModel model) { if (!string.IsNullOrEmpty(model.loginId)) { PatientMaster patient = new PatientMaster { EmailId = model.Email, FirstName = model.FirstName, LastName = model.LastName, Dob = model.DOB, IsActive = true, //by Default UserLoginDetailsId = model.loginId, //CreatedBy = model.CreatedBy, ModifiedBy = model.UpdatedBy, CreatedOn = DateTime.Now, ModifiedOn = DateTime.Now, Gender = model.Gender, Address = model.Address, //ContactNumber = model.PhoneNumber, Age = AgeCalculator(model.DOB), PatientDisplayId = GetPatientId(), Title = model.Title, City = model.City, PhoneNo = model.ContactNo, }; ctx.PatientMasters.Add(patient); ctx.SaveChanges(); } else { throw new Exception("User not registered."); } }
public DataBaseResultSet SavePatientMaster <T>(T objData) where T : class, IModel, new() { PatientMaster obj = objData as PatientMaster; string sQuery = "sprocPatientMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("PatientCode", "PatientCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.PatientCode)); list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode)); list.Add(SqlConnManager.GetConnParameters("PatientName", "PatientName", 50, GenericDataType.String, ParameterDirection.Input, obj.PatientName)); list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 50, GenericDataType.String, ParameterDirection.Input, obj.Add1)); list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone1)); list.Add(SqlConnManager.GetConnParameters("Email", "Email", 50, GenericDataType.String, ParameterDirection.Input, obj.Email)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode)); list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public async Task <IActionResult> CreatePatient(PatientMaster model) { if (model.Id > 0) { var response = await _IPatientRepo.Update(model); if (response == Common.ResponseStatus.UpdatedSuccessFully) { return(Ok("Patient updated Successfully")); } return(BadRequest("Error patient updation. Please contact Admin Department")); } else { var response = await _IPatientRepo.CreateEntity(model); if (response == Common.ResponseStatus.AddedSuccessfully) { return(Ok("Patient Created Successfully")); } return(BadRequest("Error patient creation. Please contact Admin Department")); } }
public DemographicData GetDemographicById(string userName) { AspNetUser user = _dbContext.AspNetUsers.SingleOrDefault(x => x.UserName == userName); int patientId = _dbContext.PatientMasters.Where(x => x.UserLoginDetailsId == user.Id).SingleOrDefault().Id; PatientMaster patientMaster = _dbContext.PatientMasters.SingleOrDefault(x => x.Id == patientId); PatientEmergencyContact patientEmergencyContact = _dbContext.PatientEmergencyContacts.SingleOrDefault(x => x.PatientId == patientId); DemographicData data = new DemographicData(); if (patientEmergencyContact != null) { data = new DemographicData { id = patientEmergencyContact.Id, patientid = patientMaster.Id, race = patientMaster.Race, ethnicity = patientMaster.Ethnicity, languagesKnown = patientMaster.LanguagesKnown, address = patientMaster.Address, nomineeFirstName = patientEmergencyContact.FirstName, nomineeLastName = patientEmergencyContact.LastName, nomineeAddress = patientEmergencyContact.Address, nomineeEmail = patientEmergencyContact.Email, nomineeContact = patientEmergencyContact.ContactNumber, nomineeRelationship = patientEmergencyContact.Relationship, isNeedportalAccess = patientEmergencyContact.AccessPatientPortal }; } return(data); }
public ActionResult Registration(PatientMaster obj, string SubmitBtn) { obj.CMD = SubmitBtn == "Save" ? "Save" : SubmitBtn == "Update" ? "Update" : "Delete"; obj.hid = Convert.ToInt32(Session["hospital"].ToString()); switch (obj.CMD) { case "Save": obj.hid = Convert.ToInt32(Session["hospital"].ToString()); string[] str = obj.PerformAction(); ViewBag.msg = str[1]; return(View("Registration", obj)); case "Update": string[] str1 = obj.PerformAction(); ViewBag.msg = str1[2]; return(View("Registration", obj)); case "Delete": string[] str2 = obj.PerformAction(); ViewBag.msg = str2[3]; return(View("Registration", obj)); default: return(View(obj)); } }
public PatientFormViewModel(PatientMaster patient) { Id = patient.Id; Name = patient.Name; Address = patient.AddressMaster; Gender = patient.Gender; IsSubscribedToNewsletter = patient.IsSubscribedToNewsletter; }
public ActionResult DeleteConfirmed(int id) { PatientMaster patientMaster = db.PatientMasters.Find(id); db.PatientMasters.Remove(patientMaster); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddorEdit(PatientMaster pat) { using (Models.DemoCorePatientEntities db = new DemoCorePatientEntities()) { db.PatientMasters.Add(pat); db.SaveChanges(); } return(Redirect(Url.Action("ViewAll") + "#firsttab")); }
public ActionResult Update(PatientMaster obj, string SubmitBtn) { Registration(obj, SubmitBtn); if (SubmitBtn == "Delete") { return(Redirect("~/Patient/PatientDetails")); } return(View("Registration", obj)); }
/// <summary> /// Insert a PatientMaster /// </summary> /// <param name="PatientMaster">PatientMaster</param> public void InsertPatientMaster(PatientMaster patientMaster) { if (patientMaster == null) { throw new ArgumentNullException(nameof(patientMaster)); } _patientMasterRepository.Insert(patientMaster); }
/// <summary> /// Updates the PatientMaster /// </summary> /// <param name="PatientInfo">PatientInfo</param> public void UpdatePatientMaster(PatientMaster patientMaster) { if (patientMaster == null) { throw new ArgumentNullException(nameof(patientMaster)); } _patientMasterRepository.Update(patientMaster); }
public void GetListPatientMaster <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListPatientMaster"; PatientMaster objData = objFilter as PatientMaster; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("PatientCode", "PatientCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.PatientCode)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillPatientMasterDataFromReader, ref listData); }
public ResultModel AddPatientDemographicData(string userName, DemographicData demographicData) { ResultModel rs = new ResultModel(); AspNetUser user = _dbContext.AspNetUsers.SingleOrDefault(x => x.UserName == userName); PatientMaster patientMaster = _dbContext.PatientMasters.SingleOrDefault(x => x.UserLoginDetailsId == user.Id); if (patientMaster != null) { patientMaster.Race = demographicData.race; patientMaster.Ethnicity = demographicData.ethnicity; patientMaster.Address = demographicData.address; patientMaster.LanguagesKnown = demographicData.languagesKnown; patientMaster.ModifiedOn = DateTime.Now; _dbContext.SaveChanges(); rs.Code = 1; } PatientEmergencyContact patientEmergencyContact = _dbContext.PatientEmergencyContacts.SingleOrDefault(x => x.PatientId == patientMaster.Id); if (patientEmergencyContact == null) { PatientEmergencyContact patientEmergencyContact1 = new PatientEmergencyContact { FirstName = demographicData.nomineeFirstName, LastName = demographicData.nomineeLastName, Email = demographicData.nomineeEmail, Relationship = demographicData.nomineeRelationship, ContactNumber = demographicData.nomineeContact, PatientId = patientMaster.Id, Address = demographicData.nomineeAddress, AccessPatientPortal = demographicData.isNeedportalAccess, CreatedOn = DateTime.Now, ModifiedOn = DateTime.Now, IsActive = true }; _dbContext.PatientEmergencyContacts.Add(patientEmergencyContact1); _dbContext.SaveChanges(); rs.Code = 1; rs.Response = "Demographic data saved successfully"; } else { patientEmergencyContact.FirstName = demographicData.nomineeFirstName; patientEmergencyContact.LastName = demographicData.nomineeLastName; patientEmergencyContact.Email = demographicData.nomineeEmail; patientEmergencyContact.Relationship = demographicData.nomineeRelationship; patientEmergencyContact.ContactNumber = demographicData.nomineeContact; patientEmergencyContact.PatientId = patientMaster.Id; patientEmergencyContact.Address = demographicData.nomineeAddress; patientEmergencyContact.AccessPatientPortal = demographicData.isNeedportalAccess; patientEmergencyContact.ModifiedOn = DateTime.Now; patientEmergencyContact.IsActive = true; _dbContext.SaveChanges(); rs.Code = 1; rs.Response = "Demographic data saved successfully"; } return(rs); }
public PatientViewModel(PatientMaster patientMaster) { if (patientMaster != null) { Id = patientMaster.Id; Name = patientMaster.Name; Email = patientMaster.Email; Active = patientMaster.Active; } }
private void FillPatientMasterDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new() { while (DbReader.Read()) { T obj = new T(); PatientMaster objData = obj as PatientMaster; obj.FillDataFromDB(DbReader); listData.Add(obj); } }
public ActionResult SetAppointment(int pid) { PatientMaster obj = new PatientMaster(); if (pid > 0) { Session["PatientId"] = pid; //hold only session id Session["PatientObj"] = obj = obj.GetSinglePatient(pid, Convert.ToInt32(Session["hospital"].ToString())); //hold whole patient details } return(RedirectToAction("Appointment", "Patient", obj)); }
public ActionResult Edit([Bind(Include = "PatientId,PatientName,PatientAge,Gender,DateOfRegister,Mobile,Address")] PatientMaster patientMaster) { patientMaster.DateOfRegister = DateTime.Now; if (ModelState.IsValid) { db.Entry(patientMaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(patientMaster)); }
public async Task <IActionResult> CreatePatient(PatientMaster model) { var response = await _IPatientRepo.CreateEntity(model); if (response == Common.ResponseStatus.AddedSuccessfully) { return(Ok("Patient Created Successfully")); } return(Ok("Unable to Create Patient")); }
public ViewResult Update(int patientid) { PatientMaster obj = new PatientMaster(); if (patientid > 0) { obj.CMD = "Update"; obj = obj.GetSinglePatient(patientid, Convert.ToInt32(Session["hospital"].ToString())); } return(View("Registration", obj)); }
public ActionResult Select(int patientid) { PatientMaster obj = new PatientMaster(); if (patientid > 0) { Session["PatientId"] = patientid; //hold only session id Session["PatientObj"] = obj = obj.GetSinglePatient(patientid, Convert.ToInt32(Session["hospital"].ToString())); //hold whole patient details } return(RedirectToAction("Dashboard", "Home")); }
public ActionResult Create([Bind(Include = "PatientId,PatientName,PatientAge,Gender,DateOfRegister,Mobile,Address")] PatientMaster patientMaster) { patientMaster.DateOfRegister = DateTime.Now; if (ModelState.IsValid) { db.PatientMasters.Add(patientMaster); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(patientMaster)); }
public JsonResult Update(PatientMaster patient) { var pat = patDB.PatientMasters.Where(j => j.ID == patient.ID).FirstOrDefault(); pat.MRN = patient.MRN; pat.PatientName = patient.PatientName; pat.Sex = patient.Sex; pat.Age = patient.Age; pat.City = patient.City; patDB.SaveChanges(); return(Json(pat)); }
public ActionResult PatientDetails() { PatientMaster obj = new PatientMaster(); DBConnection cn = new DBConnection(); obj.CMD = "View"; obj.hid = Convert.ToInt32(Session["hospital"].ToString()); string xml = Common.ToXML(obj); DataSet dataset = cn.ExecuteProcedure("SP_PatientView", xml); return(View(dataset)); }
public PatientMaster GetPtData(string PtCode) { try { GBCCon con = new GBCCon(); PatientMaster obj = con.db_patient.SingleOrDefault(p => p.PtCode == PtCode); return(obj); } catch { return(null); } }
// GET: PatientMasters/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PatientMaster patientMaster = db.PatientMasters.Find(id); if (patientMaster == null) { return(HttpNotFound()); } return(View(patientMaster)); }
public ActionResult PDFForPatient(int patientID) { MbprosEntities en = new MbprosEntities(); //get the patient data with matching patient id PatientMaster objPatient = en.PatientMasters.Where(x => x.PatientID == patientID).FirstOrDefault(); if (objPatient != null) { //Generates pdf for the patient data using PDFForPatient view. //return new Rotativa.ViewAsPdf("PDFForPatient", objPatient) { FileName = "PatientInformation.pdf" }; return(new Rotativa.ViewAsPdf("PDFForPatient", objPatient)); // return View(objPatient); } return(View(objPatient)); }
public string UpdatePtArea(string PtCode, string area) { try { GBCCon con = new GBCCon(); PatientMaster obj = con.db_patient.SingleOrDefault(p => p.PtCode == PtCode); obj.Area = area; con.SaveChanges(); return(""); } catch { return("$"); } }