public PositionDetails GetPositionDetails(string Position)
{
PositionDetails positionDetails = new PositionDetails();
DataTable dtPosition = enrollmentDataAccess.GetPositionDetails(Position);
if (dtPosition != null)
{
positionDetails.Position = Position;
positionDetails.InstallationNo = (Int32)dtPosition.Rows[0]["InstallationNo"];
positionDetails.BarPosNo = dtPosition.Rows[0]["BarPosNo"].ToString();
positionDetails.AssetNo = dtPosition.Rows[0]["Stock_No"].ToString();
positionDetails.GMUNo = dtPosition.Rows[0]["DatapakNo"].ToString();
positionDetails.SerialNo = dtPosition.Rows[0]["SerialNo"].ToString();
positionDetails.AltSerialNo = dtPosition.Rows[0]["AltSerialNo"].ToString();
positionDetails.MachineType = dtPosition.Rows[0]["MachineTypeCode"].ToString();
positionDetails.Manufacturer = dtPosition.Rows[0]["Manufacturer_Name"].ToString();
positionDetails.GameCode = dtPosition.Rows[0]["GameCode"].ToString();
positionDetails.GameCategory = dtPosition.Rows[0]["GameCategory"].ToString();
positionDetails.ActAssetNo = dtPosition.Rows[0]["ActAssetNo"].ToString();
positionDetails.GMUNo = dtPosition.Rows[0]["GMUNo"].ToString();
positionDetails.ActSerialNo = dtPosition.Rows[0]["ActSerialNo"].ToString();
positionDetails.EnrolmentFlag = int.Parse(dtPosition.Rows[0]["EnrolmentFlag"].ToString());
positionDetails.OperatorName = dtPosition.Rows[0]["OperatorName"].ToString();
positionDetails.IsDefaultAssetDetail = Convert.ToBoolean(dtPosition.Rows[0]["IsDefaultAssetDetail"]);
positionDetails.BaseDenom = int.Parse(dtPosition.Rows[0]["Base_Denom"].ToString());
positionDetails.PercentagePayout = Convert.ToSingle(dtPosition.Rows[0]["Percentage_Payout"].ToString());
}
return(positionDetails);
}
public EnrollmentErrorCodes InstallMachine(PositionDetails PosDetails, int userid, out int installationNo)
{
LockHandler Lock = new LockHandler();
EnrollmentErrorCodes ReturnValue;
installationNo = 0;
int SPResult = Lock.InsertLockRecord(userid, Dns.GetHostName(), "MACHINEADMIN", "POS", PosDetails.Position);
switch (SPResult)
{
case 0: ReturnValue = enrollment.InstallMachine(PosDetails, out installationNo);
break;
case 1:
ReturnValue = EnrollmentErrorCodes.LockExists;
break;
case 2:
ReturnValue = EnrollmentErrorCodes.LockError;
break;
default:
ReturnValue = EnrollmentErrorCodes.DatabaseError;
break;
}
Lock.DeleteLockRecord(userid, Dns.GetHostName(), "MACHINEADMIN", "POS", PosDetails.Position);
return(ReturnValue);
}
private void LoadRecord()
{
Int16 iID = Convert.ToInt16(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
Positions clsPosition = new Positions();
PositionDetails clsDetails = clsPosition.Details(iID);
clsPosition.CommitAndDispose();
lblPositionID.Text = clsDetails.PositionID.ToString();
txtPositionCode.Text = clsDetails.PositionCode;
txtPositionName.Text = clsDetails.PositionName;
}
private void SaveRecord()
{
Positions clsPosition = new Positions();
PositionDetails clsDetails = new PositionDetails();
clsDetails.PositionID = Convert.ToInt16(lblPositionID.Text);
clsDetails.PositionCode = txtPositionCode.Text;
clsDetails.PositionName = txtPositionName.Text;
clsPosition.Update(clsDetails);
clsPosition.CommitAndDispose();
}
public EnrollmentWnd(string PositionName)
{
InitializeComponent();
LogManager.WriteLog("Inside Constructor", LogManager.enumLogLevel.Info);
objPosDetails = new PositionDetails()
{
Position = PositionName
};
lblPosition.Content = PositionName;
lblStatus.Visibility = Visibility.Hidden;
progressBar1.Visibility = Visibility.Hidden;
if (Settings.RegulatoryEnabled && Settings.RegulatoryType == "AAMS")
{
chkInTransitAsset.Visibility = Visibility.Visible;
}
//txtBaseDenom.Text = "1";
//if (BMC.Common.ConfigurationManagement.ConfigManager.Read("EnableDenomChange").ToUpper() == "FALSE")
// txtBaseDenom.IsEnabled = false;
lblCoinType.Text = lblCoinType.Text + "(" + ExtensionMethods.GetCurrencyCoinSymbol() + "):";
using (InstallationDataContext objCoinType = new InstallationDataContext(oCommonUtilities.CreateInstance().GetConnectionString()))
{
var vCoinType = (from CoinType in objCoinType.GetCoinType(ExtensionMethods.CurrentSiteCulture)
select CoinType);
cmbCoinType.DisplayMemberPath = "CoinType";
cmbCoinType.SelectedValuePath = "CoinType";
cmbCoinType.ItemsSource = vCoinType;
if (cmbCoinType.Items.Count > 0)
{
cmbCoinType.SelectedIndex = 0;
}
}
bw.WorkerReportsProgress = true;
bw.WorkerSupportsCancellation = true;
bw.DoWork += new DoWorkEventHandler(bw_DoWork);
bw.ProgressChanged += new ProgressChangedEventHandler(bw_ProgressChanged);
bw.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bw_RunWorkerCompleted);
bwGetAssetDetails.DoWork += new DoWorkEventHandler(bwGetAssetDetails_DoWork);
bwGetAssetDetails.ProgressChanged += new ProgressChangedEventHandler(bwGetAssetDetails_ProgressChanged);
bwGetAssetDetails.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwGetAssetDetails_RunWorkerCompleted);
txtAsset.Focus();
}
private Int16 SaveRecord()
{
Positions clsPosition = new Positions();
PositionDetails clsDetails = new PositionDetails();
clsDetails.PositionCode = txtPositionCode.Text;
clsDetails.PositionName = txtPositionName.Text;
Int16 id = clsPosition.Insert(clsDetails);
clsPosition.CommitAndDispose();
return(id);
}
public PositionDetails GetPosition()
{
if (RoverCurrentPosition.CurrentDirection == 0)
{
SetInitialPosition();
}
var currentPosition = new PositionDetails(RoverCurrentPosition.CurrentDirection, RoverCurrentPosition.XPosition, RoverCurrentPosition.YPosition);
currentPosition.CurrentDirectionValue = currentPosition.CurrentDirection.ToString();
currentPosition.GridNumber = currentPosition.YPosition * -1 * _rover.GetParentSurface().Height +
currentPosition.XPosition;
currentPosition.LastStatusTime = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss");
return(currentPosition);
}
public MachineEnrolment(bool IsEnrol, string Position)
{
this.InitializeComponent();
MessageBox.childOwner = this;
this.IsEnrol = IsEnrol;
this.Position = Position;
txt_Position.Text = Position;
com_GMU_Type.Items.Add("MC300");
com_GMU_Type.Items.Add("Connexus");
com_GMU_Type.Items.Add("NoDevice");
com_GMU_Type.SelectedIndex = 0;
if (IsEnrol)
{
panel_Enrol_Button.Visibility = Visibility.Visible;
panel_Remove_Button.Visibility = Visibility.Hidden;
txt_MC_AssetNo.PreviewMouseUp += new MouseButtonEventHandler(txt_MC_AssetNo_PreviewMouseUp);
txt_GMU_No.PreviewMouseUp += new MouseButtonEventHandler(txt_GMU_No_PreviewMouseUp);
}
else
{
panel_Enrol_Button.Visibility = Visibility.Hidden;
panel_Remove_Button.Visibility = Visibility.Visible;
objPositiondetails = Enrollment.GetPositionDetails(Position);
txt_Mc_Serial_No.Text = objPositiondetails.SerialNo;
txt_Mc_Alt_Serial_No.Text = objPositiondetails.AltSerialNo;
txt_Manufacturer.Text = objPositiondetails.Manufacturer;
txt_Mc_Type.Text = objPositiondetails.MachineType;
txt_GameCode.Text = objPositiondetails.GameCode;
txt_GameCat.Text = objPositiondetails.GameCategory;
txt_Game.Text = objPositiondetails.Game;
txt_GMU_No.Text = objPositiondetails.GMUNo;
txt_MC_AssetNo.Text = objPositiondetails.AssetNo;
lbl_Title.Text = "Machine Removal";
if (txt_GMU_No.Text.Trim().Length == 0 || txt_GMU_No.Text.Trim() == "0")
{
com_GMU_Type.SelectedIndex = 2;
}
txt_GMU_No.IsReadOnly = true;
txt_Position.IsReadOnly = true;
txt_MC_AssetNo.IsReadOnly = true;
}
}
public MachineRemoval(PositionDetails objPd)
{
this.InitializeComponent();
MessageBox.childOwner = this;
objPositionDetails = objPd;
txt_GMU_No.Text = objPositionDetails.GMUNo;
txt_MC_AssetNo.Text = objPositionDetails.AssetNo;
txt_Position.Text = objPositionDetails.Position;
txt_GMU_No.IsReadOnly = true;
txt_MC_AssetNo.IsReadOnly = true;
txt_Position.IsReadOnly = true;
com_GMU_Type.Items.Add("MC300");
com_GMU_Type.Items.Add("Connexus");
com_GMU_Type.Items.Add("NoDevice");
com_GMU_Type.SelectedIndex = 0;
if (txt_GMU_No.Text.Trim().Length == 0 || txt_GMU_No.Text == "0")
{
com_GMU_Type.SelectedIndex = 2;
}
}
public void Dispose()
{
if (Commoditys != null)
{
Commoditys.Clear();
}
if (Users != null)
{
Users.Clear();
}
if (Accounts != null)
{
Accounts.Clear();
}
if (ClosedTradeDetails != null)
{
ClosedTradeDetails.Clear();
}
if (CommoditySummarizations != null)
{
CommoditySummarizations.Clear();
}
if (FundStatus != null)
{
FundStatus.Clear();
}
if (Parameters != null)
{
Parameters.Clear();
}
if (PositionDetails != null)
{
PositionDetails.Clear();
}
if (Positions != null)
{
Positions.Clear();
}
if (Remittances != null)
{
Remittances.Clear();
}
if (Stocks != null)
{
Stocks.Clear();
}
if (TradeDetails != null)
{
TradeDetails.Clear();
}
if (Trades != null)
{
Trades.Clear();
}
Commoditys = null;
Users = null;
Accounts = null;
ClosedTradeDetails = null;
CommoditySummarizations = null;
FundStatus = null;
Parameters = null;
PositionDetails = null;
Positions = null;
Remittances = null;
Stocks = null;
TradeDetails = null;
Trades = null;
}
public void Delete(DateTime dateTime, Guid accountId, params Type[] types)
{
foreach (var type in types)
{
SQLiteCommand cmd = null;
if (type == typeof(Commodity))
{
continue;
}
else if (type == typeof(User))
{
continue;
}
else if (type == typeof(Account))
{
continue;
}
else if (type == typeof(ClosedTradeDetail))
{
string sql = "DELETE FROM ClosedTradeDetail WHERE AccountId=@AccountId AND ActualDate>=@Date";
cmd = new SQLiteCommand(sql);
ClosedTradeDetails.RemoveAll(m => m.AccountId == accountId && m.ActualDate >= dateTime.Date);
}
else if (type == typeof(CommoditySummarization))
{
string sql = "DELETE FROM CommoditySummarization WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
CommoditySummarizations.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(FundStatus))
{
string sql = "DELETE FROM FundStatus WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
FundStatus.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(Parameter))
{
continue;
}
else if (type == typeof(PositionDetail))
{
string sql = "DELETE FROM PositionDetail WHERE AccountId=@AccountId AND DateForPosition>=@Date";
cmd = new SQLiteCommand(sql);
PositionDetails.RemoveAll(m => m.AccountId == accountId && m.DateForPosition >= dateTime.Date);
}
else if (type == typeof(Position))
{
string sql = "DELETE FROM Position WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
Positions.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(Remittance))
{
string sql = "DELETE FROM Remittance WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
Remittances.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(Stock))
{
string sql = "DELETE FROM Stock WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
Stocks.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else if (type == typeof(TradeDetail))
{
string sql = "DELETE FROM TradeDetail WHERE AccountId=@AccountId AND ActualTime>=@Date";
cmd = new SQLiteCommand(sql);
TradeDetails.RemoveAll(m => m.AccountId == accountId && m.ActualTime >= dateTime.Date);
}
else if (type == typeof(Trade))
{
string sql = "DELETE FROM Trade WHERE AccountId=@AccountId AND Date>=@Date";
cmd = new SQLiteCommand(sql);
Trades.RemoveAll(m => m.AccountId == accountId && m.Date >= dateTime.Date);
}
else
{
continue;
}
cmd.Parameters.AddWithValue("@AccountId", accountId.ToString());
cmd.Parameters.AddWithValue("@Date", dateTime.Date);
cmds.Add(cmd);
}
}
public int CreateInstallation(PositionDetails PosDetails)
{
LogManager.WriteLog("CreateInstallation:", LogManager.enumLogLevel.Info);
SqlDataReader Reader = null;
SqlConn = new SqlConnection(CommonDataAccess.ExchangeConnectionString);
int InstallationNO = 0;
SqlConn.Open();
Tran = SqlConn.BeginTransaction(IsolationLevel.ReadUncommitted, "Installation");
try
{
///Store the installation data in database
var oArrayParam = new SqlParameter[24];
var oParam1 = new SqlParameter
{
ParameterName = "@Position",
Value = PosDetails.Position,
Direction = ParameterDirection.Input
};
oArrayParam[0] = oParam1;
var oParam2 = new SqlParameter
{
ParameterName = "@Machine_Stock_No",
Value = PosDetails.AssetNo,
Direction = ParameterDirection.Input
};
oArrayParam[1] = oParam2;
var oParam3 = new SqlParameter
{
ParameterName = "@MachineTypeCode",
Value = PosDetails.GameCode,
Direction = ParameterDirection.Input
};
oArrayParam[2] = oParam3;
var oParam4 = new SqlParameter
{
ParameterName = "@MachineName",
Value = PosDetails.Game,
Direction = ParameterDirection.Input
};
oArrayParam[3] = oParam4;
var oParam5 = new SqlParameter
{
ParameterName = "@SerialNo",
Value = PosDetails.SerialNo,
Direction = ParameterDirection.Input
};
oArrayParam[4] = oParam5;
var oParam6 = new SqlParameter
{
ParameterName = "@AltSerialNo",
Value = PosDetails.AltSerialNo,
Direction = ParameterDirection.Input
};
oArrayParam[5] = oParam6;
var oParam7 = new SqlParameter
{
ParameterName = "@BaseDenom",
Value = PosDetails.BaseDenom,
Direction = ParameterDirection.Input
};
oArrayParam[6] = oParam7;
var oParam8 = new SqlParameter
{
ParameterName = "@CreditValue",
Value = PosDetails.CreditValue,
Direction = ParameterDirection.Input
};
oArrayParam[7] = oParam8;
var oParam9 = new SqlParameter
{
ParameterName = "@Installation_Percentage_Payout",
Value = PosDetails.PercentagePayout,
Direction = ParameterDirection.Input
};
oArrayParam[8] = oParam9;
var oParam10 = new SqlParameter
{
ParameterName = "@Installation_Jackpot_Value",
Value = PosDetails.Jackpot,
Direction = ParameterDirection.Input
};
oArrayParam[9] = oParam10;
var oParam11 = new SqlParameter
{
ParameterName = "@Manufacturer_Name",
Value = PosDetails.Manufacturer,
Direction = ParameterDirection.Input
};
oArrayParam[10] = oParam11;
var outParam = new SqlParameter
{
ParameterName = "@Installation_No",
Value = 0,
Direction = ParameterDirection.Output
};
oArrayParam[11] = outParam;
var oParam12 = new SqlParameter
{
ParameterName = "@ActAssetNo",
Value = PosDetails.ActAssetNo,
Direction = ParameterDirection.Input
};
oArrayParam[12] = oParam12;
var oParam13 = new SqlParameter
{
ParameterName = "@GMUNo",
Value = PosDetails.GMUNo,
Direction = ParameterDirection.Input
};
oArrayParam[13] = oParam13;
var oParam14 = new SqlParameter
{
ParameterName = "@ActSerialNo",
Value = PosDetails.ActSerialNo,
Direction = ParameterDirection.Input
};
oArrayParam[14] = oParam14;
var oParam15 = new SqlParameter
{
ParameterName = "@EnrolmentFlag ",
Value = PosDetails.EnrolmentFlag,
Direction = ParameterDirection.Input
};
oArrayParam[15] = oParam15;
var oParam16 = new SqlParameter
{
ParameterName = "@CMPGameType",
Value = PosDetails.CMPGameType,
Direction = ParameterDirection.Input
};
oArrayParam[16] = oParam16;
var oParam17 = new SqlParameter
{
ParameterName = "@OperatorName",
Value = PosDetails.OperatorName,
Direction = ParameterDirection.Input
};
oArrayParam[17] = oParam17;
var oParam18 = new SqlParameter
{
ParameterName = "@IsMultiGame",
Value = PosDetails.isMultiGame,
Direction = ParameterDirection.Input
};
oArrayParam[18] = oParam18;
var oParam19 = new SqlParameter
{
ParameterName = "@GetGameDetails",
Value = PosDetails.GetGameDetails,
Direction = ParameterDirection.Input
};
oArrayParam[19] = oParam19;
var oParam20 = new SqlParameter
{
ParameterName = "@IsDefaultAssetDetail",
Value = PosDetails.IsDefaultAssetDetail,
Direction = ParameterDirection.Input
};
oArrayParam[20] = oParam20;
var oParam21 = new SqlParameter
{
ParameterName = "@OccupanyHour",
Value = PosDetails.OccupancyHour,
Direction = ParameterDirection.Input
};
oArrayParam[21] = oParam21;
var oParam22 = new SqlParameter
{
ParameterName = "@AssetDisplayName",
Value = PosDetails.AssetDisplayName,
Direction = ParameterDirection.Input
};
oArrayParam[22] = oParam22;
var oParam23 = new SqlParameter
{
ParameterName = "@GameTypeCode",
Value = PosDetails.GameTypeCode,
Direction = ParameterDirection.Input
};
oArrayParam[23] = oParam23;
Reader = SqlHelper.ExecuteReader(SqlConn, Tran, CommandType.StoredProcedure, "usp_CreateSimpleInstallation", oArrayParam, SqlHelper.SqlConnectionOwnership.External);
InstallationNO = Int32.Parse(oArrayParam[11].Value.ToString());
if (Reader != null)
{
if (!Reader.IsClosed)
{
Reader.Close();
}
}
return(InstallationNO);
}
catch (Exception ex)
{
if (Reader != null)
{
if (!Reader.IsClosed)
{
Reader.Close();
}
}
RollbackTransaction(InstallationNO);
ExceptionManager.Publish(ex);
return(0);
}
finally
{
if (Reader != null)
{
if (!Reader.IsClosed)
{
Reader.Close();
}
Reader = null;
}
}
}
