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(); } }