protected override void OnData()
{
base.OnData();
CC cc = Db.FromId <CC>((ulong)CCoNo);
var session = Session.Ensure();
var mp = session.Store[nameof(MasterPage)] as MasterPage;
IsYetkili = false;
if (!string.IsNullOrEmpty(cc.Pwd) && mp.Pwd == cc.Pwd)
{
IsYetkili = true;
}
Hdr = $"{cc.Ad} ► Fikstür";
string tarih = "";
var cets = Db.SQL <CET>("SELECT r FROM CET r WHERE r.CC = ? order by r.Trh", cc);
foreach (var cet in cets)
{
var rde = new CETsElementJson
{
CEToNo = (long)cet.CEToNo,
HCToNo = (long)cet.HCToNo,
HCTAd = cet.HCTAd,
GCToNo = (long)cet.GCToNo,
GCTAd = cet.GCTAd,
Tarih = cet.Tarih,
Drm = cet.Drm,
HWL = cet.HWL,
GWL = cet.GWL,
HR = cet.HR,
GR = cet.GR,
HPW = cet.HPW,
GPW = cet.GPW,
Puan = cet.Puan,
Info = cet.Info,
IsHOS = cet.IsHOS,
IsGOS = cet.IsGOS
};
if (rde.Tarih != tarih)
{
//rde.Break = true; // Ayni tarihdekileri gruplamak icin. Gerek yok
tarih = rde.Tarih;
}
CETs.Add(rde);
}
}
protected override void OnData()
{
base.OnData();
CT ct = Db.FromId <CT>((ulong)CToNo);
Hdr = $"{ct.CC.Ad} ► {ct.Ad} ► Müsabakaları";
CTAd = ct.Ad;
var cets = Db.SQL <CET>("select r from CET r where r.HCT = ? or r.GCT = ? order by r.Trh", ct, ct);
foreach (var cet in cets)
{
if (cet.HCT.GetObjectNo() == ct.GetObjectNo()) // Kendisi Home. Rakip Guest
{
var hcet = new CETsElementJson
{
CEToNo = (long)cet.GetObjectNo(),
Tarih = cet.Tarih,
RkpCToNo = (long)cet.GCToNo,
RkpCTAd = cet.GCTAd,
RkpPW = $"{cet.GPW:#}",
RkpKW = $"{cet.GKW:#}",
RkpSMW = $"{cet.GSMW:#}",
RkpDMW = $"{cet.GDMW:#}",
PW = $"{cet.HPW:#}",
KW = $"{cet.HKW:#}",
SMW = $"{cet.HSMW:#}",
DMW = $"{cet.HDMW:#}",
WL = cet.HPW > cet.GPW ? "W" : "L"
};
CETs.Add(hcet);
}
else
{
var gcet = new CETsElementJson
{
CEToNo = (long)cet.GetObjectNo(),
Tarih = cet.Tarih,
RkpCToNo = (long)cet.HCToNo,
RkpCTAd = cet.HCTAd,
RkpPW = $"{cet.HPW:#}",
RkpKW = $"{cet.HKW:#}",
RkpSMW = $"{cet.HSMW:#}",
RkpDMW = $"{cet.HDMW:#}",
PW = $"{cet.GPW:#}",
KW = $"{cet.GKW:#}",
SMW = $"{cet.GSMW:#}",
DMW = $"{cet.GDMW:#}",
WL = cet.GPW > cet.HPW ? "W" : "L"
};
CETs.Add(gcet);
}
}
}
protected override void OnData()
{
base.OnData();
DD dd = Db.SQL <DD>("select r from DD r where r.Dnm = ?", H.DnmRun).FirstOrDefault();
Hdr = $"{dd.Ad} ► Güncel";
// Gecmis Pzrtsi'den bir sonraki Cumaya kadar. 2 haftalik
DateTime firstMonday = H.GetNextWeekday(DayOfWeek.Monday);
DateTime T1 = firstMonday.AddDays(-7); // -7
DateTime T2 = firstMonday.AddDays(5);
string tarih = "";
var cets = Db.SQL <CET>("SELECT r FROM CET r WHERE r.CC.Dnm = ? and r.Drm = ? and r.Trh < ? order by r.Trh", H.DnmRun, "", T1);
foreach (var cet in cets)
{
var rde = new CETsElementJson
{
CCoNo = (long)cet.CCoNo,
CEToNo = (long)cet.CEToNo,
HCToNo = (long)cet.HCToNo,
HCTAd = cet.HCTAd,
GCToNo = (long)cet.GCToNo,
GCTAd = cet.GCTAd,
Tarih = cet.Tarih,
Drm = cet.Drm,
HWL = cet.HWL,
GWL = cet.GWL,
HR = cet.HR,
GR = cet.GR,
HPW = cet.HPW,
GPW = cet.GPW,
Puan = cet.Puan,
Info = cet.Info,
IsHOS = cet.IsHOS,
IsGOS = cet.IsGOS
};
if (rde.Tarih != tarih)
{
tarih = rde.Tarih;
}
CETs.Add(rde);
}
cets = Db.SQL <CET>("SELECT r FROM CET r WHERE r.CC.Dnm = ? and r.Trh >= ? and r.Trh <= ? order by r.Trh", H.DnmRun, T1, T2);
foreach (var cet in cets)
{
var rde = new CETsElementJson
{
CCoNo = (long)cet.CCoNo,
CEToNo = (long)cet.CEToNo,
HCToNo = (long)cet.HCToNo,
HCTAd = cet.HCTAd,
GCToNo = (long)cet.GCToNo,
GCTAd = cet.GCTAd,
Tarih = cet.Tarih,
Drm = cet.Drm,
HWL = cet.HWL,
GWL = cet.GWL,
HR = cet.HR,
GR = cet.GR,
HPW = cet.HPW,
GPW = cet.GPW,
Puan = cet.Puan,
Info = cet.Info,
IsHOS = cet.IsHOS,
IsGOS = cet.IsGOS
};
if (rde.Tarih != tarih)
{
rde.Break = true;
tarih = rde.Tarih;
}
CETs.Add(rde);
}
}
