public static void insertNewPosts(List <PostModel> Posts, string friend)
{
for (int j = 0; j < Posts.Count; j++)
{
MySqlOperations.InsertIntoTable("INSERT INTO `vk_app`.`friendsposts` (`FriendID`, `PostID`, `CountLikes`, `Date`, `Text`) VALUES (" + @friend + "," + @Posts[j].id + "," + @Posts[j].likesCount + ", '" + @Posts[j].Date.ToString("yyyy-MM-dd HH:mm:ss") + "', '" + @Posts[j].text + "');");
}
}
public static void insertMainUser(UserModel user)
{
MySqlOperations.InsertIntoTable("INSERT INTO `vk_app`.`user` (`UserID`,`FirstName`,`SecondName`) VALUES (" + @user.Id + ",'" + @user.FirstName + "','" + @user.LastName + "');");
for (int j = 0; j < user.Posts.Count; j++)
{
MySqlOperations.InsertIntoTable("INSERT INTO `vk_app`.`userposts` (`userId`, `postId`, `CountLikes`, `Date`, `postText`) VALUES (" + @user.Id + ", " + @user.Posts[j].id + ", " + @user.Posts[j].likesCount + ", '" + @user.Posts[j].Date.ToString("yyyy-MM-dd HH:mm:ss") + "', '" + @user.Posts[j].text + "');");
}
}
public static void insertFriends(List <UserModel> friends)
{
for (int i = 0; i < friends.Count; i++)
{
MySqlOperations.InsertIntoTable("INSERT INTO `vk_app`.`friends` (`FriendID`, `FirstName`, `SecondName`, `City`, `OwnerId`) VALUES (" + @friends[i].Id + ",'" + @friends[i].FirstName + "', '" + @friends[i].LastName + "', '" + @friends[i].City + "'," + @friends[i].ownerId + ");");
for (int j = 0; j < friends[i].Posts.Count; j++)
{
MySqlOperations.InsertIntoTable("INSERT INTO `vk_app`.`friendsposts` (`FriendID`, `PostID`, `CountLikes`, `Date`, `Text`) VALUES (" + @friends[i].Id + "," + @friends[i].Posts[j].id + "," + @friends[i].Posts[j].likesCount + ", '" + @friends[i].Posts[j].Date.ToString("yyyy-MM-dd HH:mm:ss") + "', '" + @friends[i].Posts[j].text + "');");
}
}
}
public static void DeleteFriendPosts(string friendID)
{
MySqlOperations.InsertIntoTable("DELETE FROM friendsposts where FriendID =" + @friendID + "");
}
public static void InsertNewUsers(string mainUser, string friendId)
{
MySqlOperations.InsertIntoTable("INSERT INTO `vk_app`.`friends` (`FriendID`, `OwnerId`) VALUES (" + @friendId + ", " + @mainUser + ")");
}
public static DataTable ReturnIdFriendsCount()
{
return(MySqlOperations.GetData("Select count(FriendID) from friends"));
}
public static DataTable ReturnIdFriends()
{
return(MySqlOperations.GetData("SELECT FriendID from friends"));
}
public static DataTable ReturnUserName(string id)
{
return(MySqlOperations.GetData("SELECT FirstName FROM user WHERE UserID = " + @id));
}