// Competitions public override async Task CCFill(QryProxy request, IServerStreamWriter <CCProxy> responseStream, ServerCallContext context) { CCProxy proxy = new CCProxy(); List <CCProxy> proxyList = new List <CCProxy>(); Type proxyType = typeof(CCProxy); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); await Scheduling.RunTask(() => { IEnumerable <CC> rows = null; if (request.Query == "DD") { rows = Db.SQL <CC>("SELECT r FROM CC r WHERE r.Dnm = ?", int.Parse(request.Param)); } else { rows = Db.SQL <CC>("select r from CC r"); } foreach (var row in rows) { proxy = CRUDsHelper.ToProxy <CCProxy, CC>(row); proxyList.Add(proxy); } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }
public string CCUpdate() { StringBuilder sb = new StringBuilder(); var dt = CC; var request = new CCProxy(); 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.CCUpdate(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(); } } } return(sb.ToString()); }
public override Task <CCProxy> CCUpdate(CCProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A" || request.RowSte == "M") { if (request.RowErr == string.Empty) { CC row = CRUDsHelper.FromProxy <CCProxy, CC>(request); //XUT.Append(request.RowUsr, row, request.RowSte); request = CRUDsHelper.ToProxy <CCProxy, CC>(row); } } else if (request.RowSte == "D") { var row = (CC)Db.FromId(request.RowKey); if (row == null) { request.RowErr = "CC Rec not found"; } else { request.RowErr = $"Silemezsiniz"; } } }); }).Wait(); Session.RunTaskForAll((s, id) => { s.CalculatePatchAndPushOnWebSocket(); }); return(Task.FromResult(request)); }