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