public bool addNewUser(string userName, string password) { UserInfo newUser = new UserInfo(userName, password); if (!AccountSearch(newUser)) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; User user = new User(); user.Username = userName; user.Password = password; user.isConnected = false; db.Users.InsertOnSubmit(user); db.SubmitChanges(); } return(true); } else { return(false); } }
public List <SearchResult> findListOfFilesByFileName(string fileName) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; var files = from f in db.Files where f.FileName == fileName select f; var sizes = (from f in db.Files where f.FileName == fileName select f.FileSize).Distinct(); List <SearchResult> answer = new List <SearchResult>(); foreach (var size in sizes) { List <String> ips = new List <string>(); foreach (var file in files) { if (file.FileSize == size) { ips.Add(file.IP); } } answer.Add(new SearchResult(fileName, size, ips)); } return(answer); } }
public void DisconnectUser(UserInfo userInfo) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; var user = db.Users.Single(u => u.Username == userInfo.UserName); user.isConnected = false; db.SubmitChanges(); } RemoveUserFiles(userInfo); }
public void ConnectUser(UserInfo userInfo) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; var user = db.Users.Single(u => u.Username == userInfo.UserName); user.isConnected = true; db.SubmitChanges(); } FilesDBClass.Instance.AddUserFileList(userInfo); }
public void AddFileSource(UpdateSourceInfo info) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; File f = new File(); f.FileName = info.Filename; f.FileSize = info.Filesize; f.IP = info.Ip; f.UserName = info.Username; db.Files.InsertOnSubmit(f); db.SubmitChanges(); } }
public void RemoveUserFiles(UserInfo userInfo) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; var files = from f in db.Files where f.UserName == userInfo.UserName select f; foreach (var item in files) { db.Files.DeleteOnSubmit(item); db.SubmitChanges(); } } }
public void AddUserFileList(UserInfo userInfo) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; foreach (KeyValuePair <string, long> file in userInfo.FileDict) { File f = new File(); f.FileName = file.Key; f.FileSize = file.Value; f.IP = userInfo.Ip; f.UserName = userInfo.UserName; db.Files.InsertOnSubmit(f); db.SubmitChanges(); } } }
public bool AccountSearch(UserInfo userInfo) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; var userAccount = from users in db.Users where users.Username == userInfo.UserName select users; if (userAccount.Count() == 0) { return(false); } else { return(true); } } }
public int getNumberOfUsers(bool isConnected) { using (TorrentFreakDBLinkDataContext db = new TorrentFreakDBLinkDataContext()) { db.Connection.ConnectionString = myConnectionString; if (isConnected) { var activeUserAccount = from u in db.Users where u.isConnected == true select u; return(activeUserAccount.Count()); } else { var userAccount = from u in db.Users select u; return(userAccount.Count()); } } }