public void InsertIfNotExists_Poco_AppliedInfo_False_Test() { //Just a few props as it is just to test that it runs var user = TestDataHelper.GetUserList().First(); var newUser = new InsertUser { Id = Guid.NewGuid(), Name = user.Name }; string query = null; var sessionMock = new Mock <ISession>(MockBehavior.Strict); sessionMock .Setup(s => s.ExecuteAsync(It.IsAny <BoundStatement>())) .Returns(TestHelper.DelayedTask(TestDataHelper.CreateMultipleValuesRowSet(new[] { "[applied]", "userid", "name" }, new object[] { false, newUser.Id, "existing-name" }))) .Callback <BoundStatement>(b => query = b.PreparedStatement.Cql) .Verifiable(); sessionMock .Setup(s => s.PrepareAsync(It.IsAny <string>())) .Returns <string>(cql => TestHelper.DelayedTask(GetPrepared(cql))) .Verifiable(); var mappingClient = GetMappingClient(sessionMock); //Execute var appliedInfo = mappingClient.InsertIfNotExists(newUser); sessionMock.Verify(); StringAssert.StartsWith("INSERT INTO users (", query); StringAssert.EndsWith(") IF NOT EXISTS", query); Assert.False(appliedInfo.Applied); Assert.AreEqual(newUser.Id, appliedInfo.Existing.Id); Assert.AreEqual("existing-name", appliedInfo.Existing.Name); }
public void Insert_Poco_Returns_WhenResponse_IsReceived() { var newUser = new InsertUser { Id = Guid.NewGuid(), Name = "Dummy" }; var rowsetReturned = false; var sessionMock = new Mock <ISession>(MockBehavior.Strict); sessionMock .Setup(s => s.ExecuteAsync(It.IsAny <BoundStatement>())) .Returns(TestHelper.DelayedTask(new RowSet(), 2000).ContinueWith(t => { rowsetReturned = true; return(t.Result); })) .Verifiable(); sessionMock .Setup(s => s.PrepareAsync(It.IsAny <string>())) .Returns <string>(cql => TaskHelper.ToTask(GetPrepared(cql))) .Verifiable(); var mappingClient = GetMappingClient(sessionMock); //Execute mappingClient.Insert(newUser); Assert.True(rowsetReturned); sessionMock.Verify(); }
public void Insert_Poco() { //Just a few props as it is just to test that it runs var user = TestDataHelper.GetUserList().First(); var newUser = new InsertUser { Id = Guid.NewGuid(), Name = user.Name }; var sessionMock = new Mock <ISession>(MockBehavior.Strict); sessionMock .Setup(s => s.ExecuteAsync(It.IsAny <BoundStatement>())) .Returns(TestHelper.DelayedTask(new RowSet())) .Verifiable(); sessionMock .Setup(s => s.PrepareAsync(It.IsAny <string>())) .Returns <string>(cql => TaskHelper.ToTask(GetPrepared(cql))) .Verifiable(); var mappingClient = GetMappingClient(sessionMock); //Execute mappingClient.Insert(newUser); sessionMock.Verify(s => s.ExecuteAsync(It.Is <BoundStatement>(stmt => stmt.QueryValues.Length == TestHelper.ToDictionary(newUser).Count&& stmt.PreparedStatement.Cql.StartsWith("INSERT INTO users (") )), Times.Exactly(1)); sessionMock.Verify(); }
public ActionResult SignUp(InsertUser user) { if (ModelState.IsValid && AccountDAO.CreateUser(user)) { return(RedirectToAction("Index", "Home")); } return(View()); }
//public HttpResponseMessage Put(int Id, [FromBody] User user) //{ // try // { // using (SalesForceEntities entities = new SalesForceEntities()) // { // var entity = entities.Users.FirstOrDefault(d => d.Id == Id); // if (entity == null) // { // return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with " + Id.ToString() + " not found"); // } // else // { // entity.FirstName = user.FirstName; // entity.City = user.City; // entity.ContactNo = user.ContactNo; // entity.Email = user.Email; // entity.Gender = user.Gender; // entity.Lane = user.Lane; // entity.LastName = user.LastName; // entity.NIC = user.NIC; // entity.Passwords = user.Passwords; // entity.ResidenceNo = user.ResidenceNo; // entity.Username = user.Username; // entity.UserType = user.UserType; // entities.SaveChanges(); // return Request.CreateResponse(HttpStatusCode.OK, entity); // } // } // } // catch (Exception ex) // { // return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex); // } public void Put([FromBody] InsertUser adduser) { using (SalesForceEntities entities = new SalesForceEntities()) { entities.UpdateUser(adduser.Id, adduser.NIC, adduser.Username, adduser.Passwords, adduser.FirstName, adduser.LastName, adduser.ResidenceNo, adduser.Lane, adduser.City, adduser.ContactNo, adduser.Email, adduser.UserType, adduser.Gender); entities.SaveChanges(); } }
public object Post(InsertUser request) { var entity = request.ConvertTo <User>(); return(InTransaction(db => { Logic.Add(entity); return new CommonResponse(Logic.GetById(entity.Id)); })); }
// GET: Create public ActionResult Create() { var items = new InsertUser(); items.Roles = _roleManager.Roles.Select(x => new CheckBoxItem { Id = x.Id, Text = x.Name, Checked = false }).ToList(); return(View(items)); }
protected void Button1_Click(object sender, EventArgs e) { InsertUser u = new InsertUser(); u.Name = TextBox1.Text; u.Email = TextBox2.Text; string r = client.Insert(u); lblmsg.Text = r.ToString(); }
private static void RunDemo(SqlConnection connection) { var selectStudent = new SelectStudent(); var insertStudent = new InsertUser(); var deleteStudent = new DeleteUser(); var elev = new Student { Name = "", Path = "[dbo].[Student]" }; Console.Write("You can Delete, Insert, Update or Select a user {Template: [Command] [User]}: "); var input = Console.ReadLine(); if (!string.IsNullOrEmpty(input)) { var command = input.Split(' '); switch (command[0].ToLower()) { case "delete": elev.Name = command[1]; deleteStudent.DeleteUser(connection, elev.Name, elev.Path); Console.WriteLine($"Deleting user {elev.Name}..."); break; case "insert": elev.Name = command[1]; insertStudent.AddUser(connection, elev.Name, elev.Path); Console.WriteLine($"Creating new user {elev.Name}..."); break; case "update": break; case "select": break; default: Console.WriteLine("Invalid input, please try again..." + Environment.NewLine); break; } } else { Console.WriteLine("Invalid input, please try again..." + Environment.NewLine); } Console.WriteLine("Outputting list of all students: "); var students = selectStudent.GetAllStudents(connection); foreach (var student in students) { Console.WriteLine(student); } }
public IActionResult OnBoardNewUser([FromBody] InsertUser requestedUser) { if (ModelState.IsValid) { //Call Lambda return(Ok($"Successfully created new user: {requestedUser.UserName}")); } return(BadRequest(ModelState)); }
protected void BtInsert_Click(object sender, EventArgs e) { InsertUser user = new InsertUser(); user.Name = TextBox1.Text; user.Email = TextBox2.Text; string result = client.Insert(user); lblMsg.Text = result; }
// [Authorize(Roles = Role.Clinician + "," + Role.OfficeAdmin + "," + Role.SuperAdmin)] public async Task <ActionResult <int> > InsertUser(InsertUser user) { try { //cast InsertUser into User object. return(await _userRepository.InsertUser((User)user)); } catch (Exception) { return(StatusCode(500, "Internal Server Error")); } }
public async Task <IActionResult> InsertUser([FromBody] InsertUser request) { string userGuid = HttpContext.Request.Headers["UserGuid"]; UserLogic userLogic = new UserLogic(); await userLogic.InsertUser(request, userGuid); if (userLogic.Response.IsSuccessful == false) { return(BadRequest(userLogic.Response.ErrorMessage)); } return(Ok("Success")); }
public async Task <JsonResult> Register([FromBody] CreateUser model) { try { var collForInserting = _database.GetCollection <InsertUser>("users"); var collForReading = _database.GetCollection <ReadUser>("users"); model.Email = model.Email.ToLower(); var user = new InsertUser() { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Type = 0, Password = model.Password }; //checking if the user already exists. var isAlreadyPresent = collForReading.AsQueryable().Any(x => x.Email == model.Email); if (isAlreadyPresent) { return(Json(new { Error = 0, Message = "Sorry, the email has already been used. Please use the procedure to retrieve your password instead" }.ToJson(jsonWriterSettings))); } String salt = String.Empty; user.Password = AuthHelper.EncryptPassword(user.Password, out salt); user.Salt = salt; if (temporaryUsers.ContainsKey(model.Email)) { temporaryUsers.Remove(model.Email); } temporaryUsers.Add(model.Email, user); var randomCode = Randomizer.RandomString(5); var body = await _renderService.RenderToStringAsync("EmailTemplates/ConfirmEmail", new ConfirmEmailViewModel() { Name = user.FirstName, Code = randomCode }); await Task.Run(() => _emailHelper.SendEmail("The Curious Carrot - Verify Your Email", "*****@*****.**", user.Email, body)); return(Json(new { Error = 0, GeneratedCode = randomCode }.ToJson(jsonWriterSettings))); } catch (Exception ex) { return(Json(ex.RaiseException())); } }
private void Initialiser() { addUser = new InsertUser(); user = new List <DbUser>(); user.Add(new DbUser()); user[0].Username = "******"; user[0].Password = "******"; user[0].FirstName = "Thomas"; user[0].LastName = "Shore"; user[0].Email = "*****@*****.**"; user[0].Location = "Manchester"; user[0].TypeId = 3; user.Add(new DbUser()); }
private void Initialiser() { addUser = new InsertUser(); user = new List<DbUser>(); user.Add(new DbUser()); user[0].Username = "******"; user[0].Password = "******"; user[0].FirstName = "Thomas"; user[0].LastName = "Shore"; user[0].Email = "*****@*****.**"; user[0].Location = "Manchester"; user[0].TypeId = 3; user.Add(new DbUser()); }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text.Equals("") || TextBox1.Text.Equals("")) { lblMsg.Text = "Sorry, Column can't Empty!!!"; } else { InsertUser u = new InsertUser(); u.Name = TextBox1.Text; u.Email = TextBox2.Text; string r = client.Insert(u); lblMsg.Text = r.ToString(); } }
public async Task InsertUser(InsertUser request, string guid) { Response.IsSuccessful = true; // validate request if (request.AdminId == 0 || string.IsNullOrEmpty(guid)) { Response.IsSuccessful = false; Response.ErrorMessage = "you must provide Admin Id and guid "; return; } // get user by guid and validate permisions User user = await userCRUDService.GetByUserGuid(guid); if (user == null || user?.UserId != request.AdminId) { Response.IsSuccessful = false; Response.ErrorMessage = "Ilegale operation"; return; } User userToCreate = new User() { UserId = 0, UserName = request.UserName, HashedPassword = null, UserGuid = Guid.NewGuid().ToString("N"), IsSetPasswordAllowed = true, SaltPassword = null, IsAdmin = request.IsAdmin, CreationDate = DateTime.UtcNow, FirstName = request.FirstName, LastName = request.LastName, AdminId = user.UserId, Phone = request.Phone, SlackWebHook = request.SlackWebHook }; //insert user if (!await userCRUDService.InsertUser(userToCreate)) { Response.IsSuccessful = false; Response.ErrorMessage = "Cannot Insert User"; return; } }
protected void btInsert_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=DESKTOP-KT69I3S;Initial Catalog=WCFService;Persist Security Info=True;User ID=sa;Password=ifan99"); con.Open(); InsertUser u = new InsertUser(); u.Name = TextBoxName.Text; u.Email = TextBoxEmail.Text; string r = client.Insert(u); lblmsgInsert.Text = r.ToString(); con.Close(); TextBoxID.Text = ""; TextBoxName.Text = ""; TextBoxEmail.Text = ""; }
public ContentResult SignUpUser(UserModel user) { if (ModelState.IsValid) { InsertUser.Insert(user); return(new ContentResult { StatusCode = (int)HttpStatusCode.OK }); } else { return(new ContentResult { StatusCode = (int)HttpStatusCode.InternalServerError }); } }
public HttpResponseMessage Post([FromBody] InsertUser addusers) { try { using (SalesForceEntities entities = new SalesForceEntities()) { entities.CreateUser(addusers.NIC, addusers.Username, addusers.Passwords, addusers.FirstName, addusers.LastName, addusers.ResidenceNo, addusers.Lane, addusers.City, addusers.ContactNo, addusers.Email, addusers.Gender, addusers.UserType); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, addusers); // message.Headers.Location = new Uri(Request.RequestUri + InsertUser.Id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
public async Task <IActionResult> InsertUser([FromBody] InsertUser user) { var entity = new User() { FirstName = user.FirstName, LastName = user.LastName, Email = user.Email, IsActive = user.IsActive, IsInternalUser = user.IsInternalUser, }; entity.InvitationUrl = !user.IsInternalUser ? _invitationUrl.CreateInvittionUrl(entity) : string.Empty; _context.User.Add(entity); await _context.SaveChangesAsync(new CancellationToken()); return(Ok()); }
public void Execute_MixedBatch_Test() { // Generate test user const int idx = 20; var testUser = new InsertUser { Id = Guid.NewGuid(), Name = string.Format("Name {0}", idx), Age = idx, CreatedDate = TestDataGenerator.GetDateTimeInPast(idx), IsActive = idx % 2 == 0, LastLoginDate = TestDataGenerator.GetNullableDateTimeInPast(idx), LoginHistory = TestDataGenerator.GetList(idx, TestDataGenerator.GetDateTimeInPast), LuckyNumbers = TestDataGenerator.GetSet(idx, i => i), FavoriteColor = TestDataGenerator.GetEnumValue <RainbowColor>(idx), TypeOfUser = TestDataGenerator.GetEnumValue <UserType?>(idx), PreferredContact = TestDataGenerator.GetEnumValue <ContactMethod>(idx), HairColor = TestDataGenerator.GetEnumValue <HairColor>(idx) }; // Get id of existing user for deleting and updating Guid deleteId = Guid.NewGuid(); Guid updateId = Guid.NewGuid(); // Create batch of mixed statements and execute var mapper = GetMapper(() => TestHelper.DelayedTask(new RowSet())); ICqlBatch batch = mapper.CreateBatch(); batch.Insert(testUser); batch.Delete <InsertUser>("WHERE userid = ?", deleteId); batch.Update <InsertUser>("SET name = ? WHERE userid = ?", "SomeNewName", updateId); var queries = batch.Statements.Select(cql => cql.Statement).ToArray(); Assert.AreEqual(3, queries.Length); Assert.AreEqual("INSERT INTO users (userid, Name, Age, CreatedDate, IsActive, " + "LastLoginDate, LoginHistory, LuckyNumbers, ChildrenAges, " + "FavoriteColor, TypeOfUser, preferredcontactmethod, HairColor) VALUES " + "(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", queries[0]); Assert.AreEqual("DELETE FROM users WHERE userid = ?", queries[1]); Assert.AreEqual("UPDATE users SET name = ? WHERE userid = ?", queries[2]); mapper.Execute(batch); }
public void InsertAsync_Poco() { // Get a "new" user by using the test data from an existing user and changing the primary key var user = TestDataHelper.GetUserList().First(); var newUser = new InsertUser { Id = Guid.NewGuid(), Name = user.Name, Age = user.Age, CreatedDate = user.CreatedDate, IsActive = user.IsActive, LastLoginDate = user.LastLoginDate, LoginHistory = user.LoginHistory, LuckyNumbers = user.LuckyNumbers, ChildrenAges = new Dictionary <string, int>(user.ChildrenAges), FavoriteColor = user.FavoriteColor, TypeOfUser = user.TypeOfUser, PreferredContact = user.PreferredContactMethod, HairColor = user.HairColor }; var sessionMock = new Mock <ISession>(MockBehavior.Strict); sessionMock.Setup(s => s.Keyspace).Returns <string>(null); sessionMock .Setup(s => s.ExecuteAsync(It.IsAny <BoundStatement>(), It.IsAny <string>())) .Returns(TaskHelper.ToTask(new RowSet())) .Verifiable(); sessionMock .Setup(s => s.PrepareAsync(It.IsAny <string>())) .Returns <string>(cql => TaskHelper.ToTask(GetPrepared(cql))) .Verifiable(); var mappingClient = GetMappingClient(sessionMock); //Execute Insert and wait mappingClient.InsertAsync(newUser).Wait(3000); sessionMock.Verify(s => s.ExecuteAsync(It.Is <BoundStatement>(stmt => stmt.QueryValues.Length == TestHelper.ToDictionary(newUser).Count&& stmt.PreparedStatement.Cql.StartsWith("INSERT INTO users (") ), It.IsAny <string>()), Times.Exactly(1)); sessionMock.Verify(); }
public ActionResult Create(User user) { User user1 = new User(); user1.BirthDate = DateTime.Now; user1.Email = "teste@teste"; user1.Gender = "Male"; user1.Name = "Nome teste"; try { InsertUser insert = new InsertUser(); insert.Inserir(user1); return(RedirectToAction(nameof(User))); } catch { return(View()); } }
public void TestInsert() { // Arrange var newUser = new InsertUser { Name = "User1", }; var newGuidUserId = Guid.NewGuid(); var newGuidUser = new InsertGuidUser { Id = newGuidUserId, Name = "GuidUser1" }; // Act Connection.Insert(newUser); Connection.Insert(newGuidUser); // Assert Assert.True(Connection.Any <InsertUser>(p => p.Name == "User1")); Assert.True(Connection.Any <InsertGuidUser>(p => p.Id == newGuidUserId)); }
public async Task TestInsertAsync() { // Arrange var newUser = new InsertUser { Name = "User2", }; var newGuidUserId = Guid.NewGuid(); var newGuidUser = new InsertGuidUser { Id = newGuidUserId, Name = "GuidUser2" }; // Act await Connection.InsertAsync(newUser); await Connection.InsertAsync(newGuidUser); // Assert Assert.True(await Connection.AnyAsync <InsertUser>(p => p.Name == "User2")); Assert.True(await Connection.AnyAsync <InsertGuidUser>(p => p.Id == newGuidUserId)); }
public ActionResult Create([Bind(Include = "Email,Password,ConfirmPassword")] InsertUser currentUser, string[] Roles) { var user = new ApplicationUser { Email = currentUser.Email, UserName = currentUser.Email }; var result = UserManager.Create(user, currentUser.Password); if (result.Succeeded) { var currentRole = new IdentityRole(); if (Roles != null) { string[] roleNames = _roleManager.Roles.Where(x => Roles.Contains(x.Id)).Select(x => x.Name).ToArray(); UserManager.AddToRoles(user.Id, roleNames); } return(RedirectToAction("Index")); } ModelState.AddModelError("", result.Errors.FirstOrDefault()); currentUser.Roles = _roleManager.Roles.Select(x => new CheckBoxItem { Id = x.Id, Text = x.Name, Checked = false }).ToList(); return(View(currentUser)); }
private void btnSubmit_Click(object sender, RoutedEventArgs e) { firstName = txtFirstname.Text; lastName = txtLastname.Text; username = txtUsername.Text; InsertUser user = new InsertUser(); user.FirstName = txtFirstname.Text; user.LastName = txtLastname.Text; user.UserPassword = txtPassword.Password; user.Email = txtEmail.Text; user.Gender = toggleGender.Content.ToString(); user.UserName = txtUsername.Text; if (toggleAdmin.Content.ToString() == "Yes") { isAdmin = 1; } else { isAdmin = 0; } user.IsAdmin = isAdmin; string response = client.AddUser(user); client.Close(); dummyLabel.Content = response; if (response == "Successfully Inserted") { this.NavigationService.Navigate(new SignIn()); } }
public bool InsertUser(List<DbUser> user, int stream_id) { InsertUser insUser = new InsertUser(); return insUser.GetCommand(user, stream_id); }
static void Main(string[] args) { Console.WriteLine("Main Menu \r\n \r\n User Operations: \r\n 0. See Registered Users \r\n 1. Register User \r\n 2. Update User \r\n "); Console.WriteLine("Physical Address Operations: \r\n 3. Enter User Physical Address \r\n 4. Update User Physical Address \r\n "); Console.WriteLine("Postal Address Operations: \r\n 5. Enter User Postal Address \r\n 6. Update User Postal Address \r\n "); Console.WriteLine("User Approval Operations: \r\n 7. Press 1 to Approve User"); Console.WriteLine("User Deletion Operations: \r\n 8. Press 1 to Delete User"); //Object in use by 2---Methods as Parameter ,thats why is Glabol var user = new _User(); var physical = new Physical_Address(); var postal = new Postal_Address(); int option = Convert.ToInt32(Console.ReadLine()); switch (option) { case 0: var objSelectUser = new SelectUser(); objSelectUser.RetrieveUser(); break; case 1: var objInsertUser = new InsertUser(); objInsertUser.EnterUserDetails(user); Console.WriteLine("would you like to add your physical address: Y/N"); string value = Console.ReadLine(); string lower = value.ToLower(); if (lower == "y") { var objaddressOption = new InsertPhysical(); objaddressOption.EnterPhysicalAddressDetails(physical); } else if (lower == "n") { Console.WriteLine("Thank you"); } break; case 2: var objUpdateUser = new UpdateUser(); objUpdateUser.EnterUpdateUserDetails(user); break; case 3: var objInsertPhysical = new InsertPhysical(); objInsertPhysical.EnterPhysicalAddressDetails(physical); break; case 4: var objUpdatePhysical = new UpdatePhysical(); objUpdatePhysical.EnterPhysicalUpdateDetails(physical); break; case 5: var objInsertPostal = new InsertPostal(); objInsertPostal.EnterPostalAddressDetails(postal); break; case 6: var objUpdatePostal = new UpdatePostal(); objUpdatePostal.EnterPostalUpdateDetails(postal); break; case 7: var objUpdateApprovalStatus = new UpdateApprovalStatus(); objUpdateApprovalStatus.EnterUpdateStatus(); break; case 8: var objSoftDeleteUser = new DeleteUser(); objSoftDeleteUser.UserIdToDelete(); break; default: Console.WriteLine("Opps! Invalid option entered. Retry"); Console.ReadKey(); break; } }