private void LoadData() { _sessionData = DataBaseClass.Instancedb().GetDaySessionBySessionId(_sessionId); tbSessionId.Text = _sessionData.session_id.ToString(CultureInfo.InvariantCulture); tbConsole.Text = _sessionData.playstation_id; tbStartTime.Text = _sessionData.start_game.ToString(); tbEndTime.Text = _sessionData.end_game.ToString(); tbClient.Text = GetClientsFromSession(); tbDiscountAmount.Text = _sessionData.session_discount.ToString(); tbPaidSum.Text = _sessionData.payed_sum.ToString(CultureInfo.InvariantCulture); tbPlayed.Text = _daySessionMyClass.Счетчик.ToString(CultureInfo.InvariantCulture); }
partial void Deletedays_sessions_t(days_sessions_t instance);
public void AddNewDaySession(string playstationId, string clientId,double discountMoney, TimeSpan timeToPlay, double paidSum, DateTime curTime) { if (!String.IsNullOrWhiteSpace(playstationId) && !String.IsNullOrWhiteSpace(clientId)) { global_session_t globalSession = DataBaseClass.Instancedb().GetOpenedGlobalSession(); var lastClientNumInSession = DataBaseClass.Instancedb().GetLastClientNumInSession(globalSession.daily_id); var daysSessionT = new days_sessions_t { daily_id = globalSession.daily_id, client_num = lastClientNumInSession + 1, start_game = curTime, end_game = curTime.Add(timeToPlay), playstation_id = playstationId, session_state = "opened", payed_sum = paidSum, played_money = 0, session_discount = discountMoney//-----------------------------------------------------------------DISCOUNT ACCOUNTING }; try { DataBaseClass.Instancedb().InsertNewDaySession(daysSessionT); } catch (Exception) { MessageBox.Show(ErrorsAndWarningsMessages.ErrorsAndWarningsInstance().GetError(18)); } try { // int dailyId = DataBaseClass.Instancedb().GetOpenedGlobalSession().daily_id; DataBaseClass.Instancedb().AddMoneyToCash(daysSessionT.payed_sum, globalSession.daily_id); } catch (Exception) { MessageBox.Show(ErrorsAndWarningsMessages.ErrorsAndWarningsInstance().GetError(19)); } try { DataBaseClass.Instancedb().UpdatePlaystationState(playstationId, "busy"); } catch { //delete successful insertions DataBaseClass.Instancedb().DeleteDaySession(); MessageBox.Show(ErrorsAndWarningsMessages.ErrorsAndWarningsInstance().GetError(20)); } try { if (clientId == Options.OptionsInstance().UsualClient) { DataBaseClass.Instancedb().InsertClientsPerTable(clientId); } else { DataBaseClass.Instancedb().InsertClientsPerTable(ClientId); } } catch (Exception) { //delete successful insertions DataBaseClass.Instancedb().DeleteDaySession(); DataBaseClass.Instancedb().UpdatePlaystationState(playstationId, "free"); MessageBox.Show(ErrorsAndWarningsMessages.ErrorsAndWarningsInstance().GetError(19)); //"Cannot insert clients in clients_per_session table!"); } } }
partial void Updatedays_sessions_t(days_sessions_t instance);
partial void Insertdays_sessions_t(days_sessions_t instance);
private void detach_days_sessions_ts(days_sessions_t entity) { this.SendPropertyChanging(); entity.tables_t = null; }
private void attach_days_sessions_ts(days_sessions_t entity) { this.SendPropertyChanging(); entity.global_session_t = this; }
public void InsertNewDaySession(days_sessions_t daySession) { var db = new dbDataContext(); lock (db) { Table<days_sessions_t> daysT = db.GetTable<days_sessions_t>(); var daysSessionT = new days_sessions_t { daily_id = daySession.daily_id, client_num = daySession.client_num, start_game = daySession.start_game, end_game = daySession.end_game, playstation_id = daySession.playstation_id, session_state = "opened", payed_sum = daySession.payed_sum, played_money = daySession.played_money, session_discount = daySession.session_discount }; daysT.InsertOnSubmit(daysSessionT); db.SubmitChanges(); } }