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);
}
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 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 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()
{
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);
}
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 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);
}
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);
}
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);
}
}
public void StartTransaction(Type requestor)
{
if (transRoot != null)
{
throw new Exception("Transazione in corso");
}
if (this.Session_isActive() == false)
{
this.CurrentConnection.Open();
}
currentTransaction = this.CurrentConnection.BeginTransaction();
transRoot = requestor;
}
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();
}
}
}
/// <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()
{
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);
}
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 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 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 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 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)
{
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);
}
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);
}
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);
}
