public AgencyUser SearchAgencyByNameAndPassword(string name, string password) { log.InfoFormat("SearchAgencyByNameAndPassword with values {0} and {0}", name, password); IDbConnection con = DBUtils.getConnection(properties); using (var comm = con.CreateCommand()) { comm.CommandText = "select * from agencyUsers where userName=@name and password=@pass"; IDbDataParameter paramName = comm.CreateParameter(); paramName.ParameterName = "@name"; paramName.Value = name; comm.Parameters.Add(paramName); IDbDataParameter paramPass = comm.CreateParameter(); paramPass.ParameterName = "@pass"; paramPass.Value = password; comm.Parameters.Add(paramPass); using (var dataR = comm.ExecuteReader()) { if (dataR.Read()) { int idV = dataR.GetInt32(0); String name2 = dataR.GetString(1); String password2 = dataR.GetString(2); AgencyUser agencyUser = new AgencyUser(idV, name2, password2); log.InfoFormat("Exiting findOne with value {0}", agencyUser); return(agencyUser); } } } log.InfoFormat("Exiting SearchAgencyByNameAndPassword with value {0} and {0}", name, password); return(null); }
public void Save(AgencyUser entity) { var con = DBUtils.getConnection(properties); using (var comm = con.CreateCommand()) { comm.CommandText = "insert into agencyUsers values (@idT, @name, @pass)"; var paramId = comm.CreateParameter(); paramId.ParameterName = "@idT"; paramId.Value = entity.Id; comm.Parameters.Add(paramId); var paramName = comm.CreateParameter(); paramName.ParameterName = "@name"; paramName.Value = entity.UserName; comm.Parameters.Add(paramName); var paramPass = comm.CreateParameter(); paramPass.ParameterName = "@pass"; paramPass.Value = entity.Password; comm.Parameters.Add(paramPass); var result = comm.ExecuteNonQuery(); if (result == 0) { throw new Exception("No agencyUser added !"); } } }
public IEnumerable <AgencyUser> FindAll() { IDbConnection con = DBUtils.getConnection(properties); IList <AgencyUser> agencyUsers = new List <AgencyUser>(); using (var comm = con.CreateCommand()) { comm.CommandText = "select * from agencyUsers"; using (var dataR = comm.ExecuteReader()) { while (dataR.Read()) { int idV = dataR.GetInt32(0); String name = dataR.GetString(1); String password = dataR.GetString(2); AgencyUser agencyUser = new AgencyUser(idV, name, password); agencyUsers.Add(agencyUser); } } } return(agencyUsers); }
public AgencyUser FindOne(int id) { log.InfoFormat("Entering findOne with value {0}", id); IDbConnection con = DBUtils.getConnection(properties); using (var comm = con.CreateCommand()) { comm.CommandText = "select * from agencyUsers where id=@id"; IDbDataParameter paramId = comm.CreateParameter(); paramId.ParameterName = "@id"; paramId.Value = id; comm.Parameters.Add(paramId); using (var dataR = comm.ExecuteReader()) { if (dataR.Read()) { int idV = dataR.GetInt32(0); String name = dataR.GetString(1); String password = dataR.GetString(2); AgencyUser agencyUser = new AgencyUser(idV, name, password); log.InfoFormat("Exiting findOne with value {0}", agencyUser); return(agencyUser); } } } log.InfoFormat("Exiting findOne with value {0}", null); return(null); }
public async Task <ActionResult> DeleteConfirmed(int id) { AgencyUser agencyuser = await db.AgenciesUsers.FindAsync(id); db.AgenciesUsers.Remove(agencyuser); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <IActionResult> OnPostAsync(string returnUrl = null) { returnUrl = returnUrl ?? Url.Content("~/"); //ExternalLogins = (await _signInManager.GetExternalAuthenticationSchemesAsync()).ToList(); if (ModelState.IsValid) { var worker = new Worker(); await this._workersService.AddAsync(worker); var user = new AgencyUser { UserName = Input.Email, Email = Input.Email, WorkerId = worker.Id }; var result = await _userManager.CreateAsync(user, Input.Password); if (result.Succeeded) { _logger.LogInformation("User created a new account with password."); #region EmailConfirmation // var code = await _userManager.GenerateEmailConfirmationTokenAsync(user); // code = WebEncoders.Base64UrlEncode(Encoding.UTF8.GetBytes(code)); //var callbackUrl = Url.Page( // "/Account/ConfirmEmail", // pageHandler: null, // values: new { area = "Identity", userId = user.Id, code = code, returnUrl = returnUrl }, // protocol: Request.Scheme); //await _emailSender.SendEmailAsync(Input.Email, "Confirm your email", // $"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>."); //if (_userManager.Options.SignIn.RequireConfirmedAccount) //{ // return RedirectToPage("RegisterConfirmation", new { email = Input.Email, returnUrl = returnUrl }); //} //else //{ // await _signInManager.SignInAsync(user, isPersistent: false); // return LocalRedirect(returnUrl); //} #endregion await _signInManager.SignInAsync(user, isPersistent : false); return(LocalRedirect(returnUrl)); } foreach (var error in result.Errors) { ModelState.AddModelError(string.Empty, error.Description); } } // If we got this far, something failed, redisplay form return(Page()); }
public void Logout(AgencyUser agencyUser, IObserver observer) { IObserver localAgencyUser = loggedAgencyUsers[agencyUser.Id]; if (localAgencyUser == null) { throw new TouristAttractiontException("Agency User logged out!"); } loggedAgencyUsers.Remove(agencyUser.Id); }
public async Task <ActionResult> Edit([Bind(Include = "AgencyUserId,AgencyId,Name,Mail,City,Ranking")] AgencyUser agencyuser) { if (ModelState.IsValid) { db.Entry(agencyuser).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.AgencyId = new SelectList(db.Agencies, "AgencyId", "Name", agencyuser.AgencyId); return(View(agencyuser)); }
protected void rptUsers_ItemCommand(object source, RepeaterCommandEventArgs e) { switch (e.CommandName.ToLower()) { case "delete": _agency = Module.AgencyGetById(Convert.ToInt32(Request.QueryString["AgencyId"])); AgencyUser data = Module.AgencyUserGet(_agency, Module.UserGetById(Convert.ToInt32(e.CommandArgument))); Module.Delete(data); rptUsers.DataSource = _agency.Users; rptUsers.DataBind(); break; } }
private void UpdateEntityTimestamps(AgencyUser entity) { // determine whether this is a "new" entity being saved for the first time if (entity.CreatedDateTime == DateTime.MinValue) { entity.CreatedDateTime = DateTime.UtcNow; entity.UpdatedDateTime = null; } else { entity.UpdatedDateTime = DateTime.UtcNow; } }
private void showTripsDialog(AgencyUser agencyUser) { try { tripsForm.SetAgencyUser(agencyUser); tripsForm.Show(); tripsForm.updateRows(); tripsForm.update(); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); } }
// GET: /AgencyUser/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AgencyUser agencyuser = await db.AgenciesUsers.FindAsync(id); if (agencyuser == null) { return(HttpNotFound()); } return(View(agencyuser)); }
// GET: /AgencyUser/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AgencyUser agencyuser = await db.AgenciesUsers.FindAsync(id); if (agencyuser == null) { return(HttpNotFound()); } ViewBag.AgencyId = new SelectList(db.Agencies, "AgencyId", "Name", agencyuser.AgencyId); return(View(agencyuser)); }
//public void Delete(int agencyUserId) //{ // _logger.Debug("Calling repository to delete agency user with Id={0}", agencyUserId); // Collection.Remove(Query<MongoAgencyUser>.EQ(o => o.AgencyUserId, agencyUserId)); // _logger.Debug("Deleted agency user with Id={0}", agencyUserId); //} public AgencyUser Save(AgencyUser entity) { _logger.Debug("Called Mongodb to save agency user with username={0}", entity.Username); SetCreatedDateTime(entity); SetUpdatedDateTime(entity); var mongoEntity = _mapper.Map <AgencyUser, MongoAgencyUser>(entity); Collection.Save(mongoEntity); _logger.Debug("Saved agency user to Mongodb with username={0}", entity.Username); return(_mapper.Map <MongoAgencyUser, AgencyUser>(mongoEntity)); }
private static AgencyUserViewModel GetAgencyUserViewModel(AgencyUser agencyUser, IEnumerable <Role> roles) { if (agencyUser.Role == null) { agencyUser.Role = roles.First(r => r.IsDefault); } return(new AgencyUserViewModel { Roles = GetRolesSelectList(roles, agencyUser.Role.Id), RoleId = agencyUser.Role.Id, RegionalTeams = GetRegionalTeamsSelectList(agencyUser.RegionalTeam), RegionalTeam = agencyUser.RegionalTeam }); }
public static async Task <IdentityResult> CreateUser(AgencyUser user, string password) { var userManager = new UserManager <AgencyUser>( new UserStore <AgencyUser>(new AgencyUserIdentityDbContext())); //Allows for use of email address as username: userManager.UserValidator = new UserValidator <AgencyUser>(userManager) { AllowOnlyAlphanumericUserNames = false }; var idResult = await userManager.CreateAsync(user, password); return(idResult); }
public void Login(AgencyUser agencyUser, IObserver observer) { AgencyUser newAgencyUser = AgencyUserRepository.SearchAgencyByNameAndPassword(agencyUser.UserName, agencyUser.Password); if (newAgencyUser != null) { if (loggedAgencyUsers.ContainsKey(newAgencyUser.Id)) { throw new TouristAttractiontException("Agency User already logged in!"); } loggedAgencyUsers[newAgencyUser.Id] = observer; } else { throw new TouristAttractiontException("Autthetication failed!"); } }
public void Logout(AgencyUser agencyUser, IObserver observer) { sendRequest(new LogoutRequest(agencyUser)); Response response = readResponse(); closeConnection(); if (response is ErrorResponse) { ErrorResponse err = (ErrorResponse)response; throw new TouristAttractiontException(err.Message); } if (response is OkResponse) { this.client = observer; return; } }
public AgencyUserViewModel GetOrCreateAgencyUser(string username) { var agencyUser = _userProfileService.GetAgencyUser(username); var roles = _userProfileService.GetRoles().ToList(); if (agencyUser == null) { agencyUser = new AgencyUser { Username = username, Role = roles.Single(r => r.IsDefault), RegionalTeam = RegionalTeam.North }; agencyUser = _userProfileService.SaveUser(agencyUser); } return(GetAgencyUserViewModel(agencyUser, roles)); }
protected void btnAdd_Click(object sender, EventArgs e) { if (Request.QueryString["AgencyId"] != null) { _agency = Module.AgencyGetById(Convert.ToInt32(Request.QueryString["AgencyId"])); } UserSelector selector = userSelector as UserSelector; if (selector == null) { throw new Exception("Selector error"); } if (selector.SelectedUserId > 0) { AgencyUser data = Module.AgencyUserGet(_agency, Module.UserGetById(selector.SelectedUserId)); rptUsers.DataSource = _agency.Users; rptUsers.DataBind(); } }
public AgencyUser Save(AgencyUser entity) { _logger.Debug("Called SQL DB to save AgencyUser with AgencyUserId={0}", entity.AgencyUserId); UpdateEntityTimestamps(entity); var dbEntity = _mapper.Map <AgencyUser, Entities.AgencyUser>(entity); if (dbEntity.AgencyUserGuid == Guid.Empty) { dbEntity.AgencyUserGuid = Guid.NewGuid(); } // TODO: SQL: AG: consider generalising (and testing) SqlException handling below. try { var result = (int)_getOpenConnection.Insert(dbEntity); dbEntity.AgencyUserId = result; } catch (SqlException e) when(e.Number == 2601) { if (!_getOpenConnection.UpdateSingle(dbEntity)) { throw new Exception("Failed to update record after failed insert", e); } } _logger.Debug("Saved AgencyUser with AgencyUserId={0}", entity.AgencyUserId); var endResult = _mapper.Map <Entities.AgencyUser, AgencyUser>(dbEntity); endResult.Role = entity.Role; endResult.RegionalTeam = entity.RegionalTeam; return(endResult); }
public LogoutRequest(AgencyUser agencyUser) { this.agencyUser = agencyUser; }
public FindAgencyUserResponse(AgencyUser agencyUser) { this.agencyUser = agencyUser; }
private object handleRequest(Request request) { Response response = null; if (request is LoginRequest) { Console.WriteLine("Login request ..."); LoginRequest logReq = (LoginRequest)request; AgencyUser agencyUser = logReq.AgencyUser; try { lock (server) { server.Login(agencyUser, this); } return(new OkResponse()); } catch (TouristAttractiontException e) { connected = false; return(new ErrorResponse(e.Message)); } } if (request is LogoutRequest) { Console.WriteLine("Logout request ..."); LogoutRequest logReq = (LogoutRequest)request; AgencyUser agencyUser = logReq.AgencyUser; try { lock (server) { server.Logout(agencyUser, this); } return(new OkResponse()); } catch (TouristAttractiontException e) { connected = false; return(new ErrorResponse(e.Message)); } } if (request is GetTripsRequest) { Console.WriteLine("Get Trips request"); GetTripsRequest getReq = (GetTripsRequest)request; IEnumerable <Trip> trips; try { lock (server) { trips = server.FindAllTrips(); } return(new GetTripsResponse(trips)); } catch (TouristAttractiontException e) { connected = false; return(new ErrorResponse(e.Message)); } } if (request is GetSearchedTripsRequest) { Console.WriteLine("Find searched trips request"); GetSearchedTripsRequest getReq = (GetSearchedTripsRequest)request; TripDTO tripDTO = getReq.TripDTO; List <Trip> trips; try { lock (server) { trips = (List <Trip>)server.SearchTripByTouristAttractionAndLeavingHour(tripDTO.TouristAttraction, tripDTO.Hour1, tripDTO.Hour2); } return(new GetSearchedTripsResponse(trips)); } catch (TouristAttractiontException e) { connected = false; return(new ErrorResponse(e.Message)); } } if (request is FindAgencyUserRequest) { Console.WriteLine("Finding agency user"); FindAgencyUserRequest findReq = (FindAgencyUserRequest)request; AgencyUserDTO agencyUserDTO = findReq.AgencyUser; AgencyUser agencyUser; try { lock (server) { agencyUser = server.SearchAgencyUserByUserNameAndPassword(agencyUserDTO.userName, agencyUserDTO.password); } return(new FindAgencyUserResponse(agencyUser)); } catch (TouristAttractiontException e) { connected = false; return(new ErrorResponse(e.Message)); } } if (request is AddReservationRequest) { Console.WriteLine("Add Reservation Request"); AddReservationRequest findReq = (AddReservationRequest)request; Reservation reservation = findReq.Reservation; try { lock (server) { server.AddReservation(reservation); } return(new OkResponse()); } catch (TouristAttractiontException e) { connected = false; return(new ErrorResponse(e.Message)); } } if (request is UpdateTripRequest) { Console.WriteLine("Update Trip Request"); UpdateTripRequest findReq = (UpdateTripRequest)request; Trip trip = findReq.Trip; try { lock (server) { server.UpdateTrip(trip); } return(new OkResponse()); } catch (TouristAttractiontException e) { connected = false; return(new ErrorResponse(e.Message)); } } if (request is GetReservsationSizeRequest) { Console.WriteLine("Reservation Size Request"); GetReservsationSizeRequest findReq = (GetReservsationSizeRequest)request; int size = 0; try { lock (server) { size = server.GetReservationsSize(); } return(new GetReservationSizeRespons(size)); } catch (TouristAttractiontException e) { connected = false; return(new ErrorResponse(e.Message)); } } return(response); }
public TouristAttractions.model.AgencyUser SearchAgencyUserByUserNameAndPassword(string userName, string password) { AgencyUser agencyUser = server.SearchAgencyUserByUserNameAndPassword(userName, password); return(new TouristAttractions.model.AgencyUser(agencyUser.Id, agencyUser.UserName, agencyUser.Password)); }
public AgencyUser SaveUser(AgencyUser agencyUser) { return(_agencyUserWriteRepository.Save(agencyUser)); }
internal void SetAgencyUser(AgencyUser AgencyUser) { this.AgencyUser = AgencyUser; userFillLabel.Text = AgencyUser.UserName; }