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; } } }