public Visits GetVisitsData(int id)
{
try
{
Visits visits = new Visits();
using (SqlConnection con = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM Visits WHERE ID_Visit= " + id;
SqlCommand cmd = new SqlCommand(sqlQuery, con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
visits.ID_Visit = Convert.ToInt32(rdr["ID_Visit"]);
visits.ID_Doctor = Convert.ToInt32(rdr["ID_Doctor"]);
visits.ID_Patient = Convert.ToInt32(rdr["ID_Patient"]);
visits.ID_Diag = Convert.ToInt32(rdr["ID_Diag"]);
visits.price = Convert.ToInt32(rdr["price"]);
object sqlDateTime = rdr["visit_date"];
visits.visit_date = (sqlDateTime == System.DBNull.Value)
? (DateTime?)null
: Convert.ToDateTime(sqlDateTime);
}
}
return(visits);
}
catch
{
throw;
}
}
public ActionResult PrepareInterviewerExistingClient()
{
int nowServing = NowServing();
RequestedServicesViewModel rsvm = new RequestedServicesViewModel();
Client client = Clients.GetClient(nowServing, rsvm);
PrepareClientNotes(client, rsvm);
DateTime today = Extras.DateTimeToday();
ViewBag.TicketDate = today.ToString("MM/dd/yyyy");
ViewBag.ServiceTicket = client.ServiceTicket;
ViewBag.ClientName = Clients.ClientBeingServed(client);
ViewBag.BirthName = client.BirthName;
ViewBag.DOB = client.DOB.ToString("MM/dd/yyyy");
ViewBag.Age = client.Age;
ViewBag.Agency = GetClientAgencyName(client);
List <VisitViewModel> visits = Visits.GetVisits(nowServing);
rsvm.XBC = client.XBC == true ? "XBC" : string.Empty;
rsvm.XID = client.XID == true ? "XID" : string.Empty;
// ServiceTicketBackButtonHelper("Set", rsvm);
var objTuple = new Tuple <List <VisitViewModel>, RequestedServicesViewModel>(visits, rsvm);
return(View("PrintExistingClient", objTuple));
}
public ActionResult PrepareExistingClientOverflowVoucher(RequestedServicesViewModel rsvm)
{
int nowServing = NowServing();
Client client = Clients.GetClient(nowServing, null);
Clients.StoreRequestedServicesAndSupportingDocuments(client.Id, rsvm);
PrepareClientNotes(client, rsvm);
DateTime today = Extras.DateTimeToday();
DateTime expiryDate = Clients.CalculateExpiry(today);
Clients.UpdateOverflowExpiry(nowServing, expiryDate);
ViewBag.ClientName = Clients.ClientBeingServed(client);
ViewBag.BirthName = client.BirthName;
ViewBag.DOB = client.DOB.ToString("MM/dd/yyyy");
ViewBag.Age = client.Age;
ViewBag.Agency = Agencies.GetAgencyName(Convert.ToInt32(rsvm.AgencyId)); // rsvm.AgencyId will be the Id of an Agency as a string
ViewBag.IssueDate = today.ToString("ddd MMM d, yyyy");
ViewBag.Expiry = expiryDate.ToString("ddd MMM d, yyyy");
ViewBag.VoucherDate = today.ToString("MM/dd/yyyy"); // for _OverflowSignatureBlock.cshtml
List <VisitViewModel> visits = Visits.GetVisits(nowServing);
rsvm.XBC = client.XBC == true ? "XBC" : string.Empty;
rsvm.XID = client.XID == true ? "XID" : string.Empty;
// VoucherBackButtonHelper("Set", rsvm);
var objTuple = new Tuple <List <VisitViewModel>, RequestedServicesViewModel>(visits, rsvm);
return(View("PrintExistingClientOverflowVoucher", objTuple));
}
public int UpdateVisits(Visits visits)
{
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("UpdateVisit", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID_Visit", visits.ID_Visit);
cmd.Parameters.AddWithValue("@ID_Doctor", visits.ID_Doctor);
cmd.Parameters.AddWithValue("@ID_Patient", visits.ID_Patient);
cmd.Parameters.AddWithValue("@ID_Diag", visits.ID_Diag);
cmd.Parameters.AddWithValue("@price", visits.price);
cmd.Parameters.AddWithValue("@visit_date", visits.visit_date);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
return(1);
}
catch
{
throw;
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,DoctorId,Date")] Visits visits)
{
if (id != visits.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(visits);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VisitsExists(visits.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["DoctorId"] = new SelectList(_context.Doctors, "Id", "PersonalData", visits.DoctorId);
return(View(visits));
}
public ActionResult Create(int id)
{
// Logger.Log(LogLevel.Debug, "Starting VisitsController Get Create.", "Patient Id = " + id.ToString(), "", "");
List <Visits> visits = db.Visits.ToList();
var listVisits = visits.Where(v => v.PatientId == id).OrderByDescending(v => v.VisitDate);
var patient = db.Patients.Find(id);
Visits visit = new Visits();
visit.PatientId = Convert.ToInt32(id);
visit.FullName = patient.FullName;
visit.BirthDate = patient.BirthDate;
visit.PatientPhone = patient.PatientPhone;
visit.VisitDate = DateTime.Now;
visit.DateSignedByPhys = DateTime.Now;
if (listVisits.Count() > 0)
{
Visits lastVisit = visits.Where(v => v.PatientId == id).OrderBy(v => v.VisitId).LastOrDefault();
visit.DiagnosisCode = lastVisit.DiagnosisCode;
visit.ProblemList = lastVisit.ProblemList;
visit.MedicalAllergy = lastVisit.MedicalAllergy;
visit.ReferralReason = lastVisit.ReferralReason;
visit.History = lastVisit.History;
visit.PastHistory = lastVisit.PastHistory;
visit.FamilyHistory = lastVisit.FamilyHistory;
visit.SocialHistory = lastVisit.SocialHistory;
visit.RosGeneral = lastVisit.RosGeneral;
visit.RosHeent = lastVisit.RosHeent;
visit.Respiratory = lastVisit.Respiratory;
visit.Cardiovascular = lastVisit.Cardiovascular;
visit.Gastrointestinal = lastVisit.Gastrointestinal;
visit.Genitourniary = lastVisit.Genitourniary;
visit.RosNeurological = lastVisit.RosNeurological;
visit.psychosocial = lastVisit.psychosocial;
visit.Medications = lastVisit.Medications;
visit.PeGeneral = lastVisit.PeGeneral;
visit.BloodPressure = lastVisit.BloodPressure;
visit.HeartRate = lastVisit.HeartRate;
visit.Tempurature = lastVisit.Tempurature;
visit.Weight = lastVisit.Weight;
visit.PeHeent = lastVisit.PeHeent;
visit.Neck = lastVisit.Neck;
visit.Skin = lastVisit.Skin;
visit.Lungs = lastVisit.Lungs;
visit.Heart = lastVisit.Heart;
visit.Abdomen = lastVisit.Abdomen;
visit.Musculoskeletal = lastVisit.Musculoskeletal;
visit.PeNeurological = lastVisit.PeNeurological;
visit.Additional = lastVisit.Additional;
visit.Documentsoratory = lastVisit.Documentsoratory;
visit.Assessment = lastVisit.Assessment;
visit.Plan = lastVisit.Plan;
}
// Logger.Log(LogLevel.Debug, "Returning VisitsController Get Create.", "Patient Id = " + id.ToString(), "", "");
return(View(visit));
}
public async Task <IActionResult> Edit(int id, [Bind("visitId,companyName,companyTypeId,noOfPax,visitDate,visitTypeId,dateCreated")] Visits visits)
{
if (id != visits.visitId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(visits);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VisitsExists(visits.visitId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(visits));
}
public async Task <ActionResult <Visits> > PostVisits(Visits visits)
{
_context.Visits.Add(visits);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetVisits", new { id = visits.VisitId }, visits));
}
public IActionResult LogPSFVisit(int id)
{
var visit = new Visits();
var expectedPSFVisit = _visitLogic.LoadExpectedPSFVisit(id);
ViewData["IsPSF"] = _visitLogic.IsPSF(id);
if (expectedPSFVisit != null)
{
visit.VisitDate = expectedPSFVisit.ExpectedDate;
visit.VisitSettingId = expectedPSFVisit.VisitStage;
visit.ParticipantId = expectedPSFVisit.ParticipantId;
visit.NextAppointment = _visitLogic.GetNextPSFAppointmentDate(expectedPSFVisit.VisitStage, expectedPSFVisit.StudyId);
if (User.IsInRole("Super Admin") || User.IsInRole("admin"))
{
ViewData["VisitSetting"] = new SelectList(_visitSettingLogic.GetVisitSettings().Result, "Id", "VisitType", expectedPSFVisit.VisitStage);
}
else
{
ViewData["VisitSetting"] = new SelectList(_visitSettingLogic.GetVisitSettings().Result.FindAll(v => v.Id <= 9), "Id", "VisitType", expectedPSFVisit.VisitStage);
}
}
visit.ParticipantId = id;
ViewData["Participant"] = new SelectList(_paticipantLogic.GetParticipants().Result, "Id", "StudyId");
return(View(visit));
}
public async Task <IActionResult> Edit(int id, [Bind("VS_ID,VS_DATE,VS_DESCRIPTION")] Visits visits)
{
if (id != visits.VS_ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(visits);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VisitsExists(visits.VS_ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(visits));
}
// GET: Visits/Edit/5
public ActionResult Edit(int?id, int customerId)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Visits visits = db.Visits.SingleOrDefault(x => x.Id == id);
if (visits == null)
{
return(HttpNotFound());
}
VisitsViewModel vm = new VisitsViewModel
{
Id = visits.Id,
ContactPerson = visits.ContactPerson,
Comment = visits.Comment,
Date = visits.Date,
NextAppointment = visits.NextAppointment,
CustomerId = customerId
};
return(View(vm));
}
async Task ExecuteLoadVisitsCommand(Guest selectedGuest)
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
Visits.Clear();
var visits = await VisitDataStore.GetMembersAsync(true);
foreach (var visit in visits)
{
if (visit.GuestId == selectedGuest.PersonalCode)
{
Visits.Add(visit);
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
finally
{
IsBusy = false;
}
}
/// <summary>
/// Create a list of tasks for a visit. A workorder can have multiple visits
/// Based on the WorkOrder.SelectedTasks a list is created with task attached to the actual visit it was executed
/// </summary>
/// <param name="visit">The visit for which the Tasks are requested</param>
/// <returns></returns>
public ICollection <Task> GetTasksForVisit(Visit visit)
{
// For a visit, all Tasks defined in WorkOrder.SelectedTasks have to be performed by a technician.
// In redo scenario's, it is possible that multiple Visits are created.
// Each Visit shows the same number of tasks (as defined by WorkOrder.SelectedTasks), with their corrsponding status
if (visit == null)
{
return(null);
}
var tasks = new List <Task>();
foreach (var taskInfo in TaskInfos)
{
//Only the last task from a certain specification is shown
var existingTask = Visits.SelectMany(v => v.Tasks).LastOrDefault(t => t.TaskInfo.TaskSpecificationId == taskInfo.TaskSpecificationId && !t.IsDeleted);
if (existingTask == null)
{
existingTask = Task.Create(taskInfo, null); //Task does not yet exist on visit => Create Virtual Task to show in list
existingTask.VisitId = visit.Id;
existingTask.Visit = visit;
existingTask.EndEdit();
existingTask.Delete();
}
else
{
//Task => set to unmodified (Task boundary)
existingTask.EndEdit();
}
tasks.Add(existingTask);
}
return(new ObservableCollection <Task>(tasks.OrderBy(t => t.TaskInfo.SeqNo)));
}
public JsonResult GetClientHistory(int nowServing)
{
if (nowServing == 0)
{
return(GetEmptyGrid(1, 20));
}
List <VisitViewModel> visits = Visits.GetVisits(nowServing);
int pageIndex = 0;
int pageSize = 20;
int totalRecords = visits.Count;
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)20);
visits = visits.Skip(pageIndex * pageSize).Take(pageSize).ToList();
visits = visits.OrderBy(v => v.Date).ToList();
var jsonData = new
{
total = totalPages,
page = 1,
records = totalRecords,
rows = visits
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> PutVisits(decimal id, Visits visits)
{
if (id != visits.VisitId)
{
return(BadRequest());
}
_context.Entry(visits).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VisitsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
/// <summary>
/// PLB: 6/15/2020 Disallowed this through jqGrid in
/// FrontDeskClientHistory.js
/// FrontDeskPocketChecks.js
/// BackOfficeClientHistory.js
/// BackOfficePocketChecks.js
/// InterviewerClientHistory.js
/// InterviewerPocketChecks.js
/// May revisit this decision later.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string DeletePocketCheck(int id)
{
int nowServing = NowServing();
Visits.DeletePocketCheck(nowServing, id);
DailyHub.Refresh();
return("Success");
}
public string EditPocketCheck(VisitViewModel vvm)
{
int nowServing = NowServing();
Visits.EditVisit(nowServing, vvm);
DailyHub.Refresh();
return("Success");
}
public async Task <IActionResult> UpdateVisit([FromBody] Visits obj)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
return(Ok(await _Interface.UpdateVisit(obj)));
}
public ActionResult DeleteConfirmed(int id)
{
Visits visits = db.Visits.Find(id);
db.Visits.Remove(visits);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id, int customerId)
{
Visits visits = db.Visits.Find(id);
db.Visits.Remove(visits);
db.SaveChanges();
return(RedirectToAction("Details", "Customers", new { id = customerId }));
}
void ReloadData()
{
if (textBox1.Text.Trim().Length > 0)
{
switch (comboBox1.SelectedIndex)
{
case 0:
PopulateData(
Doctors.Records().Get(),
Patients.Records().Where(Patients.COLUMNS.Surname, "LIKE", "%" + textBox1.Text + "%").Get(),
Servises.Records().Get(),
Treatments.Records().Get(),
Visits.Records().Get()
);
break;
case 1:
PopulateData(
Doctors.Records().Get(),
Patients.Records().Get(),
Servises.Records().Where(Servises.COLUMNS.Servise_name, "LIKE", "%" + textBox1.Text + "%").Get(),
Treatments.Records().Get(),
Visits.Records().Get()
);
break;
case 2:
PopulateData(
Doctors.Records().Where(Doctors.COLUMNS.Surname, "LIKE", "%" + textBox1.Text + "%").Get(),
Patients.Records().Get(),
Servises.Records().Get(),
Treatments.Records().Get(),
Visits.Records().Get()
);
break;
default:
PopulateData(
Doctors.Records().Get(),
Patients.Records().Get(),
Servises.Records().Get(),
Treatments.Records().Get(),
Visits.Records().Get()
);
break;
}
}
else
{
PopulateData(
Doctors.Records().Get(),
Patients.Records().Get(),
Servises.Records().Get(),
Treatments.Records().Get(),
Visits.Records().Get()
);
}
}
public ActionResult Create1()
{
Visits visitsViewModel = new Visits();
// IEnumerable<VisitsViewModel> model = VisitsViewModel.GetPeople();
return(View(visitsViewModel));
}
public async Task <int> UpdateVisit(Visits visit)
{
var existing = context.Visits.FirstOrDefault(m => m.Id == visit.Id);
visit.CreateDate = existing.CreateDate;
context.Entry(existing).CurrentValues.SetValues(visit);
//context.Update(visit);
return(await context.SaveChangesAsync());
}
public string AddDatedPocketCheck(VisitViewModel vvm)
{
int nowServing = NowServing();
vvm.Date = Extras.DateTimeToday();
Visits.AddPocketCheck(nowServing, vvm);
DailyHub.Refresh();
return("Success");
}
public virtual bool RemoveVisit(SiteVisit visit)
{
if (Visits.Remove(visit))
{
visit.Site = null;
return(true);
}
return(false);
}
public ActionResult DeleteConfirmed(int id)
{
// Logger.Log(LogLevel.Debug, "Starting VisitsController Post Delete.", "Patient Id = " + id.ToString(), "", "");
Visits visit = db.Visits.Find(id);
db.Visits.Remove(visit);
db.SaveChanges();
// Logger.Log(LogLevel.Debug, "Returning VisitsController Post Delete.", "Patient Id = " + id.ToString(), "", "Saved changes");
return(RedirectToAction("PatientIndex", new { id = visit.PatientId }));
}
public override ICollection <VisitCustomers> GetVisitCustomers()
{
Visits.Clear();
foreach (var vis in db.VisitCustomers)
{
Visits.Add(vis);
}
return(Visits);
}
public string AddVisitNote(int vid, string sender, VisitNoteModel vnm)
{
int nowServing = NowServing();
// Log.Debug(string.Format("NowServing = {0}, vid = {1}, side = {2}", nowServing, vid, side));
Visits.AddVisitNote(nowServing, vid, sender, vnm);
DailyHub.Refresh();
return("Success");
}
public async Task <IActionResult> Create([Bind("VisitDate,ParticipantId,VisitSettingId,NextAppointment,ParticipantCame,VisitOutcome, OutcomeComment, DateParticipantCame")] Visits visits)
{
var isPSF = _visitLogic.IsPSF(visits.ParticipantId);
string studyId = _visitLogic.GetStudyId(visits.ParticipantId);
if (!string.IsNullOrWhiteSpace(studyId) && visits.VisitSettingId == 2 && visits.ParticipantCame == 1)
{
foreach (var schedule in _visitLogic.GenerateParticipantSchedule(visits.DateParticipantCame.Value, studyId))
{
if (!_visitLogic.ScheduleExists(studyId, schedule.VisitStage))
{
await _visitLogic.AddSchedule(schedule);
}
}
if (isPSF)
{
var psfSchedules = _visitLogic.CreatePSFSchedule(studyId);
await _visitLogic.AddPSFSchedule(psfSchedules);
}
}
if (visits.VisitSettingId > 9)
{
var expectedVisit = _visitLogic.LoadExpectedPSFVisit(visits.ParticipantId);
}
else
{
var expectedVisit = _visitLogic.LoadExpectedVisit(visits.ParticipantId);
}
//if (!isPSF)
// ModelState.AddModelError("ParticipantId", "Participant not a PSF");
if (ModelState.IsValid)
{
visits.CreateDate = DateTime.Now;
await _visitLogic.AddVisits(visits);
return(RedirectToAction(nameof(Index)));
}
if (User.IsInRole("Super Admin") || User.IsInRole("admin"))
{
ViewData["VisitSetting"] = new SelectList(_visitSettingLogic.GetVisitSettings().Result, "Id", "VisitType");
}
else
{
ViewData["VisitSetting"] = new SelectList(_visitSettingLogic.GetVisitSettings().Result.FindAll(v => v.Id <= 9), "Id", "VisitType");
}
ViewData["Participant"] = new SelectList(_participantLogic.GetParticipants().Result, "Id", "StudyId");
return(View(visits));
}
public ActionResult Edit([Bind(Include = "visitID,description,visitCost,visitDate,ownerID")] Visits visits)
{
if (ModelState.IsValid)
{
db.Entry(visits).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ownerID = new SelectList(db.Owners, "ownerID", "petName", visits.ownerID);
return(View(visits));
}
public void AddToVisits(Visits visits)
{
base.AddObject("Visits", visits);
}
public static Visits CreateVisits(
global::System.Guid visitId,
int visitorVisitIndex,
int visitPageCount,
global::System.DateTime startDateTime,
global::System.DateTime endDateTime,
int value,
string aspNetSessionId,
string rDNS,
string multiSite,
byte[] ip,
string businessName,
string city,
string postalCode,
string metroCode,
string areaCode,
string region,
string ispName,
string country,
double latitude,
double longitude,
string referrer)
{
Visits visits = new Visits();
visits.VisitId = visitId;
visits.VisitorVisitIndex = visitorVisitIndex;
visits.VisitPageCount = visitPageCount;
visits.StartDateTime = startDateTime;
visits.EndDateTime = endDateTime;
visits.Value = value;
visits.AspNetSessionId = aspNetSessionId;
visits.RDNS = rDNS;
visits.MultiSite = multiSite;
visits.Ip = ip;
visits.BusinessName = businessName;
visits.City = city;
visits.PostalCode = postalCode;
visits.MetroCode = metroCode;
visits.AreaCode = areaCode;
visits.Region = region;
visits.IspName = ispName;
visits.Country = country;
visits.Latitude = latitude;
visits.Longitude = longitude;
visits.Referrer = referrer;
return visits;
}
