public static ProviderPortalUser ProviderPortalUser(Models.ProviderPortalUser entity, bool includeProviderMap = false)
{
var p = new ProviderPortalUser();
p.AspNetUserID = entity.AspNetUserID;
p.DateCreated = entity.DateCreated;
p.ID = entity.ID;
p.ProviderUserNumber = entity.ProviderUserNumber;
p.ProviderID = entity.ProviderID;
if (includeProviderMap)
{
p.Provider = ProviderMappings.Provider(entity.Provider);
}
p.HasAppAccess = entity.ProviderHasAppAccess;
return(p);
}
public void RegisterProvider(Models.ProviderPortal.RegisterVM model)
{
var ppu = new ProviderPortalUser();
var hashedPass = System.Web.Helpers.Crypto.HashPassword(model.Password);
int aspNetId = 0;
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ProviderPortalConnection"].ConnectionString))
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO dbo.UserProfile (UserName) VALUES (@UserName);";
cmd.Parameters.AddWithValue("@UserName", model.ProviderNumber);
aspNetId = cmd.InsertToIdentity();
cmd.CommandText = "INSERT INTO dbo.webpages_Membership (" +
"UserID, CreateDate, IsConfirmed, PasswordFailuresSinceLastSuccess, Password, PasswordChangedDate, PasswordSalt" +
") VALUES (" +
"@UserID, @CreateDate, @IsConfirmed, @PasswordFailuresSinceLastSuccess, @Password, @PasswordChangedDate, @PasswordSalt);";
cmd.Parameters.AddWithValue("@UserID", aspNetId);
cmd.Parameters.AddWithValue("@CreateDate", DateTime.Now);
cmd.Parameters.AddWithValue("@IsConfirmed", 1);
cmd.Parameters.AddWithValue("@PasswordFailuresSinceLastSuccess", 0);
cmd.Parameters.AddWithValue("@Password", hashedPass);
cmd.Parameters.AddWithValue("@PasswordChangedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@PasswordSalt", "");
cmd.ExecuteNonQueryToInt();
}
ppu.AspNetUserID = aspNetId;
ppu.ProviderID = model.ProviderID;
ppu.ProviderUserNumber = model.ProviderNumber;
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "DELETE FROM dbo.ProviderPortalUsers WHERE AspNetUserID = @AspID; INSERT INTO dbo.ProviderPortalUsers (AspNetUserID, ProviderID, ProviderUserNumber) VALUES (" +
"@AspID, @ProviderID, @UserNumber);";
cmd.Parameters.AddWithValue("@AspID", aspNetId);
cmd.Parameters.AddWithValue("@ProviderID", model.ProviderID);
cmd.Parameters.AddWithValue("@UserNumber", model.ProviderNumber);
cmd.InsertToIdentity();
}
}
