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