public void IntegrationCheckAddToDatabase()
{
string table = "users";
string login = "******";
string password = "******";
string name = "name1231112";
int expID = 100;
//var mock = new Mock<InteractionDB>();
string connectionStr = "server = localhost;user = root; database = test_pm_database; password = root";
//string connectionStr = "server=localhost;user=root;database=PM_DB;password=root";
MySqlConnection connection = new MySqlConnection(connectionStr);
connection.Close();
connection.Open();
//string commandStr = "create table users ( id INT, login varchar(50), username varchar(30), pass varchar(100)); ";
//MySqlCommand command = new MySqlCommand("drop table users", connection);
//MySqlCommand command = new MySqlCommand(commandStr, connection);
InteractionDB interactionDB = new InteractionDB(connection);
bool rez = interactionDB.AddToDB(table, "'" + login + "','" + name + "','" + password + "'");
connection.Open();
MySqlCommand command = new MySqlCommand("Select * from " + table + " where login = '******' and pass = '******'", connection);
MySqlDataReader reader = command.ExecuteReader();
Assert.IsTrue(rez, "Function AddToDB returned value 'false'");
Assert.IsTrue(reader.Read(), "User exist in table ");
connection.Close();
}
private void butComplete_Click(object sender, EventArgs e)
{
try
{
Client cl = Client.getInstance();
int ID = InteractionDB.CountNextID();
DateTime DateOfBirth = DateTime.Parse(textBoxDateOfBirth.Text);
DateTime PassportDate = DateTime.Parse(textBoxPassportDate.Text);
string gender;
if (checkBoxFemale.Checked == true)
{
gender = "женский";
}
else
{
gender = "мужской";
}
string education = null;
foreach (object item in checkedListBoxEducation.SelectedItems)
{
education += item.ToString();
education += "/";
}
switch (checkedListBoxFamily.SelectedIndex)
{
case 0:
Family = "Женат/Замужем";
break;
case 1:
Family = "Холост/Не замужем";
break;
case 2:
Family = "Гражданский брак";
break;
case 3:
Family = "Разведен/Разведена";
break;
case 4:
Family = "Вдова/Вдовец";
break;
}
cl.CreateSQLQuery(textBoxLogin.Text, textBoxPassword.Text, textBoxSurname.Text, textBoxName.Text, textBoxPatronymic.Text,
DateOfBirth, textBoxPlaceOfBirth.Text, textBoxINN.Text, gender, textBoxPassportSeries.Text, textBoxPassportNumber.Text,
PassportDate, textBoxPassportCode.Text, textBoxPassportPlace.Text, textBoxPhoneNumber.Text, textBoxHomeNumber.Text,
textBoxEmail.Text, education, Family, textBoxAdressIndex.Text, textBoxAdressRegion.Text, textBoxAdressArea.Text, textBoxAdressCity.Text);
InteractionDB.AddClient(cl);
this.Close();
AuthLink.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show("Проверьте вводимые значения!", "Ошибка при выполнении");
}
}
public void IntegrationCheckGetUserByID()
{
string table = "users";
string login = "******";
string password = "******";
string name = "name112";
int expID = 100;
string connectionStr = "server = localhost;user = root; database = test_pm_database; password = root";
MySqlConnection connection = new MySqlConnection(connectionStr);
connection.Close();
connection.Open();
string commandStr = "insert into users(id, login, pass, username) values (" + expID.ToString() + ",'" + login + "','" + password + "','" + name + "'";
InteractionDB interactionDB = new InteractionDB(connection);
int rez = interactionDB.GetIDByUsername(name);
Assert.AreEqual(rez, expID, "expID is {0} but no {1}", expID, rez);
connection.Close();
}
