/// <summary> /// Deletes a Keyword Subject /// </summary> /// <param name="dto"></param> /// <param name="mandatoryOnly"></param> /// <returns></returns> internal int Delete(Keyword_Subject_DTO dto, bool?mandatoryOnly = null) { var inputParams = new List <ADO_inputParams>(); if (dto.KsbCode != default(int)) { inputParams.Add(new ADO_inputParams() { name = "@KsbCode", value = dto.KsbCode }); } if (dto.SbjCode != default(int)) { inputParams.Add(new ADO_inputParams() { name = "@SbjCode", value = dto.SbjCode }); } if (mandatoryOnly != null) { inputParams.Add(new ADO_inputParams() { name = "@KsbMandatoryFlag", value = mandatoryOnly }); } var returnParam = new ADO_returnParam() { name = "@ReturnVal", value = 0 }; ado.ExecuteNonQueryProcedure("System_Navigation_Keyword_Subject_Delete", inputParams, ref returnParam); return((int)returnParam.value); }
/// <summary> /// Deletes a Keyword subject /// </summary> /// <param name="Ado"></param> /// <param name="subjectDto"></param> /// <param name="mandatoryOnly"></param> /// <returns></returns> internal int Delete(ADO Ado, Subject_DTO subjectDto, bool?mandatoryOnly = null) { Keyword_Subject_ADO ksAdo = new Keyword_Subject_ADO(Ado); Keyword_Subject_DTO ksDto = new Keyword_Subject_DTO(); ksDto.SbjCode = subjectDto.SbjCode; if (mandatoryOnly != null) { return(ksAdo.Delete(ksDto, mandatoryOnly)); } else { return(ksAdo.Delete(ksDto)); } }
/// <summary> /// Reads Keyword subjects /// </summary> /// <param name="dto"></param> /// <returns></returns> internal List <dynamic> Read(Keyword_Subject_DTO dto) { var inputParams = new List <ADO_inputParams>(); if (dto.KsbCode != default(int)) { inputParams.Add(new ADO_inputParams { name = "@KsbCode", value = dto.KsbCode }); } if (dto.SbjCode != default(int)) { inputParams.Add(new ADO_inputParams { name = "@SbjCode", value = dto.SbjCode }); } var reader = ado.ExecuteReaderProcedure("System_Navigation_Keyword_Subject_Read", inputParams); return(reader.data); }
/// <summary> /// Updates a Keyword Subject /// </summary> /// <param name="dto"></param> /// <returns></returns> internal int Update(Keyword_Subject_DTO dto) { if (dto.LngIsoCode != null) { Keyword_BSO_Extract bse = new Keyword_BSO_Extract(dto.LngIsoCode); dto.KsbValue = bse.Singularize(dto.KsbValue); } var inputParams = new List <ADO_inputParams>() { new ADO_inputParams() { name = "@KsbCode", value = dto.KsbCode }, new ADO_inputParams() { name = "@KsbValue", value = dto.KsbValue }, new ADO_inputParams() { name = "@KsbMandatoryFlag", value = dto.KsbMandatoryFlag != null?dto.KsbMandatoryFlag:false }, new ADO_inputParams() { name = "@KsbSingularisedFlag", value = dto.LngIsoCode != null } }; var returnParam = new ADO_returnParam() { name = "@ReturnVal", value = 0 }; ado.ExecuteNonQueryProcedure("System_Navigation_Keyword_Subject_Update", inputParams, ref returnParam); return((int)returnParam.value); }