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