public async Task<string> HandleResult(IDictionary<string, object> payload)
        {
            var connectionString = "Data Source=TestSQL;Initial Catalog=YPIData;Integrated Security=True";
                        
            string testName = (string)payload["testName"];
            string aliquotOrderId = (string)payload["aliquotOrderId"];
            string result = (string)payload["result"];
            string sql = null;

            if (testName == "TRICH")
            {
                HPVResult hpvResult = null;
                if (result == "TRICH neg")
                {
                    hpvResult = new HPVNegativeResult();
                    sql = @"Update tblTrichomonasTestOrder set Result = '" + hpvResult.Result + "' "
                        + "from tblTrichomonasTestOrder psoh, tblPanelSetOrder pso "
                        + "where psoh.ReportNo = pso.ReportNo "
                        + "and pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";                        

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "', "
                    + "[HoldDistribution] = 1, "
                    + "[Accepted] = 1, "
                    + "[AcceptedBy] = 'Optimus Prime', "
                    + "[AcceptedById] = 5134, "
                    + "[AcceptedDate] = '" + DateTime.Today.ToString("MM/dd/yyyy") + "', "
                    + "[AcceptedTime] = '" + DateTime.Now.ToString("MM/dd/yyyy HH:mm") + "', "
                    + "[Final] = 1, "
                    + "[Signature] = 'Optimus Prime', "
                    + "[FinaledById] = 5134, "
                    + "[FinalDate] = '" + DateTime.Today.ToString("MM/dd/yyyy") + "', "
                    + "[FinalTime] = '" + DateTime.Now.ToString("MM/dd/yyyy HH:mm") + "' "
                    + "where PanelSetId = 61 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";                    
                }
                else if (result == "TRICH POS")
                {
                    hpvResult = new HPVPositiveResult();
                    sql = @"Update tblTrichomonasTestOrder set Result = '" + hpvResult.Result + "' "
                        + "from tblTrichomonasTestOrder psoh, tblPanelSetOrder pso "
                        + "where psoh.ReportNo = pso.ReportNo "
                        + "and pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";                        

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "', "
                    + "[HoldDistribution] = 1, "
                    + "[Accepted] = 1, "
                    + "[AcceptedBy] = 'Optimus Prime', "
                    + "[AcceptedById] = 5134, "
                    + "[AcceptedDate] = '" + DateTime.Today.ToString("MM/dd/yyyy") + "', "
                    + "[AcceptedTime] = '" + DateTime.Now.ToString("MM/dd/yyyy HH:mm") + "' "
                    + "where PanelSetId = 61 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";
                }
                else if (result == "Invalid")
                {
                    hpvResult = new HPVInvalidResult();
                    sql = @"Update tblHPVTestOrder set Result = '" + hpvResult.Result + "' "
                        + "from tblHPVTestOrder psoh, tblPanelSetOrder pso "
                        + "where psoh.ReportNo = pso.ReportNo "
                        + "and pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";                    

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "', "
                    + "[HoldDistribution] = 1 "                    
                    + "where PanelSetId = 61 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";                    
                }
            }

            using (var cnx = new SqlConnection(connectionString))
            {
                using (var cmd = new SqlCommand(sql, cnx))
                {
                    await cnx.OpenAsync();
                    await cmd.ExecuteNonQueryAsync();
                }
            }

            return "Optimus Prime updated result: " + aliquotOrderId + " - " + testName + " on: " + DateTime.Now.ToString();
        }
        public async Task <string> HandleResult(IDictionary <string, object> payload)
        {
            var connectionString = "Server = 10.1.2.26; Uid = sqldude; Pwd = 123Whatsup; Database = lis;";

            string testName              = (string)payload["testName"];
            string aliquotOrderId        = (string)payload["aliquotOrderId"];
            string overallInterpretation = (string)payload["overallInterpretation"];
            string sql = null;

            if (testName == "HPV")
            {
                HPVResult hpvResult = null;
                if (overallInterpretation == "Negative")
                {
                    hpvResult = new HPVNegativeResult();
                    sql       = @"Update tblHPVTestOrder psoh "
                                + "Inner join tblPanelSetOrder pso on psoh.ReportNo = pso.ReportNo "
                                + "Set Result = '" + hpvResult.Result + "' "
                                + "Where pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "', "
                           + "Accepted = 1, "
                           + "AcceptedBy = 'AUTOVER TESTING', "
                           + "AcceptedById = 5134, "
                           + "AcceptedDate = '" + DateTime.Today.ToString("yyyy-MM-dd") + "', "
                           + "AcceptedTime = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "', "
                           + "Final = 1, "
                           + "Signature = 'AUTOVER TESTING', "
                           + "FinaledById = 5134, "
                           + "FinalDate = '" + DateTime.Today.ToString("yyyy-MM-dd") + "', "
                           + "FinalTime = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' "
                           + "where PanelSetId = 14 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";
                }
                else if (overallInterpretation == "POSITIVE")
                {
                    hpvResult = new HPVPositiveResult();
                    sql       = @"Update tblHPVTestOrder psoh "
                                + "Inner join tblPanelSetOrder pso on psoh.ReportNo = pso.ReportNo "
                                + "Set Result = '" + hpvResult.Result + "' "
                                + "Where pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "', "
                           + "Accepted = 1, "
                           + "AcceptedBy = 'AUTOVER TESTING', "
                           + "AcceptedById = 5134, "
                           + "AcceptedDate = '" + DateTime.Today.ToString("yyyy-MM-dd") + "', "
                           + "AcceptedTime = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' "
                           + "where PanelSetId = 14 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";
                }
                else if (overallInterpretation == "Invalid")
                {
                    hpvResult = new HPVInvalidResult();
                    sql       = @"Update tblHPVTestOrder psoh "
                                + "Inner Join tblPanelSetOrder pso on psoh.ReportNo = pso.ReportNo "
                                + "set Result = '" + hpvResult.Result + "' "
                                + "Where pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "' "
                           + "where PanelSetId = 14 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";
                }
            }

            using (var cnx = new MySqlConnection(connectionString))
            {
                using (var cmd = new MySqlCommand(sql, cnx))
                {
                    await cnx.OpenAsync();

                    await cmd.ExecuteNonQueryAsync();
                }
            }

            return("Optimus Prime updated result: " + aliquotOrderId + " - " + testName + " on: " + DateTime.Now.ToString());
        }
예제 #3
0
        public async Task <string> HandleResult(IDictionary <string, object> payload)
        {
            var connectionString = "Data Source=TestSQL;Initial Catalog=YPIData;Integrated Security=True";

            string testName              = (string)payload["testName"];
            string aliquotOrderId        = (string)payload["aliquotOrderId"];
            string overallInterpretation = (string)payload["overallInterpretation"];
            string sql = null;

            if (testName == "HPV")
            {
                HPVResult hpvResult = null;
                if (overallInterpretation == "Negative")
                {
                    hpvResult = new HPVNegativeResult();
                    sql       = @"Update tblHPVTestOrder set Result = '" + hpvResult.Result + "' "
                                + "from tblHPVTestOrder psoh, tblPanelSetOrder pso "
                                + "where psoh.ReportNo = pso.ReportNo "
                                + "and pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "', "
                           + "[HoldDistribution] = 1, "
                           + "[Accepted] = 1, "
                           + "[AcceptedBy] = 'Optimus Prime', "
                           + "[AcceptedById] = 5134, "
                           + "[AcceptedDate] = '" + DateTime.Today.ToString("MM/dd/yyyy") + "', "
                           + "[AcceptedTime] = '" + DateTime.Now.ToString("MM/dd/yyyy HH:mm") + "', "
                           + "[Final] = 1, "
                           + "[Signature] = 'Optimus Prime', "
                           + "[FinaledById] = 5134, "
                           + "[FinalDate] = '" + DateTime.Today.ToString("MM/dd/yyyy") + "', "
                           + "[FinalTime] = '" + DateTime.Now.ToString("MM/dd/yyyy HH:mm") + "' "
                           + "where PanelSetId = 14 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";
                }
                else if (overallInterpretation == "POSITIVE")
                {
                    hpvResult = new HPVPositiveResult();
                    sql       = @"Update tblHPVTestOrder set Result = '" + hpvResult.Result + "' "
                                + "from tblHPVTestOrder psoh, tblPanelSetOrder pso "
                                + "where psoh.ReportNo = pso.ReportNo "
                                + "and pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "', "
                           + "[HoldDistribution] = 1, "
                           + "[Accepted] = 1, "
                           + "[AcceptedBy] = 'Optimus Prime', "
                           + "[AcceptedById] = 5134, "
                           + "[AcceptedDate] = '" + DateTime.Today.ToString("MM/dd/yyyy") + "', "
                           + "[AcceptedTime] = '" + DateTime.Now.ToString("MM/dd/yyyy HH:mm") + "' "
                           + "where PanelSetId = 14 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";
                }
                else if (overallInterpretation == "Invalid")
                {
                    hpvResult = new HPVInvalidResult();
                    sql       = @"Update tblHPVTestOrder set Result = '" + hpvResult.Result + "' "
                                + "from tblHPVTestOrder psoh, tblPanelSetOrder pso "
                                + "where psoh.ReportNo = pso.ReportNo "
                                + "and pso.OrderedOnId = '" + aliquotOrderId + "' and pso.Accepted = 0; ";

                    sql += @"Update tblPanelSetOrder set ResultCode = '" + hpvResult.ResultCode + "', "
                           + "[HoldDistribution] = 1 "
                           + "where PanelSetId = 14 and Accepted = 0 and OrderedOnId = '" + aliquotOrderId + "';";
                }
            }

            using (var cnx = new SqlConnection(connectionString))
            {
                using (var cmd = new SqlCommand(sql, cnx))
                {
                    await cnx.OpenAsync();

                    await cmd.ExecuteNonQueryAsync();
                }
            }

            return("Optimus Prime updated result: " + aliquotOrderId + " - " + testName + " on: " + DateTime.Now.ToString());
        }