private static List <FindPeople.PersonInformation> GetFoindPeopleFromNetworks(string login, string TableName)
{
ConnectToDatabase();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string query = String.Format("SELECT * FROM " + TableName + " WHERE UserLogin=@a");
List <FindPeople.PersonInformation> list = new List <FindPeople.PersonInformation>();
using (SqlCommand comm = new SqlCommand(query, conn))
{
comm.Parameters.AddWithValue("@a", login);
SqlDataReader reader = comm.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
FindPeople.PersonInformation hum = new FindPeople.PersonInformation();
hum.Name = reader.GetValue(1).ToString();
hum.LastName = reader.GetValue(2).ToString();
hum.YearOfBirth = (int)reader.GetValue(3);
List <string> lst = new List <string>();
lst.Add(reader.GetValue(4).ToString());
hum.Cities = SeparateElements(lst);
lst.Clear();
lst.Add(reader.GetValue(5).ToString());
hum.Education = SeparateElements(lst);
list.Add(hum);
}
}
}
return(list);
}
private static string MakeCityRow(FindPeople.PersonInformation pers)
{
string cities = "";
foreach (string a in pers.Education)
{
cities += a + ",";
}
if (!String.IsNullOrEmpty(cities))
{
cities.Remove(cities.Length - 1, 1);
}
return(cities);
}
private static string MakeEducationRow(FindPeople.PersonInformation pers)
{
string education = "";
foreach (string a in pers.Education)
{
education += a + ",";
}
if (!String.IsNullOrEmpty(education))
{
education.Remove(education.Length - 1, 1);
}
return(education);
}
public static void AddFoundPerson(FindPeople.PersonInformation persVK = null, FindPeople.PersonInformation persOK = null)
///Vk = true, значит, ссылка из ВК, в противном случае - из ОК
{
if (persVK != null || persOK != null)
{
if (persVK != null)
{
InsertIntoNetwork(persVK, "FoundPersonsVK");
}
if (persOK != null)
{
InsertIntoNetwork(persOK, "FoundPersonsOK");
}
}
}
private static void InsertIntoNetwork(FindPeople.PersonInformation pers, string tableName)
{
if (!String.IsNullOrEmpty(pers.Name) &&
!String.IsNullOrEmpty(pers.LastName) &&
!String.IsNullOrEmpty(pers.YearOfBirth.ToString()))
{
int buf = -1;
List <FindPeople.PersonInformation> alreadyExist = GetFoundPeople(App.CurrentUserLogin);
foreach (var k in alreadyExist)
{
if (k == pers)
{
buf = 100;
}
}
if (buf == -1)
{
ConnectToDatabase();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string query = String.Format("INSERT INTO " + tableName +
" (UserLogin, FirstName, LastName, BirthData, Cities, " +
"Education, Link) " +
"VALUES (@login, @name, @lastName, @birthData, @cities," +
"@education, @link)");
using (SqlCommand comm = new SqlCommand(query, conn))
{
string cities = "";
string education = "";
comm.Parameters.AddWithValue("@login", App.CurrentUserLogin);
comm.Parameters.AddWithValue("@name", pers.Name);
comm.Parameters.AddWithValue("@lastName", pers.LastName);
comm.Parameters.AddWithValue("@birthData", pers.YearOfBirth);
cities = MakeCityRow(pers);
education = MakeEducationRow(pers);
comm.Parameters.AddWithValue("@cities", cities);
comm.Parameters.AddWithValue("@education", education);
comm.Parameters.AddWithValue("@link", pers.SocialNetwork);
comm.ExecuteNonQuery();
}
}
else
{
throw new Exception("Данная запистьв базе уже существует!");
}
}
}
