// Ferdi Events
public override async Task CEFFill(QryProxy request, IServerStreamWriter <CEFProxy> responseStream, ServerCallContext context)
{
CEFProxy proxy = new CEFProxy();
List <CEFProxy> proxyList = new List <CEFProxy>();
Type proxyType = typeof(CEFProxy);
PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray();
await Scheduling.RunTask(() =>
{
IEnumerable <CEF> rows = null;
if (request.Query == "CC")
{
rows = Db.SQL <CEF>("select r from CEF r where r.CC.ObjectNo = ?", ulong.Parse(request.Param));
}
else
{
rows = Db.SQL <CEF>("select r from CEF r");
}
foreach (var row in rows)
{
proxy = CRUDsHelper.ToProxy <CEFProxy, CEF>(row);
proxyList.Add(proxy);
}
});
foreach (var p in proxyList)
{
await responseStream.WriteAsync(p);
}
}
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));
}
// Team Players
public override async Task CTPFill(QryProxy request, IServerStreamWriter <CTPProxy> responseStream, ServerCallContext context)
{
CTPProxy proxy = new CTPProxy();
List <CTPProxy> proxyList = new List <CTPProxy>();
Type proxyType = typeof(CTPProxy);
PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray();
await Scheduling.RunTask(() =>
{
IEnumerable <CTP> rows = null;
if (request.Query == "CT")
{
rows = Db.SQL <CTP>("select r from CTP r where r.CT.ObjectNo = ?", ulong.Parse(request.Param));
}
else
{
rows = Db.SQL <CTP>("select r from CTP r ");
}
foreach (var row in rows)
{
proxy = CRUDsHelper.ToProxy <CTPProxy, CTP>(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);
}
}
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));
}
// Players
public override async Task PPFill(QryProxy request, IServerStreamWriter <PPProxy> responseStream, ServerCallContext context)
{
PPProxy proxy = new PPProxy();
List <PPProxy> proxyList = new List <PPProxy>();
Type proxyType = typeof(PPProxy);
PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray();
await Scheduling.RunTask(() =>
{
foreach (var row in Db.SQL <PP>("select r from PP r"))
{
//proxy = ReflectionExample.ToProxy<AHPproxy, AHP>(row);
proxy = CRUDsHelper.ToProxy <PPProxy, PP>(row);
/*
* proxy = new PPProxy
* {
* RowKey = row.GetObjectNo(),
* Ad = row.Ad,
* Sex = row.Sex ?? "",
* Tel = row.Tel ?? "",
* Info = row.Info ?? "",
* IsRun = row.IsRun,
*
* RnkIlk = row.RnkBaz,
* RnkBaz = row.RnkBaz,
* RnkSon = row.RnkSon,
* RnkIdx = row.RnkIdx,
*
* SST = row.SST,
* SSW = row.SSW,
* SSL = row.SSL,
* SMT = row.SMT,
* SMW = row.SMW,
* SML = row.SML,
* DST = row.DST,
* DSW = row.DSW,
* DSL = row.DSL,
* DMT = row.DMT,
* DMW = row.DMW,
* DML = row.DML,
*
* };
*/
proxyList.Add(proxy);
}
});
foreach (var p in proxyList)
{
await responseStream.WriteAsync(p);
}
}
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));
}
// Donemler
public override async Task DDFill(QryProxy request, IServerStreamWriter <DDProxy> responseStream, ServerCallContext context)
{
DDProxy proxy = new DDProxy();
List <DDProxy> proxyList = new List <DDProxy>();
Type proxyType = typeof(DDProxy);
PropertyInfo[] proxyProperties = proxyType.GetProperties().Where(x => x.CanRead && x.CanWrite).ToArray();
await Scheduling.RunTask(() =>
{
foreach (var row in Db.SQL <DD>("select r from DD r"))
{
proxy = CRUDsHelper.ToProxy <DDProxy, DD>(row);
proxyList.Add(proxy);
}
});
foreach (var p in proxyList)
{
await responseStream.WriteAsync(p);
}
}
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));
}
// 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);
}
}
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));
}
