public int saveCaseDenials(ArrayList objAL)
{
int j = 0;
sqlCon = new SqlConnection(strsqlCon);
sqlCon.Open();
try
{
if (sqlCon != null)
{
Bill_Sys_Denial_Desc obj = null;
for (int i = 0; i < objAL.Count; i++)
{
obj = (Bill_Sys_Denial_Desc)objAL[i];
sqlCmd = new SqlCommand("SP_SAVE_CASE_DENIAL_DESCRIPTION", sqlCon);
sqlCmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@SZ_CASE_ID", obj.sz_case_id);
sqlCmd.Parameters.AddWithValue("@SZ_CASE_NO", obj.sz_case_no);
sqlCmd.Parameters.AddWithValue("@SZ_DESCRIPTION", obj.sz_description);
sqlCmd.Parameters.AddWithValue("@DT_VERIFICATION_DATE", obj.sz_verification_date);
sqlCmd.Parameters.AddWithValue("@I_VERIFICATION_TYPE", 3);
sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_ID", obj.sz_company_id);
sqlCmd.Parameters.AddWithValue("@SZ_CREATED_USER_ID", obj.sz_user_id);
sqlCmd.Parameters.AddWithValue("@SZ_DENIAL_REASONS_CODE", obj.sz_denial_reason_code);
sqlCmd.Parameters.AddWithValue("@SZ_USER_NAME", obj.sz_user_name);
sqlCmd.Parameters.AddWithValue("@FLAG", obj.sz_flag);
j = sqlCmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
if (sqlCon.State == ConnectionState.Open)
{
sqlCon.Close();
}
}
return(j);
//Method End
}
protected void btnSaveDesc_Click(object sender, EventArgs e)
{
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
int j = 0;
Bill_Sys_Case_Denial objOpDen = new Bill_Sys_Case_Denial();
string reasons = hfdenialReason.Value.ToString();
string[] reasonCodes = reasons.Split(',');
try
{
ArrayList objDen = new ArrayList();
for (int i = 0; i < reasonCodes.Length - 1; i++)
{
Bill_Sys_Denial_Desc objDesc = new Bill_Sys_Denial_Desc();
objDesc.sz_company_id = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString();
objDesc.sz_case_id = ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID.ToString();
objDesc.sz_case_no = ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_NO.ToString();
objDesc.sz_description = txtSaveDescription.Text.ToString();
objDesc.sz_verification_date = txtSaveDate.Text.ToString();
objDesc.sz_user_id = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString();
objDesc.sz_denial_reason_code = reasonCodes[i].ToString();
objDesc.sz_user_name = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_NAME.ToString();
objDesc.sz_flag = "DEN";
objDen.Add(objDesc);
}
j = objOpDen.saveCaseDenials(objDen);
txtSaveDate.Text = "";
extddenial.Text = "0";
lbSelectedDenial.Text = "";
hfdenialReason.Value = "";
if (j > 0)
{
usrMessage.PutMessage("Records Saved Successfully.");
usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage);
usrMessage.Show();
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
}
//}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}