public int AddOtherBenchmarkSearch(string benchmarkName)
{
using (SqlConnection conn = Sql.GetEditorConnection("SecurityData"))
{
SQLsp spHelper = new SQLsp(conn, "addOtherBenchmarkSearch");
if (!String.IsNullOrEmpty(benchmarkName))
{
spHelper.setParameterValue("@p_BenchmarkName", benchmarkName);
}
else
{
spHelper.setParameterValue("@p_BenchmarkName", DBNull.Value);
}
spHelper.executeNonQuery();
int benchmarkId = 0;
if(spHelper.getParameterValue("@r_BenchmarkId") != DBNull.Value)
{
Int32.TryParse(spHelper.getParameterValue("@r_BenchmarkId").ToString(),
out benchmarkId);
}
return benchmarkId;
}
}
public void AddXXX_OtherBenchmark_20121211(int benchmarkId, string benchmarkName)
{
using (SqlConnection conn = Sql.GetEditorConnection("CurrentData"))
{
SQLsp spHelper = new SQLsp(conn, "addXXX_OtherBenchmark_20121211");
spHelper.setParameterValue("@p_BenchmarkId", benchmarkId);
if (!String.IsNullOrEmpty(benchmarkName))
{
spHelper.setParameterValue("@p_BenchmarkName", benchmarkName);
}
else
{
spHelper.setParameterValue("@p_BenchmarkName", DBNull.Value);
}
spHelper.executeNonQuery();
}
}
public void AddFundBenchmarkIndexMapping(string fundId,
int benchmarkId,
int benchmarkType,
string indexId,
double weight,
int createUserId,
DateTime effectiveDate
)
{
using (SqlConnection conn = Sql.GetEditorConnection("CurrentData"))
{
SQLsp spHelper = new SQLsp(conn, "addFundBenchmarkIndexMapping");
if (!String.IsNullOrEmpty(fundId))
{
spHelper.setParameterValue("@p_FundId", fundId);
}
else
{
spHelper.setParameterValue("@p_FundId", DBNull.Value);
}
spHelper.setParameterValue("@p_BenchmarkType", benchmarkType);
if (benchmarkId == 0)
{
spHelper.setParameterValue("@p_RawBenchmarkId", DBNull.Value);
}
else
{
spHelper.setParameterValue("@p_RawBenchmarkId", benchmarkId);
}
if (!String.IsNullOrEmpty(indexId))
{
spHelper.setParameterValue("@p_IndexId", indexId);
}
else
{
spHelper.setParameterValue("@p_IndexId", DBNull.Value);
}
spHelper.setParameterValue("@p_EffectiveDate", effectiveDate);
spHelper.setParameterValue("@p_Weight", weight);
spHelper.setParameterValue("@p_Status", 3);
spHelper.setParameterValue("@p_CreationDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
spHelper.setParameterValue("@p_CreateUserId", createUserId);
spHelper.setParameterValue("@p_ApproveUserId", DBNull.Value);
spHelper.setParameterValue("@p_StatusChangeUserId", DBNull.Value);
spHelper.setParameterValue("@p_StatusChangeDate", DBNull.Value);
spHelper.executeNonQuery();
}
}
