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