public override Task <CETProxy> CETUpdate(CETProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A") { CET row = CRUDsHelper.FromProxy <CETProxy, CET>(request); request = CRUDsHelper.ToProxy <CETProxy, CET>(row); } else if (request.RowSte == "M") { CET row = CRUDsHelper.FromProxy <CETProxy, CET>(request); H.CET_RefreshSonuc(row); request = CRUDsHelper.ToProxy <CETProxy, CET>(row); H.CT_RefreshSonuc(row.CC); } else if (request.RowSte == "D") { var row = (CET)Db.FromId(request.RowKey); if (row == null) { request.RowErr = "CET Rec not found"; } else { var mac = Db.SQL <MAC>("select r from MAC r where r.CEB = ?", row).FirstOrDefault(); if (mac != null) { request.RowErr = $"Maçları var, Silemezsiniz"; } else { row.Delete(); } } } }); }).Wait(); Session.RunTaskForAll((s, id) => { s.CalculatePatchAndPushOnWebSocket(); }); return(Task.FromResult(request)); }
public string CETUpdate() { StringBuilder sb = new StringBuilder(); var dt = CET; var request = new CETProxy(); 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.CETUpdate(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()); }
// Team Events public override async Task CETFill(QryProxy request, IServerStreamWriter <CETProxy> responseStream, ServerCallContext context) { CETProxy proxy = new CETProxy(); List <CETProxy> proxyList = new List <CETProxy>(); Type proxyType = typeof(CETProxy); PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray(); await Scheduling.RunTask(() => { IEnumerable <CET> rows = null; if (request.Query == "CC") { rows = Db.SQL <CET>("select r from CET r where r.CC.ObjectNo = ?", ulong.Parse(request.Param)); } else if (request.Query == "DD") { rows = Db.SQL <CET>("select r from CET r where r.CC.Dnm = ?", int.Parse(request.Param)); } else { rows = Db.SQL <CET>("select r from CET r"); } foreach (var row in rows) { proxy = CRUDsHelper.ToProxy <CETProxy, CET>(row); proxyList.Add(proxy); } }); foreach (var p in proxyList) { await responseStream.WriteAsync(p); } }