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);
 }
Exemple #2
0
 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!");
         }
     }
 }
Exemple #4
0
 partial void Updatedays_sessions_t(days_sessions_t instance);
Exemple #5
0
 partial void Insertdays_sessions_t(days_sessions_t instance);
Exemple #6
0
		private void detach_days_sessions_ts(days_sessions_t entity)
		{
			this.SendPropertyChanging();
			entity.tables_t = null;
		}
Exemple #7
0
		private void attach_days_sessions_ts(days_sessions_t entity)
		{
			this.SendPropertyChanging();
			entity.global_session_t = this;
		}
Exemple #8
0
 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();
     }
 }