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