public int PatientRemove(int patientId) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); chsi.dat.payNewPatients patient = db.payNewPatients.Where(a => a.payNewPatientId == patientId).FirstOrDefault(); if (patient == null) return 0; patient.Active = false; db.SaveChanges(); return patientId; }
public bool PatientContactSave(int patientId, string employee, string whatHappened, string notes, bool isDND, bool isIneligible, bool isCallback, bool isApptMade, DateTime? callBackDateTime, DateTime? apptDateTime) { try { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); string details = ""; chsi.dat.payNewPatientContacts c = new chsi.dat.payNewPatientContacts(); c.payNewPatientId = patientId; c.ContactDate = DateTime.Now; c.EmployeeName = employee; switch (whatHappened.ToLower().Trim()) { case "phonenoanswer": c.isPhoneNoAnswer = true; break; case "phoneanswer": c.isPhoneAnswered = true; break; case "phoneleftmessage": c.isPhoneLeftMessage = true; break; case "phonebusy": c.isPhoneBusy = true; break; case "phonewrongnumber": c.isPhoneWrongNumber = true; break; case "phonedisconnected": c.isPhoneDisconnected = true; break; case "postcardsent": c.isPostCardSent = true; break; } c.isDoNotDisturbRequested = isDND; c.isIneligible = isIneligible; c.isRequestCallBack = isCallback; c.isApptMade = isApptMade; if (isCallback) { c.CallBack = callBackDateTime; DateTime dt = (DateTime)callBackDateTime; details = string.Format("Callback requested for {0} {1}{2}", dt.ToShortDateString(), (dt.Hour > 0 ? dt.ToShortTimeString() : ""), Environment.NewLine); } if (isApptMade) { c.Appt = apptDateTime; DateTime dt = (DateTime)apptDateTime; details = string.Format("Appointment made for {0} {1}{2}", dt.ToShortDateString(), (dt.Hour > 0 ? dt.ToShortTimeString() : ""), Environment.NewLine); } if (isDND) { details += "Patient requests Do Not Disturb" + Environment.NewLine; } if (isIneligible) { details += "Patient is inelibible" + Environment.NewLine; } details += notes; c.Details = details; db.AddTopayNewPatientContacts(c); db.SaveChanges(); return true; } catch (Exception e) { } return false; }
protected void btnSaveAssist_Click(object sender, EventArgs e) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); int _assistId = 0; int _appId = 0; if (!String.IsNullOrEmpty(Request.QueryString["assistId"])) { string assistId = Request.QueryString["assistId"]; int.TryParse(assistId, out _assistId); } if (!String.IsNullOrEmpty(Request.QueryString["appId"])) { string appId = Request.QueryString["appId"]; int.TryParse(appId, out _appId); } if (_assistId == 0) { chsi.dat.acaAssists newAssist = new acaAssists(); newAssist.Notes = txtNotes.Text; newAssist.AssistDate = Convert.ToDateTime(txtDateOfEncounter.Text); newAssist.PrimaryApplicantId = _appId; newAssist.RegionId = Convert.ToInt32(ddlRegion.SelectedValue); newAssist.SiteId = Convert.ToInt32(ddlSite.SelectedValue); newAssist.AssistTypeId = Convert.ToInt32(ddlAssistType.SelectedValue); newAssist.RepresentativeId = Convert.ToInt32(ddlPSR.SelectedValue); if (ddlAssistType.SelectedValue == "7") newAssist.isSubmission = true; else newAssist.isSubmission = false; if (ddlAssistType.SelectedValue == "9") newAssist.isEnrolled = true; else newAssist.isEnrolled = false; db.acaAssists.AddObject(newAssist); db.SaveChanges(); } else { acaAssists assist = (from a in db.acaAssists where a.AssistId == _assistId select a).FirstOrDefault(); assist.Notes = txtNotes.Text; assist.AssistDate = Convert.ToDateTime(txtDateOfEncounter.Text); assist.RegionId = Convert.ToInt32(ddlRegion.SelectedValue); assist.SiteId = Convert.ToInt32(ddlSite.SelectedValue); assist.AssistTypeId = Convert.ToInt32(ddlAssistType.SelectedValue); assist.RepresentativeId = Convert.ToInt32(ddlPSR.SelectedValue); if (ddlAssistType.SelectedValue == "7") assist.isSubmission = true; else assist.isSubmission = false; if (ddlAssistType.SelectedValue == "9") assist.isEnrolled = true; else assist.isEnrolled = false; db.SaveChanges(); } foreach (RepeaterItem item in rptrFamily.Items) { HiddenField applicantId = (HiddenField)item.FindControl("hidApplicantId"); CheckBox submission = (CheckBox)item.FindControl("cbxSubmission"); CheckBox enrolled = (CheckBox)item.FindControl("cbxEnrolled"); CheckBox providerSelected = (CheckBox)item.FindControl("cbxProviderSelected"); DropDownList payer = (DropDownList)item.FindControl("ddlPayers"); DropDownList types = (DropDownList)item.FindControl("ddlTypes"); DropDownList tiers = (DropDownList)item.FindControl("ddlTiers"); DropDownList subTiers = (DropDownList)item.FindControl("ddlSubTiers"); int appId = Convert.ToInt32(applicantId.Value); //Save Applicant acaApplicants app = (from a in db.acaApplicants where a.ApplicantId == appId select a).FirstOrDefault(); app.IsEnrolled = enrolled.Checked; app.IsSubmission = submission.Checked; app.SelectedCHSIProvider = providerSelected.Checked; db.SaveChanges(); //Save health plan acaHealthPlans hp = (from h in db.acaHealthPlans where h.ApplicantId == appId select h).FirstOrDefault(); if (payer.SelectedIndex > 0) hp.PayerId = Convert.ToInt32(payer.SelectedValue); else hp.PayerId = null; if (types.SelectedIndex > 0) hp.PlanTypeId = Convert.ToInt32(types.SelectedValue); else hp.PlanTypeId = null; if (tiers.SelectedIndex > 0) hp.PlanTierId = Convert.ToInt32(tiers.SelectedValue); else hp.PlanTierId = null; if (subTiers.SelectedIndex > 0) hp.PlanSubTierId = Convert.ToInt32(subTiers.SelectedValue); else hp.PlanSubTierId = null; db.SaveChanges(); } //total assists for each assist record int totalAssistCount = db.acaAssists.Where(a => a.PrimaryApplicantId == _appId).Count(); int totalEnrolled = db.acaAssists.Where(a => a.AssistTypeId == 9 && a.PrimaryApplicantId == _appId).Count(); int totalSubmitted = db.acaAssists.Where(a => a.AssistTypeId == 7 && a.PrimaryApplicantId == _appId).Count(); int familyCount = db.acaApplicants.Where(a => a.PrimaryApplicantId == _appId || a.ApplicantId == _appId).Count(); var some = db.acaAssists.Where(a => a.PrimaryApplicantId == _appId).ToList(); some.ForEach(a => a.NumberAssisted = (totalAssistCount * familyCount)); some.ForEach(a => a.NumberEnrolled = (totalEnrolled)); some.ForEach(a => a.NumberSubmitted = (totalSubmitted)); db.SaveChanges(); Response.Redirect(string.Format("/aca/assists?appId={0}", _appId)); }
protected void btnAddApplicant_Click(object sender, EventArgs e) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); int _appId = 0; if (!String.IsNullOrEmpty(Request.QueryString["appId"])) { string appId = Request.QueryString["appId"]; int.TryParse(appId, out _appId); } if (_appId == 0) { chsi.dat.acaApplicants app = new acaApplicants(); app.FirstName = this.txtFirstName.Text.Trim(); app.LastName = this.txtLastName.Text.Trim(); //app.Email = this.txtEmail.Text.Trim(); //app.Address = this.txtAddress.Text.Trim(); //app.City = this.txtCity.Text.Trim(); app.isPrimary = true; app.DateOfBirth = Convert.ToDateTime(this.txtDOB.Text); app.Phone = this.txtPhone.Text.Trim(); app.RegionId = int.Parse(this.ddRegion.SelectedValue); app.isActive = this.chkActive.Checked; //app.Zip = this.txtZip.Text.Trim(); app.Notes = this.txtNotes.Text.Trim(); db.acaApplicants.AddObject(app); db.SaveChanges(); int appId = app.ApplicantId; acaHealthPlans hp = new acaHealthPlans(); hp.ApplicantId = appId; db.acaHealthPlans.AddObject(hp); db.SaveChanges(); Response.Redirect(string.Format("/aca/assists?appId={0}", appId)); } else { acaApplicants app = (from a in db.acaApplicants where a.ApplicantId == _appId select a).FirstOrDefault(); app.FirstName = this.txtFirstName.Text.Trim(); app.LastName = this.txtLastName.Text.Trim(); //app.Email = this.txtEmail.Text.Trim(); //app.Address = this.txtAddress.Text.Trim(); //app.City = this.txtCity.Text.Trim(); app.DateOfBirth = Convert.ToDateTime(this.txtDOB.Text); app.isPrimary = true; app.Phone = this.txtPhone.Text.Trim(); app.RegionId = int.Parse(this.ddRegion.SelectedValue); app.isActive = this.chkActive.Checked; //app.Zip = this.txtZip.Text.Trim(); app.Notes = this.txtNotes.Text.Trim(); db.SaveChanges(); Response.Redirect(string.Format("/aca/assists?appId={0}", _appId)); } }
public int SaveApplicant(string FirstName, string LastName, string DateOfBirth, string Region , string Active, string Address, string City, string Zip , string Phone, string Email, string Notes) { chsi.dat.acaApplicants applicant = new chsi.dat.acaApplicants(); applicant.FirstName = FirstName; applicant.LastName = LastName; applicant.isActive = (Active == "true")? true : false; applicant.Address = Address; applicant.City = City; applicant.Zip = Zip; applicant.Phone = Phone; applicant.Email = Email; applicant.DateOfBirth = Convert.ToDateTime(DateOfBirth); applicant.RegionId = Convert.ToInt32(Region); applicant.Notes = Notes; chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); db.acaApplicants.AddObject(applicant); db.SaveChanges(); return applicant.ApplicantId; }
protected void btnSaveAssist_Click(object sender, EventArgs e) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); int _assistId = 0; int _appId = 0; _submissionId = int.Parse(ddlAssistType.Items.FindByText("Submitting application").Value); _enrolledId = int.Parse(ddlAssistType.Items.FindByText("Enrollment Confirmation, payment submitted").Value); if (!String.IsNullOrEmpty(Request.QueryString["assistId"])) { string assistId = Request.QueryString["assistId"]; int.TryParse(assistId, out _assistId); } if (!String.IsNullOrEmpty(Request.QueryString["appId"])) { string appId = Request.QueryString["appId"]; int.TryParse(appId, out _appId); } chsi.dat.acaAssists assist = new acaAssists(); if (_assistId > 0) { assist = (from a in db.acaAssists where a.AssistId == _assistId select a).FirstOrDefault(); } assist.Notes = txtNotes.Text; assist.AssistDate = Convert.ToDateTime(txtDateOfEncounter.Text); assist.PrimaryApplicantId = _appId; assist.RegionId = Convert.ToInt32(ddlRegion.SelectedValue); assist.SiteId = Convert.ToInt32(ddlSite.SelectedValue); assist.AssistTypeId = Convert.ToInt32(ddlAssistType.SelectedValue); assist.RepresentativeId = Convert.ToInt32(ddlPSR.SelectedValue); assist.isSubmission = (int.Parse(ddlAssistType.SelectedValue) == _submissionId); assist.isEnrolled = (int.Parse(ddlAssistType.SelectedValue) == _enrolledId); int familyCount = db.acaApplicants.Where(a => a.PrimaryApplicantId == _appId || a.ApplicantId == _appId).Count(); assist.NumberAssisted = familyCount; if (assist.isSubmission ) { //get previous totals int prevSubmitted = 0; int.TryParse(db.acaAssists.Where(a => a.AssistTypeId == _submissionId && a.PrimaryApplicantId == _appId).ToList().Select(a => a.NumberAssisted).Sum().ToString(), out prevSubmitted); int totalSubmitted = GetCount("cbxSubmission"); assist.NumberAssisted = Math.Abs(totalSubmitted - prevSubmitted); } if (assist.isEnrolled) { //get previous totals int prevEnrolled = 0; int.TryParse(db.acaAssists.Where(a => a.AssistTypeId == _enrolledId && a.PrimaryApplicantId == _appId).ToList().Select(a => a.NumberAssisted).Sum().ToString(), out prevEnrolled); int totalEnrolled = GetCount("cbxEnrolled"); assist.NumberAssisted = Math.Abs(totalEnrolled - prevEnrolled); } if (_assistId == 0) db.acaAssists.AddObject(assist); //only update health plans if this is an enrollment or submission if (assist.isEnrolled || assist.isSubmission) UpdateHealthPlans(); db.SaveChanges(); Response.Redirect(string.Format("/aca/assists?appId={0}", _appId)); }
private void UpdateHealthPlans() { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); foreach (RepeaterItem item in rptrFamily.Items) { HiddenField applicantId = (HiddenField)item.FindControl("hidApplicantId"); CheckBox submission = (CheckBox)item.FindControl("cbxSubmission"); CheckBox enrolled = (CheckBox)item.FindControl("cbxEnrolled"); CheckBox providerSelected = (CheckBox)item.FindControl("cbxProviderSelected"); DropDownList payer = (DropDownList)item.FindControl("ddlPayers"); DropDownList types = (DropDownList)item.FindControl("ddlTypes"); DropDownList tiers = (DropDownList)item.FindControl("ddlTiers"); DropDownList subTiers = (DropDownList)item.FindControl("ddlSubTiers"); int appId = Convert.ToInt32(applicantId.Value); //Save Applicant acaApplicants app = (from a in db.acaApplicants where a.ApplicantId == appId select a).FirstOrDefault(); app.IsEnrolled = enrolled.Checked; app.IsSubmission = submission.Checked; app.SelectedCHSIProvider = providerSelected.Checked; db.SaveChanges(); //Save health plan acaHealthPlans hp = (from h in db.acaHealthPlans where h.ApplicantId == appId select h).FirstOrDefault(); if (payer.SelectedIndex > 0) hp.PayerId = Convert.ToInt32(payer.SelectedValue); else hp.PayerId = null; if (types.SelectedIndex > 0) hp.PlanTypeId = Convert.ToInt32(types.SelectedValue); else hp.PlanTypeId = null; if (tiers.SelectedIndex > 0) hp.PlanTierId = Convert.ToInt32(tiers.SelectedValue); else hp.PlanTierId = null; if (subTiers.SelectedIndex > 0) hp.PlanSubTierId = Convert.ToInt32(subTiers.SelectedValue); else hp.PlanSubTierId = null; db.SaveChanges(); } }