internal bool Parse_configurationInfo_getGame(s2sMessage target, DLGameCollectionDto collection)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "Parse_configurationInfo_getGame");
bool result = default(bool);
try
{
configurationInfo ci = target.p_body.p_configuration.p_configurationInfo;
if (collection != null)
{
List<game> Games = new List<game>();
foreach (var dto in collection)
{
Games.Add(new game()
{
gameId = dto.GameID.ToStringSafe(),
gameName = dto.GameName,
gameActive = dto.IsActive,
});
}
ci.game = Games.ToArray();
result = true;
}
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return result;
}
internal bool Parse_configurationInfo_getGame(s2sMessage target, DLGameCollectionDto collection)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "Parse_configurationInfo_getGame");
bool result = default(bool);
try
{
configurationInfo ci = target.p_body.p_configuration.p_configurationInfo;
if (collection != null)
{
List <game> Games = new List <game>();
foreach (var dto in collection)
{
Games.Add(new game()
{
gameId = dto.GameID.ToStringSafe(),
gameName = dto.GameName,
gameActive = dto.IsActive,
});
}
ci.game = Games.ToArray();
result = true;
}
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return(result);
}
internal bool Parse_configurationInfo_getGame(s2sMessage target, object source)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "Parse_configurationInfo_getGame");
bool result = default(bool);
getConfigurationGetGame s2s = source as getConfigurationGetGame;
try
{
DLGameCollectionDto collection = _di.GetGames(target.p_body.p_configuration.propertyId, s2s.gameId.s2sStringId());
result = this.Parse_configurationInfo_getGame(target, collection);
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return(result);
}
public DLGameCollectionDto GetGames(string siteCode, object gameId)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "GetGames");
DLGameCollectionDto result = new DLGameCollectionDto();
try
{
using (Database db = DbFactory.OpenDB(_connectionString))
{
db.Open();
DbParameter[] parameters = db.CreateParameters(2);
parameters[0] = db.CreateParameter("@SiteCode", DbType.AnsiString, 50, siteCode);
parameters[1] = db.CreateParameter("@GamePrefix", gameId);
// if (string.IsNullOrWhiteSpace(gameId)) parameters[0].Value = gameId.Trim()[0];
DataSet ds = db.ExecuteDataset("[dbo].[rsp_EBS_GetGameDetails]", parameters);
DataTable dt = ds.GetDataTable(0);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
DLGameDto dto = new DLGameDto();
dto.GameID = dr.Field <string>("GameID").ToStringSafe();
dto.GameName = dr.Field <string>("GameName");
dto.IsActive = dr.Field <bool>("IsActive");
result.Add(dto);
}
}
}
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return(result);
}
public DLGameCollectionDto GetGames(string siteCode, object gameId)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "GetGames");
DLGameCollectionDto result = new DLGameCollectionDto();
try
{
using (Database db = DbFactory.OpenDB(_connectionString))
{
db.Open();
DbParameter[] parameters = db.CreateParameters(2);
parameters[0] = db.CreateParameter("@SiteCode", DbType.AnsiString, 50, siteCode);
parameters[1] = db.CreateParameter("@GamePrefix", gameId);
// if (string.IsNullOrWhiteSpace(gameId)) parameters[0].Value = gameId.Trim()[0];
DataSet ds = db.ExecuteDataset("[dbo].[rsp_EBS_GetGameDetails]", parameters);
DataTable dt = ds.GetDataTable(0);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
DLGameDto dto = new DLGameDto();
dto.GameID = dr.Field<string>("GameID").ToStringSafe();
dto.GameName = dr.Field<string>("GameName");
dto.IsActive = dr.Field<bool>("IsActive");
result.Add(dto);
}
}
}
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return result;
}
