public void CanUpdateMember()
{
//first create one
var m = new Member();
m.Email = "*****@*****.**";
m.FirstName = "Emmitt";
m.LastName = "Carter";
m.HashedPassword = "******";
m.PasswordSalt = "blee";
//remove previous ones
DeleteMember(m.Email);
//persist
var repo = CreateRepository();
Assert.IsTrue(m.MemberID == 0);
repo.Save(m);
//update
Assert.AreEqual("Emmitt", m.FirstName);
m.FirstName = "Riley";
repo.Save(m);
//re-get
var m2 = repo.Find(m.MemberID);
Assert.AreEqual("Riley", m.FirstName);
}
public ServiceResponse CreateMember(Member member, string originalPassword)
{
var result = new ServiceResponse();
member.PasswordSalt = CreateSalt();
member.HashedPassword = _formsAuth.HashPasswordForStoringInConfigFile(originalPassword + member.PasswordSalt, "sha1");
_memberRepo.Save(member);
return result;
}
public void CanCreateMember()
{
var chris = new Member();
chris.Email = "*****@*****.**";
chris.FirstName = "Chris";
chris.LastName = "Carter";
chris.CreateDate = DateTime.Now;
var service = CreateSecurityService();
service.CreateMember(chris, "quickbrownfox");
}
public void CanCreateNewMember()
{
var m = new Member();
m.Email = "*****@*****.**";
m.FirstName = "Emmitt";
m.LastName = "Carter";
m.HashedPassword = "******";
m.PasswordSalt = "blee";
DeleteMember(m.Email);
var repo = CreateRepository();
repo.Save(m);
Assert.IsTrue(m.MemberID > 0);
Console.WriteLine(m.MemberID);
}
public void Save(Member member)
{
var sql = @"
if exists(select * from member where memberid=@memberid)
begin
update member set
Email=@Email,
PasswordSalt=@PasswordSalt,
HashedPassword=@HashedPassword,
FirstName=@FirstName,
LastName=@LastName
where memberid = @memberid
select @memberid as 'memberid'
end
else
begin
insert into member(
Email,
PasswordSalt,
HashedPassword,
FirstName,
LastName,
CreateDate
)values(
@Email,
@PasswordSalt,
@HashedPassword,
@FirstName,
@LastName,
getdate()
)
select scope_identity() as 'memberid'
end
";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.Add("@MemberID", SqlDbType.Int).Value = member.MemberID;
cmd.Parameters.Add("@Email", SqlDbType.VarChar, 100).Value = member.Email;
cmd.Parameters.Add("@PasswordSalt", SqlDbType.VarChar, 1000).Value = member.PasswordSalt;
cmd.Parameters.Add("@HashedPassword", SqlDbType.VarChar, 500).Value = member.HashedPassword;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 50).Value = member.FirstName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar, 50).Value = member.LastName;
member.MemberID = _helper.ExecuteScalar<int>(cmd);
}
}
public void Save(Project project, Member member)
{
Save(project, member.MemberID);
}
