コード例 #1
0
 /// <summary>
 /// Delete Data in cb.ivp_polaris_pricingandanalytics
 /// </summary>
 /// <param name="objClass">Object Of Class</param>
 /// <returns>Bool Value True- Success, False- Failure</returns>
 public bool DeletePricingandanalytics(P_Cb_Ivp_Polaris_Pricingandanalytics objClass)
 {
     try
     {
         string Query = "delete from cb.ivp_polaris_pricingandanalytics where code={0}";
         Query = string.Format(Query, objClass._code);
         if (connect.executeQuery(Query) > 0)
         {
             return(true);
         }
         return(false);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #2
0
 /// <summary>
 /// Update Data in cb.ivp_polaris_pricingandanalytics
 /// </summary>
 /// <param name="objClass">Object Of Class</param>
 /// <returns>Bool Value True- Success, False- Failure</returns>
 public bool UpdatePricingandanalytics(P_Cb_Ivp_Polaris_Pricingandanalytics objClass)
 {
     try
     {
         string Query = "update cb.ivp_polaris_pricingandanalytics set fk_security_id={0},ask_price={1},high_price={2},low_price={3},open_price={4},volume={5},bid_price={6},last_price={7})  "
                        + "where code={8}";
         Query = string.Format(Query, objClass._fk_Security_Id, objClass._ask_Price, objClass._high_Price, objClass._low_Price, objClass._open_Price, objClass._volume, objClass._bid_Price, objClass._last_Price, objClass._code);
         if (connect.executeQuery(Query) > 0)
         {
             return(true);
         }
         return(false);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #3
0
 /// <summary>
 /// Insert Data in cb.ivp_polaris_pricingandanalytics
 /// </summary>
 /// <param name="objClass">Object Of Class</param>
 /// <returns>Bool Value True- Success, False- Failure</returns>
 public bool InsertPricingandanalytics(P_Cb_Ivp_Polaris_Pricingandanalytics objClass)
 {
     try
     {
         string Query = "insert into cb.ivp_polaris_pricingandanalytics(fk_security_id,ask_price,high_price,low_price,open_price,volume,bid_price,last_price)  "
                        + "values({0},{1},{2},{3},{4},{5},{6},{7})";
         Query = string.Format(Query, objClass._fk_Security_Id, objClass._ask_Price, objClass._high_Price, objClass._low_Price, objClass._open_Price, objClass._volume, objClass._bid_Price, objClass._last_Price);
         if (connect.executeQuery(Query) > 0)
         {
             return(true);
         }
         return(false);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }