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 async Task <string> XGTfill() { var dt = XGT; DataRow row; int nor = 0; dt.BeginLoadData(); sw.Start(); using (var response = grpcService.ClientCRUDs.XGTfill(new QryProxy { Query = "abc" })) { 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 async Task <string> BRfill(ulong M, string Mtyp, string Dtyp) { var dt = BR; DataRow row; int nor = 0; dt.BeginLoadData(); sw.Start(); using (var response = grpcService.ClientCRUDs.BRfill(new QryBRproxy { M = M, Mtyp = Mtyp, Dtyp = Dtyp })) { while (await response.ResponseStream.MoveNext(new CancellationToken())) { 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 string NNTupdate() { StringBuilder sb = new StringBuilder(); var dt = NNT; var request = new NNTproxy(); string rs = ""; // Unchanged disindakileri gonder, deleted disindakileri reply ile guncelle, hata yoksa her rec icin AcceptChanges for (int i = 0; i < dt.Rows.Count; i++) { // States: Added, Modified, Deletede, Unchanged rs = dt.Rows[i].RowState.ToString().Substring(0, 1); if (rs == "A" || rs == "M" || rs == "D") { dt.Rows[i].ClearErrors(); request.RowSte = rs; request.RowUsr = Program.ObjUsr; if (rs == "D") { request.RowKey = (ulong)dt.Rows[i]["RowKey", DataRowVersion.Original]; } else { ProxyHelper.RowToProxy(dt, dt.Rows[i], request); } var reply = grpcService.ClientCRUDs.NNTupdate(request); // ---------> if (string.IsNullOrEmpty(reply.RowErr)) { if (rs != "D") { ProxyHelper.ProxyToRow(dt, dt.Rows[i], reply); } dt.Rows[i].AcceptChanges(); } else { dt.Rows[i].RowError = reply.RowErr; sb.AppendLine(reply.RowErr); //dt.Rows[i].RejectChanges(); ProxyHelper.ProxyToRow(dt, dt.Rows[i], reply); dt.Rows[i].AcceptChanges(); } } } return(sb.ToString()); }
async Task TestTblaFill() { //Dynamically create Table from class. //Not fullfil our requirements. Table structure should be created at design time //to use in Controls. Create maunally now. //var aaaa = CreateDataTable<TblaRec>(); //dataSet1.Tables.Add(aaaa); var dt = dataSet1.Tables[0]; //if (dt.Rows[0].RowState == DataRowState. dt.BeginLoadData(); int nor = 0, ml = 0; Channel channel = new Channel($"127.0.0.1:50051", ChannelCredentials.Insecure); //Channel channel = new Channel($"217.160.13.102:50051", ChannelCredentials.Insecure); var client = new CRUDs.CRUDsClient(channel); CancellationToken token = new CancellationToken(); DataRow row; Stopwatch sw = new Stopwatch(); sw.Start(); using (var response = client.TblaFill(new QryProxy { Query = "abc" })) { while (await response.ResponseStream.MoveNext(token)) { //var proxy = response.ResponseStream.Current; row = dt.NewRow(); ProxyHelper.ProxyToRow(dt, row, response.ResponseStream.Current); dt.Rows.Add(row); nor++; //ml += proxy.CalculateSize(); //MessageBox.Show(rec.Message); } } sw.Stop(); dt.AcceptChanges(); dt.EndLoadData(); MessageBox.Show($"Time elapsed: {nor:n0}recs {sw.ElapsedMilliseconds:n0}ms {nor / sw.ElapsedMilliseconds}recs/ms TotalSize:{ml:n0}"); }
private void button4_Click(object sender, EventArgs e) { var dt = dataSet1.Tables[1]; string rs = ""; Channel channel = new Channel($"127.0.0.1:50051", ChannelCredentials.Insecure); //Channel channel = new Channel($"217.160.13.102:50051", ChannelCredentials.Insecure); var client = new CRUDs.CRUDsClient(channel); var request = new AHPproxy(); // Unchanged disindakileri gonder, deleted disindakileri reply ile guncelle, hata yoksa her rec icin AcceptChanges for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i].ClearErrors(); // States: Added, Modified, Deletede, Unchanged rs = dt.Rows[i].RowState.ToString().Substring(0, 1); if (rs == "A" || rs == "M") { request.RowSte = rs; ProxyHelper.RowToProxy(dt, dt.Rows[i], request); var reply = client.AHPupdate(request); if (string.IsNullOrEmpty(reply.RowErr)) { ProxyHelper.ProxyToRow(dt, dt.Rows[i], reply); dt.Rows[i].AcceptChanges(); } else { dt.Rows[i].RowError = reply.RowErr; dt.Rows[i].RejectChanges(); } } } channel.ShutdownAsync().Wait(); }