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();
}