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