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