internal string EditMappingMetaData(DandBEnrichmentDataEntity obj)
        {
            string result = string.Empty;

            try
            {
                StoredProcedureEntity sproc = new StoredProcedureEntity();
                sproc.StoredProcedureName = "dnb.EditMappingMetaData";
                sproc.StoredProceduresParameter.Add(GetParam("@MappingId", obj.MappingId.ToString(), SQLServerDatatype.VarcharDataType));
                sproc.StoredProceduresParameter.Add(GetParam("@JSONPath", obj.JSONPath.ToString(), SQLServerDatatype.VarcharDataType));
                sproc.StoredProceduresParameter.Add(GetParam("@SpecialHandling", !string.IsNullOrEmpty(obj.SpecialHandling) ? Convert.ToString(obj.SpecialHandling) : "", SQLServerDatatype.VarcharDataType));
                sproc.StoredProceduresParameter.Add(GetParam("@MBSColumnName", obj.MBSColumnName.ToString(), SQLServerDatatype.VarcharDataType));
                sproc.StoredProceduresParameter.Add(GetParam("@DataType", Convert.ToString(obj.DataType), SQLServerDatatype.VarcharDataType));
                result = Convert.ToString(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
            }
            catch (Exception ex)
            {
                result = ex.Message;
            }

            return(result);
        }
Exemple #2
0
 public string EditMappingMetaData(DandBEnrichmentDataEntity model)
 {
     return(rep.EditMappingMetaData(model));
 }
Exemple #3
0
 public string AddNewMappingMetaData(DandBEnrichmentDataEntity model)
 {
     return(rep.AddNewMappingMetaData(model));
 }