private static void UpdateUI(InstagramDataContext instagramDC, string accountName) =>
GetAccountsList().Add
(new VM_Account
{
AccountId = instagramDC.InstagramAccounts.First(m => m.AccountName == accountName).Id,
Title = accountName,
ImageSource = "/Sources/likes_wrap.png"
});
private static void UpdateDB(InstagramDataContext db, InstagramAccount account)
{
if (db.InstagramAccounts.FirstOrDefault(m => m.AccountName == account.AccountName) == null)
{
db.InstagramAccounts.Add(account);
db.SaveChanges();
}
}
private void button19_Click(object sender, EventArgs e)
{
var db = new InstagramDataContext();
var accounts = db.InstagramAccounts;
var account = accounts.Find(1);
MessageBox.Show(account.ToString());
}
private void HashtagFollowing()
{
var follower = new TagFollower();
var vm_account = ((Application.Current.Windows[0] as MainWindow).accountsArea.Content as AccountsView).AccountsView_ListView.SelectedItem as VM_Account;
var db = new InstagramDataContext();
var account = db.InstagramAccounts.First(m => m.AccountName == vm_account.Title);
follower.StartFollow(targetInput.Text, int.Parse(followCountInput.Text), account);
}
private void GeopositionLike()
{
var liker = new LocationLiker();
var vm_account = ((Application.Current.Windows[0] as MainWindow).accountsArea.Content as AccountsView).AccountsView_ListView.SelectedItem as VM_Account;
var db = new InstagramDataContext();
var account = db.InstagramAccounts.First(m => m.AccountName == vm_account.Title);
liker.StartLike(targetInput.Text, int.Parse(likeCountInput.Text), account);
}
private void submitAccountForm_Click(object sender, RoutedEventArgs e)
{
if (Validation())
{
using (var db = new InstagramDataContext())
{
var account = AssembleAccountFromForm();
UpdateDB(db, account);
UpdateUI(db, account.AccountName);
LogAccountsIDsToTxtFile(GetAccountsList());
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
//InstagramApiController api = new InstagramApiController();
//api.Autheticate("test_account_brooler", "TestPassword");
//var client = new RestClient("https://www.instagram.com/");
//client.CookieContainer = new CookieContainer();
//client.UserAgent = USER_AGENT;
//var firstRequest = new RestRequest("/", Method.GET);
//var firstResponse = client.Execute(firstRequest);
//var csrftoken = firstResponse.Cookies.First(x => x.Name == "csrftoken").Value;
//var loginRequest = new RestRequest("/accounts/login/ajax/", Method.POST);
//loginRequest.AddHeader("X-CSRFToken", csrftoken);
//loginRequest.AddHeader("X-Requested-With", "XMLHttpRequest");
//loginRequest.AddHeader("X-Instagram-AJAX", "1");
//loginRequest.AddHeader("Referer", client.BaseUrl.ToString());
//loginRequest.AddParameter("username", "test_account_brooler");
//loginRequest.AddParameter("password", "TestPassword");
//var loginResponse = client.Execute<LoginResponse>(loginRequest).Data;
//var newResponse = client.Execute<LoginResponse>(loginRequest);
//var userRequest = new RestRequest("/users/self", Method.GET);
//userRequest.AddHeader("Referer", client.BaseUrl.ToString());
//var userResponse = client.Execute<object>(userRequest);
//var folowRequest = new RestRequest("/query", Method.POST);
//folowRequest.AddHeader("referer", "https://www.instagram.com/test_account_brooler/");
//folowRequest.AddHeader("X-CSRFToken", csrftoken);
//folowRequest.AddHeader("X-Instagram-AJAX", "1");
//folowRequest.AddHeader("x-requested-with", "XMLHttpRequest");
//folowRequest.AddParameter("q", "ig_user(3236268191) { followed_by.first(10) { count, page_info { end_cursor, has_next_page }, nodes { id, is_verified, followed_by_viewer, requested_by_viewer, full_name, profile_pic_url, username } } }");
//folowRequest.AddParameter("ref", "relationships::follow_list");
//var response = client.Execute(folowRequest);
//MessageBox.Show(newResponse.ToString());
//var scopes = new List<OAuth.Scope>();
//scopes.Add(InstaSharp.OAuth.Scope.Likes);
//scopes.Add(InstaSharp.OAuth.Scope.Comments);
//var config = new InstagramConfig("b68377a3d2794d2c8cc2a63a29209ada", "aa455874beb24fffbb4b1b35baeaf887");
//var link = InstaSharp.OAuth.AuthLink(config.OAuthUri + "authorize", config.ClientId, config.RedirectUri, scopes, InstaSharp.OAuth.ResponseType.Code);
//MessageBox.Show(link);
//var client = new RestClient("https://api.instagram.com/");
//var request = new RestRequest("/v1/users/self/follows", Method.GET);
//request.AddParameter("access_token", "3236268191.b68377a.34bc58d0e7ab4cb7be88322863218486");
//var response = client.Execute(request);
if (Validation())
{
var vm_account = ((Application.Current.Windows[0] as MainWindow).accountsArea.Content as AccountsView).AccountsView_ListView.SelectedItem as VM_Account;
var db = new InstagramDataContext();
var account = db.InstagramAccounts.First(m => m.AccountName == vm_account.Title);
var unfollow = new BotTasks.Unfollow();
unfollow.StartTask(account, followersInput.Text.Split(','));
}
}
static void Main(string[] args)
{
try
{
var cb = new SqlConnectionStringBuilder();
cb.DataSource = "server-1337.database.windows.net";
cb.UserID = "CommonUser"; // read only
cb.Password = "******";
cb.InitialCatalog = "generailDB";
using (InstagramDataContext db = new InstagramDataContext(cb.ConnectionString))
{
#region Select
IEnumerable <string> names =
from u in db.comments
orderby u.id
select u.comment_text;
foreach (string n in names)
{
Console.WriteLine(n);
}
Console.WriteLine();
#endregion
#region Update
/*
* string upUsername = "******";
* user upUser =
* (from u in db.users
* orderby u.id
* where u.id == 1
* select u).Single<user>();
* upUser.username = upUsername;
* Console.WriteLine($"Update id = 1 username to '{upUsername}'");
* Console.WriteLine();
*/
#endregion
#region Insert
/*
* string newUsername = "******";
* user newUser = new user { username = newUsername };
* db.users.InsertOnSubmit(newUser);
* Console.WriteLine($"Insert username to '{newUsername}'");
* Console.WriteLine();
*/
#endregion
#region Delete
/*
* user delUser =
* (from u in db.users
* orderby u.id descending
* select u).First<user>();
* if (delUser != null)
* db.users.DeleteOnSubmit(delUser);
* Console.WriteLine($"Delete Last record");
* Console.WriteLine();
*/
#endregion
db.SubmitChanges();
#region Select
names =
from u in db.users
orderby u.id
select u.username;
foreach (string n in names)
{
Console.WriteLine(n);
}
// Console.WriteLine($"There are {names.Count()} users");
Console.WriteLine();
#endregion
}
#region Select --Association Update--
DataLoadOptions dl = new DataLoadOptions();
dl.LoadWith <user>(u => u.photos);
dl.AssociateWith <user>(u => u.photos.Where(p => true));
using (InstagramDataContext db = new InstagramDataContext(cb.ConnectionString))
{
// db.LoadOptions = dl;
// db.Log = Console.Out;
var users = from u in db.users select u;
foreach (var u in users)
{
Console.WriteLine($"There are {u.photos.Count()} products in category {u.username}");
}
}
# endregion
}
catch (InvalidOperationException e)
{
Console.WriteLine(e.ToString());
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
Console.ReadKey();
}
