protected void Continue(object sender, EventArgs e)
{
//Get the connection string for the specific database if it isn't already in the view state
if (ConnString == String.Empty)
{
using (GetEmployerConnString gecs = new GetEmployerConnString("AnalogDevices")) //2 = Analog Devices
if (!gecs.HasErrors)
{
ConnString = gecs.ConnectionString;
EmployerID = gecs.EmployerID.ToString();
}
}
if (ConnString != String.Empty)
{
ThisSession.CnxString = ConnString;
}
if (EmployerID != String.Empty)
{
ThisSession.EmployerID = EmployerID;
}
//Check if the employee exists and if they do, store session info and move on
using (GetEmployeeEnrollment gee = new GetEmployeeEnrollment())
{
//gee.Firstname = txtFirstName.Text;
gee.LastName = Encoder.HtmlEncode(txtLastName.Text);
gee.MemberID = Encoder.HtmlEncode(txtMemID.Text);
gee.DOB = Encoder.HtmlEncode(txtDOB.Text);
gee.GetData(ConnString);
if (!gee.HasErrors)
{
if (gee.EmployeeTable.TableName != "Empty" && gee.EmployeeTable.Rows.Count > 0)
{
lblNotFound.Visible = false;
lblError.Visible = false;
ThisSession.CCHID = gee.CCHID;
ThisSession.EmployeeID = gee.EmployeeID;
ThisSession.SubscriberMedicalID = gee.SubscriberMedicalID;
ThisSession.SubscriberRXID = gee.SubscriberRXID;
ThisSession.LastName = gee.LastName;
//ThisSession.FirstName = gee.Firstname;
ThisSession.PatientAddress1 = gee.Address1;
ThisSession.PatientAddress2 = gee.Address2;
ThisSession.PatientCity = gee.City;
ThisSession.PatientState = gee.State;
ThisSession.PatientZipCode = gee.ZipCode;
ThisSession.PatientLatitude = gee.Latitude;
ThisSession.PatientLongitude = gee.Longitude;
ThisSession.PatientDateOfBirth = gee.DOB;
ThisSession.PatientPhone = gee.Phone;
ThisSession.HealthPlanType = gee.HealthPlanType;
ThisSession.MedicalPlanType = gee.MedicalPlanType;
ThisSession.RxPlanType = gee.RxPlanType;
ThisSession.PatientGender = gee.Gender;
ThisSession.Parent = gee.Parent;
ThisSession.Adult = gee.Adult;
ThisSession.PatientEmail = gee.Email;
if (gee.Insurer != String.Empty)
{
ThisSession.Insurer = gee.Insurer;
}
if (gee.RXProvider != String.Empty)
{
ThisSession.RXProvider = gee.RXProvider;
}
if (gee.DependentTable.TableName != "EmptyTable")
{
Dependents deps = new Dependents();
Dependent dep = null;
gee.ForEachDependent(delegate(DataRow dr)
{
dep = new Dependent();
dep.CCHID = int.Parse(dr["CCHID"].ToString());
dep.FirstName = dr["FirstName"].ToString();
dep.LastName = dr["LastName"].ToString();
dep.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString());
dep.Age = int.Parse(dr["Age"].ToString());
dep.IsAdult = int.Parse(dr["Adult"].ToString()) == 1 ? true : false;
dep.ShowAccessQuestions = int.Parse(dr["ShowAccessQuestions"].ToString()) == 1 ? true : false;
dep.RelationshipText = dr["RelationshipText"].ToString();
dep.DepToUserGranted = int.Parse(dr["DepToUserGranted"].ToString()) == 1 ? true : false;
dep.UserToDepGranted = int.Parse(dr["UserToDepGranted"].ToString()) == 1 ? true : false;
dep.Email = dr["Email"].ToString();
deps.Add(dep);
});
ThisSession.Dependents = deps;
}
if (gee.YouCouldHaveSavedTable.TableName != "EmptyTable")
{
ThisSession.YouCouldHaveSaved = (int)gee.YouCouldHaveSaved;
}
Response.Redirect("Review.aspx");
}
else
{
lblNotFound.Visible = true;
}
}
else
{
lblError.Visible = true;
}
}
}
protected void Continue(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
//Get the connection string for the specific database if it isn't already in the view state
if (ConnString == String.Empty)
{
using (GetEmployerConnString gecs = new GetEmployerConnString("Starbucks"))
if (!gecs.HasErrors)
{
ConnString = gecs.ConnectionString;
EmployerID = gecs.EmployerID.ToString();
}
}
if (ConnString != String.Empty)
{
ThisSession.CnxString = ConnString;
}
if (EmployerID != String.Empty)
{
ThisSession.EmployerID = EmployerID;
}
//Check if the employee exists and if they do, store session info and move on
using (GetEmployeeEnrollment gee = new GetEmployeeEnrollment())
{
//gee.Firstname = txtFirstName.Text;
gee.LastName = Encoder.HtmlEncode(txtLastName.Text);
gee.SSN = "zzzz";
if (txtPremera1.Text != "XXXXXXX" && txtPremera2.Text != "XX") //From this point validation has already passed so this indicates they are using the member id
{
gee.MemberID = Encoder.HtmlEncode(txtPremera1.Text) + Encoder.HtmlEncode(txtPremera2.Text);
}
else
{
gee.SSN = Encoder.HtmlEncode(txtSSN.Text);
}
gee.DOB = String.Format("{2}-{1}-{0}", txtMonth.Text, txtDay.Text, txtYear.Text);
gee.GetData(ConnString);
if (!gee.HasErrors)
{
if (gee.EmployeeTable.TableName != "Empty" && gee.EmployeeTable.Rows.Count > 0)
{
lblNotFound.Visible = false;
lblError.Visible = false;
ThisSession.CCHID = gee.CCHID;
ThisSession.EmployeeID = gee.EmployeeID;
ThisSession.SubscriberMedicalID = gee.SubscriberMedicalID;
ThisSession.SubscriberRXID = gee.SubscriberRXID;
ThisSession.LastName = gee.LastName;
ThisSession.FirstName = gee.FirstName;
ThisSession.PatientAddress1 = gee.Address1;
ThisSession.PatientAddress2 = gee.Address2;
ThisSession.PatientCity = gee.City;
ThisSession.PatientState = gee.State;
ThisSession.PatientZipCode = gee.ZipCode;
ThisSession.PatientLatitude = gee.Latitude;
ThisSession.PatientLongitude = gee.Longitude;
ThisSession.PatientDateOfBirth = gee.DOB;
ThisSession.PatientPhone = gee.Phone;
ThisSession.HealthPlanType = gee.HealthPlanType;
ThisSession.MedicalPlanType = gee.MedicalPlanType;
ThisSession.RxPlanType = gee.RxPlanType;
ThisSession.PatientGender = gee.Gender;
ThisSession.Parent = gee.Parent;
ThisSession.Adult = gee.Adult;
ThisSession.PatientEmail = gee.Email;
if (gee.Insurer != String.Empty)
{
ThisSession.Insurer = gee.Insurer;
}
if (gee.RXProvider != String.Empty)
{
ThisSession.RXProvider = gee.RXProvider;
}
if (gee.DependentTable.TableName != "EmptyTable")
{
Dependents deps = new Dependents();
Dependent dep = null;
gee.ForEachDependent(delegate(DataRow dr)
{
dep = new Dependent();
dep.CCHID = int.Parse(dr["CCHID"].ToString());
dep.FirstName = dr["FirstName"].ToString();
dep.LastName = dr["LastName"].ToString();
dep.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString());
dep.Age = int.Parse(dr["Age"].ToString());
dep.IsAdult = int.Parse(dr["Adult"].ToString()) == 1 ? true : false;
dep.ShowAccessQuestions = int.Parse(dr["ShowAccessQuestions"].ToString()) == 1 ? true : false;
dep.RelationshipText = dr["RelationshipText"].ToString();
dep.DepToUserGranted = int.Parse(dr["DepToUserGranted"].ToString()) == 1 ? true : false;
dep.UserToDepGranted = int.Parse(dr["UserToDepGranted"].ToString()) == 1 ? true : false;
dep.Email = dr["Email"].ToString();
deps.Add(dep);
});
ThisSession.Dependents = deps;
}
if (gee.YouCouldHaveSavedTable.TableName != "EmptyTable")
{
ThisSession.YouCouldHaveSaved = (int)gee.YouCouldHaveSaved;
}
Response.Redirect("Review.aspx");
}
else
{
pnlReg.Visible = false; pnlCapture.Visible = true;
} //Membership not found
}
else
{
lblError.Visible = true;
} //General error validating
}
}
protected void Continue(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
////Dictionary<Int32, Tuple<String, String>> connections = null;
//Get the connection string for the specific database if it isn't already in the view state
if (ConnString == String.Empty)
{
using (GetEmployerConnString gecs = new GetEmployerConnString(hfEmployerIDFromURL.Value))
if (!gecs.HasErrors)
{
////if (gecs.EmployerRows.Length > 1)
////{
//// connections = new Dictionary<int, Tuple<string, string>>();
//// gecs.ForEach(delegate(object[] row)
//// {
//// connections.Add(Convert.ToInt32(row[0]),
//// new Tuple<string, string>(row[1].ToString(), row[2].ToString()));
//// });
////}
ConnString = gecs.ConnectionString;
EmployerID = gecs.EmployerID.ToString();
}
}
if (ConnString != String.Empty)
{
ThisSession.CnxString = ConnString;
}
if (EmployerID != String.Empty)
{
ThisSession.EmployerID = EmployerID;
}
//Check if the employee exists and if they do, store session info and move on
using (GetEmployeeEnrollment gee = new GetEmployeeEnrollment())
{
//gee.Firstname = txtFirstName.Text;
gee.LastName = Encoder.HtmlEncode(txtLastName.Text);
if (!String.IsNullOrWhiteSpace(cmidfWelcome.MemberIDText.Replace("X", "")))
{
gee.MemberID = cmidfWelcome.MemberIDText;
}
else
{
gee.SSN = Encoder.HtmlEncode(txtSSN.Text);
}
//if(txtPremera1.Text != "XXXXXXX" && txtPremera2.Text != "XX") //From this point validation has already passed so this indicates they are using the member id
//gee.MemberID = txtPremera1.Text + txtPremera2.Text;
//else
//gee.SSN = txtSSN.Text;
gee.DOB = String.Format("{0}-{2}-{1}", Encoder.HtmlEncode(txtYear.Text), Encoder.HtmlEncode(txtDay.Text), Encoder.HtmlEncode(txtMonth.Text));// txtMonth.Text, txtDay.Text, txtYear.Text));
gee.GetData(ConnString);
if (gee.PutInSession())
{
lblNotFound.Visible = lblError.Visible = false;
//////JM 11/28/12 (TO BE REMOVED 9/16/13)
//////For Sanmina change the employer id and cnxstring to the BCBS version if this employee is not an AETNA insured employee
////if (hfEmployerIDFromURL.Value.Trim().ToLower().Contains("sanmina"))
////{
//// if (ThisSession.MedicalPlanType.ToLower().Contains("bcbs"))
//// {
//// ThisSession.EmployerID = connections.Single(cnn => cnn.Value.Item2.ToLower().Contains("bcbs")).Key.ToString();
//// ThisSession.CnxString = connections[Convert.ToInt32(ThisSession.EmployerID)].Item1;
//// }
////}
if (Debugger.IsAttached && Request.QueryString["e"] != null)
{
Response.Redirect("Review.aspx?e=" + Encoder.HtmlEncode(Request.QueryString["e"]));
}
else
{
Response.Redirect("Review.aspx");
}
}
else
{ // Membership not found
pnlReg.Visible = false;
pnlCapture.Visible = true;
}
}
}
protected void Continue(object sender, EventArgs e)
{
if (!Page.IsValid) return;
//Get the connection string for the specific database if it isn't already in the view state
if (ConnString == String.Empty)
using (GetEmployerConnString gecs = new GetEmployerConnString("Starbucks"))
if (!gecs.HasErrors)
{
ConnString = gecs.ConnectionString;
EmployerID = gecs.EmployerID.ToString();
}
if (ConnString != String.Empty)
ThisSession.CnxString = ConnString;
if (EmployerID != String.Empty)
ThisSession.EmployerID = EmployerID;
//Check if the employee exists and if they do, store session info and move on
using (GetEmployeeEnrollment gee = new GetEmployeeEnrollment())
{
//gee.Firstname = txtFirstName.Text;
gee.LastName = Encoder.HtmlEncode(txtLastName.Text);
gee.SSN = "zzzz";
if (txtPremera1.Text != "XXXXXXX" && txtPremera2.Text != "XX") //From this point validation has already passed so this indicates they are using the member id
gee.MemberID = Encoder.HtmlEncode(txtPremera1.Text) + Encoder.HtmlEncode(txtPremera2.Text);
else
gee.SSN = Encoder.HtmlEncode(txtSSN.Text);
gee.DOB = String.Format("{2}-{0}-{1}", txtMonth.Text, txtDay.Text, txtYear.Text);
gee.GetData(ConnString);
if (!gee.HasErrors)
{
if (gee.EmployeeTable.TableName != "Empty" && gee.EmployeeTable.Rows.Count > 0)
{
lblNotFound.Visible = false;
lblError.Visible = false;
ThisSession.CCHID = gee.CCHID;
ThisSession.EmployeeID = gee.EmployeeID;
ThisSession.SubscriberMedicalID = gee.SubscriberMedicalID;
ThisSession.SubscriberRXID = gee.SubscriberRXID;
ThisSession.LastName = gee.LastName;
ThisSession.FirstName = gee.FirstName;
ThisSession.PatientAddress1 = gee.Address1;
ThisSession.PatientAddress2 = gee.Address2;
ThisSession.PatientCity = gee.City;
ThisSession.PatientState = gee.State;
ThisSession.PatientZipCode = gee.ZipCode;
ThisSession.PatientLatitude = gee.Latitude;
ThisSession.PatientLongitude = gee.Longitude;
ThisSession.PatientDateOfBirth = gee.DOB;
ThisSession.PatientPhone = gee.Phone;
ThisSession.HealthPlanType = gee.HealthPlanType;
ThisSession.MedicalPlanType = gee.MedicalPlanType;
ThisSession.RxPlanType = gee.RxPlanType;
ThisSession.PatientGender = gee.Gender;
ThisSession.Parent = gee.Parent;
ThisSession.Adult = gee.Adult;
ThisSession.PatientEmail = gee.Email;
if (gee.Insurer != String.Empty)
ThisSession.Insurer = gee.Insurer;
if (gee.RXProvider != String.Empty)
ThisSession.RXProvider = gee.RXProvider;
if (gee.DependentTable.TableName != "EmptyTable")
{
Dependents deps = new Dependents();
Dependent dep = null;
gee.ForEachDependent(delegate(DataRow dr)
{
dep = new Dependent();
dep.CCHID = int.Parse(dr["CCHID"].ToString());
dep.FirstName = dr["FirstName"].ToString();
dep.LastName = dr["LastName"].ToString();
dep.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString());
dep.Age = int.Parse(dr["Age"].ToString());
dep.IsAdult = int.Parse(dr["Adult"].ToString()) == 1 ? true : false;
dep.ShowAccessQuestions = int.Parse(dr["ShowAccessQuestions"].ToString()) == 1 ? true : false;
dep.RelationshipText = dr["RelationshipText"].ToString();
dep.DepToUserGranted = int.Parse(dr["DepToUserGranted"].ToString()) == 1 ? true : false;
dep.UserToDepGranted = int.Parse(dr["UserToDepGranted"].ToString()) == 1 ? true : false;
dep.Email = dr["Email"].ToString();
deps.Add(dep);
});
ThisSession.Dependents = deps;
}
if (gee.YouCouldHaveSavedTable.TableName != "EmptyTable")
ThisSession.YouCouldHaveSaved = (int)gee.YouCouldHaveSaved;
Response.Redirect("Review.aspx");
}
else
{ pnlReg.Visible = false; pnlCapture.Visible = true; } //Membership not found
}
else
{ lblError.Visible = true; }//General error validating
}
}
protected void Continue(object sender, EventArgs e)
{
if (!Page.IsValid) return;
////Dictionary<Int32, Tuple<String, String>> connections = null;
//Get the connection string for the specific database if it isn't already in the view state
if (ConnString == String.Empty)
using (GetEmployerConnString gecs = new GetEmployerConnString(hfEmployerIDFromURL.Value))
if (!gecs.HasErrors)
{
////if (gecs.EmployerRows.Length > 1)
////{
//// connections = new Dictionary<int, Tuple<string, string>>();
//// gecs.ForEach(delegate(object[] row)
//// {
//// connections.Add(Convert.ToInt32(row[0]),
//// new Tuple<string, string>(row[1].ToString(), row[2].ToString()));
//// });
////}
ConnString = gecs.ConnectionString;
EmployerID = gecs.EmployerID.ToString();
}
if (ConnString != String.Empty)
ThisSession.CnxString = ConnString;
if (EmployerID != String.Empty)
ThisSession.EmployerID = EmployerID;
//Check if the employee exists and if they do, store session info and move on
using (GetEmployeeEnrollment gee = new GetEmployeeEnrollment())
{
//gee.Firstname = txtFirstName.Text;
gee.LastName = Encoder.HtmlEncode(txtLastName.Text);
if (!String.IsNullOrWhiteSpace(cmidfWelcome.MemberIDText.Replace("X","")))
gee.MemberID = cmidfWelcome.MemberIDText;
else
gee.SSN = Encoder.HtmlEncode(txtSSN.Text);
//if(txtPremera1.Text != "XXXXXXX" && txtPremera2.Text != "XX") //From this point validation has already passed so this indicates they are using the member id
//gee.MemberID = txtPremera1.Text + txtPremera2.Text;
//else
//gee.SSN = txtSSN.Text;
gee.DOB = String.Format("{0}-{2}-{1}", Encoder.HtmlEncode(txtYear.Text), Encoder.HtmlEncode(txtDay.Text), Encoder.HtmlEncode(txtMonth.Text));// txtMonth.Text, txtDay.Text, txtYear.Text));
gee.GetData(ConnString);
if (gee.PutInSession())
{
lblNotFound.Visible = lblError.Visible = false;
//////JM 11/28/12 (TO BE REMOVED 9/16/13)
//////For Sanmina change the employer id and cnxstring to the BCBS version if this employee is not an AETNA insured employee
////if (hfEmployerIDFromURL.Value.Trim().ToLower().Contains("sanmina"))
////{
//// if (ThisSession.MedicalPlanType.ToLower().Contains("bcbs"))
//// {
//// ThisSession.EmployerID = connections.Single(cnn => cnn.Value.Item2.ToLower().Contains("bcbs")).Key.ToString();
//// ThisSession.CnxString = connections[Convert.ToInt32(ThisSession.EmployerID)].Item1;
//// }
////}
if (Debugger.IsAttached && Request.QueryString["e"] != null)
Response.Redirect("Review.aspx?e=" + Encoder.HtmlEncode( Request.QueryString["e"]) );
else
Response.Redirect("Review.aspx");
}
else
{ // Membership not found
pnlReg.Visible = false;
pnlCapture.Visible = true;
}
}
}
protected void Continue(object sender, EventArgs e)
{
//Get the connection string for the specific database if it isn't already in the view state
if (ConnString == String.Empty)
using (GetEmployerConnString gecs = new GetEmployerConnString("AnalogDevices")) //2 = Analog Devices
if (!gecs.HasErrors)
{
ConnString = gecs.ConnectionString;
EmployerID = gecs.EmployerID.ToString();
}
if (ConnString != String.Empty)
ThisSession.CnxString = ConnString;
if (EmployerID != String.Empty)
ThisSession.EmployerID = EmployerID;
//Check if the employee exists and if they do, store session info and move on
using (GetEmployeeEnrollment gee = new GetEmployeeEnrollment())
{
//gee.Firstname = txtFirstName.Text;
gee.LastName = Encoder.HtmlEncode(txtLastName.Text);
gee.MemberID = Encoder.HtmlEncode(txtMemID.Text);
gee.DOB = Encoder.HtmlEncode(txtDOB.Text);
gee.GetData(ConnString);
if (!gee.HasErrors)
{
if (gee.EmployeeTable.TableName != "Empty" && gee.EmployeeTable.Rows.Count > 0)
{
lblNotFound.Visible = false;
lblError.Visible = false;
ThisSession.CCHID = gee.CCHID;
ThisSession.EmployeeID = gee.EmployeeID;
ThisSession.SubscriberMedicalID = gee.SubscriberMedicalID;
ThisSession.SubscriberRXID = gee.SubscriberRXID;
ThisSession.LastName = gee.LastName;
//ThisSession.FirstName = gee.Firstname;
ThisSession.PatientAddress1 = gee.Address1;
ThisSession.PatientAddress2 = gee.Address2;
ThisSession.PatientCity = gee.City;
ThisSession.PatientState = gee.State;
ThisSession.PatientZipCode = gee.ZipCode;
ThisSession.PatientLatitude = gee.Latitude;
ThisSession.PatientLongitude = gee.Longitude;
ThisSession.PatientDateOfBirth = gee.DOB;
ThisSession.PatientPhone = gee.Phone;
ThisSession.HealthPlanType = gee.HealthPlanType;
ThisSession.MedicalPlanType = gee.MedicalPlanType;
ThisSession.RxPlanType = gee.RxPlanType;
ThisSession.PatientGender = gee.Gender;
ThisSession.Parent = gee.Parent;
ThisSession.Adult = gee.Adult;
ThisSession.PatientEmail = gee.Email;
if (gee.Insurer != String.Empty)
ThisSession.Insurer = gee.Insurer;
if (gee.RXProvider != String.Empty)
ThisSession.RXProvider = gee.RXProvider;
if (gee.DependentTable.TableName != "EmptyTable")
{
Dependents deps = new Dependents();
Dependent dep = null;
gee.ForEachDependent(delegate(DataRow dr)
{
dep = new Dependent();
dep.CCHID = int.Parse(dr["CCHID"].ToString());
dep.FirstName = dr["FirstName"].ToString();
dep.LastName = dr["LastName"].ToString();
dep.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString());
dep.Age = int.Parse(dr["Age"].ToString());
dep.IsAdult = int.Parse(dr["Adult"].ToString()) == 1 ? true : false;
dep.ShowAccessQuestions = int.Parse(dr["ShowAccessQuestions"].ToString()) == 1 ? true : false;
dep.RelationshipText = dr["RelationshipText"].ToString();
dep.DepToUserGranted = int.Parse(dr["DepToUserGranted"].ToString()) == 1 ? true : false;
dep.UserToDepGranted = int.Parse(dr["UserToDepGranted"].ToString()) == 1 ? true : false;
dep.Email = dr["Email"].ToString();
deps.Add(dep);
});
ThisSession.Dependents = deps;
}
if (gee.YouCouldHaveSavedTable.TableName != "EmptyTable")
ThisSession.YouCouldHaveSaved = (int)gee.YouCouldHaveSaved;
Response.Redirect("Review.aspx");
}
else
{ lblNotFound.Visible = true; }
}
else
{ lblError.Visible = true; }
}
}