public static PosCredential ToPosCredential(this CredentialModel credential)
{
var posCredential = new PosCredential()
{
EmailAddress = credential.EmailAddress,
UserName = credential.UserName,
Password = credential.Password
};
return(posCredential);
}
public bool Register(PosCredential credential)
{
var posCredential = GetUser(credential.EmailAddress);
if (posCredential != null)
{
throw new CommonException(ExceptionCodes.UserExisted);
}
DBHelper.ExecuteNonQuery("insert into [user]([nick_name], [email_address], [password]) values(@nick_name, @email_address, @password)", new[] { credential.UserName, credential.EmailAddress, credential.Password });
return(true);
}
public PosCredential Login(PosCredential credential)
{
var posCredential = GetUser(credential.EmailAddress);
if (posCredential == null || posCredential.Password != credential.Password)
{
throw new CommonException(ExceptionCodes.CanNotFoundUser);
}
posCredential.Password = null;
return(posCredential);
}
public PosCredential GetUser(string emailAddress)
{
return(DBHelper.ExecuteDataReader <PosCredential>("select * from [user] where email_address = @email_address", new[] { emailAddress }, (reader) =>
{
while (reader.Read())
{
var tempCredential = new PosCredential();
tempCredential.UserName = reader.GetString("nick_name");
tempCredential.EmailAddress = reader.GetString("email_address");
tempCredential.Password = reader.GetString("password");
return tempCredential;
}
return null;
}));
}
