public ActionResult DoctorVisit([FromForm] Visit visits)
{
var patients = PatientTable.GetPatientById(patientId);
DateTime time = DateTime.Now.Date;
string date = time.ToString("yyyy-MM-dd");
if (visits.Type == "visit")
{
visits.Status = "in progress";
}
else if (visits.Type == "referral")
{
visits.Status = "pending";
}
else if (visits.Type == "test")
{
TestTable.InsertData(patientId, Properties.UserId, "", date);
visits.Status = "pending";
}
VisitTable.InsertD(patients[0].Id, Properties.UserId, visits.Type, visits.Doctor, visits.Status, date);
return(RedirectToAction("DoctorView", "Doctor", PatientTable.GetPatientById(patientId)[0]));
}
public IActionResult DoctorView(Patient patient)
{
patientId = patient.Id;
Properties.patient = patient;
var doctorSpecialization = DoctorTable.GetSpecializationById(Properties.UserId);
if (patient.Name == null)
{
patient.Id = 100;
}
List <Visit> visits = VisitTable.GetDataByPatientIdAndSpecialization(patient.Id, doctorSpecialization[0].Specialization);
List <Prescription> prescriptions = PrescriptionTable.GetDataByPatientId(patient.Id);
List <Test> tests = TestTable.GetDataByPatientId(patient.Id);
List <Documentation> docs = DocumentationTable.GetDataByPatientId(patient.Id);
List <MedicalDescription> list = MedicalDescriptionTable.GetDataByPatientId(patient.Id);
ViewData["data"] = patient;
ViewData["docs"] = docs;
ViewData["visits"] = visits;
ViewData["prescript"] = prescriptions;
ViewData["tests"] = tests;
ViewData["medicalDescriptionData"] = list;
return(View());
}
public IActionResult Visit(int id)
{
ViewBag.var = id;
ViewBag.patient = Properties.patient;
Properties.VisitId = id;
var data = VisitTable.GetDataById(id);
if (data.Count == 0)
{
throw new ArgumentNullException();
}
Visit visitData = new Visit()
{
PatientName = data[0].PatientName,
DoctorName = data[0].DoctorName,
Doctor = data[0].Doctor,
Status = data[0].Status,
Type = data[0].Type,
Date = data[0].Date
};
return(View(visitData));
}
public ActionResult PatientView([FromForm] string searchString)
{
try
{
if (Regex.IsMatch(searchString, @"^[a-zA-Z]+$"))
{
List <Doctor> doctor = DoctorTable.GetDoctorIdBySurname(searchString);
if (doctor.Count != 0)
{
int doctorId = doctor[0].Id;
var visit = VisitTable.GetDataByDoctorId(doctorId, Properties.UserId);
var prescript = PrescriptionTable.GetDataByDoctorId(doctorId, Properties.UserId);
var test = TestTable.GetDataByDoctorId(doctorId, Properties.UserId);
var sickleave = SickLeaveTable.GetDataByDoctorId(doctorId, Properties.UserId);
var description = MedicalDescriptionTable.GetDataByDoctorId(doctorId, Properties.UserId);
var doc = DocumentationTable.GetDataByDoctorId(doctorId, Properties.UserId);
ViewData["PatientName"] = PatientTable.GetPatientById(Properties.UserId)[0];
ViewData["visitData"] = visit;
ViewData["prescriptioneData"] = prescript;
ViewData["Tests"] = test;
ViewData["sickLeaveData"] = sickleave;
ViewData["medicalDescription"] = description;
ViewData["documentation"] = doc;
return(View());
}
else
{
ViewData["PatientName"] = PatientTable.GetPatientById(Properties.UserId)[0];
ViewData["visitData"] = new List <Visit>();
ViewData["prescriptioneData"] = new List <Prescription>();
ViewData["Tests"] = new List <Test>();
ViewData["sickLeaveData"] = new List <SickLeave>();
ViewData["medicalDescription"] = new List <MedicalDescription>();
ViewData["documentation"] = new List <Documentation>();
var prescript = PrescriptionTable.GetPrescriptByMedicine(searchString);
if (prescript.Count != 0)
{
ViewData["prescriptioneData"] = prescript;
}
var des = MedicalDescriptionTable.GetData(Properties.UserId, searchString);
if (des.Count != 0)
{
ViewData["medicalDescription"] = des;
}
View();
}
}
return(View());
}
catch
{
return(View());
}
}
public IActionResult AddDescription(int id)
{
ViewBag.var = id;
var data = VisitTable.GetDataById(id);
var patients = PatientTable.GetPatientById(patientId);
ViewData["patient"] = patients[0];
ViewData["visit"] = data[0];
return(View());
}
public MainForm()
{
InitializeComponent();
classTableWorker = new WorkerTable(GridViewWorker);
classTableService = new ServiceTable(GridViewService);
classTableCustomer = new CustomerTable(GridViewСustomers);
groupTable = new GroupTable(GridViewGroups);
visitTable = new VisitTable(GridViewVisitGroup);
timetable = new TimetableTable(GridViewTimeTable);
recordGroup = new RecordGroupTable(GridViewRecordGroups);
timetable.DateDay = SelectDate.Value;
timetable.Room = cbRoom.Text;
}
public ViewVisitTable(VisitTable visitTable)
{
VisitId = visitTable.VisitId;
CustName = visitTable.CustName;
ContactPerson = visitTable.ContactPerson;
ContactNo = visitTable.ContactNo;
InterestProduct = visitTable.InterestProduct;
Description = visitTable.Description;
VisitDatetime = visitTable.VisitDatetime;
IsDisabled = visitTable.IsDisabled;
IsDeleted = visitTable.IsDeleted;
EmpId = visitTable.EmpId;
}
public IActionResult PdfVisit(int id)
{
var visit = VisitTable.GetDataById(id);
var patData = PatientTable.GetPatientById(Properties.UserId);
patData[0].Name = patData[0].Name + " " + patData[0].Surname;
ViewBag.patient = patData;
var doc = DoctorTable.GetDoctorIdByName(visit[0].DoctorName);
var docData = DoctorTable.GetSpecializationById(doc[0].Id);
docData[0].Name = docData[0].Name + " " + docData[0].Surname;
ViewBag.doctor = docData;
return(View(visit));
}
public async Task <ActionResult <VisitTable> > PostVisitTable(ViewVisitTable visitTable)
{
VisitTable v = new VisitTable();
v.CustName = visitTable.CustName;
v.ContactNo = visitTable.ContactNo;
v.ContactPerson = visitTable.ContactPerson;
v.Description = visitTable.Description;
v.EmpId = visitTable.EmpId;
v.VisitDatetime = DateTime.Now;
v.InterestProduct = visitTable.InterestProduct;
v.IsDeleted = false;
v.IsDisabled = false;
_context.VisitTable.Add(v);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetVisitTable", new { id = visitTable.VisitId }, visitTable));
}
public IActionResult Visit(int id)
{
ViewBag.var = id;
var data = VisitTable.GetDataById(id);
Visit visitData = new Visit()
{
PatientName = data[0].PatientName,
DoctorName = data[0].DoctorName,
Doctor = data[0].Doctor,
Status = data[0].Status,
Type = data[0].Type,
Date = data[0].Date
};
return(View(visitData));
}
public ActionResult Course(int id)
{
List <Visit> visitList = new List <Visit>();
List <Test> testList = new List <Test>();
List <Visit> tmpV = new List <Visit>();
List <Test> tmpT = new List <Test>();
visitList.AddRange(VisitTable.GetDataByPatientId(Properties.UserId));
testList.AddRange(TestTable.GetDataByPatientId(Properties.UserId));
dynamic output = new ExpandoObject();
id--;
Visit currentVisit = new Visit();
currentVisit = visitList[id];
visitList.RemoveRange(0, id);
foreach (Visit v in visitList)
{
if (currentVisit.DoctorName == v.DoctorName && DateTime.Compare(currentVisit.Date, v.Date) <= 0)
{
try
{
foreach (Test t in testList)
{
if (currentVisit.DoctorName == t.DoctorName && DateTime.Compare(currentVisit.Date, t.Date) <= 0)
{
tmpT.Add(t);
testList.Remove(t);
break;
}
}
}
catch { }
currentVisit = v;
tmpV.Add(v);
}
}
output.Visit = tmpV;
output.Test = tmpT;
return(View(output));
}
public ActionResult PatientView(Patient patient)
{
var patients = PatientTable.GetPatientById(Properties.UserId);
var description = MedicalDescriptionTable.GetDataByPatientId(Properties.UserId);
var visit = VisitTable.GetDataByPatientId(Properties.UserId);
var prescript = PrescriptionTable.GetData(Properties.UserId);
var test = TestTable.GetData(Properties.UserId);
var leavesick = SickLeaveTable.GetDataByPatientId(Properties.UserId);
var doc = DocumentationTable.GetDataByPatientId(Properties.UserId);
// ViewData["PatientName"] = PatientTable.GetPatientById(patient.Id);
ViewData["PatientName"] = patients[0];
ViewData["visitData"] = visit;
ViewData["prescriptioneData"] = prescript;
ViewData["Tests"] = test;
ViewData["sickLeaveData"] = leavesick;
ViewData["medicalDescription"] = description;
ViewData["documentation"] = doc;
return(View());
}
public VisitAdd()
{
InitializeComponent();
visitTable = new VisitTable(cbLustCustomer);
}
