/// <summary> /// Delete Data in eq.ivp_polaris_securitydetails /// </summary> /// <param name="objClass">Object Of Class</param> /// <returns>Bool Value True- Success, False- Failure</returns> public bool DeleteSecurityDetails(P_Eq_Ivp_Polaris_Securitydetails objClass) { try { string Query = "delete from eq.ivp_polaris_securitydetails where code={0}"; Query = string.Format(Query, objClass._code); if (connect.executeQuery(Query) > 0) { return(true); } return(false); } catch (Exception ex) { throw ex; } }
/// <summary> /// Insert Data in eq.ivp_polaris_securitydetails /// </summary> /// <param name="objClass">Object Of Class</param> /// <returns>Bool Value True- Success, False- Failure</returns> public bool InsertSecurityDetails(P_Eq_Ivp_Polaris_Securitydetails objClass) { try { string Query = "insert into eq.ivp_polaris_securitydetails(fk_security_id,is_adr,adr_underlying_ticker,adr_underlying_currency,shares_per_adr,ipo_date,price_currency,settle_days,shares_outstanding,voting_rights_per_share,form_pf_asset_class,form_pf_country,form_pf_credit_rating,form_pf_currency,form_pf_instrument,form_pf_liquid_profile,form_pf_maturity,form_pf_naics_code,form_pf_region,form_pf_sector,form_pf_sub_asset_class) " + "values({0},'{1}','{2}','{3}','{4}','{5}','{6}',{7},'{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}')"; Query = string.Format(Query, objClass._fk_Security_Id, objClass._is_Adr, objClass._adr_Underlying_Ticker, objClass._adr_Underlying_Currency, objClass._shares_Per_Adr, objClass._ipo_Date, objClass._price_Currency, objClass._settle_Days, objClass._shares_Outstanding, objClass._voting_Rights_Per_Share, objClass._form_Pf_Asset_Class, objClass._form_Pf_Country, objClass._form_Pf_Credit_Rating, objClass._form_Pf_Currency, objClass._form_Pf_Instrument, objClass._form_Pf_Liquid_Profile, objClass._form_Pf_Maturity, objClass._form_Pf_Naics_Code, objClass._form_Pf_Region, objClass._form_Pf_Sector, objClass._form_Pf_Sub_Asset_Class); if (connect.executeQuery(Query) > 0) { return(true); } return(false); } catch (Exception ex) { throw ex; } }