public ActionResult Edit(EditM model)
{
// Model validation.
if (!ModelState.IsValid)
{
return(View(model));
}
// Extraction of the inputted user data.
User item = new User
{
Id = model.Id,
Username = model.Username,
Password = model.Password,
FirstName = model.FirstName,
LastName = model.LastName
};
// Saving (inserting/updating) the user in the database.
UsersRepo usersRepo = new UsersRepo();
usersRepo.Save(item);
return(RedirectToAction("Index", "Users"));
}
public ActionResult Game(GamesCycle gc)
{
GamesCycle editGc = gamesRepo.GetGameCycleById(gc.CycleId);
var leagueId = editGc.Stage.LeagueId;
var unionId = editGc.Stage.League.UnionId;
var seasonId = editGc.Stage.League.SeasonId;
var uRepo = new UsersRepo();
if (unionId != null)
{
ViewBag.Referees = uRepo.GetUnionAndLeageReferees(unionId.Value, leagueId);
var aRepo = new AuditoriumsRepo();
if (seasonId.HasValue)
{
//if season id has value get all arena's by season id
ViewBag.Auditoriums = aRepo.GetByUnionAndSeason(unionId.Value, seasonId.Value);
}
else
{
ViewBag.Auditoriums = aRepo.GetAll(unionId.Value);
}
}
return(PartialView("_Game", editGc));
}
private void редактироватьДанныеПрофиляToolStripMenuItem_Click(object sender, EventArgs e)
{
if (new SignInForm(_currentUser).ShowDialog(this) == DialogResult.OK)
{
CurrentUserLabel.Text = "Пользователь : " + UsersRepo.GetUser(_currentUser.UserId).UserFullName;
}
}
protected BaseUserController(ULearnDb db)
{
this.db = db;
userManager = new ULearnUserManager(db);
usersRepo = new UsersRepo(db);
metricSender = new GraphiteMetricSender("web");
secretForHashes = WebConfigurationManager.AppSettings["ulearn.secretForHashes"] ?? "";
var spamEndpoint = WebConfigurationManager.AppSettings["ulearn.spam.endpoint"] ?? "";
var spamLogin = WebConfigurationManager.AppSettings["ulearn.spam.login"] ?? "ulearn";
var spamPassword = WebConfigurationManager.AppSettings["ulearn.spam.password"] ?? "";
spamChannelId = WebConfigurationManager.AppSettings["ulearn.spam.channels.emailConfirmations"] ?? "";
spamTemplateId = WebConfigurationManager.AppSettings["ulearn.spam.templates.withButton"] ?? "";
try
{
spamClient = new SpamClient(new Uri(spamEndpoint), spamLogin, spamPassword);
}
catch (Exception e)
{
log.Error($"Can\'t initialize Spam.API client to {spamEndpoint}, login {spamLogin}, password {spamPassword.MaskAsSecret()}", e);
throw;
}
}
public void InsertUser()
{
var userRepo = new UsersRepo();
const string user = "";
const string password = "";
const string email = "";
var hash = PasswordUtility.HashPassword(password);
var userObject = new User
{
UserName = user,
Email = email,
PasswordHash = hash,
IsTempPassword = false,
LockoutEnabled = false,
LockoutEndDate = DateTime.MaxValue,
AccessFailCount = 0,
CreatedBy = "",
ModifiedBy = "",
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
var result = userRepo.InsertUser(userObject);
Assert.IsFalse(string.IsNullOrEmpty(result.UserId));
}
protected override void Seed(ULearnDb db)
{
var roleStore = new RoleStore <IdentityRole>(db);
var roleManager = new RoleManager <IdentityRole>(roleStore);
roleManager.Create(new IdentityRole(LmsRoles.SysAdmin.ToString()));
var userStore = new UserStore <ApplicationUser>(db);
var manager = new ULearnUserManager(userStore);
if (!db.Users.Any(u => u.UserName == "user"))
{
var user = new ApplicationUser {
UserName = "******", FirstName = "User", LastName = ""
};
manager.Create(user, "asdasd");
}
if (!db.Users.Any(u => u.UserName == "admin"))
{
var user = new ApplicationUser {
UserName = "******", FirstName = "System Administrator", LastName = ""
};
manager.Create(user, "fullcontrol");
manager.AddToRole(user.Id, LmsRoles.SysAdmin.ToString());
}
var usersRepo = new UsersRepo(db);
usersRepo.CreateUlearnBotUserIfNotExists();
db.SaveChanges();
}
public async Task <User> AuthenticateAsync(string username, string password)
{
var user = await UsersRepo.ReadAsync(username);
if (user == null)
{
return(null);
}
var success = PasswordService.ValidatePassword(password, user.HashedPassword);
password = null;
if (!success)
{
return(null);
}
user.Token = TokenService.GenerateToken(user.Id);
user.Password = null;
user.HashedPassword = null;
return(user);
}
public FormUpdateUsers(DelegateClassForUsers.GridDelegate udg, Users u)
{
InitializeComponent();
this.udg = udg;
this.u = u;
URepo = new UsersRepo();
}
public UnitController()
{
db = new ULearnDb();
courseManager = WebCourseManager.Instance;
usersRepo = new UsersRepo(db);
userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new ULearnDb()));
}
// GET: Search
public ActionResult Index()
{
var vm = new SearchViewModel();
vm.IsSearchLeagueVisible = true;
vm.IsSearchTeamVisible = true;
vm.IsSearchPlayerVisible = true;
if (User.IsInRole(AppRole.Workers))
{
var usersRepo = new UsersRepo();
int userId = base.AdminId;
var roleName = usersRepo.GetTopLevelJob(userId);
switch (roleName)
{
case JobRole.LeagueManager:
vm.IsSearchLeagueVisible = false;
break;
case JobRole.TeamManager:
vm.IsSearchLeagueVisible = false;
vm.IsSearchTeamVisible = false;
break;
}
}
return(View(vm));
}
public ActionResult Info()
{
var id = Request.QueryString["id"];
var model = UsersRepo.Info(id);
return(View(model));
}
public bool IsRegistered(string email, string pass)
{
UsersRepo ur = new UsersRepo();
var result = ur.RetrieveRegistered(email, pass);
return(result);
}
public Bot(string channel, string token, BotSettings botSettings)
{
commandManager = new();
pointsManager = new();
userManager = new();
settings = botSettings;
ConnectionCredentials credentials = new ConnectionCredentials(channel, token);
var clientOptions = new ClientOptions
{
MessagesAllowedInPeriod = 750,
ThrottlingPeriod = TimeSpan.FromSeconds(1)
};
WebSocketClient customClient = new WebSocketClient(clientOptions);
client = new TwitchClient(customClient);
client.Initialize(credentials, channel);
client.OnLog += Client_OnLog;
client.OnJoinedChannel += Client_OnJoinedChannel;
client.OnMessageReceived += Client_OnMessageReceived;
client.OnWhisperReceived += Client_OnWhisperReceived;
client.OnNewSubscriber += Client_OnNewSubscriber;
client.OnConnected += Client_OnConnected;
client.Connect();
}
public ActionResult Login(LoginM model)
{
// Model validation.
if (!ModelState.IsValid)
{
return(View(model));
}
// Authentication validation.
UsersRepo usersRepo = new UsersRepo();
User user = usersRepo.GetFirstOrDefault(u => u.Username == model.Username &&
u.Password == model.Password);
// In case of invalid authentication.
if (user == null)
{
ModelState.AddModelError("authFailed", "Invalid username or password!");
return(View(model));
}
// In case of valid authentication.
Session["loggedUser"] = user;
return(RedirectToAction("Index", "Home"));
}
public async Task CreateUserAsync(User user)
{
user.HashedPassword = PasswordService.HashPassword(user.Password);
user.Password = null;
await UsersRepo.CreateAsync(user);
user.HashedPassword = null;
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req,
ILogger log)
{
List <UserDTO> Users = UsersRepo.GetAll().Select(u => new UserDTO(u)).ToList();
return(new OkObjectResult(Users));
}
public void OnGet()
{
Cookbooks = CookbooksRepo.Get().ToList();
foreach (Cookbook cookbook in Cookbooks)
{
cookbook.User = UsersRepo.Get(cookbook.UserId);
}
}
// #region Functional Methods
// public List<Users> GetAllUsers()
// {
// List<Users> resultSet = new List<Users>();
// IDbCommand cmd = this.conn.CreateCommand();
// cmd.Connection = this.conn;
// cmd.CommandText = @"
//SELECT
// userid,
// username,
// pass,
// fname,
// lname
//FROM
// Users
//";
// try
// {
// this.conn.Open();
// IDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// resultSet.Add(new Users()
// {
// UserId = Convert.ToInt32(reader["userid"]),
// Username = Convert.ToString(reader["username"]),
// Pass = Convert.ToString(reader["pass"]),
// FName = Convert.ToString(reader["fname"]),
// LName = Convert.ToString(reader["lname"]),
// });
// reader.Close();
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message,
// "Database operation Failed",
// MessageBoxButtons.OK,
// MessageBoxIcon.Asterisk,
// MessageBoxDefaultButton.Button1);
// }
// finally
// {
// this.conn.Close();
// }
// return resultSet;
// }
// private void NewUser(Users user)
// {
// IDbCommand cmd = this.conn.CreateCommand();
// cmd.CommandText = @"
//INSERT INTO Users
//(
// username,
// pass,
// fname,
// lname
//)
//VALUES
//(
// @username,
// @pass,
// @fname,
// @lname
//)
//";
// IDbDataParameter param = cmd.CreateParameter();
// param.ParameterName = "@username";
// param.Value = user.Username;
// cmd.Parameters.Add(param);
// param = cmd.CreateParameter();
// param.ParameterName = "@pass";
// param.Value = user.Pass;
// cmd.Parameters.Add(param);
// param = cmd.CreateParameter();
// param.ParameterName = "@fname";
// param.Value = user.FName;
// cmd.Parameters.Add(param);
// param = cmd.CreateParameter();
// param.ParameterName = "@lname";
// param.Value = user.LName;
// cmd.Parameters.Add(param);
// try
// {
// this.conn.Open();
// cmd.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// MessageBox.Show("User was NOT persisted correctly." + Environment.NewLine + ex.Message, "Persistance failed!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
// }
// finally
// {
// this.conn.Close();
// }
// }
// private void EditUser(Users user)
// {
// IDbCommand cmd = this.conn.CreateCommand();
// cmd.CommandText = @"
//UPDATE Users SET
// username = @username,
// pass = @pass,
// fname = @fname,
// lname = @lname
//WHERE
// userid = @userid
//";
// IDbDataParameter param = cmd.CreateParameter();
// param.ParameterName = "@username";
// param.Value = user.Username;
// cmd.Parameters.Add(param);
// param = cmd.CreateParameter();
// param.ParameterName = "@pass";
// param.Value = user.Pass;
// cmd.Parameters.Add(param);
// param = cmd.CreateParameter();
// param.ParameterName = "@fname";
// param.Value = user.FName;
// cmd.Parameters.Add(param);
// param = cmd.CreateParameter();
// param.ParameterName = "@lname";
// param.Value = user.LName;
// cmd.Parameters.Add(param);
// param = cmd.CreateParameter();
// param.ParameterName = "@userid";
// param.Value = user.UserId;
// cmd.Parameters.Add(param);
// try
// {
// this.conn.Open();
// cmd.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// MessageBox.Show("User was NOT persisted correctly." + Environment.NewLine + ex.Message, "Persistance failed!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
// }
// finally
// {
// this.conn.Close();
// }
// }
// private void DeleteUser(Users user)
// {
// IDbCommand cmd = this.conn.CreateCommand();
// cmd.CommandText = @"
//DELETE FROM Users
//WHERE
// userid = @userid
//";
// IDbDataParameter param = cmd.CreateParameter();
// param.ParameterName = "@userid";
// param.Value = user.UserId;
// cmd.Parameters.Add(param);
// try
// {
// this.conn.Open();
// cmd.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// MessageBox.Show("User was NOT deleted correctly." + Environment.NewLine + ex.Message, "Delete failed!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
// }
// finally
// {
// this.conn.Close();
// }
// }
// #endregion
#region Old
private void SetDataSources()
{
this.dataGridView1.Refresh();
UsersRepo frm = new UsersRepo();
usersBindingSource.DataSource = frm.GetAll();
dataGridView1.DataSource = usersBindingSource;
this.dataGridView1.Refresh();
}
public AnalyticsController(CourseManager courseManager)
{
this.courseManager = courseManager;
additionalScoresRepo = new AdditionalScoresRepo(db);
userSolutionsRepo = new UserSolutionsRepo(db);
groupsRepo = new GroupsRepo(db);
usersRepo = new UsersRepo(db);
visitsRepo = new VisitsRepo(db);
}
public FormAdmin()
{
InitializeComponent();
URepo = new UsersRepo();
LoadFormSalesman();
LoadFormSoldItem();
CustomizeDesign();
fs.btnLogout.Visible = false;
}
//Delete
public ActionResult Delete(int id)
{
UsersRepo usersRepo = new UsersRepo();
User user = usersRepo.GetById(id);
usersRepo.Delete(user);
return(RedirectToAction("Index", "Users"));
}
public StepikController(CourseManager courseManager, StepikRepo stepikRepo, NotificationsRepo notificationsRepo, UsersRepo usersRepo)
{
this.stepikRepo = stepikRepo;
this.notificationsRepo = notificationsRepo;
this.usersRepo = usersRepo;
this.courseManager = courseManager;
stepikClientId = WebConfigurationManager.AppSettings["stepik.clientId"];
stepikClientSecret = WebConfigurationManager.AppSettings["stepik.clientSecret"];
defaultXQueueName = WebConfigurationManager.AppSettings["stepik.defaultXQueueName"];
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (Assets.Scripts.Pesel.PESEL(check.Text))
{
Users user = new Users(Assets.Scripts.Login.UserLogin, User.Money);
UsersRepo.Update(user, 100);
check.Text = "";
SetData();
}
}
public ActionResult AddExistingUser(Workers frm)
{
var uRepo = new UsersRepo();
var usr = uRepo.GetById(frm.UserId);
ViewBag.SeasonId = frm.SeasonId;
if (usr == null || usr.FullName != frm.FullName)
{
ModelState.AddModelError("FullName", Messages.UserNotExists);
return(PartialView("_WorkerList", GetWorkerVMByRelevantEntity(frm.RelevantEntityId, frm.RelevantEntityLogicalName, frm.SeasonId, frm.LeagueId)));
}
var uJob = new UsersJob
{
JobId = frm.JobId,
UserId = usr.UserId,
SeasonId = frm.SeasonId,
LeagueId = (frm.LeagueId == 0 ? (int?)null : frm.LeagueId)
};
switch (frm.RelevantEntityLogicalName)
{
case LogicaName.Union:
uJob.UnionId = frm.RelevantEntityId;
break;
case LogicaName.League:
uJob.LeagueId = frm.RelevantEntityId;
break;
case LogicaName.Team:
uJob.TeamId = frm.RelevantEntityId;
break;
case LogicaName.Club:
uJob.ClubId = frm.RelevantEntityId;
break;
}
var jobsRepo = new JobsRepo();
if (jobsRepo.IsUserInJob(frm.RelevantEntityLogicalName, frm.RelevantEntityId, uJob.JobId, usr.UserId))
{
ModelState.AddModelError("FullName", Messages.UserAlreadyHasThisRole);
return(PartialView("_WorkerList", GetWorkerVMByRelevantEntity(frm.RelevantEntityId, frm.RelevantEntityLogicalName, frm.SeasonId, frm.LeagueId)));
}
jobsRepo.AddUsersJob(uJob);
jobsRepo.Save();
TempData["SavedId"] = uJob.UserId;
return(PartialView("_WorkerList", GetWorkerVMByRelevantEntity(frm.RelevantEntityId, frm.RelevantEntityLogicalName, frm.SeasonId, frm.LeagueId)));
}
private static void Main()
{
TaskScheduler.UnobservedTaskException +=
(sender, args) => Console.WriteLine($"Unobserved ex {args.Exception}");
_settings = ReadConfiguration();
var yandexDictionaryClient = new YandexDictionaryApiClient(_settings.YadicapiKey, _settings.YadicapiTimeout);
var yandexTranslateApiClient = new YandexTranslateApiClient(_settings.YatransapiKey, _settings.YatransapiTimeout);
var client = new MongoClient(_settings.MongoConnectionString);
var db = client.GetDatabase("SayWhatDb");
var userWordRepo = new UserWordsRepo(db);
var dictionaryRepo = new DictionaryRepo(db);
var userRepo = new UsersRepo(db);
var examplesRepo = new ExamplesRepo(db);
userWordRepo.UpdateDb();
dictionaryRepo.UpdateDb();
userRepo.UpdateDb();
examplesRepo.UpdateDb();
_userWordService = new UsersWordsService(userWordRepo, examplesRepo);
_dictionaryService = new DictionaryService(dictionaryRepo, examplesRepo);
_userService = new UserService(userRepo);
_addWordService = new AddWordService(
_userWordService,
yandexDictionaryClient,
yandexTranslateApiClient,
_dictionaryService,
_userService);
QuestionSelector.Singletone = new QuestionSelector(_dictionaryService);
Console.WriteLine("Dic started");
_botClient = new TelegramBotClient(_settings.TelegramToken);
var me = _botClient.GetMeAsync().Result;
Console.WriteLine(
$"Hello, World! I am user {me.Id} and my name is {me.FirstName}."
);
_botClient.OnUpdate += BotClientOnOnUpdate;
_botClient.OnMessage += Bot_OnMessage;
_botClient.StartReceiving();
// workaround for infinity awaiting
new TaskCompletionSource <bool>().Task.Wait();
// it will never happens
_botClient.StopReceiving();
}
public ActionResult <UserDbModel> GetUser(string username)
{
var user = UsersRepo.SingleOrDefault <UserDbModel>(model => model.Username == username);
if (user == null)
{
return(NotFound());
}
return(Ok(user));
}
public AccountController()
{
db = new ULearnDb();
userManager = new ULearnUserManager(db);
courseManager = WebCourseManager.Instance;
usersRepo = new UsersRepo(db);
userRolesRepo = new UserRolesRepo(db);
groupsRepo = new GroupsRepo(db);
certificatesRepo = new CertificatesRepo(db);
visitsRepo = new VisitsRepo(db);
}
public NotificationsController(ULearnDb db, CourseManager courseManager)
{
notificationsRepo = new NotificationsRepo(db);
usersRepo = new UsersRepo(db);
visitsRepo = new VisitsRepo(db);
userManager = new ULearnUserManager(db);
this.courseManager = courseManager;
telegramBotName = WebConfigurationManager.AppSettings["ulearn.telegram.botName"];
secretForHashes = WebConfigurationManager.AppSettings["ulearn.secretForHashes"] ?? "";
}
public RunnerController(ULearnDb db, CourseManager courseManager)
{
this.db = db;
this.courseManager = courseManager;
userSolutionsRepo = new UserSolutionsRepo(db, courseManager);
slideCheckingsRepo = new SlideCheckingsRepo(db);
visitsRepo = new VisitsRepo(db);
groupsRepo = new GroupsRepo(db, courseManager);
usersRepo = new UsersRepo(db);
metricSender = new MetricSender(ApplicationConfiguration.Read <UlearnConfiguration>().GraphiteServiceName);
}
private void tsMainNew_Click(object sender, EventArgs e)
{
Users item = new Users();
NewUser newUser = new NewUser(item);
if (newUser.ShowDialog() == DialogResult.OK)
{
UsersRepo frm = new UsersRepo();
frm.Save(item);
SetDataSources();
}
}
