public async Task <string> XDKfill(QryProxy qp) // DovizKurlari { var dt = XDK; DataRow row; int nor = 0; dt.BeginLoadData(); sw.Start(); //QryProxy qp = new QryProxy(); //qp.Query = "Trh"; //qp.Param = DateTime.Today.Ticks.ToString(); using (var response = grpcService.ClientCRUDs.XDKfill(qp)) { while (await response.ResponseStream.MoveNext(new CancellationToken())) { //var proxy = response.ResponseStream.Current; row = dt.NewRow(); ProxyHelper.ProxyToRow(dt, row, response.ResponseStream.Current); dt.Rows.Add(row); nor++; } } sw.Stop(); dt.AcceptChanges(); dt.EndLoadData(); return($"{nor:n0} records retrieved in {sw.ElapsedMilliseconds:n0} ms"); }
public override async Task TblaFill(QryProxy request, IServerStreamWriter <TblaProxy> responseStream, ServerCallContext context) { var hr = new TblaProxy { RowPk = 1, FldStr = "Bir", FldDbl = 1.23, FldDcm = 2.34, FldDate = DateTime.Now.Ticks, FldInt = 1 }; /* * for (int i = 0; i < 1; i++) * { * await Scheduling.RunTask(() => * { * foreach (var r in Db.SQL<M2DB.TblA>("select r from TblA r")) * { * //hr.Message = r.Field1; * Task.Run(async () => * { * await responseStream.WriteAsync(hr); * }).Wait(); * } * }); * } */ for (int i = 0; i < 100000; i++) { hr.RowPk = (ulong)i; await responseStream.WriteAsync(hr); } }
// Ferdi Events public override async Task CEFFill(QryProxy request, IServerStreamWriter <CEFProxy> responseStream, ServerCallContext context) { CEFProxy proxy = new CEFProxy(); List <CEFProxy> proxyList = new List <CEFProxy>(); Type proxyType = typeof(CEFProxy); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); await Scheduling.RunTask(() => { IEnumerable <CEF> rows = null; if (request.Query == "CC") { rows = Db.SQL <CEF>("select r from CEF r where r.CC.ObjectNo = ?", ulong.Parse(request.Param)); } else { rows = Db.SQL <CEF>("select r from CEF r"); } foreach (var row in rows) { proxy = CRUDsHelper.ToProxy <CEFProxy, CEF>(row); proxyList.Add(proxy); } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }
public async Task TblaFill3(QryProxy request, IServerStreamWriter <TblaProxy> responseStream, ServerCallContext context) { var proxy = new TblaProxy(); proxy.RowPk = 1; List <TblaProxy> pl = new List <TblaProxy>(); // Transfer 14K proxy/sec await Scheduling.RunTask(() => { for (int i = 0; i < 1000; i++) { foreach (var row in Db.SQL <M2DB.TblB>("select r from TblB r")) { //proxy = ReflectionExample.ToProxy<TblaProxy, M2DB.TblB>(row); proxy.FldStr = row.FldStr; proxy.FldInt = row.FldInt; proxy.FldDbl = row.FldDbl; proxy.FldDcm = Convert.ToDouble(row.FldDcm); pl.Add(proxy); //Task.Run(async () => //{ // await responseStream.WriteAsync(proxy); //}).Wait(); } } }); foreach (var p in pl) { await responseStream.WriteAsync(p); } /* * // Transfer 9K proxy/sec * for (int i = 0; i < 1000; i++) * { * await Scheduling.RunTask(() => * { * foreach (var row in Db.SQL<M2DB.TblB>("select r from TblB r")) * { * proxy = ReflectionExample.ToProxy<TblaProxy, M2DB.TblB>(row); * * Task.Run(async () => * { * await responseStream.WriteAsync(proxy); * }).Wait(); * } * }); * } */ /* * // Transfer 20K proxy/sec * for (int i = 0; i < 100000; i++) * { * await responseStream.WriteAsync(proxy); * }*/ }
// Team Players public override async Task CTPFill(QryProxy request, IServerStreamWriter <CTPProxy> responseStream, ServerCallContext context) { CTPProxy proxy = new CTPProxy(); List <CTPProxy> proxyList = new List <CTPProxy>(); Type proxyType = typeof(CTPProxy); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); await Scheduling.RunTask(() => { IEnumerable <CTP> rows = null; if (request.Query == "CT") { rows = Db.SQL <CTP>("select r from CTP r where r.CT.ObjectNo = ?", ulong.Parse(request.Param)); } else { rows = Db.SQL <CTP>("select r from CTP r "); } foreach (var row in rows) { proxy = CRUDsHelper.ToProxy <CTPProxy, CTP>(row); /* * proxy = new CTProxy * { * RowKey = row.GetObjectNo(), * CC = row.CC == null ? 0 : row.CC.GetObjectNo(), * K1 = row.K1 == null ? 0 : row.K1.GetObjectNo(), * K2 = row.K2 == null ? 0 : row.K1.GetObjectNo(), * * Ad = row.Ad, * Adres = row.Adres ?? "", * Info = row.Info ?? "", * NG = row.NG, * NM = row.NM, * NB = row.NB, * NT = row.NT, * NX = row.NX, * KA = row.KA, * KV = row.KV, * KF = row.KF, * PW = row.PW, * * IsRun = row.IsRun, * }; */ proxyList.Add(proxy); } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }
// Players public override async Task PPFill(QryProxy request, IServerStreamWriter <PPProxy> responseStream, ServerCallContext context) { PPProxy proxy = new PPProxy(); List <PPProxy> proxyList = new List <PPProxy>(); Type proxyType = typeof(PPProxy); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); await Scheduling.RunTask(() => { foreach (var row in Db.SQL <PP>("select r from PP r")) { //proxy = ReflectionExample.ToProxy<AHPproxy, AHP>(row); proxy = CRUDsHelper.ToProxy <PPProxy, PP>(row); /* * proxy = new PPProxy * { * RowKey = row.GetObjectNo(), * Ad = row.Ad, * Sex = row.Sex ?? "", * Tel = row.Tel ?? "", * Info = row.Info ?? "", * IsRun = row.IsRun, * * RnkIlk = row.RnkBaz, * RnkBaz = row.RnkBaz, * RnkSon = row.RnkSon, * RnkIdx = row.RnkIdx, * * SST = row.SST, * SSW = row.SSW, * SSL = row.SSL, * SMT = row.SMT, * SMW = row.SMW, * SML = row.SML, * DST = row.DST, * DSW = row.DSW, * DSL = row.DSL, * DMT = row.DMT, * DMW = row.DMW, * DML = row.DML, * * }; */ proxyList.Add(proxy); } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }
private void FillDB() { string res = ""; xdkGridControl.DataSource = null; dataSetGnl.XDK.Rows.Clear(); gridView1.OptionsBehavior.ReadOnly = false; QryProxy qp = new QryProxy(); qp.Query = "Trh"; qp.Param = dateEdit1.DateTime.Ticks.ToString(); if (qp.Param == "0") { qp.Query = ""; gridView1.OptionsBehavior.ReadOnly = true; } Task.Run(async() => { res = await dataSetGnl.XDKfill(qp); }).Wait(); toolStripStatusLabel1.Text = res; xdkGridControl.DataSource = xdkBindingSource; }
// Lookuo Players public override async Task PPlookUp(QryProxy request, IServerStreamWriter <PPlookUpProxy> responseStream, ServerCallContext context) { PPlookUpProxy proxy = new PPlookUpProxy(); List <PPlookUpProxy> proxyList = new List <PPlookUpProxy>(); Type proxyType = typeof(PPlookUpProxy); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); await Scheduling.RunTask(() => { foreach (var row in Db.SQL <PP>("select r from PP r")) { proxy = new PPlookUpProxy { RowKey = row.GetObjectNo(), Ad = row.Ad, Sex = row.Sex ?? "", IsRun = row.IsRun, }; if (proxy.IsRun) { foreach (var ctp in Db.SQL <CTP>("select r from CTP r where r.PP = ?", row)) { if (ctp.IsRun) { proxy.CTs += $"<{ctp.CT.GetObjectNo()}>"; } } } proxyList.Add(proxy); } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }
// Donemler public override async Task DDFill(QryProxy request, IServerStreamWriter <DDProxy> responseStream, ServerCallContext context) { DDProxy proxy = new DDProxy(); List <DDProxy> proxyList = new List <DDProxy>(); Type proxyType = typeof(DDProxy); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); await Scheduling.RunTask(() => { foreach (var row in Db.SQL <DD>("select r from DD r")) { proxy = CRUDsHelper.ToProxy <DDProxy, DD>(row); proxyList.Add(proxy); } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }
private void AbdXF_Load(object sender, EventArgs e) { ObjABM = ABMRow.RowKey; if (readOnly) { gridView1.OptionsBehavior.ReadOnly = true; abdBindingNavigator.Enabled = !readOnly; Text += " Kapalı"; } QryProxy qp = new QryProxy { Query = "Trh", Param = ABMRow.Trh.Ticks.ToString(), }; Task.Run(async() => { await dataSetGnl.XDKfill(qp); }).Wait(); DataRow[] xdkRows = dataSetGnl.XDK.Select("Dvz = 'TRL'"); ObjDvzTRL = xdkRows[0]["DVT"]; FillDB(); }
public async Task TblaFill2(QryProxy request, IServerStreamWriter <TblaProxy> responseStream, ServerCallContext context) { var proxy = new TblaProxy(); proxy.RowPk = 1; await Scheduling.RunTask(() => { for (int i = 0; i < 1000; i++) { Task.Run(async() => { foreach (var row in Db.SQL <M2DB.TblB>("select r from TblB r")) { proxy = ReflectionExample.ToProxy <TblaProxy, M2DB.TblB>(row); await responseStream.WriteAsync(proxy); } }).Wait(); //await responseStream.WriteAsync(proxy); } }); }
public override async Task TblaFill(QryProxy request, IServerStreamWriter <TblaProxy> responseStream, ServerCallContext context) { int kxx = 1; var proxy = new TblaProxy(); proxy.RowPk = 1; List <TblaProxy> pl = new List <TblaProxy>(); Type proxyType = typeof(TblaProxy); Type senert = typeof(M2DB.TblB); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); PropertyInfo[] sener = senert.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); /* * Dictionary<int, int> dic = new Dictionary<int, int>(); * for (int j = 0; j < proxyProperties.Length; j++) * { * Console.WriteLine(kxx.ToString()); * for (int k = 0; k < sener.Length; k++) * { * Console.WriteLine($"{j},{k} : {proxyProperties[j].Name} {sener[k].Name}"); * if (proxyProperties[j].Name == sener[k].Name) * { * dic[j] = k; * break; * } * } * } * Console.WriteLine(kxx.ToString()); */ await Scheduling.RunTask(() => { for (int i = 0; i < 1000; i++) { foreach (var row in Db.SQL <M2DB.TblB>("select r from TblB r")) { //proxy = ReflectionExample.ToProxy<TblaProxy, M2DB.TblB>(row); proxy = new TblaProxy { RowPk = row.GetObjectNo(), FldStr = row.FldStr, FldInt = row.FldInt, FldDbl = row.FldDbl, FldDcm = Convert.ToDouble(row.FldDcm), FldDate = ((DateTime)row.FldDate).Ticks, }; /* * foreach(var d in dic) * { * object value = sener[d.Value].GetValue(row); * value = ReflectionExample.ConvertToProxyValue(sener[d.Value].PropertyType, value); * proxyProperties[d.Key].SetValue(proxy, value); * } * /* * foreach (PropertyInfo proxyProperty in proxyProperties) * { * //PropertyInfo databaseProperty = databaseProperties.FirstOrDefault(x => x.Name == proxyProperty.Name); * // Which one is efficient? Both are same * var dbP = row.GetType().GetProperty(proxyProperty.Name); //?.GetValue(row); * var sss = sener[0].GetValue(row); * if (dbP != null) * { * object value = dbP.GetValue(row); * * value = ReflectionExample.ConvertToProxyValue(dbP.PropertyType, value); * proxyProperty.SetValue(proxy, value); * } * } */ pl.Add(proxy); //Task.Run(async () => //{ // await responseStream.WriteAsync(proxy); //}).Wait(); } } }); foreach (var p in pl) { await responseStream.WriteAsync(p); } /* * // Transfer 9K proxy/sec * for (int i = 0; i < 1000; i++) * { * await Scheduling.RunTask(() => * { * foreach (var row in Db.SQL<M2DB.TblB>("select r from TblB r")) * { * proxy = ReflectionExample.ToProxy<TblaProxy, M2DB.TblB>(row); * * Task.Run(async () => * { * await responseStream.WriteAsync(proxy); * }).Wait(); * } * }); * } */ /* * // Transfer 20K proxy/sec * for (int i = 0; i < 100000; i++) * { * await responseStream.WriteAsync(proxy); * }*/ }
// Maclar public override async Task MACFill(QryProxy request, IServerStreamWriter <MACProxy> responseStream, ServerCallContext context) { MACProxy proxy = new MACProxy(); List <MACProxy> proxyList = new List <MACProxy>(); Type proxyType = typeof(MACProxy); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); await Scheduling.RunTask(() => { IEnumerable <MAC> rows = null;// = Db.SQL<MAC>("select r from MAC r"); if (request.Query == "CET") { rows = Db.SQL <MAC>("select r from MAC r where r.CEB.ObjectNo = ?", ulong.Parse(request.Param)); } else if (request.Query == "CEF") { rows = Db.SQL <MAC>("select r from MAC r where r.CEB.ObjectNo = ?", ulong.Parse(request.Param)); } else if (request.Query == "CC") { rows = Db.SQL <MAC>("select r from MAC r where r.CC.ObjectNo = ?", ulong.Parse(request.Param)); } else if (request.Query == "PP") { ulong pp = ulong.Parse(request.Param); rows = Db.SQL <MAC>("select r from MAC r where r.HPP1.ObjectNo = ? or r.HPP2.ObjectNo = ? or r.GPP1.ObjectNo = ? or r.GPP2.ObjectNo = ?", pp, pp, pp, pp); } else { rows = Db.SQL <MAC>("select r from MAC r "); } foreach (var row in rows) { //proxy = ReflectionExample.ToProxy<AHPproxy, AHP>(row); proxy = CRUDsHelper.ToProxy <MACProxy, MAC>(row); /* * proxy = new CTProxy * { * RowKey = row.GetObjectNo(), * CC = row.CC == null ? 0 : row.CC.GetObjectNo(), * K1 = row.K1 == null ? 0 : row.K1.GetObjectNo(), * K2 = row.K2 == null ? 0 : row.K1.GetObjectNo(), * * Ad = row.Ad, * Adres = row.Adres ?? "", * Info = row.Info ?? "", * NG = row.NG, * NM = row.NM, * NB = row.NB, * NT = row.NT, * NX = row.NX, * KA = row.KA, * KV = row.KV, * KF = row.KF, * PW = row.PW, * * IsRun = row.IsRun, * }; */ proxyList.Add(proxy); } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }