internal int InsertDUNSregistration(DUNSregistrationEntity obj)
{
int result = 0;
try
{
var dict = obj.ToDictionary();
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.InsertDUNSregistration";
sproc.StoredProceduresParameter.Add(GetParam("@MonitoringRegistrationId", Convert.ToString(obj.MonitoringRegistrationId), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MonitoringProfileId", Convert.ToString(obj.MonitoringProfileId), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@NotificationProfileId", Convert.ToString(obj.NotificationProfileId), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@TradeUpIndicator", Convert.ToString(obj.TradeUpIndicator), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AutoRenewalIndicator", Convert.ToString(obj.AutoRenewalIndicator), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@SubjectCategory", obj.SubjectCategory, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CustomerReferenceText", obj.CustomerReferenceText, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@BillingEndorsementText", obj.BillingEndorsementText, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Tags", obj.Tags, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CredentialId", obj.CredentialId.ToString(), SQLServerDatatype.IntDataType));
result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception)
{
throw;
}
return(result);
}
internal DUNSregistrationEntity GetDUNSregistrationById(int id)
{
DUNSregistrationEntity results = new DUNSregistrationEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetDUNSregistrationById";
sproc.StoredProceduresParameter.Add(GetParam("@MonitoringRegistrationId", id.ToString(), SQLServerDatatype.IntDataType));
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
DUNSregistrationAdapter ta = new DUNSregistrationAdapter();
foreach (DataRow rw in dt.Rows)
{
results = ta.AdaptItem(rw, dt);
}
}
}
catch (Exception)
{
throw;
}
return(results);
}
public int InsertDUNSregistration(DUNSregistrationEntity obj)
{
int result = rep.InsertDUNSregistration(obj);
return(result);
}
