Dim req As DBRequestManager = CreateRequest
For Each item() As Object In list_isp
Dim mastersim As Object = item
Dim sim_absent_day As String 'hoeveel data wat weg is dag
Dim sim_absent_night As String ' hoeveel data weg is nag
Dim sim_booked_day As String ' hoeveel data verkoop is dag
Dim sim_bookee_night As String ' hoeveel data verkoop is nag
Dim sim_used_day As String ' hoeveel data verbruik is dag
Dim sim_used_night As String ' hoeveel data vewrbruik is nag
Dim sim_total_data_day As String ' kontrak data op hoofsim dag
Dim sim_total_data_night As String ' kontrak data op hoofsim nag
sim_booked_day = 0
sim_bookee_night = 0
sim_used_day = 0
sim_used_night = 0
Dim req As DBRequestManager = CreateRequest
Dim cmd As DBCommand = CreateCommand("device_search",Array("%%","%%","%%","%%","%"&mastersim&"%"))
Wait For (req.ExecuteQuery(cmd, 0, Null)) JobDone(j As HttpJob)
If j.Success Then
req.HandleJobAsync(j, "req")
Wait For (req) req_Result(res As DBResult)
'work with result
req.PrintTable(res)
If res.Rows.Size > 0 Then
For Each row() As Object In res.Rows
If (row(res.Columns.Get("cutdate"))) > (DateTime.Date(DateTime.Now)) Then
''''''kry plan data waar op device is
data_layout_tv_plans.SelectedRow = list_plans.IndexOf(row(res.Columns.Get("plan")))
Dim plandag As String = (data_layout_tv_plans.SelectedRowValues(1))
Dim plannag As String = (data_layout_tv_plans.SelectedRowValues(2))
'''''''werk uit hoeveel verkoop data oor is.
sim_booked_day = sim_booked_day + plandag
sim_bookee_night = sim_bookee_night + plannag
''''''werk uit hoeveel data oor is op device
Dim dayleft As Long = ((row(res.Columns.Get("cutdataday"))-row(res.Columns.Get("mtotalday")))/1000000)
Dim nightleft As Long = ((row(res.Columns.Get("cutdatanight"))-row(res.Columns.Get("mtotalnight")))/1000000)
'''''werk used op master sim uit
sim_used_day = sim_used_day + (plandag - dayleft)
sim_used_night = sim_used_night + (plannag-nightleft)
End If
Next
'''''werk uit data weg op master sim
sim_total_data_day = list_plan_size_day.Get(list_isp.IndexOf(mastersim))
sim_total_data_night = list_plan_size_day.Get(list_isp.IndexOf(mastersim))
sim_absent_day = sim_total_data_day - list_plan_data_day_left.Get(list_isp.IndexOf(mastersim)) - sim_used_day
sim_absent_night = sim_total_data_night - list_plan_data_night_left.Get(list_isp.IndexOf(mastersim)) - sim_used_night
'''table view begin wys
Dim row1() As Object = Array (mastersim,(list_sim_update_last.Get(list_isp.IndexOf(mastersim))),sim_total_data_day,sim_total_data_night,list_plan_data_day_left.Get(list_isp.IndexOf(mastersim)),list_plan_data_night_left.Get(list_isp.IndexOf(mastersim)),sim_absent_day,sim_absent_night,sim_booked_day,sim_bookee_night,sim_used_day,sim_used_night)
data_layout_tv_sims.Items.Add(row1)
End If
End If
Next
j.Release