Exemplo n.º 1
0
 private void Refresh_Click(object sender, EventArgs e)
 {
     showProgress(true);
     //Task<RefreshDataCT> task = null;
     new Thread((ThreadStart)(() =>
     {
         try
         {
             using (NmdWSAdapter nmdWS = new NmdWSAdapter(this))
                 using (dbHelper = new NmdMobileDBAdapter(this))
                 {
                     dbHelper.OpenOrCreateDatabase(dbHelper.DBNamaad);//ToDo: We should create a preference UI which will write to XML resource file to read DBNamaad name.
                     ((SharedEnviroment)ApplicationContext).DbNameServer = ((SharedEnviroment)ApplicationContext).DbNameClient = dbHelper.DBNamaad;
                     DataTable dt = null;
                     using (dt = dbHelper.ExecuteSQL("Select Cast(1 As int) As SystemCode, Cast(1 As int) As TableCode ,'WebTableName' As TableName"))
                     {
                         nmdWS.RefreshWsCall(dt, 0).Wait();//task.Wait();//For Throwing exception, otherwise next line will be executed in case of exception.
                         if (dbHelper.Exist("WebTableCode"))
                         {
                             dt = dbHelper.ExecuteSQL("Select * From WebTableCode Where SystemCode=1 And TableCode>1 And TableCode<1000 ");
                             nmdWS.RefreshWsCall(dt, 0).Wait();//task.Wait();
                         }
                     }
                 }
         }
         catch (AggregateException ae)
         {
             ExceptionHandler.logDActivity(ae.ToString(), _logging, TAG);
             RunOnUiThread(() =>
             {
                 ExceptionHandler.toastAggregateException(this, ae);
             });
         }
         catch (Exception ex)
         {
             ExceptionHandler.logDActivity(ex.ToString(), _logging, TAG);
             RunOnUiThread(() =>
             {
                 ExceptionHandler.toastMsg(this, ex.Message);
             });
         }
         finally
         {
             RunOnUiThread(() =>
             {
                 showProgress(false);
             });
         }
     }
                              ))
     {
         IsBackground = true
     }.Start();
 }
 private void btnRef_Click(object sender, EventArgs e)
 {
     showProgress(true);
     new Thread((ThreadStart)(() =>
     {
         int size = listView.Count;
         StringBuilder strTableCode = null;
         for (int i = 0; i < size; i++)
         {
             if (listView.IsItemChecked(i))
             {
                 var t = tableDesc[i];
                 if (strTableCode != null)
                 {
                     strTableCode.Append(",");
                 }
                 else if (strTableCode == null)
                 {
                     strTableCode = new StringBuilder();
                 }
                 strTableCode.Append(t.TableCode);
             }
         }
         try
         {
             using (NmdWSAdapter nmdWS = new NmdWSAdapter(this))
                 using (dbHelper = new NmdMobileDBAdapter(this))
                 {
                     dbHelper.OpenOrCreateDatabase(dbHelper.DBNamaad);
                     using (DataTable dt = dbHelper.ExecuteSQL("Select * From WebTableCode Where OrgID=" + ((SharedEnviroment)ApplicationContext).OrgID + " And SystemCode=" + ((SharedEnviroment)ApplicationContext).SystemCode + " And TableCode in(" + strTableCode.ToString() + ")"))
                     {
                         var task = nmdWS.RefreshWsCall(dt, 0);
                         task.Wait();
                     }
                 }
         }
         catch (AggregateException ae)
         {
             ExceptionHandler.logDActivity(ae.ToString(), ((SharedEnviroment)ApplicationContext).Logging, ((SharedEnviroment)ApplicationContext).TAG);
             RunOnUiThread(() =>
             {
                 ExceptionHandler.toastAggregateException(this, ae);
             });
         }
         catch (Exception ex)
         {
             ExceptionHandler.logDActivity(ex.ToString(), ((SharedEnviroment)ApplicationContext).Logging, ((SharedEnviroment)ApplicationContext).TAG);
             RunOnUiThread(() =>
             {
                 ExceptionHandler.toastMsg(this, ex.Message);
             });
         }
         finally
         {
             RunOnUiThread(() =>
             {
                 showProgress(false);
             });
         }
     }))
     {
         IsBackground = true
     }.Start();
 }