public Info_about_way()
{
Id = 0;
User_main = new Registration();
Way_info = new Way();
Companion = new Collection<Registration>();
On_me = new Collection<int>();
}
public void AddRegistration(Registration obj)
{
using (var connection1 = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSQL"].ToString()))
{
using (var command1 = new SqlCommand(String.Format(@"INSERT INTO Registration
(Name_user, SurName_user, Phone_number,Email, Login,Password)
Values(@Name_user, @SurName_user, @Phone_number, @Email,@Login,@Password)
")))
{
command1.Parameters.AddWithValue("@Name_user", obj.Name_user);
command1.Parameters.AddWithValue("@SurName_user", obj.SurName_user);
command1.Parameters.AddWithValue("@Phone_number", obj.Phone_number);
command1.Parameters.AddWithValue("@Email", obj.Email);
command1.Parameters.AddWithValue("@Login", obj.Login);
command1.Parameters.AddWithValue("@Password", obj.Password);
command1.Connection = connection1;
connection1.Open();
command1.ExecuteNonQuery();
}
}
}
public Registration return_infa_user(int par)
{
Registration obj = null;
using (var connection1 = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSQL"].ToString()))
{
connection1.Open();
using (var command1 = new SqlCommand(String.Format("SELECT * FROM Registration WHERE ID_USER_proect =" + par)))
{
command1.Connection = connection1;
using (var reader = command1.ExecuteReader())
{
if (reader.Read())
{
obj = new Registration(Convert.ToInt32(reader["ID_USER_proect"].ToString()),
(reader["Name_user"].ToString()),
(reader["SurName_user"].ToString()),
(reader["Phone_number"].ToString()),
(reader["Email"].ToString()),
(reader["Login"].ToString()),
(reader["Password"].ToString()));
}
}
}
}
return obj;
}