public void SInTests_SInEnum_IntAsString()
{
PatientStatus patStat = PatientStatus.Inactive;
string patStatIntStr = ((int)patStat).ToString();
Assert.AreEqual(patStat, SIn.Enum <PatientStatus>(patStatIntStr, isEnumAsString: false));
}
public async Task <IActionResult> UpdatePatientStatus(int id, PatientStatus status)
{
if (status == PatientStatus.IsChecking)
{
var patients = GetCurrentDoctorPatients()
.Where(p => (p.Status == PatientStatus.IsChecking));
if (patients.Any())
{
return(NoContent());
}
}
var patient = _unitOfWork.Patients.Find(id);
if (patient == null)
{
return(NotFound());
}
patient.Status = status;
_unitOfWork.Patients.Update(patient);
int result = await _unitOfWork.SaveChangesAsync();
if (result < 1)
{
return(NoContent());
}
return(Ok());
}
private void button3_Click(object sender, EventArgs e)
{
string type = "none";
string followVisit = "none";
string followPhone = "none";
type = (typePhoneChk.Checked) ? "Phone" : "Visit";
type = (typeVisitChk.Checked) ? "Visit" : "Phone";
followVisit = (visitChk.Checked) ? "Yes" : "No";
followPhone = (phoneChk.Checked) ? "Yes" : "No";
string id = Guid.NewGuid().ToString();
Follow i = new Follow(FollowID, CustomerID, UserID, ItemID, type, diagnosisTxt.Text, hospitalTxt.Text, sourceTxt.Text, lengthTxt.Text, needTxt.Text, goalTxt.Text, resultTxt.Text, "", followVisit, followPhone, nextTxt.Text, puTxt.Text, authSignatureTxt.Text, authoriserTxt.Text, relationTxt.Text, reasonTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
if (MySQL.Insert(i) != "")
{
foreach (ItemReview t in GenericCollection.itemReviews)
{
ItemReview c = new ItemReview(t.Id, FollowID, t.Title, t.Status, t.Status, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
foreach (ItemStatus t in GenericCollection.itemStatus)
{
ItemStatus c = new ItemStatus(t.Id, FollowID, t.Title, t.Status, t.Status, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
foreach (PatientStatus t in GenericCollection.patientStatus)
{
PatientStatus c = new PatientStatus(t.Id, FollowID, t.Title, t.Status, t.Status, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
MessageBox.Show("Information Saved");
this.Close();
}
}
protected override void Execute(CodeActivityContext context)
{
ITracingService tracingService = (ITracingService)context.GetExtension <ITracingService>();
IWorkflowContext workflowContext = (IWorkflowContext)context.GetExtension <IWorkflowContext>();
IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)context.GetExtension <IOrganizationServiceFactory>();
IOrganizationService service = serviceFactory.CreateOrganizationService(workflowContext.UserId);
tracingService.Trace("Patient Details using input and output parameters Workflow Started.");
var patientName = PatientName.Get(context);
var dateOfBirth = DateOfBirth.Get(context);
var hospital = ((EntityReference)(Hospital.Get(context))).Id;
var hospitalid = ((EntityReference)(Hospital.Get(context))).Name;
var patientStatus = PatientStatus.Get(context);
var hospitalizationRequired = HospitalizationRequired.Get(context);
var patientAge = PatientAge.Get(context);
var consultationFee = ConsultationFee.Get(context);
var estimatedAmount = EstimatedAmount.Get(context);
var treatmentCost = ((OptionSetValue)(TreatmentCost.Get(context))).Value;
var patientId = PatientInOut.Get(context);
tracingService.Trace($"Patient Name : {patientName}, Date Of Birth : {dateOfBirth}, Hospital : {hospital}, Patient Status : {patientStatus}, Hospitalization Required: {hospitalizationRequired}, Patient Age: {patientAge}, Consultation Fee : {consultationFee}, Estimated Amount : {estimatedAmount}, Treatment Cost : {treatmentCost}, Patient ID : {patientId}");
var patientDetails = $"Patient Name : {patientName}, Date Of Birth : {dateOfBirth}, Hospital : {hospital}, Patient Status : {patientStatus}, Hospitalization Required: {hospitalizationRequired}, Patient Age: {patientAge}, Consultation Fee : {consultationFee}, Estimated Amount : {estimatedAmount}, Treatment Cost : {treatmentCost}, Patient ID : {patientId}";
PatientInOut.Set(context, PatientInOut.ToString());
ShowPatientDetails.Set(context, patientDetails);
tracingService.Trace("Patient Details using input and output parameters Workflow Ended.");
}
/// <summary>
/// Gets all the statusses of tha <see cref="IPatient"/> instance that matches the pattern.
/// </summary>
/// <param name="patientPattern">Pattern to determine the instances of <see cref="IPatient"/>.</param>
/// <inheritDoc />
public IEnumerable <PatientStatus> GetStatusses(string patientPattern = "*")
{
EnsureArg.IsNotNullOrEmpty(patientPattern, nameof(patientPattern));
var ant = antFactory
.CreateNew(patientPattern);
var patients = kernel.GetAll <IPatient>();
var candidates = patients
.Where(_ => ant.IsMatch(_.Id))
.OrderBy(_ => _.Id);
foreach (var candidate in candidates)
{
var status = new PatientStatus(candidate.Id, PatientStatusType.Red, defaultReason);
try
{
status = candidate.GetStatus() ?? status;
}
catch (Exception ex)
{
status = new PatientStatus(candidate.Id, PatientStatusType.Red, ex.ToString());
}
yield return(status);
}
}
public static void AddDefaultPatientStatuses(AspergillosisContext context)
{
if (context.PatientStatuses.Any())
{
return;
}
var statuses = new PatientStatus[]
{
new PatientStatus {
Name = "Active"
},
new PatientStatus {
Name = "Discharged"
},
new PatientStatus {
Name = "Inactive"
},
new PatientStatus {
Name = "Deceased"
},
};
foreach (var status in statuses)
{
context.Add(status);
}
context.SaveChanges();
}
public void SInTests_SInEnum_AsString()
{
PatientStatus patStat = PatientStatus.Inactive;
string patStatStr = patStat.ToString();
Assert.AreEqual(patStat, SIn.Enum <PatientStatus>(patStatStr, isEnumAsString: true));
}
public ActionResult <StatusReadDTO> CreateStatus([FromBody] StatusUpdateDTO stDTO)
{
PatientStatus p_st = _mapper.Map <PatientStatus>(stDTO);
_repository.CreateStatus(p_st);
_repository.SaveChanges();
return(Ok(_mapper.Map <StatusReadDTO>(p_st)));
}
private void LoadEdit(string id)
{
FollowID = id;
o = new Follow();//.Select(UsersID);
o = Follow.Select(id);
CustomerID = o.CustomerID;
customerCbx.Text = CustomerDictionary.First(e => e.Value == o.CustomerID).Key;
customerCbx_SelectedIndexChanged(null, null);
UserID = o.UserID;
userCbx.Text = UserDictionary.First(e => e.Value == o.UserID).Key;
userCbx_SelectedIndexChanged(null, null);
ItemID = o.ItemID;
productCbx.Text = ProductDictionary.First(e => e.Value == o.ItemID).Key;
productCbx_SelectedIndexChanged(null, null);
typePhoneChk.Checked = (o.Type == "Phone") ? true : false;
typeVisitChk.Checked = (o.Type == "Visit") ? true : false;
diagnosisTxt.Text = o.Diagnosis;
hospitalTxt.Text = o.Hospitalisation;
sourceTxt.Text = o.Source;
foreach (ItemReview i in Model.ItemReview.List(o.Id))
{
ItemReview t = new ItemReview(id, i.FollowID, i.Title, i.Status, i.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemReviews.Add(t);
}
LoadItemReview();
foreach (ItemStatus i in Model.ItemStatus.List(o.Id))
{
ItemStatus t = new ItemStatus(id, i.FollowID, i.Title, i.Status, i.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemStatus.Add(t);
}
LoadItemStatus();
foreach (PatientStatus i in Model.PatientStatus.List(o.Id))
{
PatientStatus t = new PatientStatus(id, i.FollowID, i.Title, i.Status, i.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.patientStatus.Add(t);
}
LoadPatientStatus();
lengthTxt.Text = o.Length;
needTxt.Text = o.Need;
goalTxt.Text = o.Goal;
resultTxt.Text = o.Results;
visitChk.Checked = (o.FollowVisit == "Yes") ? true : false;
phoneChk.Checked = (o.FollowPhone == "Yes") ? true : false;
nextTxt.Text = o.Next;
puTxt.Text = o.Pu;
authoriserTxt.Text = o.Authoriser;
employeeTxt.Text = o.Signature;
reasonTxt.Text = o.Reason;
authSignatureTxt.Text = o.Authoriser;
}
private void button3_Click(object sender, EventArgs e)
{
if (currentDialog == "ItemReview")
{
if (Helper.ItemReview.ContainsKey(detailsCbx.Text + ":" + detailsTxt.Text))
{
MessageBox.Show("Selection exists !");
return;
}
if (stateCbx.Text == "Yes")
{
Helper.ItemReview.Add(detailsCbx.Text + ":" + detailsTxt.Text, true);
}
if (stateCbx.Text == "No")
{
Helper.ItemReview.Add(detailsCbx.Text + ":" + detailsTxt.Text, false);
}
string id = Guid.NewGuid().ToString();
ItemReview t = new ItemReview(id, FollowID, detailsCbx.Text, stateCbx.Text, detailsTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemReviews.Add(t);
this.DialogResult = DialogResult.OK;
this.Dispose();
return;
}
if (currentDialog == "PatientStatus")
{
if (Helper.PatientStatus.ContainsKey(detailsCbx.Text + ":" + detailsTxt.Text))
{
MessageBox.Show("Selection exists !");
return;
}
Helper.PatientStatus.Add(detailsCbx.Text + ":" + detailsTxt.Text, stateCbx.Text);
string id = Guid.NewGuid().ToString();
PatientStatus t = new PatientStatus(id, FollowID, detailsCbx.Text, stateCbx.Text, detailsTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.patientStatus.Add(t);
this.DialogResult = DialogResult.OK;
this.Dispose();
return;
}
if (currentDialog == "ItemSetting")
{
if (Helper.ItemSetting.ContainsKey(detailsCbx.Text + ":" + detailsTxt.Text))
{
MessageBox.Show("Selection exists !");
return;
}
Helper.ItemSetting.Add(detailsCbx.Text + ":" + detailsTxt.Text, stateCbx.Text);
string id = Guid.NewGuid().ToString();
ItemStatus t = new ItemStatus(id, FollowID, detailsCbx.Text, stateCbx.Text, detailsTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemStatus.Add(t);
this.DialogResult = DialogResult.OK;
this.Dispose();
return;
}
}
/// <summary>
/// Gets the list of SelectListItems based on the PatientStatus enum for the drop down
/// </summary>
/// <param name="selectedState"></param>
/// <returns></returns>
public static List <SelectListItem> GetPatientStatesSelectList(PatientStatus selectedState = PatientStatus.Unknown)
{
return(Enum.GetValues(typeof(PatientStatus))
.Cast <PatientStatus>()
.Select(v => new SelectListItem
{
Selected = (v == selectedState),
Text = v.ToString(),
Value = ((int)v).ToString(CultureInfo.InvariantCulture)
}).ToList());
}
public async Task <int> Status(PatientStatus item)
{
return(await context.DeleteDataPatient(context.PatientStatus, item));
//var st = await context.PatientStatus.FirstOrDefaultAsync(it => it.Idpatient == ps.Idpatient);
//if(st != null)
//{
// context.PatientStatus.Remove(st);
// await context.SaveChangesAsync();
//}
//context.PatientStatus.Add(ps);
//return await context.SaveChangesAsync();
}
public PatientViewModel CreatePatient(String name = "NoName", PatientStatus status = PatientStatus.Healthy, PersonSex sex = PersonSex.Male)
{
if (string.IsNullOrWhiteSpace(name))
{
throw new ArgumentNullException(nameof(name));
}
return(new PatientViewModel()
{
Name = name,
Sex = sex,
Status = status
});
}
/// <summary>Creates patient objects corresponding to the totalPat parameter. Each patient has a procedure
/// and statement created on the specified date. Aging is run for each patient.</summary>
public static void CreatePatWithProcAndStatement(int totalPat, DateTime dateTimeSentStmt = default(DateTime), bool hasPortalAccessInfo = false,
PatientStatus patStatus = PatientStatus.Patient, StatementMode stmtMode = StatementMode.Mail, bool hasSignedTil = false, double procFee = 0)
{
for (int i = 0; i < totalPat; i++)
{
Patient patient = CreatePatient("", 0, 0, "", "", ContactMethod.Email, "", "", "", default(DateTime), 0, 0, hasPortalAccessInfo, patStatus, hasSignedTil);
DateTime dateProc = DateTime.Today.AddDays(-1);
//Create a completed procedure that was completed the day before the first payplan charge date AND before the payment plan creation date.
ProcedureT.CreateProcedure(patient, "D1100", ProcStat.C, "", procFee, dateProc);
//Run Ledgers to update the patient balance from the procedure fee
Ledgers.ComputeAging(patient.PatNum, dateTimeSentStmt);
//Insert a statement that was sent during the "bill in advance days" for the payment plan charge AND before the payment plan creation date.
StatementT.CreateStatement(patient.PatNum, mode_: stmtMode, isSent: true, dateSent: dateTimeSentStmt);
}
}
public async Task <IActionResult> GetAllPatient(int pageIndex, int pageSize)
{
PatientStatus[] status = new PatientStatus[] { PatientStatus.Active, PatientStatus.Death };
int userId = _authService.GetUserId() ?? 0;
var result = await _patientService.GetUserPatientAsync(pageIndex, pageSize, status);
if (result.Success)
{
return(Ok(result.Item));
}
else
{
return(BadRequest(result.Message));
}
}
public PatientStatusDTO CreatePatientStatus(PatientStatusCreateDTO info)
{
StoreContext db = new StoreContext();
if (!string.IsNullOrEmpty(info.Name) || info.Name != "string")
{
PatientStatus patientStatus = mapper.Map <PatientStatus>(info);
db.PatientStatus.Add(patientStatus);
db.SaveChanges();
PatientStatusDTO response = mapper.Map <PatientStatusDTO>(patientStatus);
return(response);
}
else
{
return(null);
}
}
public PatientStatusDTO DeletePatientStatus(string ID)
{
StoreContext db = new StoreContext();
PatientStatus patientStatus = db.PatientStatus.Where(a => a.Id == Helper.DecryptInt(ID)).FirstOrDefault();
if (patientStatus != null)
{
PatientStatusDTO response = mapper.Map <PatientStatusDTO>(patientStatus);
db.PatientStatus.Remove(patientStatus);
db.SaveChanges();
return(response);
}
else
{
return(null);
}
}
public PatientStatusDTO UpdatePatientStatus(PatientStatusUpdateDTO info)
{
StoreContext db = new StoreContext();
PatientStatus patientStatus = db.PatientStatus.Where(a => a.Id == Helper.DecryptInt(info.Id)).FirstOrDefault();
if (patientStatus != null)
{
patientStatus.Name = info.Name;
patientStatus.IsActive = info.IsActive;
db.SaveChanges();
PatientStatusDTO response = mapper.Map <PatientStatusDTO>(patientStatus);
return(response);
}
else
{
return(null);
}
}
public dynamic UpdateAppointment(Appointment Appointment)
{
var Appointmentupdate = _context.Patient_Registration_Master.Where(x => x.MR_NO == Appointment.Master.MR_NO).AsNoTracking().FirstOrDefault();
var masters = Context.Patient_Registration_Master.Where(x => x.MR_NO == Appointment.Master.MR_NO).ToList();
if (masters != null)
{
masters.All(x => { x.Last_Visit_Date = DateTime.Now.Date; return(true); });
Context.Patient_Registration_Master.UpdateRange(masters);
}
var PatientRegDtl = new PatientRegistrationDetail();
PatientRegDtl.MR_NO = Appointment.Master.MR_NO;
PatientRegDtl.UIN = Appointment.Master.UIN;
PatientRegDtl.Sysdate = DateTime.Now;
PatientRegDtl.Visit_Number = 0;
PatientRegDtl.Visit_Date = DateTime.Now.Date;
PatientRegDtl.Allocation_Code = "LC009";
PatientRegDtl.Category_Code = "CATC001";
PatientRegDtl.Type_Code = "PC001";
PatientRegDtl.Instance_Code = "INSC002";
PatientRegDtl.Speciality_Code = "SPC001";
PatientRegDtl.SiteId = Appointment.Master.SiteId;
Context.Patient_Registration_Detail.Add(PatientRegDtl);
var PATIENTSTATUS = new PatientStatus();
PATIENTSTATUS.Visit_Date = DateTime.Now.Date;
PATIENTSTATUS.MR_NO = Appointment.Master.MR_NO;
PATIENTSTATUS.UIN = Appointment.Master.UIN;
PATIENTSTATUS.Assign_Doctor = "N";
PATIENTSTATUS.PurposeId = Appointment.EmrwfVisitPurposeServiceMaster.PurposeId;
PATIENTSTATUS.SiteId = Appointment.Master.SiteId;
Context.Patient_Status.Add(PATIENTSTATUS);
var opVisitDatewise = _context.Op_Visit_Datewise.Where(x => x.Date == DateTime.Now.Date && x.Patient_Class == Appointment.Master.Patient_Class).FirstOrDefault();
var isNewOpVisit = false;
if (opVisitDatewise == null)
{
isNewOpVisit = true;
opVisitDatewise = new OpVisitDatewise();
opVisitDatewise.Date = DateTime.Now.Date;
opVisitDatewise.Patient_Class = Appointment.Master.Patient_Class;
}
opVisitDatewise.Old += 1;
if (isNewOpVisit)
{
_context.Op_Visit_Datewise.Add(opVisitDatewise);
}
else
{
_context.Entry(opVisitDatewise).State = EntityState.Modified;
}
try
{
if (Context.SaveChanges() > 0)
{
return new
{
Success = true,
Message = "saved successfully"
}
}
;
}
catch (Exception ex)
{
Console.Write(ex);
}
return(new
{
Success = false,
Message = "Some data are Missing"
});
}
public void LoadDefaultXML(string filename)
{
Default = LoadXML(filename);
Default.Debug();
// set Current as backup
Current = Default;
}
public void Set(PatientStatus status)
{
Current = status;
}
public void Add(PatientStatus status)
{
StatusList.Add(status);
}
public void CopyOptions(PatientStatus defaults)
{
Airway.Options = defaults.Airway.Options;
Breathing.Options = defaults.Breathing.Options;
Circulation.Options = defaults.Circulation.Options;
Neurological.EyeResponse.Options = defaults.Neurological.EyeResponse.Options;
Neurological.VerbalResponse.Options = defaults.Neurological.VerbalResponse.Options;
Neurological.MotorResponse.Options = defaults.Neurological.MotorResponse.Options;
Neurological.Total.Options = defaults.Neurological.Total.Options;
Treatment.XRay.Options = defaults.Treatment.XRay.Options;
Treatment.FAST.Options = defaults.Treatment.FAST.Options;
Skin.Color.Options = defaults.Skin.Color.Options;
Skin.Moisture.Options = defaults.Skin.Moisture.Options;
Skin.Temperature.Options = defaults.Skin.Temperature.Options;
}
public dynamic ToDBCampAdmission(CampAdmission CampAdmission)
{
if (CampAdmission.Patient_Name != null || CampAdmission.Patient_Name != "")
{
var mrNo = "";
var uin = "";
var aadNo = "";
var ipano = "";
var ipno = "";
var invno = "";
var patientClass = "";
var statusDesc = Context.State_Master.Where(x => x.State_Name == CampAdmission.C_StateDesc).Select(x => x.State_Code).FirstOrDefault();
CampAdmission.StateCode = statusDesc;
var CountryDesc = Context.Country_Master.Where(x => x.Country_Name == CampAdmission.C_CountryDesc).Select(x => x.Country_Code).FirstOrDefault();
CampAdmission.ContryCode = CountryDesc;
var Districtcodes = Context.District_Master.Where(x => x.District_Name == CampAdmission.C_DistrictDesc).Select(x => x.District_Code).FirstOrDefault();
CampAdmission.DistrictCode = Districtcodes;
var talukcodes = Context.Taluk_Master.Where(x => x.Taluk_Name == CampAdmission.C_TalukDesc).Select(x => x.Taluk_Code).FirstOrDefault();
CampAdmission.Taluk_Code = talukcodes;
if (CampAdmission.IsCOTChecked == "Y")
{
CampAdmission.bedCharges = Context.StateBedCharges.Where(o => o.StateID == CampAdmission.StateCode).Select(x => x.COTCharges).FirstOrDefault();
}
else if (CampAdmission.IsMATChecked == "Y")
{
CampAdmission.bedCharges = Context.StateBedCharges.Where(o => o.StateID == CampAdmission.StateCode).Select(x => x.MATCharges).FirstOrDefault();
}
mrNo = GenerateRunningCtrlNo("MR_NO_CAMP", CampAdmission.Site_ID);
uin = GenerateRunningCtrlNo("UIN", CampAdmission.Site_ID);
CampAdmission.mr_no = mrNo;
CampAdmission.uin = uin;
if (CampAdmission.IDProof_Desc == "Aadhar Card")
{
aadNo = CampAdmission.IDProof_Code;
}
//if (CampAdmission.bedCharges > 0)
//{
// ipano = GenerateRunningCtrlNo("CIPA_NO", CampAdmission.Site_ID);
// patientClass = "SITE03";
//}
//else if (CampAdmission.bedCharges == 0)
//{
ipano = GenerateRunningCtrlNo("FIPA_NO", CampAdmission.Site_ID);
patientClass = "SITE02";
// }
ipno = GenerateRunningCtrlNo("CAMP_IP_NO ", CampAdmission.Site_ID);
CampAdmission.ipno = ipno;
invno = GenerateRunningCtrlNo("INVOICE_NO", CampAdmission.Site_ID);
var icpl = new Ip_Camp_Place();
icpl.mr_no = mrNo;
icpl.ipa_no = ipano;
icpl.Admission_place = CampAdmission.Admission_Place;
icpl.Sysdate = DateTime.Now;
Context.ip_camp_place.Add(icpl);
var ipadmissions = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).FirstOrDefault();
if (ipadmissions != null)
{
ipadmissions.LAST_ALLOCATION -= 1;
Context.Entry(ipadmissions).State = EntityState.Modified;
}
var isOPeXists = Context.Op_Visit_Datewise.Where(x => x.Date == DateTime.Now.Date && x.Patient_Class == patientClass).Count();
var opvd = Context.Op_Visit_Datewise.Where(x => x.Patient_Class == patientClass && x.Date == DateTime.Now.Date).FirstOrDefault();
var opvdw = new OpVisitDatewise();
opvdw.Patient_Class = patientClass;
opvdw.Date = DateTime.Now.Date;
opvdw.New = 0;
opvdw.Old = 0;
opvdw.Week_Day = (int)DateTime.Now.DayOfWeek;
if (isOPeXists > 0)
{
//Context.Op_Visit_Datewise.Update(opvdw);
if (opvd != null)
{
opvd.Admission += 1;
Context.Entry(opvd).State = EntityState.Modified;
}
}
//else if (isOPeXists == 0)
//{
// Context.Op_Visit_Datewise.Add(opvdw);
//}
var PRM = new PatientRegistrationMaster();
PRM.MR_NO = mrNo;
PRM.IP_NO = ipno;
PRM.Patient_Class = patientClass;
PRM.Patient_Name = CampAdmission.Patient_Name;
PRM.Next_Of_Kin = $"{CampAdmission.Next_Of_Kin_Prefix},{CampAdmission.Next_Of_Kin_Suffix}";
PRM.Date_Of_Birth = CampAdmission.Patient_DOB;
PRM.Sex = CampAdmission.Gender;
PRM.Door = CampAdmission.Door;
PRM.Street_Locality = CampAdmission.Street;
PRM.Pincode = CampAdmission.Pincode;
PRM.Town_City = CampAdmission.City;
PRM.Taluk = CampAdmission.Taluk_Code;
PRM.District = CampAdmission.DistrictCode;
PRM.State = CampAdmission.StateCode;
PRM.Country = CampAdmission.ContryCode;
PRM.Phone = CampAdmission.Phone_No;
PRM.Registered_Date = DateTime.Now;
PRM.Last_Visit_Date = DateTime.Now;
PRM.AadhaarNo = CampAdmission.Master.AadhaarNo;
PRM.Base_Unit = "LC15";
PRM.Last_Unit_Visited = "LC15";
PRM.Visit_Number = 1;
PRM.Sysdate = DateTime.Now;
PRM.UIN = uin;
//PRM.AadhaarNo = aadNo;
PRM.SiteId = CampAdmission.Site_ID;
Context.Patient_Registration_Master.Add(PRM);
var PRD = new PatientRegistrationDetail();
PRD.MR_NO = mrNo;
PRD.Allocation_Code = "LC15";
PRD.Visit_Date = DateTime.Now;
PRD.Visit_Number = 1;
PRD.Category_Code = "CATC002";
PRD.Type_Code = "PTY001";
PRD.Instance_Code = "INSC001";
PRD.Speciality_Code = "SPC001";
PRD.Sysdate = DateTime.Now;
PRD.Allocation_Code = "LC007";
PRD.Camp_Code = CampAdmission.Camp_Code;
PRD.UIN = uin;
PRD.SiteId = CampAdmission.Site_ID;
Context.Patient_Registration_Detail.Add(PRD);
var LM = new MRLocationMaster();
LM.MR_NO = mrNo;
LM.Location_Code = "LC15";
LM.Patient_Name = CampAdmission.Patient_Name;
LM.Town_City = CampAdmission.City;
LM.UIN = uin;
LM.SiteId = 1;
Context.MR_Location_Master.Add(LM);
var PS = new PatientStatus();
PS.Visit_Date = DateTime.Now;
PS.MR_NO = mrNo;
PS.Assign_Doctor = "N";
PS.UIN = uin;
//PS.PurposeId = Convert.ToInt32( CampAdmission.Camp_Code);
PS.PurposeId = 42;
PS.SiteId = CampAdmission.Site_ID;
Context.Patient_Status.Add(PS);
if (CampAdmission.History.Count() > 0)
{
foreach (var item in CampAdmission.History.ToList())
{
var PH = new PatientHistory();
PH.UIN = uin;
PH.MR_NO = mrNo;
PH.PatientHistoryDescription = item.PatientHistoryDescription;
PH.DurationMonth = item.DurationMonth;
PH.DurationYear = item.DurationYear;
PH.CreatedUTC = DateTime.Now;
PH.CreatedBy = Convert.ToInt32(CampAdmission.Operator_ID);
PH.SiteId = CampAdmission.Site_ID;
Context.PatientHistory.AddRange(PH);
}
}
var IDPD = new IDProofDtl();
IDPD.UIN = uin;
IDPD.MR_NO = mrNo;
IDPD.PROOF_TYPE = CampAdmission.IDProof_Code;
IDPD.PROOF_NO = CampAdmission.IDProof_Desc;
IDPD.CASTE_CODE = Convert.ToString(CampAdmission.Caste_Code);
Context.IDProof_Dtl.Add(IDPD);
var IPSD = new IpSurgeryDtl();
IPSD.Ipa_No = ipano;
IPSD.Surgery_Code = CampAdmission.Surgery_Code;
IPSD.Surgery_Type_Code = "T";
IPSD.Anaesthesia = "AN002";
IPSD.Doctor_Code = "401";
IPSD.Eye = CampAdmission.Eye_Code;
IPSD.Surgery_Date = DateTime.Now.Date;
IPSD.Surgery_Approval = "Y";
IPSD.Surgery_Done = "N";
IPSD.SiteId = CampAdmission.Site_ID;
IPSD.UIN = uin;
Context.Ip_Surgery_Dtl.Add(IPSD);
var IPAcc = new IPAccount();
IPAcc.Ipa_No = ipano;
IPAcc.Mr_No = mrNo;
IPAcc.Status = "ADM";
IPAcc.System = DateTime.Now;
IPAcc.Ip_No = ipno;
IPAcc.Siteid = CampAdmission.Site_ID;
IPAcc.Uin = uin;
PRM.IPAccountIC = new List <IPAccount>()
{
IPAcc
};
var IPA = new IPAdmission();
IPA.Ipa_No = ipano;
IPA.Ip_No = ipno;
IPA.Mr_No = mrNo;
IPA.Surgery_Code = CampAdmission.Surgery_Code;
IPA.Surgery_Type_Code = "T";
IPA.Admission_Date = DateTime.Now;
IPA.Room_Type = "FREETYPE7";
IPA.Room_No = CampAdmission.Room_No;
IPA.Expected_Discharge_Date = DateTime.Now.AddDays(2);
IPA.Doctor_Code = "401";
IPA.Category_Code = "CATC002";
IPA.Anesthesia = "AN002";
IPA.Discharge_Status = "ADM";
IPA.Eye = CampAdmission.Eye_Code;
//IPA.Ipa_No = ipno;
IPA.Room_Type2 = null;
IPA.Lens_Code = CampAdmission.Lens_Code;
IPA.Operator_Code = CampAdmission.Operator_ID;
IPA.Camp_Code = CampAdmission.Camp_Code;
IPA.UIN = uin;
IPA.SiteId = CampAdmission.Site_ID;
PRM.IPAdmissionIC = new List <IPAdmission>()
{
IPA
};
if (CampAdmission.bedCharges > 0)
{
var IM = new InvoiceMaster();
IM.Invoice_No = invno;
IM.Invoice_Date = DateTime.Now;
IM.Invoice_Value = float.Parse(CampAdmission.bedCharges.ToString());
IM.Invoice_Received_Value = float.Parse(CampAdmission.bedCharges.ToString());
IM.Module_Code = "MOD4";
IM.SiteId = CampAdmission.Site_ID;
IM.UIN = uin;
IM.MR_NO = mrNo;
PRM.Invoice_Master = new List <InvoiceMaster>()
{
IM
};
var accDtl = new IpAccountDtl();
if (CampAdmission.bedCharges > 0)
{
accDtl.Ipa_Sl_No = Convert.ToInt32(GenerateRunningCtrlNo("IPA_SL_NO", CampAdmission.Site_ID));
accDtl.Ipa_No = ipano;
accDtl.Cash_Flow_Code = "501";
accDtl.Tinvoice_No = invno;
accDtl.Sysdate = DateTime.Now;
accDtl.Date = DateTime.Now.Date;
accDtl.Cost_Value = Convert.ToDecimal(CampAdmission.bedCharges);
accDtl.UIN = uin;
accDtl.SiteId = CampAdmission.Site_ID;
Context.Ip_Account_Dtl.Add(accDtl);
}
var cashPaid = new CashPaid();
if (CampAdmission.bedCharges > 0)
{
cashPaid.Operator_Code = CampAdmission.Operator_ID;
cashPaid.Module_Code = "MOD4";
cashPaid.MR_NO = mrNo;
cashPaid.IPA_NO = ipano;
cashPaid.Receipt_NO = GenerateRunningCtrlNo("FRES_RECEIPT_NO", CampAdmission.Site_ID);
cashPaid.Fees_Paid = Convert.ToDouble(CampAdmission.bedCharges);
cashPaid.Date = DateTime.Now.Date;
cashPaid.Transaction_Code = "RECPT";
cashPaid.Category_Code = "CATC001";
cashPaid.Sysdate = DateTime.Now;
cashPaid.OP_IP_Flag = "IP";
cashPaid.Paymode_Code = "PC001";
cashPaid.Outstanding = "N";
cashPaid.Invoice_No = invno;
cashPaid.UIN = uin;
cashPaid.SiteId = CampAdmission.Site_ID;
Context.Cash_Paid.Add(cashPaid);
}
}
}
try
{
if (Context.SaveChanges() > 0)
{
return new
{
Success = true,
name = CampAdmission.Patient_Name,
eyes = CampAdmission.Eye_Code,
taluks = CampAdmission.C_TalukDesc,
DistrictDesc = CampAdmission.C_DistrictDesc,
StateDesc = CampAdmission.C_StateDesc,
CountryDesc = CampAdmission.C_CountryDesc,
MRNO = CampAdmission.mr_no,
UIN = CampAdmission.uin,
Siteid = CampAdmission.Site_ID,
campcodes = CampAdmission.Camp_Code,
campnames = Context.CAMP_MASTER.Where(x => x.CAMP_CODE == CampAdmission.Camp_Code).Select(x => x.CAMP_NAME).FirstOrDefault(),
ages = CampAdmission.Age,
sex = CampAdmission.Gender,
kins = CampAdmission.Next_Of_Kin_Suffix,
room = CampAdmission.Room_No,
town = CampAdmission.City,
numer = CampAdmission.Phone_No,
ipnos = CampAdmission.ipno,
VacantBed = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).Select(x => x.LAST_ALLOCATION).FirstOrDefault(),
Endrange = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).Select(x => x.END_RANGE).FirstOrDefault(),
}
}
;
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(new
{
Success = false,
message = "Details not saved!"
});
}
private void simpleButton1_Click(object sender, EventArgs e)
{
PatientStatus ps = new PatientStatus();
ps.ShowDialog();
}
public void Delete(PatientStatus ps)
{
_context.PatientStatuses.Remove(ps);
}
public void Update(PatientStatus ps)
{
// foo
}
public void CreateStatus(PatientStatus ps)
{
_context.PatientStatuses.Add(ps);
}
///<summary>Creates a patient. Practice default provider and billing type.</summary>
public static Patient CreatePatient(string suffix = "", long priProvNum = 0, long clinicNum = 0, string email = "", string phone = "",
ContactMethod contactMethod = ContactMethod.Email, string lName = "", string fName = "", string preferredName = "", DateTime birthDate = default(DateTime)
, long secProvNum = 0, long guarantor = 0, bool setPortalAccessInfo = false, PatientStatus patStatus = PatientStatus.Patient, bool hasSignedTil = false)
{
Patient pat = new Patient {
Email = email,
PreferConfirmMethod = contactMethod,
PreferContactConfidential = contactMethod,
PreferContactMethod = contactMethod,
PreferRecallMethod = contactMethod,
HmPhone = phone,
WirelessPhone = phone,
IsNew = true,
LName = lName + suffix,
FName = fName + suffix,
BillingType = PrefC.GetLong(PrefName.PracticeDefaultBillType),
ClinicNum = clinicNum,
Preferred = preferredName,
Birthdate = birthDate,
SecProv = secProvNum,
PatStatus = patStatus,
HasSignedTil = hasSignedTil,
};
if (priProvNum != 0)
{
pat.PriProv = priProvNum;
}
else
{
long practiceProvNum = PrefC.GetLong(PrefName.PracticeDefaultProv);
//Check the provider cache to see if the ProvNum set for the PracticeDefaultProv pref actually exists.
if (!Providers.GetExists(x => x.ProvNum == practiceProvNum))
{
practiceProvNum = Providers.GetFirst().ProvNum;
//Update the preference in the database NOT the unit test preference cache to a valid provider if the current pref value is invalid.
Prefs.UpdateLong(PrefName.PracticeDefaultProv, practiceProvNum);
}
pat.PriProv = practiceProvNum;
}
if (setPortalAccessInfo)
{
pat.Address = "666 Church St NE";
pat.City = "Salem";
pat.State = "OR";
pat.Zip = "97301";
if (pat.Birthdate.Year < 1880)
{
pat.Birthdate = new DateTime(1970, 1, 1);
}
if (string.IsNullOrEmpty(pat.WirelessPhone))
{
pat.WirelessPhone = "5555555555";
}
}
Patients.Insert(pat, false);
Patient oldPatient = pat.Copy();
pat.Guarantor = pat.PatNum;
if (guarantor > 0)
{
pat.Guarantor = guarantor;
}
if (lName == "")
{
pat.LName = pat.PatNum.ToString() + "L";
}
if (fName == "")
{
pat.FName = pat.PatNum.ToString() + "F";
}
Patients.Update(pat, oldPatient);
return(pat);
}
public async Task <int> CovidStatus(PatientStatus item)
{
var ds = new DeleteCreate(_context);
return(await ds.Status(item));
}
