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