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("$");
}
}
