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