private void ConfirmRecords(Boolean SelectAll)//-----------------------------------------------Confirm All Records------------------------------------------------// { try { //Int32 RecCount = GetUnreceiptedCount(); //if (RecCount > 499) //{ // call_error_msg(true); // lblResult.Text = "Please Run the relavant receipt batch and do the other confirmations...!"; // return; //} CommonCLS.IBTBatches IBTBatch = new CommonCLS.IBTBatches(); String BatchNo = IBTBatch.GetBatchNo("BATCH_NO"); if (GrdIBTConfirmation.Rows.Count > 0) { using (OracleConnection OraCon = new OracleConnection(ConfigurationManager.ConnectionStrings["ORAWF"].ToString())) { OraCon.Open(); OracleCommand command = OraCon.CreateCommand(); OracleTransaction transaction; // Start a local transaction transaction = OraCon.BeginTransaction(System.Data.IsolationLevel.ReadCommitted); // Assign transaction object for a pending local transaction command.Transaction = transaction; try { DataTable Dt = (DataTable)Session["ConfirmedData"]; //when user select all the records to be confirmed if (SelectAll) { Int16 Count = 0; foreach (DataRow item in Dt.Rows) { //if (Count == 500) //{ // call_error_msg(true); // lblResult.Text = "Please Run the relavant receipt batch and do the other confirmations...!"; // break; //} OracleCommand cmd = OraCon.CreateCommand(); cmd.CommandText = "SP_FAS_IBT_CONFIRMATION"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("vPolicyNo", OracleType.VarChar).Value = item["POLICY_NO"].ToString(); cmd.Parameters.Add("vProduct", OracleType.VarChar).Value = item["VALUE"].ToString(); cmd.Parameters.Add("vAmount", OracleType.Number).Value = item["CREDIT"].ToString(); cmd.Parameters.Add("vID", OracleType.Number).Value = Convert.ToInt64(item["ID"].ToString()); cmd.Parameters.Add("vCreatedBy", OracleType.VarChar).Value = usrName; cmd.Parameters.Add("vBatchNo", OracleType.VarChar).Value = BatchNo; cmd.Transaction = transaction; cmd.ExecuteNonQuery(); //***********************************************************************************************Test Count++; } } else { foreach (GridViewRow row in GrdIBTConfirmation.Rows)//Selected Records { CheckBox chk = (row.Cells[0].FindControl("chkboxselect") as CheckBox); DropDownList Commision = row.Cells[1].FindControl("ddlCommision") as DropDownList; if ((chk != null && chk.Checked) || SelectAll) { OracleCommand cmd = OraCon.CreateCommand(); cmd.CommandText = "SP_FAS_IBT_CONFIRMATION"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("vPolicyNo", OracleType.VarChar).Value = row.Cells[6].Text.ToString(); cmd.Parameters.Add("vProduct", OracleType.VarChar).Value = row.Cells[9].Text.ToString(); cmd.Parameters.Add("vAmount", OracleType.Number).Value = Convert.ToDouble(row.Cells[7].Text); cmd.Parameters.Add("vID", OracleType.Number).Value = Convert.ToInt64(row.Cells[1].Text); cmd.Parameters.Add("vCreatedBy", OracleType.VarChar).Value = usrName; cmd.Parameters.Add("vBatchNo", OracleType.VarChar).Value = BatchNo; cmd.Transaction = transaction; cmd.ExecuteNonQuery();//***********************************************************************************************Test //--------Send Data To TCS for Receipting--------- // Exess // Partial // When Two Debit Returns // When PPW Cancelled //------------------------------------------------ } } } transaction.Commit(); OraCon.Close(); GrdIBTConfirmation.DataSource = null; GrdIBTConfirmation.DataBind(); //--------Load New business and renewal system detected exeptions--------- LoadExeptionData(); //------------------------------------------------------------------------ call_error_msg(true); lblResult.Text = "Confirmation Successfull...!"; CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, "----IBT Confirmation Successfull ---- Active User: "******"~/IBTLogFiles/Log.txt")); //LoadData(); } catch (Exception ex) { CommonCLS.CommonFunctions.Logger(System.Web.VirtualPathUtility.GetFileName(System.Web.HttpContext.Current.Request.Url.AbsolutePath), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.InnerException.ToString(), Server.MapPath("~/IBTLogFiles/Log.txt")); call_error_msg(false); lblResult.Text = ex.InnerException.ToString(); } } } else { call_error_msg(false); lblResult.Text = "No Matching Records Available!"; } } catch (Exception) { throw; } }
private void LoadData(String CatID)//----------------------------------------------------------Load Data To Grid View---------------------------------------------// { try { OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ORAWF"].ToString()); conn.Open(); String Where = ""; if (Session["IBT_Company"] == null) { return; } //Life General Bifurcation according to the logged user. if (Session["IBT_Company"].ToString() == "GENERAL") { Where = " AND (P.VALUE = 1 or P.VALUE = 3)"; } if (Session["IBT_Company"].ToString() == "LIFE") { Where = " AND (P.VALUE = 2 or P.VALUE = 4)"; } if (Session["IBT_Company"].ToString() == "ALL") { Where = ""; //Where = " AND P.VALUE = -1"; } Where = Where + " AND T.DEPARTMENT = " + CatID; //OracleCommand cmd = new OracleCommand(" SELECT T.ID, T.ACCOUNT_NO,T.SERIAL_NO,to_char(T.TRANSACTION_DATE, 'DD/MM/RRRR') AS TRAN_DATE,T.DESCRIPTION,T.POLICY_NO,T.CREDIT,P.PRODUCT_DESCRIPTION,P.VALUE " + // " FROM FAS_IBT_UPLOADED_DTL T INNER JOIN FAS_IBT_PRODUCTS P ON " + // " P.VALUE = T.PRODUCT WHERE T.MATCHING_STATUS = 2 AND T.DEPARTMENT <> 1 " + Where, conn); OracleCommand cmd = new OracleCommand(" SELECT T.ID, T.ACCOUNT_NO,T.SERIAL_NO,to_char(T.TRANSACTION_DATE, 'DD/MM/RRRR') AS TRAN_DATE,T.DESCRIPTION,T.POLICY_NO,T.CREDIT,P.PRODUCT_DESCRIPTION,P.VALUE " + " FROM FAS_IBT_UPLOADED_DTL T INNER JOIN FAS_IBT_PRODUCTS P ON " + " P.VALUE = T.PRODUCT WHERE T.MATCHING_STATUS = 2 AND t.effective_end_date is null AND T.DEPARTMENT <> 1" + Where, conn); OracleDataAdapter oda = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); oda.Fill(dt); //Session["Dt"] //call_error_msg(true); lblReceiptStatus.Text = " - Total Records - " + Convert.ToString(dt.Rows.Count); GrdIBTConfirmation.DataSource = dt; GrdIBTConfirmation.DataBind(); Session["ConfirmedData"] = dt; conn.Close(); } catch (Exception) { throw; } }