/// <summary>
/// Select Data of core.ivp_polaris_core_referencedata
/// </summary>
/// <param name="code">Code For Selecting Particular Table_Name.</param>
/// <returns>List Of Objects</returns>
public List <P_Core_Ivp_Polaris_Core_Referencedata> SelectReferenceData(long code = 0)
{
try
{
List <P_Core_Ivp_Polaris_Core_Referencedata> lstObj = new List <P_Core_Ivp_Polaris_Core_Referencedata>();
string Query = "select * from core.ivp_polaris_core_referencedata";
if (code > 0)
{
Query += "where code = {0}";
Query = string.Format(Query, code);
}
DataTable dt = connect.returnDataset(Query).Tables[0];
foreach (DataRow row in dt.Rows)
{
P_Core_Ivp_Polaris_Core_Referencedata tempObj = new P_Core_Ivp_Polaris_Core_Referencedata();
tempObj._code = Convert.ToInt64(row["code"]);
tempObj._issue_Country = row["issue_Country"].ToString();
tempObj._exchange = row["exchange"].ToString();
tempObj._issuer = row["issuer"].ToString();
tempObj._issue_Currency = row["issue_Currency"].ToString();
tempObj._trading_Currency = row["trading_Currency"].ToString();
tempObj._bloomberg_Industry_Sub_Group = row["bloomberg_Industry_Sub_Group"].ToString();
tempObj._bloomberg_Industry_Group = row["bloomberg_Industry_Group"].ToString();
tempObj._bloomberg_Industry_Sector = row["bloomberg_Industry_Sector"].ToString();
tempObj._country_Of_Incorporation = row["country_Of_Incorporation"].ToString();
tempObj._risk_Currency = row["risk_Currency"].ToString();
lstObj.Add(tempObj);
}
return(lstObj);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Delete Data in core.ivp_polaris_core_referencedata
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool DeleteReferenceData(P_Core_Ivp_Polaris_Core_Referencedata objClass)
{
try
{
string Query = "Delete from core.ivp_polaris_core_referencedata 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 core.ivp_polaris_core_referencedata
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool UpdateReferenceData(P_Core_Ivp_Polaris_Core_Referencedata objClass)
{
try
{
string Query = "update core.ivp_polaris_core_referencedata set issue_country = '{0}',exchange = '{1}',issuer = '{2}',issue_currency = '{3}',trading_currency = '{4}',bloomberg_industry_sub_group = '{5}',bloomberg_industry_group = '{6}',bloomberg_industry_sector = '{7}',country_of_incorporation = '{8}',risk_currency = '{9}') "
+ "where code = {10}";
Query = string.Format(Query, objClass._issue_Country, objClass._exchange, objClass._issuer, objClass._issue_Currency, objClass._trading_Currency, objClass._bloomberg_Industry_Sub_Group, objClass._bloomberg_Industry_Group, objClass._bloomberg_Industry_Sector, objClass._country_Of_Incorporation, objClass._risk_Currency, objClass._code);
if (connect.executeQuery(Query) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Insert Data in core.ivp_polaris_core_referencedata
/// </summary>
/// <param name="objClass">Object Of Class</param>
/// <returns>Bool Value True- Success, False- Failure</returns>
public bool InsertReferenceData(P_Core_Ivp_Polaris_Core_Referencedata objClass)
{
try
{
string Query = "insert into core.ivp_polaris_core_referencedata(issue_country,exchange,issuer,issue_currency,trading_currency,bloomberg_industry_sub_group,bloomberg_industry_group,bloomberg_industry_sector,country_of_incorporation,risk_currency) "
+ "values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')";
Query = string.Format(Query, objClass._issue_Country, objClass._exchange, objClass._issuer, objClass._issue_Currency, objClass._trading_Currency, objClass._bloomberg_Industry_Sub_Group, objClass._bloomberg_Industry_Group, objClass._bloomberg_Industry_Sector, objClass._country_Of_Incorporation, objClass._risk_Currency);
if (connect.executeQuery(Query) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
