public string MACUpdate() { StringBuilder sb = new StringBuilder(); var dt = MAC; var request = new MACProxy(); 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.MACUpdate(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 <MACProxy> MACUpdate(MACProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A" || request.RowSte == "M") { if (request.RowErr == string.Empty) { MAC row = CRUDsHelper.FromProxy <MACProxy, MAC>(request); H.MAC_RefreshSonuc(row); request = CRUDsHelper.ToProxy <MACProxy, MAC>(row); } } else if (request.RowSte == "D") { var row = (MAC)Db.FromId(request.RowKey); if (row == null) { request.RowErr = "MAC Rec not found"; } else { row.Delete(); } } }); }).Wait(); Session.RunTaskForAll((s, id) => { s.CalculatePatchAndPushOnWebSocket(); }); return(Task.FromResult(request)); }
// 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); } }