DataTable dtOkrecords(string strPortFolio) { DataTable dtOkRecords; try { myDH.ParameterCollection paramsMcm = new myDH.ParameterCollection(); paramsMcm.Add(new myDH.InputParameter("recon_handle", Convert.ToString(GetFromSession("OkHandler")))); paramsMcm.Add(new myDH.InputParameter("portfolio", strPortFolio)); paramsMcm.Add(new myDH.InputParameter("portfolio_nm", "NULL")); paramsMcm.Add(new myDH.InputParameter("status", "O")); dtOkRecords = mcmDH.ExecuteStoredProcReturnDS("RCN_EXCEPTION_DETAILS_FI", ref paramsMcm).Tables[0]; return dtOkRecords; } catch (Exception ex) { log.Error("Exception occured-BindGridExceptionSum():", ex); throw; } //return null; }
DataTable dtOkrecords(string strPortFolio) { DataTable dtOkRecords; try { myDH.ParameterCollection paramsMcm = new myDH.ParameterCollection(); paramsMcm.Add(new myDH.InputParameter("recon_handle", Convert.ToString(GetFromSession("OkHandler")))); paramsMcm.Add(new myDH.InputParameter("portfolio", strPortFolio)); paramsMcm.Add(new myDH.InputParameter("status", "O")); // paramsMcm.Add(new myDH.InputParameter("trade_list_id", intTradeListID)); // paramsMcm.Add(new myDH.InputParameter("brkr", strBroker)); dtOkRecords = mcmDH.ExecuteStoredProcReturnDS("FLSH_DTC_RCN_ECEPTION_DETAILS", ref paramsMcm).Tables[0]; return dtOkRecords; } catch (Exception ex) { log.Error("Exception occured-BindGridExceptionSum():", ex); throw; } return null; }
/// <summary> /// calling the stored proc-MCM_STAGE..RCN_EXCEPTION_DETAILS_FI /// retrieve the type of exceptions for the portfolio /// Table used : MCM_STAGE..FLSH_DTC_DIFF_RPT /// Bind the exception with the Gridview-GridExceptionSum /// </summary> DataSet BindGridExceptionSum(string strPortFolio, string strPN) { DataSet dsException; try { myDH.ParameterCollection paramsMcm = new myDH.ParameterCollection(); paramsMcm.Add(new myDH.InputParameter("recon_handle", Convert.ToString(GetFromSession("ExHandler")))); paramsMcm.Add(new myDH.InputParameter("portfolio", strPortFolio)); if(strPN !="") paramsMcm.Add(new myDH.InputParameter("portfolio_nm", strPN)); else paramsMcm.Add(new myDH.InputParameter("portfolio_nm", "NULL")); paramsMcm.Add(new myDH.InputParameter("status", "E")); dsException = mcmDH.ExecuteStoredProcReturnDS("RCN_EXCEPTION_DETAILS_FI", ref paramsMcm); return dsException; } catch (Exception ex) { log.Error("Exception occured-BindGridExceptionSum():", ex); throw; } //return null; }
/// <summary> /// calling the stored procedure MCM_STAGE..FLSH_DTC_RCN_RPT_RESULT /// binding the data according to the page index changed in the Gridview-GridViewReconSum /// </summary> void BinddtExceptionReportSub(int intPageNo, string strHandlerKey) { DataTable dtExceptionSub = new DataTable(); try { myDH.ParameterCollection paramsMcm = new myDH.ParameterCollection(); paramsMcm.Add(new myDH.InputParameter("recon_handle", strHandlerKey));//Convert.ToString(GetFromSession("Handler") paramsMcm.Add(new myDH.InputParameter("page_no", intPageNo)); dtExceptionSub = mcmDH.ExecuteStoredProcReturnDS("FLSH_DTC_RCN_RPT_RESULT", ref paramsMcm).Tables[0]; if (dtExceptionSub.Rows.Count > 0) { GridViewReconSum.VirtualItemCount = Convert.ToInt16(dtExceptionSub.Rows[0]["distinct_rows"]); GridViewReconSum.DataSource = dtExceptionSub; GridViewReconSum.CurrentPageIndex = intPageNo - 1; GridViewReconSum.DataBind(); } } catch (Exception ex) { log.Info("Exception occured-dtExceptionReportSub():", ex); throw; } }
/// <summary> /// calling the stored procedure MCM_STAGE..insert_Portia_mtf /// Returns the no of records inserted in the table MCM_STAGE..FLSH_DTC_PORTIA_MTF /// </summary> public string insertPortiaMTF(DataTable dt) { string strOut = string.Empty; int rowcount = 0; int rowfalse = 0; int paramDelete = 1; foreach (DataRow dr in dt.Rows) { myDH.ParameterCollection param = new myDH.ParameterCollection(); param.Add(new myDH.InputParameter("paramDelete", paramDelete)); param.Add(new myDH.InputParameter("recon_handle", dr["recon_handle"].ToString())); param.Add(new myDH.InputParameter("id", Convert.ToInt32(dr["id"]))); param.Add(new myDH.InputParameter("tran_#", Convert.ToInt32(dr["tran_#"]))); if (dr["trade_list_id"].ToString().Trim() != "") param.Add(new myDH.InputParameter("trade_list_id", Convert.ToInt32(dr["trade_list_id"]))); //else // param.Add(new InputParameter("trade_list_id", DBNull.Value)); if (dr["portfolio_nm"].ToString().Trim() != "") param.Add(new myDH.InputParameter("portfolio_nm", dr["portfolio_nm"].ToString())); //else // param.Add(new InputParameter("portfolio_nm", DBNull.Value)); if (dr["portfolio"].ToString() != "") param.Add(new myDH.InputParameter("portfolio", dr["portfolio"].ToString())); //else // param.Add(new InputParameter("portfolio", DBNull.Value)); if (dr["security_nm"].ToString().Trim() != "") param.Add(new myDH.InputParameter("security_nm", dr["security_nm"].ToString())); //else //param.Add(new InputParameter("security_nm", DBNull.Value)); if (dr["cusip"].ToString().Trim() != "") param.Add(new myDH.InputParameter("cusip", dr["cusip"].ToString())); //else //param.Add(new InputParameter("cusip", DBNull.Value)); param.Add(new myDH.InputParameter("lot_#", Convert.ToInt32(dr["lot_#"]))); param.Add(new myDH.InputParameter("tran_type_id", Convert.ToInt32(dr["tran_type_int"]))); param.Add(new myDH.InputParameter("tran_type", dr["tran_type"].ToString())); param.Add(new myDH.InputParameter("trade_date", dr["trade_date"].ToString())); param.Add(new myDH.InputParameter("settle_date", dr["settle_date"].ToString())); param.Add(new myDH.InputParameter("broker", dr["broker"].ToString())); param.Add(new myDH.InputParameter("broker_number", dr["broker_number"].ToString())); param.Add(new myDH.InputParameter("quantity", Convert.ToDecimal(dr["quantity"]))); param.Add(new myDH.InputParameter("price", Convert.ToDecimal(dr["price"]))); param.Add(new myDH.InputParameter("commission", Convert.ToDecimal(dr["commission"]))); param.Add(new myDH.InputParameter("sec_fee", Convert.ToDecimal(dr["sec_fee"]))); param.Add(new myDH.InputParameter("total_amount", Convert.ToDecimal(dr["total_amount"]))); param.Add(new myDH.InputParameter("entry_status", dr["entry_status"].ToString())); if (dr["raw_id"].ToString().Trim() != "") param.Add(new myDH.InputParameter("raw_id", Convert.ToInt32(dr["raw_id"]))); //else //param.Add(new InputParameter("raw_id", DBNull.Value)); if (dr["post_date"].ToString().Trim() != "") param.Add(new myDH.InputParameter("post_date", dr["post_date"].ToString())); //else //param.Add(new InputParameter("post_date", DBNull.Value)); if (dr["settlement_country"].ToString().Trim() != "") param.Add(new myDH.InputParameter("settlement_country", dr["settlement_country"].ToString())); //else //param.Add(new InputParameter("settlement_country", DBNull.Value)); if (dr["currency_id"].ToString().Trim() != "") param.Add(new myDH.InputParameter("currency_id", dr["currency_id"].ToString())); //else //param.Add(new InputParameter("currency_id", DBNull.Value)); if (dr["price_symbol"].ToString().Trim() != "") param.Add(new myDH.InputParameter("price_symbol", dr["price_symbol"].ToString())); // else // param.Add(new InputParameter("price_symbol", DBNull.Value)); if (dr["interest"].ToString().Trim() != "") param.Add(new myDH.InputParameter("interest", Convert.ToDecimal(dr["interest"]))); //else //param.Add(new InputParameter("interest", DBNull.Value)); if (dr["principal_amount"].ToString().Trim() != "") param.Add(new myDH.InputParameter("principal_amount", Convert.ToDecimal(dr["principal_amount"]))); // else //param.Add(new InputParameter("principal_amount", DBNull.Value)); if (dr["sec_type"].ToString().Trim() != "") param.Add(new myDH.InputParameter("sec_type", dr["sec_type"].ToString())); //else //param.Add(new InputParameter("sec_type", DBNull.Value)); try { strOut = Convert.ToString(mcmDH.ExecuteStoredProcReturnScalar("dbo.insert_Portia_mtf", ref param)); param = null; } catch (Exception ex) { param = null; strOut = "ERROR"; } if (paramDelete == 1) paramDelete = 0; if (strOut == "0") { rowcount += 1; } else { rowfalse += 1; } param = null; } theDH.Dispose(); log.Info("Not inserted-FLSH_DTC_PORTIA_MTF Rowcount:" + rowfalse.ToString()); log.Info("Inserted-FLSH_DTC_PORTIA_MTF Rowcount:" + rowcount.ToString()); return Convert.ToString(rowcount + "," + rowfalse); }
/// <summary> /// calling the stored procedure PORTIA_APO..mcm_dtc_recon_New for Equity trades /// calling the stored procedure PORTIA_APO..mcm_dtc_recon_FI_New for FI trades /// Returns the datatable of inserted records from the table PORTIA_APO..mcm_dtc_flash_work /// </summary> private DataTable GetPortiamtfraw(string strHandler, string strTradeDate, string strTradeType, string strTypeVal) { DataTable dtPortia = new DataTable(); try { myDH.ParameterCollection parms = new myDH.ParameterCollection(); parms.Add(new myDH.InputParameter("recon_handle", strHandler)); parms.Add(new myDH.InputParameter("trade_date", strTradeDate)); parms.Add(new myDH.InputParameter("trade_Type", strTradeType)); if (strTypeVal == "1")//Equity trades dtPortia = theDH.ExecuteStoredProcReturnDS("mcm_dtc_recon_New", ref parms).Tables[0]; else//FI trades //dtPortia = theDH.ExecuteStoredProcReturnDS("mcm_dtc_recon_FI_New", ref parms).Tables[0]; { } log.Info(":Retrieved From PORTIA_APO..mcm_dtc_flash_work:" + Convert.ToString(dtPortia.Rows.Count)); return dtPortia; } catch (Exception ex) { log.Info("Exception occured GetPortiamtfraw()", ex); throw; } //return dtPortia; }
//#region UserDefined Function ///// <summary> ///// calling the stored proc-MCM_STAGE..FLSH_DTC_RCN_ECEPTION_RESULT ///// retrieve the type of exceptions for the portfolio ///// Table used : MCM_STAGE..FLSH_DTC_DIFF_RPT ///// Bind the exception with the Gridview-GridExceptionSum ///// </summary> //DataSet BindGridExceptionSum(string strPortFolio) //{ // DataSet dsException; // try // { // myDH.ParameterCollection paramsMcm = new myDH.ParameterCollection(); // paramsMcm.Add(new myDH.InputParameter("recon_handle", Convert.ToString(GetFromSession("ExHandler")))); // paramsMcm.Add(new myDH.InputParameter("portfolio", strPortFolio)); // paramsMcm.Add(new myDH.InputParameter("status", "E")); // // paramsMcm.Add(new myDH.InputParameter("trade_list_id", intTradeListID)); // // paramsMcm.Add(new myDH.InputParameter("brkr", strBroker)); // dsException = mcmDH.ExecuteStoredProcReturnDS("FLSH_DTC_RCN_ECEPTION_DETAILS", ref paramsMcm); // return dsException; // } // catch (Exception ex) // { // log.Error("Exception occured-BindGridExceptionSum():", ex); // throw; // } // return null; //} #region UserDefined Function /// <summary> By Ruchi /// calling the stored proc-MCM_STAGE..FLSH_DTC_RCN_ECEPTION_RESULT /// retrieve the type of exceptions for the portfolio /// Table used : MCM_STAGE..FLSH_DTC_DIFF_RPT /// Bind the exception with the Gridview-GridExceptionSum /// </summary> DataSet BindGridExceptionSum(string strPortFolio, DateTime dtSettleDate) { DataSet dsException; try { myDH.ParameterCollection paramsMcm = new myDH.ParameterCollection(); paramsMcm.Add(new myDH.InputParameter("recon_handle", Convert.ToString(GetFromSession("ExHandler")))); paramsMcm.Add(new myDH.InputParameter("portfolio", strPortFolio)); paramsMcm.Add(new myDH.InputParameter("status", "E")); //Added by Ruchi paramsMcm.Add(new myDH.InputParameter("settle_date", dtSettleDate)); // paramsMcm.Add(new myDH.InputParameter("trade_list_id", intTradeListID)); // paramsMcm.Add(new myDH.InputParameter("brkr", strBroker)); dsException = mcmDH.ExecuteStoredProcReturnDS("FLSH_DTC_RCN_ECEPTION_DETAILS", ref paramsMcm); return dsException; } catch (Exception ex) { log.Error("Exception occured-BindGridExceptionSum():", ex); throw; } return null; }