private void Updata() { Lots.Clear(); Bargaes.Clear(); Lots = DataBaseService.LoadLotsFromDataBase(); Bargaes = DataBaseService.LoatBargaesFromDataBase(); }
public AdministrationViewModel() { try { Lots = DataBaseService.LoadLotsFromDataBase(); Users = DataBaseService.LoadUsersFromDataBase(); Bargaes = DataBaseService.LoatBargaesFromDataBase(); } catch (Exception exp) { MessageBox.Show(exp.Message); } }
public LotInfoViewModel() { Lots = DataBaseService.LoadLotsFromDataBase(); user = DataBaseService.GetUserInfo(currentUser.login); Bargaes = DataBaseService.LoatBargaesFromDataBase(); selectedBarga = new Bargaining(); summa = 0; TimeLeft = ""; Task.Factory.StartNew(() => { while (true) { Task.Delay(1000).Wait(); timer(); } }); }
//Регистрация нового пользователя в базе данных static public void AddNewUser(User user) { try { if (!DataBaseService.IsUserExist(user.Login)) { string sqlCommand = "Select * from Users"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(sqlCommand, connection); DataSet ds = new DataSet(); adapter.Fill(ds); DataTable dt = ds.Tables[0]; DataRow newRow = dt.NewRow(); newRow["loginUser"] = user.Login; newRow["passwordUser"] = user.Password; newRow["name"] = user.Name; newRow["surname"] = user.Surname; newRow["email"] = user.Email; newRow["country"] = user.County; newRow["city"] = user.City; newRow["phoneNumber"] = user.PhoneNumber; dt.Rows.Add(newRow); SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adapter); adapter.Update(ds); MessageBox.Show("Регистрация прошла успешно!"); } } else { MessageBox.Show("Пользователь с таким login уже существует!"); } } catch (Exception exp) { MessageBox.Show(exp.Message); } }
public AddLotViewModel() { selectedLot = new LotInfo(); user = DataBaseService.GetUserInfo(currentUser.login); Barga = new Bargaining(); }
public ClientInfoViewModel() { selectedUser = DataBaseService.GetUserInfo(currentUser.login); }