private void UploadFile(string fullPath) { chsi.dat.payFileImports fi = new chsi.dat.payFileImports(); if (this.ddFileType.SelectedValue == "IEHP") { chsi.dom.pay.ImportIEHP i = new chsi.dom.pay.ImportIEHP(); i.ImportFile(fullPath); } if (this.ddFileType.SelectedValue == "LIHP") { chsi.dom.pay.ImportLIHP i = new chsi.dom.pay.ImportLIHP(); i.ImportFile(fullPath); } if (this.ddFileType.SelectedValue == "CHG") { chsi.dom.pay.ImportCHG i = new chsi.dom.pay.ImportCHG(); i.ImportFile(fullPath); } chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); chsi.dat.payFileImports fileImp = db.payFileImports.OrderByDescending(a => a.payFileImport).First(); decimal ratio = decimal.Round((decimal)fileImp.MembersWithVisits / (decimal)fileImp.MemberCount, 2); int iRatio = (int)(ratio *100); string sRatio = iRatio.ToString() + "%"; lblMessage.Text = string.Format("Members Added: <b>{0}</b><br/>Members Removed: <b>{1}</b><br/>Total Member Count: <b>{2}</b><br/>Members With Visits: <b>{3}</b><br/>Member/Visit Ratio: <b>{4}</b>", fileImp.NewMembers, fileImp.DeletedMembers, fileImp.MemberCount, fileImp.MembersWithVisits, sRatio); }
protected void btnSearchDependent_Click(object sender, EventArgs e) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); string firstName = txtFirstName.Text.Trim(); string lastName = txtLastName.Text.Trim(); List<acaApplicants> dependents; if (!String.IsNullOrEmpty(firstName) && !String.IsNullOrEmpty(lastName)) { dependents = db.acaApplicants.Where(col => col.PrimaryApplicantId != null && col.FirstName.Contains(txtFirstName.Text.Trim()) && col.LastName.Contains(txtLastName.Text.Trim())).ToList(); } else if (!String.IsNullOrEmpty(firstName) && String.IsNullOrEmpty(lastName)) { dependents = db.acaApplicants.Where(col => col.PrimaryApplicantId != null && col.FirstName.Contains(txtFirstName.Text.Trim())).ToList(); } else if (String.IsNullOrEmpty(firstName) && !String.IsNullOrEmpty(lastName)) { dependents = db.acaApplicants.Where(col => col.PrimaryApplicantId != null && col.LastName.Contains(txtLastName.Text.Trim())).ToList(); } else { dependents = db.acaApplicants.Where(col => col.PrimaryApplicantId != null).ToList(); } rptItems.DataSource = dependents; rptItems.DataBind(); }
public ImportCHG() { db = new chsi.dat.CHSIEntities(); providers = new Dictionary<string, string>(); currentMembers = new List<int>(); _payer = Payers.CHG; }
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; }
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 string PatientLoad(int patientId) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); var patient = (from p in db.payNewPatients join payers in db.payPatientPayers on p.payNewPatientId equals payers.payNewPatientId join busLines in db.payBusinessLines on p.payBusinessLineId equals busLines.payBusinessLineId where p.payNewPatientId == patientId select new {p.DOB, payers.HMOId, p.Address, p.City, p.State, p.Zip, p.Phone, p.NG_provider_id, BusinessLine =busLines.Name, Payer = payers.payPayers.Name }).FirstOrDefault(); chsi.dom.hlp.EFSerializer efs = new chsi.dom.hlp.EFSerializer(); return efs.EFSerialize(patient); }
public string PatientContactsLoad(int patientId) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); List<chsi.dat.payNewPatientContacts> contacts = (from c in db.payNewPatientContacts where c.payNewPatientId == patientId orderby c.ContactID select c).ToList(); chsi.dom.hlp.EFSerializer efs = new chsi.dom.hlp.EFSerializer(); return efs.EFSerialize(contacts); }
private void LoadData() { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); chsi.dat.acaApplicants app = db.acaApplicants.FirstOrDefault(a => a.ApplicantId == _appId); int depCount = db.acaApplicants.Where(a => a.PrimaryApplicantId == _appId).Count(); litPrimaryApplicantName.Text = app.FirstName + " " + app.LastName + "<BR>Total Dependents: " + depCount; List<chsi.dat.acaAssists> assists = app.acaAssists.ToList(); //foreach (chsi.dat.acaAssists ass in assists) // Response.Write(ass.Notes + "<BR>"); DataTable dt; //if (!String.IsNullOrEmpty(Request.QueryString["appId"])) //{ // string appId = Request.QueryString["appId"]; dt = Data.GetAssistsByPrimaryApplicantID(_appId.ToString()); // if (dt.Rows.Count > 0) // litPrimaryApplicantName.Text = "Primary Applicant: " + dt.Rows[0]["FirstName"].ToString() + " " + dt.Rows[0]["LastName"].ToString(); //} //else //{ // dt = Data.GetAssists(); // btnNewAssist.Visible = false; //} this.rptItems.Visible = false; if (dt.Rows.Count == 0) { litEmpty.Text = "No Assists at This Time."; litEmpty.Visible = true; return; } //string filter = "1 = 1"; ////apply filters //if (ddPSR.SelectedIndex > 0) // filter += string.Format(" AND RepresentativeId = '{0}'", ddPSR.SelectedValue); //if (ddSite.SelectedIndex > 0) // filter += string.Format(" AND SiteId = '{0}'", ddSite.SelectedValue); //bind repeater //dt.DefaultView.RowFilter = filter; this.rptItems.DataSource = dt; this.rptItems.DataBind(); this.rptItems.Visible = true; }
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 rptrFamily_ItemDataBound(object sender, RepeaterItemEventArgs e) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DropDownList players = ((DropDownList)e.Item.FindControl("ddlPayers")); DropDownList types = ((DropDownList)e.Item.FindControl("ddlTypes")); DropDownList tiers = ((DropDownList)e.Item.FindControl("ddlTiers")); DropDownList subTiers = ((DropDownList)e.Item.FindControl("ddlSubTiers")); HiddenField applicantId = ((HiddenField)e.Item.FindControl("hidApplicantId")); int appId = Convert.ToInt32(applicantId.Value); acaHealthPlans plan = db.acaHealthPlans.Where(h => h.ApplicantId == appId).FirstOrDefault(); if (plan != null) { players.DataSource = _payers; players.DataTextField = "Payer"; players.DataValueField = "PayerId"; players.DataBind(); players.Items.Insert(0, new ListItem("Select Payer", "0")); players.SelectedValue = plan.PayerId.ToString(); types.DataSource = _types; types.DataTextField = "PlanType"; types.DataValueField = "PlanTypeId"; types.DataBind(); types.Items.Insert(0, new ListItem("Select Type", "0")); types.SelectedValue = plan.PlanTypeId.ToString(); tiers.DataSource = _tiers; tiers.DataTextField = "tier"; tiers.DataValueField = "PlanTierId"; tiers.DataBind(); tiers.Items.Insert(0, new ListItem("Select Tier", "0")); tiers.SelectedValue = plan.PlanTierId.ToString(); subTiers.DataSource = _sub; subTiers.DataTextField = "SubTier"; subTiers.DataValueField = "PlanSubTierId"; subTiers.DataBind(); subTiers.Items.Insert(0, new ListItem("Select Sub Tier", "0")); subTiers.SelectedValue = plan.PlanSubTierId.ToString(); } } }
protected void Page_Load(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 (!IsPostBack) { DataSet dsDropdownData = Data.GetDropdownData_Applicants(); AddDropDownItems(dsDropdownData.Tables[0], ddlPSR, "FullName", "RepresentativeId"); AddDropDownItems(dsDropdownData.Tables[1], ddlRegion, "Region", "RegionId"); AddDropDownItems(dsDropdownData.Tables[2], ddlSite, "SiteName", "SiteId"); AddDropDownItems(dsDropdownData.Tables[4], ddlAssistType, "AssistType", "AssistTypeId"); _payers = db.acaPayers.Where(p => p.IsActive == true).OrderBy(s => s.SortOrder).ToList(); _types = db.acaPlanTypes.Where(p => p.IsActive == true).OrderBy(s => s.SortOrder).ToList(); _tiers = db.acaPlanTiers.Where(p => p.IsActive == true).OrderBy(s => s.SortOrder).ToList(); _sub = db.acaPlanSubTiers.Where(p => p.IsActive == true).OrderBy(s => s.SortOrder).ToList(); List<acaApplicants> apps = db.acaApplicants.Where(a => a.PrimaryApplicantId == _appId || a.ApplicantId == _appId).ToList(); rptrFamily.DataSource = apps; rptrFamily.DataBind(); if (_assistId > 0) { acaAssists assist = (from a in db.acaAssists where a.AssistId == _assistId select a).FirstOrDefault(); this.txtDateOfEncounter.Text = String.Format("{0:M/dd/yyyy}", assist.AssistDate); this.txtNotes.Text = assist.Notes; this.ddlPSR.SelectedValue = assist.RepresentativeId.ToString(); this.ddlAssistType.SelectedValue = assist.AssistTypeId.ToString(); this.ddlRegion.SelectedValue = assist.RegionId.ToString(); this.ddlSite.SelectedValue = assist.SiteId.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { int _appId = 0; if (!String.IsNullOrEmpty(Request.QueryString["appId"])) { string appId = Request.QueryString["appId"]; int.TryParse(appId, out _appId); } if (!IsPostBack) { DataSet dsDropdownData = Data.GetDropdownData_Applicants(); AddDropDownItems(dsDropdownData.Tables[1], ddRegion, "Region", "RegionId"); if (_appId > 0) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); acaApplicants app = (from a in db.acaApplicants where a.ApplicantId == _appId select a).FirstOrDefault(); this.txtFirstName.Text = app.FirstName; this.txtLastName.Text = app.LastName; // this.txtEmail.Text = app.Email; // this.txtAddress.Text = app.Address; this.txtDOB.Text = String.Format("{0:M/dd/yyyy}", app.DateOfBirth); //this.txtCity.Text = app.City; this.txtPhone.Text = app.Phone; this.ddRegion.SelectedValue = app.RegionId.ToString(); if (app.isActive) this.chkActive.Checked = true; else this.chkActive.Checked = false; //this.txtZip.Text = app.Zip; this.txtNotes.Text = app.Notes; } } }
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(); } }