public static void InsertPeople(IEnumerable <PeopleDto> peopleList)
{
foreach (var guy in peopleList)
{
try
{
var values = $"{guy.Id}, " +
$"{guy.FirstDate}, " +
$"{guy.Document}, " +
$"{guy.NumberOfCard}, " +
$"{guy.Surname}, " +
$"{guy.Name}, " +
$"{guy.SecondName}, " +
$"{guy.PhoneNumber}, " +
$"{guy.Area}, " +
$"{guy.Description}," +
$"{guy.Author}";
_connect.Insert(Properties.MySQLNames.cardsTableName,
Properties.MySQLNames.cardsFields,
values);
}
catch (Exception ex)
{
throw new Exception($"Unexpected error: {ex.Message}, Id = {guy.Id}");
}
}
}
private void RegistrationButton_Click(object sender, EventArgs e)
{
//todo check regex
var allUsers = DataFabric.GetUsers();
var registerUser = allUsers.FirstOrDefault(currentUser => currentUser.Name == LoginTextBox.Text.Trim());
if (registerUser != null)
{
MessageBox.Show(@"Такой пользователь уже существует",
@"Ошибка регистрации",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
var user = allUsers.FirstOrDefault(currentUser => currentUser.User == "password" &&
currentUser.Password == CodeTextBox.Text.Trim());
if (user == null)
{
MessageBox.Show(@"Неверный код!",
@"Ошибка регистрации",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
var newUser = new UserDto()
{
Name = LoginTextBox.Text.Trim(),
User = NameTextBox.Text.Trim(),
Password = PasswordTextBox.Text.Trim()
};
string values = $"'{newUser.User}', '{newUser.Password}', '{newUser.Name}'";
_connect.Insert(Properties.MySQLNames.userTableName,
Properties.MySQLNames.userFields,
values);//todo maybe add filling authorization form by this values
}