/// <summary>
/// Delete Data in cb.ivp_polaris_risk
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool DeleteRisk(P_Cb_Ivp_Polaris_Risk objClass)
{
try
{
string Query = "delete from cb.ivp_polaris_risk where code={0}";
Query = string.Format(Query, objClass._code);
if (connect.executeQuery(Query) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update Data in cb.ivp_polaris_risk
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool UpdateRisk(P_Cb_Ivp_Polaris_Risk objClass)
{
try
{
string Query = "update cb.ivp_polaris_risk set fk_security_id = {0},firstcouponcode = '{1}',duration = '{2}',volatility_thirtyD = '{3}',volatility_nintyD = '{4}',convexity = '{5}',average_volume_thirtyD = '{6}') "
+ "where code={7}";
Query = string.Format(Query, objClass._fk_Security_Id, objClass._firstcouponcode, objClass._duration, objClass._volatility_ThirtyD, objClass._volatility_NintyD, objClass._convexity, objClass._average_Volume_ThirtyD, objClass._code);
if (connect.executeQuery(Query) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Insert Data in cb.ivp_polaris_risk
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool InsertRisk(P_Cb_Ivp_Polaris_Risk objClass)
{
try
{
string Query = "insert into cb.ivp_polaris_risk(fk_security_id,firstcouponcode,duration,volatility_thirtyD,volatility_nintyD,convexity,average_volume_thirtyD) "
+ "values({0},'{1}','{2}','{3}','{4}','{5}','{6}')";
Query = string.Format(Query, objClass._fk_Security_Id, objClass._firstcouponcode, objClass._duration, objClass._volatility_ThirtyD, objClass._volatility_NintyD, objClass._convexity, objClass._average_Volume_ThirtyD);
if (connect.executeQuery(Query) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
