/// <summary>
/// Поиск пользователя
/// </summary>
private void Search_Click(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
var repository = new DbPersonRepository();
var temp = repository.SearchPerson(textBox_SurName.Text, textBox_Name.Text, textBox_Patronymic.Text,
textBox_Organization.Text,
textBox_Position.Text, textBox_Email.Text, textBox_NumberPhone.Text);
int j = 0;
foreach (var person in temp)
{
dataGridView1.Rows.Add();
}
foreach (var person in temp)
{
dataGridView1.Rows[j].Cells["Id"].Value = person.Id;
dataGridView1.Rows[j].Cells["SurName"].Value = person.SurName ?? "";
dataGridView1.Rows[j].Cells["Name"].Value = person.Name ?? "";
dataGridView1.Rows[j].Cells["Patronymic"].Value = person.Patronymic ?? "";
dataGridView1.Rows[j].Cells["Organization"].Value = person.Organization ?? "";
dataGridView1.Rows[j].Cells["Position"].Value = person.Position ?? "";
dataGridView1.Rows[j].Cells["Email"].Value = person.Email ?? "";
dataGridView1.Rows[j++].Cells["NumberPhone"].Value = person.NumberPhone ?? "";
}
}
public void SearchPersonTest()
{
var person = new Person
{
Name = "Vasy",
SurName = "Andreev",
Patronymic = "Anatolbevich",
Position = "Engineer",
Organization = "ikci",
Email = "*****@*****.**",
NumberPhone = "89652793643"
};
var repository = new DbPersonRepository();
repository.AddPerson(person);
repository.AddPerson(new Person
{
Id = 0,
Name = "Vasy",
SurName = "Pupkin",
Patronymic = "Anatolbevich",
Position = "Engineer",
Organization = "ikci",
Email = "*****@*****.**",
NumberPhone = "89652793643"
});
repository.AddPerson(new Person
{
Id = 0,
Name = "Leha",
SurName = "Andreev",
Patronymic = "Anatolbevich",
Position = "Engineer",
Organization = "ikci",
Email = "*****@*****.**",
NumberPhone = "89652793643"
});
var personListWithParametrs = repository.SearchPerson("", "Andreev", "", "", "", "", "");
foreach (var temp in personListWithParametrs)
{
Assert.IsTrue(temp.SurName.Equals("Andreev"));
}
Assert.IsTrue(repository.ExistPerson(person));
repository.DeletePerson(person);
Assert.IsFalse(repository.ExistPerson(person));
}
/// <summary>
/// Кнопка изменения пользователя
/// </summary>
private void Change_Click(object sender, EventArgs e)
{
var repository = new DbPersonRepository();
_person.SurName = textBox_new_SurName.Text;
_person.Name = textBox_new_Name.Text;
_person.Patronymic = textBox_new_Patronymic.Text;
_person.Organization = textBox_new_Organization.Text;
_person.Position = textBox_new_Position.Text;
_person.Email = textBox_new_Email.Text;
_person.NumberPhone = textBox_new_NumberPhone.Text;
repository.ChangePerson(_person);
Close();
}
/// <summary>
/// Удаление пользователя
/// </summary>
private void button_delete_Click(object sender, EventArgs e)
{
var row = dataGridView1.CurrentCell.RowIndex;
var person = new Person(dataGridView1.Rows[row].Cells["SurName"].Value.ToString(),
dataGridView1.Rows[row].Cells["Name"].Value.ToString(),
dataGridView1.Rows[row].Cells["Patronymic"].Value.ToString(),
dataGridView1.Rows[row].Cells["Organization"].Value.ToString(),
dataGridView1.Rows[row].Cells["Position"].Value.ToString(),
dataGridView1.Rows[row].Cells["Email"].Value.ToString(),
dataGridView1.Rows[row].Cells["NumberPhone"].Value.ToString())
{
Id = Convert.ToInt32(dataGridView1.Rows[row].Cells["Id"].Value.ToString())
};
var repository = new DbPersonRepository();
repository.DeletePerson(person);
Search_Click(new object(), new EventArgs());
}
public void AddUserToRepository()
{
var repository = new DbPersonRepository();
var person1 = new Person
{
Name = "Vasy",
SurName = "Pupkin",
Patronymic = "Anatolbevich",
Position = "Engineer",
Organization = "ikci",
Email = "*****@*****.**",
NumberPhone = "89652793643"
};
var person2 = new Person
{
Name = "Denis",
SurName = "Andreev",
Patronymic = "Ahmdeinov",
Position = "Engineer",
Organization = "ikci",
Email = "*****@*****.**",
NumberPhone = "89818226401"
};
repository.AddPerson(person1);
repository.ChangePerson(person1);
var people = repository.GetPeopleList();
var enumerable = people as Person[] ?? people.ToArray();
Assert.IsNull(enumerable.FirstOrDefault(u => u == person2));
Assert.IsNotNull(enumerable.FirstOrDefault(u => u == person1));
var samePeople = repository.GetPeopleList().Where(u => u == person1);
foreach (var personClone in samePeople)
{
repository.DeletePerson(personClone);
}
people = repository.GetPeopleList();
Assert.That(people.All(u => u != person1), Is.True);
}
/// <summary>
/// Кнопка добавления пользователя
/// </summary>
private void Add_Click(object sender, EventArgs e)
{
if ((Name.Text.Length == 0) || (Surname.Text.Length == 0) || (Patronymic.Text.Length == 0))
{
MessageBox.Show("Обязательные поля ввода: Name, Surname, Patronymic");
return;
}
var myRegFIO = new Regex(@"[A-Z]{1}[a-z]*");
if (!myRegFIO.IsMatch(Name.Text) || !myRegFIO.IsMatch(Surname.Text) || !myRegFIO.IsMatch(Patronymic.Text))
{
MessageBox.Show("Name, SurName, Patronymic должны начинаться с заглавной буквы! Символов быть не должно!\nПопробуйте еще раз!");
return;
}
var myRegEmail = new Regex(@"[A-Za-z0-9_-]+@[A-Za-z]+\.[A-Za-z]+");
if (!myRegEmail.IsMatch(Email.Text) & (Email.Text.Length != 0))
{
MessageBox.Show("Указанная вами электронная почта введена неверно.\nПример ввода: [email protected]");
return;
}
var myRegNumberPhone = new Regex(@"8[0-9]{10}$");
if (!myRegNumberPhone.IsMatch(NumberPhone.Text) & (NumberPhone.Text.Length != 0))
{
MessageBox.Show("Указанный вами телефон был введен неверно.\nФормат телефона: 8XXXXXXXXXX(11 цифр)");
return;
}
var repository = new DbPersonRepository();
var people = repository.GetPeopleList();
if (people.Any(person => person.Name.ToLower().Equals(Name.Text.ToLower())
& person.SurName.ToLower().Equals(Surname.Text.ToLower())
& person.Patronymic.ToLower().Equals(Patronymic.Text.ToLower())))
{
MessageBox.Show("Данный пользователь уже есть в базе данных!");
Close();
return;
}
repository.AddPerson(new Person(Surname.Text, Name.Text, Patronymic.Text, Position.Text, Organization.Text, Email.Text, NumberPhone.Text));
this.Close();
}
/// <summary>
/// Обновить таблицу
/// </summary>
public new void Update()
{
dataGridView1.Rows.Clear();
var repository = new DbPersonRepository();
var peopleList = repository.GetPeopleList();
foreach (var person in peopleList)
{
dataGridView1.Rows.Add();
}
var j = 0;
foreach (var person in peopleList)
{
dataGridView1.Rows[j].Cells["Id"].Value = person.Id;
dataGridView1.Rows[j].Cells["SurName"].Value = person.SurName ?? "";
dataGridView1.Rows[j].Cells["Name"].Value = person.Name ?? "";
dataGridView1.Rows[j].Cells["Patronymic"].Value = person.Patronymic ?? "";
dataGridView1.Rows[j].Cells["Organization"].Value = person.Organization ?? "";
dataGridView1.Rows[j].Cells["Position"].Value = person.Position ?? "";
dataGridView1.Rows[j].Cells["Email"].Value = person.Email ?? "";
dataGridView1.Rows[j++].Cells["NumberPhone"].Value = person.NumberPhone ?? "";
}
}
