public System.IAsyncResult BeginRefreshData(RefreshDataCT composite, System.AsyncCallback callback, object asyncState) { object[] _args = new object[1]; _args[0] = composite; System.IAsyncResult _result = base.BeginInvoke("RefreshData", _args, callback, asyncState); return(_result); }
public RefreshDataCT EndRefreshData(System.IAsyncResult result) { object[] _args = new object[0]; RefreshDataCT _result = ((RefreshDataCT)(base.EndInvoke("RefreshData", _args, result))); return(_result); }
private void ReciveGetData(RefreshDataCT ct) { string sqlString = null; if (ct.HasCreateTable) { dbHelper.DropTable(ct.TableName); if (ct.QueryCreateTable != "") { sqlString = ct.QueryCreateTable.Replace("@" + ct.TableName, ct.TableName); dbHelper.ExecuteNonQuery(sqlString); } } if (ct.QueryBeforeExec1 != "") { sqlString = ct.QueryBeforeExec1.Replace("@" + ct.TableName, ct.TableName); dbHelper.ExecuteNonQuery(sqlString); } if (ct.QueryBeforeExec2 != "") { sqlString = ct.QueryBeforeExec2.Replace("@" + ct.TableName, ct.TableName); dbHelper.ExecuteNonQuery(sqlString); } dbHelper.DropTable("Tmp" + ct.TableName); using (DataTable dt = ToDataTable(ct.DataTableArray)) if (dt.Rows.Count > 0) { string destTableName = ct.TableName; if (ct.IsCreateTmpTable) { destTableName = "Tmp" + destTableName; sqlString = ct.QueryCreateTable.Replace("@" + ct.TableName, destTableName); dbHelper.ExecuteNonQuery(sqlString); } dbHelper.BeginTransaction(); dbHelper.CopyToDB(dt, destTableName, ct.TableName, ct.DeleteKey); dbHelper.EndTransaction(); if (ct.QueryAfterExec1 != "") { sqlString = ct.QueryAfterExec1.Replace("@" + ct.TableName, ct.TableName); //sqlString = sqlString.Replace( "\r\n", " "); dbHelper.ExecuteNonQuery(sqlString); } if (ct.QueryAfterExec2 != "") { sqlString = ct.QueryAfterExec2.Replace("@" + ct.TableName, ct.TableName); dbHelper.ExecuteNonQuery(sqlString); } if (ct.QueryAfterExec3 != "") { sqlString = ct.QueryAfterExec3.Replace("@" + ct.TableName, ct.TableName); dbHelper.ExecuteNonQuery(sqlString); } } dbHelper.DropTable("Tmp" + ct.TableName); }
private object[] OnEndRefreshData(System.IAsyncResult result) { RefreshDataCT retVal = ((IService)(this)).EndRefreshData(result); return(new object[] { retVal }); }
/// <summary> /// Refreshes the Sync ws call /// </summary> /// <param name="dt">The dt.</param> /// <param name="userCode">The user code.</param> /// <returns></returns> public async Task RefreshWsCall(DataTable dt, int userCode)//DBNameNamaad=DBNamaad { //Task<RefreshDataCT> res = null; RefreshDataCT res = null; if (dt.Rows.Count == 0) { return; } if (dbHelper == null) { dbHelper = new NmdMobileDBAdapter(mCtx); if (int.Parse(dt.Rows[0]["SystemCode"].ToString()) == 1) { dbHelper.OpenOrCreateDatabase(((SharedEnviroment)mCtx.ApplicationContext).DbNameClient); } else { dbHelper.OpenOrCreateDatabase(((SharedEnviroment)mCtx.ApplicationContext).ActionArgument); } flagCon = true; } InitializeHelloWorldServiceClient(); RefreshDataCT ct = new RefreshDataCT(); using (dt) { foreach (DataRow row in dt.Rows) { ct.SystemCode = int.Parse(row["SystemCode"].ToString()); ct.TableCode = int.Parse(row["TableCode"].ToString()); ct.TableName = (string)row["tableName"]; ct.TableDataVersion = 0; if (ct.TableCode >= 1000 && dbHelper.Exist(ct.TableName)) { string s; if (!string.IsNullOrEmpty(s = dbHelper.ExecuteSQL("Select Max(TableDataVersion) As maxTableDataVersion From " + ct.TableName).Rows[0]["maxTableDataVersion"].ToString())) { ct.TableDataVersion = int.Parse(s); } } ct.UserCode = userCode; res = await Task <RefreshDataCT> .Factory.FromAsync(_client.BeginRefreshData, _client.EndRefreshData, ct, null); //res.Wait();//For Throwing exception, otherwise next line will be executed in case of exception. //ReciveGetData(res.Result); //ReciveGetData(_client.RefreshData(ct)); ReciveGetData(res); } } }
private void SetDbName(RefreshDataCT composite) { string StrSQL = ""; StrSQL = "Select * From WebActions Where CompanyCode=" + composite.CompanyCode + " And ActionCode=1"; //composite.StrDebug=GetConnectionString(); using (DataTable dtWebTableCode = NmdDBAdapter.ExecuteSQL(StrSQL)) { composite.DbNameServer = ((string)dtWebTableCode.Rows[0]["DbNameServer"]).Trim(); composite.DbNameClient = ((string)dtWebTableCode.Rows[0]["DbNameClient"]).Trim(); } }
private void GetDataRefresh(RefreshDataCT composite) { string StrSQL = ""; string DbNameServer = ""; string DbNameClient = ""; if (composite.TableCode > 1000) { DbNameServer = composite.DbNameServer + ".dbo."; DbNameClient = composite.DbNameClient + ".dbo."; } StrSQL = "Select * From " + DbNameServer + "WebTableCode Where CompanyCode=" + composite.CompanyCode + " And TableCode=" + composite.TableCode; //composite.StrDebug=GetConnectionString(); using (DataTable dtWebTableCode = NmdDBAdapter.ExecuteSQL(StrSQL)) { composite.TableName = ((string)dtWebTableCode.Rows[0]["TableName"]).Trim(); composite.HasCreateTable = false; if ((int)dtWebTableCode.Rows[0]["TableDataVersion"] > composite.TableDataVersion) { composite.TableDataVersion = 0; composite.HasCreateTable = true; } composite.QueryCreateTable = ((string)dtWebTableCode.Rows[0]["QueryCreateTable"]).Trim(); composite.QueryBeforeExec1 = ((string)dtWebTableCode.Rows[0]["QueryBeforeExec1"]).Trim(); composite.QueryBeforeExec2 = ((string)dtWebTableCode.Rows[0]["QueryBeforeExec2"]).Trim(); composite.QueryAfterExec1 = ((string)dtWebTableCode.Rows[0]["QueryAfterExec1"]).Trim(); composite.QueryAfterExec2 = ((string)dtWebTableCode.Rows[0]["QueryAfterExec2"]).Trim(); composite.QueryAfterExec3 = ((string)dtWebTableCode.Rows[0]["QueryAfterExec3"]).Trim(); composite.DeleteKey = ((string)dtWebTableCode.Rows[0]["DeleteKey"]).Trim(); composite.IsCreateTmpTable = (Int16)dtWebTableCode.Rows[0]["IsCreateTmpTable"]; StrSQL = ((string)dtWebTableCode.Rows[0]["QueryGetData"]).Replace("@TableDataVersion", composite.TableDataVersion.ToString()); if (composite.TableCode > 1000) { StrSQL = ((string)StrSQL).Replace("@DbNameServer.dbo.", DbNameClient); } else { StrSQL = ((string)StrSQL).Replace("@DbNameServer.dbo.", DbNameServer); } } //composite.Dt = ExecuteSQL(StrSQL); //composite.MS = ToMemStream(ExecuteSQL(StrSQL)); composite.DataTableArray = ToMemStream(NmdDBAdapter.ExecuteSQL(StrSQL)).ToArray(); }
public void RefreshDataAsync(RefreshDataCT composite, object userState) { if ((this.onBeginRefreshDataDelegate == null)) { this.onBeginRefreshDataDelegate = new BeginOperationDelegate(this.OnBeginRefreshData); } if ((this.onEndRefreshDataDelegate == null)) { this.onEndRefreshDataDelegate = new EndOperationDelegate(this.OnEndRefreshData); } if ((this.onRefreshDataCompletedDelegate == null)) { this.onRefreshDataCompletedDelegate = new System.Threading.SendOrPostCallback(this.OnRefreshDataCompleted); } base.InvokeAsync(this.onBeginRefreshDataDelegate, new object[] { composite }, this.onEndRefreshDataDelegate, this.onRefreshDataCompletedDelegate, userState); }
public RefreshDataCT RefreshData(RefreshDataCT composite) { if (composite == null) { throw new ArgumentNullException("RefreshDataCT Is Null"); } else if (string.IsNullOrWhiteSpace(composite.TableCode.ToString())) { throw new ArgumentException("TableCode IsNullOrWhiteSpace"); } try { SetDbName(composite); GetDataRefresh(composite); } catch (Exception eDB) { Console.WriteLine(eDB); Debug.WriteLine(eDB, TAG); } return(composite); }
public RefreshDataCT RefreshData(RefreshDataCT composite) { if (composite == null) throw new ArgumentNullException("RefreshDataCT Is Null"); else if (string.IsNullOrWhiteSpace(composite.TableCode.ToString())) throw new ArgumentException("TableCode IsNullOrWhiteSpace"); try { SetDbName(composite); GetDataRefresh(composite); } catch (Exception eDB) { Console.WriteLine(eDB); Debug.WriteLine(eDB, TAG); } return composite; }
private void GetDataRefresh(RefreshDataCT composite) { string StrSQL = ""; string DbNameServer = ""; string DbNameClient = ""; if (composite.TableCode > 1000) { DbNameServer = composite.DbNameServer + ".dbo."; DbNameClient = composite.DbNameClient + ".dbo."; } StrSQL = "Select * From " + DbNameServer + "WebTableCode Where CompanyCode=" + composite.CompanyCode + " And TableCode=" + composite.TableCode; //composite.StrDebug=GetConnectionString(); using (DataTable dtWebTableCode = NmdDBAdapter.ExecuteSQL(StrSQL)) { composite.TableName = ((string)dtWebTableCode.Rows[0]["TableName"]).Trim(); composite.HasCreateTable = false; if ((int)dtWebTableCode.Rows[0]["TableDataVersion"] > composite.TableDataVersion) { composite.TableDataVersion = 0; composite.HasCreateTable = true; } composite.QueryCreateTable = ((string)dtWebTableCode.Rows[0]["QueryCreateTable"]).Trim(); composite.QueryBeforeExec1 = ((string)dtWebTableCode.Rows[0]["QueryBeforeExec1"]).Trim(); composite.QueryBeforeExec2 = ((string)dtWebTableCode.Rows[0]["QueryBeforeExec2"]).Trim(); composite.QueryAfterExec1 = ((string)dtWebTableCode.Rows[0]["QueryAfterExec1"]).Trim(); composite.QueryAfterExec2 = ((string)dtWebTableCode.Rows[0]["QueryAfterExec2"]).Trim(); composite.QueryAfterExec3 = ((string)dtWebTableCode.Rows[0]["QueryAfterExec3"]).Trim(); composite.DeleteKey = ((string)dtWebTableCode.Rows[0]["DeleteKey"]).Trim(); composite.IsCreateTmpTable = (Int16)dtWebTableCode.Rows[0]["IsCreateTmpTable"]; StrSQL = ((string)dtWebTableCode.Rows[0]["QueryGetData"]).Replace("@TableDataVersion", composite.TableDataVersion.ToString()); if (composite.TableCode > 1000) StrSQL = ((string)StrSQL).Replace("@DbNameServer.dbo.", DbNameClient); else StrSQL = ((string)StrSQL).Replace("@DbNameServer.dbo.", DbNameServer); } //composite.Dt = ExecuteSQL(StrSQL); //composite.MS = ToMemStream(ExecuteSQL(StrSQL)); composite.DataTableArray = ToMemStream(NmdDBAdapter.ExecuteSQL(StrSQL)).ToArray(); }
public void RefreshDataAsync(RefreshDataCT composite) { this.RefreshDataAsync(composite, null); }
private System.IAsyncResult OnBeginRefreshData(object[] inValues, System.AsyncCallback callback, object asyncState) { RefreshDataCT composite = ((RefreshDataCT)(inValues[0])); return(((IService)(this)).BeginRefreshData(composite, callback, asyncState)); }
System.IAsyncResult IService.BeginRefreshData(RefreshDataCT composite, System.AsyncCallback callback, object asyncState) { return(base.Channel.BeginRefreshData(composite, callback, asyncState)); }