/// <summary>
/// Delete Data in cb.ivp_polaris_securitysummary
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool DeleteSecuritySummary(P_Cb_Ivp_Polaris_Securitysummary objClass)
{
try
{
string Query = "Update cb.ivp_polaris_securitysummary set is_active = '{0}' where security_Id = {1}";
Query = string.Format(Query, objClass._is_Active, objClass._security_Id);
if (connect.executeQuery(Query) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update Data in cb.ivp_polaris_securitysummary
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool UpdateSecuritySummary(P_Cb_Ivp_Polaris_Securitysummary objClass)
{
try
{
string Query = "update cb.ivp_polaris_securitysummary set security_name='{0}',security_description='{1}',asset_type='{2}',investment_type='{3}',trading_factor='{4}',pricing_factor='{5}',created_by='{6}',created_on='{7}',last_modified_by='{8}',last_modified_on='{9}',is_active='{10}') "
+ "where _security_Id={11}";
Query = string.Format(Query, objClass._securiry_Name, objClass._securiry_Description, objClass._asset_Type, objClass._investment_Type, objClass._trading_Factor, objClass._pricing_Factor, objClass._created_By, objClass._created_On, objClass._last_Modified_By, objClass._last_Modified_On, objClass._is_Active, objClass._security_Id);
if (connect.executeQuery(Query) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Insert Data in cb.ivp_polaris_securitysummary
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool InsertSecuritySummary(P_Cb_Ivp_Polaris_Securitysummary objClass)
{
try
{
string Query = "insert into cb.ivp_polaris_securitysummary(security_name,security_description,asset_type,investment_type,trading_factor,pricing_factor,created_by,created_on,last_modified_by,last_modified_on,is_active) "
+ "values('{0}','{1}','{2}','{3}',{4},'{5}','{6}','{7}','{8}','{9}','{10}')";
Query = string.Format(Query, objClass._securiry_Name, objClass._securiry_Description, objClass._asset_Type, objClass._investment_Type, objClass._trading_Factor, objClass._pricing_Factor, objClass._created_By, objClass._created_On, objClass._last_Modified_By, objClass._last_Modified_On, objClass._is_Active);
if (connect.executeQuery(Query) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}