protected void btnSave_Click(object sender, EventArgs e)
{
reasonMessage();
if (txtMemo.Text == "")
{
ShowError("You must fill the reason for partial payment of the approved amount.");
return;
}
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
SaveCSA(conn);
if (DoSave(conn))
{
lblScript.Text = "<script>alert('Your decision has been saved.');document.location.replace('PayorPendingApprovals.aspx?SkipCheck=YES')</script>";
txn.Commit();
}
else
{
txn.Rollback();
}
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
}
protected void btnClassSave_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
Data.Make_All_Classes_Eligible(ViewState["Selected_Account_Number"].ToString(), ViewState["Processing_Year"].ToString(),
rblSaveTaxTo.SelectedValue, ViewState["User_Name"].ToString(), conn);
foreach (ListItem li in cbEligible.Items)
{
if (!li.Selected)
{
Data.update_one_class(ViewState["Selected_Account_Number"].ToString(), ViewState["Processing_Year"].ToString(),
rblSaveTaxTo.SelectedValue, li.Value, "0", ViewState["User_Name"].ToString(), conn);
}
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
ShowData();
Bas_Utility.Misc.AlertSaved(Page);
}
private bool DoSave()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
bool blnOk = true;
try
{
for (int i = 0; i < chklstEmailTo.Items.Count; i++)
{
if (chklstEmailTo.Items[i].Selected)
{
SaveOne(conn, chklstEmailTo.Items[i].Value);
}
}
txn.Commit();
}
catch
{
txn.Rollback();
blnOk = false;
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
return(blnOk);
}
protected void DoSave()
{
//reInstruction.Content = "";
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
foreach (ListItem li in cbEnrommentType.Items)
{
if (li.Selected)
{
Data.Save_cvr_msg(session_id, ViewState["record_id"].ToString(), reMessage.Content, li.Value, rblSaveTo.SelectedValue);
}
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
rblEnrollmentType.SelectedIndex = 0;
rblEnrollType.SelectedIndex = 0;
gvGroups_SelectedIndexChanged(gvGroups, null);
rblEnrollmentType_SelectedIndexChanged(null, null);
}
private bool DoSave()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
bool blnOk = true;
try
{
SavePayorNumber(conn);
if (ViewState["From_2nd_supervisor"].ToString() != "T")
{
SaveApproval(conn);
}
else
{
Save2ndApproval(conn);
}
txn.Commit();
}
catch
{
blnOk = false;
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
blnOk = blnOk && (ViewState["Saved"].ToString() != "F");
return(blnOk);
}
protected void lnkbtnNo_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
Data.SaveSPN_HSA(session_id, ViewState["Employee_Number"].ToString(), ViewState["Processing_Year"].ToString(), "INS-HSA", "001",
"0", "0", conn);
Data.SaveStatusCoverage(session_id, conn);
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
Data.SaveStatusCoverage(session_id);
string strClose = "<script>Javascript:closeWindow(20);</script>";
Page.ClientScript.RegisterStartupScript(Page.GetType(), "strClose", strClose);
}
private void DoSave()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
for (int i = 1; i < 11; i++)
{
if (ViewState["Record_id_" + i.ToString()] != null)
{
SaveOne(conn, i);
}
}
txn.Commit();
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
}
protected void btnRemove_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
DataTable tbl = Data.Super_Users_List();
try
{
foreach (DataRow dr in tbl.Rows)
{
string strIndex = dr["user_id"].ToString();
if (Bas_Utility.Utilities.GetCheckBox(gvEmployee, "cb_" + strIndex).Checked)
{
Data.Remove_Super_User(strIndex, conn);
}
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
DrawGrid();
}
protected void btnSendEmails_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
if (is_inital())
{
RadGrid1.DataSource = Data.WillReciveInital(ddlRenewalDate.SelectedValue);
}
else
{
RadGrid1.DataSource = Data.WillReciveReminder(ddlRenewalDate.SelectedValue);
}
RadGrid1.DataBind();
tx.Rollback();
}
catch
{
tx.Rollback();
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
}
private bool DoSave()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
conn.Open();
bool blnOk = true;
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
SaveApproval(conn);
SaveCSA(conn);
txn.Commit();
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
return(blnOk);
}
protected void btnFullPaymentApproval_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
conn.Open();
bool blnOk = true;
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
SaveApproval(conn);
SaveCSA(conn);
txn.Commit();
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
lblScript.Text = "<script>alert('Your decision has been saved.');document.location.replace('PayorPendingApprovals.aspx?SkipCheck=YES')</script>";
}
private bool DoSave()
{
bool blnSaved = true;
DataTable tbl = (DataTable)dgQA.DataSource;
RadioButtonList opnlst;
string strID;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
foreach (DataRow dr in tbl.Rows)
{
strID = "opn_" + dr["record_id"].ToString();
opnlst = Getopnlst(this, strID);
SaveOne(conn, dr["record_id"].ToString(), opnlst.SelectedValue);
opnlst = null;
}
SaveFinalizeEvaluation(conn);
txn.Commit();
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
return(blnSaved);
}
protected void aspxbtn_Click(object sender, EventArgs e)
{
string strGradDate = ddlYear.SelectedValue + ddlMonth.SelectedValue;
if ((ddlMonth.SelectedIndex == 0) || (ddlYear.SelectedIndex == 0))
{
strGradDate = "";
}
string strSate = ddlState.SelectedValue;
if (ddlState.SelectedValue == "0")
{
strSate = "";
}
string strDepID = "";
if (Request.Params["id"] == "-1")
{
strDepID = "0";
}
else
{
strDepID = Request.Params["dep_id"];
}
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction idx = conn.BeginTransaction();
//string strID;
try
{
Data.SaveDependentsLimited(Request.Params["id"], ViewState["Employee_Number"].ToString(), strDepID, ViewState["Processing_Year"].ToString(),
txtSSN.Text, txtDOB.Text, txtSchool.Text, strGradDate, ViewState["User_Name"].ToString(), conn);
Data.SaveDependentAddressByEE(ViewState["Employee_Number"].ToString(), Request.Params["dep_id"], txtStreet.Text, txtApt.Text, txtCity.Text, strSate, txtZip.Text, txtHomePhone.Text, ViewState["User_Name"].ToString(), conn);
idx.Commit();
}
catch
{
idx.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
string strCallCloseWindow = "<script>docloseWindow(1)</script>";
Page.ClientScript.RegisterStartupScript(Page.GetType(), "strCallCloseWindow", strCallCloseWindow);
return;
}
protected void aspxbtn_Click(object sender, EventArgs e)
{
txtEffectiveDate.Text = stripDate(txtEffectiveDate.Text);
Validate();
if (!IsValid)
{
return;
}
Globalconn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction idx = Globalconn.BeginTransaction();
string strRecid = ViewState["RecID"].ToString();
try
{
for (int i = 1; i <= 6; i++)
{
if (ViewState["Record_id" + i.ToString()] != null)
{
CheckBox cb = (CheckBox)Page.FindControl("cbselect" + i.ToString());
if (cb.Checked && cb.Enabled)
{
DropDownList ddl = (DropDownList)Page.FindControl("ddlAvailableStatus" + i.ToString());
Data.SaveCoverage(ViewState["Record_id" + i.ToString()].ToString(), ViewState["Employee_Number"].ToString(), strRecid, ddl.SelectedValue, txtEffectiveDate.Text, ViewState["User_Name"].ToString(), Globalconn);
}
}
}
idx.Commit();
}
catch
{
idx.Rollback();
throw;
}
finally
{
Globalconn.Close();
Globalconn.Dispose();
}
string strCallCloseWindow = "<script>docloseWindow(1)</script>";
ViewState["Show_Declaration"] = Data.Show_Declara_Form_Send_Processess(ViewState["Employee_Number"].ToString());
if (ViewState["Show_Declaration"].ToString() == "1")
{
strCallCloseWindow = "<script>docloseWindow(2)</script>";
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), "strCallCloseWindow", strCallCloseWindow);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
string strInOPenEE = "0";
if (cbOe.Checked)
{
strInOPenEE = "1";
}
Data.Save_In_OE(Request.Params["accnt"], Request.Params["py"], strInOPenEE, Request.Params["catcode"],
Request.Params["catplan"], Request.Params["class"], Request.Params["batch"], conn);
string newCatePlN = Data.Replace_coverage(Request.Params["accnt"], Request.Params["ver"], Request.Params["class"], Request.Params["catcode"],
Request.Params["catplan"], Request.Params["py"], Request.Params["batch"], Request.Params["ratetype"], conn);
if (!string.IsNullOrEmpty(hidcomVales.Value))
{
// remove first seperatoe
hidcomVales.Value = hidcomVales.Value.Remove(0, 1);
ArrayList ar = new ArrayList(hidcomVales.Value.Split(new char[] { '!' }));
string long_description = Request.Params["cvrg"].Substring(0, Request.Params["cvrg"].IndexOf(" - "));
foreach (string str in ar)
{
string[] fs = str.Split('=');
string[] age = fs[0].Split('-');
age[0] = age[0].Replace(" + ", "");
Data.SaveRate_ver1(Request.Params["accnt"], Request.Params["ver"], Request.Params["class"], Request.Params["catcode"],
newCatePlN, "010", Request.Params["py"], Request.Params["batch"], fs[1], age[0].Trim(), "", "", long_description, fs[0], "1", conn);
}
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
btnCancel_Click(null, null);
}
public void InsertCLOB(string SQLStatement, string str)
{
if (SQLStatement.Length > 0)
{
if (connOracle.State.ToString().Equals("Open"))
{
byte[] newvalue = System.Text.Encoding.Unicode.GetBytes(str);
sqlCommandOracle =
new Oracle.DataAccess.Client.OracleCommand(SQLStatement, connOracle);
rstOracle = sqlCommandOracle.ExecuteReader();
rstOracle.Read();
txn = connOracle.BeginTransaction();
clob = rstOracle.GetOracleClob(0);
clob.Write(newvalue, 0, newvalue.Length);
txn.Commit();
}
}
}
private void DoSave()
{
DataTable tbl = (DataTable)GetGridView("gvPlans").DataSource;
if (tbl == null)
{
tbl = GetData();
}
string strIndex = null;
CheckBox cb = null;
int DoSkip = 0;
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
RadioButtonList rblOperation_ = Bas_Utility.Utilities.GetRadioButtonList(Page, "rblOperation");
try
{
foreach (DataRow dr in tbl.Rows)
{
strIndex = dr["RECORD_ID"].ToString();
cb = Bas_Utility.Utilities.GetCheckBox(Page, "cbl_" + strIndex);
if (cb.Checked)
{
DoSkip = 0;
}
else
{
DoSkip = 1;
}
Data.SaveCoverageSkip(session_id, strIndex, GetRadioButtonList("rblSaveType").SelectedValue, DoSkip.ToString(), rblOperation_.SelectedValue, conn);
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataTable tbl = CreateTable();
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
string last_fs = string.Empty;
foreach (DataRow dr in tbl.Rows)
{
if (!string.IsNullOrEmpty(dr["Family_status"].ToString()))
{
if (!dr["Family_status"].ToString().Equals(last_fs))
{
last_fs = dr["Family_status"].ToString();
}
}
if (!string.IsNullOrEmpty(dr["Age_Band"].ToString()))
{
Data.addOneRate(ViewState["Account_number"].ToString(),
ViewState["Version"].ToString(),
ViewState["class_code"].ToString(),
ViewState["Processing_Year"].ToString(),
ViewState["category_code"].ToString(),
ViewState["category_plan"].ToString(),
last_fs.Substring(0, 3),
dr["Age_Band"].ToString().Substring(0, 2).Replace("-", "").Trim(),
txtEffectiveDate.SelectedDate.Value.ToShortDateString(),
ViewState["User_Name"].ToString());
}
}
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
Response.Redirect("Default.aspx", true);
}
/// <summary>
/// 将cmdText在一个事务中执行
/// </summary>
/// <param name="cmdText"></param>
/// <returns></returns>
public string ExecuteNonQueryWithTrans(string cmdText)
{
string retVal = "0";
using (Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(connStr))
{
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(cmdText, conn);
cmd.CommandType = CommandType.Text;
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (Oracle.DataAccess.Client.OracleTransaction trans = conn.BeginTransaction())
{
try
{
cmd.Transaction = trans;
retVal = cmd.ExecuteNonQuery().ToString();
trans.Commit();
}
catch (Exception ex)
{
LogWriter.Error(ex, cmdText);
trans.Rollback();
throw;
}
}
}
catch (Exception exp)
{
LogWriter.Error(exp, cmdText);
//retVal = exp.Message;
throw exp;
}
finally
{
conn.Close();
}
}
return(retVal);
}
private void DoSave()
{
ArrayList al = (ArrayList)ViewState["save"];
string unique_id_ = string.Empty;
string rate_amount = string.Empty;
string employer_split = string.Empty;
string rate_override1 = string.Empty;
string user_name_ = SQLStatic.Sessions.GetUserName(session_id);
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
foreach (string str in al)
{
string[] codeoverride = str.Split('!');
unique_id_ = codeoverride[0];
rate_amount = codeoverride[1].Replace("$", "").Replace(",", "");
employer_split = codeoverride[2].Replace("$", "").Replace(",", "");
rate_override1 = codeoverride[3].Replace("$", "").Replace(",", "");
if (!cbSelectOnFS.Checked)
{
Data.SaveOneErRate(unique_id_, rate_amount, employer_split, rate_override1, user_name_, conn);
}
else
{
Data.SAVEONEERRATE_OneFS(unique_id_, rate_amount, employer_split, rate_override1, user_name_, conn);
}
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
DrawGrid();
Bas_Utility.Misc.AlertSaved(Page);
}
protected void brnSavePrePostTax_Click(object sender, EventArgs e)
{
string strOE = string.Empty;
foreach (ListItem li in cblFSALink.Items)
{
if (li.Selected)
{
strOE += li.Value;
}
}
if (string.IsNullOrEmpty(strOE))
{
Bas_Utility.Misc.Alert(Page, "Must select at least one OE type");
return;
}
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
foreach (ListItem li in cblFSALink.Items)
{
if (li.Selected)
{
Data.Save_er_property(ViewState["Selected_Account_Number"].ToString(), li.Value, rblSelectedFSA.SelectedValue,
ViewState["User_Name"].ToString(), rblFSALink.SelectedValue, conn);
}
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
Bas_Utility.Misc.AlertSaved(Page);
}
protected void DoSaveCvrgs()
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
SaveCoverage(conn);
SaveCoverageKeep(conn);
if (rblTermdependent.SelectedValue.Equals("1"))
{
//if (ViewState["remCoverage"].ToString().Equals("0"))
if (!string.IsNullOrEmpty(ViewState["TermDep"].ToString()))
{
if (ViewState["TermDep"].ToString().Equals("yes"))
{
DoSave(conn);
}
}
}
tx.Commit();
}
catch
{
tx.Rollback();
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
{
if (!string.IsNullOrEmpty(Request.Params["sessom"]))
{
lblScript.Text = "<script>closeWindowcloseWindowOE(1)</script>";
}
else
{
lblScript.Text = "<script>closeWindow</script>";
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
foreach (ListItem li in cblEnrollmentType.Items)
{
if (li.Selected)
{
foreach (ListItem lia in cblPlans.Items)
{
if (lia.Selected)
{
Data.SaveAlert(ViewState["Selected_Account_Number"].ToString(), lia.Text, txtQuestion.Text, txtNote.Content,
lia.Value.Substring(0, 7), lia.Value.Substring(7), li.Value, cblAccountss.SelectedValue);
}
}
}
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
rblMode.SelectedIndex = 0;
dvEdit.Visible = rblMode.SelectedValue.Equals("1");
dvView.Visible = !dvEdit.Visible;
GetText();
}
private void DoSave()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
SaveTypesAndNeeds(conn);
ClearTypesofDevelopment(conn);
SaveTypesofDevelopment(conn);
txn.Commit();
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
DataTable tbl = Data.Get_fdic_admin_assignment_data(ddlAdmin.SelectedValue, conn);
try
{
Process_Modify(tbl, conn);
process_remove(tbl, conn);
tx.Commit();
}
catch
{
tx.Rollback();
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
ViewState["skip"] = false;
DrawGrid();
Bas_Utility.Misc.AlertSaved(Page);
}
private bool DoSave()
{
if (ddlExpenseType.SelectedValue != "1000")
{
txtExpenseName.Text = ddlExpenseType.SelectedItem.Text;
}
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
string strProcedureName = "basdba.PKG_Training.AddUpdateEmploeeExpense";
if (Request.Params["Admin"] == "YES")
{
strProcedureName = "basdba.PKG_Training.AddUpdateEmploeeExpense_Admin";
}
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
bool blnok = false;
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", "number", "in", Request.Params["expid"]);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "expense_type_ID_", "number", "in", ddlExpenseType.SelectedValue);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "expense_type_", "varchar2", "in", txtExpenseName.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "amount_", "number", "in", txtAmount.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "pay_to_", "number", "in", optlstVendor.SelectedIndex);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "note_", "varchar2", "in", txtDescription.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_name_", "varchar2", "in", txtVedorName.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_contact_name_", "varchar2", "in", txtVendorContact.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_address_1_", "varchar2", "in", txtAddressLine1.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_address2_", "varchar2", "in", txtAddressLine2.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_city_", "varchar2", "in", txtCity.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_state_", "varchar2", "in", ddlStates.SelectedValue);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_zip_", "varchar2", "in", txtZipCode.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_phone_", "varchar2", "in", txtPhoneNumber.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_fax_", "varchar2", "in", txtFaxNumber.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "vendor_emai_", "varchar2", "in", txtemail.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "country_code_", "varchar2", "in", ddlContries.SelectedValue);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "province_", "varchar2", "in", txtProvince.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "new_record_id_", "number", "out", "");
cmd.ExecuteNonQuery();
double dblremain = remaining_amount(conn);
if (dblremain < 0)
{
txn.Rollback();
blnok = false;
lblError.Text = "You do not have enough money in your budget to pay for this expense. You " +
"should request at lease " + (-1 * dblremain).ToString("$###,###,##0.00") + " extra from the Division/Office Director to pay for this expense";
}
else
{
blnok = true;
txn.Commit();
}
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
}
return(blnok);
}
public override int Execute(DbCommand[] cmdArray)
{
var connection = new Oracle.DataAccess.Client.OracleConnection(connectionString);
Oracle.DataAccess.Client.OracleTransaction transaction = null;
int r = 0;
try
{
connection.Open();
transaction = connection.BeginTransaction();
for (int i = 0; i < cmdArray.Length; i++)
{
if (!(cmdArray[i] is Oracle.DataAccess.Client.OracleCommand))
throw new Exception("Not a Valid SQL Command");
var command = (Oracle.DataAccess.Client.OracleCommand)cmdArray[i];
SetTimeOut(command);
command.Connection = connection;
command.Transaction = transaction;
foreach (Oracle.DataAccess.Client.OracleParameter parameter in command.Parameters)
{
if (parameter.Value == null)
{
parameter.Value = DBNull.Value;
}
}
r += command.ExecuteNonQuery();
}
transaction.Commit();
return r;
}
catch (Exception ex)
{
if (transaction != null) transaction.Rollback();
string exceptionMessage = GetOracleExceptionMessage(ex);
throw new Exception(exceptionMessage);
}
finally
{
connection.Close();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
string strInOPenEE = "0";
string newCatePlN = Request.Params["catplan"];
if (cbOe.Checked)
{
strInOPenEE = "1";
}
Data.Save_In_OE(Request.Params["accnt"], Request.Params["py"], strInOPenEE, Request.Params["catcode"],
Request.Params["catplan"], Request.Params["class"], Request.Params["batch"], conn);
if (!Request.Params["action"].Equals("0"))
{
newCatePlN = Data.Replace_coverage(Request.Params["accnt"], Request.Params["ver"], Request.Params["class"], Request.Params["catcode"],
Request.Params["catplan"], Request.Params["py"], Request.Params["batch"], Request.Params["ratetype"], conn);
}
if (string.IsNullOrEmpty(hidcomVales.Value))
{
tx.Commit();
SQLStatic.SQL.CloseConnection(conn);
if (!Request.Params["action"].Equals("0"))
{
jscriptsFunctions.Misc.Alert(Page, "You did not enter Rates");
btnCancel_Click(null, null);
return;
}
else
{
btnCancel_Click(null, null);
}
}
if (!string.IsNullOrEmpty(hidcomVales.Value))
{
string long_description = Request.Params["cvrg"];
if (!Request.Params["cvrg"].IndexOf(" - ").Equals(-1))
{
long_description = Request.Params["cvrg"].Substring(0, Request.Params["cvrg"].IndexOf(" - "));
}
hidcomVales.Value = hidcomVales.Value.Remove(0, 1);
ArrayList ar = new ArrayList(hidcomVales.Value.Split(new char[] { '!' }));
foreach (string str in ar)
{
string[] fs = str.Split('=');
Data.SaveRate_ver1(Request.Params["accnt"], Request.Params["ver"], Request.Params["class"], Request.Params["catcode"],
newCatePlN, fs[0], Request.Params["py"], Request.Params["batch"], fs[1], "0", "", "", long_description, "", "1", conn);
}
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
btnCancel_Click(null, null);
}
public JsonResult Create(int noticeId)
{
BusinessCheckNotice businessCheckNotice = RepositoryFactory.GetRepository<IBusinessCheckNoticeRepository, BusinessCheckNotice>().FindBy(noticeId);
if (businessCheckNotice == null)
{
return Json(new { success = false, message = "商检单不存在" });
}
PipeIncomeRecord incomeRecord = repository.FindBy(businessCheckNotice);
if (incomeRecord != null)
{
return Json(new { success = false, message = "已制作了该商检任务的入库单，不能重量制作" });
}
string code = Request.Form["Code"];
string unit = Request.Form["Unit"];
string strPipes = Request.Form["Pipes"];
if (string.IsNullOrEmpty(code))
{
return Json(new { success = false, message = "编码不能为空" });
}
incomeRecord = repository.FindBy(code);
if (incomeRecord != null)
{
return Json(new { success = false, message = "编号已被占用，请尝试使用其他编号" });
}
businessCheckNotice.Waggons = RepositoryFactory.GetRepository<IDeliverWaggonRepository, DeliverWaggon>().FindBy(businessCheckNotice);
#region scarface
// IList<PDCPMS.Model.Common.Pipe> pipes = RepositoryFactory.GetRepository<IPipeRepository, PDCPMS.Model.Common.Pipe>().FindBy(businessCheckNotice.Waggons);
#endregion
JavaScriptSerializer serializer = new JavaScriptSerializer();
IList<PDCPMS.DataContracts.Common.Pipe> pipeContracts = serializer.Deserialize<IList<PDCPMS.DataContracts.Common.Pipe>>(strPipes);
IPipeRepository pipeRepository = RepositoryFactory.GetRepository<IPipeRepository, PDCPMS.Model.Common.Pipe>(unitOfWork);
IPipePositionRepository posRepository = RepositoryFactory.GetRepository<IPipePositionRepository, PipePosition>();
incomeRecord = new PipeIncomeRecord(0, code, businessCheckNotice, UserSession.OnlineAccount, DateTime.Now);
incomeRecord.State = PipeIncomeRecordState.Created;
repository.Add(incomeRecord);
unitOfWork.Commit();
#region scarface
//for (int i = pipes.Count - 1; i > -1; i--)
//{
// PDCPMS.Model.Common.Pipe pipe = pipes[i];
// PDCPMS.DataContracts.Common.Pipe pc = pipeContracts.FirstOrDefault(p => p.Key == (long)pipe.Key);
// if (pc != null)
// {
// if (pc.BusinessLength != 0)
// {
// pipe.BusinessLength = pc.BusinessLength;
// }
// else
// {
// pipe.BusinessLength = new float?();
// }
// if (pc.Weight != 0)
// {
// pipe.Weight = pc.Weight;
// }
// else
// {
// pipe.Weight = new float?();
// }
// //if ((pipe.State & PipeState.NormalChecking) == PipeState.NormalChecking) // 已发起了常检则不允许更改垛位
// //{
// //}
// //else
// //{
// if (pc.PositionId != 0)
// {
// pipe.Position = posRepository.FindBy(pc.PositionId);
// }
// //}
// }
// pipe.State |= PipeState.IncomeRecordDoing;
// pipe.PipeIncomeRecord = incomeRecord;
// pipeRepository[pipe.Key] = pipe;
//};
//incomeRecord.TotalCount = businessCheckNotice.ReceiveCount;
//incomeRecord.TotalLength = pipes.Sum(p => p.BusinessLength.HasValue ? p.BusinessLength.Value : 0);
//incomeRecord.TotalWeight = pipes.Sum(p => p.Weight.HasValue ? p.Weight.Value : 0) / 1000;
#endregion
#region 2010-11-12 scarface 新增代码
//获取前台Json的值遍历生产SQL
StringBuilder sb = new StringBuilder();
DateTime now = DateTime.Now;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PDCPDMConnection"].ConnectionString);
CY.Utility.DBUtility.OracleUtility db = new CY.Utility.DBUtility.OracleUtility(conn);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction tran = conn.BeginTransaction();
try
{
sb.Append(" update Pipe set PipeIncomeRecordId = " + incomeRecord.Key + ",");
sb.Append(string.Format(" state = (state + {0} - bitand(state,{0})),", (int)PipeState.IncomeRecordDoing));
sb.Append(" PosLastChangeTime = to_date('" + now + "', 'yyyy-mm-dd HH24:mi:ss') ");
IList<DeliverWaggon> waggons = businessCheckNotice.Waggons;
if (waggons == null)
{
throw new ArgumentNullException("waggons");
}
string waggonIds = string.Empty;
for (int i = waggons.Count - 1; i > -1; i--)
{
waggonIds += OracleDataHelper.GetSqlValue(waggons[i].Key);
if (i != 0)
{
waggonIds += ",";
}
}
sb.Append(string.Format(" Where DeliverWaggonId in ({0})", waggonIds));
db.ExecuteSql(sb.ToString());
for (int i = pipeContracts.Count - 1; i > -1; i--)
{
sb = new StringBuilder();
sb.Append(" UPDATE Pipe SET ");
sb.Append(" BusinessLength = " + pipeContracts[i].BusinessLength + ",");
sb.Append(" Weight = " + pipeContracts[i].Weight + ",");
sb.Append(" PosLastChangeTime = to_date('" + now + "', 'yyyy-mm-dd HH24:mi:ss'),");
sb.Append(" PositionId = " + pipeContracts[i].PositionId);
sb.Append(" WHERE PipeId = " + pipeContracts[i].Key + "");
db.ExecuteSql(sb.ToString());
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
return Json(new { success = false, message = "管子信息保存出错！"+ex });
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
//查询并统计数据
sb = new StringBuilder();
sb.Append(" SELECT SUM(BUSINESSLENGTH) AS lh ,SUM(WEIGHT)/1000 AS wt,count(*) as c FROM Pipe WHERE PIPEINCOMERECORDID = " + incomeRecord.Key + "");
DataTable dt = pipeRepository.ExcuteDs(sb.ToString());
float tl = dt.Rows[0]["lh"].ToString() == "" ? 0 : float.Parse(dt.Rows[0]["lh"].ToString());
float tw = dt.Rows[0]["wt"].ToString() == "" ? 0 : float.Parse(dt.Rows[0]["wt"].ToString());
int tc = dt.Rows[0]["c"].ToString() == "" ? 0 : int.Parse(dt.Rows[0]["c"].ToString());
sb = new StringBuilder();
sb.Append(" UPDATE Pipeincomerecord SET totalcount=" + tc + ",TOTALLENGTH = " + tl + ",TOTALWEIGHT = " + tw + " WHERE PIPEINCOMERECORDID = " + incomeRecord.Key + "");
//只执行一次查询 就更新数据库表
pipeRepository.Execute(sb.ToString());
#endregion
TempData["HintMessage"] = new PDCPMS.Application.HintMessage { Content = "保存成功" };
return Json(new { success = true, message = "保存成功", recordId = incomeRecord.Key });
}
private void DrawGrig()
{
if (ViewState["typeof"].ToString().Equals("0"))
{
DataTable tbl = Data.OptionalBenefits(session_id);
foreach (DataRow dr in tbl.Rows)
{
if (dr["Category_PlanCode"].ToString().Equals("001LIF-CYL"))
{
decimal bl = Convert.ToDecimal(dr["multiplier_override"]);
dr["BenefitLevel"] = String.Format("{0:C}", bl);
}
}
foreach (DataRow dr in tbl.Rows)
{
if (!string.IsNullOrEmpty(dr["End Date"].ToString()))
{
DateTime dtermdate = Convert.ToDateTime(dr["End Date"].ToString());
if (DateTime.Today > dtermdate)
{
dr.Delete();
}
}
}
foreach (DataRow dr in tbl.Rows)
{
DateTime dtermdate = Convert.ToDateTime(dr["effective_date"].ToString());
dr["effective_date"] = dtermdate.ToString("MM/dd/yy");
dtermdate = Convert.ToDateTime(dr["Last Change Date"].ToString());
dr["Last Change Date"] = dtermdate.ToString("MM/dd/yy");
}
tbl.AcceptChanges();
//int col_number = ColumnNumber();
//lblCostBase.Visible = true;
//if (!col_number.Equals(-1))
//{
// gvSummary.Columns[col_number].Visible = true;
// string strheader = Data.PerpayText(ViewState["Selected_Account_Number"].ToString());
// if (!string.IsNullOrEmpty(strheader))
// gvSummary.Columns[col_number].HeaderText = strheader;
//}
//else
// lblCostBase.Visible = false;
gvSummary.DataSource = tbl;
gvSummary.DataBind();
}
DataTable tblDep = Data.GetDependentsListActive(ViewState["Employee_Number"].ToString());
gvDep.DataSource = tblDep;
gvDep.DataBind();
if (tblDep.Rows.Count.Equals(0))
{
lblNoDependent.Visible = true;
}
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
DataTable tblPend = Data.GetBenefitStatmentPendingList(session_id, conn);
if (!tblPend.Rows.Count.Equals(0))
{
gvEOI.DataSource = tblPend;
gvEOI.DataBind();
}
else
{
gvEOI.Visible = false;
lblNoPendingElection.Visible = true;
divPendingInstruction.Visible = false;
}
tx.Rollback();
SQLStatic.SQL.CloseConnection(conn);
if (Data.benefitpagevisible(ViewState["Selected_Account_Number"].ToString()))
{
Label2.Visible = true;
DataTable tblBenef = Data.GetBeneficiary(session_id);
if (!tblBenef.Rows.Count.Equals(0))
{
gvBenefit.DataSource = tblBenef;
gvBenefit.DataBind();
}
else
{
gvBenefit.Visible = false;
lblNoBeneficireies.Visible = true;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string session_id = string.Empty;
DataTable tbl = null;
if (!string.IsNullOrEmpty(Request.Params["back"]))
{
if (string.IsNullOrEmpty(hidcomVales.Value) && string.IsNullOrEmpty(hidcomVale2.Value))
{
jscriptsFunctions.Misc.Alert(Page, "Nothing to save!");
DrawGrid();
return;
}
session_id = Request.Cookies["Session_ID"].Value.ToString();
tbl = Data.Family_Status_Generic(session_id, Request.Params["accnt"], Request.Params["cvrgid"], Request.Params["class"], Request.Params["catcode"],
Request.Params["catplan"], Request.Params["py"]);
}
else
{
tbl = Data.Family_Status_List(Request.Params["accnt"], Request.Params["ver"], Request.Params["class"], Request.Params["catcode"],
Request.Params["catplan"], Request.Params["py"], Request.Params["batch"]);
}
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
//string strInOPenEE = "0";
string newCatePlN = Request.Params["catplan"];
if (string.IsNullOrEmpty(hidcomVales.Value) && string.IsNullOrEmpty(hidcomVale2.Value))
{
tx.Commit();
SQLStatic.SQL.CloseConnection(conn);
if (!Request.Params["action"].Equals("0"))
{
jscriptsFunctions.Misc.Alert(Page, "You did not enter Rates");
btnCancel_Click(null, null);
return;
}
else
{
btnCancel_Click(null, null);
return;
}
}
if (!string.IsNullOrEmpty(hidcomVales.Value))
{
// remove first seperatoe
hidcomVales.Value = hidcomVales.Value.Remove(0, 1);
ArrayList ar = new ArrayList(hidcomVales.Value.Split(new char[] { '!' }));
string long_description = Request.Params["cvrg"];
if (!Request.Params["cvrg"].IndexOf(" - ").Equals(-1))
{
long_description = Request.Params["cvrg"].Substring(0, Request.Params["cvrg"].IndexOf(" - "));
}
foreach (DataRow dr in tbl.Rows)
{
if (!dr["exist"].ToString().Equals("0"))
{
foreach (string str in ar)
{
string[] fs = str.Split('=');
string[] age = fs[0].Split('-');
age[0] = age[0].Replace(" + ", "");
if (!string.IsNullOrEmpty(Request.Params["back"]))
{
Data.SaveRate_ver2_tbl(Request.Params["accnt"], Request.Params["ver"], dr["class_code"].ToString(), Request.Params["catcode"],
newCatePlN, dr["family_status_code"].ToString(), Request.Params["py"], Request.Params["batch"], fs[1], age[0].Trim(), "",
ViewState["user_id"].ToString(), long_description, fs[0], "1", "0", conn);
}
// else
// Data.SaveRate_ver2(Request.Params["accnt"], Request.Params["ver"], Request.Params["class"], Request.Params["catcode"],
}
}
}
}
if (!string.IsNullOrEmpty(hidcomVale2.Value))
{
// remove first seperatoe
hidcomVale2.Value = hidcomVale2.Value.Remove(0, 1);
ArrayList ar = new ArrayList(hidcomVale2.Value.Split(new char[] { '!' }));
string long_description = Request.Params["cvrg"];
if (!Request.Params["cvrg"].IndexOf(" - ").Equals(-1))
{
long_description = Request.Params["cvrg"].Substring(0, Request.Params["cvrg"].IndexOf(" - "));
}
foreach (DataRow dr in tbl.Rows)
{
if (!dr["exist"].ToString().Equals("0"))
{
foreach (string str in ar)
{
string[] fs = str.Split('=');
string[] age = fs[0].Split('-');
age[0] = age[0].Replace(" + ", "");
age[0] = age[0].Replace("_a", "");
if (!string.IsNullOrEmpty(Request.Params["back"]))
{
Data.SaveRate_ver2_tbl(Request.Params["accnt"], Request.Params["ver"], dr["class_code"].ToString(), Request.Params["catcode"],
newCatePlN, dr["family_status_code"].ToString(), Request.Params["py"], Request.Params["batch"], fs[1], age[0].Trim(), "",
ViewState["user_id"].ToString(), long_description, fs[0], "2", "0", conn);
}
}
}
}
}
if (!string.IsNullOrEmpty(Request.Params["back"]))
{
//Data.UpdateRates_One_Cvrg(Request.Params["accnt"], Request.Params["cvrgid"], Request.Params["batch"], conn);
Data.add_formulas_for_COBRA_Setup(Request.Params["accnt"], Request.Params["cvrgid"], conn);
}
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
if (!string.IsNullOrEmpty(Request.Params["back"]))
{
if ((Request.Params["back"].Equals("2")))
{
string strParam = "?accnt=" + Request.Params["accnt"] +
"&ver=" + Request.Params["ver"] +
"&class=" + Request.Params["class"] +
"&catcode=" + Request.Params["catcode"] +
"&catplan=" + Request.Params["catplan"] +
"&py=" + Request.Params["py"] +
"&batch=" + Request.Params["batch"] +
"&cvrg=" + Request.Params["cvrg"] +
"&back=2" +
"&cvrgid=" + Request.Params["cvrgid"] +
"&action=" + "0" +
"&id=";
//string strURL = "/WEB_PROJECTS/AUTOMATED_RATE_UPDATE/DoubleAgeRate.aspx" + strParam;
string strURL = "/WEB_PROJECTS/Rates/UseOld.aspx" + strParam;
lblScript.Text = "<script>Javascript:ReRun('" + strURL + "')</script>";
//Bas_Utility.Misc.AlertSaved(Page);
//DrawGrid();
return;
}
}
btnCancel_Click(null, null);
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataTable tbl = gvProfile.DataSource as DataTable;
if (tbl == null)
{
tbl = GetData();
}
RadioButtonList rblst = null;
string strRecord_id = "";
int indx = 0;
foreach (DataRow dr in tbl.Rows)
{
//rblst = FindControl( "rblst_" + indx.ToString()) as RadioButtonList ;
rblst = Bas_Utility.Utilities.GetRadioButtonList(Page, "rblst_" + indx.ToString());
indx++;
strRecord_id = rblst.ID.Replace("rblst_", "");
if (rblst.SelectedValue.Equals("1"))
{
}
else if (rblst.SelectedValue.Equals("0"))
{
}
else
{
jscriptsFunctions.Misc.Alert(Page, "A Decision must be made for ALL items");
return;
}
}
strRecord_id = "";
indx = 0;
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleTransaction tx = conn.BeginTransaction();
try
{
foreach (DataRow dr in tbl.Rows)
{
//rblst = FindControl( "rblst_" + indx.ToString()) as RadioButtonList;
rblst = Bas_Utility.Utilities.GetRadioButtonList(Page, "rblst_" + indx.ToString());
indx++;
strRecord_id = rblst.ID.Replace("rblst_", "");
if (rblst.SelectedValue.Equals("1"))
{
if (dr["which"].ToString().Equals("a"))
{
processAddress(dr);
}
else
{
processProfile(dr);
}
ViewState["email_apprve"] = "0";
}
//else if (rblst.SelectedValue.Equals("0"))
//{
//}
//else
//{
// //tx.Rollback();
// //string strError = "<script>alert('You must ckeck all the dependents first')</script>";
// //Page.ClientScript.RegisterStartupScript(Page.GetType(), "strError", strError);
// //return;
//}
}
Data.Close_pending_ee_profile_addrs(session_id, ViewState["EE_Number"].ToString());
tx.Commit();
}
catch
{
tx.Rollback();
throw;
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
}
jscriptsFunctions.Misc.AlertSaved(Page);
btnNext_Click(null, null);
//Response.Redirect("Profile.aspx?SkipCheck=YES&ee=" + Request.Params["ee"], true);
}