public List <DomainModel.TransferFile> GetSearchedFiles(string fileName) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { var a = miniTorentDB.UsersTransferFiles .Where(f => f.TransferFile.FileName.Contains(fileName) && f.User.LogIn.Equals(true)) .GroupBy(u => u.TransferFileID) .Select(g => new DomainModel.TransferFile { FileName = g.First().TransferFile.FileName, FileSize = g.First().TransferFile.FileSize.GetValueOrDefault(), ResourcesNumber = g.Count() }); var b = miniTorentDB.TransferFiles .Where(f => f.FileName.Contains(fileName) && !a.Any(r => r.FileName.Equals(f.FileName))) .Select(t => new DomainModel.TransferFile { FileName = t.FileName, FileSize = t.FileSize.GetValueOrDefault(), ResourcesNumber = 0 }) .ToList(); var d = a.ToList(); d.AddRange(b); return(d); } }
public bool AddNewUser(string userName, string password) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { var checkUser = miniTorentDB.Users .FirstOrDefault(u => u.UserName.Equals(userName)); if (checkUser == null) { var newUser = new User { UserName = userName, Password = password, LogIn = false, Enable = true }; miniTorentDB.Users.InsertOnSubmit(newUser); miniTorentDB.SubmitChanges(); return(true); } else { return(false); } } }
public int GetFilesAmount() { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"] .ConnectionString)) { return(miniTorentDB.TransferFiles.Count()); } }
public void LogoutFlag(string userName) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { var user = miniTorentDB.Users .FirstOrDefault(u => u.UserName.Equals(userName)); user.LogIn = false; miniTorentDB.SubmitChanges(); } }
public int GetOnlineUsers() { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"] .ConnectionString)) { return(miniTorentDB.Users .Count(u => u.LogIn.Equals(true))); } }
public List <string> GetListOfResources(string fileName) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { return(miniTorentDB.UsersTransferFiles .Where(f => f.TransferFile.FileName.Equals(fileName) && f.User.LogIn.Equals(true)) .Select(u => u.User.IP) .ToList()); } }
//without treatment in Enable property public DomainModel.User AdminGetUser(string userName) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { return(miniTorentDB.Users .Where(u => u.UserName.Equals(userName)) .Select(u => new DomainModel.User { UserName = u.UserName, Password = u.Password, EnableDisable = (bool)u.Enable }) .FirstOrDefault()); } }
public List <DomainModel.TransferFile> GetMyFiles(string userName) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { return(miniTorentDB.UsersTransferFiles .Where(u => u.User.UserName.Equals(userName)) .Select(u => new DomainModel.TransferFile { FileName = u.TransferFile.FileName, FileSize = u.TransferFile.FileSize.GetValueOrDefault() }) .ToList()); } }
public void DeleteUser(string userName) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { var usersTransferFilesToDelete = miniTorentDB.UsersTransferFiles .Where(u => u.User.UserName.Equals(userName)) .ToList(); foreach (var line in usersTransferFilesToDelete) { miniTorentDB.GetTable <UsersTransferFile>().DeleteOnSubmit(line); } var userToDelete = miniTorentDB.Users .FirstOrDefault(u => u.UserName.Equals(userName)); miniTorentDB.GetTable <User>().DeleteOnSubmit(userToDelete); miniTorentDB.SubmitChanges(); } }
public void UpdateUserTransferFiles(string fileName, string userName) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { var userId = miniTorentDB.Users .Where(u => u.UserName.Equals(userName)) .Select(u => u.ID) .FirstOrDefault(); var fileId = miniTorentDB.TransferFiles .Where(f => f.FileName.Equals(fileName)) .Select(f => f.ID) .FirstOrDefault(); var a = new UsersTransferFile(); a.UserID = userId; a.TransferFileID = fileId; miniTorentDB.UsersTransferFiles.InsertOnSubmit(a); miniTorentDB.SubmitChanges(); } }
public bool AdminUpdateUser(string oldUserName, string newUserName, string password, bool enable) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { if (oldUserName != newUserName) { var checkUser = miniTorentDB.Users .FirstOrDefault(u => u.UserName.Equals(newUserName)); if (checkUser != null) { return(false); } } var user = miniTorentDB.Users .FirstOrDefault(u => u.UserName.Equals(oldUserName)); user.UserName = newUserName; user.Password = password; user.Enable = enable; miniTorentDB.SubmitChanges(); return(true); } }
public bool SetUserDetails(string oldUserName, string newUserName, string password, string ip, string port) { using (var miniTorentDB = new MiniTorrentDBDataContext(ConfigurationManager.ConnectionStrings["MiniTorrentConnection"].ConnectionString)) { if (oldUserName != newUserName) { var checkUser = miniTorentDB.Users .FirstOrDefault(u => u.UserName.Equals(newUserName)); if (checkUser != null) { return(false); } } var user = miniTorentDB.Users .FirstOrDefault(u => u.UserName.Equals(oldUserName)); user.UserName = newUserName; user.Password = password; user.IP = ip; user.PORT = int.Parse(port); miniTorentDB.SubmitChanges(); return(true); } }