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());
}
}
}
