/// <summary> /// Read workflows /// </summary> /// <param name="ado"></param> /// <param name="dto"></param> /// <param name="ccnUsername"></param> /// <returns></returns> internal ADO_readerOutput Read(ADO ado, Workflow_DTO dto, string ccnUsername, string rqsCode = null) { ADO_readerOutput output = new ADO_readerOutput(); var inputParams = new List <ADO_inputParams>() { new ADO_inputParams() { name = "@RlsCode", value = dto.RlsCode }, new ADO_inputParams() { name = "@CcnUsername", value = ccnUsername } }; inputParams.Add(new ADO_inputParams() { name = "@WrqCurrentRequestOnly", value = dto.WrqCurrentFlagOnly }); if (rqsCode != null) { inputParams.Add(new ADO_inputParams() { name = "@RqsCode", value = rqsCode }); } //Call the stored procedure output = ado.ExecuteReaderProcedure("Workflow_Read", inputParams); //Read the result of the call to the database if (output.hasData) { Log.Instance.Debug("Data found"); } else { //No data found Log.Instance.Debug("No data found"); } //return the list of entities that have been found return(output); }
internal Workflow_DTO Populate(ADO ado, Workflow_DTO dto, string ccnUsername) { Workflow_ADO wAdo = new Workflow_ADO(); ADO_readerOutput reader = wAdo.Read(ado, dto, ccnUsername, "PUBLISH"); if (!reader.hasData) { return(dto); } return(new Workflow_DTO() { WrqDatetime = DataAdaptor.ReadDateTime(reader.data[0].WrqDatetime), WrqExceptionalFlag = DataAdaptor.ReadBool(reader.data[0].WrqExceptionalFlag), WrqReservationFlag = DataAdaptor.ReadBool(reader.data[0].WrqReservationFlag), WrqArchiveFlag = DataAdaptor.ReadBool(reader.data[0].WrqArchiveFlag), WrqExperimentalFlag = DataAdaptor.ReadBool(reader.data[0].WrqExperimentalFlag) }); }
internal ADO_readerOutput ReadPendingLive(ADO ado, string ccnUsername, Workflow_DTO dto) { ADO_readerOutput output = new ADO_readerOutput(); var inputParams = new List <ADO_inputParams>() { new ADO_inputParams() { name = "@CcnUsername", value = ccnUsername }, new ADO_inputParams() { name = "@LngIsoCode", value = dto.LngIsoCode }, new ADO_inputParams() { name = "@LngIsoCodeDefault", value = Configuration_BSO.GetCustomConfig("language.iso.code") } }; if (dto.RlsCode != default(int)) { inputParams.Add(new ADO_inputParams() { name = "@RlsCode", value = dto.RlsCode }); } //Call the stored procedure output = ado.ExecuteReaderProcedure("Workflow_ReadPendingLive", inputParams); //return the list of entities that have been found return(output); }