private void SaveDependents(DataRow dr) { Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection(); try { DataTable tbl = Data.GetPendingDepCvrgs(session_id, dr["Record_id"].ToString()); if (tbl.Rows.Count.Equals(0)) return; SQLStatic.Sessions.SetSessionValue(session_id, dr["Category_Code"].ToString(), "1", conn); foreach (DataRow drdep in tbl.Rows) { SQLStatic.Sessions.SetSessionValue(session_id, dr["Category_Code"].ToString() + drdep["dependent_sequence_no"].ToString(), "1", conn); } } finally { conn.Close(); conn.Dispose(); } Data.ProcessDependentCoverages(session_id); }