public CPProductDetailModel getListCpProdForContract(long counterPartyId, string cifCounterParty, string counterPartyGroup, DateTime?dataDate, string userId)
{
try
{
CPProductDetailModel resultObject = new CPProductDetailModel();
SqlParameter[] prms = new SqlParameter[]
{
new SqlParameter {
ParameterName = "counterPartyId", DbType = DbType.Int64, Value = counterPartyId, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "cifCounterParty", DbType = DbType.String, Value = string.IsNullOrEmpty(cifCounterParty) ? (object)DBNull.Value : cifCounterParty, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "counterPartyGroup", DbType = DbType.String, Value = string.IsNullOrEmpty(counterPartyGroup) ? (object)DBNull.Value : counterPartyGroup, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "dataDate", DbType = DbType.Date, Value = dataDate != null ? (object)DBNull.Value : dataDate, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "userId", DbType = DbType.String, Value = userId == null ? (object)DBNull.Value : userId, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "resultMessage", DbType = DbType.String, Direction = ParameterDirection.Output, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "resultCode", DbType = DbType.Int32, Direction = ParameterDirection.Output, Size = Int32.MaxValue
}
};
var result = _Repository.ExecWithStoreProcedureCommand(Store_getListCpProdForContract, prms);
if (result.errorCode == 0)
{
resultObject = JsonConvert.DeserializeObject <CPProductDetailModel>(result.errorMessage);
}
else
{
HDBH.Log.WriteLog.Error("CPProductService => Store_getListCpProdForContract => Detail" + result.errorMessage);
}
return(resultObject);
}
catch (Exception ex)
{
HDBH.Log.WriteLog.Error("CPProductService => Store_getListCpProdForContract", ex);
return(null);
}
}
public CPProductDetailModel getDetailCpProdCommis(CPProductGetDetailViewModel input)
{
try
{
CPProductDetailModel resultObject = new CPProductDetailModel();
SqlParameter[] prms = new SqlParameter[]
{
new SqlParameter {
ParameterName = "counterPartyId", DbType = DbType.Int64, Value = input.counterPartyId, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "cifCounterParty", DbType = DbType.String, Value = string.IsNullOrEmpty(input.cifCounterParty) ? (object)DBNull.Value : input.cifCounterParty, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "counterPartyGroup", DbType = DbType.String, Value = string.IsNullOrEmpty(input.counterPartyGroup) ? (object)DBNull.Value : input.counterPartyGroup, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "isInau", DbType = DbType.Int32, Value = input.isInau, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "userId", DbType = DbType.String, Value = input.userId == null ? (object)DBNull.Value : input.userId, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "resultMessage", DbType = DbType.String, Direction = ParameterDirection.Output, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "resultCode", DbType = DbType.Int32, Direction = ParameterDirection.Output, Size = Int32.MaxValue
}
};
var result = _Repository.ExecWithStoreProcedureCommand(Store_getDetailCpProdCommis, prms);
if (result.errorCode == 0)
{
resultObject = JsonConvert.DeserializeObject <CPProductDetailModel>(result.errorMessage);
}
else
{
HDBH.Log.WriteLog.Error("CPProductService => getDetailCpProdCommis => Detail" + result.errorMessage);
}
return(resultObject);
}
catch (Exception ex)
{
HDBH.Log.WriteLog.Error("CPProductService => getDetailCpProdCommis", ex);
return(null);
}
}
