public void RemoveUser(string username)
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
Users user = db.Users.Find(username);
db.Users.Remove(user);
db.SaveChanges();
}
}
public void AddUser(User user)
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
Users dbUser = JsonConvert.DeserializeObject <Users>(JsonConvert.SerializeObject(user));
db.Users.Add(dbUser);
db.SaveChanges();
}
}
public File GetFileByName(string name)
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
Files fileInDB = (from f in db.Files
where f.FileName == name
select f).FirstOrDefault();
return(DBUtils.FilesToFile(fileInDB));
}
}
public void GetAllUsers()
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
Console.WriteLine("Users:");
foreach (Users user in db.Users)
{
Console.WriteLine(user.UserName);
}
}
}
public void AddFilesByUser(List <File> files)
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
foreach (File file in files)
{
Files dbFile = JsonConvert.DeserializeObject <Files>(JsonConvert.SerializeObject(file));
db.Files.Add(dbFile);
}
db.SaveChanges();
}
}
public List <File> GetAllFiles()
{
List <File> files = new List <File>();
using (TorrentDBEntities db = new TorrentDBEntities())
{
foreach (Files f in db.Files)
{
files.Add(DBUtils.FilesToFile(f));
}
}
return(files);
}
public void RemoveFilesByUserName(string username)
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
foreach (Files file in db.Files)
{
if (file.Username.Equals(username))
{
db.Files.Remove(file);
}
}
db.SaveChanges();
}
}
public int GetAmountOfActiveUsers()
{
TorrentDBEntities db = new TorrentDBEntities();
int count = 0;
foreach (Users user in db.Users)
{
if (user.Connected == true)
{
count++;
}
}
return(count);
}
public void ClearAll()
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
foreach (Users user in db.Users)
{
db.Users.Remove(user);
}
foreach (Files file in db.Files)
{
db.Files.Remove(file);
}
db.SaveChanges();
}
}
public User GetUserByUsername(string userName)
{
User userResult = null;
using (TorrentDBEntities db = new TorrentDBEntities())
{
Users receivedUser = (from user in db.Users
where user.UserName.Equals(userName)
select user).FirstOrDefault();
if (receivedUser != null)
{
userResult = DBUtils.UsersToUser(receivedUser);
}
}
return(userResult);
}
public List <File> GetAllFileSharingReferencesByFileName(string fileName)
{
List <File> files = new List <File>();
using (TorrentDBEntities db = new TorrentDBEntities())
{
var filesReceived = from file in db.Files
where file.FileName == fileName
select file;
foreach (Files dbFile in filesReceived)
{
File file = JsonConvert.DeserializeObject <File>(JsonConvert.SerializeObject(dbFile));
files.Add(file);
}
}
return(files);
}
public void UpdateUser(User updatedUser, string existingUsername)
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
var receivedUser = db.Users.Find(existingUsername);
//var receivedUser = (from user in db.Users
// where user.UserName.Equals(updatedUser.UserName)
// select user).Single();
receivedUser.UserName = updatedUser.UserName;
receivedUser.Password = updatedUser.Password;
receivedUser.Enabled = updatedUser.Enabled;
receivedUser.Connected = updatedUser.Connected;
receivedUser.IP = updatedUser.IP;
receivedUser.Port = updatedUser.Port;
db.SaveChanges();
}
}
public void AddFile()
{
using (TorrentDBEntities db = new TorrentDBEntities())
{
try
{
Files file = new Files();
file.Id = 1;
file.FileName = "filename";
file.Size = 123;
db.Files.Add(file);
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("Exception = " + e.StackTrace);
}
}
}
public int GetAmountOfUsers()
{
TorrentDBEntities db = new TorrentDBEntities();
return(db.Users.Count());
}
public int GetAmountOfFiles()
{
TorrentDBEntities db = new TorrentDBEntities();
return(db.Files.Count());
}