public static string GetCasinoGameRecentWinnersInternalSql(ceDomainConfigEx domain, bool isMobile)
{
using (DbManager db = new DbManager("Dw"))
{
DwAccessor da = DwAccessor.CreateInstance <DwAccessor>(db);
List <string> countryCodes = da.GetCountryCodes(domain.RecentWinnersCountryFilterMode
, domain.RecentWinnersCountryCodes
);
return(string.Format(CultureInfo.InvariantCulture, @"EXEC [GetCasinoGameRecentWinners]
@vendorIDs='{0}',
@gameCodes='{1}',
@domainIDs='{2}',
@countryAlpha2Codes='{3}',
@minWinInEUR={4:F2},
@IsUniqueUsersOnly={5},
@betFromTime='{6}',
@betEndTime='{7}',
@isMobile={8}"
, domain.RecentWinnersFilteredVendorIDs
, domain.RecentWinnersFilteredGameCodes
, domain.RecentWinnersExcludeOtherOperators ? domain.DomainID.ToString() : null
, string.Join(",", countryCodes.ToArray())
, domain.RecentWinnersMinAmount
, domain.RecentWinnersReturnDistinctUserOnly ? 1 : 0
, DateTime.Now.AddDays(-12).ToString("yyyy-MM-dd HH:mm:ss")
, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
, isMobile ? 1 : 0
));
}
}
public static List <dwWinner> GetCasinoGameRecentWinners(ceDomainConfigEx domain, bool isMobile)
{
if (AGENT_ENABLED)
{
try
{
GetRecentWinnersResponse response = _agent.GetRecentWinners(new GetRecentWinnersRequest()
{
Environment = CURRENT_ENV,
CountryFilterMode = domain.RecentWinnersCountryFilterMode,
CountryCodes = domain.RecentWinnersCountryCodes,
VendorIDs = domain.RecentWinnersFilteredVendorIDs,
GameCodes = domain.RecentWinnersFilteredGameCodes,
DomainIDs = domain.RecentWinnersExcludeOtherOperators ? domain.DomainID.ToString() : null,
MinAmount = domain.RecentWinnersMinAmount,
DistinctUserOnly = domain.RecentWinnersReturnDistinctUserOnly,
StartTime = DateTime.Now.AddDays(-12),
EndTime = DateTime.Now,
Platform = isMobile ? Platform.Mobile : Platform.Desktop,
});
if (response.RecentWinners == null)
{
return(new List <dwWinner>());
}
return(response.RecentWinners.Select(w => new dwWinner()
{
Amount = w.Amount,
CountryCode = w.CountryCode,
Currency = w.Currency,
DomainID = w.DomainID,
Firstname = w.Firstname,
GameCode = w.GameCode,
Surname = w.Surname,
UserID = w.UserID,
Username = w.Username,
VendorID = w.VendorID,
WinTime = w.WinTime,
}).ToList());
}
catch
{
return(new List <dwWinner>());
}
}
try
{
using (DbManager db = new DbManager("Dw"))
{
DwAccessor da = DwAccessor.CreateInstance <DwAccessor>(db);
List <string> countryCodes = da.GetCountryCodes(domain.RecentWinnersCountryFilterMode
, domain.RecentWinnersCountryCodes
);
/*
* DECLARE @endDate DATETIME
* DECLARE @startDate DATETIME
* SELECT @endDate = GETDATE()
* SELECT @startDate = DATEADD( day, -12, GETDATE())
* EXEC [GetCasinoGameRecentWinners]
* @vendorIDs='108,109',
* @gameCodes=NULL,
* @domainIDs=NULL,
* @countryAlpha2Codes='AF,AL,DZ,AS,AD,AO,AI,AQ,AG,AR,AM,AW,AU,AT,AZ,BS,BH,BD,BB,BY,BE,BZ,BJ,BM,BT,BO,BA,BW,BV,BR,IO,BN,BG,BF,BI,KH,CM,CA,CV,KY,CF,TD,CL,CN,CX,CC,CO,KM,CG,CK,CR,CI,HR,CU,CY,CZ,DK,DJ,DM,DO,TP,EC,EG,SV,GQ,ER,EE,ET,FK,FO,FJ,FI,FR,FX,GF,PF,TF,GA,GM,GE,DE,GH,GI,GR,GL,GD,GP,GU,GT,GN,GW,GY,HT,HM,HN,HK,HU,IS,IN,ID,IR,I,IE,IL,IT,JM,JP,JO,KZ,KE,KI,KW,KG,LA,LV,LB,LS,LR,LY,LI,LT,LU,MO,MK,MG,MW,MY,MV,ML,MT,MH,MQ,MR,MU,YT,MX,FM,MD,MC,MN,MS,MA,MZ,MM,NA,NR,NP,NL,AN,NC,NZ,NI,NE,NG,NU,NF,KP,MP,NO,OM,xx,PK,PW,PA,PG,PY,PE,PH,PN,PL,PT,PR,QA,RE,RO,RU,RW,KN,LC,VC,WS,SM,ST,SA,SN,SC,SL,SG,SK,SI,SB,SO,ZA,GS,KR,ES,LK,SH,PM,SD,SR,SJ,SZ,SE,CH,SY,TW,TJ,TZ,TH,TG,TK,TO,TT,TN,TR,TM,TC,TV,UG,UA,AE,GB,US,UM,UY,UZ,VU,VA,VE,VN,VI,VG,WF,EH,YE,ZR,ZM,ZW,RS,ME,0X,AX,CD,GG,IM,JE,PS,CS,TL,BL,EU,MF,A1,A2,AP',
* @minWinInEUR=1,
* @IsUniqueUsersOnly=0,
* @betFromTime=@startDate,
* @betEndTime=@endDate,
* @isMobile=1
*/
string contries = string.Join(",", countryCodes.ToArray());
List <dwWinner> dw = da.GetCasinoGameRecentWinners(domain.RecentWinnersFilteredVendorIDs
, domain.RecentWinnersFilteredGameCodes
, domain.RecentWinnersExcludeOtherOperators ? domain.DomainID.ToString() : null
, contries
, domain.RecentWinnersMinAmount
, domain.RecentWinnersReturnDistinctUserOnly
, DateTime.Now.AddDays(-12)
, DateTime.Now
, isMobile
);
if (domain.RecentWinnersExcludeOtherOperators && domain.DomainID > 0)
{
for (int i = 0; i < dw.Count; i++)
{
dw[i].DomainID = domain.DomainID;
}
}
return(dw);
}
}
catch (Exception ex)
{
Logger.Exception(ex);
return(new List <dwWinner>());
}
}
