public DLMachineCollectionDto GetMachines(string siteCode, object machineID)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "GetMachines");
DLMachineCollectionDto result = new DLMachineCollectionDto();
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("@MachineId", machineID);
DataSet ds = db.ExecuteDataset("[dbo].[rsp_EBS_GetMachines]", parameters);
DataTable dt = ds.GetDataTable(0);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
DLMachineDto dto = new DLMachineDto();
dto.MachineID = dr.Field <string>("MachineID");
dto.Area = dr.Field <string>("Area");
dto.MachineType = dr.Field <string>("MachineType");
dto.Bank = dr.Field <string>("BANK");
dto.GameName = dr.Field <string>("GameName");
dto.DenominationID = dr.Field <string>("DenominationID");
dto.ManufacturerName = dr.Field <string>("ManufacturerId");
dto.MachineLoc = dr.Field <string>("MachineLoc");
dto.CasinoID = dr.Field <string>("CasinoID");
dto.ZoneID = dr.Field <string>("ZoneID");
dto.IsActive = dr.Field <bool>("IsActive");
result.Add(dto);
}
}
}
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return(result);
}
public DLMachineCollectionDto GetMachines(string siteCode, object machineID)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "GetMachines");
DLMachineCollectionDto result = new DLMachineCollectionDto();
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("@MachineId", machineID);
DataSet ds = db.ExecuteDataset("[dbo].[rsp_EBS_GetMachines]", parameters);
DataTable dt = ds.GetDataTable(0);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
DLMachineDto dto = new DLMachineDto();
dto.MachineID = dr.Field<string>("MachineID");
dto.Area = dr.Field<string>("Area");
dto.MachineType = dr.Field<string>("MachineType");
dto.Bank = dr.Field<string>("BANK");
dto.GameName = dr.Field<string>("GameName");
dto.DenominationID = dr.Field<string>("DenominationID");
dto.ManufacturerName = dr.Field<string>("ManufacturerId");
dto.MachineLoc = dr.Field<string>("MachineLoc");
dto.CasinoID = dr.Field<string>("CasinoID");
dto.ZoneID = dr.Field<string>("ZoneID");
dto.IsActive = dr.Field<bool>("IsActive");
result.Add(dto);
}
}
}
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return result;
}
internal bool Parse_configurationInfo_getMachine(s2sMessage target, object source)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "Parse_configurationInfo_getMachine");
bool result = default(bool);
getConfigurationGetMachine s2s = source as getConfigurationGetMachine;
try
{
DLMachineCollectionDto collection = _di.GetMachines(target.p_body.p_configuration.propertyId, s2s.machineId.s2sStringId());
result = this.Parse_configurationInfo_getMachine(target, collection);
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return(result);
}
internal bool Parse_configurationInfo_getMachine(s2sMessage target, DLMachineCollectionDto collection)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "Parse_configurationInfo_getMachine");
bool result = default(bool);
try
{
configurationInfo ci = target.p_body.p_configuration.p_configurationInfo;
if (collection != null)
{
List <machine> Machines = new List <machine>();
foreach (var dto in collection)
{
Machines.Add(new machine()
{
machineId = dto.MachineID,
areaId = dto.Area,
gameId = dto.GameName,
machineLoc = dto.MachineLoc,
machineActive = dto.IsActive,
denominationId = dto.DenominationID,
manufacturerId = dto.ManufacturerName,
casinoId = dto.CasinoID,
machineType = dto.MachineType,
zoneId = dto.ZoneID,
bankId = dto.Bank
});
}
ci.machine = Machines.ToArray();
result = true;
}
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return(result);
}
internal bool Parse_configurationInfo_getMachine(s2sMessage target, DLMachineCollectionDto collection)
{
ModuleProc PROC = new ModuleProc(this.DYN_MODULE_NAME, "Parse_configurationInfo_getMachine");
bool result = default(bool);
try
{
configurationInfo ci = target.p_body.p_configuration.p_configurationInfo;
if (collection != null)
{
List<machine> Machines = new List<machine>();
foreach (var dto in collection)
{
Machines.Add(new machine()
{
machineId = dto.MachineID,
areaId = dto.Area,
gameId = dto.GameName,
machineLoc = dto.MachineLoc,
machineActive = dto.IsActive,
denominationId = dto.DenominationID,
manufacturerId = dto.ManufacturerName,
casinoId = dto.CasinoID,
machineType = dto.MachineType,
zoneId = dto.ZoneID,
bankId = dto.Bank
});
}
ci.machine = Machines.ToArray();
result = true;
}
}
catch (Exception ex)
{
Log.Exception(PROC, ex);
}
return result;
}
