public override Task <PPRDProxy> PPRDUpdate(PPRDProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A") { PPRD row = CRUDsHelper.FromProxy <PPRDProxy, PPRD>(request); request = CRUDsHelper.ToProxy <PPRDProxy, PPRD>(row); } else if (request.RowSte == "M") { // Sadece IsFerdi degisebilir if (request.RowErr == string.Empty) { PPRD row = CRUDsHelper.FromProxy <PPRDProxy, PPRD>(request); request = CRUDsHelper.ToProxy <PPRDProxy, PPRD>(row); } } else if (request.RowSte == "D") { request.RowErr = "Silemezsiniz"; } }); }).Wait(); Session.RunTaskForAll((s, id) => { s.CalculatePatchAndPushOnWebSocket(); }); return(Task.FromResult(request)); }
public override Task <CTProxy> CTUpdate(CTProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A" || request.RowSte == "M") { if (request.RowErr == string.Empty) { CT row = CRUDsHelper.FromProxy <CTProxy, CT>(request); //XUT.Append(request.RowUsr, row, request.RowSte); request = CRUDsHelper.ToProxy <CTProxy, CT>(row); } } else if (request.RowSte == "D") { var row = Db.FromId(request.RowKey) as CT; if (row == null) { request.RowErr = "CT Rec not found"; } else { // CTP ve CET detaylari yoksa sil. var ctp = Db.SQL("select r from CTP r where r.CT = ?", row).FirstOrDefault(); if (ctp == null) { var cet = Db.SQL("select r from CET r where r.HCT = ? or r.GCT = ?", row, row).FirstOrDefault(); if (cet == null) { row.Delete(); } else { request.RowErr = $"Event var, Silemezsiniz"; } } else { request.RowErr = $"Oyuncuları var, Silemezsiniz"; } } } }); }).Wait(); Session.RunTaskForAll((s, id) => { s.CalculatePatchAndPushOnWebSocket(); }); return(Task.FromResult(request)); }
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 override Task <CEFProxy> CEFUpdate(CEFProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A" || request.RowSte == "M") { if (request.RowErr == string.Empty) { CEF row = CRUDsHelper.FromProxy <CEFProxy, CEF>(request); //XUT.Append(request.RowUsr, row, request.RowSte); request = CRUDsHelper.ToProxy <CEFProxy, CEF>(row); } } else if (request.RowSte == "D") { var row = (CEF)Db.FromId(request.RowKey); if (row == null) { request.RowErr = "CEF Rec not found"; } else { var mac = Db.SQL <MAC>("select r from MAC r where r.CEB.ObjectNo = ?", request.RowKey).FirstOrDefault(); if (mac != null) { request.RowErr = $"Maçı var, Silemezsiniz"; } else { row.Delete(); } } } }); }).Wait(); Session.RunTaskForAll((s, id) => { s.CalculatePatchAndPushOnWebSocket(); }); return(Task.FromResult(request)); }
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)); }
public override Task <CFProxy> CFUpdate(CFProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A" || request.RowSte == "M") { if (request.RowErr == string.Empty) { CF row = CRUDsHelper.FromProxy <CFProxy, CF>(request); //XUT.Append(request.RowUsr, row, request.RowSte); request = CRUDsHelper.ToProxy <CFProxy, CF>(row); } } else if (request.RowSte == "D") { var row = (CF)Db.FromId(request.RowKey); if (row == null) { request.RowErr = "CF Rec not found"; } else { request.RowErr = $"Silemezsiniz"; } } }); }).Wait(); Session.RunTaskForAll((s, id) => { s.CalculatePatchAndPushOnWebSocket(); }); return(Task.FromResult(request)); }
public override Task <DDProxy> DDUpdate(DDProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A" || request.RowSte == "M") { if (request.RowErr == string.Empty) { DD row = CRUDsHelper.FromProxy <DDProxy, DD>(request); request = CRUDsHelper.ToProxy <DDProxy, DD>(row); } } else if (request.RowSte == "D") { request.RowErr = $"Silemezsiniz!"; } }); }).Wait(); return(Task.FromResult(request)); }
public override Task <CTPProxy> CTPUpdate(CTPProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A") { CTP row = CRUDsHelper.FromProxy <CTPProxy, CTP>(request); H.PPRD_TryInsert(row.PP, row.CC.Dnm); request = CRUDsHelper.ToProxy <CTPProxy, CTP>(row); } else if (request.RowSte == "M") { // CC ve PP degistirilemez var oRow = (CTP)Db.FromId(request.RowKey); if (oRow.PP.GetObjectNo() != request.PP) { request.RowErr = "Oyuncu değiştiremezsiniz. Silip yenisini girin."; } else if (oRow.CC.GetObjectNo() != request.CC) { request.RowErr = "Turnuva değiştiremezsiniz. Silip yenisini girin."; } if (request.RowErr == string.Empty) { CTP row = CRUDsHelper.FromProxy <CTPProxy, CTP>(request); H.PPRD_TryInsert(row.PP, row.CC.Dnm); request = CRUDsHelper.ToProxy <CTPProxy, CTP>(row); } } else if (request.RowSte == "D") { var row = Db.FromId(request.RowKey) as CTP; if (row == null) { request.RowErr = "CTP Rec not found"; } else // Silinmesinde sakinca yok { PP pp = row.PP; int dnm = row.CC.Dnm; row.Delete(); H.PPRD_TryDelete(pp, dnm); /* * var mac = Db.SQL<MAC>("select r from MAC r where r.CC = ? and (r.HPP1 = ? or r.HPP2 = ? or r.GPP1 = ? or r.GPP2 = ?)", row.CC, row.PP, row.PP, row.PP, row.PP).FirstOrDefault(); * if (mac != null) * request.RowErr = "MAC kaydı var. Silemezsiniz"; * else * { * PP pp = row.PP; * int dnm = row.CC.Dnm; * row.Delete(); * H.PPRD_TryDelete(pp, dnm); * }*/ } } }); }).Wait(); Session.RunTaskForAll((s, id) => { s.CalculatePatchAndPushOnWebSocket(); }); return(Task.FromResult(request)); }
public override Task <PPProxy> PPUpdate(PPProxy request, ServerCallContext context) { Scheduling.RunTask(() => { // RowSte: Added, Modified, Deletede, Unchanged Db.Transact(() => { if (request.RowSte == "A" || request.RowSte == "M") { if (request.RowErr == string.Empty) { PP row = CRUDsHelper.FromProxy <PPProxy, PP>(request); //XUT.Append(request.RowUsr, row, request.RowSte); request = CRUDsHelper.ToProxy <PPProxy, PP>(row); } } else if (request.RowSte == "D") { var row = (PP)Db.FromId(request.RowKey); if (row == null) { request.RowErr = "PP Rec not found"; } else { // CTP, CF ve MAC da ara varsa sildirme string err = ""; var ctp = Db.SQL <CTP>("select r from CTP r where r.PP = ?", row).FirstOrDefault(); if (ctp != null) { err = "CTP kaydı var"; } else { var cf = Db.SQL <CF>("select r from CF r where r.PP = ?", row).FirstOrDefault(); if (cf != null) { err = "CF kaydı var"; } else { var mac = Db.SQL <MAC>("select r from MAC r where r.HPP1 = ? or r.HPP2 = ? or r.GPP1 = ? or r.GPP2 = ?", row, row, row, row).FirstOrDefault(); if (mac != null) { err = "MAC kaydı var"; } } } if (err == "") { row.Delete(); } else { request.RowErr = $"Silemezsiniz! {err}"; } } } }); }).Wait(); return(Task.FromResult(request)); }