public static void Build(APIResult apiResult, PanelSetOrderCPTCodeBillCollection panelSetOrderCPTCodeBillCollection)
 {
     for (int i = 0; i < apiResult.JSONResult["result"]["results"].Count(); i++)
     {
         PanelSetOrderCPTCodeBill panelSetOrderCPTCodeBill = new PanelSetOrderCPTCodeBill();
         panelSetOrderCPTCodeBill.FromSql((JObject)apiResult.JSONResult["result"]["results"][i]);
         panelSetOrderCPTCodeBillCollection.Add(panelSetOrderCPTCodeBill);
     }
 }
 private void ListViewBilledCases_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     if (this.ListViewBilledCases.SelectedItems.Count != 0)
     {
         BillingLog billingLog = (BillingLog)this.ListViewBilledCases.SelectedItem;
         this.m_PanelSetOrderCPTCodeBillCollection = PanelSetOrderCPTCodeBillCollection.GetChargesByReportNo(billingLog.ReportNo);
         this.NotifyPropertyChanged(string.Empty);
     }
 }
        public static PanelSetOrderCPTCodeBillCollection GetChargesByReportNo(string reportNo)
        {
            string    commandText = $"Select * from tblPanelSetOrderCPTCodeBill where reportNo = '{reportNo}';";
            JObject   request     = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText);
            APIResult apiResult   = APIRequestHelper.SubmitAPIRequestMessage(request);
            PanelSetOrderCPTCodeBillCollection panelSetOrderCPTCodeBillCollection = new PanelSetOrderCPTCodeBillCollection();

            Build(apiResult, panelSetOrderCPTCodeBillCollection);
            return(panelSetOrderCPTCodeBillCollection);
        }